An official website of the United States government.

This is not the current EPA website. To navigate to the current EPA website, please go to www.epa.gov. This website is historical material reflecting the EPA website as it existed on January 19, 2021. This website is no longer updated and links to external websites and some internal pages may not work. More information »

Polluted Runoff: Nonpoint Source (NPS) Pollution

Questions and Answers about STEPL and the Region 5 Model

Question 1:  Is the Region 5 Model only for EPA Region 5 states?

Question 2:  What are the differences between STEPL and Region 5 Model?

Question 3:  My ‘Total Load’ worksheet has ‘#VALUE!’ in result cells. What went wrong?

Question 4:  The septic system failure rate seems low, are there other alternative data?

Question 5:  How can I add my own BMPs to STEPL’s BMP list?

Question 6:  Where can I find the definitions of BMPs used in the STEPL and Region 5 Model?

Question 7:  Can you help me use the BMP Calculator?

Question 8:  What are other models that can be used for load reduction calculations?

Question 9:  If I don't know exactly where all my BMPs for a particular subwatershed are located (not knowing if they're in the same fields or even affecting the same tributary) am I better off calculating them in serial or in parallel configuration for that subwatershed?

Question 10:  Why is the STEPL-calculated sediment loading rate (t/ac/yr) from my watershed much lower than the erosion rate (> 1 t/ac/yr) reported for my study area? Can you explain?

Question 11:  Some of the data I'm gathering to input into the STEPL model is not consistent. For filter strips, I have some data coming to me as actual acres of filter strip, and some coming to me as acres affected by the filter strip. What is the best way to deal with these discrepancies in the model?

Question 12:  My general question is whether it is appropriate to use STEPL to compare the loading effects of changing a particular site from one land use to another, e.g., agricultural to commercial.  I also wonder how it applies the USLE to "soil loss" from a parking lot.

Question 13:  I used the executable to create the spreadsheet file, made some changes within the spreadsheet. Now, when I reopen the file, I receive an error message from EXCEL saying 'not enough system resources to display completely.' Do you know why?

Question 14:  Can STEPL be used to model bacteria?

Question 15:  How to enable macros in MS Excel spreadsheet?

Question 16:  How to set Excel default file location to C:\STEPL or D:\STEPL?

Question 17:  I am getting an error “Please refrain from using the mouse until the spreadsheet creation has finished” when the hang-ups occur even though the mouse hasn’t moved. I even tried unplugging my mouse all together and still get this error.

Question 18:  Can STEPL be used with Macintosh Operating System (Mac OS)?

Question 19:  I am trying to Run the STEPL 4.3 and keep getting the error "Component 'MSCOMCTL.OCX' or one of its dependencies not correctly registered: a file is missing or invalid" when I press the “Run” button.


Question 1: Is the Region 5 Model only for EPA Region 5 states?

No, the Region 5 Model can be used for other states. The model got its name because it was originally developed by Indiana Department of Environmental Management based on Michigan Department of Environmental Quality’s 319 watershed training manual. Both Indiana and Michigan are EPA Region 5 states.

Top of page

Question 2: What are the differences between STEPL and the Region 5 Model?

Below are the major differences between the two models:

The Region 5 Model
  • Calculates load at the source level
  • Sources are independent (no relationship between worksheets)
  • Users can not specify and update BMPs used in the model
STEPL
  • Calculates load for different sources at source and watershed level
  •  Sources are related in watershed
  •  Users can specify and update BMP list
  •  Users can use BMP calculator to estimate combined BMP efficiencies for complex BMP arrangements
  •  On-line input data server for initial model setup (Caution: Do not substitute the on-line data for real local data!)

Top of page

Question 3: My ‘Total Load’ worksheet has ‘#VALUE!’ in result cells. What went wrong?

First, make sure that you have selected the appropriate State, County, and Weather Station from the lists in the Input Sheet.

Another possibility is that you probably entered some non-numerical characters in the input tables on the ‘Input’ sheet. For example, when you copy and paste ‘Agricultural animals’ data from the tables generated by the ‘STEPL Input Data Server’, you may paste non-numerical characters to the STEPL input sheet if the animal number is indicated with ‘D’ for data withheld to avoid disclosing by US Department of Agriculture.

Top of page

Question 4: The septic system failure rate seems low, are there other alternative data?

Yes. The failure rate data have very high uncertainty. Users are encouraged to obtain the septic failure rate from their local health departments.

Besides the data from the ‘STEPL Input Data Server’ (National Environmental Service Center formally National Small Flow Clearinghouse, 1992 and 1998), Electric Power Research Institute conducted a state-by-state survey on septic failure rate. Below is the summary:

State

Estimated system
failure rate (in %)

Failure definition

Alabama

20

Not given

Arizona

0.5

Surfacing, backup, surface or ground water contamination

California

1-4

Surfacing, backup, surface or ground water contamination

Florida

1-2

Surfacing, backup, surface or ground water contamination

Georgia

1.7

Public hazard

Hawaii

15-35

Improper construction, overflow

Idaho

20

Backup, surface or ground water contamination

Kansas

10-15

Surfacing, nuisance conditions (for installations after 1980)

Louisiana

50

Not given

Maryland

1

Surfacing, backup, surface or ground water contamination

Massachusetts

25

Public health

Minnesota

50-70

Cesspool, surfacing, inadequate soil layer, leaking

Missouri

30-50

Backup, surface or ground water contamination

Nebraska

40

Nonconforming system, water quality

New Hampshire

<5

Surfacing, backup

New Mexico

20

Surfacing

New York

4

Backup, surface or ground water contamination

North Carolina

15-20

Not given

North Dakota

28

Backup, surfacing

Ohio

25-30

Backup, surfacing

Oklahoma

5-10

Backup, surfacing, discharge off property

Rhode Island

25

Not given

South Carolina

6-7

Not given

Texas

10-15

Surfacing, surface or ground water contamination

Utah

0.5

Surfacing, backup, exceeding discharge standards

Washington

33

Public health hazard

West Virginia

60

Backup, surface or ground water contamination

Wyoming

0.4

Backup, surfacing, ground water contamination

Top of page

Question 5: How can I add my own BMPs to STEPL’s BMP list?

You can add, delete, or edit BMPs in the “BMPList” worksheet, which can be shown (unhidden) by clicking the STEPL > View/Edit BMP List menu. On the ‘BMPlist’ worksheet, follow the steps outlined on the top-right corner. See more information in section 4.6 of the STEPL user’s guide.

Top of page

Question 6: Where can I find the definitions of BMPs used in the STEPL and Region 5 Model?

You can find BMP descriptions in a Microsoft Word document, BMPDefinition.doc, under your [Local Drive C or D]:\STEPL folder after you install STEPL on your PC.

Top of page

Question 7: Can you help me use the BMP Calculator?

Yes. The STEPL user’s guide has a detailed section (Appendix A) that describes the procedures and examples of using the BMP Calculator.

Top of page

Question 8: What are other models that can be used for load reduction calculations?

STEPL and the Region 5 Model are two of the simplest models for calculating pollutant load reductions. There are many other models that can be used to calculate the load reductions, and these models are described in a document in the STEPL website. You can find out more about these models in the document "Nutrient and Sediment Estimation Tools for Watershed Protection (PDF)".

Top of page

Question 9: If I don't know exactly where all my BMPs for a particular subwatershed are located (not knowing if they're in the same fields or even affecting the same tributary) am I better off calculating them in serial or in parallel configuration for that subwatershed?

Most non-structural BMPs should be used in parallel configuration (with the BMP Calculator) if you do not know their locations and spatial relationship. Some downstream structural BMPs or on stream BMPs may be in serial connection with the upstream BMPs; for example, a sediment settling pond may be in serial to upstream BMPs such as no-till practices. If you do not know the BMP locations in a watershed, assuming parallel BMP configurations will be better than assuming serial configurations if most of the BMPs are non-structural (except filter strips) or not in-stream.

Top of page

Question 10: Why is the STEPL-calculated sediment loading rate (t/ac/yr) from my watershed much lower than the erosion rate (> 1 t/ac/yr) reported for my study area? Can you explain?

The sediment output from a watershed is different from on-site erosion. For cropland in your calculation, erosion rate may be larger than 1 t/ac/yr; however, the sediment output from your watershed is much lower. The STEPL model calculates sediment output using "erosion x sediment delivery ratio". Your watershed area is pretty large, so it results a low sediment delivery ratio. To see the sediment delivery ratio in STEPL model, click on STEPL menu > unhide/hide other STEPL sheets, and navigate to the ‘Sediment’ worksheet, and then check cell "W9". Your can modify the sediment delivery ratio based on your local data.

Top of page

Question 11: Some of the data I'm gathering to input into the STEPL model is not consistent.  For filter strips, I have some data coming to me as actual acres of filter strip, and some coming to me as acres affected by the filter strip.  What is the best way to deal with these discrepancies in the model?
The important data that STEPL needs is the acreage affected by a filter strip. For example, if you have 20 acres of cropland affected by a filter strip, you can choose "Cropland-filter strip" as the BMP in STEPL and apply it to the affected area for load reduction calculation. The actual area of a filter strip is less important than the area it controls because:
  • the area of the filter strip is usually significant smaller than the affected area, and
  • the filter strip is not a source of nonpoint source pollution (in STEPL, you may exclude it from the load calculation or treat it as a type of forest).

Top of page

Question 12: My general question is whether it is appropriate to use STEPL to compare the loading effects of changing a particular site from one land use to another, e.g., agricultural to commercial.  I also wonder how it applies the USLE to "soil loss" from a parking lot.

For assessment and planning purposes, you can use STEPL to compare effects of land use changes on pollutant loads (N, P, and sediment). However, STEPL was created to only give rough estimates on load and load reduction, and it is not intend for making very precise predictions. For urban land uses, STEPL does not use USLE. STEPL uses annual runoff volume x pollutant concentration to estimate pollutant loads, including sediment load.

Top of page

Question 13: I used the executable to create the spreadsheet file, made some changes within the spreadsheet.   Now, when I reopen the file, I receive an error message from EXCEL saying 'not enough system resources to display completely.'  Do you know why?

This is due to a peculiar Excel behavior. Change the Input worksheet zoom level to 100% percent and try. If this is not working, make the hidden sheet visible (using the Hide/Unhide menu under STEPL) and then change the zoom level.

Top of page

Question 14: Can STEPL be used to model bacteria?

STEPL can not be used to model bacteria. There are other models available to model bacteria. These include models like HSPF, SWATExit, and PLOAD, which is now part of BASINS.

Top of page

Question 15: How to enable macros in MS Excel spreadsheet?

Excel 2003 version: Click on Tools menu > Macro > Security > Security Level > Medium.

Excel 2007 version: Click on Office icon > Excel Options > Trust Center > Trust Center Settings > Macro Settings.

Excel 2010 version: Click on File menu > Excel Options > Trust Center > Trust Center Settings > Macro Settings.

Top of page

Question 16: How to set Excel default file location to C:\STEPL or D:\STEPL?

Excel 2003 version: Click on Tools menu > Options > General tab.

Excel 2007 version: Click on Office icon > Excel Options > Save.

Excel 2010 version: Click on File menu > Excel Options > Save.

Top of page

Question 17: I am getting an error “Please refrain from using the mouse until the spreadsheet creation has finished” when the hang-ups occur even though the mouse hasn’t moved. I even tried unplugging my mouse all together and still get this error.

This error occurs only on machines with a combination of Windows 7 and Microsoft Office Excel 2007 installed. STEPL program is not compatible for this combination. You need to upgrade your Excel program (e.g., Excel 2010).

Top of page

Question 18: Can STEPL be used with the Macintosh Operating System (Mac OS)?

No, STEPL is only compatible with the Windows Operating System.

Top of page

Question 19: I am trying to run the STEPL 4.3 and keep getting the error "Component 'MSCOMCTL.OCX' or one of its dependencies not correctly registered: a file is missing or invalid" when I press the “Run” button.
After you install the STEPL 4.3, you can find the MSCOMCTL.OCX file under the STEPL installation folder (e.g. C:\STEPL\Support\MSCOMCTL.OCX). Ask your IT personal to copy the file under C:\Windows\SysWOW64\ and follow these steps to register it:
  1. Go to Start\All Programs\Accessories.
  2. Right-click Command Prompt and then click on Run As Administrator.
  3. Type the following and then press Enter: cd c:\windows\systemWOW64.
  4. Type the following and then press Enter: regsvr32 MSCOMCTL.OCX.
  5. You should get a message saying this succeeded.

Top of page