The Elsmar Cove Wiki 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
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)
Forum Username


Search the Elsmar Cove
Custom Search
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
Sponsor Links





Donate and $ Contributor Forum Access

Click the graphic above.
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
gage r&r (repeatability and reproducibility), microsoft excel .xls .xlsx spreadsheet, forms and templates (general)
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  #25  
Old 12th November 2010, 05:25 AM
Mr.Happy's Avatar
Mr.Happy Mr.Happy is offline
Involved in Discussions

 
Registration Date: Oct 2007
Location: netherlands
 
Posts: 141
Thanks Given to Others: 47
Thanked 75 Times in 39 Posts
Karma Power: 43
Karma: 601
Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.
Re: Gage R&R Form in Excel for calculating gauge R&R attached

Quote:
In Reply to Parent Post by Miner View Post

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

Sponsored Links
  #26  
Old 14th November 2010, 02:48 PM
automoto's Avatar
automoto automoto is offline
Involved in Discussions

 
Registration Date: Oct 2008
Location: Slovenia
 
Posts: 76
Thanks Given to Others: 29
Thanked 69 Times in 20 Posts
Karma Power: 32
Karma: 832
automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.
Send a message via Skype™ to automoto
Re: Gage R&R Form in Excel for Calculating Gauge R&R - Attached

Quote:
In Reply to Parent Post by Amartinez View Post

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š
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls MSA.xls (186.0 KB, 396 views)

__________________

Quality is returning of the customers and not products...
Sponsored Links

  #27  
Old 16th November 2010, 02:42 PM
jdhigh jdhigh is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Nov 2010
Location: USA/North Carolina
 
Posts: 1
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 15
Karma: 10
jdhigh has less than 100 Karma points so far.
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?
  #28  
Old 18th November 2010, 04:01 PM
Mr.Happy's Avatar
Mr.Happy Mr.Happy is offline
Involved in Discussions

 
Registration Date: Oct 2007
Location: netherlands
 
Posts: 141
Thanks Given to Others: 47
Thanked 75 Times in 39 Posts
Karma Power: 43
Karma: 601
Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.
Re: Gage R&R Form in Excel for Calculating Gauge R&R - Attached

Quote:
In Reply to Parent Post by jdhigh View Post

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
  #29  
Old 18th November 2010, 04:23 PM
Sturmkind's Avatar
Sturmkind Sturmkind is offline
Involved in Discussions

 
Registration Date: Jun 2009
Location: Sterling Heights, MI
 
Posts: 268
Thanks Given to Others: 147
Thanked 166 Times in 114 Posts
Karma Power: 49
Karma: 1421
Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.Sturmkind is appreciated, and has over 1300 Karma points.
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 0-30% rule.

Capability comparison and rationale demonstrated that 0-30% 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!

__________________

"Try not to become a man of success but rather to become a man of value." Albert Einstein
  #30  
Old 7th March 2011, 07:56 AM
Mr.Happy's Avatar
Mr.Happy Mr.Happy is offline
Involved in Discussions

 
Registration Date: Oct 2007
Location: netherlands
 
Posts: 141
Thanks Given to Others: 47
Thanked 75 Times in 39 Posts
Karma Power: 43
Karma: 601
Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.Mr.Happy is appreciated, and has over 500 Karma points.
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
  #31  
Old 8th March 2011, 03:53 PM
automoto's Avatar
automoto automoto is offline
Involved in Discussions

 
Registration Date: Oct 2008
Location: Slovenia
 
Posts: 76
Thanks Given to Others: 29
Thanked 69 Times in 20 Posts
Karma Power: 32
Karma: 832
automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.
Send a message via Skype™ to automoto
Re: Gage R&R Form in Excel for Calculating Gauge R&R - Attached

Quote:
In Reply to Parent Post by Sturmkind View Post

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 0-30% rule.

Capability comparison and rationale demonstrated that 0-30% 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 0-30% rule? GRR criteria all the same as in MSA 3rd version, right? Page 78.

Form update will be made in one month.
Regards

__________________

Quality is returning of the customers and not products...
  #32  
Old 8th March 2011, 04:01 PM
automoto's Avatar
automoto automoto is offline
Involved in Discussions

 
Registration Date: Oct 2008
Location: Slovenia
 
Posts: 76
Thanks Given to Others: 29
Thanked 69 Times in 20 Posts
Karma Power: 32
Karma: 832
automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.automoto is appreciated, and has over 700 Karma points.
Send a message via Skype™ to automoto
Re: Gage R&R Form in Excel for Calculating Gauge R&R - Attached

Quote:
In Reply to Parent Post by Mr.Happy View Post

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

__________________

Quality is returning of the customers and not products...
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)

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
How often do you have to repeat a Gage R&R study? phomer Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 27 1st July 2013 07:44 AM
Type 1 Gauge (Gage) R&R Excel Template anyone? wrekin Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21 16th February 2012 08:21 PM
Gage R&R / Inspection Sheet - Example Excel .xls Templates Attached D2theave Excel .xls Spreadsheet Templates and Tools 38 17th November 2011 02:39 PM
Gage R&R Excel .xls form and SPC Xbar and R template (lost it.. ) TownDawg Excel .xls Spreadsheet Templates and Tools 13 28th July 2009 06:43 AM
Gage R&R Form - Excel or other - Calculations Questions IGORTS Excel .xls Spreadsheet Templates and Tools 13 19th October 2006 07:57 AM



The time now is 09:03 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