Bridge Design Spreadsheets

Home About Bridge Design . Design Notes . Calculations . Spreadsheets . Tutorials Workshop Resources

You are here: Home » 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.
Consumer Protection - Please Read Consumer Protection
Please ensure that you are purchasing the correct document or spreadsheet as they cannot be returned.

The documents and spreadsheets conform with clause 13(1)(c) of the Consumer Protection (Distance Selling) Regulations 2000 as being an 'Exception to the right to cancel'.

You don't need a PayPal account to pay using a credit or debit card.

Buried Concrete Box Structure Loading to BD 31

Two examples of output from the spreadsheet may be viewed by clicking the pdf icon.

BoxOutput.zip(473KB)

Bending moments, shear and axial forces for loads on a buried concrete box structure, as described in BD 31/01, are calculated. Single, double or triple cell boxes may be analysed on fixed or spring foundation supports.Dispersed wheel loads from moving vehicles (HA, HB, Accidental Wheel and Construction loads) are traversed across the structure to determine the worst effect on each member in the structure.

Temperature Effects, hydrostatic pressures and collision loading (depending on the nature of the structure and constraints) are also analysed.
The analysis is carried out using moment distribution with sway correction on a one metre length of box.
The scope of BD 31/01 sets the Standard for buried box structures with depth of cover up to 11.0m, and length between inside faces of outermost walls greater than 0.9m and up to 15.0m.

Price: £25.00 GBP

51.zip
Version 1.01

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.02

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 (170KB)
Version 1.05

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.03

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.01

GEOMETRY

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.02

CONCRETE

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.02

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.03

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

Reinforced Concrete Slab Design to Eurocodes EN 1992-2:2005 & UK National Annex

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. A calculation sheet is automatically prepared for the desired reinforcement layout.

Price: £10.00 GBP

304.zip
Version 1.00

General Reinforced Concrete Section Design to Eurocodes EN 1992-2:2005 & UK National Annex

Bending moment capacity at ultimate limit state, serviceability limit state checks and shear capacity calculations for a general reinforced concrete section. Both tension and compression reinforcement can be included in a section of varying widths symmetrical about the vertical axis. Efficient stirrup arrangements can be obtained by an interacive analysis.

Price: £12.00 GBP

305.zip
Version 1.00

Early Age Thermal Crack Control to Eurocodes EN 1992-3:2006 & UK National Annex applicable to bridges, incorporating CIRIA Report C660 recommendations.

Calculates the area of steel reinforcement required to control early age thermal cracking using methods described in CIRIA Report C660 "Early Age Thermal Crack Control in Concrete".

Price: £10.00 GBP

306.zip
Version 1.00

STEEL

Riveted Plate Girder Section Properties

Section properties of a riveted plate girder to
BD 56/10 and BS5400-3:2000 with facility to allow for corroded elements. The slenderness parameter λ_LT and limiting moment of resistance M_R are also determined.

Free

Sectprop.zip (114KB)
Version 3.05

Effective Span of Plate Girder with no Bearing

The effective span and maximum bearing pressure for a plate girder with no specific bearing is calculated in accordance with BD 56/10 clause 16 and Figure 16.1A

Free

EffSpan.zip (23KB)
Version 1.02

COMPOSITE

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

MASONRY