But the real story is what happened next.
Prr=2⋅Le⋅σv′⋅F*⋅α⋅Rccap P sub r r end-sub equals 2 center dot cap L sub e center dot sigma sub v prime center dot cap F raised to the * power center dot alpha center dot cap R sub c Lecap L sub e is the embedment length behind the failure surface, σv′sigma sub v prime is the effective vertical stress, F*cap F raised to the * power is the pullout resistance factor, and is the scale correction factor. 🏗️ LRFD vs. ASD in Spreadsheet Design
: Reference tables for reinforcement strengths and reduction factors. 2. Define Essential Input Parameters tab must capture these critical variables: Wall Geometry : Height ( ), embedment depth ( cap D sub m ), and batter angle. Soil Properties : Unit weight ( ) and internal friction angle (
The design of an MSE wall involves iterative calculations, multiple limit states, and compliance with modern criteria. A spreadsheet serves as a powerful tool for several reasons:
: The select backfill placed within the reinforcement. Retained Backfill : The soil behind the reinforced mass. Foundation Soil : The native soil beneath the wall. mse wall design spreadsheet
Calculation of horizontal thrust vectors from soil weight and surcharges. Implementing the Verification Engines
MSE wall design involves balancing the lateral earth pressure of a backfill soil mass using horizontal reinforcement layers (like geogrids or metallic strips). Because the design process requires iterating through multiple wall heights, reinforcement lengths, and soil properties, manual calculation is highly inefficient.
Creating an MSE wall design spreadsheet requires expertise in civil engineering, specifically in geotechnical engineering and MSE wall design. The spreadsheet should be developed using a spreadsheet software (e.g., Microsoft Excel) and should include:
Vary φ by ±2° and γ by ±10%. If FS drops below 1.3 in any scenario, redesign. But the real story is what happened next
Marcus had been staring at the same line of code in the spreadsheet for three hours. The sun had set over the industrial park, leaving only the blue glow of his dual monitors to illuminate the cluttered engineering office. On his screen, a single cell — E47 — glowed angry red.
Total height (H), front face batter, and embedment depth ( Dmincap D sub m i n end-sub
Engineers have a variety of spreadsheet and software options for MSE wall design:
Create explicit data-entry cells highlighted in a distinct color (e.g., light blue). Use data validation to prevent negative values for soil friction angles or wall heights. Tab 2: Earth Pressure Coefficients ASD in Spreadsheet Design : Reference tables for
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.
Establish a rigid color hierarchy. Use light yellow or blue fills exclusively for user input cells. Keep calculation cells white with black text. Use light green or bold text for final check outputs.
Evaluating whether the embedded length of the reinforcement in the resistant zone (behind the failure plane) is sufficient to prevent pulling out. Reinforcement Rupture: Checking if the calculated Tmaxcap T sub m a x end-sub exceeds the allowable long-term tensile strength ( Talcap T sub a l end-sub ) of the geogrid or steel. 4. Code Compliance Summary Sheet
): 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