The ConbeamU spreadsheet has been updated to Version 4.10, to fix a problem with incorrect default parameters being used if the support stiffness columns had empty cells. The revised spreadsheet (including open-source code) can be downloaded from:
Applications in the spreadsheet include:
Conbeam and ConbeamU; continuous beam analysis with any number of supports and beam segments. Supports may have specified translation or rotation stiffness or specified displacements. ConbeamU (and other functions ending in U) are unit aware, allowing input and output in a wide variety of different units:
There are also similar functions for single spans (SSSpanU) and cantilevers (CantileverU).
MovLoadU does moving load analysis on a continuous beam, with vehicles with any number of axles:
FEAU and REAU find fixed end moments or restrained end moments for a single span with fixed ends or spring restrained ends. The beam may have any number of segments with different section properties.
Any number of loads may be applied, which may be point forces or moments, of uniform or trapezoidal distributed loads:
The BeamAct3D function returns beam actions and deflections along the beam, for a beam with any number of segments and specified end conditions and applied loads.
The React3D function returns fixed or restrained actions for a beam with any number of segments, subject to 3D loading:
Download the spreadsheet for more details of each function, and information on using array functions.