| Parameter | Cell Ref | Formula / Input | Unit | | :--- | :---: | :--- | :---: | | | | | | | Span ($L_clear$) | B5 | 3.0 | m | | Earth Cover ($d$) | B6 | 1.5 | m | | Soil Unit Wt ($\gamma_s$) | B7 | 18 | kN/m³ | | LOADS | | | | | Earth Pressure (Base) | B12 | =B7 * B6 (Surcharge + Height) | kN/m² | | ANALYSIS | | | | | Moment (Midspan) | C20 | =(w * L^2)/8 - (M_support) | kNm | | DESIGN | | | | | $A_st$ Required | D30 | =(0.5*fck/fy)*(1-SQRT(1-(4.6*Mu)/(fck*b*d)))*b*d | mm²/m |
An effective Excel sheet should be divided into logical modules. Below is a step-by-step guide to its structure. box culvert design excel sheet as per irc
The sheet must combine loads using Load Factors: $$ \textDesign Load = 1.5(DL) + 1.5(LL) + 1.5(EP) $$ (Note: Factors may vary based on specific IRC:112 combinations, e.g., DL + EP may use different factors than DL + LL). | Parameter | Cell Ref | Formula /
The sheet should allow selection of the loading class. The sheet should allow selection of the loading class