Gage R&R Excel add-in

Have you every wished Excel had functions to perform a Gage R&R study? This easy to use Excel add-in gives you reliable and easy to use functions for Gage R&R.

Reliable Industry Standard Algorithms

This add-in provides the ability to calculate variance components for a Gage R&R ANOVA crossed study. It uses the equations given in the Automotive Industry Action Group (AIAG) Measurement Systems Anlysis (MSA) Manual. These are the same equations  used by Minitab. Validation of the Gage R&R Excel add-in against minitab has been carried out. This has shown that for a range of different input datasets indentical results are obtained.

Easy to Use with Context Sensitive Help

Once installed you simply type “=grr” into any cell on any Excel spreadsheet. You will then see a list of relevant functions appear, just like the native Excel functions. Select from the list to see more information about what each function does.

Built-in Excel help guides you to use the right Gage R&R function
Built-in Excel help guides you to use the right Gage R&R function

Once you’ve selected the function you need, tooltip help guides you to input your study data correctly.

Tooltip help guides you to input your Gage R&R Study data into the Excel function
Tooltip help guides you to input your Gage R&R Study data into the Excel function

Input validation ensures the inputs make sense, for example the part id column has the same number of entres as the measurement values column. If there is a mistake this is flagged and results are not given until it is corrected.

Easy to install

Once you’ve downloaded the add-in it’s really easy to install. Just unzip the file ‘GageRR.xlam’, load Excel and go to File > Options > Add-Ins.

Then click    Manage > Excel Add-ins > Go… to open the add-ins dialogue:

Click here to open the add-ins dialogue
Click here to open the add-ins dialogue

Click ‘Browse’ in the add-ins dialogue, select the file you just unzipped and ensure it’s checked in the list

Click browse in the add-ins dialogue, select the file you just unzipped and ensure it’s checked in the list
Click browse in the add-ins dialogue, select the file you just unzipped and ensure it’s checked in the list

Click OK and restart Excel. The functions will now be available to use and will give correct results. The tooltip help will not appear yet. For that you will need to install another add-in, ‘DNA-IntelliSense’ which can be downloaded for free and installed using the above process. And that’s it, you should be up and running within 5 minutes.

Please do support my paid downloads. They fund all of the free information you enjoy on this site. It’s also a lot lot cheaper than a Minitab licence!