KimHEC’s proprietary online data application, DROP – Data Reporting and OPerations.
DROP is a comprehensive wastewater pretreatment software solution because data collection and data use plays a critical role in maintaining an effective pretreatment program for wastewater facilities and industrial users. DROP makes it possible to track and analyze data for facilities with NPDES water permits and pretreatment programs more effectively. KimHEC clients see the most program benefits when using DROP + our consultation services.
DROP‘s Data Management Capabilities
Pretreatment Program Implementation
Wastewater Operational Data
Biosolids Tracking
Water System Data
Collection System Data
DROP consists of multiple components and is designed to bring those elements together to help effectively manage pretreatment and other Water NPDES permit programs. Below is a description of some of the components currently in production:
Contract Laboratory Data: KimHEC works with multiple contract laboratories to generate reports which interface and upload automatically into DROP. These reports include industry data, POTW data, collection system data, and biosolids data.
Industrial User and NPDES Permits: KimHEC enters permit monitoring and permit limits into DROP so that data reported by contract laboratories and users can be checked against permit limits to identify violations.
Data Entry: DROP allows users to enter data directly into the application or by downloading an excel template. Parameters such as daily flow, field pH readings, and pollutant concentrations not sent in via contract laboratories can be uploaded on a daily basis.
Mass Loadings and Mass Limits: KimHEC generates mass loadings as a standard calculation for evaluating results. When a user has a mass limit as part of their permit requirements, the analytical results can be compared to the permit limits.
Customized Queries: DROP offers users the functionality of evaluating specific pollutants and time periods and easily comparing data across locations. The queries can also be exported into Excel for further analysis and trending.
Reporting: DROP generates Discharge Monitoring Report summaries for Monthly, Quarterly, and Semi-Annual time periods which can be saved and attached to eDMRs for NPDES permit reporting. Self-Monitoring Discharge Reports (SMRs) are generated for Industrial Users who use concentration-based or mass-based limits. Additional reporting features to be added in the future (non-discharge, annual reports, etc).
Surcharge Billing: DROP calculates surcharges based on Municipal rates and the average industrial loading. An invoice can be generated to send to Industrial Users for a specified monitoring period.
DROP IS A Tool to assist in
Operations
Plant Upgrades For Capacity
Plant Upgrades For New Regulations
Tracking Pollutants
Additional Surcharge Calculations: Future buildout of DROP will include additional methodology for surcharge calculations with more flexibility in the methodology such as including a flow-component to the utility bill, incorporating surcharges for COD:BOD ratios, and tiered surcharge levels.
Biosolids Tracking and Documentation: DROP will use the analytical data already stored in the client’s database to calculate daily biosolids generated, method of disposal, and cumulative loading calculations for metals (historical) and for nutrients (per growing season).
SCADA Integration: Using a secure connection, DROP will receive pertinent summary data from the client’s existing SCADA system (flows, parameter analyzers, etc), reducing data transfer errors and increasing operator efficiency.
Local Limit Evaluations and Mass Balances: DROP will evaluate analytical data to monitor the effectiveness of the pretreatment program. Based on mass balance evaluations, key pollutants of concern will be identified for which additional data collection and consideration is warranted.
Historical Trending and Visual Graphics: A key component to the functionality of DROP is to provide visual tools so that all the data being collected can be used to trend historical data and evaluate correlations between multiple monitoring locations.
Laboratory Bench Sheets: Users will be able to enter data into standardized laboratory bench sheets to calculate Oxygen Demand, Solids, and more. Bench sheets will be based off of Standard Methods for the Examination of Water and Wastewater.
As a consulting firm, KimHEC can offer these additional customized services:
Laboratory Coordination
Including sample plans, determination of reporting limits, report generation, electronic distribution, analytical methods.
Integrated Data Management
Combine industrial monitoring data with wastewater treatment plant data to evaluate industrial impact on the community’s wastewater treatment plant. Data is also evaluated to determine appropriate monitoring frequencies and to identify pollutants of concern.
Industrial User Reporting Evaluation
Industrial User Reports are evaluated for compliance. Reports can be generated to demonstrate industrial compliance and to identify instances of noncompliance.
NPDES Reporting
KimHEC’s data management system is capable of generating electronic data for upload into electronic reporting for operating permit compliance.