Category Archives: Frame Analysis

Update to Frame4.xls

Posted on 19/07/2009 by dougaj4

It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect results. The code for the non-uniform load has now been fixed, and the spreadsheet can be downloaded from Frame4.zip

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , | 1 Comment

More on cubic splines

Posted on 12/07/2009 by dougaj4

Link to Cubic Spline Update The previous two posts used cubic splines with the “natural” end condition, that is with an end curvature of zero.  To apply the cubic spline to analysis of continuous beams with different end conditions we … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , | 10 Comments

Continuous beam analysis with cubic splines

Posted on 05/07/2009 by dougaj4

The last example in the previous post illustrated the use of cubic splines to find the bending moments in a continuous beam subject to prescribed lateral displacements.  A similar technique can be used to find bending moments, shear forces, reactions, … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 9 Comments

Frame Analysis with Excel – 7; Shear deflections and support displacements

Posted on 11/05/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 31 Comments

Frame Analysis with Excel – 6; Beam end releases and actions

Posted on 29/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003 Download Frame3.zip – the download file includes complete open source code. The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | 4 Comments