: Horizontal forces acting on the side walls, calculated using active or at-rest earth pressure coefficients ( Kacap K sub a K0cap K sub 0
If you want to customize your spreadsheet for a specific project, please let me know:
: Modify the live load distribution parameters based on your local highway agency codes. box culvert design calculations xls link
Concentrated wheel loads from standard design vehicles (such as AASHTO HL-93, IRC Class AA, or Eurocode LM1).
Using the applied loads, the spreadsheet calculates the resulting bending moments, shear forces, and axial loads. It then uses the material properties (e.g., fcu = 30 N/mm², fy = 460 N/mm² for reinforcement) to determine the required reinforcement area (e.g., As1, AS7, AS8) to resist these forces, checking against crack width limits and other serviceability requirements. : Horizontal forces acting on the side walls,
: Ideal for sites with limited clearance between the roadway and the stream bed.
Most XLS templates use approximate coefficients or rigid frame analysis. Because a box culvert is a closed monolithic frame, the corners experience significant (tension on the outside) and the midspans experience positive moments (tension on the inside). It then uses the material properties (e
: Determining whether the flow capacity is limited by the entrance geometry or the barrel friction and downstream tailwater. Structural Load Cases