Wastewater Treatment Works: Managing Mechanical Assets with Excel

Introduction

A wastewater treatment works is not a building project — it is an industrial process facility that happens to be constructed using civil engineering and building techniques. The permanent works include not just concrete structures and pipework but hundreds or even thousands of mechanical and electrical assets: pumps, valves, screens, blowers, analysers, samplers, flow meters, control panels, and instrumentation. Each of these assets needs to be tracked from procurement through installation, testing, and commissioning to operational handover, and the data captured during construction directly affects the maintenance regime that the asset owner will operate for the next twenty to thirty years.

For the construction team, this means that asset management is not an afterthought — it is an integral part of the project from day one. The quality of the asset records you create during construction determines how smoothly the commissioning phase runs, how confident the client is in accepting the works, and how effectively the operations team can maintain the assets after handover. In this article we look at the key asset management activities on a typical wastewater treatment works project and the Excel tools that support them.

Pump Maintenance Tracking

Pumps are the workhorses of any wastewater treatment facility. A typical works will have dozens of pumps of various types — submersible sewage pumps, progressive cavity sludge pumps, centrifugal clean water pumps, chemical dosing pumps, and more — each with its own maintenance schedule based on the manufacturer's recommendations and the operating environment. During construction, pumps may be installed months before they are commissioned, and some may be used temporarily for dewatering or process diversion. This creates a maintenance liability from the moment the pump is energised, regardless of whether the permanent works are complete.

A pump maintenance tracker in Excel records every pump on the project with its location, type, manufacturer, model number, serial number, installation date, and commissioning status. The maintenance schedule is driven by runtime hours — for example, grease bearings every 500 hours, change oil every 2000 hours, replace mechanical seal every 8000 hours — and the tracker calculates when each maintenance task is next due based on the cumulative runtime recorded at each service. Conditional formatting highlights pumps that are approaching or overdue for maintenance, and a dashboard summary shows the total number of pumps by status (installed, commissioned, operational) and the maintenance compliance rate. This data is essential for the operations and maintenance manual that forms part of the handover documentation.

Valve Schedule Management

Valves are one of the most numerous asset types on a wastewater treatment works, and managing them is a logistics challenge as much as an engineering one. A large works might have several hundred valves — gate valves, butterfly valves, non-return valves, penstock valves, actuated valves, and specialist process valves — each specified by size, material, pressure rating, actuator type, and duty. The valves need to be procured to specification, delivered to site, stored correctly, installed in the right location, tested, and recorded in the asset register.

A valve schedule in Excel provides a complete inventory of every valve on the project, cross-referenced to the process and instrumentation diagram (P&ID) reference, the construction drawing reference, and the specification clause. For each valve, the schedule records the tag number, the type, the size, the material, the pressure rating, the actuator type (manual, pneumatic, electric), the supplier, the delivery status, the installation status, and the test status. The schedule serves multiple purposes: it is a procurement tool (ensuring all valves are ordered), a logistics tool (tracking deliveries against the installation programme), a quality tool (recording test results), and a handover tool (forming the basis of the asset register that is transferred to the operations team).

Sampler and Instrument Logs

Environmental compliance at a wastewater treatment works depends on continuous monitoring of the effluent quality and flow. Automatic samplers collect composite samples of the treated effluent at prescribed intervals, and these samples are analysed to confirm compliance with the environmental permit conditions set by the Environment Agency. During commissioning and the early operational period, the sampling regime is particularly intensive, and meticulous record-keeping is essential to demonstrate that the works is meeting its discharge consent.

A sampler log in Excel records the date and time of each sample collection, the sampler location, the sample type (composite, spot, or flow-proportional), the parameters tested, and the results. The log can be filtered by sampler location or by parameter to identify trends or exceedances. Similarly, an instrument calibration log tracks the calibration status of every measuring instrument on the works — flow meters, level sensors, pH analysers, dissolved oxygen probes, turbidity meters, and others. Each instrument is recorded with its tag number, location, type, calibration frequency, last calibration date, and next calibration due date. Overdue calibrations are highlighted automatically, and the log provides evidence of calibration compliance for the environmental permit and for ISO 17025 requirements where applicable.

Meter Readings and Utility Tracking

During construction and commissioning, the site consumes significant quantities of electricity, water, and in some cases gas. Meter readings need to be recorded regularly — at least monthly, often weekly — for cost control, for carbon reporting, and for billing purposes where the site is operating under a temporary supply arrangement. On a wastewater treatment works, there may also be process-related meters that need regular reading during commissioning to verify that the works is operating within its design parameters.

A meter reading log in Excel provides a structured format for recording each reading with the date, the meter location, the meter serial number, the previous reading, the current reading, and the calculated consumption for the period. Charts show consumption trends over time, making it easy to spot anomalies — a sudden spike in electricity consumption might indicate a pump running continuously when it should be on intermittent duty, while a gradual increase in water consumption might indicate a leak. For sites with multiple meters, the log provides a consolidated summary of total site consumption by utility type, which feeds into the monthly project report and the environmental management reporting.

Testing and Commissioning Records

The testing and commissioning phase of a wastewater treatment works project is where all the civil, mechanical, electrical, and instrumentation work comes together and is proved to function as an integrated system. The commissioning process is documented through a series of inspection and test records (ITRs) that cover everything from individual cable termination checks to full process performance tests. Managing the volume of testing records is a significant administrative challenge — a large works might generate several thousand individual ITRs.

A testing and commissioning log in Excel provides the top-level tracking system for this process. Each ITR is recorded with its reference number, the system or asset it relates to, the type of test, the responsible person, the planned date, the actual date, the result (pass, fail, or not tested), and any punch list items arising. The log can be filtered by system, by status, or by result to generate the completion statistics needed for the commissioning progress meetings and for the handover documentation. A summary dashboard shows the overall completion percentage, the number of outstanding ITRs by system, and the number of open punch list items — the key metrics that the client and the project manager want to see as the handover date approaches.

Conclusion

Mechanical and electrical asset management on a wastewater treatment works is a discipline that runs through the entire project lifecycle, from procurement to handover. Pump maintenance trackers, valve schedules, sampler logs, instrument calibration records, meter reading logs, and testing and commissioning registers are the tools that ensure every asset is tracked, tested, and documented. The data captured in these spreadsheets does not just support the construction phase — it forms the foundation of the operational asset management system that will serve the works for decades. Investing the time to get these records right during construction is one of the highest-value activities on any infrastructure project.