The Elsmar Cove Business Systems and Standards Discussion Forums Excel Templates for MSA Study as per 4th Edition Manual
 Forum User Name Keep Me Logged In Password
 Register Photo Albums Blogs FAQ Registered Visitors Social Groups Calendar Search Today's Posts Mark Forums Read

 Elsmar Cove Forum Visitor Notice(s)

# Excel Templates for MSA Study as per 4th Edition Manual

 Elsmar XML RSS Feed Monitor the Elsmar Forum Sponsor Links Courtesy Quick Links Links Elsmar Cove visitors will find useful in the quest for knowledge and support: International Standards Bodies - World Wide Standards Bodies International Organization for Standardization - ISO Standards and Information Quality Digest

Post Number #1
2nd August 2011, 08:31 AM
 V5652 Total Posts: 9
Excel Templates for MSA Study as per 4th Edition Manual

hello friends,
can anybody has the Excel Templates for MSA Study as per MSA 4th Manual?
e.g. Bias, Linearity, G R&R etc.

Post Number #2
2nd August 2011, 03:22 PM
 automoto Total Posts: 76
Re: Excel Templates for MSA Study as per 4th Edition Manual

For type 1 study see http://elsmar.com/Forums/showthread.php?t=49600

Hope will be useful....
 Thank You to automoto for your informative Post and/or Attachment!
Post Number #3
2nd August 2011, 11:43 PM
 V5652 Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Thanks for the quick reply automoto.
Can you have any template for Bias & Linearity study.
I have to know how to calculate P-Value in bias study and also Repeatability as a percentage of Tolerance and Process Variation.
Post Number #4
3rd August 2011, 01:54 AM
 automoto Total Posts: 76
Re: Excel Templates for MSA Study as per 4th Edition Manual

For calculating of p-value used data form type 1 MSA study (one pcs. measured 50 times with same appraiser). See explanation and formulas below.
p-value
P-value associated with t. It is the probability of seeing a t statistic as large or larger than the calculated one, assuming that the bias is zero. So as t gets larger, P gets smaller. A small P implies that the assumption that the bias = 0 is probably not true.

T
The t-statistic for testing the null hypothesis that bias = 0 versus the alternate that bias 0.
where
T=SQER(n)*ABS(X- Xm) / S
n = number of measurements
X = mean of n measurements
Xm = reference measurement
S = standard deviation
t follows the t-distribution with n degrees of freedom, where n = n-1.

Bias
The gage bias is calculated by the difference between the mean of the n measurements and the reference value.
Bias = X - Xm
where
X = mean of n measurements
Xm = reference measurement

For calculating Repeatability as a percentage of Tolerance and Process Variation use standard form for variable or type 1 MSA.
Post Number #5
9th December 2011, 08:33 AM
 StewiSch Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
 In Reply to Parent Post by automoto For variable see http://elsmar.com/Forums/showthread.php?t=35928 ...
Thanks Aleš, ... referring to the question on MSA 4th edition we need to be careful referring to threads on MSA 3rd.

Your variable calculation is really smart - looking for answers using MSA 3rd edition. As constants and calculation methods have changed significantly, do you have (or know about) an updated version somewhere?

Stephan
Post Number #6
9th December 2011, 09:27 AM
 StewiSch Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Thanks a lot Stijloor,
actually I am looking for Excel templates for MSA (4th ed.) gauge assessment ... type 1 and type 2 studies, for variable and attributive gauges.
Maybe someone has a hint for variable gauges ... :-)
Cheers
Stephan
Post Number #7
9th December 2011, 09:30 AM
 Stijloor Total Posts: 15,223
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
 In Reply to Parent Post by StewiSch Thanks a lot Stijloor, actually I am looking for Excel templates for MSA (4th ed.) gauge assessment ... type 1 and type 2 studies, for variable and attributive gauges. Maybe someone has a hint for variable gauges ... :-) Cheers Stephan
Yes, I know.... I had an older version (MSA 3rd Ed) posted some years ago.

This one covers the MSA 4th Edition. Just something extra for our Cove Members...

Stijloor.
Post Number #8
9th December 2011, 11:14 AM
 StewiSch Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
 In Reply to Parent Post by Stijloor ... This one covers the MSA 4th Edition. Just something extra for our Cove Members... Stijloor.
looking at your previous attachment I find a one page power point document referring to the different chapters/pages of MSA 4 - is that what you mean
Stephan

 The Elsmar Cove Business Systems and Standards Discussion Forums Excel Templates for MSA Study as per 4th Edition Manual

 Bookmarks

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

 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 Emoticons are On [IMG] code is On HTML code is Off Forum Rules

 Similar Discussion Threads Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote Laila rezzouki Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12 1st March 2017 04:06 PM Hirstyuk Using Minitab Software 18 3rd March 2014 12:44 PM yundm APQP and PPAP 38 16th October 2010 07:16 PM jsamson Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10 27th November 2007 02:30 AM justncredible Using Minitab Software 4 27th April 2007 11:13 PM

The time now is 06:25 PM. All times are GMT -4.