Home › Shop › Heat Duty and Utility Consumption
Excel tool

Heat Duty and Utility Consumption

Turn a stream list into utility demand and a yearly cost in minutes.

Heat duty for up to 10 process streams, the steam, cooling water, refrigeration or fuel each one needs, and the yearly utility bill.

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

Buying several tools? Get the Heat Exchanger Complete Kit — USD 179

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

Try the online calculator

Heat Duty and Utility Consumption — sample pages

What it does

Up to 10 streams

Fluid, flow, inlet and outlet temperature and pressure — boiling and condensing included.

10 utilities

LP, MP and HP steam, cooling and chilled water, refrigeration, electric heater, fired heater, hot oil and heat recovery.

Your site data

Utility prices, steam pressures, efficiencies and COP with editable defaults.

Totals by utility

Duty, utility use, MWh per year and cost per year, by stream and by utility.

Feasibility checks

Heating or cooling direction and utility temperature checks for every stream.

Heat recovery hint

Flags when the plant both heats and cools, so a heat recovery study may pay.

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

Heat Duty and Utility Consumption 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 againstStream duties within 0.1 % of reference equation-of-state results (methanol, toluene, n-hexane, air, steam). See the verification record
Free versionTry the online calculator

Online tool or Excel workbook?

Online toolExcel workbook (this page)
What it doesThe same sheet as the Excel workbook, run in your browserHeat duty for up to 10 process streams, the steam, cooling water, refrigeration or fuel each one needs, and the yearly utility bill.
CostCheck your inputs free. Results: 3 runs for USD 9, or every online tool for USD 15 a month (USD 99 a year)USD 39 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.