How is the next due date calculated?

Next due is the latest calibration date on Calibration Records plus the gauge's interval in calendar days. A caliper calibrated on 2 April 2026 with a 180-day interval is due on 29 September 2026; with a status date of 9 October 2026 it reads Overdue and Days to due shows -10. An in-service gauge with no record at all also reads Overdue, and its Check column says No calibration record.

How is on-time calibration measured?

It is the share of calibrations that fell due between the Dashboard's From and To dates and were done on or before the due date. Gauges that fell due in that window and are still overdue count in the denominator too, so an ignored recall lowers the figure. With 240 on time out of 250 due the figure is 96.0 percent, the same answer as the Calibration Schedule Adherence calculator.

What should I do when a gauge is found out of tolerance?

Record the as-found result before adjusting, then decide whether product measured since the last good calibration is affected: ISO 9001 clause 7.1.5.2 asks for that assessment. Log the review as Open until it is done, then Closed. The Check column flags an out-of-tolerance record with no review entry, and the Dashboard counts open reviews.

Does the template set calibration intervals for me?

No. Intervals are yours, typed per gauge from your procedure, the maker's advice and the gauge's history. The workbook gives you the evidence for changing them: the out-of-tolerance finds per gauge on the register and the rate by gauge type on the Dashboard. ILAC-G24 describes methods for adjusting intervals; a type found out of tolerance in 3 of 12 calibrations is a candidate for a shorter interval.

Can I track gauges calibrated by outside labs?

Yes. List each provider on Setup as Internal or External, pick it on every record and type the certificate number and cost. The Dashboard sums calibration cost for the period in the currency label you set; no exchange rate is applied.

Quality Systems and Compliance

Gauge Calibration Log Excel Template

Keep every gauge's interval, next due date and calibration history in one workbook, and see what is overdue, what falls due in the next 12 months and which gauge types are found out of tolerance.

Overview

This gauge calibration log is a working Excel workbook for quality engineers, calibration technicians and quality managers who control measuring equipment. It ships with example data for a fictional machine shop with 24 gauges and about 21 months of calibration records, so the register, due dates and dashboard are populated the moment you open it; replace the example rows with your own and everything recalculates.

The Gauge Register holds one row per gauge with its calibration interval. The Calibration Records sheet holds one row per calibration with the as-found result (before adjustment), the as-left result, the action taken and the impact review an out-of-tolerance find needs. The register takes each gauge's latest record, adds the interval to get the next due date and compares it with the status date on Setup: Overdue, Due soon or OK. Each record also finds the gauge's previous calibration, so the date it was due and whether it was done on time are calculated, not typed.

In practice, update the records as certificates come back, move the status date forward and read the Dashboard in your weekly quality meeting. The first tile and the recall chart show what must be called in now and what the lab faces over the next 12 months; the on-time tile measures recall discipline; the out-of-tolerance rate by gauge type shows which gauges drift, which is the evidence you need to shorten an interval, lengthen one or change how a gauge is handled.

What this template includes

Gauge Register table: gauge ID, description, type, location, range or size, calibration interval and service status, one row per gauge
Last calibration, next due date, days to due and a due status in words (Overdue, Due soon, OK) calculated against a status date you set, so the file never changes by itself
Calibration Records table with as-found and as-left results, action taken, impact review, certificate number and cost; each record finds the gauge's previous calibration and works out its own due date and whether it was on time
Check columns that name problems in words: duplicate gauge IDs, gauges with no calibration record, records for a gauge not on the register, out-of-tolerance finds with no impact review
Dashboard with KPI tiles for gauges overdue, due soon, on-time calibration and the as-found out-of-tolerance rate against your own targets
Two native charts: recalls falling due in each of the next 12 months, and the out-of-tolerance rate by gauge type against your limit
Next-12-months, by gauge type and calibrations-by-month summary tables, with calibration cost in your currency
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference (Self-check: PASS)

Suggested use case

Use it to run gauge recall in a machine shop or small plant, to prepare for an ISO 9001, IATF 16949, AS9100 or ISO 13485 audit of measuring equipment, or to see whether calibration intervals and handling need a review.

How to use it

On Setup, set the status date, the due-soon window and your on-time and out-of-tolerance targets, then replace the example gauge types, locations and calibration providers.
On Gauge Register, list every gauge once with its interval in days and whether it is in service.
On Calibration Records, add a row for every calibration with its date, provider, as-found and as-left result, impact review, certificate number and cost.
Fix anything the Check columns flag, move the status date forward, and read the Dashboard.
Set the Dashboard's From and To dates to review a quarter or a year; filter the register's Due status column to print the recall list.

Frequently Asked Questions

How is the next due date calculated?: Next due is the latest calibration date on Calibration Records plus the gauge's interval in calendar days. A caliper calibrated on 2 April 2026 with a 180-day interval is due on 29 September 2026; with a status date of 9 October 2026 it reads Overdue and Days to due shows -10. An in-service gauge with no record at all also reads Overdue, and its Check column says No calibration record.
How is on-time calibration measured?: It is the share of calibrations that fell due between the Dashboard's From and To dates and were done on or before the due date. Gauges that fell due in that window and are still overdue count in the denominator too, so an ignored recall lowers the figure. With 240 on time out of 250 due the figure is 96.0 percent, the same answer as the Calibration Schedule Adherence calculator.
What should I do when a gauge is found out of tolerance?: Record the as-found result before adjusting, then decide whether product measured since the last good calibration is affected: ISO 9001 clause 7.1.5.2 asks for that assessment. Log the review as Open until it is done, then Closed. The Check column flags an out-of-tolerance record with no review entry, and the Dashboard counts open reviews.
Does the template set calibration intervals for me?: No. Intervals are yours, typed per gauge from your procedure, the maker's advice and the gauge's history. The workbook gives you the evidence for changing them: the out-of-tolerance finds per gauge on the register and the rate by gauge type on the Dashboard. ILAC-G24 describes methods for adjusting intervals; a type found out of tolerance in 3 of 12 calibrations is a candidate for a shorter interval.
Can I track gauges calibrated by outside labs?: Yes. List each provider on Setup as Internal or External, pick it on every record and type the certificate number and cost. The Dashboard sums calibration cost for the period in the currency label you set; no exchange rate is applied.