Water Treatment Reports

Operational and State reports for Water Treatment Facilities.

play_s.pngVideo on Water and Wastewater Treatment
play_s.pngSlides on Water and Wastewater Treatment

The EPA sets the standard for drinking water quality and oversees all States, localities, and water suppliers that implement the standards.

The Safe Drinking Water Act (SDWA) is the principal federal law in the United States that safeguards human health by protecting the nation's public drinking water supply and its sources (rivers, lakes, reservoirs, springs, and ground water wells).

The SDWA applies to every public water system (PWS) in the United States. There are currently about 155,000 public water systems providing water to almost all Americans at some time in their lives. The Act does not cover private wells.

Water treatment facility

Water Quality Management

XLReporter is scalable so that facilities that vary in size, data sources and people skills all have a solution. The product provides the compliance reports required by the State as well as operating and performance reports used by plant personnel.

State Reports

The major regulations are in Title 40 of the Code of Federal Regulation (40 CFR Part 141,142 and 143) to regulate primary contaminants, implementation by state and secondary contaminants.
Reports in this category include Monthly Operating Reports (MOR), Discharge Monitoring Reports, Surface Water Treatment Report (SWTR), CT Determination Reports and Turbidity Reports.

Operational Reports

Operational reports provide plant personnel the information they need to work more effectively and efficiently, improving the process, driving productivity up and costs down.
Reports in this category include Equipment Performance reports, Production reports, Energy Management reports and Alarm reports.

MA Monthly Operating Report

Individual Filter Monitoring

Water providers must meet a number of requirements for the storing and reporting of water turbidity measurements.

XLReporter gathers turbidity samples for each 15 minute interval for all individual filters and maintains an archive for at least 3 years.

Turbidity values that exceed the maximum NTU must be carried forward for up to 3 months to determine violations in the current and future months.

States like Massachusetts require the timestamps when consecutive samples exceed NTU limits require to be listed as individual records. Valid turbidity measurements for the individual filters start 4 hours after every backwash.

MA Individual Filter CT Calculation

Annual Production

The annual production report provides plant supervisors an up-to-date view of the amount of treated water. It includes monthly reports as well as a yearly summary that shows the monthly minimum and maximum flow over the year.

With the use of Excel, these and many other significant statistics are easily calculated in the report, saving many hours of paper computations.

In practice the report is updated automatically every day by XLReporter’s Scheduler, adding the daily volume to each monthly report sheet.

MA annual water treatment

XLReporter Used In Over 35 USA States

XLReporter is used in hundreds of water and wastewater facilities for their day-to-day operations and the regulatory State reports. Most States publish their reports in Excel format which can be readily imported into XLReporter without touch up.
Below is a sampling of State links which, at the time of this article, referred to their regulatory requirements.

USA

State
Alabama http://adem.alabama.gov/DeptForms/default.cnt
Alaska http://dnr.alaska.gov/mlw/forms/
Arkansas https://www.healthy.arkansas.gov/programs-services/topics/drinking-water-system-forms
Arizona https://azdeq.gov/forms
California http://www.waterboards.ca.gov/water_issues/programs/npdes/
Colorado https://cdphe.colorado.gov/ereporting-rule-discharge-monitoring-report-information
Connecticut http://www.ct.gov/dph/cwp/view.asp?a=3139?Q=387316
Delaware https://www.dhss.delaware.gov/dhss/dph/hsp/odwprogs.html
Florida http://www.dep.state.fl.us/water/drinkingwater/forms.htm
Georgia http://epd.georgia.gov/drinking-water-forms
Hawaii http://health.hawaii.gov/cwb/site-map/clean-water-branch-home-page/forms/
Iowa http://www.iowadnr.gov/InsideDNR/RegulatoryWater/DrinkingWaterCompliance/Forms.aspx
Illinois https://www.dhss.delaware.gov/dhss/dph/hsp/odwprogs.html
Indiana http://in.gov/idem/cleanwater/index.htm
Kentucky https://eec.ky.gov/Environmental-Protection/Water/SubmitReport/Pages/default.aspx
Louisiana http://ldh.la.gov/index.cfm/page/963
Massachusetts https://www.mass.gov/lists/drinking-water-permits-forms-and-templates
Maine http://www.maine.gov/dhhs/mecdc/environmental-health/dwp/
Michigan http://www.deq.state.mi.us/deqforms/default.asp
Minnesota http://www.pca.state.mn.us/index.php/water/water-monitoring-and-reporting/index.html
Missouri https://dnr.mo.gov/water/business-industry-other-entities/reporting/electronic-discharge-monitoring-reporting-system-edmr
Mississippi https://msdh.ms.gov/msdhsite/_static/30,0,76,62.html
North Carolina https://dnr.mo.gov/water/business-industry-other-entities/reporting/electronic-discharge-monitoring-reporting-system-edmr
Nebraska http://www.dnr.ne.gov/forms
New Jersey http://www.nj.gov/dep/watersupply/
New Mexico https://www.env.nm.gov/forms/
Nevada http://ndep.nv.gov/water/drinking-water/forms
New York http://www.health.ny.gov/environmental/water/drinking/forms/forms.htm
Ohio https://epa.ohio.gov/divisions-and-offices/drinking-and-ground-waters/guides-manuals/data-reporting-faqs
Oklahoma http://www.deq.state.ok.us/wqdnew/forms.html
Oregon http://www.oregon.gov/deq/wq/wqpermits/Pages/Forms.aspx
Pennsylvania https://www.dep.pa.gov/Business/Water/CleanWater/WastewaterMgmt/Pages/Wasteload-Management.aspx
Puerto Rico http://ofmpub.epa.gov/waters10/attains_state.control?p_state=PR
Rhode Island http://www.health.ri.gov/licenses/detail.php?id=274#
South Carolina http://www.scdhec.gov/Environment/PermitCentral/ApplicationForms/
South Dakota https://danr.sd.gov/OfficeOfWater/DrinkingWater/DisinfectionByProducts.aspx
Tennessee http://http://tn.gov/environment/topic/wr-wq-dw-drinking-water
Texas http://www.tceq.texas.gov/drinkingwater/swmor/swmor/swmor-forms-and-instructions
Utah https://deq.utah.gov/drinking-water/forms-drinking-water
Virginia https://edmr.deq.virginia.gov/edmr_public/E2/Shared/Pages/Main/Login.aspx?ReturnUrl=%2fedmr_public%2f
Vermont http://drinkingwater.vt.gov/pcwspermits.htm
Washington https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fecology.wa.gov%2FDOE%2Ffiles%2F2a%2F2a986250-a5cf-4eed-b572-3f086faecce2.docx&wdOrigin=BROWSELINK
Wisconsin https://dnr.wisconsin.gov/topic/DrinkingWater/ownerOperator.html
West Virginia http://www.dep.wv.gov/wwe/Pages/default.aspx
Wyoming http://deq.wyoming.gov/wqd/

Canada

Province
Alberta http://environment.alberta.ca/apps/regulateddwq/more.aspx
British Columbia http://www.bclaws.ca/civix/document/id/complete/statreg/200_2003