United States Department of Agriculture
Natural Resources Conservation Service		 Illinois Go to Accessibility Information
Skip to Page Content



Illinois Engineering Spreadsheets

NOTICE – The following engineering spreadsheets have been developed to assist in the design of typical NRCS engineering practices in Illinois. Before using any of the spreadsheet designs, the designer should verify that the design complies with NRCS standards and that the standard applies to the site. The designer should also verify that the design limitations are not exceeded. All designs shall be reviewed and approved by qualified individuals with appropriate engineering approval authority. All spreadsheets have macros.

Spreadsheet Software
Topic Ver Date Spreadsheet Software File Type Possible Applicable Standards
Terraces 2.08 7-04 ILSS01Terrace_v2_08.xls Excel Terrace - 600
Underground Outlet - 620
WASCOB - 638
Waterways 2.01 2-08 ILSS02Waterway_v2_01.xls Excel Grassed Waterway - 412
Diversion - 362
EFH2 Hydrology 2.52 10-03 ILSS03HydrologyEFH2_v2_52.xls Excel many
Open Channel Flow 1.07 1-06 ILSS04OpenChannelFlow_v1_07.xls Excel many
Floodrouting 1.0 11-02 ILSS05FloodRouting_v1_0.xls Excel Constructed Wetland - 656
Wetland Creation - 658
Shallow Water Management For Wildlife -  646
NEW Update!
Stream Stabilization		 3.2 5-08 ILSS06StreamStabilization_v3_2.xls Excel

Streambank and Shoreline Protection - 580

Pipeline

1.14

10-03

ILSS07Pipeline_v1_14.xls

 Excel

Pipeline - 516
Vegetated Treatment Area 3.3 11-08 ILSS08VTA_v3_3.xls Excel Vegetated Treatment Area - 635
   
Other Software

Description
AWM

Animal Waste Management system component design
EFH2
[ZIP; 8.21 MB]

Hydrology using method described in NRCS Engineering Field Handbook, Chapter 2. Data file county.il is to be placed in the EFH2 directory (c:\Program Files\USDA\EFH2).
Hydraulics Formula
[ZIP; 4.29MB]

Solutions to hydraulic equations frequently encountered in soil and water conservation activities.
H&H Tools and Models

Hydraulics and hydrology tools and models supported by NRCS, including TR-55, SITES, TR-20.
HEC-RAS

US Army Corps of Engineers Hydraulic Engineering Center River Analysis System model.

Last Updated:January 30, 2009

Questions Contact:
Ruth Book, State Conservation Engineer