8D Gate

Launch · Excel

Error-proofing verification log: free Excel

One row per check of a poka-yoke or error-proofing device: station, device, device type, check method, who checked it and when, the result and your own next check due date. When a device did not work: parts made since the last good check, parts held, the reaction, the restore date and the recheck. Devices past your next check due date are flagged.

Free, no card. Enter your email to get the Excel file.

Get the free error-proofing verification log

We store your email to give you what you asked for. If you tick the box, we may also email you about new tools. We never sell your data. Privacy · To delete it, email 8dgate@agent.mailboxkit.com

Own structure and wording. Tested in LibreOffice. Advisory only.

Your check frequencies, not ours

  • How frequently each device is checked and the next check due date are your own. The file quotes no frequencies from any standard or customer and sets no default.
  • A logged check records what was seen on that date. It does not show that the device works at any other time.

What is in the file

  • Settings: an as-of date (blank means today).
  • Log: check ID, station, device, device type (Sensor, Fixture or locator, Vision, Counter, Other), check method (Master or test part, Function test, Other), checked on, checked by, result (Worked as expected, Did not work, Check not done), next check due, parts made since last good check, parts held, reaction, device restored on, rechecked after repair on, notes.
  • A separate check column. Neither the status nor the 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 log: rows logged, rows per status, rows with a check note, rows past the next check due date with no later check (any status), a line that should read 0 (rows not in any status), rows per device type and rows per result. No score and no ranking.

How the status is worked out

In this order; the first match wins. A row only reads Restored and rechecked or Next check not due yet when every step before it is filled. Text typed in a date cell counts as blank:

StatusWhen
Enter check IDThe row has an entry but no check ID. It still counts.
Enter station … Enter check methodStation, device, device type and check method (both from a list), in that order.
Enter checked-on date, Enter checked byDate (blank or text counts as blank), then the name.
Enter resultBlank, or typed outside the list (Worked as expected, Did not work, Check not done). The result is a dropdown.
Enter next check due dateBlank, or text instead of a date. The date is your own entry; the file sets no default.
Enter parts made since last good check, Enter parts heldResult Did not work, number blank or not 0 or more.
Enter reactionResult Did not work, reaction blank.
Device not restored yetResult Did not work, restored date blank or text.
Recheck after repair not doneResult Did not work, recheck date blank or text.
Later check loggedA check with a later date is logged for the same station and device.
Check not doneResult Check not done, no later check logged.
Next check past dueAs-of date after your next check due date, no later check logged.
Restored and recheckedResult Did not work, every step filled, next check not due yet.
Next check not due yetResult Worked as expected, next check due date not passed.

Check column notes, each followed by "worth a check", on any row whatever its status:

  • Next check due date passed, no later check for this device
  • Next check due date before the checked-on date
  • Device restored before the checked-on date
  • Recheck before the device was restored
  • Restored or recheck date filled, result is not Did not work
  • More parts held than parts made since last good check
  • Did not work, 0 parts held
  • Parts not a number (0 or more)
  • Check ID used on more than one row
  • Same station and device checked twice on one date
  • A checked, restored or recheck date after the as-of date
  • Date not readable (text in a date cell)
  • Check not done, nothing written in Notes
  • Parts filled, result is not Did not work

Example (fictional)

Made-up stations, names and dates, extract, as of Thursday 22 October 2026 (Thu 22 Oct 2026):

Check IDStationDeviceChecked onResultNext check dueStatusCheck
E-01Line 1Missing-clip sensorMon 19 Oct 2026Worked as expectedMon 26 Oct 2026Next check not due yet
E-02Line 1Missing-clip sensorMon 12 Oct 2026Worked as expectedMon 19 Oct 2026Later check logged
E-03Cell 2Hole presence pinWed 14 Oct 2026Did not workFri 30 Oct 2026Restored and rechecked
E-04Line 3Label cameraTue 20 Oct 2026Did not workTue 27 Oct 2026Device not restored yet
E-05Press 4Stroke counterMon 5 Oct 2026Worked as expectedMon 19 Oct 2026Next check past dueNext check due date passed, no later check for this device: worth a check
E-06Line 2Torque checkFri 16 Oct 2026Check not doneFri 23 Oct 2026Later check loggedCheck not done, nothing written in Notes: worth a check
E-07Cell 5Orientation pinWed 21 Oct 2026Worked as expectedTue 20 Oct 2026Next check past dueNext check due date passed, no later check for this device: worth a check; Next check due date before the checked-on date: worth a check
Line 3Part-present sensorThu 22 Oct 2026Worked as expectedThu 29 Oct 2026Enter check ID
E-09Press 4Die-height sensorTue 13 Oct 2026Did not workTue 27 Oct 2026Recheck after repair not doneMore parts held than parts made since last good check: worth a check
E-10Line 2Torque checkThu 22 Oct 2026Worked as expectedThu 29 Oct 2026Enter checked by

Worth a check each week

  • Devices past your next check due date with no later check logged, whatever the result (red while the status reads Next check past due).
  • Rows with Did not work but no restore or recheck date.
  • Rows where more parts are held than were made since the last good check, or none are held.

What counts as a good check and what to do with held parts is your call. The file records it and does not judge it.

Related

Advisory template, in English. Not a customer decision.