Using Excel’s native and Goal Seek features allows designers to instantly stress-test the plant design. For example, you can see how an unexpected 30% spike in industrial influent COD impacts the required aeration tank volume or MLSS concentration without re-running an entire software simulation block. Low Cost and High Portability
This Excel-based tool helps design engineers, students, and operators perform , 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.
Which does your firm prefer? (e.g., Metcalf & Eddy, ATV-DVWK-A 131, WEF Manual of Practice)
Set up visual warnings if the calculated Sludge Volume Index (SVI) or weir loading rates breach state or national regulatory limits. 4. Avoiding Common Pitfalls in Spreadsheet-Based Sizing wastewater treatment plant design calculation xls better
Use index-match functions to let users instantly switch the entire workbook between Metric units ( ) and US Customary units (MGD,
=IF(Calculated_SOR > Max_Allowable_SOR, "FAIL: Footprint Too Small", "PASS")
Excel handles these moving targets through built-in data tools: Using Excel’s native and Goal Seek features allows
(e.g., light blue fill) from hardcoded constants (gray) and calculated outputs (no fill/bold).
Top-tier WWTP design sheets typically include modules for specific treatment stages:
In the engineering of wastewater treatment plants (WWTP), precision is paramount. While specialized modeling software exists, many industry professionals find that a customized is often a better choice for preliminary design, optimization, and daily operational adjustments. Commercial wastewater simulation software is powerful
To size the connecting channels and ensure self-cleansing velocities, Manning's equation is fundamental: $$v = \frac1n \times R^2/3 \times S^1/2$$ Where $v$ is velocity (m/s), $n$ is roughness, $R$ is hydraulic radius, and $S$ is slope.
Senior engineers can click on a cell to instantly verify the math.
Commercial wastewater simulation software is powerful, but it often operates as a "black box." Input parameters go in, and a final design comes out, hiding the underlying equations. Auditability