Aashto Flexible Pavement Design Excel Spreadsheet ((better)) Site

The structural number ($SN$) is solved iteratively using: $$\log_10(W_18) = Z_R \cdot S_o + 9.36 \cdot \log_10(SN + 1) - 0.20 + \frac\log_10[\frac\Delta PSI4.2 - 1.5]0.40 + \frac1094(SN + 1)^5.19 + 2.32 \cdot \log_10(M_R) - 8.07$$

| Parameter | Typical Range | Excel Cell Example | | :--- | :--- | :--- | | Reliability (R%) | 50% - 99.9% | B4 = 90 | | Standard Deviation (So) | 0.35 - 0.50 | B5 = 0.45 | | Initial PSI | 4.2 – 4.5 | B6 = 4.2 | | Terminal PSI | 2.0 – 2.5 | B7 = 2.5 | | ΔPSI | (Initial – Terminal) | B8 = B6 - B7 | | Resilient Modulus MR (psi) | 3,000 – 30,000 | B9 = 5000 | | 18-kip ESALs (W₁₈) | 10^4 – 10^7 | B10 = 2.5E6 | aashto flexible pavement design excel spreadsheet

A professional-grade spreadsheet is organized into three clear sections: , Calculations , and Outputs . The structural number ($SN$) is solved iteratively using:

: Offered by the CMHA , this free program uses the AASHTO 1993 methodology specifically for base design in interlocking concrete pavements. 000 – 30