Uso de Macros en Microsoft Excel para Analizar Estructuras Planas

Translated title of the contribution: Using Macros in Microsoft Excel to Analyze Planar Structures

Nelson Andres Lopez Machado, Juan Vielma, Leonardo López, Vanessa Viviana Montesinos Machado

Research output: Contribution to journalArticle


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 contributionUsing Macros in Microsoft Excel to Analyze Planar Structures
Original languageSpanish (Ecuador)
Pages (from-to)123-139
Number of pages17
JournalRevista Internacional De Ingeniería De Estructuras
Issue number24
StatePublished - 30 Apr 2019


  • Excel macros
  • Flat structures
  • Rigidity matrix
  • Visual basic

CACES Knowledge Areas

  • 237A Construction and civil engineering


Dive into the research topics of 'Using Macros in Microsoft Excel to Analyze Planar Structures'. Together they form a unique fingerprint.

Cite this