Here is a recommended tab structure with sample formulas (adapt to your units – kN, m, mm, MPa).
Create tables for vertical and horizontal loads: double box culvert design excel sheet
Most practical Excel sheets use combined with coefficient tables from standard references (e.g., USBR 2800, AASHTO Table 4.6.1.2.1b). Here is a recommended tab structure with sample
Each load case is tabulated in a separate worksheet, then combined using LRFD factors. double box culvert design excel sheet
Use Goal Seek or a simple iterative loop (circular references enabled carefully) to solve Manning’s equation.