Attribute Gage R&R Template in Excel

Compatible with AIAG MSA 4th Edition

Easy to Use Fill-in-the Blank Template

attribute gage r&r template input area

attribute gage rr template excel

When to Perform an Attribute Gage R&R Study:

  • Perform an Attribute Gage R&R Study when the measurement value has a limited number of possibilities.
  • This differs from a variables measurement system when you can have any number of possible results.
  • The most common example is a go/no go, pass/fail, gage that only provides two results.

Attribute Agreement Analysis

In instances where there is no objective measurement device like a gage, follow these procedures to conduct an attribute agreement analysis.

Step by Step Instructions for Using QI Macros Attribute Gage R&R Template

  1. Open QI Macros Gage R&R Template by clicking on QI Macros menu, then DOE Gage R&R FMEA and select Gage R&R.
  2. gage-rr-template-excel-menu

  3. Click on the Attribute Gage Worksheet to open the Attribute Gage Study Template.

    attribute gage r&r template input
  4. Input the Upper and Lower Spec Limits in cells N3:O3 of QI Macros template.
  5. input spec limits and reference values

    Code: This section indicates whether your Ref Value is within your Spec Limits (+) or outside of your Spec Limits (-). If you receive an (X), this means your Ref Value falls within the "Gray Zone."

    %R&R: This is the calculated value that is provided after you have run a Gage R&R Study
    (NOTE: Value is provided upon completion of a Gage R&R MSA 4th, Gage R&R 30 Parts, or Type 3 Gage R&R Study).

    Under 10%: Your measurement system is generally considered to be acceptable.
    10%-29.9%: Your measurement system MAY be thought of as acceptable.
    30% or Greater: Your measurement system is NOT considered acceptable.

    Gray Zone: This value is informed by the %R&R value and provides you with the "zone" (above or below your spec limits) of where "Bad Parts" can potentially be mistaken as "Good Parts" and vice versa.
    The above example's Gray Zone would be any Ref Value between 0.42625 and 0.450 (LSL - Grazy Zone), along with 0.545 and 0.56875 (USL + Gray Zone).

  6. Select 10 parts and measure them accurately using a variable gage to get a reference value for each. Enter the reference values in column L.
  7. The template will calculate if the reference value in column L is within the spec limits. If the value is within the spec limits, the corresponding cell in column K will be populated with a 1 (Pass). If the reference value is outside of the spec limits then K will be populated with 0 (Fail).

    If you do not have reference values to input in L, then input the reference for each part directly into K (1 for Pass and 0 for Fail).
     

    Tip: The 10 parts must have an actual reference value spanning unacceptable low to unacceptable high.

  8. Have 3 appraisers use the attribute gage to accept/reject 10+ parts with at least three trials.
  9. Enter pass/fail in columns B-J. 1 = pass (the value is between the spec limits) and 0 = Fail (value is outside of the spec limits). If the appraisers result differs from the reference result in column K, then the cell will be highlighted in red.

    pass fail comparison to reference values

Evaluate the Results Calculated by the Attribute Gage R&R Template

attribute gage r&R calculations

Kappa: The value used to compare two appraisers measuring the same parts:

    Kappa (maximum of 1) > 0.75 = Good to Excellent agreement
    0.40 < (minimum of -1) = Poor agreement

UCI: Upper Confidence Interval
LCI: Lower Confidence Interval

FREE QI Macros 30-Day Trial


Attribute Gage R&R Video Tutorial


Why Choose QI Macros Gage R&R Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • Compatible with AIAG 4th Ed.
  • 100,000 Users in 80 Countries
  • Five Star CNET Rating - Virus Free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support