Your intervals, not ours
- Count intervals come from your toolmaker, your customer or your own records. The file quotes no intervals or values from any standard or supplier and fills in none for you.
- This log works by counter reading. For date-based maintenance of tools your customer owns, with location and owner marking, see the customer-owned tooling register.
- After a repair, the log asks whether a first piece check was recorded. The check itself goes in your own first piece record, for example a first piece inspection log.
What is in the file
- Settings: an as-of date (blank means today).
- Log, one row per event: tool ID, tool or die description, line or machine, event type, event date, counter reading at the event, your count interval to the next maintenance, done or read by, released to production (Yes, No, Not yet), released by, first piece check recorded after (Yes or No), notes.
- Next due at count: counter reading plus your interval, on maintenance rows. Count left to due: on the latest maintenance row of each tool only, next due minus the highest counter reading logged for that tool. A reading equal to the next due count counts as reached. Count left is negative once the due count is passed.
- A separate check column. The status does not hide 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, latest maintenance rows at or past your interval, a line that should read 0 (rows not in any status), rows per event type and rows per release answer. No score and no ranking.
- The log does not restart the count after a counter reset. After a reset, use a new tool ID for the reset counter (for example T-01-B).
How the status is worked out
In this order; the first match wins. Text typed in a date or number cell counts as blank:
| Status | When |
|---|---|
| Enter tool ID | The row has an entry but no tool ID. It still counts. |
| Enter line or machine, Enter event type | In that order. Event type blank or typed outside the list (Counter reading, Planned maintenance, Sharpen or regrind, Repair, Inspection only, Other). |
| Enter event date, Enter counter reading, Enter done or read by | In that order. Text in the date or counter cell counts as blank. |
| Counter reading logged | Event type Counter reading, all of the above filled. |
| Logged, not a maintenance event | Event type Inspection only or Other. |
| Enter your count interval | Maintenance event (Planned maintenance, Sharpen or regrind, Repair) with no interval, or an interval that is not a number above 0. The interval is your own; the file fills in none. |
| Enter released to production | Blank, or typed outside the list (Yes, No, Not yet). |
| Not released yet, Held, not released | Released to production Not yet, or No. |
| Enter released by | Released Yes, name missing. |
| Earlier maintenance, a later one is logged | This tool has a maintenance row with a higher counter reading. |
| Count reached or past your interval | Latest maintenance of this tool: the highest counter reading logged for the tool on any row is at or past the next due count. |
| Within your count interval | Latest maintenance of this tool, highest counter reading still below the next due count. |
Check column notes, each followed by "worth a check", on any row whatever its status:
- Counter reading lower than on an earlier-dated row of this tool
- Counter reading or interval not a number above 0
- Date not readable (text in a date cell)
- Event date after the as-of date
- Same tool, event type and counter reading on more than one row
- Repair with no first piece check recorded after it
- Released by filled, released to production is not Yes
- Held, nothing written in Notes
- Interval entered on a row that is not a maintenance event
- Rows of one tool differ in line or machine
- Count reached or past your interval
Example (fictional)
Made-up tools, names, counts and dates, extract, as of Wednesday 21 October 2026 (Wed 21 Oct 2026):
| Tool ID | Event | Date | Counter | Your interval | Released | First piece check after | Count left | Status | Check |
|---|---|---|---|---|---|---|---|---|---|
| T-01 | Planned maintenance | Mon 5 Oct 2026 | 120000 | 50000 | Yes | Yes | Earlier maintenance, a later one is logged | ||
| T-01 | Counter reading | Mon 12 Oct 2026 | 145000 | Counter reading logged | |||||
| T-01 | Sharpen or regrind | Thu 15 Oct 2026 | 160000 | 40000 | Yes | Yes | 2000 | Within your count interval | |
| T-01 | Counter reading | Tue 20 Oct 2026 | 198000 | Counter reading logged | |||||
| T-02 | Repair | Fri 16 Oct 2026 | 80000 | 30000 | Yes | No | -2000 | Count reached or past your interval | Repair with no first piece check recorded after it: worth a check; Count reached or past your interval: worth a check |
| T-02 | Counter reading | Wed 21 Oct 2026 | 112000 | Counter reading logged | |||||
| T-03 | Repair | Tue 20 Oct 2026 | 5000 | 20000 | Not yet | 20000 | Not released yet | Repair with no first piece check recorded after it: worth a check | |
| T-04 | Inspection only | Wed 21 Oct 2026 | 3000 | Enter done or read by | |||||
| Counter reading | Wed 21 Oct 2026 | 190000 | Enter tool ID | ||||||
| T-01 | Counter reading | Wed 21 Oct 2026 | 150000 | Counter reading logged | Counter reading lower than on an earlier-dated row of this tool: worth a check |
Worth a check each week
- Tools at or past your count interval (red rows).
- Repairs with no first piece check recorded after them.
- Counter readings lower than an earlier one: a reset counter or a typing slip. The log does not restart the count after a counter reset. After a reset, use a new tool ID for the reset counter (for example T-01-B).
- Tools held or not released yet.
Whether a tool goes back into production is your call. The file records it and does not judge it.
Related
- Customer-owned tooling register
- Trial run and pilot lot log
- Gauge calibration log template
- Free 8D and quality tools
Advisory template, in English. Not a customer decision.