Your review dates, not ours
- The review due date and what makes a sample still usable are your own. The file quotes no review intervals or sample counts from any standard or customer.
- Pieces in the set is your own number. The file sets no default.
What is in the file
- Settings: an as-of date (blank means today).
- Register: sample ID, part number, feature shown, sample type (Limit sample, Good sample, Defect sample, Other), location, made or received on, pieces in the set, signed off by, sign-off date, review due, last reviewed on, pieces found at review, review result (Still usable, Replace, Withdraw), withdrawn on, replaced by, notes.
- A separate check column. Neither the status nor the review result hides it, a filled date or number is checked for the cases listed below, and a row can show several notes, joined with a semicolon.
- Counts under the register: rows logged, rows per status, rows with a check note, rows past the review due date with no withdrawn date (any status), a line that should read 0 (rows not in any status), rows per sample type and rows per review result. No score and no ranking.
How the status is worked out
In this order; the first match wins. A row only reads Withdrawn or In use when every step before it is filled. Text typed in a date cell counts as blank:
| Status | When |
|---|---|
| Enter sample ID | The row has an entry but no sample ID. It still counts. |
| Enter part number … Enter location | Part number, feature shown, sample type (from the list) and location, in that order. |
| Enter made or received date | Blank, or text instead of a date. |
| Enter pieces in the set | Blank, or not a number above 0. |
| Enter signed off by, Enter sign-off date | Name, then the date (blank or text counts as blank). |
| Enter review due date | Blank, or text instead of a date. The date is your own entry; the file sets no default. |
| Enter review result | Last review date filled with no result, or a result typed outside the list (Still usable, Replace, Withdraw). The result is a dropdown. |
| Enter last review date | Result filled, review date blank or text. |
| Enter pieces found at review | Result filled, pieces found blank or not a number, 0 or more. |
| Withdrawal decided, not withdrawn yet | Result Replace or Withdraw, withdrawn date blank. |
| Enter replacement sample ID | Result Replace, withdrawn, replaced-by blank. |
| Withdrawn | Result Replace or Withdraw, withdrawn date filled (and a replacement ID for Replace). |
| Review past due | Not withdrawn, as-of date after your review due date. |
| In use | Not withdrawn, review due date not passed. |
Check column notes, each followed by "worth a check", on any row whatever its status:
- Review due date passed, no withdrawn date
- Sign-off date before the made or received date
- Last review before the sign-off date
- Withdrawn date filled, review result is not Replace or Withdraw
- Withdrawn before the last review date
- Replaced by filled, review result is not Replace
- Replaced by the same sample ID
- Replacement sample ID not found in the register
- Review due date before the sign-off date
- Review result filled, last review date blank
- Last review date filled, review result blank
- Signed off by and sign-off date: only one filled
- Sample ID used on more than one row
- A made, sign-off, review or withdrawn date after the as-of date
- Date not readable (text in a date cell)
- Fewer pieces found than in the set, result Still usable
- More pieces found than in the set
- Pieces not a number (set above 0, found 0 or more)
- Review result filled, pieces found blank
- Replace or Withdraw, nothing written in Notes
Example (fictional)
Made-up parts, names and dates, extract, as of Thursday 22 October 2026 (Thu 22 Oct 2026):
| Sample ID | Part number | Feature shown | Type | Sign-off date | Review due | Last reviewed | Result | Status | Check |
|---|---|---|---|---|---|---|---|---|---|
| B-01 | 4410-A | Flash on parting line | Limit sample | Wed 4 Mar 2026 | Fri 4 Dec 2026 | Mon 7 Sep 2026 | Still usable | In use | |
| B-02 | 7001-B | Paint run | Defect sample | Tue 6 Jan 2026 | Wed 14 Oct 2026 | Review past due | Review due date passed, no withdrawn date: worth a check | ||
| B-03 | 5100-C | Scratch on cover | Limit sample | Tue 2 Jun 2026 | Thu 1 Apr 2027 | Mon 5 Oct 2026 | Replace | Withdrawn | |
| B-04 | 5100-C | Scratch on cover | Limit sample | Wed 7 Oct 2026 | Wed 7 Apr 2027 | In use | |||
| B-05 | 2210 | Sink mark | Good sample | Tue 5 May 2026 | Fri 6 Nov 2026 | Mon 19 Oct 2026 | Withdraw | Withdrawal decided, not withdrawn yet | |
| B-06 | 3350 | Colour shade | Limit sample | Tue 3 Feb 2026 | Mon 1 Feb 2027 | Thu 15 Oct 2026 | Still usable | In use | Fewer pieces found than in the set, result Still usable: worth a check |
| B-07 | 5120 | Burr height | Defect sample | Mon 5 Oct 2026 | Mon 5 Apr 2027 | In use | Sign-off date before the made or received date: worth a check | ||
| 2290 | Weld spatter | Defect sample | Tue 13 Oct 2026 | Tue 13 Apr 2027 | Enter sample ID | ||||
| B-09 | 9001 | Colour shade | Limit sample | Tue 7 Apr 2026 | Wed 7 Oct 2026 | Wed 7 Oct 2026 | Replace | Enter replacement sample ID | |
| B-10 | 9010 | Print legibility | Good sample | Mon 15 Mar 2027 | Enter sign-off date | Signed off by and sign-off date: only one filled: worth a check |
Worth a check each week
- Samples past your review due date with no withdrawn date, whatever the result (red while the status reads Review past due).
- Rows with Replace or Withdraw but no withdrawn date or replacement ID.
- Sets where fewer pieces were found at review than are listed, with the result Still usable.
Whether a sample still shows the feature is your call. The file records it and does not judge it.
Related
Advisory template, in English. Not a customer decision.