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 #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.

M1M2M3
58.5657.3058.14
58.6861.4458.86
60.5457.3658.08
60.0061.2059.22
58.9860.0059.88
61.3858.7459.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.

Tool1Tool2Tool3
15.317.316.0
18.317.517.1
17.515.115.8
19.016.118.9
15.115.812.6
15.015.312.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.

ToolMeasure
115.3
118.3
117.5
119.0
115.1
115.0
217.3
217.5
215.1
216.1
215.8
215.3
316.0
317.1
315.8
318.9
312.6
312.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.

PressCavityMeasure
1141.35
1241.45
1340.35
2141.45
2241.75
2341.55
3141.45
3241.55
3341.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.

MachineToolMeas1Meas2Meas3
114.808354.810074.80639
124.806844.808244.81270
214.810714.811444.81285
224.807244.803024.80467
314.810354.809924.81294
324.804364.807684.81109