Gage R&R Excel add-in

I have created and verified an Excel add-in that allows you to quickly and easily calculate results for the most common type of Gage R&R study – a Gage R&R ANOVA crossed study. If you can use Excel, you will find it very easy to use straight away.

The download includes an example spreadsheet and a user guide. The add-in uses the industry standard Gage R&R ANOVA calculations, from the AIAG MSA Manual, exactly the same calculations that Minitab uses. I’ve verified it by running datasets through my add-in and Minitab, confirming that they always get the same results. I do charge a small fee of $20 for this one, just to help cover the cost of running this free metrology information site. You can click here to buy it for instant download.

Once the add-in is activated, the Gage R&R functions work just like any other function in Excel. You start typing =grr into a cell and a list of relevant functions appears, just like the native Excel functions. Select from the list to see more information about what each function does.

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

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 entries as the measurement values column. If there is any mistake, this is flagged and results are not given until it is corrected.

To get started, I suggest you look at the example spreadsheet, then import your data into it. Once you understand that, you’ll be able to easily use the Gage R&R functions in any spreadsheet.

Gage R&R in Excel add-in screenshot
This is a screenshot of the included example spreadsheet