): Multipliers that increase design loads (e.g., 1.5 for horizontal earth pressure, 1.75 for live loads). Resistance Factors (
Design methodologies typically follow either via AASHTO specifications or ASD (Allowable Stress Design) via NCMA or FHWA guidelines. Your spreadsheet must be explicitly tailored to one of these frameworks to ensure correct safety factors or load/resistance factors are applied. Share public link
Ensures the maximum lateral stress at a specific layer does not exceed the allowable design strength ( Talcap T sub a l end-sub ) of the reinforcement.
The Ultimate Guide to MSE Wall Design Spreadsheets: Streamlining Retaining Wall Engineering mse wall design spreadsheet
But the killer feature was the . A dropdown that let him toggle between:
: Single point of entry for wall geometry, soil properties, and loading. CALCULATIONS (Internal & External) : Hidden or protected sheets for the engineering math. OUTPUT/SUMMARY
FSoverturning=∑Mresisting∑Mdriving=Wreinforced⋅(L/2)Pa⋅(H/3)+Psurcharge⋅(H/2)cap F cap S sub o v e r t u r n i n g end-sub equals the fraction with numerator sum of cap M sub r e s i s t i n g end-sub and denominator sum of cap M sub d r i v i n g end-sub end-fraction equals the fraction with numerator cap W sub r e i n f o r c e d end-sub center dot open paren cap L / 2 close paren and denominator cap P sub a center dot open paren cap H / 3 close paren plus cap P sub s u r c h a r g e end-sub center dot open paren cap H / 2 close paren end-fraction Target FS is typically ≥2.0is greater than or equal to 2.0 Reinforcement Pullout Capacity ): Multipliers that increase design loads (e
) of the resultant force must fall within the middle third (or middle half for rock foundations) of the base width (
Mechanically Stabilized Earth (MSE) Retaining Walls - Geoquest USA
#GeotechnicalEngineering #CivilEngineering #MSEWall #StructuralDesign #Excel #EngineeringTools #RetainingWalls Share public link Ensures the maximum lateral stress
He called it .
One spreadsheet, quietly holding up the world.
). Use conditional formatting ( IF statements) to print a bold green or a bright red "FAIL" based on your target factors of safety. Tab 4: Internal Layer-by-Layer Matrix