Specify column types

For GainSeeker to correctly analyze your data, you will need to identify the type of data in each relevant column.

You will need to specify at least one Data column. Columns with no specified data type will not be included in analysis.

A column that contains part numbers or characteristics can be designated as the Part Number column, even if standards do not exist for these part numbers or characteristics. New temporary standards will be created for those items for which standards have not already been defined.

There are two ways to specify the type of data in a column:

• Right-click any row in a column. Point to Column Type  >, and then click the data type that should be used to analyze this column.

–or–

• Click an item in the Column Type list and drag it to the grid column. The new column header displays for that column. Any column header that may have previously been assigned to that column now displays in the Column Type list.

• If the first row of information copied to the Clipboard contains column headings that also appear in the Column Type list, these headings will be automatically set as the column types.

• If multiple columns contain numeric data values that will be used to calculate statistics, you should set the Column Type to Data for each of these columns.

To remove the Column Type designation from a column:

• Right-click the column and then click Clear Column Type. Columns with no data type specified will not be included in analysis.

Related Topics

• Accessing external data from the Clipboard