Category Archives: Frame Analysis

ConBeamU Update

Posted on 17/04/2014 by dougaj4

Recently a comment pointed out that if the ConBeam, or ConBeamU, user defined functions were used with a single span then the “Out” argument was ignored, so it was not possible to return support reactions.  This has now been fixed … Continue reading →

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

Global to Local for plates (and three node beams)

Posted on 02/03/2014 by dougaj4

The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading →

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , | 3 Comments

Using Frame4Buckle with the Alglib solver

Posted on 01/03/2014 by dougaj4

The Frame4Buckle spreadsheet carries out a buckling analysis of a column or strut, which may be divided into any number of segments with varying cross section details, allowing the analysis of stepped or tapered members.  The spreadsheet includes a VBA … Continue reading →

Posted in AlgLib, Computing - general, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , , | 5 Comments

Beam actions and deflections, 3D or 2D

Posted on 01/02/2014 by dougaj4

Two new functions have been added to the ConBeamU spreadsheet, last discussed here. The new version can be downloaded from ConBeamU.zip, including full open-source code. The new functions, BeamAct3D and BeamAct2D calculate forces, moments, deflections and rotations along a 3D … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 2 Comments

Frame Analysis with Excel

Posted on 22/01/2014 by dougaj4

Starting from 2009 I have posted a series on frame analysis using Excel, starting from a simple “on-sheet” solution and working through to applications able to solve large 2D or 3D problems. To follow the analysis process it is best … Continue reading →

Posted in Excel, Frame Analysis, VBA | Tagged , , , | 1 Comment