The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
Miner's MSA (Measurement Systems Analysis) Blog
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > General Metrology, Measurement Device, Calibration and Test Laboratories > Metrology Topics - Measurement Devices, Calibration and Test Laboratories
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

Uncertainty Calculation in Excel - Please review my calculation

Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Courtesy Quick Links

Links that Cove visitors will find useful in your quest for knowledge:


ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Atul's
Quality Forum Online

Howard's
International Quality Services

Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum

Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Related LinkedIn Groups

ISO 9001 for Small Businesses

ISO 9001:2015 Revision Discussions

Information Security Community

Medical Devices Group

Quality and Regulatory Network

FDA (Food and Drugs)

AS91XX Series - Tips and Advice


Related Topic Tags
measurement uncertainty (mu), microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 25th August 2010, 05:12 AM
ghosh1975

 
 
Total Posts: 2
Thank You! Uncertainty Calculation in Excel - Please review my calculation

Hello Experts,

I am working with a Rotameter manufacturing company. we have recently calibrated our Master flow Instruments from a Laboratory.

The said laboratory report I am tabulate in excel but some variation come in decimal in following points.

1) Type A standared Uncertainty 7.84E-02 slpm instead of report says 7.86E-02.
2) Combine Uncertainty 3.09E-03 instead of report says 3.06E-03
3) Effective degree of Freedom 36019 instead of report says 34968

Please find attachment and correct me, if any formula error or this error comes due to number of decimal points hide in report etc.

Regards
Tapas Ghosh
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Uncertainty in Excel.xls (38.0 KB, 500 views)

Sponsored Links
  Post Number #2  
Old 25th August 2010, 03:33 PM
zamclachia's Avatar
zamclachia

 
 
Total Posts: 62
Re: Uncertainty Calculation in Excel - Please review my calculation

Quote:
In Reply to Parent Post by ghosh1975 View Post

Hello Experts,

1) Type A standared Uncertainty 7.84E-02 slpm instead of report says 7.86E-02.
2) Combine Uncertainty 3.09E-03 instead of report says 3.06E-03
3) Effective degree of Freedom 36019 instead of report says 34968
Have you looked at the effect of rounding. Where you have used a value of 0.00167 (Cell H6) in the manual calculation, the calculated formula gives you 0.0016723535694697 (Cell H33) which is been used in the final result calculation.
Sponsored Links

  Post Number #3  
Old 26th August 2010, 01:18 AM
ghosh1975

 
 
Total Posts: 2
Re: Uncertainty Calculation in Excel - Please review my calculation

Quote:
In Reply to Parent Post by zamclachia View Post

Have you looked at the effect of rounding. Where you have used a value of 0.00167 (Cell H6) in the manual calculation, the calculated formula gives you 0.0016723535694697 (Cell H33) which is been used in the final result calculation.
Yes Sir, you are right.
I have seen this effect, because Cell H6 is the lab report, which I have received as printed format from lab .Cell H33 and all Green color field in both of sheet "REPORT & BUDGET", I have calculate through formula

So please review my formula, and correct me if any error.

I am also assumed the deviation with Lab report and calculate value comes due to rounding effect.

Any one can HELP me that how the column “Sensitivity coefficient” value calculate. Is it comes from Student T Table? If so, please clarify when these values comes negative.


Thanks
Tapas Ghosh
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > General Metrology, Measurement Device, Calibration and Test Laboratories > Metrology Topics - Measurement Devices, Calibration and Test Laboratories


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Sigma Calculation in Excel MartyCalavera Capability, Accuracy and Stability - Processes, Machines, etc. 3 10th January 2014 08:59 PM
Uncertainty Measurement Calculation in Chemical Testing harendrasinhsolanki Measurement Uncertainty (MU) 1 3rd January 2014 03:52 PM
Uncertainty calculation for a voltage measurement NickF Measurement Uncertainty (MU) 3 16th July 2013 08:40 AM
Is Uncertainty Calculation Mandatory raghu_1968 Metrology Topics - Measurement Devices, Calibration and Test Laboratories 26 30th August 2011 09:27 AM
Is Uncertainty Calculation Mandatory for Field calibrations? LenaRuiz Metrology Topics - Measurement Devices, Calibration and Test Laboratories 5 20th May 2011 03:42 AM



The time now is 03:55 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 


NOTE: This forum uses "Cookies" -- The Elsmar Cove is *Copyright Free*.
A Peachfarm LLC Internet Property