Difference between revisions of "Calculator"
m |
Lsavereide (talk | contribs) m |
||
| (50 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[File:Version 4 image.png|300px|thumb|alt=schematic|<font size=3>To download the calculator, [https://app.sharebase.com/#/folder/40078/share/185-BJp5uVhHk8F694jNfUe0Nu--Q-Ck link here]. To see changes from Version 3, [https://stormwater.pca.state.mn.us/index.php?title=Summary_of_changes_in_Version_4_Minimal_Impact_Design_Standards_(MIDS)_Calculator link here]. Note that Version 3 files cannot be used in Version 4 but you can have Versions 3 and 4 loaded on your computer at the same time.</font size>]] | ||
| + | |||
| + | {{alert|If you are using Version 3 of the Calculator, three formula errors were found in the Excel spreadsheet that accompanies Version 3. | ||
| + | *Tree trench/tree box with a raised underdrain was not receiving annual volume credits, resulting in no pollutant removal for the portion of captured water that infiltrates below the underdrain. | ||
| + | *Multiple stormwater disconnection BMPs, beyond the first disconnection BMP, were not receiving credit for volume and pollutants. | ||
| + | *Volume stored beneath an underdrain for permeable pavement was not being calculated correctly when multiple permeable pavement BMPs were used (i.e. the first permeable pavement calculation was correct but not for additional permeable pavement BMPs) | ||
| + | |||
| + | '''We corrected the formulas and these three issues should be resolved. However, when you create a new file within Version 3 or use an existing Version 3 file, these errors will not be resolved. To access a file with these issues resolved you must download the following file and continue to use this file or saved versions of this file to avoid the previous errors.''' | ||
| + | |||
| + | [[file:Corrected June 27.xls]] | ||
| + | |||
| + | If you are interested in seeing an example with the first two items corrected, you can access the following file. | ||
| + | [[file:Corrected April 10 example.xls]] | ||
| + | |||
| + | It has also been noted the TSS removal for bioretention with an underdrain is 60%, while the manual provided a removal rate of 85%. The 60% value was derived from the Virginia calculator and stormwater manual. Similarly, tree trench with underdrain in the calculator receives a credit of 68%, compared to the higher value in the manual. We conducted a literature review and determined the values for bioretention and tree trench in the Manual should be reduced to 80%. We created a MIDS calculator Excel that provides credits of 80% for these two BMPs. This file can be accessed at the link provided below. Note that this file includes the corrections provided above. | ||
| + | |||
| + | [[file:Corrected July 14.xls]] | ||
| + | |||
| + | |alert-warning}} | ||
| + | |||
| + | {{alert|The MIDS calculator has been updated to Version 4.|alert-info}} | ||
| + | |||
| + | [https://app.sharebase.com/#/folder/40078/share/185-BJp5uVhHk8F694jNfUe0Nu--Q-Ck Version 4]<br> | ||
| + | [https://stormwater.pca.state.mn.us/index.php?title=Summary_of_changes_in_Version_4_Minimal_Impact_Design_Standards_(MIDS)_Calculator View changes made from the previous version]. | ||
| + | |||
{{alert|Please read the information on this page before downloading the MIDS calculator|alert-warning}} | {{alert|Please read the information on this page before downloading the MIDS calculator|alert-warning}} | ||
{{alert|Volume and pollutant reductions calculated with the MIDS calculator will be incorrect if BMPs do not meet the following criteria|alert-warning}} | {{alert|Volume and pollutant reductions calculated with the MIDS calculator will be incorrect if BMPs do not meet the following criteria|alert-warning}} | ||
| − | |||
| − | |||
*Volume and pollutant reductions given in the MIDS calculator are based on the assumption that the BMP is properly designed, constructed and maintained. Guidance and recommendations for design, construction and maintenance are contained within the individual BMP sections of this Manual. You can find lists of relevant web pages at the following links. | *Volume and pollutant reductions given in the MIDS calculator are based on the assumption that the BMP is properly designed, constructed and maintained. Guidance and recommendations for design, construction and maintenance are contained within the individual BMP sections of this Manual. You can find lists of relevant web pages at the following links. | ||
**[http://stormwater.pca.state.mn.us/index.php?title=Category:Design_criteria&action=edit&redlink=1 Design criteria] (NOTE the page [[Design criteria for filtration]] includes design criteria for swales.) | **[http://stormwater.pca.state.mn.us/index.php?title=Category:Design_criteria&action=edit&redlink=1 Design criteria] (NOTE the page [[Design criteria for filtration]] includes design criteria for swales.) | ||
| − | **[ | + | **[https://stormwater.pca.state.mn.us/index.php?title=Construction_stormwater_program Construction specifications] |
**[http://stormwater.pca.state.mn.us/index.php?title=Category:Operation_and_maintenance&action=edit&redlink=1 Operation and maintenance] | **[http://stormwater.pca.state.mn.us/index.php?title=Category:Operation_and_maintenance&action=edit&redlink=1 Operation and maintenance] | ||
*BMPs must be designed and constructed in accordance with the [http://www.pca.state.mn.us/index.php/view-document.html?gid=18984 Construction Stormwater General Permit] (CSW permit). Requirements of the CSW permit are highlighted in red throughout the various sections of this Manual. It is important to note that volume reduction BMPs need at least three feet of separation to the seasonally saturated soils to be eligible under the CSW permit to receive credit for volume reduction. The pollutant removal credit is not valid for undersized or oversized practices. | *BMPs must be designed and constructed in accordance with the [http://www.pca.state.mn.us/index.php/view-document.html?gid=18984 Construction Stormwater General Permit] (CSW permit). Requirements of the CSW permit are highlighted in red throughout the various sections of this Manual. It is important to note that volume reduction BMPs need at least three feet of separation to the seasonally saturated soils to be eligible under the CSW permit to receive credit for volume reduction. The pollutant removal credit is not valid for undersized or oversized practices. | ||
*The MIDS calculator does not require sizing criteria for BMPs that do not achieve volume reductions (ponds, wetlands, sand filters). The pollutant removal credit in the calculator assumes these BMPs are properly sized per recommendations in this Manual. | *The MIDS calculator does not require sizing criteria for BMPs that do not achieve volume reductions (ponds, wetlands, sand filters). The pollutant removal credit in the calculator assumes these BMPs are properly sized per recommendations in this Manual. | ||
| + | We welcome comments and suggestions on the calculator. Please send comments to [mailto:todd.smith@state.mn.us Todd Smith]. We will compile comments and, if resources allow, incorporate suggestions into future versions of the calculator. | ||
| − | + | <font size=6>[https://app.sharebase.com/#/folder/40078/share/185-BJp5uVhHk8F694jNfUe0Nu--Q-Ck Download MIDS calculator]</font size> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | <font size=6>[ | ||
| − | |||
| − | |||
| − | |||
| − | |||
<noinclude> | <noinclude> | ||
| Line 34: | Line 45: | ||
*[[Ordinance goals]] | *[[Ordinance goals]] | ||
*[[MIDS calculator]] | *[[MIDS calculator]] | ||
| + | *[[MIDS Calculator example documents (MS WORD)]] | ||
*[[Training and workshop materials and modules]] | *[[Training and workshop materials and modules]] | ||
*[[Technical documents]] | *[[Technical documents]] | ||
| − | [[Category:MIDS]] | + | [[Category:Level 3 - Models and modeling/Specific models/MIDS Calculator]] |
</noinclude> | </noinclude> | ||
Latest revision as of 15:14, 2 October 2024
Caution: If you are using Version 3 of the Calculator, three formula errors were found in the Excel spreadsheet that accompanies Version 3.
- Tree trench/tree box with a raised underdrain was not receiving annual volume credits, resulting in no pollutant removal for the portion of captured water that infiltrates below the underdrain.
- Multiple stormwater disconnection BMPs, beyond the first disconnection BMP, were not receiving credit for volume and pollutants.
- Volume stored beneath an underdrain for permeable pavement was not being calculated correctly when multiple permeable pavement BMPs were used (i.e. the first permeable pavement calculation was correct but not for additional permeable pavement BMPs)
We corrected the formulas and these three issues should be resolved. However, when you create a new file within Version 3 or use an existing Version 3 file, these errors will not be resolved. To access a file with these issues resolved you must download the following file and continue to use this file or saved versions of this file to avoid the previous errors.
If you are interested in seeing an example with the first two items corrected, you can access the following file. File:Corrected April 10 example.xls
It has also been noted the TSS removal for bioretention with an underdrain is 60%, while the manual provided a removal rate of 85%. The 60% value was derived from the Virginia calculator and stormwater manual. Similarly, tree trench with underdrain in the calculator receives a credit of 68%, compared to the higher value in the manual. We conducted a literature review and determined the values for bioretention and tree trench in the Manual should be reduced to 80%. We created a MIDS calculator Excel that provides credits of 80% for these two BMPs. This file can be accessed at the link provided below. Note that this file includes the corrections provided above.
Information: The MIDS calculator has been updated to Version 4.
Version 4
View changes made from the previous version.
Caution: Please read the information on this page before downloading the MIDS calculator
Caution: Volume and pollutant reductions calculated with the MIDS calculator will be incorrect if BMPs do not meet the following criteria
- Volume and pollutant reductions given in the MIDS calculator are based on the assumption that the BMP is properly designed, constructed and maintained. Guidance and recommendations for design, construction and maintenance are contained within the individual BMP sections of this Manual. You can find lists of relevant web pages at the following links.
- Design criteria (NOTE the page Design criteria for filtration includes design criteria for swales.)
- Construction specifications
- Operation and maintenance
- BMPs must be designed and constructed in accordance with the Construction Stormwater General Permit (CSW permit). Requirements of the CSW permit are highlighted in red throughout the various sections of this Manual. It is important to note that volume reduction BMPs need at least three feet of separation to the seasonally saturated soils to be eligible under the CSW permit to receive credit for volume reduction. The pollutant removal credit is not valid for undersized or oversized practices.
- The MIDS calculator does not require sizing criteria for BMPs that do not achieve volume reductions (ponds, wetlands, sand filters). The pollutant removal credit in the calculator assumes these BMPs are properly sized per recommendations in this Manual.
We welcome comments and suggestions on the calculator. Please send comments to Todd Smith. We will compile comments and, if resources allow, incorporate suggestions into future versions of the calculator.
Related pages
This page was last edited on 2 October 2024, at 15:14.