Menu
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.
At 3:00 AM, exhausted but satisfied, she filled out : aashto flexible pavement design excel spreadsheet
Add a Solver model to minimize total pavement cost (material costs per inch) subject to: This document outlines the specifications for a Microsoft
The core of the method is the following structural number (SN) equation: At 3:00 AM, exhausted but satisfied, she filled
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)
(Design Traffic): Total expected 18,000-lb over the design period. ZRcap Z sub cap R
A very specific topic!
