![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
Area Wide Drinking Water Optimization Program for States
Optimization Assessment Software | Long-Term Trend Software
Related Publication
EPA’s Area Wide Optimization Program (AWOP) helps states prioritize their technical assistance resources. AWOP tracks the performance of water systems to show which are in most need of help and also provides tools for systems to optimize their treatment to go beyond regulatory requirements.
Area Wide Optimization Program Tools for Surface Water Systems
All filtered surface water suppliers should consider using these tools to:
- reduce the chances of a waterborne disease outbreak,
- determine whether long-term plant performance is improving or degrading,
- assess the need for assistance, and
- prepare for future regulations.
PDF Version of Software About PDF
- Instructions (PDF) (2 pp, 20K)
- Data Entry Paste (PDF) (14 pp, 71K)
- Data Entry Values (PDF) (48 pp, 699K)
- Treatment Barrier Performance Summary (PDF) (1 pg, 24K)
- Optimization Trend Report (PDF) (2 pp, 98K)
- Turbidity Log Profile (PDF) (1 pg, 13K)
- Settled Turdibity (PDF) (1 pg, 12K)
- Sedimentation Summary (PDF) (2 pp, 19K)
- Maximum Filtered Turbidity (PDF) (1 pg, 13K)
- Filtration Performance Summary (PDF) (4 pp, 39K)
- Long-Term Trend (PDF) (2 pp, 30K)
Optimization Assessment Software (Microsoft Excel) (Version Turb-opt36filtersV4)
This Microsoft Excel program allows filtered surface water suppliers to enter turbidity information and assess the performance of sedimentation processes, individual filters, and the combined filter effluent. The software will also calculate annual averages for each of those parameters, as well as 95th percentile values and percent of values meeting optimization goals. The software will generate simple, yet meaningful graphs and tables so you may compare filter plant performance to the goals.
To download:
- Click on the link called "Optimization Assessment Software".
- When prompted, click "Yes" or "Enable Macros" regarding the notice about macros.
- In Excel, save the file to a familiar folder on your computer by clicking "File" on the top menu line, select "Save," and then click the "Save" button once you know the file and folder names.
You should also open and print the instructions:
PDF (14 pp, 643K, About PDF) or Microsoft Word
Long-Term Trend Software (Microsoft Excel) or (PDF) (2 pp, 24K, About PDF)
The Long-Term Trend Software allows pasting of three years of data, to generate tables of 95th percentiles and percent of values meeting goals for settled and filtered water. It also graphs these trends over three years. This is a Microsoft Excel program.
To download:
- Click on the link called "Long-Term Trend Software".
- In Excel, save the file to a familiar folder on your computer by clicking "File" on the top menu line, select "Save," and then click the "Save" button once you know the file and folder names.
Related Publication:
Implementing AWOPs through the Capacity Development and Drinking Water State Revolving Fund Programs (PDF) (4 pp, 486K, About PDF)
