| 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") |
The humble Excel sheet is not obsolete. In fact, with the integration of (to pull live hydrological data from APIs) and VBA macros (to automate the trial-and-error loop for structural optimization), the Excel sheet remains the most practical tool for small to medium engineering firms. box culvert design excel sheet