Skip Navigation

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
Terraces 2.08 7-04 ILSS01Terrace_v2_08.xls Excel
Waterways 3.9 9-14 ILSS02Waterway_v3_9.xlsb Excel
EFH2 Hydrology 2.52 10-03 ILSS03HydrologyEFH2_v2_52.xls Excel
Open Channel Flow 1.08 1-10 ILSS04OpenChannelFlow_v1_08.xls Excel
Floodrouting 1.0 11-02 ILSS05FloodRouting_v1_0.xls Excel
Stream Stabilization 3.4 5-13 ILSS06StreamStabilization_v3_5.xls Excel
Pipeline 1.14 10-03 ILSS07Pipeline_v1_14.xls Excel
Vegetated Treatment Area 4.1 8-16 ILSS08VTA_v4_1.xlsb Excel
Roof Runoff 2.4 4-14 ILSS09Roof_Runoff_v2_4 Excel
Mortality Composter Design 1.8 7-16 ILSS10Mortality_Composter_v1.8 Excel


Illinois NRCS Engineering Toolbox

Toolbox Version Date Supporting Documents
Illinois NRCS GIS Tools  1.1.2 7-15

 GIS Tool_User Guide V 112.pdf (PDF, 1 mb)
 LiDAR DATA Coordinate Systems .pdf (PDF, 228kb)
 LiDAR Status.pdf (PDF< 2mb)
 IL Bulletin 210-15-7.pdf (PDF, 66kb)


Other Software



Animal Waste Management system component design

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: August 11, 2016

Ruth Book, State Conservation Engineer