- Need Gage R&R results fast?
- No time to learn new software?
- No budget for expensive statistical software?
- Quick and simple: From download to results in five minutes
- Use the tool you already know – Excel
- Start immediately with included example spreadsheet
- Proven industry standard Gage R&R ANOVA calculations
- Excel results ready for Word or PowerPoint presentation
- Get ahead at work by making Gage R&R look easy
- Try it free with my Money Back Guarantee
Reliable Industry Standard Algorithms
Once the add-in is installed you will simply insert a single Excel Function. In the background the function performs all of the calculations specified in the Automotive Industry Action Group’s MSA Manual. This is the sources of the equations used by Minitab and most other software so the results you get will be the same as you would expect from any standard package. We’ve even validated this against minitab to show that the Gage R&R add-in gives exactly the same results for a range of data sets. Technically this add-in calculates variance components for a Gage R&R ANOVA crossed study.
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.
Once you’ve selected the function you need, tooltip help guides you to input your study data correctly.
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 ‘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.