Planilha eletrônica para o dimensionamento de ancoragens em tubulações sob pressão

Abstract

This work presents the development of an electronic spreadsheet, created in Excel software, aimed at the automated analysis and design of thrust blocks for pressurized pipelines in water supply systems. The development methodology included the implementation of calculation routines for cohesive and non-cohesive soils, as well as an interactive interface that generates detailed calculation results, based on the guidelines of the NBR 13211:1994 standard, which covers the design of pipeline anchorages. To validate the tool's effectiveness, a case study and a comparative analysis with Lasmar’s analytical method were conducted, demonstrating the precision of the results and adherence to current standards. The results show that the spreadsheet significantly optimizes the design process, reducing the likelihood of manual errors and providing speed in the analysis of different construction scenarios. It is concluded that the development of this tool represents a valuable resource for infrastructure engineering, promoting technical efficiency and structural safety in a practical and optimized manner.