Aashto Flexible Pavement Design Excel Spreadsheet =link=

AASHTO Flexible Pavement Design Method:

3.4 Output Section

• Required SN (from Goal Seek)
• Proposed Layer Thicknesses (D₁, D₂, D₃) rounded up to nearest 0.5 inch
• Provided SN (must be ≥ Required SN)
• Cost Estimate (optional)

A standard AASHTO spreadsheet evaluates six critical inputs to determine the required Structural Number (SN) aashto flexible pavement design excel spreadsheet

Step 1: Set Up Your Workbook

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

Inputs from traffic analysis:

Mara opened the folder. Inside were soil reports, traffic counts (a hefty 20% truck traffic), and climate data showing three distinct freeze-thaw cycles per winter. Standard stuff. But Hank had written in red marker across the top: No black boxes. Show your work. AASHTO Flexible Pavement Design Method: 3

An Excel spreadsheet can be a great tool for implementing the AASHTO flexible pavement design equations and calculations. Here's a helpful post on the topic: Required SN (from Goal Seek) Proposed Layer Thicknesses

Do you have a specific traffic volume or soil CBR value you’d like to test in a design scenario?