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

  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

 


Attribute Gage R&R Video Tutorial


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

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

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