Creating and Editing Tables

To create a new table, select the Alarm Tables folder, the Event Tables folder, the Historical Tables folder, or the Real Time Tables folder and click the New Table button. The appropriate Table Properties window will be displayed.

To edit an existing table, select the table and click the Properties button. The appropriate Table Properties window will be displayed. All items can be edited except the Table Name.

Alarm Table Properties

Type a new table name in the Table Name textbox. Type a description in the Description textbox. If you want the table to be included in the active list of tables, then check the Active checkbox.

Type an IP address in the IP Address textbox (e.g. 172.20.30.10). Click the Find Servers button. The Find Servers button will automatically find the available OPC Servers for the IP Address. The list of available OPC Servers will be displayed in the OPC Server Name drop-down list. Select the server you want to use from the drop-down list.

The Test button checks the connection to the selected OPC Server. A message will popup that tells you if a connection could be made to the OPC Server.

When you are finished entering the information for the new alarm table, press the Save button to save your changes.

The Data Groups Panel

The Data Groups panel is used to group data. It defines how the data will be displayed. There are three ways you can group data: by Date and Time, by Tag Value, and by Shift.

To group the data by date/time and shift, you would do the following:

• Check the Group 1 checkbox.
• Check the Date/Time option button.
• Select the Date/Time type from the drop-down list. You can select Date, Year, Month, Week of the Year, Day of the Week, or Hour of the Day.
• Check the Group 2 checkbox.
• Check the Shift Description option button.
• Click the Save button to save your changes.

The Tag Browser

Select a Tag Name from the appropriate folder and click on the Select button. The selected tag will appear in the Tag Value text box.

Creating and Editing Shifts

To create a new shift or to edit an existing shift, click the Edit Shifts button. The Configure Shifts window will open.

To add a new shift, click the New button. This will add a new row at the bottom of the Spreadsheet. Type the description in the Description cell. Type the start time of the shift in the Start Time cell. Type the end time of the shift in the End Time cell. Select the days included in the shift by checking the check box under each day of the week. Click the Save button to save the changes.

To edit a shift, select the cell you want to edit and follow the procedure for adding a new shift. Click the Save button to save the changes.

To delete a shift, select the row to be deleted and click the Delete button. A message window will appear to ask if you really want to delete the selected shift. Select the Yes button to delete the shift. If a shift has been used in any other tables, then that shift cannot be deleted.

Event Table Properties

The General Panel of the Event Table Properties window works the same way as the General Panel of the Alarm Table Properties window. See Creating and Editing Alarm Tables for more information.

The Event Triggers Panel

The Event Triggers Panel of the Event Table Properties window works the same way as the Data Groups Panel of the Alarm Table Properties window. See Creating and Editing Alarm Tables for more information.

The Event Acknowledgements Panel

The Event Acknowledgement Panel allows you to define an acknowledge tag for each trigger in the Event Triggers Panel.

To define an acknowledge tag for Acknowledge 1, you would do the following:

• Check the Acknowledge 1 check box.
• Click the Browse button. The Tag Browser window will open.
• Select a Tag Name from the appropriate folder in the Tag Browser window and click on the Select button.
• The selected tag will appear in the Tag Name textbox of the Event Acknowledgements panel.
• Type the Acknowledge Value in the Value textbox.
• Click the Save button to save your changes.

Historical Table Properties

The General Panel

The General Panel of the Historical Table Properties window works the same way as the General Panel of the Alarm Table Properties window. See Creating and Editing Alarm Tables for more information.

The Data Groups Panel

The Data Groups Panel of the Historical Table Properties window works the same way as the Data Groups Panel of the Alarm Table Properties window. See Creating and Editing Alarm Tables for more information.

Real Time Table Properties

The General Panel

The General Panel of the Real Time Table Properties window works the same way as the General Panel of the Alarm Table Properties window. See Creating and Editing Alarm Tables for more information.

Dropping Tables

Dropping a table deletes the table and all of the data in the table. To drop a table, select the table from the Table Tree, right-click the mouse to display the popup menu, and select the Drop Table menu item. A message will be displayed asking if you really want to drop the table. Click the Yes button to drop the table.

Creating and Editing OPC Tags

To create a new OPC Tag:

• Select a table from the Table Tree.
• Double-Click on the Tag Name cell and enter a tag name.
• Enter an OPC tag name in the OPC Tag Name cell.
• Select a data type from the Type drop-down list.
• Enter the scale factor into the Scale Factor cell.
• Enter the dead band value into the Dead Band cell.
• Click the Save button to save your changes.

To edit an existing OPC Tag, double-click on the cell you want to change and enter the new value. Click the Save button to save your changes.

To delete an OPC tag, select the row to be deleted and click the Delete button. A message window will appear to ask if you really want to delete the selected OPC tag. Select the Yes button to delete the OPC tag. If the OPC tag has been referenced in any other tables, then that OPC tag cannot be deleted.

To find an OPC tag in the OPC Tag Name spreadsheet, click the Find button. An input box will popup. Type the Tag Name you want to find in the textbox and press the Ok button. To find any Tag Name that starts with ‘emerg’, enter ‘emerg’ in the textbox and click Ok.

To find the next Tag Name that starts with the string ‘emerg’, click the Find Next button.