OdysseyGPT

Free template

Routine test report checklist for transformers and switchgear (Excel and CSV)

For test and quality engineers at electrical equipment manufacturers: fifteen checks to run on a routine test report before the customer sees it.

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

The short answer

A routine test report records the tests made on every unit before it leaves the factory. This free Excel checklist reviews a transformer or switchgear report before issue: serial number, tests against the ITP and the contract's list, each result beside its guaranteed value, instrument calibration, test conditions, witness signatures, deviations and approval.

Key Takeaways

  • Compare the report with two lists: the ITP and the contract's own test list. They are not always the same.
  • A measured value means little without the guaranteed or specified value written next to it.
  • The checklist never judges a tolerance. The contract and the standard it names do.
  • The example has 15 checks on an invented transformer order (PO-EX-6230), with two fails and six queries.

Download the routine test report checklist

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.

When to run it

Run the checklist after the test bay has finished and before the report is signed off for the customer. At that point a missing signature or an absent test costs an hour. Once the unit has shipped it costs a site visit. The checklist suits power and distribution transformers, switchgear panels and similar equipment that is tested unit by unit to a contract test list.

  • Test engineers, as a self-check before handing the report over.
  • Quality engineers, who approve the report and file it in the record book.
  • Project engineers, who know which extra tests the customer ordered on this contract.

Which tests count as routine, type or special depends on the equipment and on the standard the contract names, such as the IEC 60076 series for power transformers. Check the governing standard or contract. For background, see transformer testing and electrical equipment manufacturers.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Substation Extension (fictional)
CustomerExample Utility Ltd (fictional)
Purchase orderPO-EX-6230 (fictional)
EquipmentDistribution transformer, serial EX-TR-24017 (fictional)
Test standard named in the contractAs stated in the contract (for example IEC 60076-1 for a power transformer)
Routine test reportRTR-EX-6230 Rev 0
Test date(s)2027-03-09
ITP and contract test listITP-EX-6230 Rev B; technical schedule TS-EX-02 section 6
Checklist no.RTC-EX-6230
Date2027-03-11
Prepared byTest engineer
Checked byQuality engineer

Example checks: a distribution transformer report

Invented example checks for report RTR-EX-6230
ItemAreaCheckChecked againstWhat the report showsResultRemarks
1IdentificationThe report identifies the unit: type, rating and serial number, the same on every sheetPO-EX-6230 item 1; rating plate drawing RP-EX-6230 Rev ASerial EX-TR-24017 on sheets 1 to 8; rating as the plate drawingOK
2IdentificationThe report names the contract, the test standard with its edition, and the test procedurePO-EX-6230; test procedure TP-EX-TR-01 Rev AStandard named without edition or year (sheet 1)QueryAdd the edition the contract names.
3Test scopeEvery test in the ITP is reportedITP-EX-6230 Rev B, steps 14 to 21Eight tests in the ITP; eight reportedOK
4Test scopeEvery test in the contract's test list is reported, including any additional test the customer orderedTechnical schedule TS-EX-02 section 6Schedule lists nine tests; item 6.9 is not in the reportFailItem 6.9 was ordered as an additional test and is missing from the ITP too. Run it or agree a concession before the report is issued.
5ResultsEach result is recorded with its guaranteed or specified value alongside, in the same unitsSchedule of guarantees TS-EX-02 section 4 (invented contract figures)No-load loss: specified 1.10 kW, measured 1.07 kW. Load loss: specified 9.50 kW, measured 9.62 kW (sheet 4)QueryLoad loss is above the specified figure. Check the tolerance the contract and the standard it names allow before accepting or rejecting; the report does not state it.
6ResultsResults are stated at the reference conditions the guarantee uses, and the correction is shownTS-EX-02 section 4; TP-EX-TR-01Reference temperature stated; correction shown on sheet 4OK
7ResultsThe tap position and connection are recorded for each measurement that depends on themTP-EX-TR-01Recorded on sheets 2 to 5OK
8InstrumentsThe instrument ID or serial number is recorded for every testTP-EX-TR-01; calibration list CL-EX-6230IDs given for seven tests; none on sheet 7QueryAdd the instrument ID to sheet 7 from the test-bay log.
9InstrumentsEach instrument's calibration was valid on the test dateCalibration list CL-EX-6230Power analyser PA-EX-03: due 2027-03-01; test date 2027-03-09FailCalibration had run out. Raise an NCR; repeat the loss measurements or get the as-found results from recalibration.
10ConditionsAmbient and reference conditions are recorded where the test needs themTP-EX-TR-01Ambient and oil temperature recorded on each sheetOK
11WitnessWitnessed tests are signed by the witness, or a written waiver is attachedITP-EX-6230 steps 16 and 19 (customer witness)Customer's inspector signed sheets 1 to 6; sheets 7 and 8 unsignedQueryAsk the inspector to sign, or attach the waiver.
12DeviationsAgreed deviations, concessions and NCRs that affect a test are referenced on the reportAgreed deviation list TDL-EX-6230 Rev AItem 3 of the deviation list changes one test value; the report does not mention itQueryReference TDL-EX-6230 item 3 beside the result.
13DeviationsAny repeated test is recorded with the reason and the first resultQuality procedure QP-11No test was repeatedNot applicable
14ApprovalThe report carries a number, revision and date, and is signed by the people the procedure namesTP-EX-TR-01; QP-11RTR-EX-6230 Rev 0, dated 2027-03-09; prepared and checked, not approvedQueryApproval signature needed before issue.
15ApprovalPage count is complete and every attachment listed is attachedReport contents listEight sheets and two attachments, all presentOK

The loss figures in row 5 are an invented contract's specified values and invented measurements. They are not limits from any standard. The row is a query because the report shows a measured value above the specified one without saying what tolerance applies. 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.

Columns and what to write

ColumnWhat to write
ItemRunning number.
AreaIdentification, Test scope, Results, Instruments, Conditions, Witness, Deviations or Approval.
CheckWhat to confirm on the routine test report.
Checked againstThe document the report is compared with: the purchase order, the ITP, the contract's test list or schedule of guarantees, the rating plate drawing or the calibration list.
What the report showsWhat the test report says, with the sheet or page. For results, write the guaranteed or specified value and the measured value side by side, with units.
ResultOK, Query, Fail or Not applicable (drop-down). Fail rows turn red; Query rows amber.
RemarksWhat is wrong or missing, who acts and by when.

How to use the checklist

  1. Fill in the header block: the unit and its serial number, the test standard the contract names, the report number and revision, and the ITP and contract test list you will check against.
  2. Start with identification. The serial number and rating on the report must be the unit's own, on every sheet.
  3. Lay the report beside the ITP and the contract's test list. Every test in either must appear in the report. Which tests are routine, type or special for your equipment comes from the contract and the standard it names.
  4. For each result, write the guaranteed or specified value and the measured value side by side in the What the report shows column, with units. Where they differ, the tolerance comes from the contract and the standard; the checklist records the comparison and does not judge it.
  5. Check the instruments: an ID for every test, and a calibration that was valid on the test date.
  6. Check that ambient and reference conditions are recorded where the test needs them, and that witnessed tests are signed or waived in writing.
  7. Check that agreed deviations, concessions and NCRs are referenced beside the results they affect.
  8. Set the result for each row. Fail rows turn red and Query rows amber. Close each one before the report goes to the customer.

Having the test list and calibration dates read for you

Two of these checks are document comparisons that software can prepare. In OdysseyGPT's Inspection & Testing module, ITP Validator (beta) compares the tests in your ITP with the customer's quality requirements and lists the ones the plan leaves out. Calibration Validity Check (beta) reads the test report and the calibration certificates and flags an instrument whose certificate is missing or had expired on the test date. Each finding points to its source page. A test engineer still reads the results and decides. 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 routine test report?

It is the manufacturer's record of the tests carried out on each individual unit, as opposed to type tests made once on a representative unit. It lists each test, the measured result, the instruments used and who witnessed it.

Which tests should a transformer routine test report contain?

The tests the contract and the standard it names require for that transformer, plus any the customer added. The checklist does not list them, because they differ by equipment, rating and edition. Take the list from your ITP and the contract's technical schedule.

What if a measured value is worse than the guaranteed value?

Mark the row as a query and look up the tolerance in the contract and in the standard it names. Some contracts allow a tolerance, some apply a penalty and some reject. The checklist records the two values; it does not decide the outcome.

Can I use the checklist for switchgear?

Yes. The checks are about the report, not the physics: identification, test scope, results against specified values, instruments, witness, deviations and approval. Change the example rows to the tests your switchgear contract lists.

Does the customer have to witness routine tests?

Only if the contract or the agreed ITP says so. Where a test is a witness point and the customer did not attend, keep the written waiver or the notification record with the report.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages