A clean summary tab that highlights the final Safety Factors (FS) or Load and Resistance Factor Design (LRFD) Demand-to-Capacity ratios. It should feature automated "PASS/FAIL" indicators using conditional formatting. 📐 Essential Design Equations for Your Spreadsheet
): Friction angle, unit weight, and cohesion of the bearing stratum. Tab 3: Geometric & Loading Inputs Total wall height ( ) and embedment depth ( Reinforcement length ( )—typically initialized at a minimum of 0.7H0.7 cap H Surcharge loads: Constant dead load surcharge ( ) and temporary live load surcharge ( Backslope angle ( ) if the terrain rises behind the wall crest. Tab 4: Earth Pressure Calculations mse wall design spreadsheet
Active earth pressure coefficient ( Kacap K sub a ) calculation using Rankine or Coulomb theories. A clean summary tab that highlights the final
These ensure the wall behaves as a rigid block: Tab 3: Geometric & Loading Inputs Total wall
Use IF statements to flag failures. Example: =IF(FS_sliding<1.5,"FAIL - Increase base width","OK") .
Professional tools like the CivilWeb Spreadsheets allow designers to optimize reinforcement spacing, showing exactly how many layers are needed to avoid over-engineering while ensuring safety. Key Components & Methodology
A robust spreadsheet is organized into logical modules. Below is a breakdown of the essential tabs or sections.