Aashto: Flexible Pavement Design Excel Spreadsheet Link

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:

To construct an effective AASHTO flexible pavement design Excel spreadsheet, your workbook must accommodate five primary categories of inputs. 1. Traffic Characterization ( W18cap W sub 18

The difference between initial smoothness (roughly 4.2) and terminal serviceability (2.0–2.5) before major repairs are needed. Resilient Modulus ( cap M sub cap R A measure of subgrade soil strength and stiffness. Layer Coefficients ( aashto flexible pavement design excel spreadsheet

The fundamental output of the AASHTO method is the Structural Number (SN), an index that represents the total pavement thickness and strength required to withstand the predicted traffic loads over the design life. The SN is calculated using the following equation:

Because the equation is implicit, you must use Excel's optimization features to find the correct Structural Number. Here is a step-by-step breakdown of how a typical AASHTO design spreadsheet functions under the hood: Create dedicated cells for user inputs ( W18cap W sub 18 ZRcap Z sub cap R S0cap S sub 0 MRcap M sub cap R The AASHTO 1993 method is empirical, based on

) : Structural values per inch of thickness for the surface, base, and subbase materials. Drainage Coefficients (

[SN = a_1 D_1 + a_2 D_2 m_2 + a_3 D_3 m_3] Layer Coefficients ( The fundamental output of the

Estimate the total number of 18-kip Equivalent Single Axle Loads (ESALs) expected over the pavement's design life. This requires: