MPCA anticipates several permittees will use the MPCA Simple Estimator to demonstrate compliance with or progress toward meeting total maximum daily load (TMDL) wasteload allocations (WLAs). If a permittee uses the MPCA Simple Estimator for permit compliance, it is recommended they submit an electronic copy of the entire Excel spreadsheet to the MPCA. An electronic copy of the worksheet called Summary sheet, or a printout or legible image of the worksheet called Summary sheet may be acceptable, though MPCA may request an electronic copy of the spreadsheet to clarify items on the Summary sheet.

In reviewing the information in the Estimator, MPCA staff will focus on the following.

  • Comparing the reduction (lbs or %) or final loading rate (lb/ac/yr) with the WLA, depending on how the WLA is expressed in the TMDL
  • Changes in default values for event mean concentration (emc), runoff coefficients, bmp removal efficiencies, or the fraction of runoff that is treated and infiltrated by bmps
  • Changes in adjusted loads compared to unadjusted total loads
  • Land use distributions
  • BMPs implemenated

These are discussed briefly below.

Comparing the reduction (lbs or %) or final loading rate (lb/ac/yr) with the WLA

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

Wasteload allocations are typically expressed as a total load (e.g. pounds), a mass load reduction (e.g. pounds), a percent mass reduction, or a loading rate (lb/ac/yr). The value reported on the Summary sheet of the Estimator will be compared to the WLA as reported in the TMDL report (or in the Watershed Restoration and Protection Strategy (WRAPS) report) or as interpreted by the MPCA.

An example is shown in the adjacent image. This shows a Summary sheet from the Estimator, illustrating pounds of phosphorus reduced for a site having three subwatersheds. The pollutant of concern is phosphorus. The Summary sheet shows initial loading for each of the subwatersheds and for the entire site (2699.54 lbs), pounds reduced after BMP implementation (819.29 lbs), percent reduction from the initial load (30.35%), and final loading rate (0.57 lb/ac/yr). Each of these results is also displayed by subwatershed.

The MPCA will review the Summary sheet to assess compliance with the permit requirement of either meeting a WLA or making progress toward meeting a WLA.

Information: The MPCA reviews the completeness and accuracy of information from permittees and compares progress made by the permittee with the permittee's compliance schedule. In the case of permittee's claiming to meet a WLA, the MPCA does not make a determination that the permittee is either meeting or not meeting a WLA.

Changes in default values for event mean concentration, runoff coefficients, bmp removal efficiencies, or the fraction of runoff that is treated and infiltrated by bmps

screenshot alert check for the Estimator
Screen shot showing the alert checks on the Summary sheet of the MPCA Simple Estimator

The Estimator contains default values for total phosphorus and total suspended solid event mean concentrations, runoff coefficients for different land uses, pollutant removal efficiency (removal fraction), the fraction of runoff treated by BMPs, and the fraction of captured runoff that is infiltrated. These inputs are based on information from the literature.

Users may change these default values. This is encouraged when there is water quality monitoring data, site-specific land use information, bmp performance monitoring, or some similar information available. When the user changes a default value, an alert is displayed and this alert is also documented on the Summary sheet. The Estimator spreadsheet contains cells for describing the rationale for changes to these inputs and a Notes worksheet where additional information supporting these changes can be documented. The Stormwater Manual provides guidance for adjusting emcs and runoff coefficients. The adjacent image provides an example of some changes that MPCA staff would examine in determining compliance with a WLA. Examples of changes that may merit further investigation by MPCA staff include but are not limited to the following.

  • Improved bmp removal efficiency
  • Increased fraction of water infiltrating for a specific bmp
  • Changes in emc or runoff coefficient greater, particularly if the change is greater than 10 percent compared to the default value

In the adjacent image, the user changed the default event mean concentration (emc) for the residential and agricultural areas. The permittee should provide a brief explanation of the reason for the change, either on the worksheet where the change was made or in the Notes worksheet of the Estimator. The Notes worksheet is preferable because it allows the permittee to provide a detailed explanation of the change. For example, in the case of the image on the right, the emc was changed from the default of 0.325 mg/ L to 0.350 mg/L to account for high tree canopy, then modified again to 0.30 mg/L to account for enhanced street sweeping that targeted leaf removal during fall. The agricultural emc was changed as the land was developed and changed to mixed (multi-use) land use. The screen shot of the alert section of the spreadsheet also indicates the pollutant removal fraction for a sand filter was changed. In this case, it was due to incorporation of iron into the sand filter ( iron-enhanced sand filter), resulting in a change from the default pollutant removal of 0.47 to 0.80.

Changes in adjusted loads compared to unadjusted total loads

The bmps included in the Simple Estimator have approved pollutant removal efficiencies. There are other actions that may reduce pollutant loading, or in some cases increase loading. Examples include changes in land use and street sweeping. Because there are not documented reductions for these activities, permittees can adjust emcs and/or runoff coefficients based on local data or information. MPCA encourages these adjustments when they are well supported and provide more realistic pollutant loading estimates. These activities should be documented in the spreadsheet. The spreadsheet is designed so that these adjustments will be noted and MPCA staff may request additional information about the basis for these adjustments.

The Summary sheet in the worksheet does not display changes in loading associated with adjusted loads. MPCA staff will examine individual worksheets to identify these changes. The permittee should document the reason for these changes and, if appropriate, provide references supporting the values used, preferably in the Notes worksheet where more detailed explanation can be provided.

Land use distributions

MPCA staff will not conduct a comprehensive analysis of land use detailed in the Estimator spreadsheet. However, staff may request additional information under certain circumstances. Examples where MPCA may request additional information include but are not limited to the following.

  • A single land use for the entire area, particularly if it is mixed (multi-use) land use
  • Multiple entries for the same land use. For example, a permittee may include two residential areas on a worksheet if pollutant loading in the two areas is significantly different
  • Associated changes in adjusted loads, emcs, or runoff coefficient, particularly if rationale for these changes is not provided
  • Land uses different than the defaults (e.g. low density residential, forested)

If maps displaying land use for the site and/or subwatersheds are readily available and easily submitted, the MPCA encourages permittees to submit these with the spreadsheet.

BMP information

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

The Summary sheet in the Estimator provides a summary of pollutant reductions associated with each structural BMP type. This is summary information across all worksheets (subwaterasheds) and includes the acreages treated by each BMP type and associated reduction in pollutant loading (pounds). In the example in the adjacent image, pollutant reductions were achieved with biofiltration, infiltration, swales, sand filters, and wet ponds. Examples of items MPCA staff may examine include but are not limited to the following:

  • BMP acreages that exceed total acreages within individual worksheets,
  • very large pollutant removal associated with small scale BMPs (e.g. biofiltration, sand filters), and
  • pollutant removals associated with BMPs where pollutant removal or treatment fractions were changed.

Links