Pavement Design Excel Spreadsheet — Aashto Flexible

AASHTO Flexible Pavement Design Using an Excel Spreadsheet

1. Introduction

The AASHTO (American Association of State Highway and Transportation Officials) flexible pavement design method, based on the 1993 AASHTO Guide for Design of Pavement Structures, remains a widely used empirical approach for determining the required thickness of asphalt pavement layers. While more modern mechanistic-empirical methods exist, the AASHTO 1993 method is still preferred by many agencies for its simplicity, familiarity, and reliable performance when calibrated locally.

Mara smiled. Her spreadsheet — built line by line, conditional format by conditional format — was going to build a road. A road that would freeze, thaw, carry logging trucks and minivans, and not crack for twenty years. Because a little green glow from a carefully built cell is sometimes more reliable than a black box. aashto flexible pavement design excel spreadsheet

She saved the file. Then, remembering Hank’s paranoia, she clicked File > Save As > PDF. She printed the Inputs, Equation Check, Layer Calculation, and Summary tabs. Staple. AASHTO Flexible Pavement Design Using an Excel Spreadsheet

She hit “Calculate Required SN” (Structural Number). The spreadsheet hummed — no fancy animations, just the soft click of Excel recalculating. Mara smiled

MR (Resilient Modulus): A measure of the subgrade soil's stiffness. Essential Features of a Design Spreadsheet