Category Archives: Frame Analysis

Route Map …

… so we know where we are going. I’ll be starting several, to some extent interlinked, new themes in this blog over the coming weeks.  Firstly VBA Classes.  Regular readers may have noticed that my VBA code tends to be … Continue reading

Posted in AlgLib, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, VBA | Tagged , , , , , | 4 Comments

Buckling of columns with varying cross section

Following a post in the Eng-Tips Forum about finding the buckling load of a stepped strut I have modified the Frame4 spreadsheet to carry out a buckling analysis of any straight member subject to axial load, including stepped or tapered cross … Continue reading

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

SplineBeam update

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths.  This … Continue reading

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Frame4.xls – Update2

It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis.  The problem turned out to be that the analysis did not have any restraint specified in the X direction, … Continue reading

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

Continuous beam with specified end conditions …

… and/or support displacements. The previous post in this series derived cubic splines with specified end conditions; either a specified curvature or a specified end slope. I have adapted the splinebeam function to allow input of specified end conditions (either a … Continue reading

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