Finding and selecting SPC standards

Click the Setup menu on the GainSeeker Charts window or the SPC Data Entry window. Then, click Standards... on the list that displays. The Select Part Number dialog opens.

Finding a standard in the list

Changing the sort order and scrolling through standards

To:	Do this:
Scroll through the list of standards	Click the scroll bar - or - Click one item in the list and then press the down arrow key - or - Click one item in the list and then type the first letter of the name of the standard
Change the sort order of the list of standards	Click the Part Number or Description buttons at the top of the list

Using the Search button

A quick way to find a part number in a long list is to use the Search button.

Type the first few characters of the standard name in the Part Number begins with text box. You can only search the items in the Part Number column, not the Description column.

Click Search. GainSeeker displays part numbers that begin with the alphanumeric characters you entered.

Restoring the full list of standards

To restore the full list of standards after you perform a search, delete any characters you entered in the Part Number begins with text box and then click Search.

More search tips

To narrow your search by uppercase or lowercase letters, select the Match case checkbox before clicking Search. This is only applicable to databases, tables, or columns on which the Collation is set as case-sensitive.

To search for standards that contain specific alphanumeric characters, but that do not necessarily begin with those characters, use the % wildcard character.

For example, to find all the standards that contain 34, enter %34 in the Part Number begins with text box. To find all standards that begin with D and that contain Length, enter D%Length in the Part Number begins with text box.

To search for standards that contain a value in a specific position in the standard name, use the _ wildcard character.

For example, to find standards:

D-34KW X-dimension, D-34KW Y-dimension, and D-34KW Z-dimension, enter D-34KW _-dimension in the Part Number begins with text box.

Restricting the list of standards by date or filter conditions

You can narrow the list of standards to those with data meeting a specific date range and/or filter criteria. For example, you may need to find only the part numbers that are in production this week, or those that can be traced to a particular work shift.

To reduce the list of SPC standards according to values in the data, click the Restrict button.

The Restrict List dialog opens. Use it to define a date period and/or filter for which to check for the presence of data for each standard. Click the button for each option to open the Date Period or Select Filter dialog.

For more information, see Setting the filter or Setting the Date period

If you use a filter to narrow the list of standards, some characteristics of the filter can greatly affect the speed of the search for standards that meet your criteria:

- When filtering on traceability field seven or greater, try to avoid the Doesn't equal and Doesn't contain tests if possible. These tests are processed more slowly than any of the others.
- A filter that combines testing for values in traceability field seven or greater with testing for values in the other fields (traceability fields one to six, Part Number, date/time stamp, corrective action, or bypass) will be processed more slowly than a filter that tests for only one of these two categories.

After you define a date period and/or filter, select one or both Restrict list to items containing... checkboxes and click OK, a narrowed list of standards is displayed. Additionally, the date period and/or filter for the retrieval is automatically set to match your restrict options.

Using the priority and full lists

If you have established user priority lists, click Priority to view the list.

If the standard you are searching for is not in the priority list, to switch to the full list of standards for further searching, click Full.

Selecting one or more standards (option available in only some parts of GainSeeker)

To:	Do this:
Select several standards listed in sequence	Use one of these methods: Click the first standard you want to select. Press and hold the SHIFT key. Scroll to the last standard and click on it. All standards between your first and last standards will also be selected. - or - Click the first or last standard you want to select. Press and hold the SHIFT key. Press the arrow keys on the keyboard to scroll up or down the list.
Select several standards not listed in succession	Press and hold the CTRL key. Click the standards you want to select
Select all the standards in the list	Click the Select all button. (This button is not available in all parts of GainSeeker.)

Finding and selecting SPC standards

Accessing the Select Part Number dialog

from the GainSeeker System Administration module

from the GainSeeker Charts module or SPC Data Entry module