An MSE wall design spreadsheet is a programmed Excel or equivalent sheet designed to automate the analytical processes required for designing reinforced soil structures. It integrates:
The market offers a variety of spreadsheets, ranging from free legacy tools to sophisticated commercial products and official state resources. Here's a breakdown of what's available.
External stability treats the entire reinforced soil mass as a rigid gravity retaining wall. The spreadsheet must compute three primary safety factors:
That night, Marcus didn’t sleep. Instead, he opened a blank Excel workbook and began to build.
): 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
Modern design spreadsheets typically follow the methodology. This involves applying specific factors to various loads, such as: Vertical Pressure (EV): Dead load of the earth fill. Live Load Surcharge (LS): Traffic loads on top of the wall. Seismic Conditions (EQ): Earthquake-induced forces.
Surcharge loads (e.g., 12 kPa traffic surcharge, similar to those in NZGS case studies ), seismic coefficients, and water table levels.
): Friction angle and unit weight of the structural backfill. Retained Fill ( ϕbphi sub b γbgamma sub b
Ka=tan2(45∘−ϕ2)=1−sin(ϕ)1+sin(ϕ)cap K sub a equals tangent squared open paren 45 raised to the composed with power minus the fraction with numerator phi and denominator 2 end-fraction close paren equals the fraction with numerator 1 minus sine open paren phi close paren and denominator 1 plus sine open paren phi close paren end-fraction : The total thrust from the retained soil:
Wall height, backslope angle, and toe slope angle.
An MSE wall design spreadsheet is a programmed Excel or equivalent sheet designed to automate the analytical processes required for designing reinforced soil structures. It integrates:
The market offers a variety of spreadsheets, ranging from free legacy tools to sophisticated commercial products and official state resources. Here's a breakdown of what's available.
External stability treats the entire reinforced soil mass as a rigid gravity retaining wall. The spreadsheet must compute three primary safety factors:
That night, Marcus didn’t sleep. Instead, he opened a blank Excel workbook and began to build.
): 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
Modern design spreadsheets typically follow the methodology. This involves applying specific factors to various loads, such as: Vertical Pressure (EV): Dead load of the earth fill. Live Load Surcharge (LS): Traffic loads on top of the wall. Seismic Conditions (EQ): Earthquake-induced forces.
Surcharge loads (e.g., 12 kPa traffic surcharge, similar to those in NZGS case studies ), seismic coefficients, and water table levels.
): Friction angle and unit weight of the structural backfill. Retained Fill ( ϕbphi sub b γbgamma sub b
Ka=tan2(45∘−ϕ2)=1−sin(ϕ)1+sin(ϕ)cap K sub a equals tangent squared open paren 45 raised to the composed with power minus the fraction with numerator phi and denominator 2 end-fraction close paren equals the fraction with numerator 1 minus sine open paren phi close paren and denominator 1 plus sine open paren phi close paren end-fraction : The total thrust from the retained soil:
Wall height, backslope angle, and toe slope angle.