Home › Shop › Centrifugal Pump Performance Evaluation
Excel tool

Centrifugal Pump Performance Evaluation

Is your pump still on its curve, and does it have enough NPSH margin? Site readings come at a different speed, impeller trim and liquid from the curve, so the raw numbers cannot be compared directly.

Pump readings turned into head, power, efficiency and NPSH margin, referred to your own five-point curve by speed, trim and viscosity correction: position against the best-efficiency flow, head and efficiency shortfall, minimum-flow flag.

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
Centrifugal Pump Performance Evaluation — sample pages

What it does

Head, power and efficiency

Differential head from pressures, elevations and velocity heads; hydraulic and shaft power, pump and wire-to-water efficiency and kWh per m3.

NPSH margin

NPSH available against the NPSH required you enter, with margin, margin ratio and an OK, Caution or Alert level.

Your five-point curve

Head, efficiency and power fitted by a quadratic; best-efficiency flow, percent of BEP, preferred operating region and a minimum-flow flag.

Speed, trim and viscosity

Affinity-law correction for speed and impeller trim, and a viscosity correction aligned with the publicly documented Hydraulic Institute method.

Deviation from the curve

Head, efficiency and power shortfall at the equivalent flow, with an OK, Watch or Alert level.

Any liquid

Water from temperature with IAPWS-IF97, or your own density, vapour pressure and viscosity for any liquid.

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

Centrifugal Pump Performance Evaluation 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 in about 100 recalculated runs: all 64 selector combinations, SI, US and British units, and 31 edge and invalid-input cases; 0 formula errors in LibreOffice.
Free versionTry the free pump head, power and efficiency 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.