PMEL Forum

Can anyone give example of uncertainty budget calculation in microsoft excel? Thank you. mail:[email protected]

www.nrc-cnrc.gc.ca/obj/doc/solutions-solutions/advisory-consultatifs/clas-clas/uncertainty_budget_template.xls

Here is a paper we wrote for Quality Magazine. 
http://digital.bnpmedia.com/publication/?i=273926&p=36
This is how we are going to start building our uncertainty budgets. 
The problem is once you get a budget built.. How to you use it and call it from all your software packages.

Mike.

Quote from: CalLabSolutions on 10-29-2015 -- 20:52:33
Here is a paper we wrote for Quality Magazine. 
http://digital.bnpmedia.com/publication/?i=273926&p=36
This is how we are going to start building our uncertainty budgets. 
The problem is once you get a budget built.. How to you use it and call it from all your software packages.

Mike.

and how i can use this program?

Ill paraphrase the question to clarify
"Guys I have no idea how to calculate uncertainties, I dont even know where to begin...as far as that goes I dont even understand the basics.
Will someone please give me an easy fix so I dont have to be bothered to learn anything new...."
Ill answer you honestly here.
If you had enough understanding of what you needed to do then you would already have your own working excel uncertainty calculator that works...

The book that helped me understand measurement uncertainty is "Measurement Uncertainty, Fourth Edition: Methods and Applications". It a good one to read.

If you do not have the training for Uncertainty Budgets, the excell program will not help you.

Good point.  You can not just plug and play an Excel sheet.  I use numerous excel sheets.  But there are a lot of different math formulas, knowing which to apply, which curve shapes/divisors to use for your uncertainties, and many more details.  Matter of fact, if this is for ISO17025 Accreditation purposes, one of the requirements is to have someone competent to know how to do the calculations.  Having a spreadsheet may be a nice tool as an example for while you are learning.  But training is a must (even if it is getting things online and self-training).

Seems a little harsh.  I sat through that Class A Uncertainty NCSLI class with you earlier this year and that's some complicated material to wrap your head around!!

It is difficult material.  I definitely struggle with it.  Hope I wasn't being harsh.  Just trying to be real about how much it takes to do uncertainty budgets.

You're good.  I was responding to a Marine buddy of mine that commented a few posts above yours. 

Quote from: RFCAL on 10-30-2015 -- 09:09:43
If you do not have the training for Uncertainty Budgets, the excell program will not help you.

I have big experience in uncertainty calculation but i want to se experience in excel calculation of my colleagues.

Its not intentionally harsh, it is the truth though.

There are two problems with these types of requests

1) (as stated above)  If you know how to do uncertainty calculations you could easily write an excel sheet to calculate them.  If you do not know how to calculate uncertainties then an excel sheet, uncert software, etc  isnt going to help.

2) Asking for someone to "give" you professional tools they (or someone else) developed is wrong.  Asking for assistance understanding the problem or guidance in creating an excel is far better

A better request given the current information in the post might be

Guys,
I have a good understanding of uncertainties and a terrible understanding of excel. 
Could someone provide guidance, (or review the attached sheet) on proper formatting of the math in excel"

Just my 1/50th of a dollar

Okey, may be anyone give excel template calculating with uncertainty toolbox?

You cannot expect people to just give you spreadsheets and software.
You will need to contact Quametek for Uncertainty Toolbox. You need the training and a license in order to operate / use that software.