Desenvolvimento de uma planilha eletrônica em VBA para o dimensionamento didático de instalações de recalque de água

This study aims to develop a computer program based on VBA programming language, using Microsoft Excel, for designing pumping systems of water. The program allows the user to determine the economical diameter, using the equation of Bresse, for a given installation, since the geometric elevation, the material of the tube, the accessories along the line and the volumetric flow are known. In addition, the program estimates the total annual cost of the installation for three different diameters, in order to compare which diameter is more advantageous from an economical perspective. The program interface is designed to be simple and intuitive with the intention of being didactic and offering to engineering students an advantageous tool to analyze this type of project. Microsoft Excel was chosen for this work because is present in virtually all personal computer, and is an indispensable tool for educational purposes

Diagnóstico e proposição de medidas para o controle das perdas de água no sistema de abastecimento de Guaratinguetá

Over the past two years, Brazil has been facing a major water crisis in its history and the state of Sao Paulo is the one that has been going through worst difficulties. In this scenario, all water users should do everything possible so that the consumption of water resources is carried out in a sustainable manner. In this context, the companies responsible for the public water supply must increase the efficiency of water resource management. It is indispensable combating losses in the public supply system. When there is a non-visible leak in a pipe, the wastewater volume can be high, but in this case, the water returns to nature and continues to participate in the hydrological cycle. The economic loss corresponds to the value added to the product water, which includes the intrinsic costs of exploration, processing and distribution. This damage results in a reduced availability of financial resources of sanitation companies to invest in environmentally friendly solutions. This study aimed to diagnose the water distribution system in the city of Guaratinguetá (SP), held by the Companhia de Serviços de Água, Esgoto e Resíduos de Guaratinguetá (SAEG), to propose measures to combat water loss. Among the proposed measures, there is the monitoring of losses, planning for replacement of old pipes and company awareness as a whole in relation to combat water losses