1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hello and Welcome to The Quality Forum Online...Continuing in the spirit of People Helping People !
    Dismiss Notice
Dismiss Notice
You must be a registered member in order to post messages and view/download attached files in this forum.
Click here to register.

Gage R&R Excel Template required

Discussion in 'Gage R&R and MSA - Measurement Systems Analysis' started by Mukmetalman, Aug 18, 2015.

Tags:
  1. Mukmetalman

    Mukmetalman New Member

    Joined:
    Aug 18, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Does anyone have a good excel template for performing Gage R&R?
     
  2. Steve Kent

    Steve Kent Member

    Joined:
    Aug 3, 2015
    Messages:
    25
    Likes Received:
    25
    Trophy Points:
    12
    Location:
    UK
    Cannot remember where I found this and I've not validated it.

    Steve
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

  3. Mukmetalman

    Mukmetalman New Member

    Joined:
    Aug 18, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thanks Steve!
     
  4. Bev D

    Bev D Moderator Staff Member

    Joined:
    Jul 30, 2015
    Messages:
    342
    Likes Received:
    342
    Trophy Points:
    62
    Location:
    Maine
    Here is a spreadsheet for an alternative to the standard Gauge R&R (which has serious issues despite being recommended by AIAG and some fairly large Customers) along with a few documents explaining the approach and the limitations of the 'popular' approach.
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

    Atul Khandekar likes this.
  5. MCW8888

    MCW8888 Well-Known Member

    Joined:
    Aug 17, 2015
    Messages:
    637
    Likes Received:
    190
    Trophy Points:
    42
    Thank you
     
  6. MCW8888

    MCW8888 Well-Known Member

    Joined:
    Aug 17, 2015
    Messages:
    637
    Likes Received:
    190
    Trophy Points:
    42
    Thank you Bev
     
  7. MCW8888

    MCW8888 Well-Known Member

    Joined:
    Aug 17, 2015
    Messages:
    637
    Likes Received:
    190
    Trophy Points:
    42
    I found this one and used it for our bulk fluid MSA. For our purpose I recommended using the GRR situation #2.
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

    Mark Paul and Bazinga like this.
  8. Scott

    Scott Member

    Joined:
    Sep 1, 2015
    Messages:
    16
    Likes Received:
    9
    Trophy Points:
    2
    Location:
    UK
    Here are 2 that i used in a company previously - i haven't used them in a while but im sure they still work
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

  9. Bazinga

    Bazinga Member

    Joined:
    Aug 3, 2015
    Messages:
    21
    Likes Received:
    9
    Trophy Points:
    2
    Location:
    Grand Rapids, Mi
    Thanks Scott.
     
    Scott likes this.
  10. Flyingo

    Flyingo Member

    Joined:
    Oct 15, 2015
    Messages:
    5
    Likes Received:
    4
    Trophy Points:
    2
    Attached Excel File covers all Gage R&R Situations described in the AIAG MSA 4th
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

    MCW8888 likes this.
  11. MCW8888

    MCW8888 Well-Known Member

    Joined:
    Aug 17, 2015
    Messages:
    637
    Likes Received:
    190
    Trophy Points:
    42
    Thank you! This template is the one I recommend to use for my facility. the Nested ANOVA (Gage R&R #2) is the choice for "Thixotropic samples" (from a Cove member). Sample preparation is done by splitting the samples into 10 parts.
     
  12. umran_ca

    umran_ca New Member

    Joined:
    Mar 9, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    thanks :)
     
  13. Plague Doctor

    Plague Doctor Member

    Joined:
    Jan 19, 2016
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ukraine
    Can someone share a template of Nested GR&R for non-replicable measurements?
     

Share This Page