Designing flexible pavement requires careful consideration of numerous factors, including traffic loads, soil properties, material characteristics, and environmental conditions. The American Association of State Highway and Transportation Officials (AASHTO) provides a structured methodology—primarily the 1993 AASHTO Guide for Design of Pavement Structures—that has long been the industry standard.
Furthermore, engineers must ensure their spreadsheets are based on the correct units (imperial vs. metric) and the specific variations of the AASHTO equation adopted by their local Department of Transportation (DOT), as many states adapt the national guidelines to local climates and materials.
log base 10 of open paren cap W sub 18 close paren equals cap Z sub cap R cross cap S sub 0 plus 9.36 cross log base 10 of open paren cap S cap N plus 1 close paren minus 0.20 plus the fraction with numerator log base 10 of open bracket the fraction with numerator cap delta cap P cap S cap I and denominator 4.2 minus 1.5 end-fraction close bracket and denominator 0.40 plus the fraction with numerator 1094 and denominator open paren cap S cap N plus 1 close paren to the 5.19 power end-fraction end-fraction plus 2.32 cross log base 10 of open paren cap M sub cap R close paren minus 8.07 2. Key Input Variables Needed in the Spreadsheet aashto flexible pavement design excel spreadsheet
Accounts for variability in traffic predictions and material properties. Typically ranges from 0.40 to 0.50 for flexible pavements. A value of 0.45 is standard for most highway designs. 4. Serviceability Loss ( ΔPSIcap delta cap P cap S cap I Measures the drop in ride quality over time. Typically 4.2 for flexible pavements. Terminal Serviceability (
Enter the M_R value into the designated cell in the spreadsheet. metric) and the specific variations of the AASHTO
Required SN = 4.2
log base 10 of open paren cap W sub 18 close paren equals cap Z sub cap R center dot cap S sub o plus 9.36 center dot log base 10 of open paren cap S cap N plus 1 close paren minus 0.20 plus the fraction with numerator log base 10 of open paren the fraction with numerator cap delta cap P cap S cap I and denominator 4.2 minus 1.5 end-fraction close paren and denominator 0.40 plus the fraction with numerator 1094 and denominator open paren cap S cap N plus 1 close paren to the 5.19 power end-fraction end-fraction plus 2.32 center dot log base 10 of open paren cap M sub cap R close paren minus 8.07 1. Define Input Parameters Set up your spreadsheet with the following input cells: Federal Highway Administration (.gov) cap W sub 18 Typically ranges from 0
, the smoothness at construction) and terminal serviceability ( Ptcap P sub t , when the road requires rehabilitation).
Whether using a free or commercial spreadsheet, the following step-by-step methodology will guide you through the design process:
The AASHTO 1993 flexible pavement design procedure uses an empirical equation to determine a Structural Number ( cap S cap N