Uso de Macros en Microsoft Excel para Analizar Estructuras Planas

The use of computer tools to solve calculations in any area of study is essential to reduce the time spent performing them, leading to the investment of time in the analysis of the problem for a number "n" of solutions to the proposed problem, being able to perform iterations multiple until reaching an optimal result. The objective of this article is to use one of the simplest computer tools, such as the Microsoft Excel program, to create a code in Visual Basic that allows the resolution of flat structures, subject to shear forces, axial forces and bending moments, thus calculating the reactions and displacements in the nodes of the structure. The macro was based on the analysis of structures with the direct stiffness method, where codes were created to obtain the stiffness matrix of each element, the global stiffness matrix of the structure assembled from the stiffness matrix of each element, the matrix of embeddingforces, the matrix of nodal forces, and the matrix of displacements of each node. Each of the matrices are displayed in a spreadsheet, so that for academic purposes, the user can view each of the matrices.