Datasheet Form Catalogue

All Electrical Engineer datasheets are based on user-definable Excel Worksheets that are used as templates for each datasheet.

The Datasheet Form Catalogue contains all datasheet forms and their attributes, including:

• Name of datasheet type and its equipment type.

• Layout/Design (that means the name of Excel spreadsheet file).

• Database table(s) used to store data within the AVEVA Electrical database.

• Field definitions (one per spreadsheet cell is required).

• Spreadsheet cell to database field mappings (using AVEVA Electrical DataLinks).

The Catalogue Datasheet definition is complete when each cell in the datasheet is mapped to an AVEVA Electricall database field. Then when a project datasheet uses the Catalogue Datasheet all data entered into each datasheet cell can be saved to the mapped database field and any data changed in the database can be updated back to each datasheet cell.

Suggested Workflow to create a new Catalogue Datasheet Template

When a project datasheet is created, it is configured in accordance with a selected catalogue datasheet. The data mappings will populate the cells of the project datasheet with the required data from the project datasheet, both generic project data, and data specific to the item that is the subject of the datasheet. In turn, changes to data in the datasheet will automatically update the equivalent data in the database.

Suggested Workflow to create a new Catalogue Datasheet Template

1. The Excel spreadsheet layout must first be created in Microsoft Excel prior to adding the new template form to the AVEVA Electrical Datasheets Catalogue.

   The fastest ways to do this are to copy and modify an existing Datasheet spreadsheet provided with Electrical Engineer, or to copy and modify one previously created for the project.

   In completing the layout in Excel, pay attention to fonts, justification and merged cells to complete the ideal form for a particular instrument type. All physical attributes of the form including fonts, cell sizing/merging, cell formatting (bold, italics and justification etc.), print setup, margins, colours, shading etc. are controlled by this Excel template. There is no control of formatting/layout within AVEVA Electrical, which just transfers data between the spreadsheet cells and the AVEVA Electrical database.

2. Once new spreadsheet layout is complete, register it in the Datasheet Form Catalogue Grid (refer to Add a New Datasheet Definition).

3. Once the new Catalogue Datasheet template is registered, open this datasheet template in design mode from the Datasheet Form Catalogue Grid List and define map the datasheet cells to the appropriate database fields (refer to Map Database Fields to Datasheet Cells).

   This step enables AVEVA Electrical to update each cell with the required database data (and vice versa).

   Note:
   AVEVA Electrical can only save data to/from the project database/Excel workbook if a worksheet cell is mapped to a database field. Any other data will not be saved.

4. Finally, while in the design mode, assign picklists cells for more efficient data entry (see Assign a PickList to a Cell).

When this is completed, the new datasheet template is then ready for use on the project.