Uncertainty Template
Used to Measure Different Forms of Uncertainty
To open this template, click on the QI Macros menu > DOE Gage R&R FMEA > Uncertainty Template:
NOTE: This Worksheet is the intellectual Property of E=mc3 Solutions. Permission is granted to the E=mc3 Solution Clients who have validly purchased this spreadsheet or with a QI Macros Purchase. All others should contact: emc3solu@aol.com or call 330-328-4400 to purchase a license.
Once opened, there are (2) template options:
Uncertainty 2016
To complete this worksheet:
- Input your "Technicians" data in cells E23 to J42.
- Once you have done so, your Uncertainty values will be calculated and filled in automatically.
Repeatability in B7 and Reproducibility in B8
Combined and Expanded Uncertainty in G17 and G20 - You can change your "Distribution" definition in cells D7 through D16.
- Input "Traceable Uncertainty of the Standard" in cell B9, "Resolution of the Standard" in B10 and "Resolution of UUT" in B11. Lastly, input your Type in column C and Distribution definition in column D:
- Your data set will be placed into the following bar chart:
For additional questions regarding this template, contact E=mc3 Solution directly: 330-328-4400.
Uncertainty 2015
To complete this worksheet:
- Input your information into cells C2 through C10.
- Next, input your measurements data in I14 through R18.
- Once you have done so, your Combined Type A and B Uncertainty values will be calculated and filled in automatically:
(Combined Type A Uncertainty in G19)
(Combined Type B Uncertainty in G33) - Your data set will be placed into the following column charts:
For additional questions regarding this template, contact E=mc3 Solution directly: 330-328-4400.