Box Culvert Design Excel Sheet ((exclusive)) – Instant Download
Calculate the required riprap length at inlet/outlet using L_apron = 3 * D .
| Cell | Parameter | Formula/Note | |------|-----------|---------------| | B2 | Design Q (m³/s) | User Input | | B3 | Culvert Width (m) | Trial value | | B4 | Culvert Height (m) | Trial value | | B5 | Manning's n | 0.012 (concrete) | | B6 | Slope (m/m) | 0.005 | | B7 | Area (A) | =B3*B4 | | B8 | Hydraulic Radius (R) | =(B3*B4)/(2*B3+2*B4) | | B9 | Full Flow Q | =(1/0.012)*B7*B8^(2/3)*B6^(1/2) | | B10 | HW/D Ratio | =IF(B9>=B2, "OK", "Resize") | box culvert design excel sheet
This is where a becomes an engineer’s best friend. Gone are the days of manual lookup tables and slide rules. Today, a well-structured spreadsheet can transform hours of repetitive calculations into a 15-minute design verification. Calculate the required riprap length at inlet/outlet using