The use of computer tools to solve calculations in any area of study is essential to reduce the time spent to perform them, resulting in the investment of time in the analysis of the problem for a number "n" of solutions to the problem proposed, being able to perform multiple iterations to reach an optimal result. The objective of this article is to use one of the simplest computer tools, such as Microsoft Excel, to create a Visual Basic code 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 assembled structure from the stiffness matrix of each element, the embedding forces matrix, the nodal forces matrix, and the displacements matrix of each node. Each of the matrices is displayed in a spreadsheet, so that for academic purposes, the user will be able to visualize each of the matrices.
|Translated title of the contribution||Using Macros In Microsoft Excel To Analyze Flat Structures|
|Original language||Spanish (Ecuador)|
|Journal||Revista Internacional De Ingeniería De Estructuras|
|State||Published - 8 Mar 2019|