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
| Format | Excel workbook (.xlsx), no macros |
| Version | v1.0 |
| Works in | Excel 2010 or later, Windows and Mac |
| Units | SI, US and British, mixed freely |
| Includes | Guide tab with method and references, calculator, print-ready report |
| Checked against | Stream duties within 0.1 % of reference equation-of-state results (methanol, toluene, n-hexane, air, steam). |
| Free version | Try the online calculator |
Single-user licence. Team and site licences: see options. Instant download after payment; you also get updates to this major version.
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.