This User Guide is intended to assist Municipal Separate Storm Sewer System (MS4) Permittees in the completion of the Commissioner-approved TMDL Annual Reporting Form (TMDL Form).

Quickguides have been created for two of the worksheets in the form.

  1. Quick Guide: BMP-Activities completed tab
  2. Quick Guide: Cumulative reductions tab

Examples showing how to complete the form are contained in another guidance document.

Contents

A note on terminology

  • The TMDL form is a Microsoft Excel file. A Microsoft Excel file or spreadsheet file refers to the entire Excel document. An Excel file may contain one or more worksheets or spreadsheets.
  • We use the term worksheet to refer to a single sheet within the Excel file.
  • A workbook includes all the worksheets in an Excel file. The TMDL form includes 9 worksheets, 5 of which are visible when first opening the Excel file.
  • A worksheet tab refers to the tab at the bottom of the Excel file. You will see 5 worksheet tabs when opening the form. Four worksheet tabs are hidden but can be made visible.

Purpose of the TMDL Annual Report form

If you (an MS4 Permittee) are assigned one or more Wasteload Allocation (WLA) in a Total Maximum Daily Load (TMDL) that was approved by the United States Environmental Protection Agency (USEPA) prior to August 1, 2013, and were not meeting the WLA(s) when you applied for permit coverage, you must complete this form to demonstrate progress toward meeting the WLA(s).

Submission of this form fulfills the permit requirement (Part III.E) to demonstrate continuing progress toward achieving WLAs . This is achieved by including information on one or more of the following in the TMDL Form.

  • An inventory of structural stormwater BMPs and non-structural BMPs (e.g. establish ordinance, education and outreach, illicit discharge elimination, etc.) within the watershed tributary to the impaired water and that are being applied toward meeting the WLA(s). To determine watershed boundaries see the specific TMDL report or retrieve shapefiles from the MPCA.
  • An estimate of annual cumulative pollutant load reductions for certain structural BMPs.
  • A summary of the number of BMPs or activities implemented and applied to an applicable WLA.
  • A description of planned and in-progress BMPs and other pollutant management strategies that have not yet been implemented.

TMDL requirements in stormwater permits

Specific language that requires MS4 Permittees to submit progress towards meeting a WLA is contained in Part III.E of MPCA Permit No: MNR040000, effective August 1, 2013. Requirements include Stormwater Pollution Prevention Program (SWPPP) development and Annual Reporting.

SWPPP Development

All MS4 Permittees that manage a stormwater discharge to an impaired water with a TMDL approved by the USEPA prior to August 1, 2013, have incorporated information for each applicable WLA in their SWPPP documents, as required in Part II.D.6 of MPCA Permit No: MNR040000, effective August 1, 2013.

Annual Reporting Schedules

Permittees with applicable WLAs shall submit the TMDL Form along with the MS4 Annual Report to the MPCA by June 30th of each calendar year, beginning in 2015. Additional information regarding the MS4 General Permit schedule and the SWPPP Submittal Schedule can be found in Appendix A of the MS4 General Permit and on the MPCA’s MS4 Annual Report web page.

TMDL Annual Report form

Each Permittee will have a custom TMDL Form created by the MPCA that lists WLAs affecting the Permittee. All WLAs applicable to a Permittee may not be included in the form. There are two scenarios in which this may occur:

  • When the TMDL report explicitly states no reduction in pollutant loading is needed for an MS4 WLA, that WLA will not be included in the TMDL Annual Report Form.
  • When the Permittee has stated they are meeting a WLA at the time of application, that WLA will not be included in the TMDL Annual Report Form.

You are only responsible for reporting on WLAs included in your customized form.

Information: In the Annual Report Form, TMDL WLAs are expressed differently depending on the type of receiving water.
  • Lake TMDLs: Will be labeled by Waterbody + Pollutant.
  • Stream TMDLs: For ease of reporting, the Permittee is allowed to report on groupings of WLAs within the same report. Stream TMDLs will therefore be labeled by TMDL Project Name + Pollutant. For example, if the Permittee has TSS WLAs on four stream reaches in a single project, these will be grouped into one TMDL to report on. If the Permittee has been assigned WLAs for bacteria on the same four stream reaches in the same project, the Permittee would have two TMDLs to report on. Note that a Permittee may request to have the form customized to allow for individual reach reporting, however, the grouping convention will be the default.

The MPCA will not modify and resend the TMDL Form during the current permit cycle (effective through July 31, 2018). The Permittee will therefore be responsible for maintaining the TMDL Form. The same form will be updated by the Permittee throughout the permit cycle. The Permittee will submit the form each annual reporting year, starting with the 2014 Annual Report. The MPCA will maintain copies of all submitted files.

The TMDL Form is an Excel workbook that includes nine (9) color coded tabs (worksheets):

  • Green tabs include worksheets in which the User will enter specific information. These tabs must be completed by the Permittee.
  • Blue tabs are worksheets that track optional information for each User.
  • Yellow tabs contain reference lists and values used to help populate the information in the green tabs or in the MPCA Estimator.
  • Some of these tabs are hidden and may be accessed, if needed, by navigating the Excel toolbar to Home->Cells->Format->Hide & Unhide->Unhide Sheet
  • A brief description of each worksheet is given below.

Spreadsheet user information (Blue Tab) is an optional worksheet that contains general information for the User. The MPCA recommends that Permittees keep this sheet updated as a means of tracking entries into the TMDL Form.

BMPs-Activities completed (Green Tab) is a required worksheet. The User enters data related to specific BMPs or activities that were completed during the reporting period (January 1 - December 31 of the year prior to form due date or since baseline for the first year of reporting) and that are applied to meeting an applicable WLA. BMPs/activities are associated with each applicable TMDL WLA.

Cumulative reductions (Green Tab) is a required worksheet. The User enters data regarding the estimated pollutant load reduction(s) resulting from implementation of BMPs/activities and information on BMPs/Activities being applied to applicable WLAs.

Category 3 BMPs-Activities (Green Tab) is a required worksheet. The User enters data regarding activities that were included in their SWPPP submittal but that have not yet been implemented.

Adaptive management strategy (Green tab) is a required worksheet. The User provides a narrative describing any adaptive management strategies used for making progress toward achieving each applicable WLA.

List of TMDLs (Yellow Tab) is a reference worksheet, which contains a list of all the TMDLs in Minnesota with MS4 stormwater WLAs approved by the USEPA before the effective date of the MS4 General Permit, August 1, 2013. The MPCA is responsible for maintaining this information. The User cannot edit this information. This tab is hidden.

MPCA estimator (Blue Tab) is an optional User input tab that allows the User to estimate the cumulative reduction (mass or percent removal) of a pollutant of concern achieved by implementation of BMPs. The reductions calculated here can be used when entering information into the quantitative reductions portion of the Cumulative reductions tab (Guidance and examples for using the MPCA Estimator). This tab is hidden.
Please upload an updated version of the MPCA Estimator here: File:MPCA Estimator.xlsx

Input values for the MPCA estimator (Yellow Tab) contains the information used in the MPCA estimator worksheet. Information here is based on literature reviews and therefore general in nature and may not accurately reflect the User site conditions. Therefore, the User is encouraged, as much as is possible, to use their own site data to fill in the cells in the MPCA estimator worksheet. This tab is hidden.

Dropdown lists (Yellow Tab) contains a list of the inputs for the dropdown lists found in the BMPs-Activities completed and Cumulative reductions worksheets. The MPCA is responsible for maintaining this tab. The User cannot edit this information. This tab is hidden.

screen shot of User information tab
Screen shot of the TMDL Annual Report Form Spreadsheet User information tab.

Spreadsheet User information tab

The tab titled Spreadsheet user information contains an optional worksheet that can be used to track the most current version of the form. There are two boxes contained in this worksheet.

  • Form Information describes the TMDL Form and tracks the dates when the form was created by the MPCA.
  • User Information allows MS4 Permittees to track dates pertaining to submission of the TMDL Form. Cells containing the Permittee name and Permit ID are locked and cannot be edited.

BMPs-activities completed worksheet

The worksheet tab called BMP-Activities completed is used to record compliance with the requirement to demonstrate continuing progress towards meeting applicable WLAs. The Permittee is only required to report BMPs being applied toward applicable WLAs.

The content of this worksheet is shown in the two figures below. Grey cells are filled out by the MPCA and cannot be edited by the Permittee. White cells are MS4 User input cells. Brown cells are optional MS4 User input cells but are highly encouraged. Note that some of these white cells are optional or may be auto-filled depending on inputs in other white cells. Information required in this worksheet includes:

  • Reporting year,
  • BMP/Activity,
  • BMP/activity owner, and
  • TMDL WLA(s) to which the BMP/activity is being applied.

If the BMP chosen in Column E of the tab is a constructed basin, filter, infiltrator, or swale or strip, the User is required to enter, in columns H through K,

  • BMP ID,
  • y-coordinate,
  • x-coordinate, and
  • Coordinate system (e.g. lat-long, UTM).

If another BMP is entered in Column E, cells in Columns H through K will auto fill with “NA”. Optional information includes the year that the BMP was implemented and any additional notes. Detailed guidance on each of these columns can be found below.

Detailed guidance for completing the BMP-activities completed worksheet

screen shot of BMP activities completed tab
Screen shot of the BMP-Activities completed tab, Columns A through J, of the TMDL spreadsheet.
screen shot of BMP activities completed tab
Screen shot of the BMP-Activities completed tab, Columns K and beyond, of the TMDL spreadsheet.
Column A – Entry ID
  • Description: BMP line number. MPCA uses this ID for compiling data from all Permittees into a single database. The worksheet allows up to 1000 entries.
  • Input: None
  • Source of Information: The MPCA inputs this data.
Column B – Permittee
  • Description: Name of the TMDL Permittee
  • Input: None
  • Source of Information: This cell autofills when a value is entered for reporting year (Column D)
Column C – MS4 ID
  • Description: The MS4 ID number assigned to the Permittee by the MPCA
  • Input: None
  • Source of Information: This cell autofills when a value is entered for reporting year (Column D)
Column D – Reporting year
  • Description: The reporting year in which the BMP or activity was implemented
  • Input: Reporting year
  • Source of Information: User
Information: If this is the first year using this form, BMPs should be entered for the previous calendar year and all prior years back to the baseline year of the TMDL. These records should all be reported as 2014 entries. Reports in subsequent years will accumulate any BMPs added in the reporting year (ex. The 2016 Annual report will show BMPs back to the baseline year, as well as those added in 2015). If a baseline year is not provided in the List of approved TMDLs with MS4 Wasteload Allocations the Permittee should use Best Professional Judgment to determine it or contact the MPCA. If Best Professional Judgment is used, the Permittee should be able to logically explain their conclusion.
Column E – BMP/Activity
image of Column E BMP list
List of BMPs included in this example section. The BMPs are from the dropdown list in Column E of the BMP-activities completed tab of the TMDL spreadsheet.
  • Description: The type of BMP used or activity conducted
  • Input: Dropdown
  • Source of Information: The User selects the appropriate BMP from a dropdown menu contained in the cell. For the first year of reporting, this will include Category 1 and Category 2 BMPs in operation since the baseline year of the TMDL. Subsequent reporting years will include BMPs put into operation in the previous year. If a particular BMP/activity you implemented is not listed, open the Excel worksheet File:Cross-Reference list.xlsx to determine the appropriate selection from the dropdown list. If the BMP/activity is not listed in the reference list, use Best Professional Judgment or contact the MPCA.
Information: The BMP/Activities contained in the drop-down list is a short-list containing categories of BMPs. Users who are interested in referencing a more specific BMP name should enter that information in Column F or Column O.
Column F – BMP Description (Optional)
  • Description: Specific BMP/Activity description.
  • Input: BMP or Activity name
  • Source of Information: Dropdown list or User. The dropdown list contains a subset of BMPs that are associated with the BMP chosen in Column E.
Column G – Location and ID Information Needed?
  • Description: A description of whether an ID and location information is needed for the BMP
  • Input: None
  • Source of Information: This cell autofills depending on the input for Column E. For structural BMPs (constructed basins, filter, infiltrator, swale or strip) this cell autofills with the statement "Complete columns H through K" and the User is required to fill in Columns H through K. If any other BMP is entered in Column E in this row, the cell autofills with the statement "No ID information needed" and the User is not required to fill in Columns H though K in this row.
Column H – BMP ID
  • Description: ID Number assigned to the BMP by the Permittee or Owner
  • Input: ID Number. The User will input data only if the BMP is a structural BMP (constructed basin, filter, infiltrator, swale or strip). If it is not, then the cell will auto fill with NA. If the BMP was included in the Permit TMDL Attachment Spreadsheet (your permit application), the ID Number must match the ID in the Permit TMDL Attachment Spreadsheet.
  • Source of Information: User and MS4 Permit TMDL Attachment Spreadsheet. The permittee may have a database with ID numbers for BMPs. It is recommended that the permittee use the ID from their database for this field.
Columns I & J – Geographic Coordinates
  • Description: Geographic coordinates for structural BMPs (constructed basin, filter, infiltrator, swale or strip)
  • Input: x- and y-coordinates. The User will input data only if the BMP is structural. If it is not then the cell will auto fill with NA. For constructed stormwater ponds, x, y coordinates should match those submitted with the MS4 Pond, Wetland, and Lake Inventory Form (see permit language). Please enter in decimal degree format.
  • Source of Information: User
Information: The permittee may have a database with geographic coordinates for BMPs. It is recommended the permittee use the coordinates from their database for this field. If the permittee has not determined coordinates for a BMP, it is recommended that BMP coordinates represent the centroid of the BMP. If the permittee has BMPs mapped as polygons, it is recommended they provide x,y coordinates at the approximate center of the polygon.
Information: HOW DO I DETERMINE THE COORDINATES OF MY BMP IF I DON'T HAVE THEM? If the permittee does not use a Global Positioning System (GPS) or mapping software, such as ArcMap, there are numerous tools on the Internet to determine location information. Examples include [1], [2], [3], as well as Google Earth.
Column K – Coordinate System
  • Description: The coordinate system used when measuring the x- and y-coordinates of the structural/quantifiable BMP
  • Input: Dropdown with an option for the User to enter a different value. The User will input data only if the BMP is structural (constructed basin, filter, infiltrator, swale or strip). If it is not then the cell will auto fill with NA.
  • Source of Information: User
Column L – Who Owns this BMP/Activity?
  • Description: Users will have three options to select from: Permittee (you), Other MS4 Permittee, or Other. The purpose of this data is to allow multiple Permittees to demonstrate progress using the same BMP/activity while providing MPCA a mechanism for avoiding double counting of a single BMP. Ownership is important to report for those situations where the Permittee and owner are different. An example is a BMP which multiple permittees co-financed.
  • Input: Dropdown
  • Source of Information: User
Column M – If applicable name other owner(s)
  • Description: Name of MS4 permittee that owns or co-owns a BMP that the Permittee reports as reducing the pollutant load associated with a WLA. For example, if you contributed funding to a BMP that is owned and operated by another permittee, you may include this BMP in this form but indicate who the owner is in this column.
  • Input: Column M will autofill with NA (not applicable) when the user selects “Permittee (you)” or “Other” from the dropdown list of Column L. User should fill in the name of the BMP owner for only those BMPs that are owned, or co-owned by another MS4 permittee.
  • Source of Information: User
Column N – Year when BMP was implemented (Optional)
  • Description: The year in which the BMP/activity was implemented. This refers to the date when the BMP became operational. Entering this information is optional.
  • Input: Date
  • Source of Information: User
Column O – Note(s) (Optional)
  • Description: Any additional information that the User would like to enter into the spreadsheet to track progress, provide additional detail, etc. This is an optional input. Examples are shown in the Example TMDL Form.
  • Input: Notes
  • Source of Information: User
Columns Q and beyond – TMDL Project with TMDL WLAs
  • Description: The number of TMDLs within each MS4 form will be unique to the number of USEPA-approved TMDLs and WLAs applicable to the MS4 Permittee. Column headings specific to each MS4 Permittee will be entered by the MPCA prior to posting the TMDL forms in the manual. The listed projects may include multiple WLAs for the same receiving water and pollutant. For example, a TMDL report may include WLAs for different flow regimes and different reaches of the same river. These have been combined when appropriate to simplify the reporting process. Row 2 contains the TMDL project name and row 3 contains the specific impairment.
Permittees may wish to report on all discrete stream reaches or flow conditions for which they are assigned a WLA. If you wish to do this, contact the MPCA for a customized TMDL Form.
  • Input: ‘X’ from the dropdown to designate a TMDL for which a unique BMP/activity is being applied.
  • Source of Information: User

Overview of categories for Cumulative Reductions tab and Category 3 BMPs - Activities tab

A BMP may only be reported in one of the three categories. While BMPs may move from one category to another between years, they may not be reported in more than one category in a single report.

Category 1 - Summary of quantitative reductions

  • Use Category 1 if all of the following apply.
    • Pollutant loadings from the BMP/activity can be estimated using an appropriate method
    • The pollutant is phosphorus, TSS, fecal coliform, or E. coli
    • The BMP/activity was constructed within your jurisdiction (upstream of your MS4's outfall)
    • The BMP/activity was in operation the past year
  • Recommend using Category 2 if the pollutant is chloride, but Category 1 may be used if you have detailed records and can justify your methodology.


The purpose of this category is to provide a quantitative estimate of the cumulative reductions in loading achieved for each TMDL WLA applicable to the permittee. This category should be used when reductions in pollutant loading are achieved by BMPs constructed within a permittee's jurisdiction and can be quantified using an appropriate method for one of the following pollutants.

  • Total phosphorus
  • Total suspended solids
  • E. coli
  • Fecal coliform
  • Chloride – NOTE: The MPCA recommends that Permittees with chloride WLAs choose Category 2 for reporting.

The following options exist for reporting load or load reduction.

  • pounds or number (for bacteria) reduced
  • kilograms or number (for bacteria) reduced
  • percent load reduction
  • pounds or number (for bacteria) per acre reduced
  • kilograms or number (for bacteria) per hectare reduced
  • load (pounds or number of bacteria)
  • load (kilograms or number of bacteria)
Information: Reductions from all BMPs/activities included in this category are reported as a single cumulative number. For example, if 5 rain gardens (bioretention systems) were in operation and each rain garden reduced phosphorus loading by 10 pounds per year, and no other BMPs can be quantified, then the Permittee would report a cumulative reduction of 50 pounds of phosphorus.

The following BMP/activities require estimated reductions in loading under Category 1:

  • Infiltrator: examples include infiltration trench, infiltration basin, tree trench/box, permeable pavement, infiltration vault, bioinfiltration
  • Constructed basin: examples include wet pond, stormwater wetland, dry pond
  • Filter: examples include sand filter, green roof, biofiltration, iron enhanced sand filter
  • Swale or strip: examples include filter strip, swale, wet swale, grass waterway

These BMPs are included or can be simulated in most water quality models and calculators used for estimating stormwater loading. The Minnesota Stormwater Manual also provides typical reduction efficiencies for these BMPs. Note that you may have information that allows for quantifying pollutant reductions for BMPs other than those listed above, or you may have different pollutant removal values based on local data. For example, many water quality models and calculators will calculate pollutant reductions associated with street sweeping. MPCA encourages permittees to keep a record of methodology used to calculate reductions.

The following BMPs may be quantifiable. However, the Stormwater Manual either provides limited or no pollutant removal efficiencies or guidance for these BMPs, so it is suggested that they be reported under Category 2.

  • Manufactured Device: examples include drain inlet insert, geocells, grit chamber, gross pollutant trap, hood, hydrodynamic separator, manufactured filter, oil/grit separator, pollutant trap, SAFL Baffle, SAFL Baffle sump manhole, sump, sump manhole, swirl separator, water quality inlet.
  • Street sweeping if records are kept for material added to roads (e.g. sand) and removed through sweeping. See Street sweeping for trees.
  • Removal of an illicit discharge if the volume of discharge and pollutant concentration are known and the illicit discharge existed prior to the baseline year.
  • Stormwater capture and reuse if the volume of runoff captured and pollutant concentrations are known. See Stormwater re-use and rainwater harvesting.
  • Improved lawn, turf, vegetation, soil practices if the practice results in decreased pollutant application (e.g. fertilizer) or increased infiltration (e.g. improved soil or turf). See Turf.
  • Chemical treatment of stormwater: if the volume, pollutant concentrations, and removal efficiency are known, or if monitoring is conducted. See Iron enhanced sand filter (Minnesota Filter).
Information: The MPCA encourages the use of local data in determining BMPs that can be quantified and in establishing a pollutant removal value for a specific BMP.

Category 2. Number of BMPs implemented

  • Use Category 2 if any of the following applies.
    • Pollutant is Biochemical Oxygen Demand (BOD), Nitrogenous Biochemical Oxygen Demand (NBOD), chloride, or thermal loading
    • Pollutant reduction information from the BMP/activity is not readily available using an appropriate method
    • You contribute(d) to the implementation of the BMP/activity but the reduction in pollutant loading occurs outside your jurisdictional area (e.g. you contributed funding to a BMP in another MS4's jurisdiction)


The purpose of this category is to acknowledge BMPs/activities that likely reduce pollutant loads but lack information for estimating load reductions or reduce pollutant loads outside the permittee's MS4. Entries in this category are numbers of BMPs; not a reduction value. This category should be used to track those BMPs or activities that operate in one or more of the following conditions.

  • BMPs or activities that lack information for estimating pollutant load reductions. These include non-structural BMPs such as education and structural BMPs for which pollutant removal values are not in the Stormwater Manual (e.g. hydrodynamic devices).
  • Structural BMPs and non-structural BMPs within watersheds tributary to impaired waters that have a WLA for Biochemical Oxygen Demand (BOD), Nitrogenous BOD (NBOD), thermal loading, or chloride. Removal efficiencies for these pollutants are generally lacking in the literature.
  • The permittee contributed to the BMP or activity (e.g. contributed funding) but reductions in pollutant loading from the BMP/activity occur outside the jurisdictional area of the permittee. These BMPs cannot be included in Category 1 because they do not decrease the load leaving the permittee's MS4.

As with Category 1, the value entered represents a cumulative value, in this case the total number of BMPs/activities that are applied to a TMDL Project. All BMPs and activities included in this number must be included in the BMPs-Activities completed tab.

Category 3. Non-implemented Activities (Reported in Category 3 BMPs - Activities tab)

  • Use Category 3 if the BMP/activity was not in operation during the past year. This Category will also store records that constitute progress but do not achieve a reduction (e.g. planning, feasibility studies, acquisition of funding, etc.).


The purpose of this category is to capture progress made that did not directly result in a pollutant reduction. In this section, the Permittee must report on planned BMPs that have not yet been implemented but were submitted as a part of the compliance schedule in the MS4 Permit TMDL Attachment spreadsheet at the time of application. This could include both structural and non-structural BMPs/activities. Activities that constitute progress but do not achieve a reduction, such as planning, feasibility studies, acquisition of funding, etc., will be left in Category 3. When activities that can reduce pollutants are implemented, those reductions should be reported in Category 1 or 2, and removed from this worksheet.

Cumulative reductions worksheet

screen shot of cumulative reductions tab
Screen shot of the Cumulative reductions tab from the TMDL Annual Report Form.

The worksheet called Cumulative reductions is used to track the annual cumulative progress towards reduction of pollutants discharged to an impaired water with a USEPA approved TMDL. Cumulative progress may be reported in terms of measured or calculated pollutant reductions or number of BMPs implemented. Completion of this, the Category 3 BMPs - Activities, and Adaptive management worksheets fulfill compliance with Section III.E.3 of the MS4 General Permit (Permit Number MNR040000).

The contents of this worksheet are shown in the figure to the right. As with the BMPs-Activities completed worksheet, cells that are grey are column/row headings and cells that the MPCA will fill out for each MS4. Cells that are white are User input cells.

Information: The information in this worksheet is summary in nature. MS4 permittees are advised to maintain a record of the data used to complete this form, including information such as BMP name, total annual pollutant load reduction, technique used to compute pollutant load reduction, date the BMP went into operation, and other information that may assist the MS4 Permittee. Some of this information may be included in the BMPs-Activities completed worksheet.

Three categories of reporting are described in detail above. The choice of category for reporting is dependent on whether the BMPs/activities are required to be quantified for the pollutant of concern. Recommendations for the choice of Category are provided above. For Category 1 and Category 2, it is assumed the BMP/activity was in operation during the previous year, or if this is your first reporting year, between the baseline year or BMP condition of the TMDL and the past year (see the information box under Column D - Reporting year for explanation of a missing baseline).

Detailed guidance for the Cumulative reductions tab - Category 1

Columns A and B – MS4 Information
  • Description: MS4 Permittee Name and MS4 ID
  • Input: None
  • Source of Information: The MPCA will input this information.
Column C – TMDL project
  • Description: The name of the TMDL project. A stream TMDL may include multiple TMDL WLAs that have been combined for ease of reporting. A TMDL project has only one pollutant. The project name(s) match(es) the names listed starting in Column Q of the BMPs-Activities completed tab.
  • Input: Column D or Column C from the List of TMDLs tab. The project name(s) match(es) the names listed starting in Column S of the BMPs-Activities completed tab.
  • Source of Information: The MPCA will input this information.
Column D – Units
  • Description: The units of measurement for the pollutant reduction (e.g. pounds, kilograms, %) for each TMDL project. The user may select the units of measurement in which to illustrate reductions. MPCA encourages consistent units for the duration of the permit term.
  • Input: Dropdown with an option for the User to enter a different value
  • Source of Information: User
Columns E through K – Years
  • Description: Annual pollutant load reduction for the total of all BMPs within the specific TMDL watershed. If the User is reporting on more than one BMP within one TMDL watershed, the reductions should be totaled and presented as one value for that year. For subsequent years, include reductions from all BMPs, including BMPs included in the previous year’s reporting. For example, if 5 rain gardens (bioretention) achieved 50 pounds reduction in 2014 and 5 newly built rain gardens achieved 40 pounds reduction in 2015, the total reduction is 90 pounds, assuming all rain gardens have been maintained and are still performing as designed. Similarly, if a BMP is removed or no longer functioning properly, it should not be included in estimates of total reduction. The Permittee is thus reporting on cumulative reductions over a period of several years when several BMPs or activities may be implemented.
  • Input: Calculated or measured pollutant reduction (e.g. pounds, kilograms, %, etc.).
  • Source of Information: User
Column L – Calculation Method (Optional)
  • Description: This optional column allows the user to track the method used to compute the WLA reduction.
  • Input: Description of monitoring, if obtained. Name of model or calculator, if utilized.
  • Source of Information: User
Caution: MPCA highly recommends using the same methodology for estimating reductions for all reporting years of this permit issuance.
Column M – Notes (Optional)
  • Description: Users may describe background information or other data that could further explain the progress towards meeting the WLA.
  • Input: User defined.
  • Source of Information: User

Detailed guidance for the Cumulative reductions tab - Category 2

These are numbers of BMPs or activities that have been implemented but are not quantified in terms of pollutant reduction.

Columns A and B – MS4 Information
  • Description: MS4 Permittee Name and ID
  • Input: None
  • Source of Information: The MPCA will input this information.
Columns C and D– TMDL project
  • Description: The name of the TMDL project. A TMDL project may include multiple TMDL WLAs and multiple receiving waters that have been combined for ease of reporting. A TMDL project has only one pollutant.
  • Input: None
  • Source of Information: The MPCA will input this information.
Columns E through K – Years
  • Description: The number of BMPs meeting Category 2 criteria (see Overview of categories) that were implemented in the reporting year. This includes BMPs or activities operated in previous years, assuming the BMP or activity is still implemented and achieving pollutant reductions.
  • Input: Number of BMPs in operation during reporting year
  • Source of Information: User
Columns L and M – Notes (Optional)
  • Description: Users may describe background information, computational details or other data that could further explain the progress towards meeting the WLA.
  • Input: User defined.
  • Source of Information: User

Estimation of pollutant load reduction for the Cumulative reductions tab

The TMDL Form requires Permittees to estimate pollutant reductions for BMPs/activities that have established pollutant removal values for phosphorus, TSS, fecal coliform bacteria, or E. coli bacteria. “Established pollutant removal value” means the Stormwater Manual provides values for pollutant removal or MPCA has included a pollutant removal value in the MPCA Estimator.

In addition to the values provided in the TMDL Form, MS4 Permittees have multiple options for determining the pollutant load reduction of a specific BMP. The Permittee may opt to use any of these techniques. Permittees are encouraged to record the methodology utilized for computing pollutant load reductions in order to manage the data and changes that can occur each reporting year.

Models and calculators

The Minnesota Stormwater Manual contains an up-to-date list of models and calculators that can be used to compute the pollutant removal of a specific BMP. The models range from complex software that calculate hydrology/hydraulics/water quality such as USEPA SWMM, to User friendly calculators such as the MIDS calculator. Permittees are advised to consider the following.

  • Stand-alone water quality models, such as P8, work well for situations that do not require a hydraulic analysis.
  • Complex models such as SWMM work well for watersheds with multiple BMPs, but may require a MS4 Permittee to hire a modeling expert or consultant.
  • Most water quality models will compute reductions in Total Phosphorus and Total Suspended Solids. A few models will assess additional pollutants.
  • The model/calculator list of BMPs should be reviewed before selecting a model to utilize. For example, load reductions from a green roof can be computed using the MIDS Calculator, but is not in the list for P8. Some models, including P8, do have the capability of computing the load reduction from a User-defined BMP.
Credits

The Minnesota Stormwater Manual sections on Stormwater Management Credits offer four options to calcuate the pollutant removal for a number of BMPs. The term Credit implies pollutant loading and volume reductions. BMPs that have Credit sections include:

Four calculation methods are described in detail in each of these BMP Credit sections.

  • Credits Based on Volume Reduction and BMP Parameters. Details hand calculation methods to compute volume reduction, Total Phosphorus, and Total Suspended Solids removal for a single BMP.
  • Credits Based on Models. Provides detail on model selection. Also includes information on using the Minimal Impact Design Standards (MIDS) calculator.
  • Credits Based on Literature. MS4 Permittees may opt to apply percentage removal values based on published literature values. Users of this technique are advised to use only values from peer-reviewed literature of BMPs that closely resemble the MS4 Permittee’s BMP. Values included in the TMDL Form are based on literature review.
  • Credits Based on Field Measurement. MS4 Permittees and BMP owners may determine that the most accurate method of computing pollutant reduction is through direct monitoring of the BMP.
MPCA Estimator

An additional worksheet has been created for the purpose of estimating pollutant load reductions using published reductions in Event Mean Concentration (EMC). Use of this worksheet is optional. This estimator is intended solely for computing load reductions for this form and is not intended to report on the exact performance of an individual BMP. See Guidance and examples for using the MPCA Estimator for more information.

Category 3 BMPs - Activities Tab

Category 3 BMPs - Activities tab
Screen shot of the Category 3 BMPs - Activities tab from the TMDL Annual Report Form.

This tab contains a worksheet that should include all BMPs and activities listed in the compliance schedule of the permit application that have not been completed. Over time these BMPs or activities may be completed and then moved into Category 1 or Category 2. Activities that constitute progress but do not achieve a reduction, such as planning, feasibility studies, acquisition of funding, etc., are the only records that will remain in Category 3.

Columns A and B – MS4 Information

  • Description: MS4 Permittee Name and ID
  • Input: None
  • Source of Information: The MPCA will input this information.

Column C and D – BMP Description

  • Description: Description of planned BMP or activity. This description should match what was given at the time of application. For example, “Stormwater Pond located at the intersection of Main Street and Central Ave”.
  • Input: BMP
  • Source of Information: User

Column E – Status

  • Description: Status of planned BMP. If the options in the dropdown menu don't work, please enter the status in the "Notes" section.
  • Input: Planned, funded, under construction, or other user-specified status
  • Source of Information: Dropdown box

Column F – Reporting Year

  • Description: Year the BMP is to be constructed or implemented
  • Input: Year
  • Source of Information: Dropdown box

Column G – Notes (Optional)

  • Description: Users may describe background information or other data that could further explain the progress towards meeting the WLA.
  • Input: User defined.
  • Source of Information: User

Column H and beyond – TMDL Project with TMDL WLAs

  • Description: The number of columns for each MS4 form will be unique to the number of USEPA-approved TMDLs and WLAs applicable to the MS4 Permittee. The MPCA will insert the column headings specific to each MS4 Permittee. The listed projects may include multiple WLAs for the same receiving water and pollutant. For example, a TMDL report may include WLAs for different flow regimes and different reaches of the same river. These have been combined when appropriate to simplify the reporting process.
  • Input: ‘X’ from the dropdown box to designate a TMDL for which a unique BMP/activity is being applied.
  • Source of Information: User

Adaptive Management Strategy tab

screen shot of adaptive management screen
Screen shot of the Adaptive management tab in the TMDL worksheet. Click on image to enlarge.

The NPDES MS4 permit requires permittees to provide “(a)n up-dated narrative describing any adaptive management strategies used (including projected dates) for making progress toward achieving each applicable WLA”. This tab contains a text box for users to submit this narrative.

example of adaptive management strategy
Example of an adaptive management strategy entered into the TMDL spreadsheet. Click on image to enlarge.

Adaptive management (AM) is a formal process for continually improving management policies and practices by learning from their outcomes. This portion of the annual report should describe the permittee's plan for continuing to demonstrate progress toward achieving applicable WLAs through development and implementation of structural and non-structural BMPs (e.g., project funding details, details of a feasibility study, efforts to establish partnerships, updates on construction of a structural BMP, etc.). This is also the portion of the annual report that would describe any changes to the compliance schedule the permittee wishes to pursue based on past observations and recognized program enhancement opportunities.

Example: The city has used the first year of the permit term to evaluate its status in regard to WLAs for two lake phosphorus TMDLs. An assessment of implemented BMPs found that additional reductions will need to be made in order to achieve the WLAs. The city is currently determining the most cost effective strategies for meeting these goals. There is a stormwater utility fee in place that will be used to fund these Capital Improvement Projects going forward. A creative approach will need to be applied being that the city is completely built out. As redevelopment occurs, additional stormwater management practices will be evaluated and installed. Construction schedules are variable and future annual reports submitted to the MPCA by the city will provide updates made to the city’s compliance schedule. New and improved technology will also be monitored throughout the current permit term and implemented when feasible going forward.

Reference tabs

The three yellow tabs within the TMDL form are reference tabs. These are hidden when the Excel file is initially opened but can be made visible. The Dropdown lists tab was created solely to build the form and does not contain information helpful to the User. The other tabs are the List of TMDLs and the Input values for MPCA estimator. These are described in more detail below.

List of TMDLs

screen shot of list of TMDLs tab
Screen shot of the List of TMDLs tab.
  • Description: A list of the EPA-approved TMDLWLAs prior to August 1, 2013. Each TMDL is classified by waterbody, pollutant, and Permittee.
  • Input: None
  • Source of Information: MPCA

Input values for MPCA estimator

screen shot of estimator inputs tab
Screen shot of the Estimator inputs tab.

Download MPCA Estimator here: File:MPCA Estimator.xlsx

This tab contains three types of information. The first is the fraction of pollutant removed from the stormwater runoff due to the presence of a BMP. The values apply to stormwater runoff that does not infiltrate into underlying soil. For water that infiltrates into the underlying soil, the pollutant removal fraction is 1.0. Any remaining runoff will bypass the system and cannot be considered for pollutant removal. Therefore the removal fraction for these BMPs is 0 because it only applies to the water that is not infiltrating into underlying soil. The pollutant removal fraction for infiltrated water equals the fraction of water that infiltrates. These values are included in cells C37, C58, C79, and C100 in the MPCA estimator tab. The default value for fraction that infiltrates is 0.90, which corresponds approximately with a BMP designed to capture a 1 inch rain event. All removal fractions are based on the assumption that BMPs were properly designed, constructed and maintained. See specifications and guidance for design, construction and maintenance of individual BMPs in the Minnesota Stormwater Manual. Removal fractions are consistent with values presented in the Stormwater Manual and the Minimal Impact Design Standards calculator.

The second type of information is the event mean concentration (EMC) of total phosphorus, TSS, E. coli, and fecal coliform in stormwater runoff in the various land use areas. The 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 if they have reliable data.

The third type of information is the runoff coefficient (Rv) for the various land use types. The input values are based on literature. The default is set at the median of values from the literature. The User may enter a value if available data supports the value. For a discussion of runoff coefficients, see [4].

If a user wishes to provide any of the above information specific to their site for input into the Estimator, they may change the numbers here in the input tab and they will be transferred to the Estimator. These values are locked in the Estimator tab to avoid accidental edits.

Other resources, information and guidance for the TMDL spreadsheet

Cross-reference list of BMPs

Download here: File:Cross-Reference list.xlsx

  • Description: For the purpose of the TMDL form, the MPCA has opted to develop a naming convention that organizes BMPs into common categories. The cross-reference list is an Excel spreadsheet, separate from the TMDL form, for Users that have a different BMP naming convention than that used in this form.
  • Discussion: To ensure a TMDL form that was functional, it was necessary to limit the list of BMPs to a manageable number. A particular BMP may have several names or variants. For example, bioretention BMPs are often called rain gardens or rain water gardens. Permeable pavement has several variants, including porous asphalt, porous concrete, and permeable interlocking concrete pavers (PICP).
The cross-reference spreadsheet contains an extensive list of terms for BMPs and identifies the BMP to select from the BMP dropdown list in Column E of the BMPs-Activities completed worksheet. The information is sorted by BMPs in the dropdown list (Column A). Column B contains different names and variants of a BMP. Find your BMP in Column B and select the corresponding name in Column A when selecting a BMP from the dropdown list in Column E of the BMP-activities completed worksheet. If you cannot find your BMP, do a word or term search using the Find command on the Home toolbar in Excel. If your BMP term is not listed, use Best Professional Judgment to select the appropriate BMP from the dropdown.
  • Input: None
  • Source of information: MPCA

The cross-reference list is included in a separate Excel spreadsheet rather than the TMDL spreadsheet because the MPCA realizes the BMP list is likely to grow over time. The cross-reference file will be updated as needed.

Definitions

  • constructed basin: a stormwater treatment practice designed to allow pollutants to settle. Includes dry pond/dry detention pond, flow through pond, forebay, gravel wetland, multiple pond system, pond/wetland system, wet pond/wet detention pond, wetland, or other similar BMPs.
  • filter: a stormwater treatment practice designed to filter pollutants. Includes bioretention with underdrain (rain garden), green roof, iron enhanced filter, media filter, perimeter sand filter, permeable pavement with underdrain, surface sand filter, underground sand filter, or other similar BMPs.
  • infiltrator: a stormwater treatment practice designed to allow captured runoff to infiltrate into soil underlying the practice. Includes bioretention with no underdrain (rain garden), infiltration basin, infiltration trench, permeable pavement with no underdrain, tree trench/tree box/planter, underground infiltration, or other similar BMPs.
  • swale or strip: a linear stormwater treatment practice designed to treat pollutants through settling and filtering. If the device is designed to infiltrate runoff, it is considered an infiltrator. Includes dry swale, filter strip/buffer, grass channel/waterway, level spreader, wet swale, or other similar BMPs.