# MSA using tolerances - Page 116 of the AIAG MSA manual

Status
Not open for further replies.
T

#### Timmot

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.

%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:

#### Howard Atkins

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

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
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

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!

M

#### martin elliott

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!
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 most customers are only interested the metric.

Martin
Older but no wiser!

T

#### Timmot

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

Timmot

#### Miner

##### Forum Moderator
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

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

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

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.
MSA - Using a R&R study for a Tape Measure Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
MSA angle issue - Nylon parts using Aberlink 3D Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
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
New MSA file using ANOVA - January 2010 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 34
T Non-Replicable MSA when using digital multimeters or oscilloscopes Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
MSA (Measurement Systems Analysis) with One Operator using a CMM or Common Calipers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
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
Conducting an MSA Test on scales Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA samples Preparation. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA Frequency related literature Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
%AV=0 in the MSA GRR Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
MSA - Dealing with inherent within-part variation in assemblies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Ford Q1 MSA - Virtual Site Visit Hardware Manufacturing and Related Processes 14
MSA on set of parts with low variation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 20
MSA Reference Manual 2nd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
Medical Device - fixture qualification and MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Options when MSA acc. to VDA 5 is NOK (Qms > 30%) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
MSA for non-contact CMM - ISO10360 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Thermometers and Thermocouple or Transducer's require MSA? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA Studies for chemical analytical instruments in QC Lab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
IATF MSA study Type 1 General Measurement Device and Calibration Topics 7
MSA after the device move Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
MSA clause or wording needed. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA clause 7.1.5.1.1 - Statistical studies on counting weight scale Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
MSA Study Type 2 (special conditions ) IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
When the MSA results show no operator influence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA Study Type 1 (CMM) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
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
Overwhelmed with attribute MSA requirement for visual inspection IATF 16949 - Automotive Quality Systems Standard 11
Need MSA 4th ed. compliant attribute MSA template General Measurement Device and Calibration Topics 4
MSA for titration Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
MSA study for visual system with artifical inteligence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
MSA strategy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Updated MSA with the Annual PPAP validations APQP and PPAP 8
MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
MSA for Calculated Clearance Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
MSA on automated measurement system - Multiple Step Vision System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
MSA check list to audit IATF 16949 - Automotive Quality Systems Standard 10
MSA for ATE (Automatic Test Equipment Embedded Software) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
MSA Tools Misc. Quality Assurance and Business Systems Related Topics 3
MSA studies for Heat Treatment Equipment Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1