Highway Design Tools

The following spreadsheets are intended to assist Highway Design professionals in completing lines and grades. All results should be verified by a Professional Engineer. Unless otherwise stated the spreadsheets make use of AASHTO's A Policy on Geometric Design of Highways and Streets (the Green Book). Submit questions and commments to the address at the bottom of this page. All spreadsheets are provided as-is.

Superelevation and Runoff Lengths - calculates superelevation rates, runoff lengths, and optional spiral lengths for a given radius.

• 2004 Green Book  (Excel, 142 KB) (Rev. 3/2006)
• 2001 Green Book  (Excel, 174 KB) (Rev. 10/2004)
• 1994 Green Book  (Excel, 333 KB) (Rev. 5/2001)
• Maximum Relative Gradient Checker  (Excel, 217 KB) (Rev. 6/2006) - checks Geopak shape input file for actual Maximum Relative Gradient on superelevation runoff.

Curve Widening - calculates curve widening for various design vehicles.

• 2001 Green Book  (Excel, 70 KB) (Rev. 1/2004)
• 1994 Green Book  (Excel, 53 KB) (Rev. 3/2002)

Profile grades  (Excel, 51 KB) (Rev. 8/2003) - calculates grades, "K" values, and design speeds.