Aashto Flexible Pavement Design Excel Spreadsheet _verified_ Jun 2026

print(generate_aashto_excel_guide()) Use code with caution. Copied to clipboard PAVEMENT DESIGN GUIDE | TN.gov

in Excel, you must create a formula that calculates the "difference" between the left and right sides of the equation. Create a Cell for cap S cap N : Assign a cell (e.g., ) for the unknown cap S cap N . Input an initial guess (e.g., 3.0). Calculate the Left Side (LS) =LOG10(W18) Calculate the Right Side (RS) : Use the full AASHTO equation, referencing the cap S cap N ) and other input cells. Difference Cell : Create a cell for Use Goal Seek Data > What-If Analysis > Goal Seek . Set the "Difference Cell" to value by changing the cap S cap N Capitol Region Council of Governments (CRCOG) (.gov) 3. Determine Layer Thicknesses Once the required cap S cap N aashto flexible pavement design excel spreadsheet

To produce a spreadsheet for AASHTO 1993 flexible pavement design print(generate_aashto_excel_guide()) Use code with caution