Wastewater Treatment Plant Design Calculation Xls Better May 2026
While BioWin licenses can cost thousands per year, Excel is ubiquitous in every engineering office. A custom-designed WWTP calculation XLS can be shared freely with junior engineers, contractors, and regulatory bodies without licensing compliance headaches.
A B C D
---------------------------------------------------------------
[Sheet: Biological]
Q_avg (m³/d) 2000 <- Input
BOD_in (mg/L) 250 <- Input
MLSS (mg/L) 3000 <- Input
F/M (kg/kg/d) 0.3 <- Input (or calc)
Volume (m³) =B2*B3/(B4*B5) where B5=MLVSS
SRT (days) =B6*MLVSS/(Sludge_prod)
O2_required (kg/d) ... formula ...
Air (m³/min) =O2_needed / (0.23*1.201*0.2*60)
| 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 | wastewater treatment plant design calculation xls better
This is where you move from a "calculator" to a "design tool." While BioWin licenses can cost thousands per year,
| Aspect | Excel (Better Design) | Specialized Software (e.g., GPS‑X, BioWin, Sumo) |
|--------|-----------------------|--------------------------------------------------|
| Cost | Low (existing license) | High ($5k–$20k per seat) |
| Learning curve | Moderate | Steep |
| Process kinetics | Simplified (e.g., Monod) | Advanced (ASM2d, ASM3) |
| Dynamic simulation | Difficult | Built‑in (24h+ diurnal) |
| Error checking | Manual | Automatic mass closure |
| Audit trail | Via formula auditing | Automatic version control | | Row | Col A (Parameter) | Col
Conclusion: Excel is excellent for preliminary design, teaching, and small plants (<1 MGD). For complex biological nutrient removal or plant expansions, specialized software is “better” overall — but Excel remains the most accessible starting point.
Scenario: A rural municipality needed to upgrade a 0.5 MGD lagoon to an extended aeration activated sludge plant.
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.