Pretreatment Tools in the Midwest
These pretreatment tools have been made available to be used by the pretreatment community (e.g., approval authorities, control authorities, industry, consultants, etc.) as a technical assistance aid for: 1) reviewing municipal sewer use ordinances for discrepancies with the federal requirements, 2) consolidating data and calculating municipal local limits for indirect dischargers, 3) performing mass balance calculations with sewage sludge metals data, and 4) calculating industrial user permit limits for specific production-based standards with the use of the combined waste stream formula, when applicable.
Disclaimer: While the spreadsheets have been verified for correct functionality, EPA is not liable for any miscalculations that may occur. For general programmatic pretreatment questions, please contact kensinger.justin.r@epa.gov. To report errors with the spreadsheets, please contact pham.anthony@epa.gov for evaluation and corrective action.
Pretreatment Tools:
- Updated Feb. 16, 2024! Calculate Flow Knowing Concentration and Mass Spreadsheet, v2_0: To be used to calculate (estimate) flow when concentration and mass are known.
- Updated Jan. 31, 2024! Region 7 Mass Balance Calculator: Updated to version 3.0.0 to include census data from 2020. Municipal Local Limits Calculator: Updated to address multiple bug fixes.
- Updated Jan. 18, 2023! Part 461, Battery Manufacturing Point Source Category, All Subparts: To be used to calculate battery manufacturing production-based pretreatment standards.
- Updated Nov. 29, 2022! Region 7 Pretreatment Implementation Annual Report: To be used by the Kansas approved pretreatment programs to report annual program activities.
- Updates include:
- Additional questions.
- Updated to a fillable form.
- Updates include:
- Updated! Municipal Local Limits Calculator: To be used to calculate municipal local limits for pretreatment authorities.
- Updates include:
- Instructions page for using the calculator.
- A step-by-step flow chart to walk through the calculation process.
- New page for entering and averaging influent and effluent data.
- MR Method for averaging metals data in the sewage sludge, influent and effluent.
- A percent removal efficiency display and usage table.
- A Reevaluation data page that compares previous local limits calculations with the new calculations.
- A comparison of the percent industrial contribution to the design capacity in the Conventional Pollutants section.
- Clarification of digester flows in the Plant Data section.
- A “Restore” button on the Sludge data page.
- Updates include:
- Updated! Sewage Sludge Contamination Estimator (Mass Balance Calculator): To be used to estimate and compare the level of metals in municipal sewage sludge with the flow rate from industrial users.
- Updates include:
- Instructions page for using the estimator.
- MR Method for averaging metals data in the sewage sludge.
- Updates include:
- Updated! Region 7 Industrial User Inspection Checklist: To be used by control authorities to perform industrial user compliance inspections.
- Updated to a fillable form.
- Local Limits Front End Worksheet: To be used to consolidate data for local limits calculations.
- Sludge ECHO Data Consolidator: To be used to collect and consolidate sewage sludge metals data for use in the mass balance or local limits calculators.
- Ordinance Review: To be used to compare municipal pretreatment sewer use ordinance with the federal requirements.
- Part 464, Metal Molding and Casting Point Source Category, Subpart A: To be used to calculate aluminum casting production-based pretreatment standards.
- Part 464, Metal Molding and Casting Point Source Category, Subpart B: To be used to calculate copper casting production-based pretreatment standards.
- Part 464, Metal Molding and Casting Point Source Category, Subpart C: To be used to calculate ferrous casting production-based pretreatment standards.
- Part 464, Metal Molding and Casting Point Source Category, Subpart D: To be used to calculate zinc casting production-based pretreatment standards.
- Part 467, Aluminum Forming Point Source Category: To be used to calculate production-based pretreatment standards for all subparts.
- Part 471, Nonferrous Metals Forming and Metal Powders Point Source Category, Subpart F: To be used to calculate titanium-forming, production-based pretreatment standards.
To request access to download these pretreatment tools, enter your email address below and click the “Submit” button. Once accepted, you will receive automatic notification that access has been granted. Please allow two business days to process your request.