Line 12: Line 12:
  
 
The Minimal Impact Design Standards (MIDS) calculator assigns a single value across a site for fractions of total phosphorus that are in dissolved and particulate forms (45 and 55 percent, respectively). These values can be adjusted by changing the value fields within the Excel spreadsheet that the MIDS calculator creates. To change the dissolved phosphorous to total phosphorous ratio for a site (DP:TP) follow these instructions:
 
The Minimal Impact Design Standards (MIDS) calculator assigns a single value across a site for fractions of total phosphorus that are in dissolved and particulate forms (45 and 55 percent, respectively). These values can be adjusted by changing the value fields within the Excel spreadsheet that the MIDS calculator creates. To change the dissolved phosphorous to total phosphorous ratio for a site (DP:TP) follow these instructions:
 +
#Open the MIDS Excel file you are adjusting. '''This is done in Excel, not in the MIDS Graphical User Interface'''.
 
#Ensure your event mean concentration (emv) is accurate for the conditions that are being modeled. The default value in the calculator is 0.3 mg/L. For more information on emcs, [https://stormwater.pca.state.mn.us/index.php?title=Event_mean_concentrations_of_total_and_dissolved_phosphorus_in_stormwater_runoff link here].
 
#Ensure your event mean concentration (emv) is accurate for the conditions that are being modeled. The default value in the calculator is 0.3 mg/L. For more information on emcs, [https://stormwater.pca.state.mn.us/index.php?title=Event_mean_concentrations_of_total_and_dissolved_phosphorus_in_stormwater_runoff link here].
#Open the MIDS Excel file you are adjusting. '''This is done in Excel, not in the MIDS Graphical User Interface'''.
 
 
#Under the '''''Site Information and Summary''''' tab in the MIDS Excel spreadsheet change cell C60 to the desired particulate fraction. The default is 0.55.
 
#Under the '''''Site Information and Summary''''' tab in the MIDS Excel spreadsheet change cell C60 to the desired particulate fraction. The default is 0.55.
 
#Under the same tab, “Site Information and Summary”, change cell C62 to the desired dissolved phosphorous fraction. The default is 0.45.
 
#Under the same tab, “Site Information and Summary”, change cell C62 to the desired dissolved phosphorous fraction. The default is 0.45.

Revision as of 23:31, 14 March 2023

Information: This guidance is applicable to filtration practices (e.g. practices with an underdrain, filter strips, swales, sand filters). Infiltration practices are considered to remove 100% of pollutants captured, whether dissolved or particulate, and thus adjusting the ratios is irrelevant.

Phosphorus in stormwater runoff occurs in particulate and dissolved forms. Many stormwater practices are effective at removing particulate phosphorus, but many are ineffective for removing dissolved phosphorus. In addition, the dissolved phosphorus (DP) and total phosphorous (TP) loads for a site vary depending on several factors, such as land use (residential, commercial, and industrial), time of year, and precipitation amounts and patterns. To accurately model pollutant loading at a site, it may therefore be important to accurately assign these ratios. See this page for more information on phosphorus.

This page describes how to adjust the dissolved phosphorus to total phosphorus (DP:TP and the particulate phosphorus to total phosphorus (PP:TP) ratios in the MIDS Calculator.

Case 1: adjusting phosphorus ratios across an entire site

Screen shot showing the site event mean concentration (emc)
Screen shot showing the site event mean concentration (emc)
screen shot showing where to adjust DP and PP fractions on the Site Information and Summary tab
Screen shot showing where to adjust DP and PP fractions on the Site Information and Summary tab
Information: This case applies to a situation where you are adjusting the ratios across an entire site rather than for individual treatment practices (bmps). If you are adjusting ratios for the different practices at a site, see Case 2 below.

The Minimal Impact Design Standards (MIDS) calculator assigns a single value across a site for fractions of total phosphorus that are in dissolved and particulate forms (45 and 55 percent, respectively). These values can be adjusted by changing the value fields within the Excel spreadsheet that the MIDS calculator creates. To change the dissolved phosphorous to total phosphorous ratio for a site (DP:TP) follow these instructions:

  1. Open the MIDS Excel file you are adjusting. This is done in Excel, not in the MIDS Graphical User Interface.
  2. Ensure your event mean concentration (emv) is accurate for the conditions that are being modeled. The default value in the calculator is 0.3 mg/L. For more information on emcs, link here.
  3. Under the Site Information and Summary tab in the MIDS Excel spreadsheet change cell C60 to the desired particulate fraction. The default is 0.55.
  4. Under the same tab, “Site Information and Summary”, change cell C62 to the desired dissolved phosphorous fraction. The default is 0.45.
  5. Save the file and close it.

When you open the MIDS calculator GUI, the Results tab will show results for the site and for the individual bmps. The Summary Information accurately reflects phosphorus on the site. However, the individual BMP information under BMP Summary will not be accurate as you did not change the fractions for these. If you want accurate information for the individual bmps, you must adjust the individual bmps as described below in Case 2.

Case 2: adjusting phosphorus ratios and event mean concentrations (emcs) for individual bmps

Screen shot showing where to adjust PP:TP ratio for an individual bmp (bioretention with underdrain)
Screen shot showing where to adjust PP:TP ratio for an individual bmp (bioretention with underdrain)
Information: If you change the fractions or emc for any of the BMPs and want to know the pollutant load balance on the entire site, when you look at the “Results” tab in the MIDS calculator, do not look at the site summary information but look at the individual BMP summaries.

DP:TP and PP:TP ratios can be adjusted for any bmp. Changing the ratio only affects the bmp for which the change was made. Thus, when evaluating results for the site, you must use the BMP summary rather than the site summary information.

  1. Open the MIDS Excel file you are adjusting. This is done in Excel, not in the MIDS Graphical User Interface.
  2. If you are not adjusting the event mean concentration (emc) for individual bmps, ensure the emc on the Site Information and Summary tab is accurate for the conditions that are being modeled. The default value in the calculator is 0.3 mg/L. For more information on emcs, link here.
  3. Navigate to the “MIDS BMP Calculator” tab and ensure these values were adjusted the appropriate cell in column AM to match the desired particulate phosphorous amount with the desired BMP. Column AM is named “Annual Particulate P Load from Direct Drainage Area (lbs)”. See the


Note: The term “leaf drop” implies fall when the leaves are falling.