Searching for Variables by Test Name

You can use the variable test name to retrieve test values for one or more variables for a specific event. If a selected variable is not part of the specified event, no value will be returned. If a selected event is not an event-based variable, "Variable Not Event Based" will be displayed in the associated cell.

To retrieve the test values, you need to first search for the variable test name.

The variable test name is also known as the variable alias name in the Variable Sheet.

To search for variable test names

  1. Open Excel and from the Plant Applications menu, point to Search and then click Test Variable Name.

  2. In the Test Variable Name Search dialog box, do one or more of the following:

  3. Server: If you need to select a different server, click the drop-down arrow and select a server.

  4. Production Line: Click the down arrow to select a production line.

  5. Production Unit: Click the down arrow to select a production unit. If you selected a production line, only the production units associated with the selected line will be available.

  6. Production Group: Click the down arrow to select a variable group. If you selected a production unit, only the variable groups associated with the selected production unit will be available.

  7. Test Variable Name Filter: Type any combination of numbers or letters. Keep in mind that the variable test names displayed will be those that contain exactly what you enter. As an example, let’s say that you have the following variable test names:

    50#Gloss, 50#Matte, 60#Gloss, 70#Matte, Alarm, Reelspeed

 

If you enter ?

You’ll get ?

5

50#Gloss

50#Matte

A

50#Matte

70#Matte

Alarm

E

50#Matte

70#Matte

Reelspeed

At

50#Matte

70#Matte

# a

No variables will be returned.

 

  1. Click the Search button.

  2. Under Selection Found , do one of the following:

  3. Select the variable test names you want to include on your spreadsheet and click the Move Selected button  to move the selected variables to the Selected Variables.

  4. Click the Move All button to move all of the variables to the Selected Variables box.

  1. In the Output Cell box, click the Collapse Dialog button and select the output cell on your spreadsheet. For more information, please see Selecting Cells for Output.

The selected output cell is where the first variable will be entered. Be sure to include an additional row or column for the headings.

  1. Click either the Columns or Rows option. For more information, please see Output Orientation.

  2. Click the OK button.

 

Now that you've selected your variable test name(s), you can retrieve test values for all the variables that share the same test name (variable alias name). See Retrieving Test Data by Test Variable Name.