Home › Shop › Cooling Tower Water Balance
Excel tool

Cooling Tower Water Balance

Know exactly where your cooling water goes, and what it costs.

Evaporation, drift, blowdown, makeup and water cost for open recirculating towers — three cases side by side.

USD 29

FormatExcel workbook (.xlsx), no macros
Versionv1.3
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Free versionTry the online calculator

Single-user licence. Team and site licences: see options. Instant download after payment; you also get updates to this major version.

Cooling Tower Water Balance — sample pages
The water balance of a cooling tower. Evaporation leaves the salts behind; blowdown and drift take salts out; makeup replaces all the water lost.
The water balance of a cooling tower. Evaporation leaves the salts behind; blowdown and drift take salts out; makeup replaces all the water lost.

What it does

Complete water balance

Evaporation, drift, blowdown and makeup, plus heat load, approach and effectiveness.

Cycles three ways

Enter cycles directly, work them out from a water analysis (conductivity, chloride, silica, hardness or TDS), or from measured blowdown.

Your choice of method

Evaporation factor from Perry, Marley or GPSA/Branan, or your own; blowdown with or without drift credited.

Annual cost and savings

Water and blowdown treatment cost per year, and a what-if table for higher cycles.

Field check

Compare the calculation with a site test using makeup, blowdown and basin level — find unaccounted losses and your tower's real evaporation factor.

Three cases side by side

Design, actual and proposed, in any mix of SI, US and British units.

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.