Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and restrained end moments. Each function comes in both “unit aware” versions, and versions for use with any consistent units.
The functions use Macaulay’s Method, and allow beams with varying cross-section, and any number of supports, which may be rigid simple supports, or spring supports with rotational restraint. Loads may be trapezoidal distributed loads or point transverse loads or moments. The most recent blog post on this spreadsheet was: Continuous Beam Spreadsheet – with Units, and the spreadsheet may be downloaded from:
An alternative approach uses cubic splines to model the beam deflection when subject to a series of point loads and moments. The most recent post on this approach was: SplineBeam update and the spreadsheet may be downloaded from:
Finally a series of beam analysis spreadsheets were presented as an introduction to frame analysis, the most recent being: Frame Analysis with Excel – 3, Continuous beam or frame the associated download file is available at:
but note that this has been developed into a frame analysis program, which will be presented here in the next few days.
Typical screenshots are shown below: