Working with Enumerated Sets Using Excel Add-In

Before importing enumerated sets into Historian from an Excel Worksheet, you can perform the following actions:

To add sets:

  1. Enter details in the following columns in the excel worksheet.

    It is recommended to fill the columns in the following sequence: SetName, SetDescription, StateName, StateDescription, StateLowValue, StateHighValue, StateRawValueDataType, and NumberOfStatesInThisSet.

  2. Select the Import Enumerated Sets to import the sets.

To delete sets:

  1. Select the row that has the state you want to delete.
  2. Right-select the row and select Delete.

    Alternatively, you can also use the Delete key on your keyboard.

To modify the description of a set:

Select in the StateDescription cell and modify the description.

You cannot modify the name of the set. If you change the name of the set, it is considered a new set.

To add states:

  1. Select the set to which you want to add a set.
  2. Add the name of the set in the SetName column.

    The name should be same as the set you selected.

  3. Enter the details in the SetDescription, StateName, StateDescription, StateLowValue, StateHighValue, and StateRawValueDataType columns.
  4. Enter the total number of states in the NumberOfStatesInThisSet column.

    Ensure that this value is the same for the current state and existing states in the set. For example, if a state has two states already and you are adding a third state, the number of states for all the three states should be changed to three.

    A new state is added to the set.

To modify states:

  1. Select the state you wish to modify by selecting the row in the Excel worksheet.
  2. Modify the values by selecting in the respective columns.

    The state/states are modified.

To delete states:

  1. Select the row that has the state you wish to delete.
  2. Right-select the row and select Delete.

    Alternatively, you can also use the Delete key on your keyboard.