Digital Transformation

You Paid for Calibration Software. Why Does Your Uncertainty Still Live in Excel?

Many labs run uncertainty budgets and CMC corrections in spreadsheets outside their calibration software. Here's what that costs, and how to bring the math inside the record.


50,000 certificates a year can depend on one spreadsheet formula.

Your system of record isn’t where the math happens

A high-volume commercial lab told us they issue about 50,000 calibration certificates a year on a well-known calibration suite. On paper, they’re fully digital.

Their uncertainty budgets and CMC corrections tell a different story. All of them run in custom Excel files that sit outside the system, on a shared drive. Complex jobs, like CMM and vision-system calibrations, never become data at all. They get attached to the record as PDFs.

This is the most common pattern we saw in demos this year. In more than a dozen of them, the “system” a lab was replacing wasn’t another software product. It was a folder of spreadsheets holding the uncertainty math, the pass/fail logic and the certificate layouts.

Two systems that never agree

When the math lives outside the record, a lab ends up with two versions of the truth:

  • The software holds the certificate. It knows what was issued, to whom and when.

  • The spreadsheet holds the reasoning. It knows how every value was derived, but nobody else can see it.

That gap shows up at the worst moments.

During an assessment. An assessor asks how a reported uncertainty was calculated. Someone opens a file on a shared drive and hopes it’s the version that was used six months ago. Spreadsheets have no audit trail. They can’t show who changed a coefficient, or when.

When you need trends. Results locked inside PDFs can’t be queried. The lab can’t trend a single instrument across five years of calibrations, run SPC on a reference standard, or spot drift before it becomes a nonconformance.

When people change. The person who built the workbook goes on leave or moves on. The lab is left with a file that works, and that nobody fully understands.

What good looks like: the calculation lives inside the calibration record

The fix isn’t a better spreadsheet. It’s removing the gap between where the math runs and where the result is stored. In Metquay, the uncertainty budget is part of the worksheet itself:

  • Locked, versioned expressions. The uncertainty budget, the CMC lookup and the pass/fail rule are built into the worksheet as formulas. Technicians enter data. They can’t edit the math.

  • Structured data, not attachments. Raw machine data imports as CSV into structured fields, including for complex CMM and vision jobs, so every result can be trended and SPC-charted.

  • One source for the certificate. The certificate is generated from the same data the calculation used, so there’s nothing to reconcile.

  • A full history. Every procedure revision is versioned. When an assessor asks how a value was derived, the answer is one click away.

The flexibility your team likes in Excel stays. The fragility goes.

Start with one sheet

You don’t have to migrate everything to see the difference. Pick your most complex uncertainty spreadsheet and send it to us. We’ll show it running as a Metquay worksheet with the same inputs, the same results and a full audit trail.

See it on your own worksheet. Visit www.metquay.com or email consulting@metquay.com with one of your Excel uncertainty sheets. We’ll convert it and walk you through it live.

Ready to modernize your calibration lab?

A world where every measurement is trusted starts with one platform. See metquay.ai on your own data.

Ready to modernize your calibration lab?

A world where every measurement is trusted starts with one platform. See metquay.ai on your own data.

Ready to modernize your calibration lab?

A world where every measurement is trusted starts with one platform. See metquay.ai on your own data.

Ready to modernize your calibration lab?

A world where every measurement is trusted starts with one platform. See metquay.ai on your own data.