Link to Details about David Childs

 

Bridge Design & Assessment

Google

You are here: Home » Bridge Design » Spreadsheets

Scroll to top

 

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'.
Warning:
The layout of the spreadsheet should not be changed. The macros carry out calculations using values from specific cells in the spreadsheet. If extra rows or columns are added the macro will still use the value in the old address and, as a result, will not give the correct answer.
Also OpenOffice should not be used to run these spreadsheets as the visual basic used in the macros does not translate directly into the OpenOffice.org Basic.
 
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.

 
Legal Stuff - Please Read.....[Show]

Disclaimer

These spreadsheets have been prepared to assist with the repetative design and assessment calculations for highway structures.
Users of these spreadsheets should verify for themselves the appropriateness of any values which they use for their own calculations and their own particular conditions, and should check for themselves the correctness of any results that they use. David Childs has prepared these spreadsheets to assist designers, but he takes no responsibility for how the results are used.
 

Consumer Protection

Please ensure that you are purchasing the correct document as they cannot be returned.
The documents conform with clause 13(1)(c) of the Consumer Protection (Distance Selling) Regulations 2000 as being an 'Exception to the right to cancel'.
 

Proof of Purchase

Documents that are purchased will be licensed to the email address used for procurement through PayPal; any enquiries about the items purchased must be sent using this licensed email address.
There are no administration costs or VAT included in the price of the documents therefore the PayPal receipt is satisfactory for the proof of purchase. If an invoice is required then an administration charge of £15 GBP will have to be added. Click here to link to Administration Fee WebPage.

... close

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

*
 

*

Plane Frame Analysis for Static Loads

 

A Plane Frame Analysis for bending moments, axial and shears forces in a plane frame structure under point loads, UDL's, linearly varying distributed loads (soil pressures) and moments.
Limits have been applied to the number of nodes (21), number of members (20), and number of loads in one load case (40).
Either metric units or US Customary units can be used.

 

Free
 *
PlnFrm.zip (432KB)
Version 1.06

 

*

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, of equal spans, 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 (175KB)
Version 1.08

 

Price: £15.00 GBP

101.zip
Version 2.04

 

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.

 

*

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

 

The standard Tandem System with the UDL System (LM1), Annex A vehicles, SV's and SOV's to UK National Annex (LM3), 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.04

 

*

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

 

*

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 (164KB)
Version 1.06
(Metric Units)

 

Free
 *
LneBemUS.zip (166KB)
Version 1.07
(US Customary Units)

 

*

Load Cases for Fixed and Free Abutments to BD30

 

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

 

Price: £6.00 GBP

104.zip
Version 1.03

 

*

Load Cases for Fixed and Free Abutments to BS EN 1997-1:2004 & PD 6694-1:2011.

 

Seven permanent and variable load combinations are analysed for a fixed end or free end abutment. Normal traffic, SV/100 and SV/196 vehicles, or SOV vehicles can be analysed using the surcharge model described in PD 6694-1:2011. Stability and bearing pressure checks are carried out at SLS and ULS using Combinations 1 and 2 for Design Approach 1. Tables of moments and shears in the cantilever wall and base are also produced.

 

Price: £12.00 GBP

104a.zip
Version 1.04

*

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

 

*

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

 

 

*

Section Properties of Solid Irregular Sections by Co-ordinate Geometry

 

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

 

Free
 *
Xsect.zip (12KB)
Version 1.02

 

*

Section Properties of Voided Irregular Sections by Co-ordinate Geometry

 

Section properties, Area, Ixx, Iyy and xy co-ordinates of the centroid are determined for a voided irregular shaped section. Outline of the section and void is input using x-y co-ordinates. Circular voids can be input using the diameter and xy co-ordinates of their centre.

 

Free
 *
VoiddXsect.zip (34KB)
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.05

 

*

Ultimate Limit State Moment Capacity of Prestressed Pretensioned Beams with composite insitu concrete deck slabs.

 

Spreadsheet (a) is to BS 5400 Pt. 4 for design to clause 6.3.3.1. and includes a check for ductility.

 

Spreadsheet (b) is to BD 44/15 for assessment of beams with bonded prestressing tendons to clause 6.3.3.1. and allows for a ductility check to be carried out.

 

(a) Design

Price: £6.00 GBP

301a.zip Ver. 1.00

 

(b) Assessment

Price: £6.00 GBP

301b.zip Ver. 1.00

 

*

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 (154KB)
Version 2.11

 

*

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 plate bending design and assessment calculations.

 

Wood & Armer analysis to optimise steel reinforcement to resist Mx, My and Mxy plate bending 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.06

 

 

*

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 MR are also determined.

 

Free
 *
Sectprop.zip (116KB)
Version 3.07

 

*

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

 

 

*

Filler Beam Yield Moment & Plastic Moment Capacities to BD 61/10

 

Two spreadsheets for determining the moment capacities of filler beam sections in accordance with BD 61/10. 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

 

*

Section Properties of Composite Bridge Beams to BS 5400 Pt.3:2000 & Pt.5:2005

 

Two spreadsheets for determining the elastic and plastic section properties of a composite beam comprising a steel plate girder with unstiffened flanges and a reinforced concrete deck for internal and edge beams. The concrete deck may be analysed in tension or in compression. Shear lag calculations are included for SLS properties. Compact Section checks are carried out and the appropriate Plastic Moment of Resistance or Permissible Ultimate Elastic stresses are calculated.

 

Price: £12.00 GBP

502.zip
Version 2.00

 

 

*

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

 

*

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 (37KB)
Version 1.04

 

 

 

PayPal Acceptance Mark

 
For more information:

Contact David Childs