Specifies sets of data values for the properties defined on the Structure tab. You usually define the structure once, but you will probably add data quite often. The key values define the uniqueness of each row of data. When you apply a lookup table to a plant item and select a particular row, the software enters the values in that row for the appropriate properties of the plant item.
Lookup table tag
Allows you to enter a tag name that identifies the lookup table.
Set as default
Select to define this lookup table as the default for the specified equipment type when you apply a lookup table to a load.
-
Each time you define a row of data, the software adds a new blank row automatically at the end of the list. To define more than 17 rows, you have to do one of the following: increase the window size, maximize the window, close the window and then re-open it, or press the 'down arrow' key on the keyboard.
-
Each combination of data in the key fields must be unique. The software indicates key fields by double sets of asterisks (**) in the header labels. See Lookup Table Data Example.
-
For a 2- or 3-winding transformer, the Number of Secondaries property always appears by default as a key field. For a 2- winding transformer, it has a value of 1; for a 3-winding transformer, it has a value of 2.
-
You can split the view of the data columns by dragging or double-clicking the split box at the left of the horizontal scroll bar. This allows you to scroll the columns independently in each split region. To remove the split, drag the vertical divider to the left.
-
You can sort the rows of data according to a particular column by selecting the column header. Repeatedly selecting a column header displays the data in alternating ascending and descending order.
Remove
Removes the currently selected row of data.
Copy Row
Copies the data from the currently selected row to the Clipboard.
Paste Row
Pastes data from the Clipboard to the currently selected row. This action replaces all existing values in the row.
Excel Report
Select to display the data in this dialog in a Microsoft Excel file. This is useful if you want to format the layout or print out the data. Also, after correcting errors, you can use the Excel file as a data source for re-importing the data using the Import Manager.