Gage R&R Destructive Testing with One-sided Tolerance

Compatible with AIAG MSA 4th Edition Manual

Use the QI Macros Gage R&R Study Template to Perform Non Replicable Destructive Testing:

In brief, you should select your parts as follows:

  1. The samples for Part 1 (that will be repeated by a single operator, and those to be reproduced by another operator) should come from as nearly a homogeneous sample/batch as possible.
  2. The samples used as Part 2 should be from a different batch, different production run, or have sufficient time to allow long term variation to occur.
  3. Repeat for Part 3, 4, 5, etc.


The results will show some variation in equipment because of the variation in destructive tests.


The Gage R&R template will show that 20.7% for the %R&R means that the gage system may be acceptable (given destructive testing has occurred and we can't use the same part twice).

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



  • Only $279 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