Why This Tool Exists
Most shops track calibration in a spreadsheet that gets updated once a year — right before an audit. By then, overdue tools have already been used on production work, which creates a nonconformance risk that is difficult to explain to a registrar. This tool replaces that spreadsheet with a live register that recalculates every status every time it opens. When you open the Calibration Manager, every tool's due date, days remaining, and Cal Status are computed against today's date. Nothing goes stale. Overdue tools are visible the moment they become overdue, not when someone remembers to check.
How It Works
Load / Upload Register
→
Review Status Bar
→
Filter & Identify Issues
→
Edit / Update Records
→
Save .xlsx
On load, the app reads your saved register from the browser or from an uploaded .xlsx file. The status bar at the top gives you an instant count of Overdue, Due Soon, Current, and No Date tools — click any pill to filter the register to that group. Use the sidebar filters and search box to drill into specific sites, employees, or providers. Edit any tool inline using the pencil icon. When you've finished updates, Save .xlsx creates a named backup file with a hidden _Backup sheet that restores your full register on next load.
What This Tool Does for You
- Eliminates stale data. Status recalculates against today's date every time the tool opens — no manual refresh needed.
- Surfaces overdue tools before the auditor does. Overdue count is the first number you see when the register loads.
- Keeps personal tools visible. Employee-owned tools used on production work are tracked alongside facility tools — no compliance blind spots.
- Produces audit-ready reports in one click. PDF and Excel exports include all required fields, sorted and formatted for registrar review.
- Supports bulk updates from your cal lab's data. Upload a new .xlsx from your calibration provider and the app matches by Sticker #, previews the proposed changes, and lets you commit them in one action.
- Preserves your data across sessions. Every change auto-saves to the browser. The .xlsx backup restores the full register on any computer.
Before You Start
- 📋 Your current calibration register — sticker numbers, tool names, cal dates, and frequencies for each controlled tool.
- 📄 Cal certificates for any tools whose records are not yet entered. You'll need the cal date, due date, provider name, and compliance standard from each certificate.
- 🏷️ A consistent Sticker # format decided in advance (e.g. CPL-01 for calipers, MIC-01 for micrometers). This prefix-number format is what makes bulk uploads reliable.
- 👤 Employee names for any personal tools being added. Personal tools require an assigned employee to be tracked correctly.
- 💾 A saved .xlsx from a previous session, if this is a returning use. Load it via the Upload / Update tab — the _Backup sheet restores the full register automatically.
What This Tool Produces
Live Calibration Register
Full register with real-time status — Overdue, Due Soon, Current, No Date — filterable by site, employee, provider, and status.
PDF Reports
Formatted PDF exports: full register, overdue tools, due-within-window, by-site summary, and current-view exports. Audit-ready layout with TQC branding and ISO 10012 header.
Excel (.xlsx) Backup
Named workbook with a hidden _Backup sheet containing the full register state. Restores completely on next load — recoverable on any computer.
Archive Record
Tools removed from active rotation are retained in a searchable archive with an archived date — available for recall or historical review.
Upload Change Preview
Before committing any bulk upload, the tool shows a change preview: records updated, new tools flagged, rows skipped. You approve before anything changes in the register.
Status Bar Dashboard
Instant summary of register health — total active tools, overdue count, due within 30/60/90 days, current, and no-date counts — visible on every tab.
Support
Questions? Contact The QMS Collective, LLC — clayton.kuehl [at] theqmscollective.com