Quality Alert Log (Free Excel)

Alert, sort, log

The containment sorting instruction says how to sort the suspect stock. The alert is the sheet at the line that tells every shift what to look for. This log keeps all your alerts in one place, so none stays up past its date or comes down without a decision.

What is in the file

Settings: an as-of date (blank means today) and the review interval in days. The 7 days are our own default; change them.
Log: ref, issued on, part or product, defect to look for, line or station, what to check and how, valid until, last reviewed on, shifts to brief, shifts signed, suspect parts checked, found bad, closed on.
Next review fills in: last reviewed on (or issued on, if never reviewed) plus the interval. Days open runs from issued on to closed on or the as-of date.
A separate check column marks entries worth a second look: found bad more than checked, more shifts signed than to brief, shifts to brief blank, or not all shifts signed on an open alert, and closed before issued. A status never hides these notes; a row can show more than one.
Counts under the log: rows logged, rows per status, rows with a check note, open rows with shifts not all signed (whatever their status), and the totals of parts checked and found bad. No score and no ranking.

How the status is worked out

In this order; the first match wins:

Status	When
Enter issue date	Issued on is blank.
Closed	A closed-on date is entered.
Enter valid-until date	Valid until is blank.
Expired: close or extend	The as-of date is after valid until.
Set the review interval in Settings	The review interval in Settings is blank.
Review overdue	The as-of date is after the next review.
Enter shifts to brief	Shifts to brief is blank.
Shifts still to sign	Shifts signed is less than shifts to brief.
Open	None of the above.

To extend an alert, enter a new valid-until date and the date you reviewed it. The row keeps its ref and its days open.

Example (fictional)

Made-up parts and defects, extract, as of Thursday 22 October 2026, review interval 7 days. On Q-03 suspect parts checked is blank and found bad is 2, so the check column shows a note:

Ref	Defect to look for	Valid until	Next review	Shifts signed	Status	Days open	Check
Q-01	Burr on bore edge	Fri 16 Oct 2026		3 of 3	Expired: close or extend	17
Q-02	Weld spatter on face	Fri 30 Oct 2026	Mon 19 Oct 2026	3 of 3	Review overdue	10
Q-03	Scratch on top	Fri 6 Nov 2026	Tue 27 Oct 2026	2 of 3	Shifts still to sign	9	Found bad more than checked: worth a check; Not all shifts signed: worth a check
Q-04	Missing chamfer	Fri 6 Nov 2026	Wed 28 Oct 2026	3 of 3	Open	8
Q-05	Wrong colour	Fri 16 Oct 2026		2 of 2	Closed	8

Worth a check each week

Alerts past their valid-until date (marked in red): close them, or extend them with a review date.
Shifts still to sign: a shift that was not briefed may not know what to look for.
Rows in the check column, for example found bad more than checked: usually a typing slip, sometimes a count that needs a second look.

From the log to the 8D

The alert dates, shifts briefed and suspect parts found bad are the kind of evidence D3 asks for. See the D3 containment evidence checklist, and when the 8D is written, check your 8D report before you send it.

Your own procedure decides who issues and closes an alert. The log is an aid; it does not decide for you.

Advisory template, in English.