Gage R&R Template for Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

The goal of Gage R&R (repeatability and reproducibility) studies is to minimize the amount of variation and error introduced by measurement, so that you can focus on part variation.

The QI Macros Gage R&R template for Excel is actually made up of several different templates:

• Instructions Sheet - provides instructions for each template
• Gage R&R Study - includes the Average and Range Method and ANOVA Method
• Gage R&R validation using Ford Data
• Type 1 Gage R&R (1 part x 1 appraiser x 50 measurements)
• Range Method - Provides quick approximation of overall measurement variability.
• Bias - calculates the "bias" of your gage, using a "target" or "reference" value that you input.
• Linearity - calculates whether a gage over reads or under reads across a range of different sized parts.
  
• Attribute Gage Worksheet - for Pass/Fail gages
• Analytic Attribute Method - to assess the amount of repeatability and bias of a measurement system

QI Macros for Excel Gage R&R Study Template Screenshots

Gage R&R Study Input Sheet - using sample data from the AIAG Measurement Systems Analysis Third Edition.

Gage R&R Study Average and Range Method Results

Gage R&R Study ANOVA Results

Gage R&R Training Resources:

Gage R&R Video Series

Gage R&R Template Video

How to Perform a Gage R&R Study

If My Parts Are So Good, Why Are My Gage R&R Results So Bad?

Order the Gage R&R Template Separately

Order the Gage R&R Template as part of the QI Macros SPC Software for Excel

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!

To get formulas and a fuller understanding, order the MSA reference from the AIAG:
www.aiag.org

For a complete listing of AIAG books, go to:
aiag/publications

Keyboard Wedges & Gage Interfaces

WedgeLink keyboard wedges for transferring gage data directly into Excel