Home › Shop › Utilities Cost Calculator
Excel tool

Utilities Cost Calculator

Know what each tonne of steam, MWh of power and m³ of water really costs your plant.

The cost of every utility your plant makes — raw to demin water, steam at up to six pressures, power from every source, cooling water, air and nitrogen — solved together, with a monthly-data tab.

USD 79 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

Download the sample report (PDF)

New here? Get the free Starter Pack (three Lite Excel tools, two field-guide samplers).

Need it once? Use it online: check your data free, unlock results from USD 9 for 3 runs.

Utilities Cost Calculator — sample pages

What it does

The whole water chain

Wells, canal and purchased water, then clarifier, filter, softener, RO, cation–anion, polisher and condensate polisher — chemicals, resin and membranes, power and fixed costs per step.

Steam at up to six pressures

4 fired boilers, 4 waste-heat boilers, HRSGs and 6 letdown stations, on IAPWS-IF97 steam tables, with deaerator and blowdown balances.

Power from every source

Gas turbines and engines, steam turbine generators, grid import, solar and wind — each with its own cost per MWh and a plant average.

Fair heat-recovery credit

HRSG and process waste-heat steam valued by the boiler-credit method, so no cost is counted twice.

Cooling water, air and nitrogen

Evaporation, blowdown and up to 12 treatment chemicals; plant and instrument air; PSA, cryogenic or purchased nitrogen.

Monthly data in, averages out

Type each month's logged totals and operating days; the tool works out the averages and the operating hours.

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

Real pages from the workbook with its built-in example loaded (example data, not a measured plant). Choose a page below, or select the large image to enlarge it.

Report sheet (Results): unit cost of each utility, example data
Select a page, then the large image to enlarge.Open original-resolution imageDownload the sample report (PDF)

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 againstMatches an independent calculation model in six plant cases (differences below one part in a billion); steam properties match IAPWS-IF97 reference values; monthly averaging checked against hand averages.

Online tool or Excel workbook?

Online toolExcel workbook (this page)
What it doesThe same sheet as the Excel workbook, run in your browserThe cost of every utility your plant makes — raw to demin water, steam at up to six pressures, power from every source, cooling water, air and nitrogen — solved together, with a monthly-data tab.
CostCheck your inputs free. Results: 3 runs for USD 9, or every online tool for USD 15 a month (USD 99 a year)USD 79 once, yours to keep
Input checks and findingsEvery input checked; findings with the unlocked resultsEvery input checked, with findings and recommendations
Report for your calculation filePrintable results sheetPrint-ready report with your plant, tag, document number, revision and sign-off
FormulasMethod described in the guideEvery formula visible in its cell
Save, edit and rerun your casesEach run separatelyYes: keep and edit your own file
Works offline, on a plant PCNo, needs the internetYes: Excel 2010 or later, Windows and Mac

Online access and the Excel workbook are separate licences: one does not include the other.

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.