Home › Shop › Cooling Water System Heat Balance
Excel tool

Cooling Water System Heat Balance

Does the heat your users reject add up to what the cooling tower is rejecting, and how much water does that cost?

Heat balance of a recirculating cooling water system: duty of up to 12 heat users against the measured heat pick-up, closure warning, tower loading and margin, range and approach, and evaporation, drift, blowdown and makeup by cycles or blowdown flow.

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
Cooling Water System Heat Balance — sample pages

What it does

Heat picked up by the water

From circulating flow and supply and return temperatures with IAPWS-IF97 water properties, or the return temperature from the listed duties.

Up to 12 heat users

Name and duty of every user with its share of the total, plus the heat added by the circulating pumps.

Balance closure

Closure error and unaccounted heat against a tolerance you set, with a clear warning when the balance does not close.

Tower loading

Heat rejection, cooling range and approach to the wet bulb, with loading and margin against the tower design heat and water flow.

Water use

Evaporation, drift, blowdown and makeup from cycles of concentration or from the blowdown flow, per hour, per year and per MWh rejected.

What-if tables

Water use at other cycles of concentration, and range, evaporation and makeup at other heat loads, with ranked findings and three charts.

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].

Cooling Water System Heat Balance 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 (IAPWS-IF97 reference implementation for the water properties): all 12 combinations of the three selectors, 16 unit-system variants with every input and result unit switched, and 49 edge-case runs (blank, zero, negative, text and invalid inputs give a clear message and blank results, never an error value).
Free versionTry the free cooling tower water balance 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.