Here's a simple example of a wastewater treatment plant design calculation XLS:
Here is a quick look at a formula that should be in your spreadsheet:
The Ultimate Guide to Wastewater Treatment Plant Design Calculations (with XLS Tools)
Dedicate the first worksheet to global design constants. Include parameters like the density of water, acceleration due to gravity, and standard regulatory effluent limits (e.g., BOD wastewater treatment plant design calculation xls best
Estimating primary and secondary waste activated sludge (WAS) mass.
Program the sheet to multiply the chamber volume by a factor of 0.2 to 0.5 per meter of chamber length. 4. Step 3: Primary Clarifier Design Formulas
) and settling velocity of a target particle size (typically 0.2 mm sand). Primary Sedimentation Tanks (PST) Here's a simple example of a wastewater treatment
: Sizing based on the number of users (e.g., 150 liters/person/day). Unit Sizing : Designing for a specific velocity, often around Biological Reactors (MBBR/MBR)
Comprehensive Guide to Wastewater Treatment Plant Design Calculations
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. Unit Sizing : Designing for a specific velocity,
Estimating waste activated sludge (WAS) and primary sludge. Thickener/Digester Sizing. What Makes an XLS Spreadsheet the "Best"?
, dynamically updating all downstream formulas without breaking links. Comprehensive Kinetic Parameter Libraries
Biological kinetic rates ( μmaxmu sub m a x end-sub
Your spreadsheet should use this value to calculate the and size the aeration blowers based on diffuser depth and site elevation. 6. Step 5: Secondary Clarifier Sizing Matrix