Create a data table that varies M_R and ESALs simultaneously. Use Excel’s Data Table feature to generate a 2D matrix of required SN. Then use conditional formatting (color scales) to highlight risk zones.
The output SN is then broken down into layer thicknesses: aashto flexible pavement design excel spreadsheet
[ SN = a_1 D_1 + a_2 D_2 m_2 + a_3 D_3 m_3 ] Create a data table that varies M_R and ESALs simultaneously
An Excel spreadsheet’s primary job is to solve for SN (via iteration or goal seek) and then determine the minimum feasible layer thicknesses given material constraints. An Excel spreadsheet’s primary job is to solve
Add a Solver model to minimize total pavement cost (material costs per inch) subject to:
Create a hidden or adjacent table for layer coefficients:
| Material | Layer Coefficient (aᵢ) | | :--- | :--- | | Dense-graded HMA | 0.40 – 0.44 | | Crushed stone base | 0.14 | | Gravel base | 0.12 | | Sand-gravel subbase | 0.10 |