Data File Layout
The file layout used by PERFORM is a rectangular grid in which each column represents a Variable or measure.
Data Configurations
There are multiple configurations that may be use for the layout of the data. Here are 5 alternative cases and the layout methods that may be used.
Case #2: Multiple Items or Measures per Sample, No Subgroups
Case #3: Single Items or Measures per Sample, One Process Stream Variable
Case #4: Single Items or Measures per Sample, Multiple Process Stream Variables
Case #5: Multiple Items or Measures per Sample, Multiple Process Stream Variables
Case #1: Single Items or Measures per Sample, No Subgroups
The data is set up in a single column as follows.
Measure |
---|
99.01 |
99.78 |
99.61 |
100.83 |
99.81 |
100.26 |
Case #2: Multiple Items or Measures per Sample, No Subgroups
Each sample is set up on a single row. For three measure per sample, the layout would be as follows.
M1 | M2 | M3 |
---|---|---|
58.56 | 57.30 | 58.14 |
58.68 | 61.44 | 58.86 |
60.54 | 57.36 | 58.08 |
60.00 | 61.20 | 59.22 |
58.98 | 60.00 | 59.88 |
61.38 | 58.74 | 59.70 |
Case #3: Single Items or Measures per Sample, One Process Stream Variable
Two methods may be used in this case. The first creates a column for each Level of the Process Stream Variable. In other words, one column for each stream. This would be done as follows for three tool positions.
Tool1 | Tool2 | Tool3 |
---|---|---|
15.3 | 17.3 | 16.0 |
18.3 | 17.5 | 17.1 |
17.5 | 15.1 | 15.8 |
19.0 | 16.1 | 18.9 |
15.1 | 15.8 | 12.6 |
15.0 | 15.3 | 12.8 |
The second method is to create a grouping variable. The grouping variables provide a reference for each row to designate the process stream. With the same data as above, the layout would look like this.
Tool | Measure |
---|---|
1 | 15.3 |
1 | 18.3 |
1 | 17.5 |
1 | 19.0 |
1 | 15.1 |
1 | 15.0 |
2 | 17.3 |
2 | 17.5 |
2 | 15.1 |
2 | 16.1 |
2 | 15.8 |
2 | 15.3 |
3 | 16.0 |
3 | 17.1 |
3 | 15.8 |
3 | 18.9 |
3 | 12.6 |
3 | 12.8 |
Case #4: Single Items or Measures per Sample, Multiple Process Stream Variables
This situation requires the use of grouping variables. A column for each process stream variable must be created. For two process stream variables this would be done as follows.
Press | Cavity | Measure |
---|---|---|
1 | 1 | 41.35 |
1 | 2 | 41.45 |
1 | 3 | 40.35 |
2 | 1 | 41.45 |
2 | 2 | 41.75 |
2 | 3 | 41.55 |
3 | 1 | 41.45 |
3 | 2 | 41.55 |
3 | 3 | 41.80 |
Case #5: Multiple Items or Measures per Sample, Multiple Process Stream Variables
This requires a column for each process stream variable with the multiple measures found on the same row. This would be done as follows.
Machine | Tool | Meas1 | Meas2 | Meas3 |
---|---|---|---|---|
1 | 1 | 4.80835 | 4.81007 | 4.80639 |
1 | 2 | 4.80684 | 4.80824 | 4.81270 |
2 | 1 | 4.81071 | 4.81144 | 4.81285 |
2 | 2 | 4.80724 | 4.80302 | 4.80467 |
3 | 1 | 4.81035 | 4.80992 | 4.81294 |
3 | 2 | 4.80436 | 4.80768 | 4.81109 |