Mse Wall Design Spreadsheet [updated] Link

Within the Load and Resistance Factor Design (LRFD) framework, an MSE wall design must be verified against a series of limit states to ensure safety and serviceability. A robust MSE wall spreadsheet must therefore incorporate checks for:

To ensure your spreadsheet calculates values accurately, integrate these fundamental engineering equations: Lateral Earth Pressure (Rankine Theory)

When building or selecting an MSE wall design spreadsheet, it must align with the correct engineering methodology mandated by your project jurisdiction: Allowable Stress Design (ASD) : Applies global Factors of Safety ( FScap F cap S ) to nominal loads and capacities. mse wall design spreadsheet

Evaluates the lateral driving forces against the frictional resistance along the base of the reinforced zone. The spreadsheet must compute the nominal shear resistance and apply the appropriate resistance factor ( ϕτphi sub tau

The Pennsylvania Department of Transportation provides a free MSE wall design spreadsheet (April 2015). A user’s manual and the spreadsheet in XLSX format are both available for download from the PennDOT website. It is intended for PennDOT projects but can be adapted for other applications. Within the Load and Resistance Factor Design (LRFD)

The spreadsheet should automatically calculate and verify the following factors of safety (FoS) or resistance factors: Check Type What it Measures Target/Method External: Sliding Ability to resist lateral earth pressure. Factor of Safety typically is greater than or equal to 1.5 External: Bearing Capacity of foundation soil to support wall weight. Pressure < Allowable Bearing Capacity. External: Overturning Eccentricity of the resultant force. Resultant must stay within the middle third of the base. Internal: Pullout Resistance of reinforcement to being pulled out of soil. Check at each reinforcement layer. Internal: Tensile Strength of the reinforcement material itself. Actual stress < Long Term Design Strength ( cap L cap T cap D cap S 4. Implementation Tips MSE Wall Design Spreadsheet - User's Manual (April 2015)

❌

Mechanically Stabilized Earth (MSE) walls are standard in modern infrastructure. They rely on alternating layers of compacted backfill and soil reinforcement. Designing these structures requires rigorous adherence to civil engineering principles.

): 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 The spreadsheet must compute the nominal shear resistance