494449126.

xlsx

Function: Pressure Measure

LOW POINT
Test-Point 10
Unit psig

Uncertainty Analysis: CMC (Calibration and Measurement Capability)

Uncertainty Components Sensitivity Value Unit Type Distribution Divisor Std Uncertainty Degrees of Significance Check
Coefficient Freedom
(ci) (xi) u(xi) υ
1 Repeatability 1 0.000587 psig A Normal 1s 1.000 0.000587 19 3.0%
2 Reproducibility 1 0.001613 psig A Normal 1s 1.000 0.001613 1 22.4%
3 Stability 1 0.001483 psig B Normal 1s 1.000 0.001483 99 19.0%
4 Bias 1 0.001000 psig B Normal 1s 1.000 0.001000 1 8.6%
5 Drift 1 0.002007 psig B Normal 1s 1.000 0.002007 2 34.7%
6 Resolution 1 0.001000 psig B Rectangular √3 1.732 0.000577 1E+100 2.9%
7 Reference Standard Uncertainty 1 0.002100 psig B Normal 2s 2.000 0.001050 99 9.5%
8 Reference Standard Stability 1 0.000000 psig B Normal 1s 1.000 0.000000 2 0.0%
9 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
10 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
11 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
12 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
13 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
14 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
15 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
16 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
17 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
18 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
19 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
20 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
uc(y) υeff Σ
Combined Uncertainty (RSS method) 0.0034 8.5 100.0%
Expansion Coefficienct (k) k=2 2.000
Expanded Uncertainty [ kuc(y) ] 0.0068 psig

HIGH POINT
Test-Point 100
Unit psig

Uncertainty Analysis: CMC (Calibration and Measurement Capability)

Uncertainty Components Sensitivity Value Unit Type Distribution Divisor Std Uncertainty Degrees of Significance Check
Coefficient Freedom
(ci) (xi) u(xi) υ
1 Repeatability 1 0.005147 psig A Normal 1s 1.000 0.005147 19 9.3%
2 Reproducibility 1 0.015442 psig A Normal 1s 1.000 0.015442 1 83.5%
3 Stability 1 0.002608 psig B Normal 1s 1.000 0.002608 99 2.4%
4 Bias 1 -0.001000 psig B Normal 1s 1.000 -0.001000 1 0.4%
5 Drift 1 0.003033 psig B Normal 1s 1.000 0.003033 2 3.2%
6 Resolution 1 0.001000 psig B Rectangular √3 1.732 0.000577 1E+100 0.1%
7 Reference Standard Uncertainty 1 0.003700 psig B Normal 2s 2.000 0.001850 99 1.2%
8 Reference Standard Stability 1 0.000000 psig B Normal 1s 1.000 0.000000 2 0.0%
9 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
10 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
11 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
12 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
13 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
14 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
15 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
16 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
17 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
18 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
19 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
20 1 0.000000 psig B Rectangular √3 1.732 0.000000 1E+100 0.0%
uc(y) υeff Σ
Combined Uncertainty (RSS method) 0.0169 1.4 100.0%
Expansion Coefficienct (k) k=2 2.000
Expanded Uncertainty [ kuc(y) ] 0.034 psig

Updated: 10/11/2020 Page 1 of 9

NOTES
1 Enter uncertainty component notes here.
2 Enter uncertainty component notes here.
3 Enter uncertainty component notes here.
4 Enter uncertainty component notes here.
5 Enter uncertainty component notes here.
6 Enter uncertainty component notes here.
7 Enter uncertainty component notes here.
8 Enter uncertainty component notes here.
9 Enter uncertainty component notes here.
10 Enter uncertainty component notes here.
11 Enter uncertainty component notes here.
12 Enter uncertainty component notes here.
13 Enter uncertainty component notes here.
14 Enter uncertainty component notes here.
15 Enter uncertainty component notes here.
16 Enter uncertainty component notes here.
17 Enter uncertainty component notes here.
18 Enter uncertainty component notes here.
19 Enter uncertainty component notes here.
20 Enter uncertainty component notes here.

Updated: 10/11/2020 Page 2 of 9

INTERPOLATION COEFFICIENTS
X Unit Y Unit Gain Coefficient B1
Low 10 psig 0.00680 psig Offset Coefficient B0
High 100 psig 0.03400 psig
δ 90 psig 0.0272 psig
𝑈_𝐶𝑀𝐶=𝛽_1 𝑥_𝑖+𝛽_0

VERIFICATION
# X Unit Y Unit 1
1 1 psig 0.0041 psig 2
2 2 psig 0.0044 psig 3
3 3 psig 0.0047 psig 4
4 4 psig 0.0050 psig
5 5 psig 0.0053 psig
6 6 psig 0.0056 psig
7 7 psig 0.0059 psig
8 8 psig 0.0062 psig 5
9 9 psig 0.0065 psig
10 10 psig 0.0068 psig
 GAIN COEFFICIENT (B1) OPTIONS
0.000300 Percent 0.03 %
0.0038 psig PPM 300 ppm

1 𝑥_𝑖+𝛽_0

INSTRUCTIONS
Enter the Low test-point value in cell B5.
Enter the Low test-point unit of measurement in cell C5.
Enter the High test-point value in cell B6.
Determine your CMC Uncertainty equation:
a If B1 is zero and B0 is not, your CMC Uncertainty is B0
b If B1 is not zero and B0 is zero, you CMC Uncertainty is B1
c If B1 is not zero and B0 is not zero, your CMC Uncertainty is B1 + B0
d If you do not want to use a CMC Uncertainty equation, select the largest uncertainty value for the m
For verification, enter your desired test-points (including the test-points from your analysis) in cells B13 throug
ncertainty value for the measurement range.
alysis) in cells B13 through B22.
Name of Measurement Function or Test
Description of Measurement Equipment or Method
Range: [Value & Unit] to [Value & Unit]
Test Point: [Value & Unit]

Uncertainty Analysis: CMC (Calibration and Measurement Capability)

Uncertainty Components Sensitivity Value Unit Type Distribution Divisor Std Uncertainty Degrees of Significance Check
Coefficient Freedom
(ci) (xi) u(xi) υ
1 Repeatability 1 0.000102 kPa A Normal 1 1.000 0.000102 19 0.0%
2 Reproducibility 1 0.000174 kPa A Normal 1 1.000 0.000174 3 0.1%
3 Stability 1 0.005000 kPa B Normal 1 1.000 0.005000 99 98.8%
4 Bias 1 -0.000500 kPa B Normal 1 1.000 -0.000500 1 1.0%
5 Drift 1 0.000000 kPa B Normal 1 1.000 0.000000 2 0.0%
6 Resolution 1 0.000010 kPa B Rectangular √3 1.732 0.000006 1E+100 0.0%
7 Reference Standard Uncertainty 1 0.000061 kPa B Normal 2 2.000 0.000031 99 0.0%
8 Reference Standard Stability 1 0.000000 kPa B Normal 1 1.000 0.000000 2 0.0%
9 Other Factor 1 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
10 Other Factor 2 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
11 Other Factor 3 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
12 Other Factor 4 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
13 Other Factor 5 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
14 Other Factor 6 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
15 Other Factor 7 1 0.000000 kPa B Rectangular √3 1.732 0.000000 1E+100 0.0%
uc(y) υeff
Combined Uncertainty (RSS method) 0.0050 100.3 100.0%
Expansion Coefficienct (k) 1.984
Expanded Uncertainty [ kuc(y) ] 0.010 kPa

NOTES
1 Uncertainty component notes
2 Uncertainty component notes
3 Uncertainty component notes
4 Uncertainty component notes
5 Uncertainty component notes
6 Uncertainty component notes
7 Uncertainty component notes
8 Uncertainty component notes
9 Uncertainty component notes
10 Uncertainty component notes
11 Uncertainty component notes
12 Uncertainty component notes
13 Uncertainty component notes
14 Uncertainty component notes
15 Uncertainty component notes

LEGEND
Type to enter description of the measurement function, measurement method or equipment, measurement range, and test point
Type to enter uncertainty component name
Type to enter value of sensitivity coefficient
Type to enter value of uncertainty component
Type to enter unit of measure
Type to enter uncertainty type: A or B
Use dropdown menu to select probability distribution
Type to enter value of degrees of freedom
Type to enter notes about uncertainty component
Date
2/28/2018

2/27/2019

3/22/2019

3/27/2019

12/9/2019
Updates
Added error handling to: standard uncertainty, significance check, and weighted variance.
Added dropdown lists for Uncertainty type and probability distribution.
Increased the calculator to handle 20 sources of uncertainty
Added error handling to: combined uncertainty, expansion factor, expanded uncertainty, and effective degree
Updated Normal distributions to include the letter "s" for sigma.
Added Normal 3s distribution for 3-sigma or 99% confidence intervals.
Updated Notes text to: "Enter uncertainty component notes here."
Updated Measurement function, desctiption, range, and test-points cells for easier user entry.
Added a two budget option with CMC Uncertainty calculator.
Updated expanded uncertainty formula to automatically round to two significant figures.
Added dropdown list to allow users to switch between k=2 and student's t tables.
Added automatic file name printed in the header.
Added automatic date and page numbering to the footer.
Added Survey worksheet.
Added Cal Data worksheet.
Added R&R worksheet.
Added Linearity worksheet.
Added automatic calculation and linking of results to uncertainty in Budget worksheet for factors 1 through 8.
Updated Effective Degrees of Freedom calculation in 'Step 1 - Budget.'
Fixed Uncertainty Type dropdown menu in 'Step 1 - Budget.'
freedom cells.