Screening, grit removal (size, velocity, head loss).
Use scripts to run iterative loops—such as solving for optimal MLSS versus tank volume—rather than relying on unstable Excel goal-seek functions.
This is the core of the spreadsheet. It applies the international IWA Activated Sludge Models (ASM) or Metcalf & Eddy empirical equations. wastewater treatment plant design calculation xls better
Use the concept to avoid solids loading failure. Your XLS should calculate:
This is where generic spreadsheets typically fail. A robust design must calculate biological kinetics based on the International Water Association (IWA) Matrix Models or standard Metcalf & Eddy equations: Screening, grit removal (size, velocity, head loss)
Excel’s "What-If Analysis" tools, such as Data Tables and Goal Seek, allow designers to run instantaneous sensitivity analyses. For instance, an engineer can see how a 5°C drop in winter wastewater temperature simultaneously impacts the required SRT, basin volume, and blower energy consumption. Cost Efficiency and Accessibility
To maximize the benefits of Excel, a structured approach is best: It applies the international IWA Activated Sludge Models
Need a head start? Look for XLS files that include ASM1 (Activated Sludge Model No.1) simplification and built-in economic cost curves for tank concrete and piping. That is the ultimate "better" standard.