Aashto Flexible Pavement Design Excel Spreadsheet -

Title

AASHTO Flexible Pavement Design Excel Spreadsheet: Development, Validation, and Application

• a₁, a₂, a₃ = Layer coefficients (asphalt, base, subbase)
• D₁, D₂, D₃ = Thickness (inches)
• m₂, m₃ = Drainage coefficients

Step 1: Set Up Your Workbook

• Sheet 1: “Input & Design”
• Sheet 2: “Material Library”
• Sheet 3: “Chart Output”

6. Example Applications

• Case 1: Low-volume rural road — show inputs, computed ESALs, SN, chosen layer thicknesses, and sensitivity to R-value ±10%.
• Case 2: High-volume arterial — show effect of increased ESALs and reliability on required HMA thickness.
• Include charts: ESAL accumulation vs year, SN vs R-value, thickness breakdown bar chart.