|
|
 |
|

3rd July 2009, 09:46 AM
|
|
Involved in Discussions
Registration Date: Jul 2009
|
|
Posts: 11
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 2 Karma: 10 
|
|
Excel Uncertainty Calculator wanted
hello guys
i have just a simple question : is it posible someone to create xcel sheet working as an uncertainty calculator?
thank you in advance
|

3rd July 2009, 10:00 AM
|
 |
Super Moderator
Registration Date: Sep 2006
Location: Arlington,Texas
|
|
Posts: 3,384
Thanks Given to Others: 814
Thanked 850 Times in 607 Posts
Karma Power: 274
|
|
Re: uncertainty calculator
Hello Cruss! Welcome to the Cove!
The short answer to your question is: sure you can!
Here is a site that has several tools for calculating uncertainty:
http://www.callabmag.com/freeware.html
Here is a thread that I have an Excel uncertainty calculator. I think I got it from here (The Cove), but I don't recall:
Uncertainty calculation
If you desire, you might want to pop over to the Post Attachment List, and search for others; I think there are more posted here.
Hope that helps!
__________________
Brad
My idea of housework is to sweep the room with a glance.
|
|
Thanks to BradM for your informative Post and/or Attachment!
|
|

3rd July 2009, 10:06 AM
|
|
Involved in Discussions
Registration Date: Jul 2009
|
|
Posts: 11
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 2 Karma: 10 
|
|
Re: Need example of uncertainty calculator for Excel
thank you Brad, i`ll check the links
|

7th July 2009, 12:33 PM
|
|
Involved in Discussions
Registration Date: Feb 2007
Location: Gabrovo, Bulgaria
|
|
Posts: 71
Thanks Given to Others: 2
Thanked 27 Times in 18 Posts
Karma Power: 24
|
|
Re: Need example of uncertainty calculator for Excel
Hi Cruss,
QMSYS GUM Educational is a freeware for the classical calculation of the measurement uncertainty according to GUM Uncertainty Framework.
http://download.cnet.com/QMSys-GUM-E...html?tag=mncol
The most important features offer:
- Suitably for linear models
- Max. 10 input and 1 output quantities
- Distributions: Normal, Lognormal, Student's t, Rectangular, Triangular, Trapezoidal, curvilinear Trapezoidal, U-shaped, Quadratic, Exponential, Cosine, 1/2 Cosine
- Direct and indirect methods of observation
- Statistical evaluation of Typ A quantities.
|

7th July 2009, 05:29 PM
|
 |
Involved in Discussions
Registration Date: Nov 2007
Location: South Africa
Age: 42
|
|
Posts: 21
Thanks Given to Others: 6
Thanked 11 Times in 6 Posts
Karma Power: 10 Karma: 65 
|
|
Re: Need example of uncertainty calculator for Excel
I posted an excel calculation at the discussion forum below. Please try it and let me know what you think. If it needs to modified please let me know and I will correct asny errors.
How to calculate and apply Measurement Uncertainty in Chemical Analysis
|

9th July 2009, 05:27 AM
|
|
Involved in Discussions
Registration Date: Jul 2009
|
|
Posts: 11
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 2 Karma: 10 
|
|
Re: Excel Uncertainty Calculator wanted
Stefanhg this software looks good but i need unlock key to use it
|

9th July 2009, 05:29 AM
|
|
Involved in Discussions
Registration Date: Jul 2009
|
|
Posts: 11
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 2 Karma: 10 
|
|
Re: Excel Uncertainty Calculator wanted
zamclachia your Excel sheet is read only too
|

9th July 2009, 03:58 PM
|
 |
Involved in Discussions
Registration Date: Nov 2007
Location: South Africa
Age: 42
|
|
Posts: 21
Thanks Given to Others: 6
Thanked 11 Times in 6 Posts
Karma Power: 10 Karma: 65 
|
|
Re: Excel Uncertainty Calculator wanted
Quote:
Originally Posted by cruss
zamclachia your Excel sheet is read only too 
|
The yellow cells are open for entering data. The rest of the calculation is locked to protect any formulas.
|
Lower Navigation Bar
|
|
|
|
Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate Thread Content |
Linear Mode
|
|
Posting Settings
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|