


12th November 2010, 06:25 AM


Re: Gage R&R Form in Excel for calculating gauge R&R attached
Quote:
In Reply to Parent Post by Miner
The form looks nice. I entered the Ford MSA validation data set to validate the calculations. The %TV and %Tol calculations are correct. There is a slight difference in the ndc results (13 vs. 14). This may be due to how many digits were carried out in the calculation.
If you want to enhance it, consider the other graphs shown in the MSA manual.

Hi all,
I changed Cell J92 to correct difference in the ndc results (13 vs. 14) into
=1,41*(C84/C77)
and now I have 14 ndc instead of 13.
Have a nice weekend
Mr.Happy

14th November 2010, 03:48 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Quote:
In Reply to Parent Post by Amartinez
Ales,
The cell H26 shows incorrect formula to get the average, show : promedio (H24:H25) and must be promedio (H23:H25),
Regards

Cell H26 calculate "AVERAGE(H23:H25)2.
I change formula for AV calculation. In new form AV is 0 in case of R analyses.
Aleš

16th November 2010, 03:42 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
The Excel template KT.158_MSA looked really good, and it should be very helpful. However, I reentered data from a Gage R&R that I did with MiniTab and I got different results. Here are the results from MiniTab that I am interested in using:
Total Gage R&R %Tolerance (Study Var/Toler) 6.91%
Here is the results from the Excel template:100(R&R/Tol) 5.08%
Are Study Var/Toler and R&R/Tol considered to be the same? If so what could be causing the difference between the two numbers?

18th November 2010, 05:01 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Quote:
In Reply to Parent Post by jdhigh
The Excel template KT.158_MSA looked really good, and it should be very helpful. However, I reentered data from a Gage R&R that I did with MiniTab and I got different results. Here are the results from MiniTab that I am interested in using:
Total Gage R&R %Tolerance (Study Var/Toler) 6.91%
Here is the results from the Excel template:100(R&R/Tol) 5.08%
Are Study Var/Toler and R&R/Tol considered to be the same? If so what could be causing the difference between the two numbers?

Hi jdhigh,
Did you try to check your minitab data with the Measurement_System_Software_Callibration_Tables.xls
see elsewhere in the cove.
Success,
Mr.Happy

18th November 2010, 05:23 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Very nice clean interface. Do you plan to update to MSA 4th edition as well? Your good work would need only a couple of tweaks as the 4th edition does more clearly differentiate between Product and Process GR&R and acceptable % and also modified the 030% rule.
Capability comparison and rationale demonstrated that 030% error has a neglible effect on Ppk/Cpk estimates. It was noted that capability percentage uses 30% as derived from σ; when the σ˛ (variance) is used, the maximum is 10%. Over 30% the effect on accept/reject decisions is almost exponential. (Appendix B, Page 199).
Thanks!

7th March 2011, 08:56 AM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Hi automoto,
Just another question about your MSA Excel file:
I used it a couple of times now, but i wonder if it is not to be needed to fill in the minimal gage resolution ? For example when using a digimatic caliper fill in minimal gage resolution 0,01 mm or when using a micrometer fill in minimal gage resolution 0,001 mm etc.
cheers
Mr.Happy

8th March 2011, 04:53 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Quote:
In Reply to Parent Post by Sturmkind
Very nice clean interface. Do you plan to update to MSA 4th edition as well? Your good work would need only a couple of tweaks as the 4th edition does more clearly differentiate between Product and Process GR&R and acceptable % and also modified the 030% rule.
Capability comparison and rationale demonstrated that 030% error has a neglible effect on Ppk/Cpk estimates. It was noted that capability percentage uses 30% as derived from σ; when the σ˛ (variance) is used, the maximum is 10%. Over 30% the effect on accept/reject decisions is almost exponential. (Appendix B, Page 199).
Thanks!

Hi,
I have in plan to add on the form calculation of PV from historical variation informations (Pp). See page 121. Also calcualtion described in appendix B will be added. Thans for your proposal.
What you mean under 030% rule? GRR criteria all the same as in MSA 3rd version, right? Page 78.
Form update will be made in one month.
Regards

8th March 2011, 05:01 PM


Re: Gage R&R Form in Excel for Calculating Gauge R&R  Attached
Quote:
In Reply to Parent Post by Mr.Happy
Hi automoto,
Just another question about your MSA Excel file:
I used it a couple of times now, but i wonder if it is not to be needed to fill in the minimal gage resolution ? For example when using a digimatic caliper fill in minimal gage resolution 0,01 mm or when using a micrometer fill in minimal gage resolution 0,001 mm etc.
cheers
Mr.Happy

Hi Mr. Happy,
If gauge resolution is OK tells you ndc index. Do you want that I add on the form data about gauge resolution?
Regards

Lower Navigation Bar


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


Thread Tools 
Search this Thread 


Display Modes 
Rate Thread Content 
Linear Mode


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
HTML code is Off




