The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Google
  Web Elsmar.com
*Please be aware that SOME RECENT forum threads may not yet be indexed by Google.

View Full Version : Excel Uncertainty Calculator wanted


cruss
3rd July 2009, 09:46 AM
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

BradM
3rd July 2009, 10:00 AM
Hello Cruss! Welcome to the Cove!:bigwave:

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 (http://elsmar.com/Forums/showthread.php?t=32154)

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!:bigwave:

cruss
3rd July 2009, 10:06 AM
thank you Brad, i`ll check the links

stefanhg
7th July 2009, 12:33 PM
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-Educational/3000-2054_4-10915782.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.

zamclachia
7th July 2009, 05:29 PM
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 (http://elsmar.com/Forums/showthread.php?p=312323#post312323)

cruss
9th July 2009, 05:27 AM
Stefanhg this software looks good but i need unlock key to use it

cruss
9th July 2009, 05:29 AM
zamclachia your Excel sheet is read only too :confused:

zamclachia
9th July 2009, 03:58 PM
zamclachia your Excel sheet is read only too :confused:
The yellow cells are open for entering data. The rest of the calculation is locked to protect any formulas.

greif
1st September 2009, 12:21 PM
This is not Excel, but is a free , nice, and understandable Uncertainty Calculator;
go to isgmax.com/sidekick_details.htm

The program name is Uncertainty Sidekick

There is a nice manual and help pop-ups to advise you of what to plug in where!
gr