Skip to main content
SpringerLink
Log in

Analysis of Electrical Equipment at UNICAMP: Insights from the Inventory Database

  • Conference paper
  • First Online:
Energy Informatics (EI.A 2023)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 14468))

Included in the following conference series:

  • 184 Accesses

Abstract

Data plays a crucial role in understanding several problems, including those related to electrical micro, smart grids and power consumption. In addition to electrical meters, data can be sourced from different channels such as environmental conditions, user expertise, maintenance history, and inventory registries. This paper introduces a Python-based analysis tool designed to search for equipment categories that exhibit constant power consumption within the asset inventory database of the University of Campinas. The software effectively identifies and categorizes items as air conditioners, refrigerators, computers, uninterrupted power supplies and internet routers, providing detailed insights into their specific characteristics. The tool generates a comprehensive PDF report featuring item discrimination through values, charts, organized and university units. Additionally, the software incorporates identification item lists and logs, aiding in the identification of missing or mismatched data throughout the process. These reports has been utilized to establish internal guidelines for optimizing in power consumption and already help the university to improve its GreenMetric index.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 74.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Bhattarai, B.P., et al.: Big data analytics in smart grids: state-of-the-art, challenges, opportunities, and future directions. IET Smart Grid 2(2), 141–154(13) (2019), https://digital-library.theiet.org/content/journals/10.1049/iet-stg.2018.0261, publisher: Institution of Engineering and Technology

  2. Ghorbanian, M., Dolatabadi, S.H., Siano, P.: Big data issues in smart grids: a survey. IEEE Syst. J. 13(4), 4158–4168 (2019)

    Article  Google Scholar 

  3. Robbins, A.: Sed and awk Pocket Reference: Text Processing with Regular Expressions. O’Reilly Media, Inc. (2002)

    Google Scholar 

  4. Stubblebine, T.: Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and. NET. O’Reilly Media, Inc. (2007)

    Google Scholar 

  5. Brazilian Government: Law of access to public interest information (in Portuguese). http://www.planalto.gov.br/ccivil_03/_ato2011-2014/2011/lei/l12527.htm

  6. da Silva, L.C.P., et al.: Sustainable campus model at the university of campinas-brazil: an integrated living lab for renewable generation, electric mobility, energy efficiency, monitoring and energy demand management. In: Leal Filho, W., Frankenberger, F., Iglecias, P., Mülfarth, R.C.K. (eds.) Towards Green Campus Operations: Energy, Climate and Sustainable Development Initiatives at Universities, pp. 457–472. Springer (2018). https://doi.org/10.1007/978-3-319-76885-4_30

  7. DA Silva, M.K., Narvaez, D.I., de Melo, K.B., Costa, T.S., de Siqueira, T.G., Villalva, M.G.: Comparative analysis of meteorological databases and transposition models applied to photovoltaic systems. Anais da Sociedade Brasileira de Automática 1 (2019)

    Google Scholar 

  8. Puma, F.A., Cavalcante, M.M., Ugarte, L.F., Sau, R.G., de Almeida, M.C.: Assessment of loss estimation methods for distribution transformers. In: 2018 13th IEEE International Conference on Industry Applications (INDUSCON), pp. 1274–1279. IEEE (2018)

    Google Scholar 

  9. Ugarte, L.F., Sau, R.G., de Almeida, M.C.: On the performance of state estimators in distribution systems under fault conditions. In: 2018 13th IEEE International Conference on Industry Applications (INDUSCON), pp. 799–805. IEEE (2018)

    Google Scholar 

  10. Cypriano, J., Pinto, L., Machado, L., da Silva, L., Ferreira, L.: Energy management methodology for energy sustainable actions in university of campinas-brazil. In: IOP Conference Series: Earth and Environmental Science. vol. 257, p. 012034. IOP Publishing (2019)

    Google Scholar 

  11. Daniel Filipe Vieira, H.G.: Public transportation passengers accounting at university by IoT device. In: 2022 Symposium on Internet of Things (SIoT) (2022)

    Google Scholar 

  12. Van Rossum, G., Drake, F.L.: Python 3 Reference Manual. CreateSpace, Scotts Valley, CA (2009)

    Google Scholar 

  13. Brazilian Government: Brazilian National Power Conservation Program - PROCEL (in Portuguese) (1993). http://www.procelinfo.com.br/. Accessed 17 Feb 2021

  14. McKinney, W.: Data structures for statistical computing in python. In: Stéfan van der Walt, Jarrod Millman (eds.) Proceedings of the 9th Python in Science Conference, pp. 56–61 (2010)

    Google Scholar 

  15. pandas development team, T.: pandas-dev/pandas: Pandas, February 2020. https://doi.org/10.5281/zenodo.3509134

  16. Harris, C.R., et al.: Array programming with NumPy. Nature 585, 357–362 (2020)

    Google Scholar 

  17. Virtanen, P., et al.: SciPy 1.0 Contributors: SciPy 1.0: fundamental algorithms for scientific computing in python. Nature Methods 17, 261–272 (2020)

    Google Scholar 

  18. Hunter, J.D.: Matplotlib: a 2d graphics environment. Comput. Sci. Eng. 9(3), 90–95 (2007)

    Article  Google Scholar 

  19. Waskom, M., the seaborn development team: mwaskom/seaborn, September 2020. https://doi.org/10.5281/zenodo.592845

  20. CourtBouillon: WeasyPrint: the awesome document factory (2011–2021). https://www.courtbouillon.org/

  21. Numba: A High Performance Python Compiler, June 2022. https://numba.pydata.org. Accessed 28 Jun 2022

  22. Selenium, June 2022. https://www.selenium.dev. Accessed 28 Jun 2022

  23. Patil, A., Soni, M.: Hands-on Pipeline as Code with Jenkins: CI/CD Implementation for Mobile, Web, and Hybrid Applications Using Declarative Pipeline in Jenkins (English Edition). BPB PUBN (2021). https://books.google.com.br/books?id=xTYcEAAAQBAJ

  24. Unicamp Computing Center (CCUEC): Instruction 10 (in Portuguese), June 2013. https://www.ccuec.unicamp.br/ccuec/sites/default/files/tutoriais/IN_10_2013_Substituicao_IN_09_2013_Adesao_servico_EDUROAM_.pdf

  25. Unicamp advancepositions in the ranking GreenMetric 2021 (in Portuguese), December 2021. https://www.unicamp.br/unicamp/noticias/2021/12/21/unicamp-ganha-posicoes-no-ranking-greenmetric-2021. Accessed 28 June 2022

Download references

Acknowledgements

to Research Foundation of the State of São Paulo (FAPESP) for their support through grants #2020/16635-9 and #2021/11380-5. The author also acknowledges the Interdisciplinary Research Activities in Electric Smart Grids (LabREI) of UNICAMP, funded by FAPESP #2016/08645-9, which provided the necessary computational infrastructure for processing the data presented in this paper. Gratitude are extended to the team of the General Directorate of Administration of Unicamp (DGA-UNICAMP) for their valuable contributions in provision of useful information about the data and to the project Sustainable Campus of UNICAMP support group for their efforts in verifying data generated by the software, ensuring its accuracy.

Author information

Authors and Affiliations

  1. São Paulo State University, São João da Boa Vista, São Paulo, Brazil

    Hildo Guillardi Júnior

Authors
  1. Hildo Guillardi Júnior
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Hildo Guillardi Júnior .

Editor information

Editors and Affiliations

  1. University of Southern Denmark, Odense, Denmark

    Bo Nørregaard Jørgensen

  2. University of Campinas, Campinas, São Paulo, Brazil

    Luiz Carlos Pereira da Silva

  3. University of Southern Denmark, Odense, Denmark

    Zheng Ma

Rights and permissions

Reprints and permissions

Copyright information

© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Guillardi Júnior, H. (2024). Analysis of Electrical Equipment at UNICAMP: Insights from the Inventory Database. In: Jørgensen, B.N., da Silva, L.C.P., Ma, Z. (eds) Energy Informatics. EI.A 2023. Lecture Notes in Computer Science, vol 14468. Springer, Cham. https://doi.org/10.1007/978-3-031-48652-4_14

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-48652-4_14

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-48651-7

  • Online ISBN: 978-3-031-48652-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation