Cookie
Electronic Team uses cookies to personalize your experience on our website. By continuing to use this site, you agree to our cookie policy. Click here to learn more.
SHOPPING CART

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:

| 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))))) |

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

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.

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)

Get 50% OFF

Owners of a previous version of this product get 50% discount to upgrade to the latest one.

Software Local Reseller

Find a local reseller of USB Network Gate and get all advantages and benefits from the software usage. Find out more

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:

| 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))))) |

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

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.

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)