Calculation of screen area based on peak flow to prevent clogging.
The best spreadsheets include a "Sanity Check" column next to key outputs. For example, if your calculated Surface Overflow Rate for a primary clarifier results in
Look for calculators verified against textbook standards like Metcalf & Eddy’s Wastewater Engineering: Treatment and Resource Recovery . Always cross-check downloadable sheets against textbook examples to ensure formulas are free of syntax errors.
allow you to configure complete systems, from screening and grit chambers to biological units like MBBR, MBR, or SBR. Automated Hydraulic & Unit Sizing
Dissolved oxygen (DO) safety factors account for site elevation and ambient summer air temperatures. wastewater treatment plant design calculation xls best
: Use color-coded cells (e.g., blue for user inputs, yellow for automated calculations) to prevent accidental overwriting of formulas. Standardized Lookups
The EPA (Environmental Protection Agency) and university departments sometimes offer free design calculators for conventional treatment processes. 3. Creating Your Own Custom Template
Formulated equations to calculate the required pumping rate to maintain steady-state MLSS.
Instantly calculate changes in effluent quality based on altered input parameters (e.g., changing influent BODcap B cap O cap D Calculation of screen area based on peak flow
When looking for the ideal calculation template, prioritize sheets that feature comprehensive mass balance verification. The spreadsheet must demonstrate a closed-loop system where total mass influent equals the sum of mass effluent and wasted sludge.
This is the foundation. Your spreadsheet must allow you to input: Average Daily Flow ( Qavgcap Q sub a v g end-sub ) Peak Hourly Flow ( Qpeakcap Q sub p e a k end-sub ) Influent BOD, TSS, TKN, and P levels 2. Preliminary Treatment Design
Measures the organic strength of incoming wastewater, typically expressed in
ETP Design and Calculation Guide | PDF | Chemistry | Materials - Scribd : Use color-coded cells (e
Estimating waste activated sludge (WAS) and primary sludge. Thickener/Digester Sizing. What Makes an XLS Spreadsheet the "Best"?
A premier wastewater treatment plant design spreadsheet balances biological kinetics with physical hydraulics. By structuring your calculation tool modularly—separating raw inputs from locked formulas and building in automated compliance alerts—you create an asset that saves hundreds of engineering hours while minimizing design risks.
Comprehensive Guide to Wastewater Treatment Plant Design Calculations