Featured Resource

I had occasion recently to think about Gage R&R studies. This is something on which I've always had a statistician's help. But statisticians aren't always right there when you need them. So after poking around a bit for free help online, I came across a couple of templates to do the analysis in a spreadsheet.  http://www.mri-inc.com/downloads.htm has several statistical spreadsheet examples available in addition to the R&R, and http://www.microptix.com/gage_r_r.html gives an example with the results for the company's equipment.

While these spreadsheets show a standard setup, they don't give any detail about the results and calculations, other than the standard names for things that the statisticians know (xbarbar, rp, and so on). (What do you expect from free stuff? If you end up doing this sort of thing often, you'll want to spring for some real software anyway.)

Neat spreadsheet tool : Chart Converter

This is a really handy Excel add-in that takes Excel charts and converts them to image files -- .gif or .jpg. This is super handy for when you want to include spreadsheet charts in files you are sharing, where you'd like to share the chart but not the underlying data. I use them in presentations and reports, both to keep any calculations from getting out and to keep the file size down for e-mailing. The only hitch, really, is that the name of the chart is always the Excel name ("Chart 1", "Chart 2," etc.) and not descriptive at all. It's confusing when one "Chart 2" overwrites another in the save directory. But I end up inserting them in a report right away anyway, so this is a minor inconvenience.

Find the add-in on the xl-logic page.