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:

A very specific topic!

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. aashto flexible pavement design excel spreadsheet

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) An Excel spreadsheet can be a great tool

| 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))))) | where: W = number of 18-kip ESALs (equivalent