Skip

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.8 8-18 ILSS02Waterway_v3_8.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 3.4 9-09 ILSS08VTA_v3_4.xls Excel
Roof Runoff 2.4 4-14 ILSS09Roof_Runoff_v2_4 Excel

 

Other Software

Description

AWM

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.

HEC-RAS

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

Last Updated:August 18, 2014

Questions
Ruth Book, State Conservation Engineer