Brazilian Utilities' Invoice Data Understanding: Extraction, Data Standardization and Consumption Overview from Partner Universities

Autor(es)

Guillardi Junior, Hildo ; de Castro, Marcelo Stehling

• Tipo de documento: Artigo Científico
• Fonte: ENERGY INFORMATICS, EI.A 2023, PT II; v. 14468, p. 13-pg., 2024-01-01.

Resumo

Data plays a crucial role in understanding a scientific problem which includes those related to electrical micro, smart grids, and power consumption. In this scenario, one aspect that requires analysis is the consumption data that can be retrieve into the monthly utility invoices. However, the analysis of utility invoices in Brazil poses an unique challenge due to variations in invoice document formats across different services, utilities and contract types. This article addresses this challenge by developing a software based in Regular Expression to extract and standardized data from diverse invoice models. Through the establishment of a database and the use of a Business Intelligence platform, the retrieval and analysis of pertinent information have been significantly improved. The focus of this article is on understanding and extracting utility invoice data, including electricity, water, piped gas, and telephony services, which have direct or indirect impacts on natural resources and human well-being. The analysis is carried out on public buildings in Brazil, specifically those associated with the Sao Paulo Center for Energy Transition Studies (CPTEn). The data presented in this paper encompasses consumption invoices from three universities: the State University of Campinas (Unicamp), Sao Paulo State University campus of Sao Joao da Boa Vista (Unesp-SJBV), and the Federal University of Goias (UFG). It is important to note that all the analyzed information is publicly available under Brazilian law number 12 527 from November 18, 2011. (AU)

• Processo FAPESP: 20/16635-9 - Gerenciamento de energia elétrica em redes de distribuição através do conceito de usinas virtuais
• Beneficiário: Hildo Guillardi Júnior
• Modalidade de apoio: Bolsas no Brasil - Pós-Doutorado
• Processo FAPESP: 21/11380-5 - CPTEn - Centro Paulista de Estudos da Transição Energética
• Beneficiário: Luiz Carlos Pereira da Silva
• Modalidade de apoio: Auxílio à Pesquisa - Centros de Ciência para o Desenvolvimento
• Processo FAPESP: 23/11784-4 - Energy Informatics.Academy Conference 2023 (EI.A 2023)
• Beneficiário: Hildo Guillardi Júnior
• Modalidade de apoio: Auxílio à Pesquisa - Reunião - Brasil