Calibration Uncertainty Calculator for Excel – Version 4.1

What the Calibration Uncertainty Calculator does

The Calibration Uncertainty Calculator is a Microsoft Excel workbook that calculates the expanded uncertainty (U) to report with each result on a calibration certificate. It combines the CMC uncertainty from your scope of accreditation with the contributions of the unit under test (UUT), which are resolution and repeatability, as Global ACI TECH-1-009 (formerly ILAC P14) requires. It reports U at about 95 % coverage, with the coverage factor k, for every test point.

 

What’s new in version 4.1

• Clear messages, not wrong answers. U shows “Enter n”, “Enter d” or “Select β1 unit” when an input is missing, instead of quietly reporting an uncertainty that is too low.
• Never smaller than your CMC. U is rounded conventionally to two significant digits and rounded up only when rounding would put it below the CMC (TECH-1-009 5.3 and 5.5).
• Correct degrees of freedom. Effective degrees of freedom follow the Welch–Satterthwaite formula, rounded down per GUM G.4.1, with resolution-based terms treated as infinite.
• Repeatability tied to your measurement. The standard deviation of the mean uses the readings in this calibration (ν = n − 1). A single reading falls back to resolution per GUM F.2.2.1.
• Clean two-digit display. U keeps its trailing zeros at any size, from 0.10 to 8.4E-07.
• 1,000 ready rows. Blank rows stay blank, so there’s nothing to copy or fix.
• Divisors shown. A row under the headers shows each contributor’s distribution and divisor, so reviewers and assessors can follow the math.
• One Instructions sheet. Step-by-step entry, a column legend, message fixes and method notes with references, all in one place.
• Validation sheet. 18 test cases with independently calculated expected results show PASS when the formulas work.
• Input checks. Dropdowns and validation catch wrong entries, and formula cells are protected (no password).

 

How it calculates calibration uncertainty

The calculator combines three contributors by root sum of squares (GUM 5.1.2):

Contributor	Source	Distribution	Divisor
CMC uncertainty	β1·|y| + β0 from your scope	Normal	2
UUT resolution	d / 2 (half-width)	Rectangular	√3
UUT repeatability	Standard deviation of your n readings	Normal	√n

Then it:

1. Calculates effective degrees of freedom with the Welch–Satterthwaite formula (GUM G.4).
2. Selects k from the Student t-table when ν_eff ≤ 10, otherwise uses k = 2 (GUM G.6.6).
3. Multiplies k by the combined standard uncertainty and rounds U to two significant digits.

 

How to use it

1. Choose the Analog sheet (scales, dials or any display that does not count by 1) or the Digital sheet (digital displays).
2. Enter the test point, unit and UUT resolution.
3. Enter the CMC gain and offset from your scope of accreditation, and select the gain unit (%, µUnit/Unit or Unit/Unit).
4. Enter the number of readings averaged (n) and their standard deviation (ur), if you took more than one.
5. Read the expanded uncertainty in column R and copy it to your certificate.

 

Who it’s for

• Calibration labs accredited to ISO/IEC 17025:2017, or preparing for accreditation
• Quality managers who review calibration certificates before release
• Metrologists and technicians who need certificate uncertainties without building a budget for every job
• Assessors and trainers who want a transparent worked example of TECH-1-009

 

What’s included

• Calibration Uncertainty Calculator v4.1 (.xlsx) with Analog, Digital, Instructions, Validation and log sheets
• Viewable, editable formulas with every reference cited
• 1 year of free updates

 

Requirements

• Microsoft Excel 2010 or later for Windows or Mac (Microsoft 365 recommended)
• Also works in LibreOffice Calc
• Not supported in Google Sheets: Sheets can’t apply the number formats that keep U’s trailing zeros

 

Built by a calibration lab manager

Rick Hogan built and maintains this calculator. He managed an A2LA-accredited calibration lab for 14 years, served 6 years in US Navy metrology, and serves on A2LA’s Measurement Advisory Committee. Through ISOBudgets, he has helped hundreds of accredited labs calculate measurement uncertainty since 2011.

 

Frequently asked questions

How do I calculate calibration uncertainty for a calibration certificate?

Combine the CMC uncertainty from your scope of accreditation with the UUT’s resolution and repeatability by root sum of squares, then multiply by a coverage factor for about 95 % coverage. TECH-1-009 (formerly ILAC P14) requires these UUT contributions on the certificate. The calculator does every step for up to 1,000 results.

Does the calculator meet ILAC P14 and TECH-1-009?

Yes. Global ACI TECH-1-009 carries over ILAC P14’s clauses, and the calculator follows them: it includes the UUT contributions, reports U with k at about 95 % coverage, rounds to two significant digits (5.3) and never reports less than the CMC (5.5).

Can the uncertainty on a certificate be smaller than my CMC?

No. TECH-1-009 5.5 says accredited labs shall not report a smaller uncertainty than the CMC. The calculator rounds U conventionally and rounds up only when rounding would put it below the CMC.

What does the calculator use for repeatability when all readings agree?

It uses the UUT resolution, d/√12, per JCGM 100:2008 F.2.2.1. It does the same when ur/√n is smaller than d/√12 or when only one reading is taken.

Can I enter a standard deviation from my R&R study for single readings?

No. Repeatability must come from the readings in the calibration you are reporting, with ν = n − 1: a single reading has n = 1, and the mean of 5 readings has n = 5 and ν = 4. Your R&R variability is already in the CMC, so reusing it would count it twice.

What is the difference between the Analog and Digital sheets?

On the Analog sheet, you enter resolution as the increment you read to, such as 0.5 psi. On the Digital sheet, you enter the number of digits to the right of the decimal, such as 2 for 12.34. Use the Analog sheet for any display that counts by 2 or 5.

Which versions of Excel does it work in?

It works in Microsoft Excel 2010 or later on Windows and Mac, and in LibreOffice Calc. It is not supported in Google Sheets.

Can I see and change the formulas?

Yes. Every formula is visible, and the Instructions sheet cites the reference for each calculation. Formula cells are protected without a password to prevent accidental changes; choose Review > Unprotect Sheet to edit them.

How do I know the calculator is accurate?

The Validation sheet runs 18 test cases with independently calculated expected results and shows PASS for each. It covers normal results, low degrees of freedom, the CMC floor, small values and every input error message. You can keep it as software validation evidence for ISO/IEC 17025:2017 7.11.2.

Get the Calibration Uncertainty Calculator and report certificate uncertainties that hold up to assessment.