Aashto Flexible Pavement Design Excel Spreadsheet !link! Link
To produce a spreadsheet for AASHTO 1993 flexible pavement design
, you must implement the empirical relationship between traffic, soil properties, and pavement thickness. The core objective is to calculate the Structural Number ( cap S cap N
, which represents the overall strength required for the pavement layers to withstand the design traffic. 1. The Core Design Equation The following equation from the AASHTO Guide for Design of Pavement Structures is used to solve for cap S cap N
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 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 2. Required Input Parameters
To set up your Excel sheet, create input cells for these variables: Design Traffic ( cap W sub 18
The predicted cumulative 18-kip Equivalent Single Axle Loads (ESALs) over the design life. Reliability ( aashto flexible pavement design excel spreadsheet
The probability that the pavement will perform its intended function (e.g., for interstate highways). Standard Normal Deviate ( cap Z sub cap R In Excel, use =NORM.S.INV(R/100) Overall Standard Deviation ( cap S sub o Typically ranges from for flexible pavements. Serviceability Loss ( cap delta cap P cap S cap I The difference between initial serviceability ( ) and terminal serviceability ( Resilient Modulus ( cap M sub cap R A measure of the subgrade soil stiffness, typically in psi. 3. Layer Thickness Calculation Once the required cap S cap N
is determined, you can design the individual layer thicknesses using the following relationship:
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
appears on both sides of the main equation, it cannot be solved directly. Enter your inputs in one column. In a "Calculated
" cell, type the long AASHTO formula, referencing a temporary guess cell for cap S cap N Data > What-If Analysis > Goal Seek Set the "Calculated " cell to a equal to the log base 10 of of your actual cap W sub 18 cap S cap N guess cell. Final Answer To produce a spreadsheet for AASHTO 1993 flexible
The AASHTO flexible pavement design spreadsheet calculates the required Structural Number ( cap S cap N
by iteratively solving the empirical performance equation using Excel's function. This cap S cap N is then used to determine the necessary thicknesses ( cap D sub i ) of the surface, base, and subbase layers. table of layer coefficients ) for different materials like asphalt or crushed stone? generate_aashto_excel_guide
# AASHTO Flexible Pavement Design (1993) Spreadsheet Guide
To build a functional AASHTO 1993 Flexible Pavement Design spreadsheet, you need to implement the core empirical equation that relates traffic ($W_18$), reliability ($Z_R$), overall standard deviation ($S_o$), structural number ($SN$), and the change in serviceability ($\Delta PSI$).
For End Users:
- Validate against known examples (e.g., AASHTO 1993 Appendix D, Example 1).
- Enable iterative calculation (File → Options → Formulas → Enable iterative, max iterations 1000).
- Never use for >15 million ESALs – beyond 1993 calibration range.
- Consider MEPDG for major interstate projects – spreadsheet oversimplifies.
7. Comparison with Alternatives
| Tool | Pros | Cons | |------|------|------| | Excel Spreadsheet | Transparent, free, flexible | No seasonal/mechanistic, easy to break formulas | | PaveXpress (web) | Guided inputs, AASHTO 1993/2017, no install | Internet required, limited sensitivity | | AASHTOWare Pavement ME | MEPDG, climate, traffic spectra | Steep learning curve, expensive (>$5k/year) | | PavementDesigner.org | Free, 1993 method, layer optimization | Less customization, no VBA | Validate against known examples (e
Step 4: Propose Layer Thicknesses
Enter trial thicknesses for asphalt (( D_1 )), base (( D_2 )), and subbase (( D_3 )).
Keywords
AASHTO, flexible pavement, Excel spreadsheet, structural number, ESAL, layer coefficients, pavement design, subgrade R-value, reliability
3. Spreadsheet Structure
The Excel file is organized into four primary worksheets:
5.4 Layer Thickness Optimization
Add a Solver model to minimize total pavement cost (material costs per inch) subject to:
- SN_provided ≥ SN_required
- D₁ ≥ 2 inches
- D₂ ≥ 6 inches
- D₃ ≥ 6 inches