Aashto Flexible Pavement Design Excel Spreadsheet May 2026

Challenge 1: The Iterative Nature of the SN Equation

Challenge 2: Units Consistency

Challenge 3: Drainage Coefficients ($m_i$) aashto flexible pavement design excel spreadsheet

Create a VBA button:

Sub SolveForSN()
    Range("A22").GoalSeek Goal:=0, ChangingCell:=Range("A20")
    MsgBox "Required SN = " & Round(Range("A20").Value, 3)
End Sub

Scenario: Design a flexible pavement overlay for a 2-lane rural highway. Challenge 1: The Iterative Nature of the SN Equation

Inputs from traffic analysis:

Spreadsheet computed: Required SN = 3.95 Challenge 2: Units Consistency

Layer selection:

Validation: Provided SN = 4.03 (>3.95). The spreadsheet also generated a cost comparison: using 6-inch asphalt with 8-inch base was $18,000 more per mile. The chosen design saved money.

| Cell | Input/Label | Description | Typical Value | | :--- | :--- | :--- | :--- | | B1 | Reliability (%) | $R$ | 85 - 95% | | B2 | Standard Normal Deviate | $Z_R$ | Calculated: =NORM.S.INV(B1/100) | | B3 | Standard Deviation | $S_o$ | 0.40 - 0.50 | | B4 | Initial Serviceability | $p_o$ | 4.2 - 4.5 | | B5 | Terminal Serviceability | $p_t$ | 2.0 - 3.0 | | B6 | Serviceability Loss | $\Delta PSI$ | =B4 - B5 | | B7 | Resilient Modulus | $M_R$ (psi) | Based on subgrade soil | | B8 | Design ESALs | $W_18$ | Cumulative 18-kip loads | | B9 | Required SN | Target | Solved via Goal Seek |

Enter layer coefficients and drainage coefficients for each layer.