The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions.

See ConBeamU for more details of the functions available in the spreadsheet.

Download the latest version from ConBeamU.zip.

The BeamAct2D and BeamAct3D user defined functions (UDFs) return beam actions and deflections for any beam subject to specified loads and end deflections. The beam may have any number of segments with different section properties, and may be specified in either global or local coordinate systems. The new non-linear option allows non-linear geometric effects to be taken into account.

Most of the function input is unchanged from previous versions:

The optional non-linear arguments specify if a non-linear analysis is required, the target relative error in maximum deflection, and the maximum number of iterations. The support stiffness (translational and rotational) may also be supplied. The default is fixed at both ends for both translation and rotation:

The output is before, with output at any number of specified locations:

Results are shown below for a 3D analysis of a 10 m long beam under combined axial and transverse load. The blue and green lines are the results ignoring geometric non-linear effects, and the grey and red are the output from both the spreadsheet and a non-linear analysis in Strand7, with the beam divided into 16 segments:

Due to differing approximations in the two programs there are small differences in the shear results:

Bending moments are in good agreement.

The 2D function gives similar results:

Note that these functions are still under development. All results must be independently verified using other software.