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
Information: The MIDS calculator has been updated to Version 3.
Download Version 3
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.
- 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 Anne Gelbmann. We will compile comments and, if resources allow, incorporate suggestions into future versions of the calculator.
Download MIDS calculator
Warning: Google Chrome Users: There have been instances where Google Chrome does doesn’t allow you to access ftpsites