Implementação de planilha eletrônica para o cálculo de esforços e tensões em vigas

Abstract

Analysis of structures is important to verify the safety and effectiveness of projects. In this context, beams become an important structure and play a fundamental role in supporting loads and transmitting forces. To achieve this, understanding the shear force, bending moment, as well as bending and shear stresses in beams is necessary to understand the structural behavior and size the beams appropriately. This work proposes the creation of an electronic spreadsheet capable of calculating the shear force and bending moment in several sections of beams, plotting the results highlighting the maximum value of each. Furthermore, through these calculations, it is possible to determine the maximum flexural and transverse shear stress. In this way, the electronic spreadsheet was developed into an accessible tool aiming to provide a practical solution for students, where the work was developed through calculations and implementation of algorithms to obtain variables in types of beams under different load conditions and profiles. Thus, equilibrium and approximate calculations were used to solve problems with different loads on the beams, the accuracy of the spreadsheet was verified by comparing its results with theoretical analyzes and solutions found in literature reviews. Therefore, it is expected that when using this spreadsheet, students will have at their disposal a versatile and simple-to-operate tool for analyzing beams, which will contribute to the creation of safer and more effective projects in the area.