Estimating Spreadsheets for Bridge Design Calculations
Given below some exclusive samples of bridge design calculation spreadsheets. All the calculations are made on the basis of BS 5400 as well as the Design Manual for Roads and Bridges.
There are three types of spreadsheets which range from Two Span Reinforced Concrete Bridge Deck to BS 5400, Reinforced Concrete Substructure for a Two Span Bridge Deck to BS 5400 and Two Span Reinforced Concrete Deck & Substructure to BS 5400.
Two Span Reinforced Concrete Bridge Deck to BS 5400 – In this estimating sheet one can get design estimations toward a hypothetical two span reinforced concrete bridge deck to demonstrate the needs of BS 5400 Part 2 loading and Part 4 to create the design concerning concrete bridges. A grillage analysis is carried out; input load cases and output results are contained. The sample also reveals how spreadsheets are efficiently applied to lessen the design time occurred with the repetitive calculations.
Reinforced Concrete Substructure for a Two Span Bridge Deck to BS 54 – This spreadsheet will provide design estimations for reinforced concrete abutments, wing walls and pier of a hypothetical two span bridge deck to exemplify the needs of BS 5400 Part 2 loading and Part 4 for design of concrete bridges.
Loading from the superstructure is acquired from the Reinforced Concrete Bridge Deck Example. The sample also shows how the spreadsheets are utilized well to minimize the design time procured with the iterative calculations.
Download Bridge Design Calculations
Image Courtesy: ammarbridge.wordpress.com