Routine test reports for panels and transformers from one record

The sheet should exist first. When a work order releases a panel or a transformer, the system opens a record carrying the serial number, rating, customer, order number and the applicable standard.

Testers select the unit from a list and never type a serial number, which removes the usual mismatch between nameplate, test certificate and dispatch note.

Route the record by product. Add the routine test list, the type test reference and any customer witness points, because a distribution transformer needs different tests from a motor control panel.

Readings arrive in different ways: some come off a megger dial, some from a test set that exports a CSV file, some in pencil on a form. Pick the simplest route for each test. Enter the value once.

For transformers the list means winding resistance, ratio, no-load loss, load loss, impedance and insulation resistance, while panels need insulation resistance, dielectric withstand, protective circuit continuity and wiring checks. Panels also get a mechanical operation check.

Record the tester, instrument and ambient temperature beside each set of readings, and for transformers add the top oil and winding temperature, because resistance readings shift with it.

The limits come from the standard, such as IEC 60076 for power transformers or IEC 61439 for low-voltage assemblies, or from the customer’s technical specification. Store them as rules on the product type, not as notes on a sheet, and let your engineers rather than the software decide which clause applies.

A reading outside its limit turns the field red at once, and the tester can retest, record a remark or raise a hold. Red means stop. A failed dielectric test found at dispatch costs a truck booking and a week of rework, so the bench is the cheapest place to find it.

Keep the limits with an effective date and the clause they came from, so an old report can be reproduced exactly as it was issued years later.

Customers want their layout: one wants a logo and a signature block, another wants a third-party witness column, and a state utility may ask for a fixed table order.

Build a template per customer and fill it from the stored record, so a changed layout lets every past report be reprinted without retyping. A corrected reading is logged with the name, date and reason of the person who changed it, so the report never hides an edit.

Attach the PDF to the serial number when the unit is dispatched, so the report is found by serial, not by hunting through folders.

Choose the product with the most repeat orders, build its test list, limits and two customer formats, and run it beside your current sheets for a month.

Compare the printed reports line by line against the old sheets, then retire the old template once the customer’s inspector confirms the new format reads cleanly. Fix the layout first. Only then add the second product line.