Aashto Flexible Pavement Design Excel Spreadsheet

Where:

Average Daily Traffic (ADT), percentage of heavy trucks, growth rate, design period (typically 20 years), and directional/lane distribution factors. Output: Total cumulative W18cap W sub 18 for the design lane. 2. Reliability ( ) and Standard Error ( S0cap S sub 0

) : Structural values per inch of thickness for the surface, base, and subbase materials. Drainage Coefficients ( aashto flexible pavement design excel spreadsheet

): The point at which the road requires rehabilitation. Usually 2.5 or 3.0 for major highways, and 2.0 for local roads. : Evaluated as 4. Subgrade Resilient Modulus ( MRcap M sub cap R

Select the design reliability level based on road functional classification: Where: Average Daily Traffic (ADT), percentage of heavy

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

While modern design has shifted toward the AASHTOWare Pavement ME (Mechanistic-Empirical) software, the 1993 empirical method remains a standard for many local agencies, private consultancies, and educational institutions due to its transparency and ease of use. Reliability ( ) and Standard Error ( S0cap

In Excel 2010, it's File->Options->Add-ins->click on [Go…] Button at the bottom by "Manage Excel Add-ins", then select Solver Add- Capitol Region Council of Governments (CRCOG) (.gov) Flexible & Rigid pavement Design (Excel Program)

Reliability represents the probability that the pavement will survive its design life.