Aashto Flexible Pavement | Design Excel Spreadsheet
| Parameter | Value | Units | |-----------|-------|-------| | W18 (design ESALs) | 5,000,000 | – | | Reliability (R) | 90% | – | | Z_R (from table) | -1.282 | – | | S₀ | 0.40 | – | | ΔPSI | 2.0 | – | | MR (subgrade) | 5,000 | psi | Tip: Use NORM.S.INV(1-R) to auto-calculate Z_R from reliability. The main equation is:
Start with the basic AASHTO ’93 equation, layer in Goal Seek, and test it against a known example from the AASHTO Guide. aashto flexible pavement design excel spreadsheet
That’s where comes to the rescue.