Calculates the high stress exerted at the toe of the wall and verifies that the foundation soil can support it without shear failure. Step 3: Internal Stability Calculations
Marcus blinked. “But I followed the manual step-by-step.”
Type (steel grids, steel strips, or geogrids), ultimate tensile strength ( Tultcap T sub u l t end-sub ), long-term design strength ( Talcap T sub a l end-sub ), coverage ratio ( Rccap R sub c ), and vertical spacing ( Svcap S sub v Surcharge Loads: Live load surcharge ( qLLq sub cap L cap L end-sub ) and dead load surcharge ( qDLq sub cap D cap L end-sub ), such as traffic loads or sloping crests. 2. External Stability Analysis Sheet
One day, a young engineer from a competing firm emailed him: “I heard you have an MSE wall design spreadsheet. Can you share it?” Marcus thought for a moment, then attached a copy. The only condition: “If you find an error, tell me. If you improve it, share back.” mse wall design spreadsheet
): The natural soil beneath the wall supporting the entire structure. Reinforcement (Geogrid/Steel) Properties The maximum load the reinforcement can handle. Reduction Factors ( ): Factors for creep, installation damage, and durability. Long-Term Allowable Design Strength ( Talcap T sub a l end-sub ): Calculated as Coverage Ratio ( Rccap R sub c
An advanced spreadsheet that performs both external and internal stability analysis in accordance with AASHTO FHWA NHI-10-025. It includes unique visualization and optimization tools, allowing a fully compliant design to be completed in minutes. The price is approximately £20, or it can be purchased as part of a retaining wall design suite.
Manual MSE wall design is notoriously time-consuming due to the "trial and error" nature of optimizing reinforcement lengths and spacing. Calculates the high stress exerted at the toe
Marcus never patented it. He never sold it. He just kept adding features, fixing bugs, and documenting every change in a changelog tab that eventually ran to 1,200 lines.
Below is a comprehensive guide to understanding, building, and utilizing an MSE wall design spreadsheet. The Role of Spreadsheets in MSE Wall Design
Use Excel formulas (such as IF , INDEX , and MATCH ) to dynamically adjust the number of reinforcement layers based on the entered wall height. If an engineer changes the height from 10 feet to 20 feet, the spreadsheet should automatically add rows for the extra geogrid layers. Visual Cross-Section Plotting The only condition: “If you find an error, tell me
– Sum of moments about the toe. Spreadsheets automatically sum moments from earth pressure, surcharge, and self-weight of reinforced fill.
Several specialized spreadsheets and software tools are available for professional use: CivilWeb MSE Wall Design Spreadsheet
Mechanically Stabilized Earth (MSE) walls are a cornerstone of modern civil engineering. They offer flexible, cost-effective solutions for grade separation in highway, bridge, and commercial projects. Designing an MSE wall requires rigorous analysis of both internal and external stability.
The final spreadsheet serves as a complete, transparent calculation report. It contains all assumptions, input parameters, intermediate calculations, and final results. This is invaluable for quality control, peer review, and regulatory approval.
