Digital Tools: Spreadsheets, CMMS, and Online Reporting Portals

Why Digital Tools Matter for Water and Wastewater Operators

Modern water and wastewater facilities rely on accurate records to protect public health, meet regulatory requirements, and keep equipment running. Three digital tools appear at virtually every facility: spreadsheets, Computerized Maintenance Management Systems (CMMS), and state online reporting portals. Operators who can use all three are safer, faster, and far less likely to make costly data-entry mistakes that trigger regulatory action.

Spreadsheets: Turning Raw Data into Useful Information

A spreadsheet organizes numbers in rows and columns and performs calculations automatically. For operators, the most common uses are:

• Tracking daily operational data — flow rates, turbidity, pH, chlorine residual, and similar parameters
• Calculating weekly or monthly averages — required on most monthly operating reports (MORs)
• Flagging values that exceed a threshold — using a conditional formula so out-of-range readings stand out
• Generating graphs — a line graph of daily chlorine residual, for example, makes trends visible at a glance

Free software such as LibreOffice Calc and institutional copies of Microsoft Excel both support these tasks. The key is formula discipline: always reference the cell that holds the data rather than typing numbers directly into a formula, so the spreadsheet updates automatically when data change. Use the `AVERAGE` function for means and an `IF` statement (for example, `=IF(B2>0.5,"EXCEED","OK")`) to flag values above a threshold. Label every column header and every graph axis with the parameter name and unit. An unlabeled graph is useless during a regulatory inspection.

Graph best practices: Include a title, labeled x-axis (dates), labeled y-axis (parameter and unit), and a horizontal reference line at the regulatory or operational threshold if one applies. Keep the scale honest — do not compress the y-axis in a way that hides variation.

Computerized Maintenance Management Systems (CMMS)

A CMMS is software that tracks equipment, schedules preventive maintenance (PM), and records what work was done. Regulatory agencies and insurance auditors may request maintenance records, so completeness and accuracy are non-negotiable.

Creating a work order: A typical PM work order for a pump includes:

1. Asset ID or equipment name

2. Work type (preventive, corrective, or emergency)

3. Priority level (routine, urgent, critical)

4. Assigned technician

5. Scheduled date

6. Parts and labor used

7. Completion notes — describe what was found and what was done, not just "done"

Overdue work-order report: Most CMMS programs can generate a list of all work orders past their due date. When you show this report to a supervisor it tells them which equipment has not received scheduled maintenance, helping the team prioritize before a failure occurs. An untreated overdue PM on a chemical feed pump, for example, could lead to under-dosing and a public health violation.

State Online Reporting Portals

State drinking water and wastewater programs use web-based portals where operators submit monitoring results. Examples include state Safe Drinking Water Act (SDWA) compliance portals. Errors in these systems can trigger automatic violation notices, so accuracy is critical.

Fields you will typically complete:

• Monitoring period — the quarter, month, or specific date range required by your permit or monitoring schedule
• Sample point ID — the specific location code in your system (entry point, distribution point, etc.)
• Contaminant or analyte code — a code assigned by the state for each regulated substance (e.g., total coliform, chlorine residual, turbidity)
• Result value and unit — enter the number and select the correct unit from a dropdown; mg/L and µg/L are not interchangeable
• Laboratory ID — for lab-analyzed samples

MCL exceedance and automatic triggers: If you enter a result that exceeds the Maximum Contaminant Level (MCL) for that parameter, most portals automatically flag the entry and may generate a violation record or notify the primacy agency. This is not a system error — it is the regulatory safeguard working as intended. The operator's job is to ensure the data are accurate before submitting; once submitted, an MCL exceedance sets a clock running for public notification and corrective action requirements.

Safety Considerations in the Computer Lab and with Digital Records

• Data integrity is a safety issue. Entering a wrong result — even by accident — can delay the detection of a contamination event. Double-check every value before submitting.
• Secure login credentials. Never share your portal username or password. In most states, electronic submissions carry the same legal weight as a signature.
• Protect sensitive data. System maps and certain operational data may be sensitive; follow your facility's cybersecurity policy.
• Ergonomics. Prolonged computer work can cause repetitive strain. Adjust your chair and monitor; take short breaks during extended data-entry sessions.

Connecting These Tools to Licensing Requirements

State licensing exams for Class I and Class II water and wastewater operators test your understanding of record-keeping obligations, reporting deadlines, and the consequences of late or inaccurate reports. Employers expect licensed operators to produce accurate monthly operating reports and to maintain maintenance records that can survive a regulatory audit. The skills practiced in today's lab are direct preparation for both the exam and the job.