29 July 2013

Spreadsheet for Analysis 2D Frames (FEM)


Structural analysis of 2D beam and frame problems. This version works in Excel 2007 and Excel 2010. Due to restrictions Excel 2003 (sheet size and limitations on matrix inversion functions) an Excel 2003 version of this file is available but this version is no longer being maintained.

SECTION
  • UNITS
  • MATERIALS
  • SECTIONS
SYSTEM
  • NODES
  • SUPPORTS
  • MEMBERS
POINT LOAD
  • POINT
  • SPRING
  • DEFLECTION
MEMBER LOAD
  • VERTICAL DISTRIBUTE
  • AXIAL DISTRIBUTE
  • VERTICAL POINT
  • AXIAL POINT
  • MOMENT
  • DEFLECTION
  • THERMAL
ANALYSIS
  • NODE DEFLECTIONS
  • SUPPORT REACTIONS
  • MEMBER FORCES (L.C.)
  • MEMBER FORCES (G.C.)
  • DIAGRAMS
Calculation Reference
Finite Element Analysis 

Download
Code
Spreadsheet for Analysis 2D Frames (FEM)
This spreadsheet can be downloaded at Civilax VIP Section with more premium spreadsheets.