Link inspection readings to each unit and serial number

Many inspection sheets are tied to a batch, not a unit. The inspector writes five readings on a page and signs the bottom. Later nobody can say which reading belonged to which implant. Nobody. Even a careful team ends up with a pile of signed sheets that prove effort but cannot prove which implant was measured with which gauge on which shift.

That gap hurts the day a customer returns one unit. You can show the batch passed. You cannot show what was measured on that piece.

Fix it at the source. Etch or label the serial before the first check. Every reading then has something to hang on.

One row equals one reading on one unit. Keep the columns the same for every product so inspectors learn them once. A bone screw and a diagnostic probe housing can share the layout. Typical columns are listed below, and every one earns its place when a customer or an auditor asks about a single unit months after shipment.

Put the tolerance on the row, not in the inspector’s head. The result column should fill itself from the measured value, so nobody judges a borderline reading by eye.

Add a free-text remark for odd cases. A burr, a scratch or a reading taken twice all belong there.

A caliper, a micrometer, a pin gauge and a coordinate measuring machine all give a number. They do not give the same confidence. Record which one was used. The instrument ID deserves a column beside the number it produced.

When a gauge fails its calibration check, you need the list of units it measured since the last good check. That list is a simple filter if the instrument ID sits on every row. A calibration sticker on the gauge is not a record, because it cannot tell you which twenty units were measured under it last month.

Block entry when the calibration date has passed. The inspector should see a red warning. Audit is a bad place to find out.

When a reading falls outside tolerance, do not overwrite it. Keep the failed value, mark the unit as held and open a nonconformance linked to the serial. For a reworkable part, such as a bore that can be reamed again, record the rework as its own row with its own operator and gauge.

A retest becomes a new row, with the reason noted. The history then shows a fail, a check of the gauge and a pass. An auditor can follow that story. A single cleaned-up pass cannot be defended.

Decide who may release a held unit. Name the role on the template, such as the quality manager.

Choose one implant or one equipment model and run the template on paper for a week. Note which columns inspectors skip and which readings they repeat. A paper pilot is cheap, and it shows which fields inspectors resent before you build anything into a system.

Then move the same columns into a form or a spreadsheet with locked headers. Fix the layout before you add more products.

Next, pull the full record of one finished serial number and read it as a stranger would. If you can tell the story in a minute, the template works.