Worksheet randomization for a gage R&R study or a Wheeler's EMP study

Randomize runs within operators

Suppose you have 10 parts, 3 operators, and 2 replicates (trials), for a total of 60 runs, and you want to randomize runs within operator. Operator 1 measures the first 10 parts, before Operator 2 measures the parts.

When you choose to also randomize operator sequence, any of the operators can be assigned to their measurements first, any of the remaining operators can be assigned to measure second, and so on. In this case, Operator 3 may be assigned to the first set, Operator 1 to the second set, and Operator 2 to the last set.

Randomize all runs

Suppose you have 10 parts, 3 operators, and 2 replicates (trials), for a total of 60 runs, and you want to randomize all runs. Each time you create another worksheet and randomize all runs again, you will have a different run order. Because randomization of all runs encompasses both sets of replicates, an operator may measure the second replicate of a particular part before all parts and operators have measured the first time.

Do not randomize

Suppose you have 10 parts, 3 operators, and 2 replicates (trials), for a total of 60 runs, and you do not want to randomize. The run order is listed sequentially, 1 through 60. The parts are listed in order for each operator, then the entire sequence is repeated for the second replicate.

Standard order

Standard order is the non-randomized order of the runs. If you choose to display the standard order of the runs, it will be stored in C1 and the other columns will be shifted.