Spreadsheet Tool for Estimating Pollutant Loads (STEPL)
Questions or Comments?
- nutrient and sediment loads from different land uses, and
- the load reductions that would result from the implementation of various best management practices (BMPs).
Overview
- watershed surface runoff;
- nutrient loads, including nitrogen, phosphorus, and 5-day biological oxygen demandbiological oxygen demandAn indirect measure of the concentration of biologically degradable material present in organic wastes. It usually reflects the amount of oxygen consumed in five days by biological processes breaking down organic waste. (BOD5); and
- sediment delivery based on various land uses and management practices.
STEPL can be used to evaluate loading and load reductions at a variety of scales. Although the terminology used throughout STEPL to define land use areas is “watershed,” these same input fields can also be treated as smaller areas, such as a project area or individual agricultural fields. For instance, if a user needs to estimate the load reductions from BMPs on individual farm fields, the “watersheds” can be further defined as “Field 1”, “Field 2”, “Field 3”, etc. There is no functional difference in the way STEPL calculates loads when watersheds or fields are used. The user defines the size and characteristics of each area being evaluated, based on the total acreage of each landuse entered into STEPL. This flexibility is not limited to agricultural fields, the “watersheds” could similarly be defined by the user as city blocks in an urbanized area.
For each watershed, the annual nutrient loading is calculated based on the runoff volume and the pollutant concentrations in the runoff water, as influenced by factors such as the land use distribution and management practices.
The annual sediment load (sheet and rill erosion only) is calculated based on the Universal Soil Loss Equation (USLE)Universal Soil Loss EquationAn equation used to predict the average rate of erosion of an area on the basis of the rainfall, soil type, topography, and management measures of the area. and the sediment delivery ratio. The sediment and pollutant load reductions that result from the implementation of BMPs are computed using the known BMP efficiencies.
Model Download and Documentation
STEPL 4.4b
(Last updated: 10/27/2020)
- STEPL 4.4b Spreadsheet Model for 10 Watersheds (Microsoft Excel 2016-ZIP)(4 MB, 10-27-2020) - This download includes STEPL version 4.4b which is fully functional for modeling up to 10 watersheds at a time. It does not require users to have administrator rights for installing STEPL on their computers. Changes from version 4.4 were made to address Excel functionality issues and inconsistencies between the full installation version and the 10 watersheds version. Note: This update replaces a version posted 10/05/2020. The only substantive change fixed a cell reference error in the ag irrigation calculations.
STEPL 4.4
(Last updated: 03/15/2018)
- STEPL 4.4 Spreadsheet Model for 10 Watersheds (Microsoft Excel 2016)(4 MB, 10-27-2020) - Note: This download includes STEPL version 4.4 that is fully functional for modeling up to 10 watersheds at a time. It does not require users to have Administrator Rights for installing STEPL on their computers.
- <STEPL 4.4 Full Installation Package (.zip) (13 MB, 3-2018) - Note: This download contains a 'setup.exe' file that installs STEPL version 4.4 for full functionality on a customizable number of watersheds; however, it requires Administrator Rights for model installation.
- STEPL 4.4 BMP Calculator (.zip)(847 K, 3-2018) -( March 2018)
- STEPL 4.4 Updates and New Features (PDF) - This documentation highlights the new features of STEPL version 4.4.
- STEPL 4.4 User’s Guide (PDF) - This is the complete model documentation for STEPL version 4.4.
Note: This update includes new BMP types (cropland and pastureland) and this version of STEPL has been upgraded to be compatible with Windows 10 and Excel 2016. It is also compatible with Windows 7 and Excel 2013.
STEPL 4.3b
(Last updated: 01/16/2017)
- STEPL 4.3b Installation Package(9 MB, Jan 2017) Note: This .zip file download contains a 'setup.exe' file that installs STEPL version 4.3 for full functionality on a customizable number of watersheds; however, it requires Administrator Rights for model installation.
Note: This version of STEPL has been upgraded to be compatible with Windows 10 and Excel 2013.
Input Data Server for STEPL
The Input Data Server for STEPL uses a waterbody selection interface based on the 12-digit Hydrologic Unit Code (HUC 12) of the waterbody in question and allows the user to download data for one or multiple HUCs.
- 2011 Landuse area distribution at the Subwatershed (HUC12) level.
- 2012 Agricultural animal count at the Subwatershed (HUC12) level.
Training Materials
- Video: EPA STEPL 4.4b Training Webinar (October 7,2020)Exit
- Input File for STEPL 4.4b Training Webinar (25 K) (October 7,2020)
- Video: EPA STEPL 4.4 Training Webinar (March 20, 2018)Exit
- EPA STEPL 4.4 Training Slides (PDF) (March 20, 2018)
- EPA STEPL 4.3 Training Workshop, Washington D.C. (.zip)(9 MB) (August 25, 2015)
- Audio archive of Wisconsin STEPL 4.3 training (August 5, 2014) (University of Wisconsin - Cooperative Extension) Exit