Home | Excel Proformas
These are a selection of simple spread sheet proformas which I have found useful in the repetitive calculations needed in some of the design/assessment calculations.
The proformas were written using Microsoft Excel.
The Worksheets have been compressed to zip folders.
SUBJECT
DESCRIPTION
Download
Version
LOADING
&
ANALYSIS
A Line Beam Analysis for bending moments and shears forces in a single or multi-span continuous beam under point loads and UDL's. Settlement at supports may also be analysed.
1.03
Abnormal Load Vehicles, HB Vehicles, BD21 Annex D Vehicles and BD86 STGO Vehicles are analysed as moving loads across a single or multi-span continuous line beam to determine critical bending moments and shear forces.
1.05
Influence Line diagrams for bending moments at critical sections in a single or multi-span continuous beam.
1.02
MEXE analysis to BD 21/01 for single span arch with option for axle lift-off.
1.06
Axle lift-off criteria for hump back bridges. An assessment of the road profile to determine if axle lift-off may occur.
1.02
STEELWORK
Effective Span to BA 56/96 Clause 16 Fig. 16.1A.
1.00
'U' Frame Action to BD 56/96 - Forces Fu and Fc.
 
UframeF.zip
1.00
Section properties for a corroded section of a riveted plate girder to BD 56/96.
 
Sectprop.zip
2.05
CONCRETE
Wood & Armer equations for assessment calculations.
 
Wooda.zip
1.02
Early thermal cracking of concrete to BD 28/87.
 
Etherm.zip
1.01
Bar Schedule to BS
8666:2005. Calculates bar lengths for bar shapes and summaries of lengths for bar types and diameters.
2.10
COMPOSITE
Yield Moment of Resistance of Filler Beam Decks for assessment calculations to BD61/96.
 
Yieldm.zip
1.01
GEOMETRY
Section properties of an irregular cross section from co-ordinate geometry
 
 
Xsect.zip
1.01