Home › Shop › Heat Integration and Pinch Analysis
Excel tool

Heat Integration and Pinch Analysis

How much heating and cooling does your process really need, where is the pinch, and how much heat recovery is left on the table?

Pinch analysis for up to 12 streams: minimum hot and cold utility, pinch temperature, composite and grand composite curves, area and units targets, utility saving and a ΔTmin sweep.

USD 49 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
Heat Integration and Pinch Analysis — sample pages

What it does

Problem table

The publicly documented Linnhoff and Flower algorithm: heat cascade, minimum hot and cold utility and the pinch temperature for up to 12 streams.

Three ways to set ΔTmin

One global value, a contribution for each stream, or contributions derived from the film coefficients of the streams.

Area and units targets

Heat transfer area target on the balanced composite curves and the minimum number of units above and below the pinch.

Utility saving

Duties above and below the pinch and the saving potential against your current hot and cold utility use.

ΔTmin sweep

Five what-if rows showing how the utility, area and units targets move with ΔTmin.

Composite curves

Composite and grand composite curve data as tables and charts, with ranked findings and a print-ready report.

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 Integration and Pinch Analysis 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 (heat-cascade linear programme, composite curves by bisection, area target by numerical integration, separate code path) in 209 recalculated runs and 33,581 values: every combination of the three selectors (12), 64 random input sets with 2 to 12 streams, multiple-pinch, threshold and curve-contact cases, 22 hand-picked cases, 36 runs with every input typed in US, British and mixed units (identical results), 49 invalid or blank input sets, 11 valid edge cases; largest relative deviation 1e-8; 0 formula errors in LibreOffice.
Free versionTry the free heat exchanger duty and LMTD 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.