The MPCA Simple Estimator is a spreadsheet-based tool used to predict watershed-based loading for total phosphorus (TP) and total suspended solids (TSS), and estimate pollutant removal at water quality best management practices (BMPs). The spreadsheet tool was created by the Minnesota Pollution Control Agency (MPCA) specifically to assist Municipal Separate Storm Sewer System (MS4) permittees in the completion of the Commissioner-approved total maximum daily load (TMDL) Annual Reporting Form (TMDL Form).
Compared to the MIDS Calculator, the MPCA Simple Estimator is simplified in that it lacks a graphical user interface and uses a simplified approach for predicting pollutant removal at modeled BMPs. Download links for the MPCA Simple Estimator are provided below.
Note: information provided in the following subsections does not reiterate or re-present information readily available in model documentation files. Instead, guidance provided in this document provides engineers and planners with recommendations for development of model inputs, provides guidance for interpreting and summarizing model results, provides supplementary information not included in model documentation, and provides examples showing how the Simple Estimator can be used to demonstrate TMDL compliance.
The MPCA Simple Estimator is capable of predicting annual runoff, TSS, and TP loading from a variety of land use types, and pollutant removal for ten (10) BMP types and up to 10 sub-watersheds. The tool is an empirical model which predicts pollutant and runoff removal at BMPs based on design-standard BMP removal rates published in the 2012 International BMP Database and MPCA Stormwater Manual.
Calculations may be made for up to 10 subwatersheds. Subwatersheds may represent an area draining to a receiving water, the area draining to a specific grouping of BMPs, or the area draining to a specific BMP. Within a sub-watershed, the MPCA Simple Estimator allows grouping of BMPs of a given type prior to performing loading and removal calculations. Within the tool, there is a single column for each of the ten (10) BMP types, where the user aggregates and inputs the cumulative tributary land use area to that given BMP type. Although aggregating BMPs in this way limits the number of user-inputs required, it means the tool is not capable of modeling
The MPCA Simple Estimator should only be used to evaluate and demonstrate wasteload allocation (WLA) compliance for simplified study areas in which the impact of BMP routing, BMP treatment in series, and bypass from undersized BMPs is minimal. The user should limit grouping of BMPs by using multiple sub-watershed worksheets. Additionally, because the MPCA Simple Estimator reports results on an annualized basis, the tool is not capable of evaluating compliance for non-annualized WLAs (e.g., WLAs based on the growing season).
In summary, the MPCA Simple Estimator is capable of demonstrating compliance to annualized mass based WLAs (e.g., pounds of TSS per year), concentration-based WLAs (e.g., mg/L of TSS), and areal-loading based WLAs (e.g., pounds of TSS per acre per year) for TSS and TP, for simplified study areas where the impact of BMP treatment in series and bypass from undersized BMPs is considered negligible or where multiple sub-watershed worksheets can be used to minimize the impact of BMP treatment in series and bypass from undersized BMPs. The MPCA Simple Estimator is an empirical model which is not capable of modeling pollutant removal through BMPs in series and bypass from undersized BMPs.
The following subsections outline data sources and special consideration related to model inputs, model setup, and model initialization. The discussion applies to a single sub-watershed worksheet. Permittees should limit grouping of BMPs to the extent possible by utilizing multiple sub-watershed worksheets.
Note: these subsections do not represent information readily available in model documentation, but instead highlight data sources (e.g., spatial datasets), special consideration, and important notes for engineers and planners to consider while generating model inputs.
The MPCA Simple Estimator estimates annual runoff and pollutant loading using the Simple Method (Schueler, 1987). The tool requires the user to enter the annual rainfall total depth for the project area, and provides a link to US climate data which can be used to look up average annual precipitation depths for many cities in Minnesota. Unique pollutant event mean concentrations (EMCs) and runoff coefficient (Rv) values are assigned for each of the ten (10) land use types from The National Stormwater Quality Database (NSQD), Version 3.1, Zone 1 (Pitt, 2011). EMCs and Rv values can be edited by the user with the “Input values for MPCA estimator” tab and should be reviewed by the engineer or designer. Default EMC values in version 2 of the MPCA Simple Estimator are within a range of typical literature EMC values for TP and TSS.
MPCA Simple Estimator runoff coefficient and pollutant event mean concentration (EMC) values. For additional information, see Event mean concentrations of total and dissolved phosphorus in stormwater runoff, Event mean concentrations of total suspended solids in stormwater runoff, Stormwater runoff coefficients/curve numbers for different land uses.
Link to this table
|Land use||Runoff coefficient (Rv)||TP EMC1 (mg/L)||TSS EMC (mg/L)|
1Event mean concentration
When possible, it is recommended that site-specific information be used to delineate land use types within the study area (record drawings, zoning data, parcel information, etc.). Many public domain spatial land use databases can be used to review and supplement site-specific land use information, including databases outlined below.
Recommendations for how to model land use types not included by default in the MPCA Simple Estimator are provided in the model documentation available online (see the “Adjusting EMC’s (event mean concentration)” section of model documentation.
The estimator allows the user to adjust EMC or runoff coefficient for a land use entered in the initial load. The worksheet cells are initially auto-filled to match the cells in the initial load. Only the emc and runoff coefficient may be adjusted by the user. Upon making changes in either emc or runoff coefficient, the estimator calculates pounds reduced or increased as a result of the change.
Adjustments to emc or runoff coefficient are recommended for the following, although there may be other situations where adjustments are appropriate.
These adjusted loads will be used to determine pollutant reductions associated with implementation of downstream, permanent structural BMPs (e.g. biofiltration, sand filter, etc.).
The MPCA Simple Estimator includes ten (10) BMP types: biofiltration, infiltration, filter strip, green roof, permeable pavement with underdrain, sand filter, swale, wet basin, wetland, and “other” (user-defined BMP). Runoff and pollutant loading to a given BMP type is determined by assigning the area (acres) of each of the ten (10) land use types tributary to the BMP type with the sub-watershed. The spreadsheet tool provides one (1) column for each BMP type and requires the user to input the cumulative land use-based area to that BMP type. For example, if there are two wet basins in the sub-watershed, one with 5 acres of commercial land use and the other with 10 acres of commercial land use, the user would enter that there are 15 acres of commercial land use tributary to wet basins. Because BMPs are grouped in this way, the MPCA Simple Estimator does not require any BMP dimensions (e.g., permanent pool volume, infiltration rate, etc.) and assumes that BMPs are sized correctly for the tributary area assigned. This simplified methodology limits the number of user-inputs required and allows for rapid calculation of BMP removal, but grouping BMPs in this way means that the tool is not capable, within a given sub-watershed, of modeling
If any of the situations listed above exist in the sub-watershed, the engineer or designer must take special precautions to ensure that the MPCA Simple Estimator does not over-estimate or incorrectly calculate pollutant removal. The following steps and strategies can be used to avoid pollutant removal calculation errors associated with BMP routing and undersized BMPs.
The MPCA Simple Estimator is an empirically based model which predicts pollutant and runoff removal at BMPs based on assumptions related to (a) EMC removal efficiency for non-infiltrated water, (b) fraction of annual runoff treated by the BMP, and (c) fraction of annual runoff that is infiltrated. Below is a summary of each of these parameters and how each relate to pollutant removal calculations.
Default parameter values for each BMP are shown in the following table. In general, default values agree with or were developed from information published in the MPCA Stormwater Manual. Designers and engineers should review and, if needed, update parameter values to reflect site-specific conditions and BMP design. For BMPs not included in the MPCA Simple Estimator, BMP removal parameters can be manually assigned for the “other” BMP type, which is included in the tool to allow users to model unique BMP types. Parameter values applied for user-defined BMPs should be developed from site-specific information, BMP monitoring data and/or published literature values.
MPCA Simple Estimator default BMP parameter assumptions
Link to this table
|Percentage of annual runoff ...||EMC removal efficiency for non-infiltrated water|
|BMP type||Treated by BMP||Infiltrated||TSS||TP|
As outlined within the MPCA Simple Estimator model documentation, additional sub-watersheds can be modeled within a single MPCA Simple Estimator workbook by duplicating a sub-watershed tab. This can improve model accuracy by limiting the potential to introduce routing errors discussed above and streamline model QAQC by limiting the total number of BMPs modeled in a given study area.
Note: Additional sub-watersheds will not be included in the Summary worksheet unless the user modifies the Summary worksheet to include the additional sub-watersheds. The user may also mannually add the additional information to the information in the Summary tab.
Within each sub-watershed worksheet, the MPCA Simple Estimator provides annual pollutant loading and removal summaries for individual BMP types and on a sub-watershed basis. Load reduction for individual BMP types is presented in columns B through K within the respective pollutant load reduction tables, and total reductions are summarized in column L.
The following subsections provide guidance on how to interpret and QAQC model outputs.
A separate worksheet called "Summary sheet" provides results for the entire project area (i.e. all sub-watersheds combined). This worksheet provides the following information.
Outflow loading concentration (e.g. mg/L of phosphorus) is a WLA metric required by some TSS and TP TMDLs. Calculating inflow and outflow loading pollutant concentration in the MPCA Simple Estimator requires additional calculations outside of the tool, as the spreadsheet does not track and display runoff volumes generated or removed by BMPs. If required by a TMDL, inflow and outflow pollutant loading concentration can be calculated as follows:
The engineer or designer should perform a thorough review of all model inputs and outputs. Model inputs should be generated using best available datasets, including record drawings, development data, bathymetric surveys, and best-available spatial land use, land cover, and soil databases. Upon model completion, results should be reviewed to ensure BMPs were categorized and/or combined correctly, subwatersheds were combined correctly, and that pollutant removal and areal loading results are within typical ranges based on BMP and land use type, respectively. A general model result QAQC list and description of outputs to review is provided below.
General MPCA Simple Estimator result QAQC list
Link to this table
|QAQC / Review item||Related MIDS Calculator Output|
|Confirm total watershed area is correct||Review land use-based area assigned in the "total load" table|
|Confirm annual precipitation totals are correct||Review annual rainfall values in column G and confirm all are the same value|
|Review watershed pollutant concentrations||Compare watershed areal loading values in the "total load" table to literature values in Table 9|
|Review watershed routing to BMPs||Review land use-based area assigned to each BMP type|
|Confirm only the directly-contributing watershed area is applied for each BMP||The area assigned to a given BMP should be only the directly-contributing watershed area and should NOT include area tributary to other BMPs upstream|
|Review TSS/TP removal rates||Compare pollutant removal values to literature values. Note: percent load reduction shown for each BMP type is calculated based on the total watershed loading|
|Review BMP sizing recommendations and review contributing watershed area||Bypass from undersized BMPs is not calculated. For this reason, only the area for which the BMP is correctly-sized should be modeled to the BMP (the remainder should be modeled as untreated).|