Gage R&R on multiple measurement columns

This macro performs a Gage R&R analysis on multiple measurement columns, using the same part and operator columns. Tolerances can be specified for each measurement column.

Download the Macro

Be sure that Minitab knows where to find your downloaded macro. Choose File > Options > General. Under Macro location browse to the location where you save macro files.

Important

If you use an older web browser, when you click the Download button, the file may open in Quicktime, which shares the .mac file extension with Minitab macros. To save the macro, right-click the Download button and choose Save target as.

Download GAGELP.mac

Required Inputs

Multiple columns of measurement data
A column of part indicator values
A column of operator indicator values

Optional Inputs

LSL C: Use to specify a column of lower specification limits.
USL C: Use to specify a column of upper specification limits.

Specification limits

If you specify 5 measurement columns, then the columns that contain the specification limits should contain 5 rows, one specification limit for each measurement column. The row order of the specification limits is the order of the columns after the macro command. For example, if the first measurement column is C5, then the specification limits for C5 are in row 1. If any process is missing lower or upper limits, then enter a missing value symbol for that limit (*).

Running the Macro

Suppose you have 5 columns of measurement (response) data in C5-C9. The part indicators are in C3, and the operator indicator is in C4. To run the macro, choose View > Command Line/History and type:

%GAGELP C3 C4 C5-C9

Click Run.