Apply Lookup Table Data to Equipment - Intergraph Smart Electrical - Help - Hexagon

Intergraph Smart Electrical Help

Language
English
Product
Intergraph Smart Electrical
Search by Category
Help
Smart Electrical Version
10

Lookup tables are data tables used to populate plant items singly or in batch with data values based on one or more key fields. Where the key fields exactly match the data for a particular item, the software copies the data from the matching row in the lookup table to the plant item. For example, you can select a number of motors in the Electrical Index and apply a selected lookup table for a motor with a particular motor rated power and rated voltage. The software will then populate the properties of the selected tables with appropriate values.

You can apply data from a lookup table to any type of equipment for which you have created a lookup table. Each lookup table is specific for an item type, such as transformers, and by selecting a key value for a lookup table, the software automatically populates the item with other properties that you defined in the lookup table.

You can also use lookup tables for the following special actions:

  • When you apply data using a lookup table, the software can overwrite existing data. Because this process is not reversible, you should proceed with great care.

  • 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.

  1. In the Electrical Index, expand the folder hierarchy by selecting the + icons or by double- selecting the folders.

  2. Navigate to the folder for the required equipment type and do one of the following:

    • Expand the folder and select an item from the list.

    • Select the folder, and in the list view pane, hold CTRL while you select more than one item.

    SHARED Tip You can also select more than one item by selecting a subset of item tags in the EDE.

  3. Select Tools > Apply Options.

  4. On the Apply Options dialog, select the Lookup Table tab.

  5. Select Enable lookup table.

    The default lookup table for the equipment type appears in the Lookup table box.

    You can select a different profile by performing the following steps.

  6. Beside the Lookup table box, select Find.

  7. On the Find dialog, select Find Now to display the available lookup tables.

  8. From the list of lookup tables, highlight the lookup table that you want to apply.

    SHARED Tip For each item property, the software overwrites existing values if the value of the Overwrite Option property in the lookup table is set to True. We recommend that you view the lookup table before applying the data to verify which properties the software overwrites.

  9. Select OK.