# Gage Master List Worksheet > Source: https://netray.co/tools/gage-master-list-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable inventory of every measuring device with identification, location, status and calibration interval. ## Category quality ## Audience - Quality manager - Metrology technician - Quality auditor ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Gage ID **Key:** id **Type:** text #### Description **Key:** desc **Type:** text #### Type **Key:** type **Type:** select **Options:** - Caliper - Micrometer - Pin gage - Height gage - Thread gage - Dial indicator - CMM - Torque wrench - Multimeter - Other #### Manufacturer **Key:** mfr **Type:** text #### Serial number **Key:** serial **Type:** text #### Range **Key:** range **Type:** text #### Resolution **Key:** res **Type:** text #### Location **Key:** loc **Type:** text #### Status **Key:** status **Type:** select **Options:** - Active - Out for calibration - Quarantined - Retired #### Interval (months) **Key:** interval **Type:** number #### Owner **Key:** owner **Type:** text **Rows:** **Id:** CAL-0012 **Desc:** Digital caliper **Type:** Caliper **Mfr:** Mitutoyo **Serial:** A1234567 **Range:** 0-150 mm **Res:** 0.01 mm **Loc:** Machining cell 2 **Status:** Active **Interval:** 12 **Owner:** Cell lead **Id:** MIC-0044 **Desc:** Outside micrometer **Type:** Micrometer **Mfr:** Starrett **Serial:** M88213 **Range:** 25-50 mm **Res:** 0.001 mm **Loc:** Inspection **Status:** Active **Interval:** 12 **Owner:** Quality **Id:** TQW-0007 **Desc:** Click torque wrench **Type:** Torque wrench **Mfr:** Generic **Serial:** T55102 **Range:** 10-50 Nm **Res:** 0.5 Nm **Loc:** Assembly **Status:** Out for calibration **Interval:** 6 **Owner:** Assembly lead **Id:** HGT-0003 **Desc:** Digital height gage **Type:** Height gage **Mfr:** Mahr **Serial:** H99341 **Range:** 0-300 mm **Res:** 0.01 mm **Loc:** Inspection **Status:** Active **Interval:** 12 **Owner:** Quality **Id:** DMM-0021 **Desc:** Bench multimeter **Type:** Multimeter **Mfr:** Generic **Serial:** D40716 **Range:** DC 1000 V **Res:** 6.5 digit **Loc:** Test lab **Status:** Quarantined **Interval:** 12 **Owner:** Test engineer **Totals:** #### Total gages **Key:** id **Agg:** count **Format:** integer #### Average interval (months) **Key:** interval **Agg:** avg **Format:** decimal #### Shortest interval (months) **Key:** interval **Agg:** min **Format:** integer **Notes:** Give every gage a unique ID that is physically marked on the device. Never reuse the ID of a retired gage. Keep the manufacturer and model detail in the description if you need it for the lab quote. ## Content **Intro:** Every calibration system starts with a list of what you have. A gage master list identifies each measuring device, where it lives, who owns it and how often it must be calibrated. This worksheet gives you a ready structure to fill and export. **Sections:** #### How to use it **Body:** Walk the plant and add a row for every device that affects product quality: hand tools, fixed gages, test equipment, torque tools and software-driven systems such as a CMM. Assign a unique ID, record the serial number, range and resolution, and set the status and calibration interval. Keep the owner column filled in so someone is responsible. Sort by location to plan collection rounds, and filter by status to find anything quarantined or out for calibration. #### What to include **Body:** Auditors check that the list is complete and that each item is traceable to calibration records. Beyond the basic columns, consider adding calibration source (internal or external lab), required accuracy, the characteristic it measures, and links to the calibration procedure. The list should also cover customer-owned and employee-owned equipment used for product acceptance, as well as reference standards that sit above the shop gages. **Bullets:** - Unique ID marked on the device - Serial, range and resolution - Location and owner - Status and interval - Link to calibration records #### Common mistakes **Body:** Lists go stale. Devices get moved, borrowed or forgotten in a drawer, and then show up at audit with an expired sticker. Run a periodic physical audit against the list, and treat any gage not on the list as quarantined until identified. Do not leave the interval blank, since a missing interval means a missing due date. Also avoid duplicate IDs; a single master ID should map to a single physical device or a clearly defined set such as a pin gage kit. **Cta:** If your gage list should live as equipment records in your ERP or CMMS, Netray can help plan the data model and migration. **Faq:** #### What equipment belongs on the master list? **Answer:** Any device used to accept product, verify a process or take a measurement that affects quality or safety. That includes hand tools, fixed gages, test equipment, torque tools and environmental monitors such as temperature loggers. #### Should retired gages be deleted? **Answer:** No. Mark them retired and keep the record so the history remains traceable, especially if product was accepted with them. Remove them from active due-date tracking instead. #### How do I handle gage sets such as pin kits? **Answer:** Either give each pin its own ID or treat the set as one asset with a single ID and a set-level record. Choose one approach and apply it consistently so that lost or damaged items can be traced. #### How often should I audit the list? **Answer:** A physical check against the list at least once a year is typical, with spot checks during internal audits. Any gage found on the floor without an ID or sticker should be pulled and identified. ## Search terms gage master list template, gauge list excel, measuring equipment list template, calibration equipment inventory, gage control list, master gage register, measuring and monitoring equipment list, gage ID tracking --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json