Download the pump performance test record
XLSX
Pump performance test record (Excel)
Test record sheet with header block and 13 columns, a second sheet for instruments and the witness block, result drop-down, Fail rows in red and Query rows in amber, and a How to use sheet.
CSV
Pump performance test record (CSV)
The example rows as plain CSV (UTF-8), for Google Sheets or any other tool.
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
| Field | Example |
|---|---|
| Project | Example Cooling Water Upgrade (fictional) |
| Customer | Example Process Company Ltd (fictional) |
| Purchase order | PO-EX-9040 (fictional) |
| Pump tag | P-9040A |
| Pump serial no. | EX-P-55012 (fictional) |
| Pump type and size | Single-stage end-suction centrifugal pump (fictional) |
| Datasheet | DS-EX-P-9040 Rev C |
| Test procedure | TP-EX-P-01 Rev B |
| Test standard and acceptance grade | As named in the contract |
| Rated point (from the datasheet) | 120 m³/h at 85 m, 2950 r/min (invented order) |
| Guaranteed at the rated point | Head 85.0 m; power 37.6 kW; efficiency 74.0 %; NPSHR 3.2 m (invented order) |
| Test fluid | Clean cold water, 18 °C |
| Test speed | 2962 r/min measured; results converted to 2950 r/min as TP-EX-P-01 describes |
| Driver used for the test | Calibrated test-bed motor |
| Test date | 2027-04-14 |
| Record no. | PTR-EX-9040A Rev 0 |
Example test points: a single-stage centrifugal pump
| Point | Description | Flow (m³/h) | Head (m): guaranteed or curve / measured | Power (kW): guaranteed or curve / measured | Efficiency (%): guaranteed or curve / measured | NPSHR (m): guaranteed / measured | Result | Remarks |
|---|---|---|---|---|---|---|---|---|
| 1 | Shut-off (closed valve) | 0 | 101.0 / 102.4 | 17.0 / 17.3 | - / - | - / - | Information | Curve value only; no guarantee at this point in the invented order. |
| 2 | Minimum continuous flow | 36 | 99.0 / 99.6 | 23.5 / 23.9 | 41.3 / 40.9 | - / - | Information | |
| 3 | Intermediate | 84 | 94.0 / 94.8 | 31.6 / 31.9 | 68.1 / 68.0 | - / - | Information | |
| 4 | Rated point | 120 | 85.0 / 85.9 | 37.6 / 38.4 | 74.0 / 73.1 | 3.2 / 3.0 | Query | Head 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. |
| 5 | Above rated flow | 132 | 80.0 / 80.7 | 39.2 / 39.9 | 73.4 / 72.8 | - / - | Information | |
| 6 | End of curve | 144 | 73.5 / 74.0 | 40.6 / 41.2 | 71.0 / 70.5 | - / - | Information | Compare 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
| Item | Quantity measured | Instrument | ID / serial no. | Range | Calibration certificate no. | Calibration due date | Valid on test date | Remarks |
|---|---|---|---|---|---|---|---|---|
| 1 | Flow | Electromagnetic flowmeter | FM-EX-021 | 0 to 250 m³/h | CAL-EX-2210 | 2027-09-30 | Y | |
| 2 | Suction pressure | Pressure transmitter | PT-EX-061 | -1 to 3 bar g | CAL-EX-2214 | 2027-08-12 | Y | |
| 3 | Discharge pressure | Pressure transmitter | PT-EX-062 | 0 to 16 bar g | CAL-EX-2215 | 2027-08-12 | Y | |
| 4 | Power | Power analyser on the calibrated motor | PA-EX-007 | 0 to 75 kW | CAL-EX-2198 | 2027-04-02 | N | Due 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. |
| 5 | Speed | Optical tachometer | TA-EX-004 | 0 to 6000 r/min | CAL-EX-2230 | 2027-11-05 | Y | |
| 6 | Water temperature | Resistance thermometer | TE-EX-015 | 0 to 100 °C | CAL-EX-2231 | 2027-11-05 | Check | Certificate names serial TE-EX-051. Confirm which is right. |
| Field | Example |
|---|---|
| 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 NCRs | None raised; rated point under query |
| Attachments | Performance 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
| Result | Use it when |
|---|---|
| Pass | The measured values meet the guaranteed values within the tolerance the contract and its test standard allow. |
| Query | A 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. |
| Fail | A measured value is outside the contract tolerance. Raise a nonconformance. |
| Information | The point is recorded for the curve only and carries no guarantee. |
Columns and what to write
| Column | What to write |
|---|---|
| Point | Test point number, in the order the points were taken. |
| Description | What 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. |
| Result | Pass, 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. |
| Remarks | What was compared, what is open and who decides. |
| Column | What to write |
|---|---|
| Item | Running number. |
| Quantity measured | What the instrument measured in the test, such as flow, suction pressure, discharge pressure, power, speed or temperature. |
| Instrument | The type of instrument. |
| ID / serial no. | The ID or serial number on the instrument itself. |
| Range | The calibrated range, with units. |
| Calibration certificate no. | The number of the calibration certificate. |
| Calibration due date | The next calibration due date (YYYY-MM-DD). |
| Valid on test date | Y, N or Check (drop-down). N rows turn red. |
| Remarks | Anything open, and the action. |
How to complete the record
- 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.
- Write the test standard and acceptance grade exactly as the contract names them. They set the tolerance; this record does not.
- 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.
- For each test point, enter the measured flow, head and power after conversion to rated speed, and the efficiency worked out from them.
- 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.
- 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.
- Have the tester and each witness sign the witness block, and list any deviation or NCR.
- 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.
