Monitoramento remoto do consumo de água em agências bancárias utilizando gráficos de controle estatístico

Lucas Lepinski Golin Freitas; Andreza Kalbusch; Elisa Henning; Marcio Ferreira de Lima

doi:10.18830/1679-09442025v18e53504

Authors

Lucas Lepinski Golin Freitas Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Engenharia Civil https://orcid.org/0000-0001-9188-8874
Andreza Kalbusch Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Engenharia Civil https://orcid.org/0000-0002-4770-1758
Elisa Henning Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Matemática. https://orcid.org/0000-0002-7754-9451
Marcio Ferreira de Lima Caixa Econômica Federal; Vice-presidência de Logística; Gerência Executiva de Engenharia e Arquitetura https://orcid.org/0000-0002-1179-135X

DOI:

https://doi.org/10.18830/1679-09442025v18e53504

Keywords:

Statistical control charts, Water consumption, Remote monitoring, Sustainability, Public buildings, Statistical monitoring

Abstract

The aim of this work was to analyze the performance of two distinct types of statistical control charts, Shewhart and EWMA, when used to monitor water consumption in bank branches located in southern Brazil. The control charts were used in an attempt to detect unusual events that happened during the data collection period, ranging from 10/31/2018 to 11/03/2019. Three bank branches, located in the municipalities of Joinville, Criciúma and Curitiba were selected for this analysis. The Joinville’s branch daily water consumption averages found were 4.51m³/day, 81.82 L/employee/day, 11.14 L/service/day and 1.47L/m²/day. For the Criciúma’s branch the averages found were 4.18m³/day, 34.73 L/employee/day, 21.02/L/service/day and 1.27L/m²/day. After the replacement of all the drive mechanisms of the discharge valves, the consumption was reduced to 2.48 m³/day, totaling a saving of 298.69 m³. Finally, for Curitiba’s branch the averages found were 0.61m³/day, 34.69L/employee/day, 1.98L/service/day and 0.29L/m²/day. Both charts displayed an acceptable performance for detecting leakages, excessive water consumption and other unusual events. Furthermore, the EWMA chart displayed an improved performance for detecting small variations

Author Biographies

Lucas Lepinski Golin Freitas, Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Engenharia Civil

Civil Engineer from the State University of Santa Catarina (2020), scholarship holder from the Foundation for Research and Innovation Support of the State of Santa Catarina - FAPESC (2019), works on research into the use of statistical control charts to monitor water consumption in buildings. He is currently a project manager and dimensioning of metal structures.
Andreza Kalbusch, Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Engenharia Civil

PhD in Civil Engineering from the Federal University of Santa Catarina (2011), Master in Civil Engineering from the University of São Paulo (2006), with a degree in Civil Engineering from the State University of Santa Catarina (2001). She is currently a professor in the Department of Civil Engineering at the State University of Santa Catarina, a CNPq Research Productivity Fellow and coordinator of the Building Systems Working Group of the National Association of Built Environment Technology. Her research topics are water conservation, building systems performance and water consumption in the built environment and water consumption in the urban environment.
Elisa Henning, Universidade do Estado de Santa Catarina; Centro de Ciências Tecnológicas; Departamento de Matemática.

She holds a degree in Civil Engineering from the State University of Santa Catarina (1992), a master's degree in Environmental Engineering from the Federal University of Santa Catarina (1998), a specialization in Mathematics and Statistics from the Federal University of Lavras (2005), a specialization in Data Science and Artificial Intelligence from the Pontifical Catholic University of Rio Grande do Sul (2024), a master's degree in Statistics from the Open University of Portugal (2014) and a PhD in Production Engineering from the Federal University of Santa Catarina (2010). He is currently a tenured professor at the State University of Santa Catarina and a CNPq Research Productivity Scholarship Holder - Level 2. He develops research in the area of Statistics Applied to Engineering, namely Sustainable Development in Civil Construction and Statistical Methods for Research in Education.
Marcio Ferreira de Lima, Caixa Econômica Federal; Vice-presidência de Logística; Gerência Executiva de Engenharia e Arquitetura

He holds a Master's degree in Urban and Industrial Environment from the Federal University of Paraná (UFPR) and Universität Stuttgart, Germany (2017), a specialization in Sustainable Projects and Climate Change from UFPR (2014) and a degree in Civil Production Engineering from the Federal Technological University of Paraná (UTFPR) in 2005. He has been a Civil Engineer on the professional staff of Caixa Econômica Federal since 2007. At the National Infrastructure Management, he works on engineering works, maintenance of building facilities and management of water and energy consumption of CAIXA properties. He participates in research on water meters with telemetry (smart meters), the Internet of Things (IoT) and statistical control of water consumption processes.

References

ABNT - Associação Brasileira de Normas Técnicas. NBR 5626: Sistemas prediais de água fria e quente – Projeto, execução, operação e manutenção. Rio de Janeiro, 2020.

BRITTON, T.; COLE, G.; STEWART, R.; WISKAR, D. Remote Diagnosis of leakage in residential households. Water, Australia, v. 35, n. 6, p. 56-60, 2009.

CLARO, F. A. E.; COSTA, A. F. B.; MACHADO, M. A. G. Gráficos de controle de EWMA e de Xbar para monitoramento de processos autocorrelacionados. Produção, v. 17, n. 3, p. 536-546, 2007.

COMINOLA, A.; GIULIANI, M.; PIGA, D.; CASTELLETTI, A.; RIZZOLI, A. E. Benefits and challenges of using smart meters for advancing residential water demand modeling and management: A review, Environmental Modelling & Software, v. 72, p. 198-214, 2015.

COSGROVE, W. J.; LOUCKS, D. P. Water management: Current and future challenges and research directions, Water Resour. Res., v. 51, p. 4823– 4839, 2015.

FREITAS, L. L. G.; HENNING, E.; KALBUSCH, A.; KONRATH, A. C.; WALTER, O. F. C. Analysis of water consumption in toilets employing Shewhart, EWMA, and Shewhart-EWMA combined control charts. J. Clean. Prod., Brasil, v. 233, p. 1146-1157, 2019.

HACKBARTH, FRANCISCO BARBOSA; KALBUSCH, ANDREZA; HENNING, ELISA; NASCIMENTO, MARIA IZABEL DO; BRUHN, ANA LUÍZA. Water Consumption Modeling in Office Buildings: A Case Study in Southern Brazil. JOURNAL OF WATER RESOURCES PLANNING AND MANAGEMENT, v. 149, p. 1-13, 2023. https://doi.org/10.1061/JWRMD5.WRENG-5850

KIM, Y.; SCHMID, T.; CHARBIWALA, Z. M.; FRIEDMAN, J.; SRIVASTAVA, M. B.; NAWMS: Nonintrusive autonomous water monitoring system. In: 6 ed. ASSOCIATION FOR COMPUTING MACHINERY - ACM CONFERENCE ON EMBEDDED NETWORK SENSOR SYSTEMS, 2008, Nova York. Anais Eletrônicos.

MONTGOMERY, Douglas C.; RUNGER, George C. Applied Statistics and Probability for Engineers. 3. ed. Estados Unidos da América: John Wiley & Sons. 2003.

MONTGOMERY, D. C. (2012). Introduction to Statistical Quality Control. 7. ed. Estados Unidos da América: John Wiley & Sons. 2012.

QIU, P. Introduction to statistical process control. Estados Unidos da America, Universidade da Florida: Chapman and Hall/CRC. 2014. Disponível em: https://www.routledge.com/Introduction-to-Statistical-Process-Control/Qiu/p/book/9781439847992. Acesso em: 10 dez. 2020.

R CORE TEAM. A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria, 2023. Disponível em: https://cran.r-project.org/bin/windows/. Acesso em 07. mar. 2023.

ROBERTS, S.W. Control Charts Tests Based on Geometric Moving Averages. Technometrics, Reino Unido, v. 42, p. 97-101, 2000. Disponível em: https://www.jstor.org/stable/1271439?seq=1#metadata_info_tab_contents. Acesso em: 19 mai. 2019.

SCRUCCA, L. qcc: An R package for quality control charting and statistical process control. R News 4/1, 11-17. 2004.

SHAMSUZZAMAN, M.; KHOO, M. B. C.; HARIDY, S.; ALSYOUF, I. An optimization design of the combined Shewhart-EWMA control chart. The International Journal of Advanced Manufacturing Technology, Londres, v. 86, p. 1627-1637, 2016.

VASCONCELLOS, Bruna T. C.; FILHO, Geraldo L. T.; BONATTO, Benedito D.; DE SOUZA JUNIOR, Oswaldo H. Applying an Exponentially Weighted Moving Average control chart using flow history and assured energy levels to small hydroelectric power plants, Brazilian Journal of Water Resources, Brasil, v. 25, 2020. https://doi.org/10.1590/2318-0331.252020190159.

WAN, Xi; FARMANI, Raziyeh; KEEDWELL, Edward. Online leakage detection system based on EWMA-enhanced - Tukey method for water distribution systems, Hydroinformatics, Reino Unido, v. 25, n. 1, p. 51-69, 2022. https://doi.org/10.1590/2318-0331.252020190159.