Aashto Flexible Pavement Design Excel Spreadsheet ^new^ Jun 2026

Can be estimated from the California Bearing Ratio (CBR) using the empirical relationship: Layered Design and the Structural Number Equation Once the spreadsheet calculates the required total SNcap S cap N , you must select layer thicknesses. The total SNcap S cap N is the sum of the capacities of the individual layers:

Write out the long mathematical formula for the right side of the equation in an adjacent cell, referencing the SNestcap S cap N sub e s t end-sub cell and all other inputs.

Spreadsheets typically include a dedicated tab to convert Average Daily Traffic (ADT) into design ESALs. 2. Reliability ( ) and Standard Normal Deviate ( ZRcap Z sub cap R

To construct an effective AASHTO flexible pavement design Excel spreadsheet, your workbook must accommodate five primary categories of inputs. 1. Traffic Characterization ( W18cap W sub 18

Choose a level (e.g., 95% for interstates, 85% for collectors). aashto flexible pavement design excel spreadsheet

Typically ranges from 0.40 to 0.50 for flexible pavements.

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 center dot cap S sub 0 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 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 center dot log base 10 of open paren cap M sub cap R close paren minus 8.07 Key Design Variables W18cap W sub 18

You can quickly adjust layer thicknesses (e.g., swapping a thicker base for a thinner subbase) to find the most cost-effective design .

While modern design has shifted toward the AASHTOWare Pavement ME (Mechanistic-Empirical) software, the 1993 empirical method remains a standard for many local agencies, private consultancies, and educational institutions due to its transparency and ease of use. Can be estimated from the California Bearing Ratio

Then check subbase similarly. Use =CEILING() to round up to 0.5 inch.

If you are developing your own template, consider adding a . This allows you to input material unit costs so the spreadsheet can automatically determine the most cost-effective combination of asphalt, base, and subbase thicknesses that still satisfies the required Structural Number. To help me tailor or provide a template, tell me:

cap S cap N sub p r o v i d e d end-sub equals open paren a sub 1 center dot cap D sub 1 close paren plus open paren a sub 2 center dot cap D sub 2 center dot m sub 2 close paren plus open paren a sub 3 center dot cap D sub 3 center dot m sub 3 close paren The design is "Adequate" if the provided cap S cap N meets or exceeds the required cap S cap N Key Benefits of Using a Spreadsheet Aashto Guide For Design Of Pavement Structures - CLaME

SN=(a1×D1)+(a2×D2×m2)+(a3×D3×m3)cap S cap N equals open paren a sub 1 cross cap D sub 1 close paren plus open paren a sub 2 cross cap D sub 2 cross m sub 2 close paren plus open paren a sub 3 cross cap D sub 3 cross m sub 3 close paren Variable Breakdown Traffic Characterization ( W18cap W sub 18 Choose

Serviceability defines the functional riding quality of the road surface on a scale from 0 (impassable) to 5 (perfect). Typically 4.2 for flexible pavements. Terminal Serviceability (

The sheet enforces minimum thickness requirements specified by AASHTO to prevent local shear failures. Advantages of Using Excel for Pavement Design

: A macro or manual command that adjusts an experimental SNcap S cap N