This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
where: W = number of 18-kip ESALs (equivalent single axle loads) Zr = standard normal variable (e.g., 1.28 for 90% reliability) S0 = overall standard deviation (e.g., 0.45) SN = structural number (a measure of pavement strength) p = pavement serviceability index (e.g., 2.5)
A high-quality spreadsheet will implement or iterative circular references to solve for SN, not just forward calculations.
This paper presents the development of an Excel-based tool implementing the AASHTO flexible pavement design procedure (1993 interim guide / 1993 AASHTO Guide or calibrated mechanistic-empirical approach — assume 1993 interim guide unless specified). The spreadsheet automates computations for ESALs, structural number (SN) determination, layer coefficient selection, drainage and subgrade resilient modulus adjustments, traffic and reliability factors, and thickness design for multiple pavement sections. Validation against sample problems from the AASHTO Guide shows close agreement. Example applications demonstrate sensitivity to axle load, subgrade R-value, and layer coefficients. The tool aids engineers by offering transparent calculations, scenario analysis, and rapid iteration for preliminary design and teaching. aashto flexible pavement design excel spreadsheet
AASHTO Table 6.2 (mᵢ):
The spreadsheet must also enforce agency-mandated to ensure the asphalt can be compacted properly in the field. Setting Up the Excel Sheet (Step-by-Step)
Once the total required Structural Number is determined, the designer must distribute this strength across multiple pavement layers using the layer coefficient equation: This public link is valid for 7 days
, which represents the total strength needed for the pavement layers: Traffic Loading ( cap W sub 18
While Excel spreadsheets are the most accessible and widely used tool for this method, several software alternatives are available:
Update your spreadsheet to auto-calculate aᵢ when E_BS changes. Can’t copy the link right now
The AASHTO 1993 method is empirical, based on the specific materials, climate, and loading conditions of the AASHO Road Test. Applying the method—and any spreadsheet implementing it—to conditions outside these bounds requires careful engineering judgment. Key limitations include:
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
The difference between initial and terminal serviceability.