MSA using tolerances - Page 116 of the AIAG MSA manual

Status
Not open for further replies.
T

Timmot

#1
I am a bit confused over one point in the MSA manual . . .

I have updated our old MSA speadsheets to the newer MSA book issue 3 and have checked and double checked all the results against other peoples results and everything seems fine . . . . until . . .

We performed an MSA test yesterday and got great results, then I saw on page 116 of the manual that when using the tolerance method I have to replace the TV value by the tolerance divide by six in %EV, %AV, %GRR, I hadn't done this division.

SO I made the adjustments:

%EV = 100 [EV/(tolerance/6)]
%AV = 100 [AV/(tolerance/6)]
%GRR = 100 [GRR/(tolerance/6)]
%PV = 100 [PV/(tolerance/6)]

. . . .and ofcourse got much worse results.

I am confused because the examples I have got from these forums have not replaced the TV values with tolerance/6, only the full tolerance, or do people divided the tolerance before entering the value into the spreadsheet.

I am greatful for some clarity on this point.

Thanks

Timmot

ps. does anyone have a spreadsheet example of the Anova method, thanks.
 
Last edited by a moderator:
Elsmar Forum Sponsor

Howard Atkins

Forum Administrator
Staff member
Admin
#2
As one of those responsible for posting examples of edition 3 I admit that I had not paid attention to this issue.
I did not study the text properly and in fact used the previous worksheets and just changed the constants.
I know see that in the 2nd edition (page 60) there is no requirement to divide by 6 as there is in the 3rd edition (page 117).
Have I been misleading the public?
Why is there such a big difference?
 
T

Timmot

#3
Thanks for your reply & ofcourse your right,

I checked the version 2 manual and the by six division is not stated, this seems very odd to me . . . . I think I'll go back to issue 2 and save me and my company a lot of headaches and money as I'm unlikely to every get an acceptable MSA with issuse 3 . . . .

. . seriously though, how can such a dramatic change be made, it seems to me a misstake has been made in one of the issues, the question is which one.

:(

Timmot
 

Miner

Forum Moderator
Staff member
Admin
#4
Unfortunately, I do not have ready access to my MSA, 3rd ed., so I cannot cite the correct pages.

If you take the formula that you cited and divide by 5.15 instead of 6, you should get the same answer as in the 2nd edition. The MSA manual made two changes that affect this example.

In the 2nd edition you multiplied the AV, et al, by 5.15 and divideby the total tolerance. In the third edition, you do not multiply by 6, so you must divide the tolerance by 6.

This simplified the %GRR calculations, which they now emphasize over the P/T ratio,because you did not multiply and divide by the same number. It also reflects the push to 6 instead of 5.15 as a multiplier. However, it resulted in confusion to users of the P/T ratio.
 
T

Timmot

#5
I'm not sure from what version I have updated,
We have used an old excel spreadsheet which is about 5 years old, anyway I can not find anywhere which uses the 5.15 calcalation you mentioned, I saw the K1 and the K2 values differ a lot maybe it has something to do with this!.

I changed the division of 6 to 5,15 in the new spreadsheet I have made using issue 3 but it does not give the same results as the old spreadsheet - the values are higher in the newer, maybe the old spreadsheet has some faulty calculations or are from issue 1.

I will just have accept the miss I made with the division of 6 and that I will probably never get an approved MSA - We make large parts of foam and plastics measured on gigs in CMM's . . . . . . well at least MSA keeps me busy and in a job! :biglaugh:
 
M

martin elliott

#6
5.15 change to 6

Timmot said:
I'm not sure from what version I have updated,
We have used an old excel spreadsheet which is about 5 years old, anyway I can not find anywhere which uses the 5.15 calcalation you mentioned, I saw the K1 and the K2 values differ a lot maybe it has something to do with this!.

I changed the division of 6 to 5,15 in the new spreadsheet I have made using issue 3 but it does not give the same results as the old spreadsheet - the values are higher in the newer, maybe the old spreadsheet has some faulty calculations or are from issue 1.

I will just have accept the miss I made with the division of 6 and that I will probably never get an approved MSA - We make large parts of foam and plastics measured on gigs in CMM's . . . . . . well at least MSA keeps me busy and in a job! :biglaugh:
The information regarding the change to a 6 from 5.15 is described within page vi, i.e. after the MSA 3rd edition Quick guide, just before the table of contents.

Obviously this change degrades the value reported but increases the "safety" of the result.

If you are trying to modify MSA 2 speadsheets you are possibly missing some of the changes and maybe even missing the changes in emphasis on chart interpretation. The metric represents only a small part of the study and to get the most out of the study there is a lot more to look at. Fortunatly :rolleyes: most customers are only interested the metric.

Martin
Older but no wiser!
 
T

Timmot

#7
I had missed an imput on the old excel spreadseet and now get the same values as issue 2 by dividing the tolerance by 5,15 in the 3rd issue, also I got back a copy of issue 2 and can now see where the calulations differ, it was as I thought in the K values, I can now see in issue 2 the D2 value was divided by 5,15, but not in the third . . . .

Thanks for the help :thanx:

Timmot
 

Miner

Forum Moderator
Staff member
Admin
#8
Timmot said:
I had missed an imput on the old excel spreadseet and now get the same values as issue 2 by dividing the tolerance by 5,15 in the 3rd issue, also I got back a copy of issue 2 and can now see where the calulations differ, it was as I thought in the K values, I can now see in issue 2 the D2 value was divided by 5,15, but not in the third . . . .

Thanks for the help :thanx:

Timmot
I found my manual. If you take the K1 and K2 values from the 2nd edition, and divide them by 5.15, you will obtain the new K1 and K2 values found in the 3rd edition. That is why you have to divide the tolerance by 5.15 to get the same answer as in the 2nd edition.
 
T

Timmot

#9
From a helpful lady at AIAG:

On page 117, the first line the text reads... “value of tolerance divided by six” in the denominator. This effectively degrades the GR&R score as calculated by using the formulas in MSA2. Is this calculation correct?

Your logic is correct but your conclusion is not since it is based on an incorrect assumption. The problem is not that the 3rd edition inadvertently degrades (i.e. overestimates) the GRR but that the 2nd edition underestimates it. The 2nd edition went to a standardized 5.15 factor even for the total variation (see conversion of historical process variation on pg 60 top MSA2). This same conversion should have been applied to the tolerance (assuming a process with a Cp =1). It was not and consequently the GRR calculated using the MSA2 approach is for a process with a Cp of 0.86 rather than a minimal Cp =1.


Now, if you want to continue to use the underestimated GRR based on the MSA2 approach you can, but you need to get your customer agreement with this approach."
 
C

CREED

#10
Msa Manual Third Edition

DOES ANY ONE KNOW WHAT THE RECOMMENDATION FOR PV% SHOULD BE. ACCORDING TO THE MSA MANUAL, GRR% SHOULD BE UNDER 10% GOOD, 10%- 30% MAY BE ACCEPTABLE, OVER 30% NOT ACCEPTABLE. ndc SHOULD BE GREATER THAN 5. BUT IT DOES NOT GIVE ANY GUIDE LINES FOR PV%.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S MSA on a process using different fixtures Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C PPAP Rejection for "MSA-GR&R are not using the latest AIAG format" APQP and PPAP 9
M Using an earlier MSA on a different but similar part Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
J Performing a MSA on a new gauge using different parts Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M MSA 4 - Results of GR&R Study using Range & Average Method Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Q Using Traceable Standards - AIAG MSA Manual Chapter II, Section B, 1st bullet Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Miner New MSA file using ANOVA - January 2010 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 33
T Non-Replicable MSA when using digital multimeters or oscilloscopes Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
B MSA (Measurement Systems Analysis) with One Operator using a CMM or Common Calipers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Miner Intro to MSA of Continuous Data – Part 7: R&R using Wheeler’s Honest Gage Study Imported Legacy Blogs 17
C Attribute MSA Study using Kappa - Why Kappa value is low Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 13
V To formulate an Excel .xls worksheet for MSA on attribute data using Kappa Analysis Excel .xls Spreadsheet Templates and Tools 14
Nihls When the MSA results show no operator influence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Nihls MSA Study Type 1 (CMM) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M MSA Study Type 1 not capable. We are at the limit. And manufacturing wants to continue producing. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
I Overwhelmed with attribute MSA requirement for visual inspection IATF 16949 - Automotive Quality Systems Standard 8
H Need MSA 4th ed. compliant attribute MSA template General Measurement Device and Calibration Topics 4
P MSA for titration Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
P MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
P MSA study for visual system with artifical inteligence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
D MSA strategy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
K Updated MSA with the Annual PPAP validations APQP and PPAP 8
E MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
6 MSA for Calculated Clearance Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Ron Rompen MSA on automated measurement system - Multiple Step Vision System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G MSA check list to audit IATF 16949 - Automotive Quality Systems Standard 10
R MSA for ATE (Automatic Test Equipment Embedded Software) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Bev D MSA Tools Misc. Quality Assurance and Business Systems Related Topics 3
R MSA studies for Heat Treatment Equipment Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Industrial scales and MSA (IATF 16949 requirement 7.1.5.1.1) IATF 16949 - Automotive Quality Systems Standard 30
M Difference between MSA and MSE? General Measurement Device and Calibration Topics 1
M Test method validation - Is MSA (MSA1, MSA2, MSA3 and linearity) a good solution? Medical Device and FDA Regulations and Standards News 1
A MSA results differences - Supplier results vs. My results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
R Preliminary MSA and Sockets' correlation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
I MSA requirement for 5 Micrometers + CP changes need customer approval? IATF 16949 - Automotive Quality Systems Standard 2
T Correct MSA study for an automated camera system which makes attribute inspection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Bev D MSA Misc. Quality Assurance and Business Systems Related Topics 46
Emran.mi Measurement system analysis - Can you help me about implementation MSA for CMM device Manufacturing and Related Processes 2
N MSA Study for a Leak Testing Device Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
N Justifications for not performing MSA (Measurement System Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
D Do I need part variation while doing Destructive Variable Gage R&R MSA study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
Prashant G MSA Study - AS 9100 and and our customer want us to do MSA study for their parts dimension Reliability Analysis - Predictions, Testing and Standards 4
D Compression Spring Force MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
E MSA Study on MTS dynamic rate measurements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
A The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
S IATF 16949 Audit MSA IATF 16949 - Automotive Quality Systems Standard 10
C Do Calibration Reference Standards require an MSA study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
A MSA When an Instrument Measures More than One Parameter Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
G MSA Type 1 - Cg and Cgk ranges Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1

Similar threads

Top Bottom