8D Gate

Calibration · Excel

Gauge out-of-tolerance log: free Excel

One row per gauge found out of tolerance: what was found, the lots measured with it since its last good calibration, the lots checked again, the product decision and when the review closed. The file shows reviews past due and gaps worth a check.

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

Get the free gauge out-of-tolerance 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.

The calibration log tracks due dates; this log picks up after a bad result

The gauge calibration log tells you when each gauge is due. When one comes back out of tolerance, the open question is the product measured with it since the last good calibration. This log keeps that review in one row: lots measured, lots checked again, impact, action, and the dates.

What is in the file

  • Settings: an as-of date (blank means today), and working days to close the impact review, used only on rows where review due by is blank (10 working days is our own default, not from a standard; set your own).
  • Log: OOT ref, gauge ID, gauge type, date found, as-found result, last good calibration on, lots measured since, lots checked, product impact (No impact, Impact), action on product, customer told on, review due by, review closed on, owner, 8D or NCR ref.
  • A separate check column. The status never hides it, 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 due (any status), a line that should read 0 (rows not in any status), lots measured, lots checked and lots still to check. No score and no ranking.

How the status is worked out

In this order; the first match wins:

StatusWhen
Enter OOT refThe row has an entry but no OOT ref. It still counts.
Enter gauge IDGauge ID is blank.
Enter date foundDate found is blank.
Review past dueReview closed on is blank, and the as-of date is after review due by.
Review openReview closed on is blank.
Closed, impact foundProduct impact is Impact.
Closed, no impactProduct impact is No impact.
Closed, impact not setProduct impact is blank.

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

  • Review past due, not closed
  • Last good calibration date blank
  • Last good calibration after date found
  • Lots checked more than lots measured
  • Closed with lots not all checked
  • Closed, product impact blank
  • Impact found, action blank
  • Impact found, 8D or NCR ref blank
  • Impact found, customer told date blank (ignore if not applicable)
  • Closed before the date found
  • Date found after the as-of date
  • Owner blank

So a row still waiting for its OOT ref shows in the check column when its review is past due.

The product decision is yours and, where it applies, your customer's; the file only records it. Your own procedure comes first.

Example (fictional)

Made-up gauges, extract, as of Thursday 22 October 2026, Settings 10 working days to close the review. Lots shown as measured since / checked:

OOT refGaugeDate foundLotsImpactReview closed onStatusCheck
O-01G-12 CaliperMon 5 Oct 202614 / 14No impactFri 16 Oct 2026Closed, no impact
O-02G-31 Bore gaugeTue 6 Oct 20268 / 8ImpactMon 19 Oct 2026Closed, impact found
O-03G-18 Height gaugeWed 7 Oct 202620 / 12Review past dueReview past due, not closed: worth a check
O-04G-22 Plug gaugeThu 15 Oct 20266 / 2Review open
O-05G-09 MicrometerFri 9 Oct 202610 / 7No impactTue 20 Oct 2026Closed, no impactClosed with lots not all checked: worth a check
O-06G-40 Thread gaugeMon 12 Oct 20265 / 5ImpactWed 21 Oct 2026Closed, impact foundImpact found, action blank: worth a check; Impact found, 8D or NCR ref blank: worth a check; Impact found, customer told date blank (ignore if not applicable): worth a check
G-07 CaliperTue 13 Oct 20263 / 3No impactThu 22 Oct 2026Enter OOT ref
O-08Dial indicatorWed 21 Oct 20264 / 0Enter gauge IDOwner blank: worth a check
O-09G-44 Torque wrenchFri 16 Oct 20269 / 3Review openLast good calibration after date found: worth a check

Worth a check each week

  • Reviews past due (marked in red), and any row whose check column says past due.
  • Closed rows with lots not all checked, or with product impact blank.
  • Impact rows with no action, no 8D or NCR ref, or no customer told date, if one applies.

When product is affected

Suspect lots still in house can go on the quarantine and hold log; for a sort, see the containment sorting instruction template.

Related

Advisory template, in English. Not a customer decision.