Surge margin of each operating point against your surge line: control line position, alarm status, required recycle flow, recycle valve loading and the margin trend.
USD 39 one-time purchase

What it does
Surge and control lines
Surge limit line from 4 to 8 points of flow with polytropic head or pressure ratio, linear or quadratic interpolation, and a control line offset by your margin.
Margin of every reading
Up to 12 operating points with the margin to surge on a flow or head basis and the position against the control line; points outside the surge-line data are marked.
Alarm status
Each point classed as right of the control line, left of it with the recycle valve open, in the alarm zone or at the surge limit, with counts and an overall status.
Recycle flow to restore margin
The recycle flow that brings each point back to your target margin at the same head, as suction volume flow and as mass flow.
Recycle valve loading
Valve capacity and opening from its Cv or Kv and the choked-flow limit, aligned with the publicly documented IEC 60534-2-1 gas sizing method.
Margin trend
Least-squares slope of the margin against time and the time left before the control line is reached, with ranked findings and three charts.
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].
Specification and checks
| 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 | An independent Python model (separate interpolation code, root-finding for the valve opening) in 232 recalculated runs: the default case, all 16 selector combinations on two data sets, SI, US, British and industry unit sets (identical to 1e-13), result unit switching, 105 edge and invalid-input cases and 80 random cases, about 16,900 values compared; 0 formula errors in LibreOffice. |
| Free version | Try the free compressor head and power calculator |
Compatibility, licence and support
| File | Excel 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. |
| Licence | Single user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms. |
| Updates | Updates to this major version are included; download them again from the link in your receipt. |
| Support | Email [email protected] with your order number — questions on the method, your inputs or your results are welcome. |
| Refunds | If 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. |
Field guide: Gas Turbines, HRSG and Compressors Made Simple