Home › Shop › Pump Troubleshooting Guide
Excel tool

Pump Troubleshooting Guide

Stop guessing. Work down a ranked list of causes, easiest checks first.

Pick the pump kind and the symptom, answer simple yes/no questions and add any readings — get the likely causes ranked, with what to check, what to do and the source.

USD 19 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

Buying several tools? Get the Pumps Complete Kit — USD 129

Need it once? Use it online: check your data free, unlock results from USD 9 for 3 runs.

Pump Troubleshooting Guide — sample pages

What it does

12 symptoms, 4 pump kinds

Centrifugal, vertical and submersible, reciprocating and rotary pumps.

38 causes

Each with what to check, what to do and its literature source — on a visible Cause Library sheet.

Your answers count

16 yes / no / not-known questions move causes up or down; the list shows which answers support or argue against each.

Measurements sharpen it

Flow vs BEP, NPSH ratio, speed, head vs curve, motor current, bearing temperature and packing leakage.

Plain findings

Low-flow, cavitation, overload and hot-bearing warnings with the thresholds stated.

Work order ready

Print-ready report with your answers, readings and the ranked causes.

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

Pump Troubleshooting Guide 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 againstRanking re-implemented in Python from the same knowledge base: identical top-8 lists in eight scenarios; every cause traced to its source.

Online tool or Excel workbook?

Online toolExcel workbook (this page)
What it doesThe same sheet as the Excel workbook, run in your browserPick the pump kind and the symptom, answer simple yes/no questions and add any readings — get the likely causes ranked, with what to check, what to do and the source.
CostCheck your inputs free. Results: 3 runs for USD 9, or every online tool for USD 15 a month (USD 99 a year)USD 19 once, yours to keep
Input checks and findingsEvery input checked; findings with the unlocked resultsEvery input checked, with findings and recommendations
Report for your calculation filePrintable results sheetPrint-ready report with your plant, tag, document number, revision and sign-off
FormulasMethod described in the guideEvery formula visible in its cell
Save, edit and rerun your casesEach run separatelyYes: keep and edit your own file
Works offline, on a plant PCNo, needs the internetYes: Excel 2010 or later, Windows and Mac

Online access and the Excel workbook are separate licences: one does not include the other.

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.