Aashto Flexible Pavement Design | Excel Spreadsheet

This document outlines the specifications for a Microsoft Excel spreadsheet tool created to automate the design of flexible (asphalt) pavements. The tool utilizes the AASHTO 1993 Design Equation to calculate the required Structural Number ($SN$) and subsequently determines the thickness of individual pavement layers (Surface, Base, and Sub-base). The spreadsheet includes input sections for traffic data, material properties, environmental factors, reliability parameters, and an output summary with a design check.

log10(W18)=ZR⋅S0+9.36⋅log10(SN+1)−0.20+log10[ΔPSI4.2−1.5]0.40+1094(SN+1)5.19+2.32⋅log10(MR)−8.07log base 10 of open paren cap W sub 18 close paren equals cap Z sub cap R center dot cap S sub 0 plus 9.36 center dot log base 10 of open paren cap S cap N plus 1 close paren minus 0.20 plus the fraction with numerator log base 10 of open bracket the fraction with numerator cap delta cap P cap S cap I and denominator 4.2 minus 1.5 end-fraction close bracket and denominator 0.40 plus the fraction with numerator 1094 and denominator open paren cap S cap N plus 1 close paren to the 5.19 power end-fraction end-fraction plus 2.32 center dot log base 10 of open paren cap M sub cap R close paren minus 8.07 Key Design Inputs aashto flexible pavement design excel spreadsheet

To iterate and find the SN that balances both sides of the equation. VLOOKUP Tables: To automatically pull layer coefficients ( This document outlines the specifications for a Microsoft

Flexible pavement design is a critical aspect of transportation engineering, and the AASHTO 1993 Guide remains the industry standard for many agencies. Using an Excel spreadsheet to automate these complex empirical calculations ensures accuracy and saves hours of manual computation. log10(W18)=ZR⋅S0+9

log₁₀(W₁₈) = Z_R * S_o + 9.36 * log₁₀(SN+1) - 0.20 + [log₁₀(ΔPSI / (4.2-1.5))] / [0.40 + (1094/(SN+1)^5.19)] + 2.32 * log₁₀(M_R) - 8.07

This report details the development, methodology, and application of an Excel spreadsheet designed to perform flexible pavement structural design in accordance with the .