Wastewater Treatment Plant Design Calculation Xls Best Jun 2026

Sized using the Surface Overflow Rate (SOR) , typically ranging from , and Weir Loading Rates . Secondary (Biological) Treatment Calculations

To ensure your Excel sheet is auditable, professional, and free of fatal calculation errors, implement the following design principles: Color-Coded Cell Formatting

What are you focusing on right now? (e.g., Moving Bed Biofilm Reactor (MBBR), Sequencing Batch Reactor (SBR), or conventional Activated Sludge?) wastewater treatment plant design calculation xls best

You might ask: Why not use specialized software?

: Dedicated tabs for grit removal, primary settling, aeration, and secondary clarification. SSI Aeration design sheet or something for a small residential septic system? Sized using the Surface Overflow Rate (SOR) ,

Maya’s spreadsheet was a masterpiece of "automatic calculations". She started with the , inputting the city’s population and per capita demand.

Below I have provided a . You can copy this directly into Excel. It covers the primary calculation chain: Influent Loading $\rightarrow$ Reactor Sizing $\rightarrow$ Aeration $\rightarrow$ Sedimentation. : Dedicated tabs for grit removal, primary settling,

| Process / Unit | Key Design Calculations | Example Spreadsheet Titles & Content | | :--- | :--- | :--- | | | Aeration tank volume, SRT, F:M ratio, return/waste activated sludge rates, oxygen demand. | "Activated Sludge Calculations with Excel," "E – 1533 – Activated Sludge Calculations"; Roteiro de cálculo implementado em Excel/VBA para dimensionamento de lodos ativados. | | MBBR (Moving Bed Biofilm Reactor) | Carrier volume, tank sizing, surface area loading rates (SALR), BOD removal, nitrification. | " A/0-MBBR设计计算及填料校核 "; MBBR Process Design Calculations; "Design your own MBBR with a handy calculation tool". | | SBR (Sequencing Batch Reactor) | Cycle timing, tank volume (rectangular/circular), BOD/ nitrogen removal checking, aeration needs. | "经典SBR工艺计算(excel)"; "SBR Wastewater Treatment Design Calculations"; "SBR/CASS工艺计算表(excel)". | | UASB (Upflow Anaerobic Sludge Blanket) | Reactor sizing, methane production, biological kinetic coefficients, upflow velocity. | "UASB Anaerobic Sludge Blanket Reactor Design Calculations" / "UASB Wastewater Treatment Design Calculations". | | Clarifiers / Sedimentation | Surface overflow rate (SOR), weir loading rate, solids loading rate, tank diameter and depth. | "FINAL CLARIFIER DESIGN CALCULATIONS"; "Lamella (Inclined Plate) Clarifier". | | Sludge Treatment | Thickener and digester sizing, solids mass balance, biogas production, dewatering equipment sizing. | "污泥浓缩池计算 / sludge thickening tank calculation". | | Comprehensive Plant Design | Integration of multiple processes, complete mass balance, full equipment and sizing across all plant units. | "AAO法污水处理设计计算excel"; "一键畅享水处理计算书及Excel计算表格全套资料" which includes "A2O生物池 (厌氧缺氧好氧)计算书" and "AAO法污水处理设计计算". | | Advanced Tools / Simulators | Whole plant simulation, energy balance, GHG estimation, process optimization, and cost-benefit analysis. | "Poseidon 2.0 - Decision Support Tool for Water Reuse"; "PKES (PuKyung -Excel based Simulator)"; "SBR Wastewater Treatment Design Calculations"; "Dissolved Air Flotation (DAF) Calculations". |

SLR accounts for both the influent flow and the Mixed Liquor Recirculation Flow ( QRAScap Q sub cap R cap A cap S end-sub

sand grit) using Stokes' Law to determine the required surface overflow rate ( SORcap S cap O cap R ) and channel length. Primary Clarifier Sizing