To help tailor this guide or assist with your specific calculations, let me know:
Marcus released MSE-Wall-Pro v1.0 internally. Within three months, it was used on five projects. He added a seismic module after a small earthquake hit a neighboring county. He added a “reinforcement layout optimizer” that minimized geogrid length while satisfying all safety factors — saving $8,000 in materials per wall on average. He added a construction checklist tab for field inspectors. mse wall design spreadsheet
Ensuring the entire slope, including the wall, does not fail in a deep-seated, rotational manner (often validated with additional software, but initial checks are done in the spreadsheet). B. Internal Stability (Safety Within the Reinforced Mass) To help tailor this guide or assist with
– For modular block walls, the connection between reinforcement and facing unit must be checked. Spreadsheets use manufacturer-provided connection capacity curves. Best Practices for Developing Excel-Based Tools
: The spreadsheet outputs the exact lengths of geogrid needed, which the CAD team uses to generate construction drawings .
The philosophy was simple: transparency, traceability, and automation. Every input would be a named range. Every equation would include a comment citing the AASHTO clause. Every intermediate result would be visible, not hidden in some macro.
Pr=2⋅Le⋅σv⋅F*⋅α⋅Rccap P sub r equals 2 center dot cap L sub e center dot sigma sub v center dot cap F raised to the * power center dot alpha center dot cap R sub c F*cap F raised to the * power = Pullout friction factor = Scale correction factor Rccap R sub c = Reinforcement coverage ratio 4. Best Practices for Developing Excel-Based Tools