Chemical costs are a major operational expense for every water and wastewater plant. Supervisors, plant managers, and council members need to see monthly totals, year-over-year comparisons, and cost trends to make budget decisions and justify expenditures. Month summary DataViews in Operator10 consolidate chemical usage data into a clean 12-month grid that shows totals, averages, and calculated costs at a glance.
Why use month summary for chemical tracking?
Daily chemical usage data is useful for process control, but budget planning requires monthly totals. How many pounds of chlorine did we use in October? What was the average daily polymer dose in September? How does this year’s alum usage compare to last year? Month summary DataViews answer these questions by aggregating daily values into monthly summaries, so you see one row (or column) per month instead of 28–31 rows.
How to create a month summary DataView
When creating a new DataView in Operator10, the top of the dialog box has a View Type dropdown that defaults to Daily. Change it to Month Summary. Then filter and select the location parameters you want to track: chemical feed rates, total pounds used, calculated costs, etc. When you click OK, Operator10 displays the DataView as a 12-month grid, with each column (or row) representing one month. Summary values like Sum, Average, Min, or Max appear for each month.
Choose the right summary type
For chemical usage, Sum is the most common summary type because you want to know total pounds used per month. For chemical feed rates, Average might be more useful because it shows the typical daily dose. You can display both by adding the same parameter twice: once with Sum summary type, once with Average summary type. For example, create columns for “Total Chlorine Used (Sum)” and “Avg Daily Chlorine Dose (Average)” so you see both metrics side by side.
Add calculated cost columns
If your Operator10 database includes chemical cost per pound or gallon, you can create calculated parameters that multiply usage by cost and display total monthly expenditure. For example, if polymer feed rate is stored in pounds per day and you have a “Polymer Cost per Pound” parameter, create a formula that multiplies feed rate × cost. Add that calculated parameter to your month summary DataView with a Sum summary type, and you’ll see total monthly cost for polymer. Repeat for each chemical to build a complete cost tracking view.
Set a useful date range
Month summary DataViews default to showing the current calendar year (12 months). To compare multiple years, click the date range dropdown and select Custom. Set the start date to January 1 of the earliest year you want to review and the end date to the current month. The DataView expands to show every month in that range, grouped by year. This is useful for multi-year budget analysis or spotting seasonal usage patterns that repeat annually.
Use for council meetings and budget reviews
Many plants print or export their month summary DataView for chemical costs at the end of each month and present it at council meetings, budget hearings, or internal management reviews. The 12-month layout provides a clear year-to-date snapshot of spending. If alum costs spiked in July, the council sees it immediately. If chlorine usage has been dropping over the year, the trend is obvious. No need to build a separate report—just open the DataView, adjust the date range if needed, and export to Excel or print to PDF.
Track multiple chemicals in one view
A well-designed month summary DataView for chemical costs includes all major chemicals your plant uses: chlorine, alum, polymer, ferric chloride, sodium hydroxide, etc. Each chemical gets two columns: one for total pounds used (Sum) and one for total cost (Sum of calculated cost parameter). Add a column for total monthly flow (Sum) so you can see usage relative to treatment volume. Supervisors can review the entire chemical program’s performance and costs in one screen.
Combine with custom column headers
Long parameter names like “Chlorine Feed Pump Station 1 Total Pounds Used” clutter the month summary DataView. Use custom column headers (see that blog post) to shorten them: “Cl2 Pounds,” “Cl2 Cost,” “Alum Pounds,” “Alum Cost.” Keep headers concise so the 12-month grid fits on one screen or one printed page without scrolling or resizing.
Update and review monthly
Set a recurring task to open your chemical cost month summary DataView on the first of each month. Review the previous month’s totals, compare to budget targets, and check for unusual spikes or drops. Export the updated view to Excel or save a PDF snapshot for your records. Over time, you’ll build a historical archive of monthly chemical costs that supports long-term planning and capital improvement decisions.
Why this matters for plant management
Budget justification requires data, not guesses. When a council member asks, “Why did we spend $12,000 on polymer last quarter?” you can open your month summary DataView and show exactly how much was used each month, what the average daily dose was, and how that compares to the same quarter last year. When you need to forecast next year’s chemical budget, you have historical monthly totals to base your projections on. Month summary DataViews turn daily operational data into strategic management information.
Next Steps: Track operational costs with Operator10 →
