Gage R&R Template for Excel
You Don't Have to be an Expert to Conduct a Gage R&R Study
QI Macros add-in for Excel provides an easy to use Gage R&R Template that:
- performs all of the calculations
- interprets the results (tells you if your measurement system is acceptable or needs improvement)
- is compatible with AIAG Measurement Systems Analysis - MSA, Fourth Edition
Gage R&R Study Methods used to Evaluate Your Measurement System
QI Macros Gage R&R template offers three main ways to evaluate your measurement system:
- Average and Range Method
- Specification Tolerance Method
- Anova Method
To begin, just drop your measurements into the yellow input fields.
This example uses sample data from the AIAG Measurement Systems Analysis Fourth Edition.
Then just scroll down to view the results.
Average and Range Method Results in the Gage R&R Template
- Key cells are shaded with yellow or red based on their values.
- A message regarding Gage System acceptability and recommendations are provided.
- NDC Calculation in row 52 indicates whether you have enough part variation for a valid test.
Specification Tolerance Method Results in the Gage R&R Template
Spec tolerance can be input into cell B:43. The calculations for % EV, % AV and %R&R using the spec tolerance are displayed in column C just next to the Average and Range method results in column B.
ANOVA Method Results
QI Macros calculations have been tested and validated against the AIAG MSA 4th edition. For more details view this Gage R&R validation test using Ford Motor Co data
QI Macros saved us a ton of time.
They take all the guesswork out of it.
- Richard Nardini, Apptec
Control Charts, Histograms, Scatter and Box Plots to Visualize Your Results
QI Macros template creates numerous charts to help you analyze the results. For more information about these charts refer to the AIAG MSA manual. Here are some examples:
The area between the UCL and LCL shows the "measurement sensitivity." More than half of the points should fall outside of the UCL/LCL which means the measurement system is adequate to detect part-to-part variation. Less than half means the system is inadequate.
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
- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry
Proven and Trusted
- Compatible with AIAG 4th Ed.
- 100,000 Users in 80 Countries
- Five Star CNET Rating - Virus Free