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

Author(s)

Guillardi Junior, Hildo ; de Castro, Marcelo Stehling

• Document type: Journal article
• Source: ENERGY INFORMATICS, EI.A 2023, PT II; v. 14468, p. 13-pg., 2024-01-01.

Abstract

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)

• FAPESP's process: 20/16635-9 - Energy management in distribution networks through the concept of virtual power plants
• Grantee: Hildo Guillardi Júnior
• Support Opportunities: Scholarships in Brazil - Post-Doctoral
• FAPESP's process: 21/11380-5 - CPTEn - São Paulo Center for the Study of Energy Transition
• Grantee: Luiz Carlos Pereira da Silva
• Support Opportunities: Research Grants - Science Centers for Development
• FAPESP's process: 23/11784-4 - Energy Informatics.Academy Conference 2023 (EI.A 2023)
• Grantee: Hildo Guillardi Júnior
• Support Opportunities: Research Grants - Meeting - Brazil