Mse - Wall Design Spreadsheet __exclusive__
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
: Optimizing geogrid layout requires trial and error. By changing the spacing ( Svcap S sub v ) or length (
| Module | Function | Key Outputs | | :--- | :--- | :--- | | | Defines the wall’s physical and material parameters. | Wall height (H), backslope angle, reinforcement length (L), soil properties (friction angle, unit weight), load data (live load surcharges). | | 2. External Stability | Analyzes the reinforced soil block as a rigid mass. | Calculated factors of safety or resistance factors for sliding, overturning, and bearing pressure. | | 3. Internal Stability | Performs step-by-step analysis for each reinforcement layer. | For each layer: Earth pressure coefficient (K), required reinforcement strength (Tmax), required embedment length for pullout (Le). | | 4. Reinforcement Selection | Automates the iterative process of selecting products. | The optimal reinforcement type, length, and vertical spacing for each layer based on available product data. | | 5. Connection & Facing | Checks the connection point between the reinforcement and the facing. | Connection capacity demand vs. capacity ratios (CDR). | | 6. Settlement Analysis | Estimates the immediate and consolidation settlement of the foundation soil. | Predicted total settlement to compare against project tolerances. | mse wall design spreadsheet
A robust spreadsheet begins with well-organized input cells. According to common design methodologies, the following inputs are essential:
Full control, educational value, no cost. Cons: Time-consuming (30+ hours for a robust version), risk of hidden bugs, requires validation against benchmark examples. This public link is valid for 7 days
High-quality spreadsheets provide immediate feedback on the "Performance Ratio" of each check. If a ratio is greater than 1.0, the design is flagged as "NG!" (No Good), prompting the designer to adjust reinforcement spacing or length. MSE Wall Design Spreadsheet
Implement Load and Resistance Factor Design (LRFD) for higher reliability in structural and geotechnical calculations. Can’t copy the link right now
Ensures the overturning moment caused by the retained soil is less than the restoring moment.
Generate tables of required reinforcement length, spacing, and strength for varying wall heights – useful for preliminary design and cost estimation.
To make your MSE wall design spreadsheet professional, reliable, and auditable, follow these layout rules:
Not all spreadsheets are equal. A high-quality MSE wall design tool should include: