Abstract
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.
Translated title of the contribution | Using Macros in Microsoft Excel to Analyze Planar Structures |
---|---|
Original language | Spanish (Ecuador) |
Pages (from-to) | 123-139 |
Number of pages | 17 |
Journal | Revista Internacional De Ingeniería De Estructuras |
Volume | 24 |
Issue number | 24 |
DOIs | |
State | Published - 30 Apr 2019 |
Keywords
- Excel macros
- Flat structures
- Rigidity matrix
- Visual basic
CACES Knowledge Areas
- 237A Construction and civil engineering