Skip

Engineering Spreadsheets

Engineering 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)

Title

Description Date
Area By Coordinate Method Calculates cross-section area or plane surface based on manual input of X and Y coordinate pairs. 4/25/2005
Animal Units Calculator Calculates the total number of animal units based on animal type, number of animals, and average weight, using a 1,000-pound equivalent.  These calculations are needed to determine if a Wisconsin Pollutant Discharge Elimination System (WPDES) permit is needed (Wisconsin Administrative Code NR 243).  Includes a Help tab. 3/14/2008
Barnyard Evaluation Rating Tool (BERT) Rating tool for concentrated livestock areas to determine if the area is a resource concern by calculating a rating at the edge of a concentrated livestock area and the end of a buffer.  Includes a Help tab. 2/15/2013
BTU Conversion Calculator The quantity of BTUs is calculated from the data entered for different energy sources.  Conversion factors are included. Total BTU's will be the total of the BTU's calculated for each energy source. "BTU's saved" is calculated by subtracting "Total BTU's used with conservation system" from "Total BTU's used with baseline system."  Energy savings percentage is calculated by dividing "BTU's Saved" by "Total BTU's used with baseline system." 4/21/2014
Concrete Delivery Check, Job Sheet 821 Calculates concrete delivery tickets based on WCS-4 (5/12) criteria.  Automates Job Sheet 821 calculations. 2/15/2013
Concrete Mixture and Materials, Job Sheet 813 Calculates concrete design mixture and materials based on WCS-4 (5/12) criteria.  Automates Job Sheet 813 calculations. 2/15/2013
Cross Section Plotting Plots cross section of streambank based on manual input of elevation and distance for existing ground, top of water, constructed grade, and riprap.  This spreadsheet could be modified for cross sections of other features. 3/14/2008
Culvert Design Calculates capacity of circular culverts based on culvert material, inlet type, diameter, and length. Analysis is also based on water and culvert elevation.  Includes a Help tab. 2/15/2013
Culvert Protection (MN TR-3) Aids in design of riprap outlet basin for culverts. Includes three alternative designs:  horizontal blanket, preformed scour hole, and lined channel expansion.  Also aids in design of culvert inlet protection.  Includes a Help tab. 2/18/2014
Drain Diaphragm Design Calculates the size and placement of a filter diaphragm for pipes through dams.  Includes a Help tab. 6/1/2012
Estimated Fill Computations Calculates the estimated volume of earth fill required to build dikes or dams.  Able to accommodate sloping land, upstream and downstream berms, and core trenches.  Also does calculations with percentages for compaction and settlement. 5/25/2012
Feed Storage Area Runoff - Treatment Calculates runoff using EFH-2, the size of the vegetated treatment area, and the first flush (the initial contaminated runoff volume), the size of pump needed, the size of the tank, and the annual runoff volume collected.  Includes a Help tab. 4/18/2014
Fence Specification Calculates amounts of materials needed for six different types of animal fences, and produces plan drawings that can be copied to CAD.  There are 15 tabs, including a Help tab. 4/18/2014
Flood Frequency USGS 2003 Method Calculates peak flood discharge for streams with large drainage areas based on the USGS report, "Flood-Frequency Characteristics of Wisconsin Streams."  Inputs depend on the Wisconsin Flood Frequency area.  Includes a Help tab. 2/18/2014
Gradation (Riprap - EFH Chapter 17 Method) Calculates riprap gradation from manual inputs of measured sample.  Includes a Help tab. 12/1/2004
Gradation (Rock Chute - EFH Chapter 6) Calculates riprap rock chute gradation from manual inputs of measured sample.  Includes a Help tab. 12/23/2005
Grassed Waterway Design Aids in grassed waterway design using Chapter 2 of the Engineering Field Handbook hydrology routine.  Includes a waterway design table and plan diagram. 7/8/13
Lakeshore Riprap Design Computations Assists with design, calculates the quantities of riprap, geotextile, and filters needed based on lakeshore length, wind direction, lake depth, wave height, lake elevation, and rock design.  There is no Help tab. Use Engineering Field Handbook, Chapter 16; and Wisconsin NRCS FOTG Standard 580 for help with design inputs. 4/1/1999
Lined Waterway Design Assists in lined waterway design.  If peak flows of the watershed are unknown, a copy of Chapter 2 of the Engineering Field Handbook is included.  Includes a Help tab. 6/6/2007
Livestock Pipeline - Single Line Calculates single line pipeline pressure based on user inputs.  Includes a Help tab. 1/21/2011
Livestock Pipeline - Multiple Spurs Calculates multiple line pipeline pressure based on user inputs.  Up to six separate pipelines or spur lines can be accommodated.  Includes a Help tab. 1/6/2011
Manning's N Applications (Trapezoidal and Circular) Calculates capacity and velocity of trapezoidal or circular flow conduits by using Manning's equation. 12/1/2004
Milking Center Waste Volume Calculates estimated milking center wastewater volume based on many user inputs such as size of milking system, whether there is a plate cooler, parlor washdown, milk house wash down, bulk tank wash, etc.  Includes a Help tab. 12/23/2005
Milking Center Wastewater Treatment - Buffer Process Calculates size of buffer needed for milkhouse wastewater based on user inputs.  Includes a Help tab. 2/22/2010
Natural Channel Flow Calculates the flow capacity of a stream which varies in roughness across its profile.  Up to 24 different sets of cross section data can be entered.  Includes a Help tab. 3/27/2007
Peak Discharge, EFH Chapter 2 Method Calculates hydrology (peak discharge, runoff volume, etc.) for small watersheds using the method found in Chapter 2 of the Engineering Field Handbook.  Data is based on user input such as drainage area, slope, and soil hydrologic group. 3/22/2010
Pond Assists with designing embankment pond structures with pipe outlets following procedures in Chapters 3 and 6 of Engineering Field Handbook.  Watershed peak flow calculations are also included.  Includes a Help tab. 4/18/2014
Pump Sizing Determines pump size depending on user inputs.  Inputs require some knowledge and experience with pump sizing. 2/27/2009
Quantities Returns a plan sheet (Standard Drawing 005) and cost estimate, and includes dropdowns for specs. 4/18/2014
Riprap Lined Plunge Pool for Cantilever Outlet (DN-6) Calculates riprap-lined plunge pool location and dimensions and volumes of excavation, riprap, and geotextile below water surface.  The data inputs are from Design Note 6 and outputs are for Standard Drawing 320. 6/1/2012
Riprap Lined Plunge Pool for Cantilever Outlet (ASABE) Calculates riprap-lined plunge pool location and dimensions.  The data inputs are from ASABE paper 94-2541 and the outputs are for Standard Drawing 321. 2/29/2012
Rock Chute Assists in designing rock chutes based on user inputs such as channel geometry, design storm data, and output profile and cross section.  Calculates required D50 and quantities.  Includes a Help tab. 9/1/2011
Rock Riprap Lined Waterway Design Assists in rock riprap lined waterway design. Calculates required D50 and quantities.  Design follows the practice standard issued March 2013.  Includes a "Help" tab. 3/18/2013
Roof Gutter Design Assists in designing roof gutters, downspouts, and roof gutter underground outlets, and is based on Wisconsin NRCS FOTG Standard 558.  Includes a Help tab. 6/1/2013
Roof Gutter Design (simple) Simplified version of the Roof Gutter Design spreadsheet.  Includes a Help tab. 6/1/2013
Seeding Mixes - Engineering Seeding Plan sheet for 342 STANDARD mixes commonly used with engineering projects.  Includes a Help tab. 11/25/13
Seeding Mixes - Standard  (327, 342, 512) Seeding plan sheet for standard 327, 342, and 512 mixes.  Includes a Help tab. 7/8/2013
Seeding Mixes -  Custom Calculates amount of seed per acre and total pounds of seed needed for CUSTOM mixes. Also includes fertilizer recommendations, seeding dates, temporary cover crop and companion crop requirements.  Includes a Help tab. 7/8/2013
Stadia Survey Notes Converted to N-E-Elevation Converts conventional survey notes into data suitable for downloading into CADD.  Includes a Help tab. 5/25/2012
Streambank Protection Assists with design, calculating quantities, and cost computations for the design of a rock riprap streambank protection project.  Works with Chapter 16 of the Engineering Field Handbook, Wisconsin NRCS Standard Drawing Series 404.  Includes a Help tab. 3/18/2013
Thrust Blocks Design and installation of Thrust Control devices according to Part 636 Structural Engineering National Design Handbook, Chapter 52 Structural Design of Flexible Conduits. 7/8/2013
TR-55 Peak Runoff Calculation Calculates the peak flow runoff from a watershed using the graphical method from TR55, Urban Hydrology for Small Watersheds, based on user inputs of drainage area, channel shapes and slopes, and soil hydrologic group.  Includes a Help tab. 6/1/2013
Unit Conversions Conversion tool for distance, area, volume, flow, velocity, force, mass, acceleration, angle, time, and temperature. 4/8/2011
Underground Outlet Design Computations Assists in sizing underground tile lines for both pressurized and non-pressurized flow conditions.  Allows up to 5 inlets and 5 tile reaches, and will assist in selecting an appropriate surface inlet if one is needed.  Used for round conduits only, but can accommodate round and rectangular orifices.  Includes a Help tab. 5/8/2007
Vegetated Treatment Areas Assists in designing three different treatment strip buffers:  slow rate infiltration, overland flow, and buffer design using BARNY.  Includes a Help tab. 3/18/2013
Waste Storage Design Assists in design of waste storage facilities based on user inputs of animal type and number, bedding used, number of days needed to store manure, feedlot area, etc.  Outputs include dimensions of storage pond, cut and fill volumes, percent solids, and linear quantities.  Includes a Help tab. 2/2/2012

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