Tools
Schedules
The following tools assist the designer in creating project and award schedules:
CPM Tips (Acrobat, 212 KB) - provides helpful tips to assist designers in developing realistic CPM schedules for their projects- CPMs Made Easy (Acrobat, 725 KB) - instructions for developing a proposed construction schedule in Microsoft Project
PS&E to Notice-to-Proceed Calculator (Excel, 84 KB) - Calculator to determine the number of days required from the delivery of a completed PS&E package to the Contracts Section until a Notice-to-Proceed may be issued for Construction. (Rev. 11/2006)
Fuel Escalation
The Fuel Escalation Worksheet (Excel, 84 KB) calculates the asphalt and fuel adjustments.
File Name Generator
The File Name Generator provides filenames that follow the WFLHD naming convention.
Roadway Geometry
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. 4/2007)
- 2001 Green Book (Excel, 178 KB) (Rev. 10/2004)
- 1994 Green Book (Excel, 339 KB) (Rev. 5/2001)
- Maximum Relative Gradient Checker (Excel, 219 KB) - checks Geopak shape input file for actual Maximum Relative Gradient on superelevation runoff. (Rev. 6/2006)
Curve Widening
Calculates curve widening for various design vehicles.
- 2004 Green Book (Excel, 74 KB) (Rev. 9/2007)
- 2001 Green Book (Excel, 72 KB) (Rev. 1/2004)
- 1994 Green Book (Excel, 55 KB) (Rev. 3/2002)
Profile grades (Excel, 54 KB) - calculates grades, "K" values, and design speeds. (Rev. 8/2003)