Accessing External Data from the Clipboard

From the GainSeeker Charts module, you can use the Windows clipboard to Copy and Paste external data for GainSeeker analysis.

 

Contents  [Hide]

 

Reading data from the Clipboard

Several steps are needed to correctly read data from the clipboard:

  1. Use the application best suited to your external data source to view a data set and copy it to the Windows clipboard.

    Whatever the source, this data must be limited to a single standard. For SPC data, this is one combination of Part Number + characteristic being measured. For DMS, this is one combination of Part Number + Process.

–or–

–or–

  1. In the GainSeeker Charts module, click the File menu. Point to External Data and then click Copied SPC or Copied DMS.

The data you have copied will display on the External (SPC or DMS ) Data from Clipboard window:

  1. Verify that the data to be analyzed is correctly displayed in the Data from clipboard list.

  1. If the data is not correctly displayed, use one or more of the following tools to correct the data:

The Enter Value dialog opens.

Enter the correct value in the text field and then click OK.

  1. If the Data from clipboard box displays any columns that should not be analyzed, you can hide these columns from display:

  1. Set the to the number of data rows that should be combined into one subgroup. For more information, see Number of rows per subgroup

  2. If one of the columns you specified is the Date/Time column, GainSeeker attempts to automatically determine the order of month, day, and year in the specified dates.

  1. If the selected Regional format does not match the date/time stamps in your data, select the correct format from the Date order drop-down list. Or if your date/time stamps are formatted in the GainSeeker format of "yyyymmddhhnnssxx," select this option.

  2. If you have not specified a column for Part Number, you must use the Part Number used if no column defined box to designate which standard to use. You may either choose a standard that already exists by clicking the ellipsis button and selecting an available listed standard, or you specify a name for a new temporary standard by entering it in the text field:

  1. After verifying your settings, click OK to proceed with data analysis. For instructions on analyzing this data, see Analyzing external data

Dividing columns and formatting text values

Based on the data you copied to the Clipboard, GainSeeker automatically attempts to determine where columns are divided and how text values are formatted. If the information that GainSeeker displays is not correct, you can configure these settings to match your data.

Characters that separate fields

Data copied from many data files and tables will use special characters—most commonly, tabs, commas, or spaces—to mark where one column ends and the next begins. For example, data copied from a spreadsheet in Microsoft Excel uses tab characters to separate columns.

It can be difficult to distinguish whether white space in the Data from clipboard box comes from spaces or tabs, a note on the right side of the External (SPC or DMS) Data from Clipboard indicates whether tab characters were detected in the first row of data.

Characters that qualify text

Some files and tables will use characters such as quotation marks (") to mark text fields while numeric fields simply contain a numeric value.