Aashto Flexible Pavement Design Excel Spreadsheet Page

For those who may not be familiar, AASHTO (American Association of State Highway and Transportation Officials) provides guidelines for flexible pavement design, which is a widely used method for designing pavement structures.

| Calculations | | | --- | --- | | W (18-kip ESALs) | =(10^((1.28 0.45)+9.36 LOG10(SN+1)-4.14-0.20-0.372*((SN+1)^(1/3))/(2.5+1)))) | | SN | =(W/(10^((1.28 0.45)+9.36 LOG10(SN+1)-4.14-0.20-0.372*((SN+1)^(1/3))/(2.5+1))))) | aashto flexible pavement design excel spreadsheet

The AASHTO flexible pavement design method is based on the following equation: For those who may not be familiar, AASHTO

| Input Parameters | | | --- | --- | | Zr | 1.28 | | S0 | 0.45 | | p | 2.5 | | Design Life (years) | 20 | | Traffic Growth Rate (%/year) | 3 | | Number of Lanes | 2 | aashto flexible pavement design excel spreadsheet

An Excel spreadsheet can be a great tool for implementing the AASHTO flexible pavement design equations and calculations. Here's a helpful post on the topic:

where: W = number of 18-kip ESALs (equivalent single axle loads) Zr = standard normal variable (e.g., 1.28 for 90% reliability) S0 = overall standard deviation (e.g., 0.45) SN = structural number (a measure of pavement strength) p = pavement serviceability index (e.g., 2.5)

log10(W) = Zr * S0 + 9.36 * log10(SN+1) - 4.14 - 0.20 - 0.372 * (SN+1)^(1/3) / (p+1)