Illinois Department of Transportation, Erica Borggren, Acting Secretary
Patrick J. Quinn, Governor
Traveling PublicMapsProjectsRoad ClosuresNewsDoing BusinessLetting & BiddingCareers@IDOTGeneral Info


Design and Construction Spreadsheets

The Geotechnical Spreadsheets have been developed by the Bureau of Bridges and Structures Foundations and Geotechnical Unit in an effort to simplify the work involved in Structure Geotechnical Reports and Foundation construction inspection.

Special Instructions: Users can download individual files to your hard drive by clicking the link with the right mouse button, and then choose "save target as". Files are in Microsoft Excel format. 

Spreadsheet Title Spreadsheet Description Revised Date
COFFERDAM SEAL COAT DESIGN Cofferdam seal coat design using the Bridge Manual Design Guide Procedure 3.13.3 issued Nov. 2006 04/24/14
INTEGRAL ABUTMENT FEASIBILITY ANALYSIS Integral Abutment Feasibility Analysis- All Bridge Designers 12.3 01/13/14
WSDOT PILE BEARING VERIFICATION WSDOT Formula Pile Driving Inspectors Chart/Graph 08/30/11
LIQUEFACTION Liquefaction Factor of Safety 05/24/10
SEISMIC SITE CLASS Seismic Site Class Determination 12/13/10
ESTIMATING PILE LENGTH IDOT Static Method of Estimating Pile Length vs. Resistance 10/18/11
BROM’S OVERTURNING & TORSIONAL SHAFT ANALYSIS Depth To Support Traffic Signals, Sign Structures and Light Poles/Towers Against Overturning and Torsional Loadings 01/29/12
SHEET PILE SECTIONS AND PROPERTIES List of known Sheet Pile Sections and Various Properties including (b/tmin), Sx, etc. 11/29/11


IDOT Privacy Statement | Illinois Privacy Information | Kids Privacy | Web Accessibility  | FOIA