Wastewater Treatment Plant Design Calculation Xls Better May 2026
This report evaluates the current common practices for wastewater treatment plant (WWTP) design calculations using Microsoft Excel. It identifies critical gaps in standard "ad-hoc" spreadsheet approaches—specifically regarding error rates, traceability, and version control. The report outlines a roadmap to achieve "better" calculation spreadsheets through standardization, automation (VBA), and integrated checking protocols, ultimately aiming to reduce engineering man-hours and mitigate technical risk.
This Excel-based tool helps design engineers, students, and operators perform mass balance, sizing, and hydraulic calculations for key unit processes in a municipal or industrial WWTP (up to 10 MLD capacity typical).
Outputs: Tank volumes, air requirements, sludge production, pump sizing, and preliminary cost estimation. wastewater treatment plant design calculation xls better
Scenario: A rural municipality needed to upgrade a 0.5 MGD lagoon to an extended aeration activated sludge plant. This report evaluates the current common practices for
Result: The Excel design was accepted by the state regulator because every formula could be audited. The contractor used the same XLS to verify the tank volumes before pouring concrete. Scenario: A rural municipality needed to upgrade a 0
Excel tip: Use named cells for
Q_avg,Peak_factor,Q_peak.
| Sheet Name | Content | |------------|---------| | Cover | Project info, design inputs (flow, BOD, TSS, temperature) | | Influent & Primary | Screens, grit chamber, primary clarifier | | Biological (ASP) | Aeration tank, F/M ratio, SRT, MLSS, oxygen, blower sizing | | Secondary Clarifier | Surface overflow rate, weir loading, sludge thickening | | Sludge Handling | Gravity thickener, digester volume, dewatering | | Hydraulic Profile | Head loss through units (Excel table + graph) | | Equipment Summary | Pumps, blowers, motors (power, Q, H) | | Cost Estimate (optional) | CAPEX/OPEX rough order |
| Row | Col A (Parameter) | Col B (Value) | Col C (Unit) | Col D (Source/Formula) |
| :-- | :--- | :--- | :--- | :--- |
| 1 | INPUTS | | | |
| 2 | Average Flow | 5,000 | m³/d | User Input |
| 3 | Influent BOD | 250 | mg/L | User Input |
| 4 | Influent TKN | 40 | mg/L | User Input |
| 5 | Target Effluent NH3 | 1.0 | mg/L | Regulatory Limit |
| 6 | Design Temp (Winter) | 10 | °C | User Input |
| 7 | COEFFICIENTS | | | |
| 8 | $\mu_max$ (20°C) | 0.75 | 1/d | Metcalf & Eddy Table |
| 9 | Temp Correction Factor ($\theta$) | 1.07 | - | Metcalf & Eddy Table |
| 10 | CALCULATIONS | | | |
| 11 | Corrected $\mu_max$ | 0.48 | 1/d | =B8*(B9^(B6-20)) |
| 12 | Min SRT Required | 12.5 | days | =1/(B11...) |
| 13 | OUTPUTS | | | |
| 14 | Design SRT | 15.0 | days | Selected Value (> Min SRT) |
| 15 | Reactor Volume | 2,500 | m³ | Calculated via Mass Balance |