Aashto Flexible Pavement Design Excel Spreadsheet [work] [720p – 480p]
An AASHTO flexible pavement design Excel spreadsheet is an indispensable tool for geotechnical and transportation engineers. By accurately capturing the 1993 AASHTO design equation, engineers can optimize pavement structures, ensuring durability while managing costs.
Since SN_total (3.87) > SN_required (3.65), the design satisfies the AASHTO structural requirement.
) : Typically ranges from 0.40 to 0.50 for flexible pavements. 3. Serviceability ( Initial Serviceability (
Using an automates these complex calculations. Automation saves time and reduces human error. The Core AASHTO 1993 Design Equation
Use IF statements to flash warnings if calculated thicknesses fall below agency minimums. aashto flexible pavement design excel spreadsheet
Since $SN$ appears on both sides of the main equation, use :
cap S cap N equals a sub 1 cap D sub 1 plus a sub 2 cap D sub 2 m sub 2 plus a sub 3 cap D sub 3 m sub 3 Description Layer Coefficients Empirical values for asphalt (e.g., ), base, and subbase. Drainage Coefficients Factor based on the quality of drainage (typically Thicknesses (inches) The actual thickness of each pavement layer. 4. Excel Implementation via Goal Seek cap S cap N
is determined, it is translated into individual layer thicknesses ( ) using structural layer coefficients ( ) and drainage modifiers ( Layer Coefficients (
The standard AASHTO design equation for flexible pavements is: An AASHTO flexible pavement design Excel spreadsheet is
Free spreadsheets available online vary widely in quality. Some contain formula errors, incorrect unit conversions, or inadequate validation. Engineers should test any downloaded spreadsheet against known example problems before using it for actual design work.
in the main AASHTO equation to find the structural number needed above the base. Calculate the minimum surface layer thickness: . Round up to the nearest half-inch. Find SN2cap S cap N sub 2 : Use the resilient modulus of the subbase material ( Esubbasecap E sub s u b b a s e end-sub ) in place of MRcap M sub cap R
log10(W18)=ZR×S0+9.36×log10(SN+1)−0.20+log10[ΔPSI4.2−1.5]0.40+1094(SN+1)5.19+2.32×log10(MR)−8.07log 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 W18cap W sub 18
), you must determine the actual thicknesses of the individual pavement layers using the following relationship: ) : Typically ranges from 0
The spreadsheet should allow for calculating individual layer thicknesses based on the total SN:
appears on both sides of the main equation, it cannot be solved directly. Enter your inputs in one column. In a "Calculated
Estimate the total number of 18-kip Equivalent Single Axle Loads (ESALs) expected over the pavement's design life. This requires: