IL Engineering Spreadsheets

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 3.7 12-13 ILSS02Waterway_v3_7.xlsb Excel Grassed Waterway - 412
Diversion - 362
EFH2 Hydrology 2.52 10-03 ILSS03HydrologyEFH2_v2_52.xls Excel many
Open Channel Flow 1.08 1-10 ILSS04OpenChannelFlow_v1_08.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
Stream Stabilization 3.4 5-13 ILSS06StreamStabilization_v3_5.xls Excel

Streambank and Shoreline Protection - 580
Stream Habitat Improvement and Management - 395






Pipeline - 516

Vegetated Treatment Area 3.4 9-09 ILSS08VTA_v3_4.xls Excel Vegetated Treatment Area - 635
Roof Runoff 2.4 4-14 ILSS09Roof_Runoff_v2_4 Excel Roof Runoff Structure - 558


Other Software



Animal Waste Management system component design

[ZIP; 8.21 MB]

Hydrology using method described in NRCS Engineering Field Handbook, Chapter 2. Data file 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.


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

Last Updated:April 10, 2014

Ruth Book, State Conservation Engineer