Where the spreadsheet must solve for iteratively, given:
Sub SolveForSN() Range("A22").GoalSeek Goal:=0, ChangingCell:=Range("A20") MsgBox "Required SN = " & Round(Range("A20").Value, 3) End Sub
A complete design suite includes multiple, interconnected spreadsheets that cover the full range of necessary calculations. This may include modules for estimating the subgrade resilient modulus from soil properties, calculating traffic ESALs from survey data, and performing the core design calculations, saving engineers time and ensuring a thorough analysis.
): Accounts for chance variations in traffic predictions and material properties. For flexible pavements, a value of 0.45 is standard. 3. Serviceability Index ( aashto flexible pavement design excel spreadsheet
SNart=(a1×D1)+(a2×D2×m2)+(a3×D3×m3)≥SNreqcap S cap N sub a r t end-sub 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 is greater than or equal to cap S cap N sub r e q end-sub D1cap D sub 1 = Surface layer thickness (inches) D2cap D sub 2 = Base layer thickness (inches) D3cap D sub 3 = Subbase layer thickness (inches) Phase 3: Minimum Thickness Constraints
Weeks later, Elias stood on-site as the pavers rolled out the first steaming mat of asphalt. The spreadsheet stayed on his laptop in the truck, a silent blueprint that had turned hours of manual math into a few clicks of confidence.
:
The spreadsheet is a powerful tool because it automatically calculates the required total SN based on several critical input parameters. Key inputs include the predicted number of representing expected traffic, the subgrade Resilient Modulus (MR) (a measure of soil support strength), the design Reliability (R) and overall standard deviation (So) which account for variability in traffic and performance predictions, the loss in serviceability (ΔPSI) that the pavement experiences over its design life, and the drainage coefficients (mi) for each layer to account for water infiltration. Once the required structural number is determined, the spreadsheet allows engineers to test various layer thickness combinations to ensure the pavement's total structural number meets or exceeds the requirement.
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
variable appears on both sides of the equation and is raised to a power, it cannot be isolated algebraically. Engineers must solve it using iterative trial-and-error methods, charts (nomographs), or computational tools like Excel. Key Input Parameters for the Excel Spreadsheet Where the spreadsheet must solve for iteratively, given:
The beast itself. The one that looked like a page from a spell book:
Values representing the structural contribution of each material (e.g., for new asphalt). How the Excel Spreadsheet Works
Required SN = 4.5 (example).
Once your spreadsheet successfully converges on the required Structural Number ( SNreqcap S cap N sub r e q end-sub
Comprehensive Guide to AASHTO Flexible Pavement Design Excel Spreadsheets