Category Archives: Frame Analysis

Frame Analysis with Excel – 5; Large frames in Excel 2003

Posted on 05/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 4, 2D frame analysis Download Frame2.zip – the download file includes complete open source code. The solution presented in the previous post in this series made use of the Excel built in functions MINVERSE() and … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 5 Comments

Frame Analysis with Excel – 4, 2D frame analysis

Posted on 15/02/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download Frame1.zip – the download file includes complete open source code. The continuous beam spreadsheet presented in the previous post has been modified to deal with 2D frames where any … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, Uncategorized, VBA | Tagged , , , | 20 Comments

Frame Analysis with Excel – 3, Continuous beam or frame

Posted on 10/02/2009 by dougaj4

Continuing from Frame Analysis with Excel 2 – Single inclined beam Download Beam3.zip – the download file includes complete open source code. The spreadsheet for a single inclined beam presented in the previous post has been modified to deal with up … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 30 Comments

Frame Analysis with Excel 2 – Single inclined beam

Posted on 04/02/2009 by dougaj4

This post continues from – Frame Analysis with Excel 1 – Single beam Download Beam2.zip The stiffness matrix shown in the previous post was for a single beam with loads applied either perpendicular to the beam, or along the longitudinal beam axis, … Continue reading →

Posted in Excel, Frame Analysis, Newton, UDFs | Tagged , , , | 11 Comments

Frame Analysis with Excel 1 – Single beam

Posted on 31/01/2009 by dougaj4

Download Beam1.zip This is the first of a series of posts in which I will develop a structural frame analysis program operating within Excel.  The first few stages will be mostly spreadsheet based, with later stages using VBA routines to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, Uncategorized | Tagged , , , | 14 Comments