Home › Shop › HRSG Pinch and Approach Analysis
Excel tool

HRSG Pinch and Approach Analysis

How much steam can your exhaust gas make at one, two or three pressure levels, where is the pinch, and how cold can the stack gas get before the dew point bites?

Steam generation, section duties, gas temperature profile, stack temperature, dew point margin and T-Q diagram data for a single, dual or triple pressure HRSG from your pinch and approach targets.

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
HRSG Pinch and Approach Analysis — sample pages

What it does

One, two or three pressure levels

The pinch and approach points of each level fix its steam generation; the lowest-pressure economiser heats all the feedwater.

Built-in properties

IAPWS-IF97 steam and water as workbook formulas; exhaust gas as an ideal-gas mixture from a typical turbine exhaust or your own analysis.

Section duties and profile

Superheater, evaporator and economiser duty at each level, gas temperatures in and out of every section, stack temperature and effectiveness.

UA of every section

Heat transfer conductance from the log-mean temperature difference, and the smallest gas-to-water temperature difference.

Cold-end check

Water dew point and, with your SO3 content, the acid dew point against the stack and feedwater temperatures, with a warning.

T-Q diagram and what-ifs

T-Q diagram data, feedwater temperature and pinch what-if tables, 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].

HRSG Pinch and Approach 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 (IAPWS-IF97 reference implementation and NASA polynomial data, separate code path) in 183 recalculated runs and 16,883 values: every combination of the three selectors (18), 70 further input sets, 9 runs with every input typed in US, British and mixed units, 49 invalid or blank input sets, 18 valid edge cases; largest relative deviation 7e-7; 0 formula errors in LibreOffice.
Free versionTry the free steam tables 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.