In years past, IDEM developed several spreadsheet-based tools for use in pursuing risk-based closure. Although we no longer maintain or update these tools, they may prove useful in some applications, particularly those proceeding under earlier guidance.
- Mann-Kendall Spreadsheet:
- Although Mann-Kendall trend analysis remains an important line of evidence in site closures, IDEM will remove the Mann-Kendall spreadsheet from this website after June 30, 2013. Instead, IDEM recommends that users perform Mann-Kendall analysis using U.S. EPA’s ProUCL software, available for free download, or an equivalent tool. U.S. EPA also offers free web-based basic ProUCL training and advanced ProUCL training.
- RISC Default Closure Tool:
- IDEM released Version 1.2 of the RISC Default Closure Tool on May 1, 2009 as a means of providing access to Default Closure Levels located in Appendix 1 of the RISC Technical Guidance Document. However, IDEM now maintains a webpage of IDEM Screening and Closure Levels that links to Excel versions of most of its risk-based closure tables, and users may find the posted tables more convenient.
- RISC Industrial Nondefault Closure Tool:
- IDEM designed the Industrial Nondefault Closure Tool to help users calculate nondefault closure levels for commercial and industrial sites. Users can change commonly modified site specific parameters when performing a nondefault risk assessment.
- TPH Fractionation Tool:
- IDEM developed the TPH Fractionation Tool spreadsheet to aid users in implementing the TPH Fractionation Guidance Released by IDEM in June 2006. Users enter the fractions that they receive from the laboratory analysis, enter site specific data when appropriate, and spreadsheet displays site specific values at the bottom of the sheet.
If you have questions regarding risk-based closure, please see the Contact Risk webpage