The following procedure explains how to modify an existing lookup table.
-
In the Reference Data Explorer, expand the Lookup Tables folder by selecting the + icon beside the folder.
-
Expand the lookup table folder for the required item type.
-
Right-click the required lookup table and on the shortcut menu, select Common Properties.
-
On the Lookup Table Properties dialog, select the Structure tab to determine the item properties that you want to use for applying data.
To define the lookup table as the default for the current item type, select Set as default.
-
Select Add to add a new property line to the lookup table definition.
-
Under Edit, select in the Property list the required property to use for the lookup table.
It is good practice not to include calculated properties in lookup tables. For example,
if the Supply AC/DC Flag property for a motor is set to DC, and you try to select a value for the Frequency property, you cannot apply this value and the software rejects the operation. You
must first set Supply AC/DC Flag to AC, and only then you can apply the lookup table value for the Frequency property to the motor.
-
If required, modify the caption text for the header that appears on the Data tab. The default is the property name.
-
From Input-output value, select Input if you want to define the property as a key field - otherwise, select Output.
-
The software uses key field values to identify the data to update using the appropriate values for the output fields.
-
The software treats read- only data as input only, and the Input-output value property is disabled for such data.
-
-
From Overwrite option, select True if you want to overwrite existing data when you apply the lookup table values, or select False to insert the values only where no data exists previously.
-
Repeat the preceding steps for as many other properties as you require.
-
If required, change the order of the properties under Definition by selecting an individual property and selecting Up or Down.
The order of the properties affects how they are arranged on the Data tab. It is usually convenient to arrange the input properties at the beginning, followed
by the output properties. For more details, see Lookup Table Structure Example.
-
Select the Data tab and enter data values for the required properties.
-
Enter data values for the properties that you require on the blank line.
-
You can right-click individual cells to copy and paste data. To copy and paste entire rows of data, select the source row and select Copy Row. Next, select the target row and select Paste Row.
-
Ensure that each combination of data in the key fields is unique. If you enter duplicate key fields in two rows, the software displays a warning message and highlights the duplicate row so that you can modify he input data. For more details, see Lookup Table Data Example.
-
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.
-
-
Repeat the previous step for each set of data required.
-
You can define as many lookup tables as you require for a particular item type.
-
There are three specific lookup tables for conductors that cannot be deleted: Conductor Material Coefficients, Conductor Insulation Temperatures, and Conductor Area cmils. These tables contain typical values for some of the most common conductor materials and conductor insulation materials. You should check these typical values and make sure they comply with and match the values used or specified by local codes or cable manufacturers. The software uses the data in these lookup tables for short circuit cable sizing and you should add appropriate data for any additional conductor material or insulation if needed.
Do not change any of the values on the Structure tab for the conductor lookup tables.