two bracket checks share one handwritten number

Ask the people who wrote them, if they are available; the numbering convention may be simpler than the mystery the archive has made of it.

And keep their recollection separate from an actual batch match.

Lucy, yes, fabrication restarted at one for each job; Aaron, both sheets name the same drawing revision, so that has not narrowed it, but the inspector is looking for the original inspection-book entries.

Same revision is useful. Still not the same bracket.

Does each released check identify its measured feature and datum, David, so that recovering the batch would actually give you a comparable result?

Emma Adams, we kept a note against each unmatched stores entry for that reason. A separate list helped us investigate, but the main sheet still needed to say why no result was linked.

Agree with Isaac. Whoever inherits the costing sheet needs to see the gap without opening a second file or finding David.

Emma Bell, both released checks use the same defined hole-position method; the inspection book now places them in different orders, so they are two brackets, not a failed-and-corrected pair.

Useful find. Does either order have its own correction entry, or has that part simply vanished from the copies you were given?

Isaac and Sofia, agreed. I meant a small investigation list, not a place to hide the uncertainty. The main sheet should say unmatched until the link is established

Amara, the failed bracket's order has a correction entry but no recovered final result; the passing bracket belongs to another order and never needed that correction, so I've removed the supposed before-and-after comparison.

That is worth retaining in the review. You found a false comparison, even though the first bracket's final disposition is still missing.

And the new sheet needs order plus bracket identity from fabrication onward. Then stores and inspection can preserve the link instead of trying to reconstruct it after everyone has moved on.