Elsmar Cove Forum Header Graphic The Elsmar Cove Wiki Sitemap 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
NQA-USA
Miner's MSA (Measurement Systems Analysis) Blog 
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Wooden Line

Excel Templates for MSA Study as per 4th Edition Manual

Search the Elsmar Cove
Search Elsmar
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
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
aiag manual(s), microsoft excel .xls .xlsx spreadsheet, msa (measurement system analysis), msa manual, statistical analysis and studies, forms and templates (general)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 2nd August 2011, 09:31 AM
V5652

 
 
Total Posts: 9
Please Help! 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.

Sponsored Links
  Post Number #2  
Old 2nd August 2011, 04:22 PM
automoto's Avatar
automoto

 
 
Total Posts: 76
Re: Excel Templates for MSA Study as per 4th Edition Manual

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

Hope will be useful....
Thank You to automoto for your informative Post and/or Attachment!
Sponsored Links

  Post Number #3  
Old 3rd August 2011, 12:43 AM
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  
Old 3rd August 2011, 02:54 AM
automoto's Avatar
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  
Old 9th December 2011, 08:33 AM
StewiSch's Avatar
StewiSch

 
 
Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
In Reply to Parent Post by automoto View Post

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?

Thanks for your great support
Stephan
  Post Number #6  
Old 9th December 2011, 09:27 AM
StewiSch's Avatar
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  
Old 9th December 2011, 09:30 AM
Stijloor's Avatar
Stijloor

 
 
Total Posts: 14,711
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
In Reply to Parent Post by StewiSch View Post

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  
Old 9th December 2011, 11:14 AM
StewiSch's Avatar
StewiSch

 
 
Total Posts: 9
Re: Excel Templates for MSA Study as per 4th Edition Manual

Quote:
In Reply to Parent Post by Stijloor View Post

...

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
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

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 my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Hirstyuk Using Minitab Software 18 3rd March 2014 12:44 PM
MSA 4th Edition formats in Excel wanted - GR&R, Bias, Stability and Linearity sudhaacar Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5 14th October 2012 04:26 AM
Simple Navigation Guide for the MSA 4th Edition Manual Stijloor Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0 9th December 2011 08:52 AM
MSA Manual 4th Edition, Page 100 - What is wrong in the graph? Rameshwar25 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8 14th December 2010 05:01 AM
New MSA Manual (4th Edition) - June 2010 JQuality ISO/TS 16949 - International Automotive Quality Systems Standard 1 10th June 2010 04:19 PM



The time now is 02:01 PM. 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
NOTE: This forum uses "cookies".