Google  

 

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.

---
Some of the Proformas contain Macros. Downloading these Proformas will trigger a Macro warning in the later versions of Excel. Macros will need to be 'Enabled' in order to run the proforma.
These are Internet Versions and are not to be used commercially unless verified by the user as being correct.

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.

 
1.00

 
Section properties for a corroded section of a riveted plate girder to BD 56/96.

 
2.05

 
CONCRETE

 
Wood & Armer equations for assessment calculations.

 
1.02

 
Early thermal cracking of concrete to BD 28/87.

 
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.

 
1.01

 
GEOMETRY

 
Section properties of an irregular cross section from co-ordinate geometry
 

 
1.01