Worksheets in EXCEL

Top  Previous  Next

The first worksheet contains the definitions of different screen pages, the objects, actions etc. and the associated variables. Other worksheets are provided for additional information, e.g. about objects. These worksheets are automatically created if required.

 

The following worksheets are provided:

 

Worksheet type

Description

Number

Project

The Project worksheet is used to define all screen pages and their objects with attributes.

1

Text

The Text worksheet is used for managing multilingual project-specific texts.

1

UserVar

The UserVar worksheet is used for defining all variables.

1

UserColor

The UserColor worksheet contains the color names and color definitions.

1

Setup

The Setup worksheet contains different project settings and should not be changed.

1

DRVParam

The DRVParam worksheet contains the settings for the communication between EPAM and the PLC and should not be changed.

1

Hosts

The Hosts worksheet contains the settings for communication with different Codesys PLCs via Ethernet (TCP/IP).

1

RS7Hosts

The RS7Hosts worksheet contains the settings for communication with S7 PLCs via Ethernet (TCP/IP).

1

S

The S worksheet contains user-specific system variable groups (Hosts).

1

Alarm

The Alarm worksheet contains the alarm definitions of the Alarm object.

1 per alarm object

AlarmList

The AlarmList worksheet contains the definitions of the AlarmList object.

1 per AlarmList object

Datalog

The Datalog worksheet contains the variable definitions for the Datalog object. A Datalog worksheet is created for each Datalog object, and is referenced via the worksheet name.

1 per Datalog object

Message

The Message worksheet contains the definitions of the Message object. A Message worksheet is created for each Message object and is referenced via the worksheet name. However, several Message objects can also use the same Message worksheet.

1 per message object

Recipe

The Recipe worksheet contains the variable definitions for a recipe type. Several different recipe types can be defined in a project (e.g. product and machine parameters). The associated variable definitions are referenced via the worksheet names.

1 per recipe object

Trend

The Trend worksheet contains the definitions for the trend object. A Trend worksheet is created for each Trend object, and is referenced via the worksheet name. Several Trend objects can use the same Trend worksheet.

1 per trend object

Sys2PLC

The Sys2PLC worksheet contains the variable definitions for the Sys2PLC object. A Sys2PLC worksheet is created for each Sys2PLC object and is referenced via the worksheet name.

1 per Sys2PLC object

Fontmap

The Fontmap worksheet contains the font definitions (name, type, style...)

1

VBar

The VBar contains the definitions for the display of the VBar object

1 per VBar object

VMeter

The VMeter contains the definitions for the display of the VMeter object

1 per VMeter object




 

 

Attention!

 

The type of a worksheet is stored as a comment in the first cell (A1) and must not be changed or deleted.