Ferramenta computacional de suporte à fiscalização de obras de sistemas de esgotamento sanitário coletivos

Abstract

The continuous growth of urban centers highlights the need to expand basic sanitation infrastructure as well as to implement efficient inspection mechanisms capable of ensuring quality, transparency, and efficiency in the use of public resources. In this context, this dissertation presents the development of the computational tool SIFIO-SES, created in a Microsoft Excel spreadsheet with Visual Basic for Applications programming, designed to support the inspection of collective sanitary sewage systems. The research identified the absence of specific solutions for this type of project and structured the tool into four main modules: (i) comparative analysis between the executive design and the budget spreadsheet, (ii) contractual and design adjustments, (iii) construction execution, and (iv) project completion. Additionally, the tool includes a “Measurements” tab, which enables the recording of construction stages, service pricing, schedule development, delay calculations, and the monitoring of the project's physical and financial progress, supported by reports and graphical representations. The results show that SIFIO-SES consolidates data, automates calculations, generates real-time indicators, and promotes greater standardization in inspection processes, establishing itself as an accessible, innovative, and effective solution. It is concluded that the tool contributes to the improvement of construction management, strengthening sustainable practices and ensuring greater administrative efficiency in the sanitation sector.