Once the required SN is found, the spreadsheet must satisfy the following inequality: : Layer coefficients. Dicap D sub i : Layer thicknesses (inches). : Drainage coefficients. Benefits of Using Excel for Pavement Design
variable appears on both sides of the equation, spreadsheets utilize the or Goal Seek feature to iteratively find the correct value. 🎛️ Essential Input Parameters for Spreadsheets
Sub SolveForSN() Range("A22").GoalSeek Goal:=0, ChangingCell:=Range("A20") MsgBox "Required SN = " & Round(Range("A20").Value, 3) End Sub
) : Statistical probability that the pavement will outlast its design life (typically 85% to 99% for interstates). Standard Normal Deviate ( ZRcap Z sub cap R aashto flexible pavement design excel spreadsheet
is calculated, the spreadsheet helps determine the thicknesses (D₁, D₂, D₃) of the asphalt concrete (a₁), base (a₂), and subbase (a₃) layers using the following formula:
The spreadsheet should automatically round layer thicknesses up to the nearest half-inch or full inch to reflect practical construction standards. Advantages of Using Excel for Pavement Design
If you are developing your own sheet, would you like to focus on the , or do you need help mapping material properties (like CBR) to layer coefficients ? Share public link Once the required SN is found, the spreadsheet
Serviceability measures a road's riding quality on a scale of 0 to 5. Typically 4.2 to 4.5 for new flexible pavements. Terminal Serviceability (
Flexible pavement design is a critical aspect of transportation engineering, and the AASHTO 1993 Guide remains the industry standard for many agencies. Using an Excel spreadsheet to automate these complex empirical calculations ensures accuracy and saves hours of manual computation.
log(W18)=ZRS0+9.36log(SN+1)−0.20+log(ΔPSI4.2−1.5)0.40+1094(SN+1)5.19+2.32log(MR)−6.24log open paren cap W sub 18 close paren equals cap Z sub cap R cap S sub 0 plus 9.36 log open paren cap S cap N plus 1 close paren minus 0.20 plus the fraction with numerator log 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 log open paren cap M sub cap R close paren minus 6.24 3. Determine Layer Thicknesses SNreqcap S cap N sub r e q end-sub Benefits of Using Excel for Pavement Design variable
The difference between initial and terminal serviceability.
A proper AASHTO spreadsheet is built around the fundamental empirical equation that predicts the number of 18,000 lb Equivalent Single Axle Loads ( W18cap W sub 18 ) a pavement can withstand. Design Traffic ( W18cap W sub 18
): Excel converts the reliability percentage into a statistical -score using the formula =NORM.S.INV(R/100) . Overall Standard Deviation ( S0cap S sub 0