OdysseyGPT

Free template

Pump performance test record template: a test report format (Excel and CSV)

For pump manufacturers and test-bed engineers: rated point, test points with guaranteed and measured values side by side, instruments with calibration details, and a witness block.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A pump performance test measures flow, head, power and efficiency at several points and compares them with the guaranteed values. This free Excel record sheet holds the pump and rated-point header, a table of test points with guaranteed and measured values side by side, an instrument list with calibration certificate numbers and due dates, and a witness block.

Key Takeaways

  • Write the test standard and acceptance grade exactly as the contract names them. They set the tolerance.
  • Only the rated point normally carries a guarantee. Curve values at other points are for information unless the contract says otherwise.
  • A reading from an instrument out of calibration is in doubt, however good it looks.
  • The example has 6 test points and 6 instruments for an invented pump order (PO-EX-9040).

Download the pump performance test record

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX. Here the CSV holds the test point table; the instrument table is in the XLSX.

Where the record fits in a pump order

The performance test is often one of the last hold or witness points before a pump is painted and packed. Prepare the header and the instrument sheet the day before, from the datasheet and the test procedure, so that on the day the test-bed engineer only enters readings. Afterwards the signed record, the plotted curve and the calibration certificates go into the record book together.

  • Test-bed engineers, who take the readings and convert them to rated speed.
  • Quality engineers, who compare measured values with the guarantee and release the pump.
  • Customer and third-party inspectors, who sign the witness block.

The template states no acceptance tolerance. That comes from the contract and from the test standard and grade it names, and the two can differ from one order to the next. Check the governing standard or contract. For what a pump datasheet commits you to, see API 610 pump datasheet review and pump manufacturers.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Cooling Water Upgrade (fictional)
CustomerExample Process Company Ltd (fictional)
Purchase orderPO-EX-9040 (fictional)
Pump tagP-9040A
Pump serial no.EX-P-55012 (fictional)
Pump type and sizeSingle-stage end-suction centrifugal pump (fictional)
DatasheetDS-EX-P-9040 Rev C
Test procedureTP-EX-P-01 Rev B
Test standard and acceptance gradeAs named in the contract
Rated point (from the datasheet)120 m³/h at 85 m, 2950 r/min (invented order)
Guaranteed at the rated pointHead 85.0 m; power 37.6 kW; efficiency 74.0 %; NPSHR 3.2 m (invented order)
Test fluidClean cold water, 18 °C
Test speed2962 r/min measured; results converted to 2950 r/min as TP-EX-P-01 describes
Driver used for the testCalibrated test-bed motor
Test date2027-04-14
Record no.PTR-EX-9040A Rev 0

Example test points: a single-stage centrifugal pump

Invented example test points for pump P-9040A (guaranteed or curve value / measured value)
PointDescriptionFlow (m³/h)Head (m): guaranteed or curve / measuredPower (kW): guaranteed or curve / measuredEfficiency (%): guaranteed or curve / measuredNPSHR (m): guaranteed / measuredResultRemarks
1Shut-off (closed valve)0101.0 / 102.417.0 / 17.3- / -- / -InformationCurve value only; no guarantee at this point in the invented order.
2Minimum continuous flow3699.0 / 99.623.5 / 23.941.3 / 40.9- / -Information
3Intermediate8494.0 / 94.831.6 / 31.968.1 / 68.0- / -Information
4Rated point12085.0 / 85.937.6 / 38.474.0 / 73.13.2 / 3.0QueryHead is above and NPSHR below the guaranteed figures. Power is above and efficiency below. Compare each with the tolerance in the contract and the test standard and grade it names before deciding.
5Above rated flow13280.0 / 80.739.2 / 39.973.4 / 72.8- / -Information
6End of curve14473.5 / 74.040.6 / 41.271.0 / 70.5- / -InformationCompare the measured power with the driver rating on the datasheet.

Every figure is invented, including the guaranteed values, which belong to an invented order. At the rated point the measured power is above the guaranteed figure and the efficiency below it, so the row is a query: someone must compare both with the tolerance in the contract before the pump is accepted or rejected. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Instruments used and witness block

Invented example instruments for the test on 2027-04-14
ItemQuantity measuredInstrumentID / serial no.RangeCalibration certificate no.Calibration due dateValid on test dateRemarks
1FlowElectromagnetic flowmeterFM-EX-0210 to 250 m³/hCAL-EX-22102027-09-30Y
2Suction pressurePressure transmitterPT-EX-061-1 to 3 bar gCAL-EX-22142027-08-12Y
3Discharge pressurePressure transmitterPT-EX-0620 to 16 bar gCAL-EX-22152027-08-12Y
4PowerPower analyser on the calibrated motorPA-EX-0070 to 75 kWCAL-EX-21982027-04-02NDue date passed before the test date. Raise an NCR and get the as-found results; the power and efficiency readings are in doubt until then.
5SpeedOptical tachometerTA-EX-0040 to 6000 r/minCAL-EX-22302027-11-05Y
6Water temperatureResistance thermometerTE-EX-0150 to 100 °CCAL-EX-22312027-11-05CheckCertificate names serial TE-EX-051. Confirm which is right.
Witness block fields, with the invented example values
FieldExample
Tested by (name, signature, date)Test engineer, 2027-04-14
Witnessed by, customer (name, signature, date)Customer's inspector, 2027-04-14
Witnessed by, third party (name, signature, date)Not required by the order
Reviewed by (name, signature, date)Quality engineer, 2027-04-15
Deviations or NCRsNone raised; rated point under query
AttachmentsPerformance curve PC-EX-9040A; NPSH test sheet; raw data log

The power analyser in the example was past its due date on the test day. To check the certificates themselves, use the calibration certificate checklist template.

Result values

ResultUse it when
PassThe measured values meet the guaranteed values within the tolerance the contract and its test standard allow.
QueryA measured value is on the wrong side of the guaranteed value and someone must compare it with the contract tolerance, or a reading is missing or doubtful.
FailA measured value is outside the contract tolerance. Raise a nonconformance.
InformationThe point is recorded for the curve only and carries no guarantee.

Columns and what to write

ColumnWhat to write
PointTest point number, in the order the points were taken.
DescriptionWhat the point is: shut-off, minimum flow, an intermediate point, the rated point, or the end of the curve. The test procedure sets how many points are taken and where.
Flow, measured (m³/h)Measured flow, converted to rated speed as the test procedure describes. Change the unit in the header if you use another.
Head, guaranteed or curve (m)The guaranteed head at the rated point. At other points, the value read from the proposal curve, which is not a guarantee unless the contract says so.
Head, measured (m)Measured total head at this flow, converted to rated speed.
Power, guaranteed or curve (kW)Guaranteed pump input power at the rated point, or the proposal curve value at other points.
Power, measured (kW)Measured pump input power, converted to rated speed and to the fluid density on the datasheet if the procedure requires it.
Efficiency, guaranteed or curve (%)Guaranteed efficiency at the rated point, or the proposal curve value at other points.
Efficiency, measured (%)Efficiency worked out from the measured flow, head and power.
NPSHR, guaranteed (m)Guaranteed NPSH required, where the datasheet gives one for this point. Leave blank where NPSH is not tested.
NPSHR, measured (m)NPSH required found by the NPSH test, where the order includes one. Leave blank otherwise.
ResultPass, Query, Fail or Information (drop-down). Fail rows turn red; Query rows amber. The tolerance comes from the contract and the test standard and grade it names.
RemarksWhat was compared, what is open and who decides.
Instrument sheet columns
ColumnWhat to write
ItemRunning number.
Quantity measuredWhat the instrument measured in the test, such as flow, suction pressure, discharge pressure, power, speed or temperature.
InstrumentThe type of instrument.
ID / serial no.The ID or serial number on the instrument itself.
RangeThe calibrated range, with units.
Calibration certificate no.The number of the calibration certificate.
Calibration due dateThe next calibration due date (YYYY-MM-DD).
Valid on test dateY, N or Check (drop-down). N rows turn red.
RemarksAnything open, and the action.

How to complete the record

  1. Before the test, fill in the header block from the datasheet and the test procedure: tag, serial number, rated point, the guaranteed values, the test fluid and the speed.
  2. Write the test standard and acceptance grade exactly as the contract names them. They set the tolerance; this record does not.
  3. On the Instruments and witness sheet, list every instrument with its ID, range, calibration certificate number and due date, and check each is valid on the test date.
  4. For each test point, enter the measured flow, head and power after conversion to rated speed, and the efficiency worked out from them.
  5. Beside each measured value, enter the guaranteed value at the rated point, or the proposal curve value at the other points. Enter NPSH values only where the order includes an NPSH test.
  6. Set the result. Use Information for points that carry no guarantee. Use Query where a value needs comparing with the contract tolerance, and say who decides.
  7. Have the tester and each witness sign the witness block, and list any deviation or NCR.
  8. Attach the plotted curve and the raw data, then file the record with the calibration certificates.

Getting ready for a witnessed pump test

Most trouble at a witnessed test is paperwork: a procedure the customer never approved, or a flowmeter whose certificate ran out last month. In OdysseyGPT's Inspection & Testing module, FAT Readiness Check (beta) reads the ITP, the test procedure and the customer's requirements and lists what is not yet in place for the test. Calibration Validity Check (beta) checks each instrument's certificate against the test date. Findings cite their source page, and your test engineer makes the call. Tools marked beta are open on request, and we onboard each team ourselves.

Want us to run the check for you?

Send your ITP and the customer's quality requirements. We send back what is covered, what is missing and what still needs evidence before the FAT.

Get the free ITP and FAT readiness check

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is a pump performance test?

A factory test in which the pump is run on a test bed at a series of flows while head, power and speed are measured. The results are plotted as a curve and compared with the values guaranteed on the datasheet.

What should a pump test report contain?

The pump's identity, the rated point and guarantees, the test fluid and speed, the readings at each test point, the instruments with their calibration details, the plotted curve and the signatures of the tester and any witness. Your contract may ask for more.

What tolerance applies to head, power and efficiency?

The one in your contract and in the test standard and acceptance grade it names. Tolerances differ between standards, grades and editions, so the template gives none. Check the governing standard or contract.

How many test points are needed?

The test procedure and the standard behind it set the number and where they fall along the curve. The example shows six as an illustration. Add or remove rows to match your procedure.

Is an NPSH test always part of the performance test?

No. It is a separate test that the order may or may not include. The NPSH columns are there for orders that do; leave them blank otherwise.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages