Water Treatment · Excel workbook
Cooling Tower Water Efficiency Calculator
Compare existing and proposed cycles of concentration under an explicit simplified balance.
Download free XLSX ↗Version 1.0 · 25 September 2026 · No registration required
What you need
- Evaporation in kL/day
- Existing and proposed cycles greater than one
- Operating days
- Water and disposal variable costs
What you get
- Makeup and blowdown in each case
- Annual water savings
- Indicative gross variable-cost savings
How to use it
- Save a working copy and read the instructions in the file.
- Replace illustrative inputs or response fields with your site records.
- Check units, dates and boundaries before using the results.
- Keep the completed file with its supporting evidence.
Method
With negligible drift and leaks, blowdown = evaporation ÷ (cycles − 1); makeup = evaporation + blowdown.
Scope and limitations
Higher cycles require approval from the treatment specialist based on water chemistry and equipment. Does not calculate dosing or net project return.
Reference: DOE Cooling Tower Management
Read the related guide: Practical guidance for this tool.