(268 intermediate revisions by 4 users not shown)
Line 1: Line 1:
This User Guide is intended to assist Municipal Separate Storm Sewer System (MS4) Permittees in the completion of the Commissioner-approved [[Upload page with TMDL forms|TMDL Annual Reporting Form]] (TMDL Form).
+
<div style="float:right">
 +
<table class="infobox" style="border:3px; border-style:solid; border-color:#FF0000; text-align: left; width: 300px; font-size: 100%">
 +
<tr>
 +
<th><center><font size=3>'''Overview of the MPCA Simple Estimator'''</font size></center></th>
 +
</tr>
 +
<tr>
 +
<td>'''The MPCA Simple estimator is an Excel-based tool that utilizes the [https://stormwater.pca.state.mn.us/index.php?title=The_Simple_Method_for_estimating_phosphorus_export Simple Method] to estimate total suspended solid and/or total phosphorus loads and load reductions associated with implementation of best management practices (BMPs). The spreadsheet includes the following features.'''
 +
*Up to 10 worksheets where the user provides inputs to estimate loading. Each worksheet includes the following.
 +
**Multiple land uses
 +
**Adjustable event mean concentrations, runoff coefficients, pollutant removal efficiency, and percent of runoff treated by a BMP
 +
**Adjustments in loading associated with non-structural BMPs, such as street sweeping and changes in land use
 +
*A worksheet summarizing pollutant loads and reductions across the ten worksheets described above.
 +
*An information sheet with links to useful pages in the stormwater manual
 +
*A notes sheet where users can provide additional information
 +
*A blank worksheet where users can make calculations or store data
 +
</td>
 +
</tr>
 +
</table>
 +
</div>
  
Some errors were identified in the original [[file:MPCA_Estimator.xlsx]]. We recommend you download and use the updated file.
+
[[file:Check it out.png|100px|thumb|left|alt=download for Estimator|<font size=3>[https://stormwater.pca.state.mn.us/index.php?title=File:MPCA_simple_estimator_version_3.0_March_5_2021.xlsx Download Version 3]</font size>]]
 +
[[file:Check it out.png|100px|thumb|left|alt=video link for guidance|<font size=3>[https://youtu.be/FtlJ8pzyW5k Guidance video]</font size>]]
 +
[[File:Pdf image.png|100px|thumb|left|alt=pdf image|<font size=3>[https://stormwater.pca.state.mn.us/index.php?title=File:Guidance_and_examples_for_using_the_MPCA_Estimator_-_Minnesota_Stormwater_Manual_feb_17_21.pdf Download pdf</font size>]]]
 +
[[File:Technical information page image.png|100px|right|alt=image]]
 +
[[File:General information page image.png|right|100px|alt=image]]
  
'''<big>Download updated MPCA Estimator here: [[file:MPCA_Estimator-2.xlsx]]</big>
+
{{alert|The MPCA Simple Estimator has been updated to Version 3. The guidance on the following page is for Version 3 of the Estimator.|alert-warning}}
  
A quick guide for the estimator is available [[Quick Guide: MPCA Estimator tab]].
+
{{alert|The MPCA Simple Estimator contains default values for event means concentrations, runoff coefficients, BMP pollutant removal efficiency, and fraction of runoff treated by BMPs. If appropriate, the user should adjust these values to match site conditions. Guidance for adjusting values is provided on this page.|alert-warning}}
  
The MPCA estimator worksheet presents an optional calculator approach to computing the pollutant load reduction for four pollutants:  Total phosphorus, Total Suspended Solids (TSS), E. coli, and fecal coliform (note: the estimator may not be used for any other pollutants). Results from the estimator can be used in the ''Cumulative reductions'' tab. The estimator applies only to specific structural BMPs and is a simplistic tool that provides rough estimates of loading and load reductions. It should not be used for modeling a stormwater system or selecting BMPs. The following color coding applies to this worksheet.
+
This page provides guidance on the use of the MPCA Simple Estimator for calculating total phosphorus and total suspended solids (TSS) pollutant loads and reductions in loads associated with implementation of <span title="one of many different structural or non–structural methods used to treat runoff"> '''best management practices'''</span> (BMPs). It assists <span title="A municipal separate storm sewer system (MS4) is a means of transportation, individually or in a system, (e.g. roads with drainage systems, municipal streets, catch basins, curbs, gutters, ditches, man-made channels, storm drains, etc.) that are: owned or operated by a public entity (e.g. cities, townships, counties, military bases, hospitals, prison complexes, highway departments, universities, etc.) with jurisdiction over disposal of sewage, industrial wastes, stormwater, or other wastes. This includes special districts under State law (sewer, flood control, or drainage districts, etc.), an authorized Indian tribal organization, or a designated and approved management agency under section 208 of the Clean Water Act; designed or used for collecting or transporting stormwater; not a combined sewer; and not part of a publicly owned treatment works."> '''MS4'''</span> (Municipal Separate Storm Sewer System) permittees in the completion of the Commissioner-approved [[Upload page with TMDL forms|TMDL Annual Reporting Form]] (<span title="the amount of a pollutant from both point and nonpoint sources that a waterbody can receive and still meet water quality standards"> [https://stormwater.pca.state.mn.us/index.php?title=Total_Maximum_Daily_Loads_(TMDLs) '''TMDL''']</span> Form).
*Grey cells are column and row headings
 
*White cells are User input (some cells contain default values but can be edited)
 
*Yellow cells contain formulas that calculate loads (can only be edited in "Input values for MPCA estimator" tab)
 
*Red cells contain formulas that contain results for reductions (cannot be edited)
 
The estimator utilizes the [http://www.stormwatercenter.net/monitoring%20and%20assessment/simple%20meth/simple.htm Simple Method] to estimate land use based pollutant loads for total phosphorus, total suspended solids (TSS), and total bacteria (Schueler, 1987). BMPs included in the estimator are biofiltration (bioretention with an underdrain), bioinfiltration (bioretention with no underdrain), filter strip, landscaped roof (green roof), permeable pavement with an underdrain, sand filter, swale, wet basin, and constructed wetland. Users may include other BMPs if they have reliable data on pollutant removal efficiency.
 
  
The estimator will compute pollutant reduction using BMP performance data as published in the [http://www.bmpdatabase.org/performance-summaries.html 2012 International BMP Database]. The database compiles [[Glossary|Event Mean Concentration]] (EMC) performance data and reports in terms of 25th Percentile, Median, and 75th Percentile. The estimator computes the load reduction according to the formula
+
This guidance applies to Version 3 of the Estimator.
 +
 
 +
==Estimator downloads and links to resources==
 +
{{alert|The guidance on this page applies to Version 3 of the Estimator.|alert-info}}
 +
 
 +
Download Version 3 of the estimator here: [[File:MPCA simple estimator version 3.0 March 5 2021.xlsx]]
 +
 
 +
Download Version 2 of the MPCA Estimator here: [[file:MPCA_Estimator-2.xlsx]]
 +
 
 +
A quick guide for the Estimator is available [[Quick Guide: MPCA Estimator tab]].
 +
 
 +
'''NOTE: This page is a User's Guide that explains the various cells and worksheets in the Estimator. Guidance for using the Estimator for permit compliance and case studies are found at the following links'''
 +
*[[Recommendations and guidance for utilizing the MPCA Simple Estimator to meet TMDL permit requirements]]
 +
*[[Case study for using the MPCA Simple Estimator to meet TMDL permit requirements]]
 +
 
 +
==Opening the MPCA Simple Estimator==
 +
If the Version 3 of the Estimator you open has macros enabled, you will see an information box stating the following:
 +
 
 +
"''This spreadsheet contains several default values, such as pollutant concentrations, curve numbers, and BMP pollutant removal efficiency. It is important to adjust those values, as appropriate, to your site conditions. Read the information tab in the spreadsheet for more information''."
 +
 
 +
Click '''''OK''''' to open the spreadsheet.
 +
 
 +
==General description of the MPCA Simple Estimator==
 +
The MPCA Estimator spreadsheet presents a calculator approach to computing pollutant loading and the pollutant load reduction for [https://stormwater.pca.state.mn.us/index.php?title=Phosphorus total phosphorus] (TP) and [https://stormwater.pca.state.mn.us/index.php?title=Total_Suspended_Solids_(TSS)_in_stormwater total suspended solids] (TSS)(Note: the Estimator may not be used for any other pollutants). For MS4 permittees reporting on TMDL <span title="the portion of a receiving water's assimilative capacity that is allocated to one of its existing or future point sources of pollution"> '''wasteload allocations'''</span> (WLAs), results from the Estimator can be used in the ''Cumulative reductions'' tab of the [https://stormwater.pca.state.mn.us/index.php?title=Phase_I_MS4_Guidance_for_completing_the_TMDL_Annual_report_form Annual Report form]. The Estimator applies load reductions to specific <span title="a stationary and permanent BMP that is designed, constructed and operated to prevent or reduce the discharge of pollutants in stormwater"> '''structural stormwater BMPs'''</span> but can be used to estimate reductions associated with other BMPs such as street sweeping, impervious surface disconnection, and changes in land use. It is a simplistic tool and should not be used for modeling a stormwater system or selecting BMPs.
 +
 
 +
When working in the Estimator, the following color coding applies.
 +
*Grey cells have fixed information and cannot be edited
 +
*White cells can be edited by the user
 +
*Yellow cells contain default values that the user can edit. Editing the defaults triggers an alert informing the user that the default has been modified.
 +
*Red cells contain formulas that result in calculated pollutant reductions; these cells cannot be edited
 +
The Estimator utilizes the [http://www.stormwatercenter.net/monitoring%20and%20assessment/simple%20meth/simple.htm Simple Method] to estimate pollutant loads for total phosphorus and total suspended solids (TSS). BMPs (best management practices) included in the Estimator are <span title="a bioretention practice having an underdrain. All water entering the practice is filtered through engineered media and filtered water is returned to the storm sewer system."> [https://stormwater.pca.state.mn.us/index.php?title=Bioretention '''biofiltration''']</span> (bioretention with an underdrain), <span title="Infiltration Best Management Practices (BMPs) treat urban stormwater runoff as it flows through a filtering medium and into underlying soil, where it may eventually percolate into groundwater. The filtering media is typically coarse-textured and may contain organic material, as in the case of bioinfiltration BMPs."> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices '''infiltration''']</span> (a bmp with no underdrain), <span title="an area of permanent vegetation or other material used to reduce sediment, organics, nutrients, pesticides, and other contaminants from runoff and to maintain or improve water quality.> '''filter strip'''</span>, landscaped roof (<span title="Green roofs consist of a series of layers that create an environment suitable for plant growth without damaging the underlying roof system. Green roofs create green space for public benefit, energy efficiency, and stormwater retention/ detention."> '''[https://stormwater.pca.state.mn.us/index.php?title=Green_roofs green roof]'''</span>), <span title="Permeable pavements allow stormwater runoff to filter through surface voids into an underlying stone reservoir for temporary storage and/or infiltration. The most commonly used permeable pavement surfaces are pervious concrete, porous asphalt, and permeable interlocking concrete pavers (PICP)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Permeable_pavement permeable pavement]'''</span> with an underdrain, <span title="filtration of stormwater through a sand filtering material whose purpose is to remove pollution from runoff"> '''[https://stormwater.pca.state.mn.us/index.php?title=Filtration sand filter]'''</span>, <span title="are configured as shallow, linear channels. They typically have vegetative cover such as turf or native perennial grasses"> [https://stormwater.pca.state.mn.us/index.php?title=Dry_swale_(Grass_swale) '''swale''']</span>, wet basin (<span title="a stormwater retention basin that includes a combination of permanent pool storage and extended detention storage above the permanent pool to provide additional water quality or rate control"> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_ponds '''wet pond''']</span>), and <span title="Stormwater wetlands are similar in design to stormwater ponds and mainly differ by their variety of water depths and associated vegetative complex."> '''[https://stormwater.pca.state.mn.us/index.php?title=Stormwater_wetlands stormwater wetland]'''</span>. Users may include other BMPs if they have reliable data on pollutant <span title="Pollutant removal efficiency, usually represented by a percentage, specifically refers to the pollutant reduction from the inflow to the outflow of a system"> '''removal efficiency'''</span>.
 +
 
 +
The Estimator allows the user to make calculations for 10 areas (e.g. subwatersheds). Within each area the Estimator computes pollutant reduction using BMP performance data [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_pollutant_concentrations_and_event_mean_concentrations as published in this manual]. The Estimator computes the load reduction according to the formula
  
 
:Load Reduction for a BMP = Load in – Load out = (EMC in * Volume in) – (EMC out * Volume out).
 
:Load Reduction for a BMP = Load in – Load out = (EMC in * Volume in) – (EMC out * Volume out).
Line 22: Line 71:
 
:% Reduction = Load Reduction ÷ Load in.
 
:% Reduction = Load Reduction ÷ Load in.
  
The cumulative reduction is the sum of load reduced for all BMPs. This computed reduction can be input into the [[Guidance_for_completing_the_TMDL_reporting_form#Cumulative_reductions_worksheet|''Cumulative reductions'']] tab of the TMDL form.
+
The cumulative reduction is the sum of load reduced for all BMPs across all 10 areas (worksheets). For MS4 permittees with WLAs, this computed reduction can be input into the [[Phase_I_MS4_Guidance_for_completing_the_TMDL_Annual_report_form#Cumulative_reductions_worksheet|''Cumulative reductions'']] tab of the TMDL Annual Report form.
  
 
The Estimator can only be used for one TMDL at a time. If a Permittee has multiple TMDLs and chooses to use the Estimator, separate calculations must be made for each TMDL.
 
The Estimator can only be used for one TMDL at a time. If a Permittee has multiple TMDLs and chooses to use the Estimator, separate calculations must be made for each TMDL.
  
{{alert|The results from the MPCA Estimator are intended to show a generalized value that represents approximate progress towards meeting TMDL WLAs. The MPCA estimator should not be used for other modeling or compliance purposes. Instead, Permittees should use field investigations combined with more detailed models.|alert-warning}}
+
{{alert|The results from the MPCA Estimator are intended to show a generalized value that represents approximate progress towards meeting TMDL WLAs. The MPCA Estimator should not be used for other modeling or compliance purposes. Instead, Permittees should use field investigations combined with more detailed models.|alert-warning}}
 +
 
 +
==Structure of the MPCA Estimator spreadsheet==
 +
[[File:Screen shot of Estimator.png|500px|thumb|alt=image mpca estimator|<font size=3>Screen shot of draft Version 3 of MPCA Estimator showing 10 calculation worksheets, an information sheet, a summary sheet, a notes sheet, and a worksheet. Click on image to enlarge.</font size>]]
 +
 
 +
The MPCA Simple Estimator (Estimator) spreadsheet contains 14 worksheets.
 +
*1 worksheet providing information about the spreadsheet
 +
*10 worksheets where data are entered and calculations made
 +
*1 summary worksheet
 +
*1 notes sheet
 +
*1 worksheet
 +
 
 +
==Information worksheet==
 +
The information worksheet provides some basic information about the Estimator and includes links that may be useful.
 +
 
 +
==Notes sheet==
 +
There is limited space to include notes on the ten calculation worksheets. The notes page allows the user to include additional information and details about inputs, assumptions, and calculations used in the calculation worksheets.
 +
 
 +
==Worksheet==
 +
This is a blank worksheet where users may perform calculations that may be necessary in using the calculation worksheets, or where information or data can be stored.
 +
 
 +
==Summary sheet==
 +
This is a protected worksheet that provides summary information, including initial loads for total phosphorus and TSS, reductions in loads associated with BMP implementation, percent reduction in loads, final loading rate (lb/ac/yr), and removal by different BMP types. Data are shown by area and for the entire site.
 +
 
 +
==Calculation worksheets==
 +
Each of the 10 calculation worksheets represents a subwatershed. The user is not obligated to use 10 worksheets for their study area. We encourage the user to use separate worksheets for the following conditions.
 +
*The study area has multiple well-defined subwatersheds.
 +
*<span title="the total area, including pervious and impervious surfaces, contributing to a BMP"> '''[https://stormwater.pca.state.mn.us/index.php?title=Contributing_drainage_area_to_stormwater_BMPs Contributing areas]'''</span> to BMPs in downstream portions of treatment trains should be treated as subwatersheds and should not include the area contributing to upstream BMPs in the <span title="multiple BMPs that work together to remove pollutants utilizing combinations of hydraulic, physical, biological, and chemical methods"> [https://stormwater.pca.state.mn.us/index.php?title=Using_the_treatment_train_approach_to_BMP_selection '''treatment train''']</span>, particularly if significant amounts of runoff are being treated by the upstream BMPs.
 +
*To more accurately reflect differences in land use. Although the Estimator provides flexibility in selecting land uses, certain situations may be better dealt with by treating land uses as different subwatersheds. For example, a single residential area highly impacted by emerald ash borers may be treated as a separate subwatershed from an adjacent residential area where tree canopy will remain intact (i.e. due to significant differences in <span title="the average pollutant concentration for a given stormwater event, expressed in units of mass per volume (e.g., mg/L)"> '''event mean concentrations'''</span>).
 +
 
 +
{{alert|Each worksheet in the Estimator is called an '''''Area''''' and represents a subwatershed as discussed above|alert-info}}
 +
 
 +
The 10 calculation worksheets are identical and each contains 5 sections, described below.
 +
*Calculation of unadjusted total loads for total phosphorus (TP) and total suspended solids (TSS)
 +
*Calculation of adjusted total loads for TP and TSS
 +
*Calculation of TP loading reductions associated with implementation of best management practices (BMPs)
 +
*Calculation of TSS loading reductions associated with implementation of best management practices (BMPs)
 +
*BMP and land use input values
 +
 
 +
Each of these sections is described below.
 +
 
 +
===Section 1: Calculation of unadjusted total loads===
 +
[[File:Unadjusted total loads screenshot.png|500px|thumb|alt=screen shot of simple estimator|<font size=3>Screen shot of Section 1 of the Estimator. Unadjusted pollutant loads are calculated in this section. Note that defaults values exist in many of the yellow cells, but the user can change these cells. To avoid a calculation error, the default area for each land use is 0.00001 acres, which creates a small amount of pollutant load. Values in red are calculated and cannot be changed by the user. Grey cells cannot be edited. White cells are input cells for the user.</font size>]]
 +
[[File:Unadjusted total loads screenshot2.png|500px|thumb|alt=screen shot of simple estimator|<font size=3>Screen shot of Section 1 of the Estimator. In this image, the user has changed some of the default emcs for phosphorus. Note an alert box is shown in those rows where a default has changed. In this example, the user provides a note explaining the emcs are based on monitoring data.</font size>]]
 +
<!--[[File:Estimator section 1 a.png|500px|thumb|alt=screen shot of simple estimator|<font size=3>Screen shot of Section 1 of the Estimator. Unadjusted pollutant loads are calculated in this section. Note that defaults values exist in many of the yellow cells, but the user can change these cells. To avoid a calculation error, the default area for each land use is 0.00001 acres, which creates a small amount of pollutant load. Values in red are calculated and cannot be changed by the user. Grey cells cannot be edited. White cells are input cells for the user.</font size>]]
 +
[[File:Estimator section 1 b.png|500px|thumb|alt=screen shot of simple estimator|<font size=3>Screen shot of Section 1 of the Estimator. In this image, the user has changed some of the default emcs for phosphorus. Note an alert box is shown in those rows where a default has changed. In this example, the user provides a note explaining the emcs are based on monitoring data.</font size>]]-->
  
==Detailed guidance for the MPCA Estimator==
+
{{alert|The Estimator spreadsheet uses a mix of SI and English units. Correction factors are included in all calculations. The user must use the correct units for input values.|alert-info}}
The MPCA Estimator is divided into five sections.
+
{{alert|To avoid calculation errors, each land use should have a minimum default area when there is acreage within that land use. The Estimator uses a value of 0.00001 and we recommend retaining that value or using a smaller value.|alert-warning}}
*Calculation of loads for total phosphorus, TSS, E. coli bacteria, and fecal coliform bacteria.
 
*Calculation of reductions in loading for total phosphorus
 
*Calculation of reductions in loading for TSS
 
*Calculation of reductions in loading for E. coli bacteria
 
*Calculation of reductions in loading for fecal coliform bacteria
 
  
Download MPCA Estimator here: [[file:MPCA_Estimator.xlsx]]
+
In this section, the total unadjusted load, in pounds, is calculated for the area considered. Unadjusted means there is no consideration of reductions associated with <span title="a stationary and permanent BMP that is designed, constructed and operated to prevent or reduce the discharge of pollutants in stormwater"> '''structural stormwater BMPs'''</span> or with practices such as street sweeping, <span title="any practice that reduces, eliminates, or prevents pollution at its source"> '''pollution prevention'''</span>, changes in land use, etc.
  
===Calculation of total pollutant loads===
+
This section comprises Cells A5 through M24 of each of the 10 calculation worksheets. In this section, the user inputs land area, in acres, associated with different land uses within the area being considered. The user inputs annual precipitation, in inches. A link provides access to precipitation information if the user does not know the precipitation for the subwatershed. The section contains default values for TP and TSS event mean concentrations (mg/L) and default values for <span title="The runoff coefficient (C) is a dimensionless coefficient relating the amount of runoff to the amount of precipitation received. It is a larger value for areas with low infiltration and high runoff (pavement, steep gradient), and lower for permeable, well vegetated areas (forest, flat land)."> [https://stormwater.pca.state.mn.us/index.php?title=Runoff_coefficients_for_5_to_10_year_storms '''runoff coefficients''']</span>. EMCs and runoff coefficients can be changed by the user. Changing a default value triggers an alert box informing the user that the default has been changed.
[[File:Estimator calculating loads.PNG|500px|thumb|alt=screen shot of simple estimator|<font size=3>Screen shot of the section where pollutant loads are calculated for the MPCA Estimator. Note that defaults values exist in many of the white cells, but the User can change these cells. To avoid a calculation error, the default area for each land use is 0.001 acres, which creates a small amount of pollutant load. Values in yellow are calculated and cannot be changed by the User.</font size>]]
 
  
 
'''Column A - Land use'''
 
'''Column A - Land use'''
*Description: This column contains various classifications for land use.  Only classifications having adequate information for pollutant concentrations in the literature were included. The User may include additional land uses if adequate information exists for pollutant concentrations in runoff from that land use. The User may also include just a single land use to represent the entire area within the TMDL Project watershed, although this may require estimates of pollutant concentrations and runoff coefficients for areas with multiple land uses.
+
*Description: This column contains various classifications for land use.  Only classifications having adequate information for pollutant concentrations in the literature were included. The user may include additional land uses if adequate information exists for pollutant concentrations in runoff from that land use. The user may also include just a single land use to represent the entire area within the TMDL Project watershed, although this may require estimates of pollutant concentrations and runoff coefficients for areas with multiple land uses.
*Input: Land use category. Options include commercial, industrial, institutional, multi-use, municipal, open space, residential-high density, residential low-density, residential-medium density, and transportation. The User may input up to two other land use classifications.
+
*Input: Land use category. Options include commercial, industrial, institutional, multi-use, municipal, open space, residential, park, agriculture, transportation, and water. The user may input up to five other land use classifications.
*Source of Information: MPCA input or User input. For descriptions of different land uses, see [http://www.datafinder.org/metadata/GeneralizedLandUseHistorical.html], [http://planning.rctlma.org/ZoningInformation/GeneralPlan/LandUseDesignations.aspx], [http://www.cityofcaldwell.com/file_depot/0-10000000/10000-20000/13986/folder/99428/DEFINITIONS+OF+RESIDENTIAL+LAND+USES.pdf].
+
*Source of Information: MPCA input or user input.
  
'''Columns B through E, Rows 6 through 17 - Event mean concentrations'''
+
'''Columns B and C, Rows 6 through 23 - Event mean concentrations'''
*Description: The influent Event Mean Concentrations (EMCs) of the pollutants of concern for each classification of land use listed in Column A.
+
*Description: The influent <span title="the average pollutant concentration for a given stormwater event, expressed in units of mass per volume (e.g., mg/L)"> '''event mean concentration'''</span> (EMCs) of the pollutants of concern for each classification of land use listed in Column A.
*Input: Default value with an option for the User to enter a different value  
+
*Input: Default value with an option for the user to enter a different value. If the user changes an emc for commercial, industrial, institutional, multi-use, municipal, residential, open space, or transportation, an alert displays in Column I or Column J, informing the user that they have changed the default emc. The user can change emcs for water, park, transportation, or user-specified land uses without an alert.
*Source of Information: The [http://rpitt.eng.ua.edu/Publications/4_Stormwater_Characteristics_Pollutant_Sources_and_Land_Development_Characteristics/Stormwater_characteristics_and_the_NSQD/NSQD%203.1%20summary%20for%20EPA%20Cadmus.pdf 2011 National Stormwater Quality Database] is the primary source of this information. Cells in the worksheet are populated with mean or median values from the Upper Midwest (Zone 1), but the User may enter a different value in the ''Input values for MPCA estimator'' tab if they have reliable data.
+
*Source of Information: We conducted a literature review to develop information on emcs. We selected default values based on analysis of data from the literature review and using best professional judgement. Information on emcs, including a summary of the literature review, ranges in emcs for different land uses, and guidance for adjusting an emc is found at these links.
 +
**[[Event mean concentrations of total suspended solids in stormwater runoff]]
 +
**[[Event mean concentrations of total and dissolved phosphorus in stormwater runoff]]
  
'''Column F, Rows 6 through 17 - Area of specified land use'''
+
'''Column D, Rows 6 through 23 - Area of specified land use'''
*Description: Area of specific land use within the TMDL study area, in acres.
+
*Description: Area of specific land use within the subwatershed, in acres.
*Input: Drainage area, in acres. A value must be entered into this cell for the pollutant reduction to be calculated. Cells are therefore populated with a default value of 0.001 acres to avoid returning an error in the calculations.
+
*Input: Drainage area, in acres. A value must be entered into this cell for the pollutant reduction to be calculated. Cells are therefore populated with a default value of 0.000001 acres to avoid returning an error in the calculations.
*Source of Information: User. [http://www.pca.state.mn.us/index.php/water/water-types-and-programs/minnesotas-impaired-waters-and-tmdls/tmdl-projects/tmdl-projects-and-staff-contacts.html#approved TMDL reports] provide maps and acreages for TMDL study areas. Shapefiles of TMDL study areas can be found at [http://www.pca.state.mn.us/index.php/data/spatial-data.html].
+
*Source of Information: User. [https://www.pca.state.mn.us/business-with-us/total-maximum-daily-load-tmdl-projects TMDL reports] provide maps and acreages for TMDL study areas. Shapefiles of TMDL study areas can be found at [https://stormwater.pca.state.mn.us/index.php?title=Additional_resources_for_completing_the_TMDL_form#Link_to_TMDL_GIS_Shapefiles link].
  
'''Column G, Rows 6 through 17 - Annual precipitation'''
+
'''Column E, Rows 6 through 23 - Annual precipitation'''
*Description: Total annual precipitation in MS4 region.
+
*Description: Total annual precipitation in subwatershed.
Note: The default value is 30.65 inches per year, which is the average annual precipitation at the Minneapolis-St. Paul International airport. The User should input the appropriate value for their location. The references below can be used to determine this value.
+
'''Note: The default value is 30.65 inches per year, which is the average annual precipitation at the Minneapolis-St. Paul International airport. The user should input the appropriate value for their location. The references below can be used to determine this value.'''
 
*Input: Annual rainfall, in inches
 
*Input: Annual rainfall, in inches
 
*Sources of Information:
 
*Sources of Information:
Line 66: Line 156:
 
**[http://www.usclimatedata.com/climate/minnesota/united-states/3193 U.S. Climate data]
 
**[http://www.usclimatedata.com/climate/minnesota/united-states/3193 U.S. Climate data]
  
'''Column H, Rows 6 through 17 - runoff coefficients'''
+
'''Column F, Rows 6 through 23 - runoff coefficients'''
*Description: Standard runoff coefficient for each type of land use.
+
*Description: Standard <span title="The runoff coefficient (C) is a dimensionless coefficient relating the amount of runoff to the amount of precipitation received. It is a larger value for areas with low infiltration and high runoff (pavement, steep gradient), and lower for permeable, well vegetated areas (forest, flat land)."> [https://stormwater.pca.state.mn.us/index.php?title=Runoff_coefficients_for_5_to_10_year_storms '''runoff coefficient''']</span> for each type of land use.
*Input: Default value with an option for the User to enter a different value
+
*Input: Default value with an option for the user to enter a different value. If the user changes the default, an alert displays in Column K informing the user that the default has changed.
*Source of Information: MPCA input values based on literature. The default is set at the median. The User may enter a value in the ''Input values for MPCA estimator'' tab if available data supports the value. For a discussion of runoff coefficients, see [http://www.brighthubengineering.com/hydraulics-civil-engineering/93173-runoff-coefficients-for-use-in-rational-method-calculations/#imgn_1].
+
*Source of Information: MPCA input values based on literature. The default is set at the median. For a discussion of runoff coefficients, see [http://www.brighthubengineering.com/hydraulics-civil-engineering/93173-runoff-coefficients-for-use-in-rational-method-calculations/#imgn_1]. For a table of runoff coefficients for different soils and slopes, [https://stormwater.pca.state.mn.us/index.php?title=Runoff_coefficients_for_different_soil_groups_and_slopes link here].
  
'''Columns I through L, Rows 6 through 18 - Pollutant loads'''
+
'''Columns G and H, Rows 6 through 24 - Pollutant loads'''
*Description: The calculated load of the various pollutants of concern. Note that the values contained in Row 18 are the total values for all the land uses. Loading values take into consideration the concentration of pollutant in the stormwater runoff, drainage area, annual rainfall, and runoff coefficient.
+
*Description: The calculated load of the various pollutants of concern. Note that the values contained in Row 24 are the total values for all the land uses. Loading values take into consideration the concentration of pollutant in the stormwater runoff, drainage area, annual rainfall, and runoff coefficient.
:This is the base loading from which reductions are made. The User should therefore not change the inputs once the initial calculations are made because it may affect the calculations for pollutant reductions.
+
:'''This is the base loading from which reductions are made. The user should therefore not change the inputs once the initial calculations are made because it may affect the calculations for pollutant reductions.'''
 
*Input: None
 
*Input: None
 
*Source of Information: The values in these cells are calculated based on the information entered in the previous cells
 
*Source of Information: The values in these cells are calculated based on the information entered in the previous cells
  
===Calculations for pollutant load reductions===
+
'''Columns I, J, K, rows 8 through 14 and row 17''' - If the user changes a default value for emc or runoff coefficient in one of these rows, an alert is displayed.
[[File:Estimator phosphorous calculations.PNG|500px|thumb|alt=screen shot estimator|<font size=3>Screen shot showing the section where reductions in phosphorus loading are calculated in the MPCA Estimator. Sections for TSS, E. coli and fecal coliform bacteria are similar.</font size>]]
+
 
 +
'''Column L, Rows 8 through 23''' - The user may enter notes. For example, if a default value is changed, the user may explain the rationale for the change.
 +
 
 +
'''Column M, Rows 8 through 24''' - This column displays calculated runoff volumes in cubic feet. The Simple Method is used to generate this value. These cells are protected.
  
This part of the worksheet is comprised of four sections corresponding with calculations for phosphorus, TSS, coliform bacteria, and E. coli bacteria. The User inputs areas being treated by a particular BMP within a specific land use. Total pounds or bacteria reduced and percent reductions from the estimated load are generated based on the pollution reduction efficiency of the BMP.
+
===Section 2: Calculation of adjusted total loads===
 +
[[File:Adjusted total loads screenshot.png|thumb|500px|alt=screen shot estimator|<font size=3>Screen shot of Section 2 - Adjusted loads. Note there are no pollutant loads because acreages have not been entered.</font size>]]
 +
<!--
 +
[[File:Adjusted loads 1.png|thumb|500px|alt=screen shot estimator|<font size=3>Screen shot of Section 2 - Adjusted loads</font size>]]
 +
[[File:Adjusted loads 2.png|thumb|500px|alt=screen shot estimator|<font size=3>Screen shot of Section 2 - Adjusted loads with example adjustments. Adjustments include implementation of an impervious disconnection program in the industrial are, enhanced street sweeping in the residential area, and conversion of agricultural land. </font size>]]-->
  
'''Rows 23 through 34, 44 through 55, 65 through 76, and 86 through 97'''
+
This section of the 10 calculation worksheets contains information and calculations for adjustments to the total loads calculated in the previous section (Unadjusted total loads). It comprises Cells A26 through M45.
 +
 
 +
Adjusted total loads account for changes in event mean concentration or runoff coefficient values used in the section "Unadjusted total loads". Examples of practices or actions that result in changes in EMC or runoff coefficients include but are not limited to the following.
 +
*Street sweeping: Enhancing an existing street sweeping program, or initiating street sweeping will lower the emc in runoff. Alternatively, reducing street sweeping will increase the emc.
 +
*Implementation of pollution prevention practices: Practices that reduce TP and/or TSS loads will lower the emc. Note that many of these practices are difficult to quantify and the user should base the decision to modify the emc on monitoring data or a literature review. An example would be a neighborhood leaf pickup program.
 +
*Land use change: A change in land use may result in a change in emc and/or a change in runoff coefficient. This may result in an increase or decrease in total load.
 +
*Altered land use practices: This potentially includes a wide range of practices that may affect the emc or runoff coefficient. Examples include disconnection of impervious surfaces, reduction in impervious surfaces, and changes in lawn practices (e.g. increased yard waste composting).
 +
 
 +
The user will adjust appropriate emcs in Cells B29 through C44, and/or adjust the appropriate runoff coefficients in cells F29 through F44. Changing a value in one of these cells (shaded yellow) displays an alert box in Column L warning the user that the default has been changed. The user should provide a description or rationale in the appropriate cell in Column K. Column M displays calculated runoff volumes in cubic feet, generated using the Simple Method.
 +
 
 +
[[File:Adjusted total loads example screenshot.png|thumb|500px|alt=screen shot estimator|<font size=3>Screen shot of Section 2 - Adjusted loads with example adjustments. Adjustments include implementation of an impervious disconnection program in the industrial are, enhanced street sweeping in the residential area, and conversion of agricultural land. Note there are no pollutant loads because acreages have not been entered.</font size>]]
 +
 
 +
The adjacent figure illustrates three example adjustments. In an industrial area, an impervious disconnection program was implemented. This could consist of, for example, a <span title="roof runoff that has been collected in gutters and piped directly to streets, storm drains, and streams and redirects it away from impervious surfaces to land-scaped areas"> '''roof runoff disconnection'''</span> program where roof runoff is diverted to pervious surfaces. In residential areas, enhanced street sweeping lowered the emc. An enhanced street sweeping program might consist, for example, of more intensive sweeping during fall leaf drop. Finally, agricultural land was developed and the emc was lowered for the developed area. For land use changes it is important to avoid double counting. For example, if the newly developed area incorporates infiltration practices, the effect of these practices should be reflected either in this section or in sections 3 or 4, where BMPs are entered, but not in both sections. Including this in both sections would be double counting.
 +
 
 +
{{alert|The user should provide a description or rationale for changed values in the appropriate cell in Column K. The Notes worksheet may also be used for this.|alert-warning}}
 +
 
 +
===Section 3: Calculations for phosphorus load reductions associated with BMP implementation===
 +
<div style="float:right">
 +
<table class="infobox" style="border:3px; border-style:solid; border-color:#FF0000; text-align: left; width: 300px; font-size: 100%">
 +
<tr>
 +
<th><center><font size=3>'''Tips for entering structural Best Management Practices'''</font size></center></th>
 +
</tr>
 +
<tr>
 +
<td>'''Sections 3 (total phosphorus) and 4 (TSS) address reductions in pollutant loading associated with implementation of structural BMPs. Below are some tips for entering data in these sections.'''
 +
*The area treated by a BMP cannot exceed the total acreage within a specific land use
 +
*Examine the values in rows 66-68 for total phosphorus and rows 91-93 for TSS. Guidance on adjusting these and rationale for the defaults is [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Tips_for_using_the_Estimator provided here].
 +
*If multiple BMPs are used in series, consider adjusting the removal efficiency downward for downstream BMPs. For more information, [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Tips_for_using_the_Estimator link here].
 +
</td>
 +
</tr>
 +
</table>
 +
</div>
 +
 
 +
[[File:Estimator section 3.png|500px|thumb|alt=screen shot estimator|<font size=3>Screen shot showing the section where reductions in phosphorus loading are calculated in the MPCA Estimator.</font size>]]
 +
 
 +
In this section of the worksheet the user enters acreages for BMPs implemented within each land use in the subwatershed. The section comprises Cells A47 through L70. The area treated by a BMP cannot exceed the total acreage within a specific land use (i.e. an error message is returned if the user attempts to enter an acreage greater than the total acres in a land use). If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.
 +
 
 +
'''Note''': it is possible for treated acres to exceed total acres when multiple BMPs are employed. The warning alerts the user to this situation, in which case the user should ensure the entered values are correct. If treated acres do exceed total acres, the user should consider adjusting removal efficiencies for downstream BMPs that are receiving water treated by upstream BMPs.
 +
 
 +
{{alert|The area treated by a BMP cannot exceed the total acreage within a specific land use|alert-warning}}
 +
{{alert|If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.|alert-warning}}
 +
 
 +
[[File:Infiltration bmps.gif|300px|thumb|alt=gif image of infiltration practices|<font size=3>Infiltration practices include infiltration basins and bioinfiltration, infiltration trenches, tree trenches with no underdrain, permeable pavement with no underdrain, and swales with check dams.</font size>]]
 +
 
 +
'''Rows 48 through 65'''
 
*Description: The area, in acres, treated by the BMP, for different land uses. Land uses are listed in Column A.
 
*Description: The area, in acres, treated by the BMP, for different land uses. Land uses are listed in Column A.
:Note: These cells represent the area tributary to a BMP, which may not be the entire area for the type of land use. Not all cells need to be filled in. The User should only enter data in the cells relating to the specific BMPs and the land use classification of the BMPs’ drainage area.
+
 
:Note that if the User attempts to enter BMP acreages greater than the land use area, an error message is generated since one BMP cannot treat an area greater than the land use area. If the User enters a total acreage for all BMPs that exceeds the area of the land use, a warning message will be generated. This warning does not prevent the User from proceeding, since the total acreage for multiple BMPs may exceed the total land use acreage. For example, assume runoff from a 1 acre commercial area drains to an underground infiltration BMP. The area may also include a 0.2 acre green roof, resulting in 1.2 acres of BMP for the 1 acre commercial area. Generally, it is unlikely the BMP acreage will exceed the land use area.
+
These cells represent the area tributary to a BMP, which may not be the entire area for the type of land use. Not all cells need to be filled in. The user should only enter data in the cells relating to the specific BMPs and the land use classification of the BMPs’ drainage area.
 +
 
 +
If the user attempts to enter BMP acreages greater than the land use area, an error message is generated in Column L since one BMP cannot treat an area greater than the land use area. If the user enters a total acreage for all BMPs that exceeds the area of the land use, a warning message will be generated. This warning does not prevent the user from proceeding, since the total acreage for multiple BMPs may exceed the total land use acreage. For example, assume runoff from a 1 acre commercial area drains to an underground infiltration BMP. The area may also include a 0.2 acre green roof, resulting in 1.2 acres of BMP for the 1 acre commercial area. Generally, it is unlikely the BMP acreage will exceed the land use area.
 
*Input: The area, in acres, tributary to the BMP. Different BMPs are contained in different columns.
 
*Input: The area, in acres, tributary to the BMP. Different BMPs are contained in different columns.
**Column B: Biofiltration (bioretention with underdrain)
+
**Column B: <span title="a bioretention practice having an underdrain. All water entering the practice is filtered through engineered media and filtered water is returned to the storm sewer system."> [https://stormwater.pca.state.mn.us/index.php?title=Bioretention '''biofiltration''']</span> (bioretention with underdrain)
**Column C: Infiltration (BMP with no underdrain)
+
**Column C: <span title="Infiltration Best Management Practices (BMPs) treat urban stormwater runoff as it flows through a filtering medium and into underlying soil, where it may eventually percolate into groundwater. The filtering media is typically coarse-textured and may contain organic material, as in the case of bioinfiltration BMPs."> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices '''infiltration''']</span> (BMP with no underdrain)
**Column D: Filter Strip
+
**Column D: <span title="an area of permanent vegetation or other material used to reduce sediment, organics, nutrients, pesticides, and other contaminants from runoff and to maintain or improve water quality.> '''[https://stormwater.pca.state.mn.us/index.php?title=Overview_for_pretreatment_vegetated_filter_strips filter strip]'''</span>
**Column E: Landscaped roof (Green roof)
+
**Column E: Landscaped roof (<span title="Green roofs consist of a series of layers that create an environment suitable for plant growth without damaging the underlying roof system. Green roofs create green space for public benefit, energy efficiency, and stormwater retention/ detention."> '''[https://stormwater.pca.state.mn.us/index.php?title=Green_roofs green roof]'''</span>)
**Column F: Permeable pavement with underdrain
+
**Column F: <span title="Permeable pavements allow stormwater runoff to filter through surface voids into an underlying stone reservoir for temporary storage and/or infiltration. The most commonly used permeable pavement surfaces are pervious concrete, porous asphalt, and permeable interlocking concrete pavers (PICP)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Permeable_pavement permeable pavement]'''</span> with underdrain
**Column G: Sand filter
+
**Column G: <span title="filtration of stormwater through a sand filtering material whose purpose is to remove pollution from runoff"> '''[https://stormwater.pca.state.mn.us/index.php?title=Filtration sand filter]'''</span>
**Column H: Swale
+
**Column H: <span title="are configured as shallow, linear channels. They typically have vegetative cover such as turf or native perennial grasses"> [https://stormwater.pca.state.mn.us/index.php?title=Dry_swale_(Grass_swale) '''swale''']</span>
**Column I: Wet basin
+
**Column I: Wet basin (<span title="a stormwater retention basin that includes a combination of permanent pool storage and extended detention storage above the permanent pool to provide additional water quality or rate control"> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_ponds '''wet pond''']</span>)
**Column J: Wetland
+
**Column J: <span title="Stormwater wetlands are similar in design to stormwater ponds and mainly differ by their variety of water depths and associated vegetative complex."> '''[https://stormwater.pca.state.mn.us/index.php?title=Stormwater_wetlands stormwater wetland]'''</span>
 
**Column K: Other
 
**Column K: Other
:Note: Read the subheadings carefully to ensure that the information is entered under the correct pollutant of concern.
+
**Column L: Displays an alert if total acres treated exceed the acres for a specific land use
 
*Source of Information: User
 
*Source of Information: User
  
'''Rows 35, 56, 77, and 98'''
+
'''Row 66'''
 
*Description: The removal efficiencies for listed BMPs
 
*Description: The removal efficiencies for listed BMPs
*Input: None or User input.  Removal efficiencies are based on information from the Minnesota Stormwater Manual and the Minimal Impact Design Standards (MIDS) calculator. BMP database sources shown below include compilations of data from multiple studies.  The User may input other values based on field studies or published BMP performance data.
+
*Input: None or user input.  <span title="Pollutant removal efficiency, usually represented by a percentage, specifically refers to the pollutant reduction from the inflow to the outflow of a system"> '''Removal efficiencies'''</span> are based on information from the [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_pollutant_removal,_stormwater_credits Minnesota Stormwater Manual] and the [https://stormwater.pca.state.mn.us/index.php?title=Minimal_Impact_Design_Standards Minimal Impact Design Standards] (MIDS) calculator. BMP database sources shown below include compilations of data from multiple studies.  The user may input other values based on field studies or published BMP performance data. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will be generated if the user attempts to enter a value greater than 1.
:Note: With the biofiltration BMP, the User will select the removal efficiency based on the type of media present within the BMP. If the media mix used is C or D, or if another mix is used that has a phosphorus content of 30 mg/kg or less per the Mehlich 3 test, then the User shall select the phosphorus removal fraction of 0.44. If another media type is present that has a phosphorus content greater than 30 mg/kg then the User shall select a phosphorus removal fraction of 0.
+
 
:Note: Typically a manufacturer will supply the pollutant removal data for their device.  The International BMP Database and USEPA Verified Technologies have pollutant removal information that can be used to verify manufacturer’s data.
+
[[File:Engineered media bmps.gif|thumb|300px|alt=gif image of bmps with engineered media|<font size=3>Bioretention BMPs that utilize engineered media include bioretention (rain gardens), tree trenches, tree boxes, and bioswales. Read the adjacent text regarding phosphorus retention in BMPs that utilize engineered media.</font size>]]
*Sources of Information:
+
 
**MN Stormwater Manual
+
With the biofiltration BMP, the default removal efficiency is 0.44. This assumes the <span title="Engineered media is a mixture of sand, fines (silt, clay), and organic matter utilized in stormwater practices, most frequently in bioretention practices. The media is typically designed to have a rapid infiltration rate, attenuate pollutants, and allow for plant growth."> [https://stormwater.pca.state.mn.us/index.php?title=Design_criteria_for_bioretention#Materials_specifications_-_filter_media '''engineered media''']</span> mix is C or D, or if another mix is used the phosphorus content is 30 mg/kg or less per the Mehlich 3 test. If Mix A, B, E, or F is used, or if the media P content exceeds 0.30 mg/kg, or if the media mix is not C or D and has not been tested, the user should enter a phosphorus removal fraction of 0.0 (i.e. the BMP will not retain phosphorus through filtration). Even if the removal efficiency is 0, some phosphorus will be retained by the BMP through infiltration, assuming the BMP does not have an impermeable liner. If the BMP has a liner, change the infiltration fraction to 0.
**[http://www.bmpdatabase.org/performance-summaries.html International BMP Database], 2012
+
 
**[http://www.epa.gov/nrmrl/std/etv/vt-wqp.html USEPA Verified Technologies]
+
{{alert|The Estimator assumes engineered media utilized in a filtration practice will not leach phosphorus. For more information, see [[Engineered (bioretention) media mixes for stormwater applications]].|alert-warning}}
**[http://www.stormwatercenter.net/Library/STP-Pollutant-Removal-Database.pdf Center for Watershed Protection], 2000
+
 
**[http://ciceet.unh.edu/news/releases/stormwater_report_05/Stormwater_05-03-06.pdf University of New Hampshire Stormwater Center Data Report], 2005  
+
When considering manufactured treatment devices, determine the appropriate column. These are typically proprietary filtration devices and may be addressed in Column B (Biofiltration), Column K (Other), or elsewhere if appropriate. Typically a manufacturer will supply the pollutant removal data for their device.  The International BMP Database, USEPA Verified Technologies, Washington State's TAPE Program, and New Jersey's NJCAT Program have pollutant removal information that can be used to verify manufacturer’s data.
 +
*Source of Information: MPCA Input, but user can change the value.
 +
 
 +
Links to additional information
 +
*[https://stormwater.pca.state.mn.us/index.php?title=Stormwater_pollutant_removal,_stormwater_credits MN Stormwater Manual]
 +
*[http://www.bmpdatabase.org/performance-summaries.html International BMP Database], 2012
 +
*[http://www.epa.gov/nrmrl/std/etv/vt-wqp.html USEPA Verified Technologies]
 +
*[https://www.wastormwatercenter.org/tape-program Washington State TAPE program]
 +
*[http://www.njcat.org/verification-process.html New Jersey NJCAT Program] - Note that NJCAT utilizes lab testing only
 +
*[http://www.stormwatercenter.net/Library/STP-Pollutant-Removal-Database.pdf Center for Watershed Protection], 2000
 +
*[http://ciceet.unh.edu/news/releases/stormwater_report_05/Stormwater_05-03-06.pdf University of New Hampshire Stormwater Center Data Report], 2005  
  
'''Rows 36, 57, 78, and 99'''
+
'''Row 67'''
 
*Description: The fraction of the annual runoff that is treated by the BMP. This is based on the amount of total runoff that enters the BMP.  
 
*Description: The fraction of the annual runoff that is treated by the BMP. This is based on the amount of total runoff that enters the BMP.  
*Input: None or User input
+
*Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
*Source of Information: MPCA Input. The default value is set for 1.0 for wet basins and wetlands based on the assumption that all annual runoff passes through these BMPs. The default value is set at 0.9 for the remaining BMPs assuming the BMPs are designed to treat 1.0 inches of runoff. This is the most common performance goal, but this value must be changed if other performance goals are used. The User can calculate annual runoff treated by a BMP by using the [[MIDS calculator]], or can estimate the value from the following data from the Minneapolis-St. Paul International Airport.
+
*Source of Information: MPCA Input, but user can change the value. The default value is set for 1.0 for wet basins (constructed ponds) and constructed wetlands based on the assumption that all annual runoff passes through these BMPs. This is approximately correct for ponds and wetlands built to [https://www3.epa.gov/npdes/pubs/sw_nurp_vol_1_finalreport.pdf National Urban Runoff Program] (NURP) standards, but may be inaccurate for smaller ponds and wetlands. The default value is set at 0.9 for the remaining BMPs assuming [https://stormwater.pca.state.mn.us/index.php?title=Design_infiltration_rate_as_a_function_of_soil_texture_for_bioretention_in_Minnesota B soils] and the BMPs are designed to treat 1.0 inch of runoff from impervious surfaces. One inch is the most common performance goal, but this value must be changed if other performance goals are used. The user should also consider adjusting this value based on soil type <span title="The SCS curve number method is a widely used method for determining the approximate amount of runoff from a rainfall even in a particular area. The curve number is based on the area's hydrologic soil group, land use , treatment and hydrologic condition."> '''curve numbers'''</span>. The value would be adjusted upward for coarser soils and for areas with increased impervious cover, assuming bmps are sized to treat runoff from impervious surfaces. The user can calculate annual runoff treated by a BMP by using the [[MIDS calculator]], or can estimate the value from the following data from the Minneapolis-St. Paul International Airport. For more guidance, [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Adjusting_the_fraction_of_annual_water_treated_and_infiltrated_in_a_BMP link here].
 +
 
 +
{| class="wikitable sortable"
 +
|+Annual runoff as a function of precipitation at Minneapolis-St. Paul International airport. Knowing how a BMP is sized, this table can be used to estimate the annual volume treated by the BMP.
 +
|-
 +
! Daily precipitation (in) !! Cumulative annual rainfall
 +
|-
 +
| 0.25 || 45%
 +
|-
 +
| 0.50 || 65%
 +
|-
 +
| 0.75 || 82%
 +
|-
 +
| 1.00 || 90%
 +
|-
 +
| 1.25 || 93%
 +
|-
 +
| 1.50 || 95%
 +
|-
 +
| 3.00 || 99%
 +
|-
 +
| 9.00 || 100%
 +
|}
 +
 
 +
'''Row 68'''
 +
*Description: The fraction of the treated water that is infiltrated by the BMP. Defaults are 90 percent for all infiltration BMPs, 20 percent for biofiltration practices, 20 percent for permeable pavement with an underdrain, and 0 percent for the remaining bmps. All of the water captured by an infiltration BMP is assumed to infiltrate into the soil underlying the BMP. If an infiltration practice is sized to capture more or less than 90 percent of annual runoff, this value should be adjusted accordingly. The [[MIDS calculator]] can be used to estimate volume loss in BMPs with an underdrain. Typical infiltration in a BMP with an underdrain and an underlying D soil will be about 20 percent (0.20); thus the 20 percent value for biofiltration and permeable pavement with an underdrain. The assumption that no water infiltrates in the remaining BMPs is a conservative assumption, since some water always infiltrates through the bottom unless the BMP is lined. If the user changes the default value, an alert displays in Column L.
 +
*Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
 +
*Source of Information: MPCA Input, but user can change the value.
 +
 
 +
'''Row 69'''
 +
*Description: The total pollutant reduced (pounds) from each BMP type.  The reduction equals the fraction of total area treated by the BMP within each land use multiplied by the removal efficiency of the BMP, summed across all land uses. The total reduction for all BMPs combined is calculated and shown in Column L.
 +
*Input: None
 +
*Source of Information: Auto-calculated
 +
 +
'''Row 70'''
 +
*Description: The percent reduction in total load for the pollutant of concern from each BMP type. The percent reduction is calculated by dividing pounds reduced by total load and multiplying by 100. The total percent reduction for all BMPs combined is calculated and shown in Column L.
 +
*Input: None
 +
*Source of Information: Auto-calculated
 +
 
 +
===Section 4: Calculations for TSS load reductions associated with BMP implementation===
 +
<div style="float:right">
 +
<table class="infobox" style="border:3px; border-style:solid; border-color:#FF0000; text-align: left; width: 300px; font-size: 100%">
 +
<tr>
 +
<th><center><font size=3>'''Tips for entering structural Best Management Practices'''</font size></center></th>
 +
</tr>
 +
<tr>
 +
<td>'''Sections 3 (total phosphorus) and 4 (TSS) address reductions in pollutant loading associated with implementation of structural BMPs. Below are some tips for entering data in these sections.'''
 +
*The area treated by a BMP cannot exceed the total acreage within a specific land use
 +
*Examine the values in rows 66-68 for total phosphorus and rows 91-93 for TSS. Guidance on adjusting these and rationale for the defaults is [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Tips_for_using_the_Estimator provided here].
 +
*If multiple BMPs are used in series, consider adjusting the removal efficiency downward for downstream BMPs. For more information, [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Tips_for_using_the_Estimator link here].
 +
</td>
 +
</tr>
 +
</table>
 +
</div>
 +
 
 +
[[File:Section 4.png|thumb|500px|alt=image estimator|<font size=3>Screen shot showing the section where reductions in TSS loading are calculated in the MPCA Estimator.</font size>]]
 +
 
 +
In this section of the worksheet the user enters acreages for BMPs implemented within each land use in the subwatershed. The section comprises Cells A72 through L95. The area treated by a BMP cannot exceed the total acreage within a specific land use (i.e. an error message is returned if the user attempts to enter an acreage greater than the total acres in a land use). If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.
 +
 
 +
'''Note''': it is possible for treated acres to exceed total acres when multiple BMPs are employed. The warning alerts the user to this situation, in which case the user should ensure the entered values are correct. If treated acres do exceed total acres, the user should consider adjusting removal efficiencies for downstream BMPs that are receiving water treated by upstream BMPs.
 +
 
 +
{{alert|The area treated by a BMP cannot exceed the total acreage within a specific land use|alert-warning}}
 +
{{alert|If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.|alert-warning}}
 +
 
 +
'''Rows 72 through 90'''
 +
*Description: The area, in acres, treated by the BMP, for different land uses. Land uses are listed in Column A.
 +
 
 +
These cells represent the area tributary to a BMP, which may not be the entire area for the type of land use. Not all cells need to be filled in. The user should only enter data in the cells relating to the specific BMPs and the land use classification of the BMP's drainage area.
 +
 
 +
If the user attempts to enter BMP acreages greater than the land use area, an error message is generated since one BMP cannot treat an area greater than the land use area. If the user enters a total acreage for all BMPs that exceeds the area of the land use, a warning message will be generated. This warning does not prevent the user from proceeding, since the total acreage for multiple BMPs may exceed the total land use acreage. For example, assume runoff from a 1 acre commercial area drains to an underground infiltration BMP. The area may also include a 0.2 acre green roof, resulting in 1.2 acres of BMP for the 1 acre commercial area. Generally, it is unlikely the BMP acreage will exceed the land use area.
 +
*Input: The area, in acres, tributary to the BMP. Different BMPs are contained in different columns.
 +
**Column B: <span title="a bioretention practice having an underdrain. All water entering the practice is filtered through engineered media and filtered water is returned to the storm sewer system."> [https://stormwater.pca.state.mn.us/index.php?title=Bioretention '''biofiltration''']</span> (bioretention with underdrain)
 +
**Column C: <span title="Infiltration Best Management Practices (BMPs) treat urban stormwater runoff as it flows through a filtering medium and into underlying soil, where it may eventually percolate into groundwater. The filtering media is typically coarse-textured and may contain organic material, as in the case of bioinfiltration BMPs."> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices '''infiltration''']</span> (BMP with no underdrain)
 +
**Column D: <span title="an area of permanent vegetation or other material used to reduce sediment, organics, nutrients, pesticides, and other contaminants from runoff and to maintain or improve water quality.> '''[https://stormwater.pca.state.mn.us/index.php?title=Overview_for_pretreatment_vegetated_filter_strips filter strip]'''</span>
 +
**Column E: Landscaped roof (<span title="Green roofs consist of a series of layers that create an environment suitable for plant growth without damaging the underlying roof system. Green roofs create green space for public benefit, energy efficiency, and stormwater retention/ detention."> '''[https://stormwater.pca.state.mn.us/index.php?title=Green_roofs green roof]'''</span>)
 +
**Column F: <span title="Permeable pavements allow stormwater runoff to filter through surface voids into an underlying stone reservoir for temporary storage and/or infiltration. The most commonly used permeable pavement surfaces are pervious concrete, porous asphalt, and permeable interlocking concrete pavers (PICP)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Permeable_pavement permeable pavement]'''</span> with underdrain
 +
**Column G: <span title="filtration of stormwater through a sand filtering material whose purpose is to remove pollution from runoff"> '''[https://stormwater.pca.state.mn.us/index.php?title=Filtration sand filter]'''</span>
 +
**Column H: <span title="are configured as shallow, linear channels. They typically have vegetative cover such as turf or native perennial grasses"> [https://stormwater.pca.state.mn.us/index.php?title=Dry_swale_(Grass_swale) '''swale''']</span>
 +
**Column I: Wet basin (<span title="a stormwater retention basin that includes a combination of permanent pool storage and extended detention storage above the permanent pool to provide additional water quality or rate control"> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_ponds '''wet pond''']</span>)
 +
**Column J: <span title="Stormwater wetlands are similar in design to stormwater ponds and mainly differ by their variety of water depths and associated vegetative complex."> '''[https://stormwater.pca.state.mn.us/index.php?title=Stormwater_wetlands stormwater wetland]'''</span>
 +
**Column K: Other
 +
**Column L: Displays an alert if total acres treated exceed the acres for a specific land use
 +
*Source of Information: User
 +
 
 +
'''Row 91'''
 +
*Description: The removal efficiencies for listed BMPs
 +
*Input: None or user input.  <span title="Pollutant removal efficiency, usually represented by a percentage, specifically refers to the pollutant reduction from the inflow to the outflow of a system"> '''Removal efficiencies'''</span> are based on information from the [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_pollutant_removal,_stormwater_credits Minnesota Stormwater Manual] and the [https://stormwater.pca.state.mn.us/index.php?title=Minimal_Impact_Design_Standards Minimal Impact Design Standards] (MIDS) calculator. BMP database sources shown below include compilations of data from multiple studies.  The user may input other values based on field studies or published BMP performance data. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will be generated if the user attempts to enter a value greater than 1.
 +
 
 +
Typically a manufacturer will supply the pollutant removal data for their device.  The International BMP Database, USEPA Verified Technologies, Washington State's TAPE Program, and New Jersey's NJCAT Program have pollutant removal information that can be used to verify manufacturer’s data.
 +
 
 +
Sources of Information: MPCA Input, but user can change the value.
 +
 
 +
Links to additional information
 +
*[https://stormwater.pca.state.mn.us/index.php?title=Stormwater_pollutant_removal,_stormwater_credits MN Stormwater Manual]
 +
*[http://www.bmpdatabase.org/performance-summaries.html International BMP Database], 2012
 +
*[http://www.epa.gov/nrmrl/std/etv/vt-wqp.html USEPA Verified Technologies]
 +
*[https://www.wastormwatercenter.org/tape-program Washington State TAPE program]
 +
*[http://www.njcat.org/verification-process.html New Jersey NJCAT Program] - Note that NJCAT utilizes lab testing only
 +
*[http://www.stormwatercenter.net/Library/STP-Pollutant-Removal-Database.pdf Center for Watershed Protection], 2000
 +
*[http://ciceet.unh.edu/news/releases/stormwater_report_05/Stormwater_05-03-06.pdf University of New Hampshire Stormwater Center Data Report], 2005
  
 +
'''Row 92'''
 +
*Description: The fraction of the annual runoff that is treated by the BMP. This is based on the amount of total runoff that enters the BMP.
 +
*Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
 +
*Source of Information: MPCA Input, but user can change the value. The default value is set for 1.0 for wet basins (constructed ponds) and constructed wetlands based on the assumption that all annual runoff passes through these BMPs. This is approximately correct for ponds and wetlands built to [https://www3.epa.gov/npdes/pubs/sw_nurp_vol_1_finalreport.pdf National Urban Runoff Program] (NURP) standards, but may be inaccurate for smaller ponds and wetlands. The default value is set at 0.9 for the remaining BMPs assuming [https://stormwater.pca.state.mn.us/index.php?title=Design_infiltration_rate_as_a_function_of_soil_texture_for_bioretention_in_Minnesota B soils] and the BMPs are designed to treat 1.0 inch of runoff from impervious surfaces. One inch is the most common performance goal, but this value must be changed if other performance goals are used. The user should also consider adjusting this value based on soil type <span title="The SCS curve number method is a widely used method for determining the approximate amount of runoff from a rainfall even in a particular area. The curve number is based on the area's hydrologic soil group, land use , treatment and hydrologic condition."> '''curve numbers'''</span>. The value would be adjusted upward for coarser soils and for areas with increased impervious cover, assuming bmps are sized to treat runoff from impervious surfaces. The user can calculate annual runoff treated by a BMP by using the [[MIDS calculator]], or can estimate the value from the following data from the Minneapolis-St. Paul International Airport. For more guidance, [https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Adjusting_the_fraction_of_annual_water_treated_and_infiltrated_in_a_BMP link here].
  
 
{{:Daily precipitation vs annual runoff MSP airport}}
 
{{:Daily precipitation vs annual runoff MSP airport}}
  
 +
'''Row 93'''
 +
*Description: The fraction of the treated water that is infiltrated by the BMP. Defaults are 90 percent for all infiltration BMPs, 20 percent for biofiltration practices, 20 percent for permeable pavement with an underdrain, and 0 percent for the remaining bmps. All of the water captured by an infiltration BMP is assumed to infiltrate into the soil underlying the BMP. If an infiltration practice is sized to capture more or less than 90 percent of annual runoff, this value should be adjusted accordingly. The [[MIDS calculator]] can be used to estimate volume loss in BMPs with an underdrain. Typical infiltration in a BMP with an underdrain and an underlying D soil will be about 20 percent (0.20); thus the 20 percent value for biofiltration and permeable pavement with an underdrain. The assumption that no water infiltrates in the remaining BMPs is a conservative assumption, since some water always infiltrates through the bottom unless the BMP is lined. If the user changes the default value, an alert displays in Column L.
 +
*Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
 +
*Source of Information: MPCA Input, but user can change the value.
  
'''Rows 37, 58, 79, and 100'''
+
'''Row 94'''
*Description: The fraction of the treated water that is infiltrated by the BMP. Defaults are 100 percent for all infiltration BMPs and 0 percent for the rest. All of the water captured by an infiltration BMP is assumed to infiltrate into the soil underlying the BMP. The assumption that no water infiltrates in the remaining BMPs is a conservative assumption, since some water always infiltrates through the bottom unless the BMP is lined. The [[MIDS calculator]] can be used to estimate volume loss in BMPs with an underdrain. Typical infiltration in a BMP with an underdrain and an underlying D soil will be about 20 percent (0.20).
+
*Description: The total pollutant reduced (pounds) from each BMP type.  The reduction equals the fraction of total area treated by the BMP within each land use multiplied by the removal efficiency of the BMP, summed across all land uses.  The total reduction for all BMPs combined is calculated and shown in Column L.
*Input: None or User input
+
*Input: None.
*Source of Information: MPCA Input, but User can change the value in the ''Input values for MPCA estimator'' tab.
 
 
 
'''Rows 38, 59, 80, and 101'''
 
*Description: The total pollutant reduced (pounds for phosphorus and TSS; number for E. coli and fecal coliform) from each BMP type.  The reduction equals the fraction of total area treated by the BMP within each land use multiplied by the removal efficiency of the BMP, summed across all land uses.  The total reduction for all BMPs combined is calculated and shown in Column W for each of the four pollutants.
 
*Input: None
 
 
*Source of Information: Auto-calculated
 
*Source of Information: Auto-calculated
 
   
 
   
'''Rows 39, 60, 81, and 102'''
+
'''Row 95'''
*Description: The percent reduction in total load for the pollutant of concern from each BMP type. The percent reduction is calculated by dividing pounds reduced by total load and multiplying by 100. The total percent reduction for all BMPs combined is calculated and shown in Column L for each of the four pollutants.
+
*Description: The percent reduction in total load for the pollutant of concern from each BMP type. The percent reduction is calculated by dividing pounds reduced by total load and multiplying by 100. The total percent reduction for all BMPs combined is calculated and shown in Column L.
 
*Input: None
 
*Input: None
 
*Source of Information: Auto-calculated
 
*Source of Information: Auto-calculated
  
===Default values for the Estimator===
+
===Section 5: Default values for BMP and land use inputs===
[[file:Screen shot of defaults for estimator.png|300px|thumb|alt=screen shot estimator defaults|<font size=3>Screen shot showing default values for the estimator.</font size>]]
+
[[File:Estimator default screen shot.png|500px|thumb|alt=screen shot estimator defaults|<font size=3>Screen shot showing default values for the estimator.</font size>]]
  
In the Estimator, the tab (worksheet) called ''Input values for MPCA estimator'' contains default values for filter BMP performance, event mean concentrations (EMCs), and runoff coefficients.  The values for BMP performance are only for the water that is filtered and are expressed as fractions, which represents the fraction of pollutant that is removed by the BMP. A value of 0.50, for example, means the BMP removes half of the pollutant. Note that the values for infiltration BMPs is 0 because it is assumed that all pollutant in infiltrated water is removed. The equations built in to the Estimator account for this complete removal for infiltrated water. Removal values are shown for total phosphorus, total suspended solids, E. coli, and fecal coliform.
+
This section of each of the 10 calculation worksheets contains default values for BMP performance (pollutant removal fractions), event mean concentrations (EMCs), runoff coefficients, fraction of water treated, and fraction of water infiltrated.  The values for removal fraction are only for the water that is captured (fraction of water treated) and are expressed as fractions, which represents the fraction of pollutant that is removed by the BMP through filtration. A value of 0.50, for example, means the BMP removes half of the pollutant. For infiltration, the fraction is 0 because treatment occurs through infiltration rather than filtration. All pollutant is considered removed for infiltration practices. The equations built in to the Estimator account for this complete removal for infiltrated water. Removal values are shown for TP and TSS.
 +
 
 +
Users cannot change the values in this section. The values are used as a check. When a user changes a default in Sections 1, 2, 3, or 4, comparison of the changed value with the defaults in Section 5 trigger a warning that the user changed a default value.
 +
 
 +
[https://stormwater.pca.state.mn.us/index.php?title=Guidance_and_examples_for_using_the_MPCA_Estimator#Tips_for_using_the_Estimator This section] provides additional information and links to information on emcs, runoff coefficients, pollutant removal, and treatment fractions.
 +
 
 +
==Tips for using the Estimator==
 +
The Estimator is a simple tool based on simple assumptions. This section contains some tips for applying the tool to different situations that you may encounter.
  
EMCs are given for several different land uses and for total phosphorus, TSS, E. coli, and fecal coliform. Runoff coefficients are given for several different land uses.
+
{{alert|It is ''Highly Recommended'' you keep all information you use to calculate reductions|alert-warning}}
  
The user can change the default values in this tab. Once changed, the default values are lost, although they can be re-entered.
+
===Addressing treatment trains===
 +
The Estimator does not explicitly address stormwater <span title="multiple BMPs that work together to remove pollutants utilizing combinations of hydraulic, physical, biological, and chemical methods"> [https://stormwater.pca.state.mn.us/index.php?title=Using_the_treatment_train_approach_to_BMP_selection '''treatment trains''']</span>. It will therefore either underestimate or overestimate pollutant removal for BMPs that are in series, depending on how they are addressed in the spreadsheet. For example, in a treatment train consisting solely of ponds, the first pond removes the greatest fraction of pollutant concentration. Each pond in succession will treat less polluted water but will further the reduction in pollutant concentration flowing downstream. The Estimator doesn’t recognize the total number of BMPs on the ground so it cannot recognize BMPs as being connected. Therefore each pond is assumed to treat the same degree of polluted water regardless of how many are connected in a treatment train.
  
==Example calculations using the MPCA Estimator==
+
We recommend that BMPs in a treatment train be considered as possible separate sub-watersheds. Using this approach, only the area draining to a single BMP is considered in a worksheet.
Download MPCA Estimator here: [[file:MPCA_Estimator.xlsx]]
 
  
[[file:example map for simple estimator example.png|300px|thumb|left|alt=map used for simple estimator example|<font size=3>Map used for the MPCA Estimator example. Note there are four impaired waters (3 lakes and a stream) and 4 MS4s (3 cities and a college). MS4 boundaries, watersheds of the impaired lakes, and the location of BMPs are shown and described in the legend. Only structural BMPs that are required to be quantified are included in the map.</font size>]]
+
If BMPs in a treatment train are not treated separately, adjusting the Estimator to more closely simulate pollutant removal for treatment trains can be challenging since the Estimator uses a lumped BMP approach in which all similar BMPs are lumped as a single BMP. For example, permeable pavement with no underdrain, bioinfiltration, and infiltration basins are all lumped together as infiltrator BMPs. Another complication is that each treatment train differs and attempting to model them as a single system creates inaccuracies.
 +
<!--
 +
To get an idea of how to adjust the Estimator to account for treatment trains, we ran a series of treatment train scenarios through the MIDS calculator and compared them to results for the Estimator. A more detailed description of this exercise, including results, is in a Word document ([[file:treatment trains.docx]]. Recommendations are summarized below.
 +
*The Estimator appears to provide reasonable results when infiltration practices are employed in a treatment train. Pollutant removal fractions in the ''Input values for MPCA Estimator'' tab could be adjusted slightly upward (e.g. 2 to 3 percent).
 +
*The Estimator underestimates treatment when filtration and settling practices are utilized. Pollutant removal fractions in the ''Input values for MPCA Estimator'' tab should be adjusted by upward 0.10 units.
 +
Tables with recommended values for pollutant removal fractions are in a Word document ([[file:treatment trains.docx]]).
 +
-->
  
[[file:screen shot inputs for simple estimator example.png|500px|thumb|alt=screen shot of inputs used for the MPCA Estimator example|<font size=3>Screen shot showing inputs used for the MPCA Estimator example. The inputs match the information provided in the map.</font size>]]
+
===Adjusting EMCs (event mean concentrations)===
 +
If you are calculating reductions in loading as a percent, modifying the EMCs in the unadjusted load section will not affect your results. If you are calculating reductions in pounds or pounds per acre, the EMC affects the initial pollutant load. The higher the initial load the greater the reduction when the BMPs are applied. For more information on EMCs, go to the following links.
  
Example calculations were made for reductions in pollutant loading for the map shown to the left.  There are 4 MS4s (City A, City B, City C, and the MS4 College) and 4 impaired waters (Lake 1, Lake 2, Lake 3, and Stream 1). The lakes are impaired for phosphorus and the stream is impaired for TSS and E. coli bacteria. Below is a summary of MS4 contributions to each impaired water.
+
*[[Event mean concentrations of total suspended solids in stormwater runoff]]
*City A drains to Lake 1, Lake 2 and Lake 3. It does not operate any BMPs in the Lake 3 watershed but has BMPs in the watersheds for Lake 1 and Lake 2. The estimator must therefore be used twice, one for each impairment the City contributes to and for which the City has implemented BMPs to decrease its phosphorus load.
+
*[[Event mean concentrations of total and dissolved phosphorus in stormwater runoff]]
*City B drains to Lake 1 and Lake 2 but has not implemented any structural BMPs. There are no pollutant reductions to calculate.
 
*City C drains to all four impairments. It has implemented BMPs to decrease the pollutant load to Lake 2, Lake 3, and Stream 1. The estimator will therefore be run three times; once for each impaired water where the City has implemented BMPs to decrease its pollutant load.
 
*MS4 College drains to Lake 1 and has implemented a BMP to decrease its pollutant load. The estimator can be used.
 
  
===City A===
+
===Adjusting the fraction of annual water treated and infiltrated in a BMP===
[[File:Screen shot estimator example city A lake1.PNG|300px|thumb|alt=screen shot of etimator results for City A|<font size=3>Results from using the MPCA Estimator for City A, Lake 1.</font size>]]
+
The default value for the fraction of runoff treated by BMPs is 0.9, except for wet basins (e.g. constructed ponds) and wetlands, where the value is 1.0.
 +
*The 0.9 corresponds with treatment of the first 1 inch of runoff on B soils (<span title="A soil classification system (Natural Resource Conservation System) based on runoff potential. Groups include A soils (coarse textured with very low runoff potential), B soils (medium coarse textured with low runoff potential), C soils (fine to moderate textured with moderate runoff potential), and D soils (fine textured with high runoff potential)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Design_infiltration_rates hydrologic soil group]'''</span>). This was determined through modeling with the Minimal Impact Design Standards (MIDS) Calculator. If you have a different performance goal (e.g. the 1.1 inch MIDS value), extensive pervious acreages, and/or different soils, we recommend adjusting this value. You can use the MIDS calculator to determine the appropriate value. We also provide some guidance below.
 +
*The value of 1.0 for wet basins and wetlands assumes all runoff is treated by the BMP. This value should be changed if this condition is not accurate.
 +
The table below can be used to determine the appropriate number. For example, if your soils were A rather than B, you should enter a value ranging from 0.92 to 0.96, depending on the specific soil type. If you had B soils but the water quality volume was 0.75 inches, the value should be changed to 0.81.
  
[[File:Screen shot estimator example city A lake2.PNG|300px|thumb|alt=screen shot of estimator results for City A|<font size=3>Results from using the MPCA Estimator for City A, Lake 2.</font size>]]
+
Similarly, the fraction of runoff that is infiltrated into an infiltrator BMP is 0.9. Again, this value should be adjusted if the water quality volume or soils differ from 1 inch and B soils or if there are significant pervious acreages contributing to runoff. The only other BMP in the Estimator that infiltrates water as the default is biofiltration. The infiltration fraction for this BMP is 0.2, which is based on data generated from [[MIDS calculator]] runs. Infiltration may occur in other BMPs, in particular permeable pavement with an underdrain and swales. A value of 0.2 can be entered for permeable pavement with underdrains to make it similar to biofiltration. An infiltration value for swales is difficult to generate because of the many potential swale configurations. The MIDS calculator is one tool that can be used to generate a value for fraction of water infiltrated in swales. If your BMP has an impermeable liner, assume there is no infiltration.
  
{{alert|Click on an image to enlarge it. Right click on the image to open an enlarged view in another tab.|alert-info}}
+
{{:Annual volume treated as a function of soil and water quality volume}}
  
City A comprises 585 acres within the Lake 1 watershed. The breakdown by specific land use is shown in the summary table above. The City has implemented 5 BMPs  within the watershed that can be included in the MPCA Estimator.
+
===Adjusting the pollutant removal fraction===
*INF3 and INF4 are infiltration BMPs (permeable pavement) in a high density residential area. The drainage area to INF3 is 0.9 acres and the drainage area to INF4 is 1.3 acres. The User therefore enters 2.2 acres in Row 28, Column C of the worksheet (Infiltration (BMP with no underdrain), high density residential land use).
+
The pollutant removal fraction is the most important factor affecting the calculations in the Estimator. The default values correspond with recommended values in the manual and represent well-defended data from the literature. The user can change the default, but any change should be supported with data. For further information on pollutant removal by BMPs, see the appropriate page in this manual on [http://stormwater.pca.state.mn.us/index.php/Category:Calculating_credits BMP pollutant credits]. Each of the credit articles contains information to help determine the most appropriate value for pollutant removal for a specific BMP.
*FIL3 is a media filter located within a high density residential area. The drainage area served by the BMP is 2.3 acres. The User enters 2.3 in Row 28, Column G (sand filter, high density residential land use).
 
*CB1 is a constructed wetland. Total drainage to the wetland is 3.2 acres, with 2 acres from a medium density residential area and 1.2 acres from a low density residential area. The User enters 1.2 in Row 29, Column J (wetland, low density residential land use) and 2 in Row 30, Column J (wetland, medium density residential).
 
*S1 is a swale that drains 1.6 acres, of which 1.1 is commercial land use and 0.5 acres is transportation land use. The User enters 1.1 in Row 22, Column H (swale, commercial land use) and 0.5 in Row 31, Column H (swale, transportation land use).
 
  
 +
===Addressing BMPs not included in the Estimator===
 +
[[File:Using the Other BMP.png|400px|thumb|alt=screen shot Simple Estimator|<font size=3>Screen shot for using the Other bmp in the Estimator. See text for discussion. Click on image to enlarge.</font size>]]
  
[[File:Create a new worksheet.PNG|300px|thumb|left|alt=screen shot showing how to create new worksheet|<font size=3>Screen shot illustrating how to create a new worksheet tab in the TMDL spreadsheet. The contents of the estimator tab can be copied into this worksheet, allowing multiple runs of the estimator in the same spreadsheet. There is no practical limit to the number of new worksheets that can be added to the spreadsheet.</font size>]]
+
The Estimator allows the user to enter an additional BMP beyond the default BMPs (called ''Other'' in the Estimator). Most urban BMPs fit into one of the default BMPs in the Estimator. There may be exceptions however, including but not limited to the following.
 +
*Underground filtration practices (these are largely proprietary)
 +
*Underground settling practices (these are largely proprietary)
 +
*Floating treatment wetlands
 +
*Enhanced <span title="Pretreatment reduces maintenance and prolongs the lifespan of structural stormwater BMPs by removing trash, debris, organic materials, coarse sediments, and associated pollutants prior to entering structural stormwater BMPs. Implementing pretreatment devices also improves aesthetics by capturing debris in focused or hidden areas. Pretreatment practices include settling devices, screens, and pretreatment vegetated filter strips."> [https://stormwater.pca.state.mn.us/index.php?title=Pretreatment '''pretreatment''']</span>
  
Using the defaults in the worksheet, reductions in phosphorus loading are shown in Rows 37 (total pounds reduced) and 38 (Percent load reduced). The total load reduction for all BMPs is 5.875 pounds, or about 1.00 percent of the original loading of 586.45 pounds. The User can enter either the pounds reduced (5.875) or the percent reduced (1.00) in the ''Cumulative reductions'' tab.
+
If you can determine values for pollutant removal fraction, fraction of water that is treated, and fraction of water that is infiltrated for the BMP, you can include an additional BMP. If these values cannot be generated for the BMP, calculate pollutant removal independently and add that value to the value generated by the Estimator when reporting cumulative reductions on the Annual Report form. For example, assume you had an in-line treatment system that treated stormwater runoff in a part of your conveyance system. This BMP is not easily incorporated into the Estimator, but if you monitor the BMP and have pollutant removal information, you can simply add the removal amount to the amount calculated by the Estimator for the remainder of your system.
  
The estimator only allows the user to estimate loads for one impaired water at a time. The User should either save the worksheet as a separate Excel file, keep a record of the inputs used for this impairment, or insert additional estimator worksheets into the spreadsheet. To create additional estimator worksheets within the spreadsheet, on the '''Home''' tab in Excel, click on '''Insert''' and select '''Insert Sheet'''. Then Copy the contents of the ''MPCA estimator'' tab into the new worksheet. Tabs within the spreadsheet can be renamed by double clicking on the tab at the bottom of the screen and then typing in a new name. See the image to the left and Excel Help for more information.
+
'''Example'''<br>
 +
Assume there is one (1) acre of commercial land use. This is entered in Section 1, Cell 8D. The total phosphorus load is 0.99 pounds per year. The entire one acre area drains to a stormwater sump basin that has received [https://ecology.wa.gov/Regulations-Permits/Guidance-technical-assistance/Stormwater-permittee-guidance-resources/Emerging-stormwater-treatment-technologies Washington State TAPE certification]. The device was certified for 85 percent TSS removal. Data from commercial areas suggests particulate phosphorus makes up 80 percent of total phosphorus. Because sumps are settling practices which remove coarser solids, assume only half the captured solids constitute TSS in receiving waters. The removal efficiency is therefore 0.85 * 0.80 * 0.5 = 0.34, or 34 percent removal of total phosphorus. The adjacent image shows how to incorporate this practice into the Estimator. Enter 1 acre in Cell K50 since the entire one acre drains to the device. There is no infiltration, so Cell K68 is 0. The device has a removal efficiency of 0.35, which is entered into Cell K66. The device is sized to treat 90 percent of the annual runoff from the area, so Cell K67 is 0.9. The device annually removes 0.311 pounds of phosphorus.
  
A new version of the estimator is run for the Lake 2 watershed. City A comprises 84 acres of this watershed and has implemented just one BMP that can be used in the estimator.  This is a bioinfiltration BMP that drains 2 acres of medium density residential area. this is an infiltration BMP, so the User enters 2 in row 30, Column C (Infiltration (BMP with no underdrain), Residential - medium density). this BMP results in a reduction of 2.004 pounds of phosphorus, or 2.46 percent of the original load of 81.33 pounds.
+
===Adjusting for impervious and pervious surface===
 +
The Estimator uses runoff coefficients to estimate the fraction of rainfall that runs off for different land uses. Default values are typical values from the literature. Runoff coefficients can be changed in Sections 1 and 2 of each calculation worksheet. Increase the runoff coefficient if your land use has greater impervious surface, or decrease the coefficient if it has less impervious surface. Ranges of values for runoff coefficients can be found [https://stormwater.pca.state.mn.us/index.php?title=Event_mean_concentrations_of_total_and_dissolved_phosphorus_in_stormwater_runoff#Accounting_for_differences_in_pollutant_loading here].
  
City A may conduct additional BMPs that decrease pollutant load. If these BMPs can be quantified, they can be entered as '''Other''' BMPs in the worksheet.
+
==Example 1: Using the MPCA Estimator with multiple subwatersheds==
 +
This example utilizes a site with three subwatersheds and proceeds through a series of implemented practices. To access the spreadsheet used for this example, click here [[File:MPCA simple estimator version 3 subwatershed example.xlsx]]
  
===City C===
+
===Step 1. Unadjusted load calculation and entering data for land uses===
City C comprises 297 acres of the Lake 2 watershed. The City has implemented one BMP that can be used in the estimator. This is a dry pond that drains 8 acres of medium density residential land use. The User enters 8 in Row 30, Column I (Wet basin, Residential - medium density). The resulting decrease in phosphorus loading is 4.453 pounds or 1.39 percent of the initial load of 319.67 pounds. This example again utilizes the default values in the worksheet.
+
[[File:Example image Step 1.png|300px|thumb|alt=image used for example|<font size=3>Schematic used for subwatershed example.</font size>]]
  
As with City A, the estimator can only be used for one impaired water at a time. The User must therefore run the estimator separately for Lake 3 and Stream 1.
+
The adjacent image is used for this example and will be modified as adjustments are made and BMPs added. The entire project area consists of three subwatersheds. Land uses within the project area include the following.
 +
*Residential with <25% tree canopy coverage
 +
*Residential with >50% tree canopy coverage
 +
*Industrial
 +
*Commercial
 +
*Park
 +
*Transportation
 +
*Mixed (multi-use)
 +
*Agricultural
  
City C comprises 366 acres of the Lake 3 watershed. The City has implemented two BMPs, an underground sand filter that serves 5 acres of medium density residential land use, and a 12 acre dry swale that serves 10 acres of commercial development and 2 acres of transportation. The User enters 5 in Row 30, Column G (Sand filter, residential - medium density), 10 in Row 22 Column H (Swale, Commercial), and 2 in Row 31, Column H (Swale, Transportation). The resulting total decrease in phosphorus load is 9.087 pounds or 2.24 percent of the total load of 405.62 pounds.
+
The entire area drains to a lake. The goal is to reduce phosphorus loading to the lake by 30 percent.
  
City C comprises 427 acres of the Stream 1 watershed (127 acres in the Oasis Lake watershed and 300 acres in the Lake 3 watershed). The City has implemented a dry swale that drains 10 acres of commercial land and 2 acres of transportation land use, and a tree trench that drains 8 acres of commercial land and 7 acres of industrial land. For the tree trench, the user enters 8 in Row 22, Column C (Commercial; Infiltration) and 7 in Row 23, Column C (industrial; infiltration). For the dry swale the User enters 10 in Row 22, Column H (Commercial; Swale) and 2 in Row 31, Column H (transportation; Swale). The resulting decrease in TSS load is 21,885.4 pounds or 9.78 percent of the initial load of 223,855 pounds. The decrease in E. coli load is 3.12 percent of the initial load. Note the swale does not reduce any of the E. coli load.
+
In this first step, we enter acreages for each of the three subwatersheds. These are shown in the adjacent image gallery. To account for the two different residential areas in subwatershed A, we change the default emc for residential to 0.350 mg/L for the high canopy area and add a residential land use with an emc of 0.275 for the low canopy area. For subwatersheds B and C, we change the default residential value to 0.35 mg/L to account for higher phosphorus inputs from trees in the high canopy areas. Alternatively, we could have made these adjustments for residential areas in the second section of the three worksheets (Adjusted loads). The total phosphorus load to the lake from all three watersheds is 2699.54 pounds. With a phosphorus reduction goal of 30 percent, this requires a 809.86 pound reduction in phosphorus loading.
  
<gallery caption="Screen shots of estimator results for City C. Click on an image for a larger view." widths="200px">
+
<gallery caption="Simple Estimator screen shots for unadjusted loads. Click on an image for enlarged view." widths="250px">
file:estimator example city C lake 2.png|alt=screen shot of estimator results for City C|<font size=3>Lake 2.</font size>
+
File:Example step 1.png|alt=Screen shot Estimator example|Screen shot showing inputs for land uses in Watershed A
file:estimator example city C lake 3.png|alt=screen shot of estimator results for City C|<font size=3>Lake 3.</font size>
+
File:Example step 1B.png|alt=Screen shot Estimator example|Screen shot showing inputs for land uses in Watershed B
file:estimator example city C stream.png|alt=screen shot of estimator results for City C, TSS|<font size=3>Stream 1; TSS</font size>
+
File:Example step 1C.png|alt=Screen shot Estimator example|Screen shot showing inputs for land uses in Watershed C
file:estimator example city C stream e coli.png|alt=screen shot of estimator results for City C, e coli|<font size=3>Stream 1; E coli</font size>
 
 
</gallery>
 
</gallery>
  
===MS4 College===
+
===Step 2. Calculating adjusted loads===
[[file:estimator example MS4 College.png|300px|thumb|left|alt=screen shot of results for MS4 college|<font size=3>Screen shot showing results and inputs for the estimator for the MS4 College.</font size>]]
+
[[File:Example Step 2.png|thumb|300px|alt=schematic for example|<font size=3>Actions implemented and accounted for in calculating adjusted loads. The implemented actions include enhanced street sweeping in the residential area with >50% tree canopy, an impervious disconnection program in the commercial area of subwatershed A, and conversion of agricultural land to mixed land use.</font size>]]
  
The MS4 College is a non-traditional regulated MS4. The area of the college is 84 acres and the college owns and operates the stormwater conveyance within the campus boundaries. The entire acreage of the college lies within the Lake 1 watershed. Land use within the campus consists of 15 acres of park and 69 acres of institutional land use.
+
Section 2 of each calculation worksheet allows the user to enter data that results in adjustments to the total load. In this example, the following actions were implemented (see adjacent image).
  
The college has constructed and operates one BMP (FIL1). The BMP is a perimeter sand filter that accepts runoff from a 3 acre area. The land use contributing runoff to the BMP is institutional. The User therefore enters 3 in row 24, Column G of the estimator (Sand filter, Institutional). The BMP decreases phosphorus loading by 1.391 pounds, or 1.77 percent from the initial load of 78.75 pounds.
+
*In the residential areas with >50% tree canopy coverage, an enhanced street sweeping program was implemented. This consisted of street sweeping at the time of fall leaf drop, rather than the once-a-fall sweeping program previously implemented. Measurements of street sweeping material collected during this time indicate this effort reduced annual loading by about 17 percent. Since the Estimator does not allow direct changes in loading, we adjusted the emc downward until we achieved a 17 percent reduction in loading. To accomplish this, we adjusted the emc from 0.35 mg/L to 0.30 mg/L. This resulted in a phosphorus decrease of 18.79 pounds in subwatershed A, 18.79 pounds in subwatershed B, and 7.51 pounds in Subwatersdhed C, for a total reduction of 45.09 pounds.
 +
*In the commercial area of subwatershed A, a rooftop and parking lot disconnection effort was implemented. Runoff from these areas was diverted to pervious surfaces. The runoff coefficient was adjusted downward from 0.71 to 0.50 based on the calculated decrease in connected impervious surface. This resulted in a phosphorus decrease of 21.91 pounds.
 +
*The agricultural areas in subwatersheds B and C were converted to mixed land use. We changed the emc and runoff coefficients from agricultural land use to the default values for mixed land use. Phosphorus loads increased by 137.76 pounds in subwatershed B and 150.28 pounds in subwatershed C. BMPs were implemented during the land use conversion, but these calculations are made in Section 3.
  
===Entering results into the Cumulative reductions tab===
+
After these adjustments, the phosphorus load increased by 221.04 pounds, assuming no further BMPs were implemented. The adjacent photo gallery provides screen shots for each of the three subwatersheds.
[[File:Screenshot estimator into cumulative reductions tab.PNG|300px|thumb|alt=screen shot of entering data into cumulative reductions tab|<font size=3>Screen shot illustrating entry of the results from City A into the Cumulative reductions tab.</font size>]]
 
  
Results of the MPCA estimator can be entered into the Cumulative reductions tab. This is illustrated in the image to the right for City A. In this example, for Lake 1 a value of 5.875 is entered into Row 4, Column F. In Column D the units are selected from the dropdown box, In this case the units are pounds reduced. For Lake 2 a value of 2.46 is entered in row 5, column F and the units are % load reduction.  The calculation method, which is an optional field, is entered as ''MPCA estimator''.
+
<gallery caption="Simple Estimator screen shots for adjusted loads. Click on an image for enlarged view." widths="250px">
 +
File:Example step 2A.png|alt=Screen shot Estimator example|Screen shot showing adjusted loads in Watershed A
 +
File:Example step 2B.png|alt=Screen shot Estimator example|Screen shot showing adjusted loads in Watershed B
 +
File:Example step 2C.png|alt=Screen shot Estimator example|Screen shot showing adjusted loads in Watershed C
 +
</gallery>
  
==Tips for using the estimator==
+
===Step 3. Entering structural best management practices (BMPs)===
The Estimator is a simple tool based on simple assumptions. This section contains some tips for applying the tool to different situations that you may encounter.
+
[[File:Example step 3b.png|thumb|300px|alt=schematic for Estimator example|<font size-3>Schematic illustrating where structural BMPs are implemented. Not shown are swales associated with transportation corridors.</font size>]]
 +
 
 +
In this section, structural BMPs are entered for each of the subwatersheds. The adjacent schematic illustrates where BMPs are implemented, except for swales associated with transportation corridors. A summary of the implemented practices is provided below.
 +
 
 +
*'''Subwatershed A.''' This subwatershed consists primarily of <span title="A soil classification system (Natural Resource Conservation System) based on runoff potential. Groups include A soils (coarse textured with very low runoff potential), B soils (medium coarse textured with low runoff potential), C soils (fine to moderate textured with moderate runoff potential), and D soils (fine textured with high runoff potential)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Design_infiltration_rates hydrologic soil group]'''</span> (HSG) C and D soils, making infiltration impractical.
 +
**Stormwater runoff in much of the area is diverted to <span title="a stormwater retention basin that includes a combination of permanent pool storage and extended detention storage above the permanent pool to provide additional water quality or rate control"> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_ponds '''wet pond''']</span> (constructed ponds). A total of 450 acres of mixed land use (multi-use) is treated by ponds and 400 acres of low canopy residential area is treated by ponds. This results in a phosphorus reduction of 330.31 pounds.
 +
**<span title="a bioretention practice having an underdrain. All water entering the practice is filtered through engineered media and filtered water is returned to the storm sewer system."> [https://stormwater.pca.state.mn.us/index.php?title=Bioretention '''Biofiltration''']</span> practices (rain gardens, with an underdrain) are implemented for 100 acres of the residential, high canopy area, resulting in a phosphorus reduction of 28.63 pounds
 +
**<span title="are configured as shallow, linear channels. They typically have vegetative cover such as turf or native perennial grasses"> [https://stormwater.pca.state.mn.us/index.php?title=Dry_swale_(Grass_swale) '''Swales''']</span> treat 75 acres of runoff from transportation areas, resulting in a reduction of 42.08 pounds of phosphorus
 +
:The total phosphorus reduction from these BMPs is 401.02 pounds
 +
*'''Subwatershed B.''' This subwatershed includes HSG A, B, and C soils. Infiltration is therefore feasible in some of the area.
 +
**Underground <span title="Infiltration Best Management Practices (BMPs) treat urban stormwater runoff as it flows through a filtering medium and into underlying soil, where it may eventually percolate into groundwater. The filtering media is typically coarse-textured and may contain organic material, as in the case of bioinfiltration BMPs."> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices '''infiltration''']</span> is utilized for 290 acres in the mixed land use areas, including the entire area where agricultural land was converted to mixed land use. This results in a reduction of 263.31 pounds of phosphorus.
 +
**Biofiltration is utilized for 100 acres of residential land, resulting in a reduction of 28.63 pounds.
 +
:The total phosphorus reduction in this subwatershed is 291.94 pounds.
 +
*'''Subwatershed C.''' This subwatershed includes HSG A, B, andC soils. Infiltration is therefore feasible in some of the area.
 +
**Underground infiltration is utilized for 280 acres in the mixed land use areas, including the entire area where agricultural land was converted to mixed land use. This results in a reduction of 254.23 pounds of phosphorus.
 +
**Biofiltration is utilized for 40 acres of residential land, resulting in a reduction of 11.45 pounds.
 +
**Swales are utilized in transportation corridors, treating 60 acres for a phosphorus reduction of 33.66 pounds
 +
**<span title="Iron-enhanced sand filters are filtration Best Management Practices (BMPs) that incorporate filtration media mixed with iron. The iron removes several dissolved constituents, including phosphate, from stormwater. Iron-enhanced sand filters may be particularly useful for achieving low phosphorus levels needed to improve nutrient impaired waters. "> [https://stormwater.pca.state.mn.us/index.php?title=Iron_enhanced_sand_filter_(Minnesota_Filter) '''Iron-enhanced sand filters''']</span> treat 60 acres of runoff in the industrial area. Note the phosphorus <span title="Pollutant removal efficiency, usually represented by a percentage, specifically refers to the pollutant reduction from the inflow to the outflow of a system"> '''removal efficiency'''</span> of this practice was change from 0.47 to 0.80 due to the use of iron in the treatment. The total phosphorus reduction for this practice is 48.03 pounds.
 +
:The total phosphorus reduction in this subwatershed is 347.37 pounds.
 +
 
 +
The total phosphorus reduction for the three subwatersheds is 819.29 pounds, which meets the target of 809.86 pounds. Note this included increased loads calculated in section 2 (adjusted loads) and decreased loads associated with BMP implementation. The adjacent image gallery provides screenshots from the Estimator for the three subwatersheds.
 +
 
 +
<gallery caption="Simple Estimator screen shots for implementation of structural BMPs. Click on an image for enlarged view." widths="250px">
 +
File:Section 3a.png|alt=Screen shot Estimator example|Screen shot showing loads in Watershed A after entering structural BMP data
 +
File:Section 3b.png|alt=Screen shot Estimator example|Screen shot showing loads in Watershed B after entering structural BMP data
 +
File:Section 3c.png|alt=Screen shot Estimator example|Screen shot showing loads in Watershed C after entering structural BMP data
 +
</gallery>
 +
 
 +
This example illustrates the following.
 +
*Infiltration is a very effective practice for removing phosphorus
 +
*Biofiltration in residential areas is only somewhat effective due to the low runoff coefficient; i.e. the practice does not treat a lot of runoff. For example, swales in subwatershed A remove more phosphorus even though swales are not particularly effective at removing phosphorus and less area is treated compared to residential land use. The higher removal is associated with the higher runoff coefficient for transportation, resulting in greater runoff volumes being treated.
 +
*We assume the <span title="Engineered media is a mixture of sand, fines (silt, clay), and organic matter utilized in stormwater practices, most frequently in bioretention practices. The media is typically designed to have a rapid infiltration rate, attenuate pollutants, and allow for plant growth."> [https://stormwater.pca.state.mn.us/index.php?title=Design_criteria_for_bioretention#Materials_specifications_-_filter_media '''engineered media''']</span> mixes for biofiltration do not leach phosphorus. These would be Mixes C or D, or use of some material in the mix that does not leach phosphorus, such as <span title="fiber from the outer husk of the coconut"> '''[https://stormwater.pca.state.mn.us/index.php?title=Coir_and_applications_of_coir_in_stormwater_management coir]'''</span> or <span title="Biochar is a charcoal-like substance that’s made by burning organic material from biomass. Biochar has useful applications for soil and engineered media used in stormwater practices."> '''[https://stormwater.pca.state.mn.us/index.php?title=Biochar_and_applications_of_biochar_in_stormwater_management biochar]'''</span>.
 +
*Iron enhanced treatment is an effective practice if large volumes of water can be treated in this manner. One concern with sand filters, however, is that large systems are needed to treat large runoff volumes.
 +
*Additional practices, such <span title="Routing impervious surfaces to pervious surfaces. An example is routing runoff from a parking lot to a turfed area."> '''impervious disconnection'''</span> and use of <span title="Permeable pavements allow stormwater runoff to filter through surface voids into an underlying stone reservoir for temporary storage and/or infiltration. The most commonly used permeable pavement surfaces are pervious concrete, porous asphalt, and permeable interlocking concrete pavers (PICP)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Permeable_pavement permeable pavement]'''</span>, could further reduce phosphorus loading. These are practices that can be used at the individual homeowner scale.
 +
 
 +
NOTE: In Section 3, a total reduction of 1080.4 pounds is achieved with BMP implementation. However, phosphorus loading would increase with the land use conversion if no BMPs were implemented. This explains why the load reduction in Section 3 is greater than the net reduction of 819.29 pounds.
 +
 
 +
===Review Summary Sheet===
 +
[[File:Summary.png|400px|thumb|alt=screen shot of Summary tab from Estimator|<font size=3>Screen shot of the Summary worksheet from this Estimator example.</font size>]]
 +
 
 +
The adjacent image provides a screen shot of the Summary worksheet for this example. Note the following in the image.
 +
*Data are shown for each subwatershed and for the entire site
 +
*Initial and final loads are shown, as well as the percent reduction achieved
 +
*Loading rate, in pounds per acre, are included (both initial and final)
 +
*Cumulative load reductions for the different BMPs are illustrated
 +
 
 +
Note that we did not address total suspended solids in our calculations. The summary suggests TSS loads increased, but this is because we ignored calculations for TSS as it was not a pollutant of concern. To accurately reflect TSS, we would enter the BMP data for each subwatershed in Section 4 of each worksheet in the Estimator.
 +
 
 +
==Example 2: treatment trains, non-structural practices, and other structural BMPs==
 +
[[file:Example 2 estimator.png|400px|thumb|alt=schematic for example 2 for the Estimator|<font size=3>Schematic for Estimator example. See text for description.</font size>]]
 +
 
 +
In this example we'll demonstrate how to use the Estimator for treatment trains, non-structural practices, and structural BMPs that are not included as defaults in the Estimator.
 +
 
 +
There are three subwatersheds. Subwatershed A consists of residential land use. A number of non-structural practices were implemented here, including enhanced street sweeping, neighborhood lawn leaf pick-up, an [https://adopt-a-drain.org/ adopt-a-drain program], and <span title="Routing impervious surfaces to pervious surfaces. An example is routing runoff from a parking lot to a turfed area."> '''impervious disconnection'''</span>. Impervious surface disconnection included a rain barrel program and routing residential roof runoff to pervious areas. Subwatershed B consisted of mixed land use, including residential, commercial, industrial, and open space land uses as well as transportation and institutional areas. A stormwater <span title="multiple BMPs that work together to remove pollutants utilizing combinations of hydraulic, physical, biological, and chemical methods"> [https://stormwater.pca.state.mn.us/index.php?title=Using_the_treatment_train_approach_to_BMP_selection '''treatment train''']</span> approach is utilized in this subwatershed and includes an area where <span title="a bioretention practice having an underdrain. All water entering the practice is filtered through engineered media and filtered water is returned to the storm sewer system."> [https://stormwater.pca.state.mn.us/index.php?title=Bioretention '''biofiltration''']</span> practices were implemented, an area served by an underground <span title="Infiltration Best Management Practices (BMPs) treat urban stormwater runoff as it flows through a filtering medium and into underlying soil, where it may eventually percolate into groundwater. The filtering media is typically coarse-textured and may contain organic material, as in the case of bioinfiltration BMPs."> [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices '''infiltration''']</span> system, and an area served by a <span title="filtration of stormwater through a sand filtering material whose purpose is to remove pollution from runoff"> '''[https://stormwater.pca.state.mn.us/index.php?title=Filtration sand filter]'''</span>. These areas drain to 3 regional ponds. Subwatershed C is an <span title="Highly urban and ultra-urban settings have a large percentage of impermeable surface and typically have limited space to install surface BMPs. An example would be a downtown area."> '''ultra-urban'''</span> area with 80 percent impervious surface on <span title="A soil classification system (Natural Resource Conservation System) based on runoff potential. Groups include A soils (coarse textured with very low runoff potential), B soils (medium coarse textured with low runoff potential), C soils (fine to moderate textured with moderate runoff potential), and D soils (fine textured with high runoff potential)."> '''[https://stormwater.pca.state.mn.us/index.php?title=Design_infiltration_rates hydrologic soil group]'''</span> (HSG) C soils, making infiltration infeasible. BMPs installed in this area include several <span title="a pre-fabricated stormwater treatment structure utilizing settling, filtration, absorptive/adsorptive materials, vortex separation, vegetative components, and/or other appropriate technology to remove pollutants from storm runoff."> '''proprietary'''</span> underground filtration systems.
 +
 
 +
The adjacent schematic illustrates the entire site. The goal is to reduce phosphorus loading to the lake by 40 percent.
 +
 
 +
===Step 1: Entering acreages and calculating unadjusted loads===
 +
The area includes the following.
 +
*Subwatershed A: 300 acres of residential land use
 +
*Subwatershed B: The entire area consists of mixed (multi-use) land use, but for calculation purposes we will use a separate worksheet in the Estimator for each of the following
 +
**70 acres draining to biofiltration
 +
**175 acres draining to underground infiltration
 +
**275 acres draining to sand filters
 +
**125 acres untreated runoff draining to Pond 1 plus drainage from the biofiltration and infiltration areas
 +
**125 acres draining to Pond 2 plus drainage from the sand filter area
 +
**175 acres draining to Pond 3 plus drainage from Pond 2
 +
**70 acres of direct runoff (untreated)
 +
*Subwatershed C: 200 acres of ultra-urban land use treated by proprietary underground filtration practices. We entered this land use as a user-defined land use and adjusted the runoff coefficient to 0.90 to reflect the impervious cover. The <span title="the average pollutant concentration for a given stormwater event, expressed in units of mass per volume (e.g., mg/L)"> '''event mean concentration'''</span> (emc) was assumed to be 0.24 mg/L.
 +
 
 +
There are thus 9 separate areas where calculations will be made (subwatershed A and C and seven (7) areas in subwatershed B).
 +
 
 +
===Step 2: calculating adjusted loads===
 +
Adjusting loads only applies to subwatershed A, where non-structural practices are implemented. Four non-structural practices are implemented in this subwatershed.
 +
*Enhanced street sweeping, which consisted of timing fall sweeping with leaf drop.
 +
*A neighborhood lawn leaf pickup program was implemented. It consisted of residents raking leaves off pervious surfaces (e.g. lawns), bagging the leaves, and placing them on the curb for pickup.
 +
*An adopt-a-drain program was implemented and 80% of the drains in the subwatershed are cleaned on a routine basis.
 +
*An impervious surface disconnection program was implemented and consisted of residents routing roof runoff to a pervious surface or to a  rain barrel that discharged to a pervious surface. Approximately 50% of the homes in subwatershed A have roof disconnection practices.
 +
 
 +
Based on monitoring data and information from the literature, we adjusted the emc down from 0.325 mg/L to 0.26 mg/L and the runoff coefficient down from 0.26 to 0.22. Note that runoff from impervious to pervious surfaces typically does not remove all the runoff generated from the impervious surface. This is particularly true for lawns that are compacted.
 +
 
 +
The resulting phosphorus reduction is 63.77 pounds or 34.81 percent of the initial load for the subwatershed.
 +
 
 +
===Step 3: Accounting for load reductions by structural BMPs===
 +
Structural BMPs were implemented in subwatershed B and C. In subwatershed C, proprietary underground filtration practices were implemented and treat 150 of the 200 acres in the subwatershed.  The treatment efficiency is assumed to be 0.44, which is the same as biofiltration. The resulting load reduction is 89.27 pounds or 29.7 percent of the initial load for the subwatershed.
  
===Addressing treatment trains===
+
Subwatershed B contains multiple BMPs configured as a treatment train. To account for this, we calculate loads separately for each practice (i.e. a separate worksheet is used for BMP in the Estimator).
The estimator does not explicitly address stormwater treatment trains. It will therefore underestimate pollutant removal for BMPs that are in series. Adjusting the estimator to more closely simulate pollutant removal for treatment trains can be challenging since the estimator uses a lumped BMP approach in which all similar BMPs are lumped as a single BMP. For example, permeable pavement with no underdrain, bioinfiltration, and infiltration basins are all lumped together as infiltrator BMPs. Another complication is that each treatment train differs and attempting to model them as a single system creates inaccuracies.
+
*Direct runoff: 70 acres of the subwatershed runs off directly to the lake with no treatment
 +
*Biofiltration: The biofiltration practices treat 90% (0.9) of annual runoff. Of this treated runoff, 20% (0.2) is infiltrated and 80% is filtered. Thus, of the original 70 acres, we assume 7 acres (10%) is untreated and goes to Pond 1. The filtered volume goes to Pond 1. We address these volumes in the calculations associated with Pond 1.
 +
*Infiltration: The infiltration practice treats 90% (0.9) of annual runoff. The remaining volume is untreated. We therefore assume 17.5 acres of the 175 (10%) acre area is untreated and goes to Pond 1.
 +
*Sand filters: Sand filters treat 90% (0.9) of the runoff. The remaining volume is untreated. We therefore assume 27.5 acres (10%) of the 275 acre area is untreated and goes to Pond 2.
 +
*Pond 1: Pond 1 receives 125 acres of direct runoff and 24.5 acres of untreated water from the biofiltration and infiltration areas. Pond 1 also receives 56.7 acres of treated water from the biofiltration area. We reduced the emc of this water by 44% (0.44) to account for treatment by biofiltration and we changed the pond treatment efficiency to 0.25 to account for reduced treatment effectiveness associated with smaller particle sizes. We used the Other treatment to address this filtered water.
 +
*Pond 2: Pond 2 receives 125 acres of direct runoff and 27.5 acres of untreated runoff from the sand filter area. Pond 1 also receives 247.5 acres of treated water from the biofiltration area. We reduced the emc of this water by 47% (0.47) to account for treatment by biofiltration and we changed the pond treatment  efficiency to 0.25 to account for reduced treatment effectiveness associated with smaller particle sizes. We used the Other treatment to address this filtered water.
 +
*Pond 3: Pond 3, there are 175 acres of runoff to the pond. There is also runoff from Pond 2, but we assume this water receives no additional treatment because it has already passed through two treatment practices upstream.
  
To get an idea of how to adjust the estimator to account for treatment trains, we ran a series of treatment train scenarios through the MIDS calculator and compared them to results for the estimator. A more detailed description of this exercise, including results, is in a Word document ([[file:treatment trains.docx]]. Recommendations are summarized below.
+
{{alert|Using acreages of runoff sent to downstream BMPs instead of volumes may introduce small inaccuracies in the calculations but is a simpler approach.|alert-info}}
*The Estimator appears to provide reasonable results when infiltration practices are employed in a treatment train. Pollutant removal fractions in the ''Input values for MPCA estimator'' tab could be adjusted slightly upward (e.g. 2 to 3 percent).
 
*The Estimator underestimates treatment when filtration and settling practices are utilized. Pollutant removal fractions in the ''Input values for MPCA estimator'' tab should be adjusted by upward 0.10 units.
 
*Bacteria were not included in the analysis. If bacteria are assumed to primarily be associated with sediment, the above recommendations could be applied to bacteria.
 
Tables with recommended values for pollutant removal fractions are in a Word document ([[file:treatment trains.docx]]).
 
  
===Adjusting EMCs (event mean concentrations)===
+
===Reviewing results===
If you are calculating reductions in loading as a percent, there is no value in modifying the EMCs in the estimator since the only factors affecting the percent removal are the BMP removal fraction and the fraction of runoff being treated by and/or infiltrating through the BMP. If you are calculating reductions in pounds or number of bacteria, the EMC affects the initial pollutant load. The higher the load the greater the reduction when the BMPs are applied. Values in the estimator are on the high end of concentrations for the different land uses. For more information on EMCs, see [http://stormwater.pca.state.mn.us/index.php/Concentrations_of_contaminants_found_in_stormwater tabled values in the manual].
+
[[File:Example 2 - summary sheet.png|400px|thumb|alt=screen shot of results for example 2|<font size=3>Screen shot of summary sheet for Estimator example. See text for discussion. Click on image to enlarge.</font size>]]
 +
[[File:Notes for example 2.png|thumb|400px|alt=screen shot of notes for example 2|<font size=3>Screen shot showing notes for this example.</font size>]]
  
If you have a land use not shown in the estimator, values should be obtained from the literature. Recommended values for agriculture are shown below.
+
The adjacent screen shot shows the results for each area, subwatershed, and by treatment practice. The final load of 974.93 pounds reflects a total reduction of 745.94 pounds. This is a 43.35 percent reduction in total phosphorus loading and meets the reduction goal of 40 percent. The greatest reductions, in terms of percent reduced, occurred in the area where infiltration practices were implemented, reflecting the effectiveness of these practices in reducing phosphorus loading. The reduced effectiveness of ponds 1 and 2 compared to pond 3 reflects the reduced effectiveness of BMPs located downstream of other BMPs. Treatment trains, however, have the advantage of providing redundant treatment and helping to meet challenging reduction goals. They also can reduce loading to the downstream BMPs and thus reduce the need for maintenance in the downstream BMPs.
*For row crop agriculture, use ''medium density residential'' land use for phosphorus and TSS.
 
*For pasture, use ''Open space'' land use for phosphorus and TSS.
 
*For bacteria, derive values from the literature as bacteria concentrations are highly variable in agricultural systems as a result of manure management and livestock practices.
 
  
===Adjusting the fraction of annual water treated and infiltrated in a BMP===
+
The screen shot also shows final loading rates from each treatment area. The effectiveness of infiltration practices is again illustrated, with a final loading rate of 0.10 pounds per acre per year. Also note the relatively high loading rate from the ultra-urban area despite 75 percent of the area being treated by filtration practices. This reflects the importance of impervious surface in contributing to loading, since 90 percent of the area is impervious.
The default value for the fraction of runoff treated by BMPs is 0.9, except for wet basins and wetlands, where the value is 1.0. The 0.9 corresponds with treatment of the first 1 inch of runoff on B soils, while a value of 1.0 assume all runoff is treated by the BMP. This value can be changed in the ''input values for MPCA estimator'' tab if your BMPs are sized for a different water quality volume or if you have different soils. The table below can be used to determine the appropriate number. For example, if your soils were A rather than B, you should enter a value ranging from 0.92 to 0.96, depending on the specific soil type. If you had B soils but the water quality volume was 0.75 inches, the value should be changed to 0.81.
 
  
Similarly, the fraction of runoff that is infiltrated into an infiltrator BMP is 0.9. Again, this value should be adjusted if the water quality volume or soils differ from 1 inch and B soils. The only other BMP in the estimator that infiltrates water as the default is biofiltration. The infiltration fraction for this BMP is 0.2, which is based on data generated from [[MIDS calculator]] runs. Infiltration may occur in other BMPs, in particular permeable pavement with an underdrain and swales. A value of 0.2 can be entered for permeable pavement with underdrains to make it similar to biofiltration. An infiltration value for swales is difficult to generate because of the many potential swale configurations. The MIDS calculator is one tool that can be used to generate a value for fraction of water infiltrated in swales.
+
{{alert|In this example we were not concerned with TSS loads. This explains the results for TSS in the summary sheet|alert-info}}
  
{{:Annual volume treated as a function of soil and water quality volume}}
+
The notes page from the Estimator is also shown in an adjacent figure. This notes page is used to provide specific details or information relevant to the calculations made in the spreadsheet and worksheets.
  
===Adjusting the pollutant removal fraction===
+
==Related pages==
The pollutant removal fraction is the most important factor affecting the calculations in the estimator. The default values correspond with recommended values in the manual and represent well-defended data from the literature. The user can change the default, but any change should be supported with data. For further information on pollutant removal by BMPs, see the appropriate page in this manual on [http://stormwater.pca.state.mn.us/index.php/Category:Calculating_credits BMP pollutant credits]. Each of the credit articles contains information to help determine the most appropriate value for pollutant removal for a specific BMP.
+
*'''MPCA Simple Estimator'''
 +
**[[Recommendations and guidance for utilizing the MPCA Simple Estimator to meet TMDL permit requirements]]
 +
**[[Guidance and examples for using the MPCA Estimator]]
 +
**[[Case study for using the MPCA Simple Estimator to meet TMDL permit requirements]]
 +
**[[Default TSS and TP loads for different land use scenarios using the MPCA Simple Estimator]]
 +
**[[MPCA review of submittals using the MPCA Simple Estimator]]
 +
*'''Other model pages'''
 +
**[[Overview of models used to meet MS4 TMDL permit requirements]]
 +
**[[Recommendations and guidance for utilizing P8 to meet TMDL permit requirements]]
 +
**[[Case study for using P8 to meet TMDL permit requirements]]
 +
**[[Recommendations and guidance for utilizing WINSLAMM to meet TMDL permit requirements]]
 +
**[[Case study for using WINSLAMM to meet TMDL permit requirements]]
 +
**[[Recommendations and guidance for utilizing the MIDS calculator to meet TMDL permit requirements]]
 +
**[[MIDS calculator]]
 +
**[[Case study for using the MIDS calculator to meet TMDL permit requirements]]
  
===Addressing BMPs not included in the estimator===
+
[[Category:Level 3 - Models and modeling/Specific models/MPCA Simple Estimator]]
The estimator allows the user to enter an additional BMP beyond the default BMPs (called ''Other'' in the estimator). Most urban BMPs fit into one of the default BMPs in the estimator. There may be exceptions however. If you can determine values for pollutant removal fraction, fraction of water that is treated, and fraction of water that is infiltrated for the BMP, you can include an additional BMP. If these values cannot be generated for the BMP, calculate pollutant removal independently and add that value to the value generated by the estimator when reporting cumulative reductions on the Annual Report form. For example, assume you had an in-line treatment system that treated stormwater runoff in a part of your conveyance system. This BMP is not easily incorporated into the estimator, but if you monitor the BMP and have pollutant removal information, you can simply add the removal amount to the amount calculated by the estimator for the remainder of your system.
 

Latest revision as of 16:40, 5 January 2023

Overview of the MPCA Simple Estimator
The MPCA Simple estimator is an Excel-based tool that utilizes the Simple Method to estimate total suspended solid and/or total phosphorus loads and load reductions associated with implementation of best management practices (BMPs). The spreadsheet includes the following features.
  • Up to 10 worksheets where the user provides inputs to estimate loading. Each worksheet includes the following.
    • Multiple land uses
    • Adjustable event mean concentrations, runoff coefficients, pollutant removal efficiency, and percent of runoff treated by a BMP
    • Adjustments in loading associated with non-structural BMPs, such as street sweeping and changes in land use
  • A worksheet summarizing pollutant loads and reductions across the ten worksheets described above.
  • An information sheet with links to useful pages in the stormwater manual
  • A notes sheet where users can provide additional information
  • A blank worksheet where users can make calculations or store data
image
image
Caution: The MPCA Simple Estimator has been updated to Version 3. The guidance on the following page is for Version 3 of the Estimator.
Caution: The MPCA Simple Estimator contains default values for event means concentrations, runoff coefficients, BMP pollutant removal efficiency, and fraction of runoff treated by BMPs. If appropriate, the user should adjust these values to match site conditions. Guidance for adjusting values is provided on this page.

This page provides guidance on the use of the MPCA Simple Estimator for calculating total phosphorus and total suspended solids (TSS) pollutant loads and reductions in loads associated with implementation of best management practices (BMPs). It assists MS4 (Municipal Separate Storm Sewer System) permittees in the completion of the Commissioner-approved TMDL Annual Reporting Form ( TMDL Form).

This guidance applies to Version 3 of the Estimator.

Contents

Estimator downloads and links to resources

Information: The guidance on this page applies to Version 3 of the Estimator.

Download Version 3 of the estimator here: File:MPCA simple estimator version 3.0 March 5 2021.xlsx

Download Version 2 of the MPCA Estimator here: File:MPCA Estimator-2.xlsx

A quick guide for the Estimator is available Quick Guide: MPCA Estimator tab.

NOTE: This page is a User's Guide that explains the various cells and worksheets in the Estimator. Guidance for using the Estimator for permit compliance and case studies are found at the following links

Opening the MPCA Simple Estimator

If the Version 3 of the Estimator you open has macros enabled, you will see an information box stating the following:

"This spreadsheet contains several default values, such as pollutant concentrations, curve numbers, and BMP pollutant removal efficiency. It is important to adjust those values, as appropriate, to your site conditions. Read the information tab in the spreadsheet for more information."

Click OK to open the spreadsheet.

General description of the MPCA Simple Estimator

The MPCA Estimator spreadsheet presents a calculator approach to computing pollutant loading and the pollutant load reduction for total phosphorus (TP) and total suspended solids (TSS)(Note: the Estimator may not be used for any other pollutants). For MS4 permittees reporting on TMDL wasteload allocations (WLAs), results from the Estimator can be used in the Cumulative reductions tab of the Annual Report form. The Estimator applies load reductions to specific structural stormwater BMPs but can be used to estimate reductions associated with other BMPs such as street sweeping, impervious surface disconnection, and changes in land use. It is a simplistic tool and should not be used for modeling a stormwater system or selecting BMPs.

When working in the Estimator, the following color coding applies.

  • Grey cells have fixed information and cannot be edited
  • White cells can be edited by the user
  • Yellow cells contain default values that the user can edit. Editing the defaults triggers an alert informing the user that the default has been modified.
  • Red cells contain formulas that result in calculated pollutant reductions; these cells cannot be edited

The Estimator utilizes the Simple Method to estimate pollutant loads for total phosphorus and total suspended solids (TSS). BMPs (best management practices) included in the Estimator are biofiltration (bioretention with an underdrain), infiltration (a bmp with no underdrain), filter strip, landscaped roof ( green roof), permeable pavement with an underdrain, sand filter, swale, wet basin ( wet pond), and stormwater wetland. Users may include other BMPs if they have reliable data on pollutant removal efficiency.

The Estimator allows the user to make calculations for 10 areas (e.g. subwatersheds). Within each area the Estimator computes pollutant reduction using BMP performance data as published in this manual. The Estimator computes the load reduction according to the formula

Load Reduction for a BMP = Load in – Load out = (EMC in * Volume in) – (EMC out * Volume out).

This is then converted to a percentage reduction

% Reduction = Load Reduction ÷ Load in.

The cumulative reduction is the sum of load reduced for all BMPs across all 10 areas (worksheets). For MS4 permittees with WLAs, this computed reduction can be input into the Cumulative reductions tab of the TMDL Annual Report form.

The Estimator can only be used for one TMDL at a time. If a Permittee has multiple TMDLs and chooses to use the Estimator, separate calculations must be made for each TMDL.

Caution: The results from the MPCA Estimator are intended to show a generalized value that represents approximate progress towards meeting TMDL WLAs. The MPCA Estimator should not be used for other modeling or compliance purposes. Instead, Permittees should use field investigations combined with more detailed models.

Structure of the MPCA Estimator spreadsheet

image mpca estimator
Screen shot of draft Version 3 of MPCA Estimator showing 10 calculation worksheets, an information sheet, a summary sheet, a notes sheet, and a worksheet. Click on image to enlarge.

The MPCA Simple Estimator (Estimator) spreadsheet contains 14 worksheets.

  • 1 worksheet providing information about the spreadsheet
  • 10 worksheets where data are entered and calculations made
  • 1 summary worksheet
  • 1 notes sheet
  • 1 worksheet

Information worksheet

The information worksheet provides some basic information about the Estimator and includes links that may be useful.

Notes sheet

There is limited space to include notes on the ten calculation worksheets. The notes page allows the user to include additional information and details about inputs, assumptions, and calculations used in the calculation worksheets.

Worksheet

This is a blank worksheet where users may perform calculations that may be necessary in using the calculation worksheets, or where information or data can be stored.

Summary sheet

This is a protected worksheet that provides summary information, including initial loads for total phosphorus and TSS, reductions in loads associated with BMP implementation, percent reduction in loads, final loading rate (lb/ac/yr), and removal by different BMP types. Data are shown by area and for the entire site.

Calculation worksheets

Each of the 10 calculation worksheets represents a subwatershed. The user is not obligated to use 10 worksheets for their study area. We encourage the user to use separate worksheets for the following conditions.

  • The study area has multiple well-defined subwatersheds.
  • Contributing areas to BMPs in downstream portions of treatment trains should be treated as subwatersheds and should not include the area contributing to upstream BMPs in the treatment train, particularly if significant amounts of runoff are being treated by the upstream BMPs.
  • To more accurately reflect differences in land use. Although the Estimator provides flexibility in selecting land uses, certain situations may be better dealt with by treating land uses as different subwatersheds. For example, a single residential area highly impacted by emerald ash borers may be treated as a separate subwatershed from an adjacent residential area where tree canopy will remain intact (i.e. due to significant differences in event mean concentrations).
Information: Each worksheet in the Estimator is called an Area and represents a subwatershed as discussed above

The 10 calculation worksheets are identical and each contains 5 sections, described below.

  • Calculation of unadjusted total loads for total phosphorus (TP) and total suspended solids (TSS)
  • Calculation of adjusted total loads for TP and TSS
  • Calculation of TP loading reductions associated with implementation of best management practices (BMPs)
  • Calculation of TSS loading reductions associated with implementation of best management practices (BMPs)
  • BMP and land use input values

Each of these sections is described below.

Section 1: Calculation of unadjusted total loads

screen shot of simple estimator
Screen shot of Section 1 of the Estimator. Unadjusted pollutant loads are calculated in this section. Note that defaults values exist in many of the yellow cells, but the user can change these cells. To avoid a calculation error, the default area for each land use is 0.00001 acres, which creates a small amount of pollutant load. Values in red are calculated and cannot be changed by the user. Grey cells cannot be edited. White cells are input cells for the user.
screen shot of simple estimator
Screen shot of Section 1 of the Estimator. In this image, the user has changed some of the default emcs for phosphorus. Note an alert box is shown in those rows where a default has changed. In this example, the user provides a note explaining the emcs are based on monitoring data.
Information: The Estimator spreadsheet uses a mix of SI and English units. Correction factors are included in all calculations. The user must use the correct units for input values.
Caution: To avoid calculation errors, each land use should have a minimum default area when there is acreage within that land use. The Estimator uses a value of 0.00001 and we recommend retaining that value or using a smaller value.

In this section, the total unadjusted load, in pounds, is calculated for the area considered. Unadjusted means there is no consideration of reductions associated with structural stormwater BMPs or with practices such as street sweeping, pollution prevention, changes in land use, etc.

This section comprises Cells A5 through M24 of each of the 10 calculation worksheets. In this section, the user inputs land area, in acres, associated with different land uses within the area being considered. The user inputs annual precipitation, in inches. A link provides access to precipitation information if the user does not know the precipitation for the subwatershed. The section contains default values for TP and TSS event mean concentrations (mg/L) and default values for runoff coefficients. EMCs and runoff coefficients can be changed by the user. Changing a default value triggers an alert box informing the user that the default has been changed.

Column A - Land use

  • Description: This column contains various classifications for land use. Only classifications having adequate information for pollutant concentrations in the literature were included. The user may include additional land uses if adequate information exists for pollutant concentrations in runoff from that land use. The user may also include just a single land use to represent the entire area within the TMDL Project watershed, although this may require estimates of pollutant concentrations and runoff coefficients for areas with multiple land uses.
  • Input: Land use category. Options include commercial, industrial, institutional, multi-use, municipal, open space, residential, park, agriculture, transportation, and water. The user may input up to five other land use classifications.
  • Source of Information: MPCA input or user input.

Columns B and C, Rows 6 through 23 - Event mean concentrations

  • Description: The influent event mean concentration (EMCs) of the pollutants of concern for each classification of land use listed in Column A.
  • Input: Default value with an option for the user to enter a different value. If the user changes an emc for commercial, industrial, institutional, multi-use, municipal, residential, open space, or transportation, an alert displays in Column I or Column J, informing the user that they have changed the default emc. The user can change emcs for water, park, transportation, or user-specified land uses without an alert.
  • Source of Information: We conducted a literature review to develop information on emcs. We selected default values based on analysis of data from the literature review and using best professional judgement. Information on emcs, including a summary of the literature review, ranges in emcs for different land uses, and guidance for adjusting an emc is found at these links.

Column D, Rows 6 through 23 - Area of specified land use

  • Description: Area of specific land use within the subwatershed, in acres.
  • Input: Drainage area, in acres. A value must be entered into this cell for the pollutant reduction to be calculated. Cells are therefore populated with a default value of 0.000001 acres to avoid returning an error in the calculations.
  • Source of Information: User. TMDL reports provide maps and acreages for TMDL study areas. Shapefiles of TMDL study areas can be found at link.

Column E, Rows 6 through 23 - Annual precipitation

  • Description: Total annual precipitation in subwatershed.

Note: The default value is 30.65 inches per year, which is the average annual precipitation at the Minneapolis-St. Paul International airport. The user should input the appropriate value for their location. The references below can be used to determine this value.

Column F, Rows 6 through 23 - runoff coefficients

  • Description: Standard runoff coefficient for each type of land use.
  • Input: Default value with an option for the user to enter a different value. If the user changes the default, an alert displays in Column K informing the user that the default has changed.
  • Source of Information: MPCA input values based on literature. The default is set at the median. For a discussion of runoff coefficients, see [1]. For a table of runoff coefficients for different soils and slopes, link here.

Columns G and H, Rows 6 through 24 - Pollutant loads

  • Description: The calculated load of the various pollutants of concern. Note that the values contained in Row 24 are the total values for all the land uses. Loading values take into consideration the concentration of pollutant in the stormwater runoff, drainage area, annual rainfall, and runoff coefficient.
This is the base loading from which reductions are made. The user should therefore not change the inputs once the initial calculations are made because it may affect the calculations for pollutant reductions.
  • Input: None
  • Source of Information: The values in these cells are calculated based on the information entered in the previous cells

Columns I, J, K, rows 8 through 14 and row 17 - If the user changes a default value for emc or runoff coefficient in one of these rows, an alert is displayed.

Column L, Rows 8 through 23 - The user may enter notes. For example, if a default value is changed, the user may explain the rationale for the change.

Column M, Rows 8 through 24 - This column displays calculated runoff volumes in cubic feet. The Simple Method is used to generate this value. These cells are protected.

Section 2: Calculation of adjusted total loads

screen shot estimator
Screen shot of Section 2 - Adjusted loads. Note there are no pollutant loads because acreages have not been entered.

This section of the 10 calculation worksheets contains information and calculations for adjustments to the total loads calculated in the previous section (Unadjusted total loads). It comprises Cells A26 through M45.

Adjusted total loads account for changes in event mean concentration or runoff coefficient values used in the section "Unadjusted total loads". Examples of practices or actions that result in changes in EMC or runoff coefficients include but are not limited to the following.

  • Street sweeping: Enhancing an existing street sweeping program, or initiating street sweeping will lower the emc in runoff. Alternatively, reducing street sweeping will increase the emc.
  • Implementation of pollution prevention practices: Practices that reduce TP and/or TSS loads will lower the emc. Note that many of these practices are difficult to quantify and the user should base the decision to modify the emc on monitoring data or a literature review. An example would be a neighborhood leaf pickup program.
  • Land use change: A change in land use may result in a change in emc and/or a change in runoff coefficient. This may result in an increase or decrease in total load.
  • Altered land use practices: This potentially includes a wide range of practices that may affect the emc or runoff coefficient. Examples include disconnection of impervious surfaces, reduction in impervious surfaces, and changes in lawn practices (e.g. increased yard waste composting).

The user will adjust appropriate emcs in Cells B29 through C44, and/or adjust the appropriate runoff coefficients in cells F29 through F44. Changing a value in one of these cells (shaded yellow) displays an alert box in Column L warning the user that the default has been changed. The user should provide a description or rationale in the appropriate cell in Column K. Column M displays calculated runoff volumes in cubic feet, generated using the Simple Method.

screen shot estimator
Screen shot of Section 2 - Adjusted loads with example adjustments. Adjustments include implementation of an impervious disconnection program in the industrial are, enhanced street sweeping in the residential area, and conversion of agricultural land. Note there are no pollutant loads because acreages have not been entered.

The adjacent figure illustrates three example adjustments. In an industrial area, an impervious disconnection program was implemented. This could consist of, for example, a roof runoff disconnection program where roof runoff is diverted to pervious surfaces. In residential areas, enhanced street sweeping lowered the emc. An enhanced street sweeping program might consist, for example, of more intensive sweeping during fall leaf drop. Finally, agricultural land was developed and the emc was lowered for the developed area. For land use changes it is important to avoid double counting. For example, if the newly developed area incorporates infiltration practices, the effect of these practices should be reflected either in this section or in sections 3 or 4, where BMPs are entered, but not in both sections. Including this in both sections would be double counting.

Caution: The user should provide a description or rationale for changed values in the appropriate cell in Column K. The Notes worksheet may also be used for this.

Section 3: Calculations for phosphorus load reductions associated with BMP implementation

Tips for entering structural Best Management Practices
Sections 3 (total phosphorus) and 4 (TSS) address reductions in pollutant loading associated with implementation of structural BMPs. Below are some tips for entering data in these sections.
  • The area treated by a BMP cannot exceed the total acreage within a specific land use
  • Examine the values in rows 66-68 for total phosphorus and rows 91-93 for TSS. Guidance on adjusting these and rationale for the defaults is provided here.
  • If multiple BMPs are used in series, consider adjusting the removal efficiency downward for downstream BMPs. For more information, link here.
screen shot estimator
Screen shot showing the section where reductions in phosphorus loading are calculated in the MPCA Estimator.

In this section of the worksheet the user enters acreages for BMPs implemented within each land use in the subwatershed. The section comprises Cells A47 through L70. The area treated by a BMP cannot exceed the total acreage within a specific land use (i.e. an error message is returned if the user attempts to enter an acreage greater than the total acres in a land use). If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.

Note: it is possible for treated acres to exceed total acres when multiple BMPs are employed. The warning alerts the user to this situation, in which case the user should ensure the entered values are correct. If treated acres do exceed total acres, the user should consider adjusting removal efficiencies for downstream BMPs that are receiving water treated by upstream BMPs.

Caution: The area treated by a BMP cannot exceed the total acreage within a specific land use
Caution: If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.
gif image of infiltration practices
Infiltration practices include infiltration basins and bioinfiltration, infiltration trenches, tree trenches with no underdrain, permeable pavement with no underdrain, and swales with check dams.

Rows 48 through 65

  • Description: The area, in acres, treated by the BMP, for different land uses. Land uses are listed in Column A.

These cells represent the area tributary to a BMP, which may not be the entire area for the type of land use. Not all cells need to be filled in. The user should only enter data in the cells relating to the specific BMPs and the land use classification of the BMPs’ drainage area.

If the user attempts to enter BMP acreages greater than the land use area, an error message is generated in Column L since one BMP cannot treat an area greater than the land use area. If the user enters a total acreage for all BMPs that exceeds the area of the land use, a warning message will be generated. This warning does not prevent the user from proceeding, since the total acreage for multiple BMPs may exceed the total land use acreage. For example, assume runoff from a 1 acre commercial area drains to an underground infiltration BMP. The area may also include a 0.2 acre green roof, resulting in 1.2 acres of BMP for the 1 acre commercial area. Generally, it is unlikely the BMP acreage will exceed the land use area.

  • Input: The area, in acres, tributary to the BMP. Different BMPs are contained in different columns.
  • Source of Information: User

Row 66

  • Description: The removal efficiencies for listed BMPs
  • Input: None or user input. Removal efficiencies are based on information from the Minnesota Stormwater Manual and the Minimal Impact Design Standards (MIDS) calculator. BMP database sources shown below include compilations of data from multiple studies. The user may input other values based on field studies or published BMP performance data. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will be generated if the user attempts to enter a value greater than 1.
gif image of bmps with engineered media
Bioretention BMPs that utilize engineered media include bioretention (rain gardens), tree trenches, tree boxes, and bioswales. Read the adjacent text regarding phosphorus retention in BMPs that utilize engineered media.

With the biofiltration BMP, the default removal efficiency is 0.44. This assumes the engineered media mix is C or D, or if another mix is used the phosphorus content is 30 mg/kg or less per the Mehlich 3 test. If Mix A, B, E, or F is used, or if the media P content exceeds 0.30 mg/kg, or if the media mix is not C or D and has not been tested, the user should enter a phosphorus removal fraction of 0.0 (i.e. the BMP will not retain phosphorus through filtration). Even if the removal efficiency is 0, some phosphorus will be retained by the BMP through infiltration, assuming the BMP does not have an impermeable liner. If the BMP has a liner, change the infiltration fraction to 0.

Caution: The Estimator assumes engineered media utilized in a filtration practice will not leach phosphorus. For more information, see Engineered (bioretention) media mixes for stormwater applications.

When considering manufactured treatment devices, determine the appropriate column. These are typically proprietary filtration devices and may be addressed in Column B (Biofiltration), Column K (Other), or elsewhere if appropriate. Typically a manufacturer will supply the pollutant removal data for their device. The International BMP Database, USEPA Verified Technologies, Washington State's TAPE Program, and New Jersey's NJCAT Program have pollutant removal information that can be used to verify manufacturer’s data.

  • Source of Information: MPCA Input, but user can change the value.

Links to additional information

Row 67

  • Description: The fraction of the annual runoff that is treated by the BMP. This is based on the amount of total runoff that enters the BMP.
  • Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
  • Source of Information: MPCA Input, but user can change the value. The default value is set for 1.0 for wet basins (constructed ponds) and constructed wetlands based on the assumption that all annual runoff passes through these BMPs. This is approximately correct for ponds and wetlands built to National Urban Runoff Program (NURP) standards, but may be inaccurate for smaller ponds and wetlands. The default value is set at 0.9 for the remaining BMPs assuming B soils and the BMPs are designed to treat 1.0 inch of runoff from impervious surfaces. One inch is the most common performance goal, but this value must be changed if other performance goals are used. The user should also consider adjusting this value based on soil type curve numbers. The value would be adjusted upward for coarser soils and for areas with increased impervious cover, assuming bmps are sized to treat runoff from impervious surfaces. The user can calculate annual runoff treated by a BMP by using the MIDS calculator, or can estimate the value from the following data from the Minneapolis-St. Paul International Airport. For more guidance, link here.
Annual runoff as a function of precipitation at Minneapolis-St. Paul International airport. Knowing how a BMP is sized, this table can be used to estimate the annual volume treated by the BMP.
Daily precipitation (in) Cumulative annual rainfall
0.25 45%
0.50 65%
0.75 82%
1.00 90%
1.25 93%
1.50 95%
3.00 99%
9.00 100%

Row 68

  • Description: The fraction of the treated water that is infiltrated by the BMP. Defaults are 90 percent for all infiltration BMPs, 20 percent for biofiltration practices, 20 percent for permeable pavement with an underdrain, and 0 percent for the remaining bmps. All of the water captured by an infiltration BMP is assumed to infiltrate into the soil underlying the BMP. If an infiltration practice is sized to capture more or less than 90 percent of annual runoff, this value should be adjusted accordingly. The MIDS calculator can be used to estimate volume loss in BMPs with an underdrain. Typical infiltration in a BMP with an underdrain and an underlying D soil will be about 20 percent (0.20); thus the 20 percent value for biofiltration and permeable pavement with an underdrain. The assumption that no water infiltrates in the remaining BMPs is a conservative assumption, since some water always infiltrates through the bottom unless the BMP is lined. If the user changes the default value, an alert displays in Column L.
  • Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
  • Source of Information: MPCA Input, but user can change the value.

Row 69

  • Description: The total pollutant reduced (pounds) from each BMP type. The reduction equals the fraction of total area treated by the BMP within each land use multiplied by the removal efficiency of the BMP, summed across all land uses. The total reduction for all BMPs combined is calculated and shown in Column L.
  • Input: None
  • Source of Information: Auto-calculated

Row 70

  • Description: The percent reduction in total load for the pollutant of concern from each BMP type. The percent reduction is calculated by dividing pounds reduced by total load and multiplying by 100. The total percent reduction for all BMPs combined is calculated and shown in Column L.
  • Input: None
  • Source of Information: Auto-calculated

Section 4: Calculations for TSS load reductions associated with BMP implementation

Tips for entering structural Best Management Practices
Sections 3 (total phosphorus) and 4 (TSS) address reductions in pollutant loading associated with implementation of structural BMPs. Below are some tips for entering data in these sections.
  • The area treated by a BMP cannot exceed the total acreage within a specific land use
  • Examine the values in rows 66-68 for total phosphorus and rows 91-93 for TSS. Guidance on adjusting these and rationale for the defaults is provided here.
  • If multiple BMPs are used in series, consider adjusting the removal efficiency downward for downstream BMPs. For more information, link here.
image estimator
Screen shot showing the section where reductions in TSS loading are calculated in the MPCA Estimator.

In this section of the worksheet the user enters acreages for BMPs implemented within each land use in the subwatershed. The section comprises Cells A72 through L95. The area treated by a BMP cannot exceed the total acreage within a specific land use (i.e. an error message is returned if the user attempts to enter an acreage greater than the total acres in a land use). If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.

Note: it is possible for treated acres to exceed total acres when multiple BMPs are employed. The warning alerts the user to this situation, in which case the user should ensure the entered values are correct. If treated acres do exceed total acres, the user should consider adjusting removal efficiencies for downstream BMPs that are receiving water treated by upstream BMPs.

Caution: The area treated by a BMP cannot exceed the total acreage within a specific land use
Caution: If the cumulative acreage for multiple BMPs exceeds the total acreage within a land use, Column L returns a message stating the treated acres exceed the total acres for the land use.

Rows 72 through 90

  • Description: The area, in acres, treated by the BMP, for different land uses. Land uses are listed in Column A.

These cells represent the area tributary to a BMP, which may not be the entire area for the type of land use. Not all cells need to be filled in. The user should only enter data in the cells relating to the specific BMPs and the land use classification of the BMP's drainage area.

If the user attempts to enter BMP acreages greater than the land use area, an error message is generated since one BMP cannot treat an area greater than the land use area. If the user enters a total acreage for all BMPs that exceeds the area of the land use, a warning message will be generated. This warning does not prevent the user from proceeding, since the total acreage for multiple BMPs may exceed the total land use acreage. For example, assume runoff from a 1 acre commercial area drains to an underground infiltration BMP. The area may also include a 0.2 acre green roof, resulting in 1.2 acres of BMP for the 1 acre commercial area. Generally, it is unlikely the BMP acreage will exceed the land use area.

  • Input: The area, in acres, tributary to the BMP. Different BMPs are contained in different columns.
  • Source of Information: User

Row 91

  • Description: The removal efficiencies for listed BMPs
  • Input: None or user input. Removal efficiencies are based on information from the Minnesota Stormwater Manual and the Minimal Impact Design Standards (MIDS) calculator. BMP database sources shown below include compilations of data from multiple studies. The user may input other values based on field studies or published BMP performance data. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will be generated if the user attempts to enter a value greater than 1.

Typically a manufacturer will supply the pollutant removal data for their device. The International BMP Database, USEPA Verified Technologies, Washington State's TAPE Program, and New Jersey's NJCAT Program have pollutant removal information that can be used to verify manufacturer’s data.

Sources of Information: MPCA Input, but user can change the value.

Links to additional information

Row 92

  • Description: The fraction of the annual runoff that is treated by the BMP. This is based on the amount of total runoff that enters the BMP.
  • Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
  • Source of Information: MPCA Input, but user can change the value. The default value is set for 1.0 for wet basins (constructed ponds) and constructed wetlands based on the assumption that all annual runoff passes through these BMPs. This is approximately correct for ponds and wetlands built to National Urban Runoff Program (NURP) standards, but may be inaccurate for smaller ponds and wetlands. The default value is set at 0.9 for the remaining BMPs assuming B soils and the BMPs are designed to treat 1.0 inch of runoff from impervious surfaces. One inch is the most common performance goal, but this value must be changed if other performance goals are used. The user should also consider adjusting this value based on soil type curve numbers. The value would be adjusted upward for coarser soils and for areas with increased impervious cover, assuming bmps are sized to treat runoff from impervious surfaces. The user can calculate annual runoff treated by a BMP by using the MIDS calculator, or can estimate the value from the following data from the Minneapolis-St. Paul International Airport. For more guidance, link here.

Daily precipitation vs annual runoff MSP airport

Row 93

  • Description: The fraction of the treated water that is infiltrated by the BMP. Defaults are 90 percent for all infiltration BMPs, 20 percent for biofiltration practices, 20 percent for permeable pavement with an underdrain, and 0 percent for the remaining bmps. All of the water captured by an infiltration BMP is assumed to infiltrate into the soil underlying the BMP. If an infiltration practice is sized to capture more or less than 90 percent of annual runoff, this value should be adjusted accordingly. The MIDS calculator can be used to estimate volume loss in BMPs with an underdrain. Typical infiltration in a BMP with an underdrain and an underlying D soil will be about 20 percent (0.20); thus the 20 percent value for biofiltration and permeable pavement with an underdrain. The assumption that no water infiltrates in the remaining BMPs is a conservative assumption, since some water always infiltrates through the bottom unless the BMP is lined. If the user changes the default value, an alert displays in Column L.
  • Input: None or user input. If the user changes the default value, an alert displays in Column L informing the user that they changed a default. The maximum value is 1.0 and an error will generate if the user attempts to enter a value greater than 1.
  • Source of Information: MPCA Input, but user can change the value.

Row 94

  • Description: The total pollutant reduced (pounds) from each BMP type. The reduction equals the fraction of total area treated by the BMP within each land use multiplied by the removal efficiency of the BMP, summed across all land uses. The total reduction for all BMPs combined is calculated and shown in Column L.
  • Input: None.
  • Source of Information: Auto-calculated

Row 95

  • Description: The percent reduction in total load for the pollutant of concern from each BMP type. The percent reduction is calculated by dividing pounds reduced by total load and multiplying by 100. The total percent reduction for all BMPs combined is calculated and shown in Column L.
  • Input: None
  • Source of Information: Auto-calculated

Section 5: Default values for BMP and land use inputs

screen shot estimator defaults
Screen shot showing default values for the estimator.

This section of each of the 10 calculation worksheets contains default values for BMP performance (pollutant removal fractions), event mean concentrations (EMCs), runoff coefficients, fraction of water treated, and fraction of water infiltrated. The values for removal fraction are only for the water that is captured (fraction of water treated) and are expressed as fractions, which represents the fraction of pollutant that is removed by the BMP through filtration. A value of 0.50, for example, means the BMP removes half of the pollutant. For infiltration, the fraction is 0 because treatment occurs through infiltration rather than filtration. All pollutant is considered removed for infiltration practices. The equations built in to the Estimator account for this complete removal for infiltrated water. Removal values are shown for TP and TSS.

Users cannot change the values in this section. The values are used as a check. When a user changes a default in Sections 1, 2, 3, or 4, comparison of the changed value with the defaults in Section 5 trigger a warning that the user changed a default value.

This section provides additional information and links to information on emcs, runoff coefficients, pollutant removal, and treatment fractions.

Tips for using the Estimator

The Estimator is a simple tool based on simple assumptions. This section contains some tips for applying the tool to different situations that you may encounter.

Caution: It is Highly Recommended you keep all information you use to calculate reductions

Addressing treatment trains

The Estimator does not explicitly address stormwater treatment trains. It will therefore either underestimate or overestimate pollutant removal for BMPs that are in series, depending on how they are addressed in the spreadsheet. For example, in a treatment train consisting solely of ponds, the first pond removes the greatest fraction of pollutant concentration. Each pond in succession will treat less polluted water but will further the reduction in pollutant concentration flowing downstream. The Estimator doesn’t recognize the total number of BMPs on the ground so it cannot recognize BMPs as being connected. Therefore each pond is assumed to treat the same degree of polluted water regardless of how many are connected in a treatment train.

We recommend that BMPs in a treatment train be considered as possible separate sub-watersheds. Using this approach, only the area draining to a single BMP is considered in a worksheet.

If BMPs in a treatment train are not treated separately, adjusting the Estimator to more closely simulate pollutant removal for treatment trains can be challenging since the Estimator uses a lumped BMP approach in which all similar BMPs are lumped as a single BMP. For example, permeable pavement with no underdrain, bioinfiltration, and infiltration basins are all lumped together as infiltrator BMPs. Another complication is that each treatment train differs and attempting to model them as a single system creates inaccuracies.

Adjusting EMCs (event mean concentrations)

If you are calculating reductions in loading as a percent, modifying the EMCs in the unadjusted load section will not affect your results. If you are calculating reductions in pounds or pounds per acre, the EMC affects the initial pollutant load. The higher the initial load the greater the reduction when the BMPs are applied. For more information on EMCs, go to the following links.

Adjusting the fraction of annual water treated and infiltrated in a BMP

The default value for the fraction of runoff treated by BMPs is 0.9, except for wet basins (e.g. constructed ponds) and wetlands, where the value is 1.0.

  • The 0.9 corresponds with treatment of the first 1 inch of runoff on B soils ( hydrologic soil group). This was determined through modeling with the Minimal Impact Design Standards (MIDS) Calculator. If you have a different performance goal (e.g. the 1.1 inch MIDS value), extensive pervious acreages, and/or different soils, we recommend adjusting this value. You can use the MIDS calculator to determine the appropriate value. We also provide some guidance below.
  • The value of 1.0 for wet basins and wetlands assumes all runoff is treated by the BMP. This value should be changed if this condition is not accurate.

The table below can be used to determine the appropriate number. For example, if your soils were A rather than B, you should enter a value ranging from 0.92 to 0.96, depending on the specific soil type. If you had B soils but the water quality volume was 0.75 inches, the value should be changed to 0.81.

Similarly, the fraction of runoff that is infiltrated into an infiltrator BMP is 0.9. Again, this value should be adjusted if the water quality volume or soils differ from 1 inch and B soils or if there are significant pervious acreages contributing to runoff. The only other BMP in the Estimator that infiltrates water as the default is biofiltration. The infiltration fraction for this BMP is 0.2, which is based on data generated from MIDS calculator runs. Infiltration may occur in other BMPs, in particular permeable pavement with an underdrain and swales. A value of 0.2 can be entered for permeable pavement with underdrains to make it similar to biofiltration. An infiltration value for swales is difficult to generate because of the many potential swale configurations. The MIDS calculator is one tool that can be used to generate a value for fraction of water infiltrated in swales. If your BMP has an impermeable liner, assume there is no infiltration.

Annual volume, expressed as a percent of annual runoff, treated by a BMP as a function of soil and Water Quality Volume. See footnote1 for how these were determined.
Link to this table

Soil Water quality volume (VWQ) (inches)
0.5 0.75 1.00 1.25 1.50
A (GW) 84 92 96 98 99
A (SP) 75 86 92 95 97
B (SM) 68 81 89 93 95
B (MH) 65 78 86 91 94
C 63 76 85 90 93

1Values were determined using the MIDS calculator. BMPs were sized to exactly meet the water quality volume for a 2 acre site with 1 acre of impervious, 1 acre of forested land, and annual rainfall of 31.9 inches.


Adjusting the pollutant removal fraction

The pollutant removal fraction is the most important factor affecting the calculations in the Estimator. The default values correspond with recommended values in the manual and represent well-defended data from the literature. The user can change the default, but any change should be supported with data. For further information on pollutant removal by BMPs, see the appropriate page in this manual on BMP pollutant credits. Each of the credit articles contains information to help determine the most appropriate value for pollutant removal for a specific BMP.

Addressing BMPs not included in the Estimator

screen shot Simple Estimator
Screen shot for using the Other bmp in the Estimator. See text for discussion. Click on image to enlarge.

The Estimator allows the user to enter an additional BMP beyond the default BMPs (called Other in the Estimator). Most urban BMPs fit into one of the default BMPs in the Estimator. There may be exceptions however, including but not limited to the following.

  • Underground filtration practices (these are largely proprietary)
  • Underground settling practices (these are largely proprietary)
  • Floating treatment wetlands
  • Enhanced pretreatment

If you can determine values for pollutant removal fraction, fraction of water that is treated, and fraction of water that is infiltrated for the BMP, you can include an additional BMP. If these values cannot be generated for the BMP, calculate pollutant removal independently and add that value to the value generated by the Estimator when reporting cumulative reductions on the Annual Report form. For example, assume you had an in-line treatment system that treated stormwater runoff in a part of your conveyance system. This BMP is not easily incorporated into the Estimator, but if you monitor the BMP and have pollutant removal information, you can simply add the removal amount to the amount calculated by the Estimator for the remainder of your system.

Example
Assume there is one (1) acre of commercial land use. This is entered in Section 1, Cell 8D. The total phosphorus load is 0.99 pounds per year. The entire one acre area drains to a stormwater sump basin that has received Washington State TAPE certification. The device was certified for 85 percent TSS removal. Data from commercial areas suggests particulate phosphorus makes up 80 percent of total phosphorus. Because sumps are settling practices which remove coarser solids, assume only half the captured solids constitute TSS in receiving waters. The removal efficiency is therefore 0.85 * 0.80 * 0.5 = 0.34, or 34 percent removal of total phosphorus. The adjacent image shows how to incorporate this practice into the Estimator. Enter 1 acre in Cell K50 since the entire one acre drains to the device. There is no infiltration, so Cell K68 is 0. The device has a removal efficiency of 0.35, which is entered into Cell K66. The device is sized to treat 90 percent of the annual runoff from the area, so Cell K67 is 0.9. The device annually removes 0.311 pounds of phosphorus.

Adjusting for impervious and pervious surface

The Estimator uses runoff coefficients to estimate the fraction of rainfall that runs off for different land uses. Default values are typical values from the literature. Runoff coefficients can be changed in Sections 1 and 2 of each calculation worksheet. Increase the runoff coefficient if your land use has greater impervious surface, or decrease the coefficient if it has less impervious surface. Ranges of values for runoff coefficients can be found here.

Example 1: Using the MPCA Estimator with multiple subwatersheds

This example utilizes a site with three subwatersheds and proceeds through a series of implemented practices. To access the spreadsheet used for this example, click here File:MPCA simple estimator version 3 subwatershed example.xlsx

Step 1. Unadjusted load calculation and entering data for land uses

image used for example
Schematic used for subwatershed example.

The adjacent image is used for this example and will be modified as adjustments are made and BMPs added. The entire project area consists of three subwatersheds. Land uses within the project area include the following.

  • Residential with <25% tree canopy coverage
  • Residential with >50% tree canopy coverage
  • Industrial
  • Commercial
  • Park
  • Transportation
  • Mixed (multi-use)
  • Agricultural

The entire area drains to a lake. The goal is to reduce phosphorus loading to the lake by 30 percent.

In this first step, we enter acreages for each of the three subwatersheds. These are shown in the adjacent image gallery. To account for the two different residential areas in subwatershed A, we change the default emc for residential to 0.350 mg/L for the high canopy area and add a residential land use with an emc of 0.275 for the low canopy area. For subwatersheds B and C, we change the default residential value to 0.35 mg/L to account for higher phosphorus inputs from trees in the high canopy areas. Alternatively, we could have made these adjustments for residential areas in the second section of the three worksheets (Adjusted loads). The total phosphorus load to the lake from all three watersheds is 2699.54 pounds. With a phosphorus reduction goal of 30 percent, this requires a 809.86 pound reduction in phosphorus loading.

Step 2. Calculating adjusted loads

schematic for example
Actions implemented and accounted for in calculating adjusted loads. The implemented actions include enhanced street sweeping in the residential area with >50% tree canopy, an impervious disconnection program in the commercial area of subwatershed A, and conversion of agricultural land to mixed land use.

Section 2 of each calculation worksheet allows the user to enter data that results in adjustments to the total load. In this example, the following actions were implemented (see adjacent image).

  • In the residential areas with >50% tree canopy coverage, an enhanced street sweeping program was implemented. This consisted of street sweeping at the time of fall leaf drop, rather than the once-a-fall sweeping program previously implemented. Measurements of street sweeping material collected during this time indicate this effort reduced annual loading by about 17 percent. Since the Estimator does not allow direct changes in loading, we adjusted the emc downward until we achieved a 17 percent reduction in loading. To accomplish this, we adjusted the emc from 0.35 mg/L to 0.30 mg/L. This resulted in a phosphorus decrease of 18.79 pounds in subwatershed A, 18.79 pounds in subwatershed B, and 7.51 pounds in Subwatersdhed C, for a total reduction of 45.09 pounds.
  • In the commercial area of subwatershed A, a rooftop and parking lot disconnection effort was implemented. Runoff from these areas was diverted to pervious surfaces. The runoff coefficient was adjusted downward from 0.71 to 0.50 based on the calculated decrease in connected impervious surface. This resulted in a phosphorus decrease of 21.91 pounds.
  • The agricultural areas in subwatersheds B and C were converted to mixed land use. We changed the emc and runoff coefficients from agricultural land use to the default values for mixed land use. Phosphorus loads increased by 137.76 pounds in subwatershed B and 150.28 pounds in subwatershed C. BMPs were implemented during the land use conversion, but these calculations are made in Section 3.

After these adjustments, the phosphorus load increased by 221.04 pounds, assuming no further BMPs were implemented. The adjacent photo gallery provides screen shots for each of the three subwatersheds.

Step 3. Entering structural best management practices (BMPs)

schematic for Estimator example
Schematic illustrating where structural BMPs are implemented. Not shown are swales associated with transportation corridors.

In this section, structural BMPs are entered for each of the subwatersheds. The adjacent schematic illustrates where BMPs are implemented, except for swales associated with transportation corridors. A summary of the implemented practices is provided below.

  • Subwatershed A. This subwatershed consists primarily of hydrologic soil group (HSG) C and D soils, making infiltration impractical.
    • Stormwater runoff in much of the area is diverted to wet pond (constructed ponds). A total of 450 acres of mixed land use (multi-use) is treated by ponds and 400 acres of low canopy residential area is treated by ponds. This results in a phosphorus reduction of 330.31 pounds.
    • Biofiltration practices (rain gardens, with an underdrain) are implemented for 100 acres of the residential, high canopy area, resulting in a phosphorus reduction of 28.63 pounds
    • Swales treat 75 acres of runoff from transportation areas, resulting in a reduction of 42.08 pounds of phosphorus
The total phosphorus reduction from these BMPs is 401.02 pounds
  • Subwatershed B. This subwatershed includes HSG A, B, and C soils. Infiltration is therefore feasible in some of the area.
    • Underground infiltration is utilized for 290 acres in the mixed land use areas, including the entire area where agricultural land was converted to mixed land use. This results in a reduction of 263.31 pounds of phosphorus.
    • Biofiltration is utilized for 100 acres of residential land, resulting in a reduction of 28.63 pounds.
The total phosphorus reduction in this subwatershed is 291.94 pounds.
  • Subwatershed C. This subwatershed includes HSG A, B, andC soils. Infiltration is therefore feasible in some of the area.
    • Underground infiltration is utilized for 280 acres in the mixed land use areas, including the entire area where agricultural land was converted to mixed land use. This results in a reduction of 254.23 pounds of phosphorus.
    • Biofiltration is utilized for 40 acres of residential land, resulting in a reduction of 11.45 pounds.
    • Swales are utilized in transportation corridors, treating 60 acres for a phosphorus reduction of 33.66 pounds
    • Iron-enhanced sand filters treat 60 acres of runoff in the industrial area. Note the phosphorus removal efficiency of this practice was change from 0.47 to 0.80 due to the use of iron in the treatment. The total phosphorus reduction for this practice is 48.03 pounds.
The total phosphorus reduction in this subwatershed is 347.37 pounds.

The total phosphorus reduction for the three subwatersheds is 819.29 pounds, which meets the target of 809.86 pounds. Note this included increased loads calculated in section 2 (adjusted loads) and decreased loads associated with BMP implementation. The adjacent image gallery provides screenshots from the Estimator for the three subwatersheds.

This example illustrates the following.

  • Infiltration is a very effective practice for removing phosphorus
  • Biofiltration in residential areas is only somewhat effective due to the low runoff coefficient; i.e. the practice does not treat a lot of runoff. For example, swales in subwatershed A remove more phosphorus even though swales are not particularly effective at removing phosphorus and less area is treated compared to residential land use. The higher removal is associated with the higher runoff coefficient for transportation, resulting in greater runoff volumes being treated.
  • We assume the engineered media mixes for biofiltration do not leach phosphorus. These would be Mixes C or D, or use of some material in the mix that does not leach phosphorus, such as coir or biochar.
  • Iron enhanced treatment is an effective practice if large volumes of water can be treated in this manner. One concern with sand filters, however, is that large systems are needed to treat large runoff volumes.
  • Additional practices, such impervious disconnection and use of permeable pavement, could further reduce phosphorus loading. These are practices that can be used at the individual homeowner scale.

NOTE: In Section 3, a total reduction of 1080.4 pounds is achieved with BMP implementation. However, phosphorus loading would increase with the land use conversion if no BMPs were implemented. This explains why the load reduction in Section 3 is greater than the net reduction of 819.29 pounds.

Review Summary Sheet

screen shot of Summary tab from Estimator
Screen shot of the Summary worksheet from this Estimator example.

The adjacent image provides a screen shot of the Summary worksheet for this example. Note the following in the image.

  • Data are shown for each subwatershed and for the entire site
  • Initial and final loads are shown, as well as the percent reduction achieved
  • Loading rate, in pounds per acre, are included (both initial and final)
  • Cumulative load reductions for the different BMPs are illustrated

Note that we did not address total suspended solids in our calculations. The summary suggests TSS loads increased, but this is because we ignored calculations for TSS as it was not a pollutant of concern. To accurately reflect TSS, we would enter the BMP data for each subwatershed in Section 4 of each worksheet in the Estimator.

Example 2: treatment trains, non-structural practices, and other structural BMPs

schematic for example 2 for the Estimator
Schematic for Estimator example. See text for description.

In this example we'll demonstrate how to use the Estimator for treatment trains, non-structural practices, and structural BMPs that are not included as defaults in the Estimator.

There are three subwatersheds. Subwatershed A consists of residential land use. A number of non-structural practices were implemented here, including enhanced street sweeping, neighborhood lawn leaf pick-up, an adopt-a-drain program, and impervious disconnection. Impervious surface disconnection included a rain barrel program and routing residential roof runoff to pervious areas. Subwatershed B consisted of mixed land use, including residential, commercial, industrial, and open space land uses as well as transportation and institutional areas. A stormwater treatment train approach is utilized in this subwatershed and includes an area where biofiltration practices were implemented, an area served by an underground infiltration system, and an area served by a sand filter. These areas drain to 3 regional ponds. Subwatershed C is an ultra-urban area with 80 percent impervious surface on hydrologic soil group (HSG) C soils, making infiltration infeasible. BMPs installed in this area include several proprietary underground filtration systems.

The adjacent schematic illustrates the entire site. The goal is to reduce phosphorus loading to the lake by 40 percent.

Step 1: Entering acreages and calculating unadjusted loads

The area includes the following.

  • Subwatershed A: 300 acres of residential land use
  • Subwatershed B: The entire area consists of mixed (multi-use) land use, but for calculation purposes we will use a separate worksheet in the Estimator for each of the following
    • 70 acres draining to biofiltration
    • 175 acres draining to underground infiltration
    • 275 acres draining to sand filters
    • 125 acres untreated runoff draining to Pond 1 plus drainage from the biofiltration and infiltration areas
    • 125 acres draining to Pond 2 plus drainage from the sand filter area
    • 175 acres draining to Pond 3 plus drainage from Pond 2
    • 70 acres of direct runoff (untreated)
  • Subwatershed C: 200 acres of ultra-urban land use treated by proprietary underground filtration practices. We entered this land use as a user-defined land use and adjusted the runoff coefficient to 0.90 to reflect the impervious cover. The event mean concentration (emc) was assumed to be 0.24 mg/L.

There are thus 9 separate areas where calculations will be made (subwatershed A and C and seven (7) areas in subwatershed B).

Step 2: calculating adjusted loads

Adjusting loads only applies to subwatershed A, where non-structural practices are implemented. Four non-structural practices are implemented in this subwatershed.

  • Enhanced street sweeping, which consisted of timing fall sweeping with leaf drop.
  • A neighborhood lawn leaf pickup program was implemented. It consisted of residents raking leaves off pervious surfaces (e.g. lawns), bagging the leaves, and placing them on the curb for pickup.
  • An adopt-a-drain program was implemented and 80% of the drains in the subwatershed are cleaned on a routine basis.
  • An impervious surface disconnection program was implemented and consisted of residents routing roof runoff to a pervious surface or to a rain barrel that discharged to a pervious surface. Approximately 50% of the homes in subwatershed A have roof disconnection practices.

Based on monitoring data and information from the literature, we adjusted the emc down from 0.325 mg/L to 0.26 mg/L and the runoff coefficient down from 0.26 to 0.22. Note that runoff from impervious to pervious surfaces typically does not remove all the runoff generated from the impervious surface. This is particularly true for lawns that are compacted.

The resulting phosphorus reduction is 63.77 pounds or 34.81 percent of the initial load for the subwatershed.

Step 3: Accounting for load reductions by structural BMPs

Structural BMPs were implemented in subwatershed B and C. In subwatershed C, proprietary underground filtration practices were implemented and treat 150 of the 200 acres in the subwatershed. The treatment efficiency is assumed to be 0.44, which is the same as biofiltration. The resulting load reduction is 89.27 pounds or 29.7 percent of the initial load for the subwatershed.

Subwatershed B contains multiple BMPs configured as a treatment train. To account for this, we calculate loads separately for each practice (i.e. a separate worksheet is used for BMP in the Estimator).

  • Direct runoff: 70 acres of the subwatershed runs off directly to the lake with no treatment
  • Biofiltration: The biofiltration practices treat 90% (0.9) of annual runoff. Of this treated runoff, 20% (0.2) is infiltrated and 80% is filtered. Thus, of the original 70 acres, we assume 7 acres (10%) is untreated and goes to Pond 1. The filtered volume goes to Pond 1. We address these volumes in the calculations associated with Pond 1.
  • Infiltration: The infiltration practice treats 90% (0.9) of annual runoff. The remaining volume is untreated. We therefore assume 17.5 acres of the 175 (10%) acre area is untreated and goes to Pond 1.
  • Sand filters: Sand filters treat 90% (0.9) of the runoff. The remaining volume is untreated. We therefore assume 27.5 acres (10%) of the 275 acre area is untreated and goes to Pond 2.
  • Pond 1: Pond 1 receives 125 acres of direct runoff and 24.5 acres of untreated water from the biofiltration and infiltration areas. Pond 1 also receives 56.7 acres of treated water from the biofiltration area. We reduced the emc of this water by 44% (0.44) to account for treatment by biofiltration and we changed the pond treatment efficiency to 0.25 to account for reduced treatment effectiveness associated with smaller particle sizes. We used the Other treatment to address this filtered water.
  • Pond 2: Pond 2 receives 125 acres of direct runoff and 27.5 acres of untreated runoff from the sand filter area. Pond 1 also receives 247.5 acres of treated water from the biofiltration area. We reduced the emc of this water by 47% (0.47) to account for treatment by biofiltration and we changed the pond treatment efficiency to 0.25 to account for reduced treatment effectiveness associated with smaller particle sizes. We used the Other treatment to address this filtered water.
  • Pond 3: Pond 3, there are 175 acres of runoff to the pond. There is also runoff from Pond 2, but we assume this water receives no additional treatment because it has already passed through two treatment practices upstream.
Information: Using acreages of runoff sent to downstream BMPs instead of volumes may introduce small inaccuracies in the calculations but is a simpler approach.

Reviewing results

screen shot of results for example 2
Screen shot of summary sheet for Estimator example. See text for discussion. Click on image to enlarge.
screen shot of notes for example 2
Screen shot showing notes for this example.

The adjacent screen shot shows the results for each area, subwatershed, and by treatment practice. The final load of 974.93 pounds reflects a total reduction of 745.94 pounds. This is a 43.35 percent reduction in total phosphorus loading and meets the reduction goal of 40 percent. The greatest reductions, in terms of percent reduced, occurred in the area where infiltration practices were implemented, reflecting the effectiveness of these practices in reducing phosphorus loading. The reduced effectiveness of ponds 1 and 2 compared to pond 3 reflects the reduced effectiveness of BMPs located downstream of other BMPs. Treatment trains, however, have the advantage of providing redundant treatment and helping to meet challenging reduction goals. They also can reduce loading to the downstream BMPs and thus reduce the need for maintenance in the downstream BMPs.

The screen shot also shows final loading rates from each treatment area. The effectiveness of infiltration practices is again illustrated, with a final loading rate of 0.10 pounds per acre per year. Also note the relatively high loading rate from the ultra-urban area despite 75 percent of the area being treated by filtration practices. This reflects the importance of impervious surface in contributing to loading, since 90 percent of the area is impervious.

Information: In this example we were not concerned with TSS loads. This explains the results for TSS in the summary sheet

The notes page from the Estimator is also shown in an adjacent figure. This notes page is used to provide specific details or information relevant to the calculations made in the spreadsheet and worksheets.

Related pages

This page was last edited on 5 January 2023, at 16:40.