Google  

 

Home | Spreadsheets

Bridge Design Spreadsheets

 

These Design and Assessment Spreadsheets were written using Microsoft Excel 2000 and they contain macros. Excel will need to be set to 'Enable Macros'. Please download and try out the FREE spreadsheets to ensure you are satisfied with the nature of the products before purchasing the priced spreadsheets. The spreadsheets will be emailed to you in a zip folder. We receive notification from PayPal when your transaction is complete, but please allow one working day for processing your purchase.  

 
Index: Loading | Geometry | Concrete | Steel | Composite | Masonry

 
 
 

 

Line Beam Analysis for Moving Vehicle Loads to
BS 5400, BD 21 and BD 86

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.

 
Free

MovinLd.zip (233KB)
Version 1.06

 
The priced version includes the Standard Fatigue Vehicle and also produces output for maximum reactions with the facility to save the results. Abnormal load configurations are also stored in the workbook.

Price: £15.00 GBP

101.zip
Version 2.01

 

 

Line Beam Analysis for Moving Vehicle Loads to
Euro Code EN 1991-2:2003

The standard Tandem System, Annex A vehicles, SV's and SOV's to UK National Annex, and Fatigue Load Models are analysed as moving loads across a single or multi-span continuous line beam to determine critical bending moments, shear forces and reactions.

 
Price: £15.00 GBP

102.zip
Version 1.01

 

 

 

Line Beam Analysis for Moving Vehicle Loads to
AASHTO LRFD Loads Chapter 3:2008

The HL-93 Design Truck and Tandem with Lane Load (including Negative Moment adjustment), Overload Trucks, H5 and H10 vehicles and the Fatigue Load Design Truck are analyzed as moving loads across a single or multi-span continuous line beam to determine critical bending moments, shear forces and reactions.


 
Price: £15.00 GBP

103.zip
Version 1.06

 

 

Line Beam Analysis for Static Loads and Settlement at Supports

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.

 
Free
 
LneBem.zip (182KB)
Version 1.04

 

 

Load Cases for Fixed and Free Abutments

Dead and Live load combinations are analysed for a fixed or free abutment. Stability and bearing pressure checks are carried out. Tables of moments and shears in the wall and base are also produced.

 
Price: £6.00 GBP

104.zip
Version 1.01

 

 

Influence Line Diagrams for single or multispan decks
 

Influence Line diagrams for bending moments at critical sections in a single or multi-span continuous beam.

 
Free
 
InfLine.zip (114KB)
Version 1.02

 

 

Differential Temperature Effects to BS 5400-2: 2006

Load effects due to vertical temperature differences through various types of bridge decks are analysed using non-linear effects as described in clause 5.4.5. Releasing moments and forces and self-equilibrating stresses are determined for the positive and reverse temperature differences.

 
Price: £8.00 GBP

105.zip
Version 1.01

 

 

Differential Temperature Effects to
Euro Code EN 1991-1-5:2003 (& UK N.A.)

Load effects due to vertical temperature differences through various types of bridge decks are analysed using non-linear effects as described in clause 6.1.4.2. Releasing moments and forces and self-equilibrating stresses are determined for the heating and cooling temperature differences.


 
Price: £8.00 GBP

106.zip
Version 1.01

 

 

Distribution of Releasing Moments from Differential
Temperature Effects on a Continuous Beam.

A line beam analysis is used to determine the secondary effects produced by the releasing moment from the differential temperature effects on a continuous beam using the moment distribution method.

 
Free
 
LbeamDTRelMom.zip (80KB)
Version 1.00

 

 

 

Section Properties of Irregular Sections
by Co-ordinate Geometry

Section properties, Area, Ixx, Iyy and xy co-ordinates of the centroid are determined for an irregular shaped section. Outline of the section is input using x-y co-ordinates.

 
Free
 
Xsect.zip (12KB)
Version 1.01

 

 

 

Prestressed Pretensioned Beam with composite
insitu concrete deck slab to BS 5400 Pt. 4

The beam and deck are checked for the serviceability requirements of BS 5400 Part 4 for all stages of construction from transfer of prestressing force to long-term creep and shrinkage and live load effects.

 
Price: £12.00 GBP

301.zip
Version 1.02

 

 

Bar Schedule to BS 8666:2005.
 

Calculates bar lengths for standard bar shapes and produces summaries of lengths and weights for bar types and diameters. Includes checks for compliance with the code requirements.

 
Free
 
Barshd.zip (182KB)
Version 2.10

 

 

Serviceability Limit State & Early Thermal Cracking Checks
to BS 5400 Pt. 4 & BD 28/87

Solid rectangular reinforced concrete sections are checked for the serviceability requirements of BS 5400 Part 4 for complying with crack width requirements to Clause 5.8.8.2 and stress limitations to Clause 4.1.1.3.

 
Price: £5.00 GBP

302.zip
Version 1.01

 

 

Wood & Armer equations for design and assessment calculations.

Wood & Armer analysis to optimise steel reinforcement to resist Mx, My and Mxy moments. Also analyses M*y reinforcement requirements for M*x provided.

 
Free
 
Wooda.zip (47KB)
Version 1.02

 

 

Reinforced Concrete Slab Design to BS 5400 Pt. 4
Clauses 4.1.1.3, 5.3.2.3 (eqn. 1 & 2), 5.4.4.1 & 5.8.8.2.

Bending moment capacities for ultimate limit and serviceability limit states together with shear capacity for a range of slab (or wall) thicknesses and bar diameters. Useful for determining suitable steel arrangements quickly.

 
Price: £8.00 GBP

303.zip
Version 1.02

 

 

 

Riveted Plate Girder Section Properties
 

Section properties of a riveted plate girder to BD 56/96 with facility to allow for corroded elements.

 
Free
 
Sectprop.zip (34KB)
Version 2.05

 

 

 

Yield Moment of Resistance of Filler Beam Decks
 

Calculates the yield moment of resistance of filler beam decks for assessment to BD61/96.

 
Free
 
Yieldm.zip (15KB)
Version 1.01

 

 

Filler Beam Yield Moment & Plastic Moment Capacities
to BD 61/96 & BA 61/96

Two spreadsheets for determining the moment capacities of filler beam sections in accordance with BD & BA 61/96. Checks are carried out on the bond between the steel and concrete at serviceability and ultimate limit states.

 
Price: £8.00 GBP

501.zip
Version 1.01

 

 

 

MEXE analysis to BD 21/01.
 

The modified MEXE analysis to BD 21/01 and BA 16/97 for single span masonry arch with option for axle lift-off.

 
Free
 
MEXE.zip (589KB)
Version 1.06

 

 

Axle lift-off criteria for hump back bridges.
 

An assessment of the road profile to determine if axle lift-off may occur for application with the MEXE analysis.

 
Free
 
lftoff.zip (16KB)
Version 1.02

 

David Childs Ltd, VAT Registration Number 613 4557 52

Tel: +44(0) 1904 701246, Fax: +44(0) 1904 701246, Email: david@childs-ceng.demon.co.uk