Desenvolvimento de uma planilha interativa para o cálculo da capacidade de carga e da tensão admissível de sapatas isoladas

Abstract

The design of isolated footings requires the determination of the bearing capacity and allowable stress of the soil using theoretical and semi-empirical methods based on the SPT test. The manual application of these procedures can be repetitive and subject to simplifications, especially in the definition of the pressure bulb and the calculation of the average NSPT. This paper presents the development of an interactive spreadsheet in Microsoft Excel to automate these calculations, integrating classical methods and national formulations. The tool was validated by exercises from the literature, presenting consistent results and accuracy in the calculation of the average NSPT. It is concluded that the spreadsheet is suitable for supporting the teaching and practice of shallow foundation design