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





Engineering SpreadsheetsEngineering Spreadsheets

 

NOTICE – The following engineering spreadsheets have been developed to assist in the design of typical engineering practices.  The designer should verify that the design complies with NRCS standards and that the standard applies to the site.  The designer must understand the assumptions and calculations contained in the spreadsheets and is responsible for their use.  Most if not all spreadsheets contain macros.

Many engineering spreadsheets are available for use.   CAD drawings are available in the Wisconsin engineering CAD drawings section.
 

These documents require Microsoft Excel.

     *Instructions for MS Excel 2007 Users  (PDF; 502 KB)

Description

Date
Area By Coordinate Method 4/25/05
Animal Units Calculator 3/14/08
Barnyard Evaluation Rating Tool (BERT) 11/28/11
Cross Section Plotting 3/14/08
Culvert Design 10/21/11
Culvert Protection (MN TR-3) 2/27/09
Drain Diaphragm Design 6/25/09
Estimated Fill Computations 12/1/04
Feed Storage Area Runoff - Treatment 2/27/09
Fence Specification 4/14/10
Flood Frequency USGS 2003 Method 8/31/11
Gradation (Riprap - EFH Chapter 17 Method) 12/1/04
Gradation (Rock Chute - EFH Chapter 6) 12/23/05
Grassed Waterway Design 11/1/11
Lakeshore Riprap Design Computations 4/1/99
Lined Waterway Design 6/6/07
Livestock Pipeline - Single Line 1/21/11
Livestock Pipeline - Multiple Spurs 1/6/11
Manning's N Applications (Trapezoidal and Circular) 12/1/04
Milking Center Waste Volume 12/23/05
Milking Center Wastewater Treatment - Buffer Process 2/22/10
Natural Channel Flow 3/27/07
Peak Discharge, EFH Chapter 2 Method 3/22/10
Pond 3/22/10
Pump Sizing 2/27/09
Quantities 2/24/12
Riprap Lined Plunge Pool for Cantilever Outlet (DN-6) 11/21/11
Riprap Lined Plunge Pool for Cantilever Outlet (ASABE) 2/29/12
Rock Chute 9/1/11
Roof Gutter Design 12/1/10
Roof Gutter Design (simple) 10/4/11
Seeding Sheet 11/18/11
Stadia Survey Notes Converted to N-E-Elevation 12/1/04
Streambank Protection 1/10/11
TR-55 Peak Runoff Calculation 12/1/10
Unit Conversions 4/8/11
Underground Outlet Design Computations 5/8/07
Vegetated Treatment Areas 3/4/11
Waste Storage Design 2/2/12

For more information on the Wisconsin Engineering Spreadsheets, email scott.mueller@wi.usda.gov

 

< Back to Engineering