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
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > ISO 17025 and related Metrology Topics - Measurement Devices, Calibration and Test Laboratories
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access
Courtesy Quick Links

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

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

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

 
Registration Date: May 2010
Location: India
 
Posts: 2
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 16
Karma: 10
ghosh1975 has less than 100 Karma points so far.
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, 416 views)

Sponsored Links
  #2  
Old 25th August 2010, 03:33 PM
zamclachia's Avatar
zamclachia zamclachia is offline
Involved in Discussions

 
Registration Date: Nov 2007
Location: South Africa
 
Posts: 61
Thanks Given to Others: 26
Thanked 33 Times in 22 Posts
Karma Power: 33
Karma: 175
zamclachia is appreciated, and has over 100 Karma points.zamclachia is appreciated, and has over 100 Karma points.
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

  #3  
Old 26th August 2010, 01:18 AM
ghosh1975 ghosh1975 is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: May 2010
Location: India
 
Posts: 2
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 16
Karma: 10
ghosh1975 has less than 100 Karma points so far.
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 Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > ISO 17025 and related Metrology Topics - Measurement Devices, Calibration and Test Laboratories

Do you find this discussion thread helpful and informational?


Bookmarks


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
Is Uncertainty Calculation Mandatory raghu_1968 ISO 17025 and related Metrology Topics - Measurement Devices, Calibration and Test Laboratories 26 30th August 2011 09:27 AM
Is Uncertainty Calculation Mandatory for Field calibrations? LenaRuiz ISO 17025 and related Metrology Topics - Measurement Devices, Calibration and Test Laboratories 5 20th May 2011 03:42 AM
Uncertainty calculation - Estimation for a Mettler Toledo XP 56 balance at 20 grams BradM Measurement Uncertainty (MU) 11 17th February 2011 08:56 AM
Bias Calculation in Excel Worksheet suresh01 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10 7th July 2010 02:12 PM
Within Part Variation - Excel .xls calculation spreadsheet shahshahani Excel .xls Spreadsheet Templates and Tools 11 29th June 2005 01:36 PM



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


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272