Uso De Macros En Microsoft Excel Para Analizar Estructuras Planas

Translated title of the contribution: Using Macros In Microsoft Excel To Analyze Flat Structures

Research output: Contribution to journalArticlepeer-review

Abstract

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 contributionUsing Macros In Microsoft Excel To Analyze Flat Structures
Original languageSpanish (Ecuador)
Pages (from-to)123
JournalRevista Internacional De Ingeniería De Estructuras
Volume24
Issue number1
DOIs
StatePublished - 8 Mar 2019

Fingerprint Dive into the research topics of 'Using Macros In Microsoft Excel To Analyze Flat Structures'. Together they form a unique fingerprint.

Cite this