Home › Shop › Wastewater Treatment Load Calculation
Excel tool

Wastewater Treatment Load Calculation

How much pollutant load reaches each treatment stage, how much oxygen and blower power does the aeration basin need, and are the clarifiers inside their loading limits?

Pollutant loads through the primary, biological and tertiary stages, equalisation volume, activated sludge balance, oxygen demand, air flow and blower power, clarifier loading and a discharge limit check, for conventional or extended aeration.

USD 39 one-time purchase

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Wastewater Treatment Load Calculation — sample pages

What it does

Loads through the plant

BOD5, COD, TSS, TKN and total phosphorus in kg/d at the raw, primary, biological and final effluent points, with removal per stage.

Equalisation volume

Volume for a diurnal flow cycle, with the peak factor before and after equalisation.

Activated sludge balance

Sludge production, aeration volume, F/M ratio and sludge age for conventional or extended aeration.

Oxygen and blower power

Carbonaceous and nitrogenous oxygen demand, standard oxygen transfer rate, air flow and blower power.

Clarifier loading

Surface overflow and solids loading rates at average and peak flow against your limits, and the area needed.

Discharge limit check

Margin on each effluent parameter, plus what-if tables for sludge age and wastewater temperature.

Built for engineers

  • Visible formulas — nothing hidden, so you can check every step.
  • Fully referenced — methods from the standard references, checked against their published worked examples.
  • Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
  • Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.

For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.

Preview the workbook

An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].

Wastewater Treatment Load Calculation Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstAn independent Python model: all 12 combinations of the three selectors, unit-system variants with every unit option switched, 32 valid edge cases and 36 invalid-input cases (blank, zero, negative, text and out-of-range inputs give a clear message and blank results, never an error value). Results agree within 1e-14 relative.
Free versionTry the free chemical dosing rate calculator

Compatibility, licence and support

FileExcel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy.