Add a New Datasheet Definition

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.

To add a new Datasheet definition to the project catalogue:

1. With the Datasheet Form Catalogue Grid grid open, click New in the Records section of the Home tab.

2. The Select Form Type window in then displayed:

   

3. Select the type of datasheet definition to be created and click Save.

   Select DataSheet to create a form for instrument datasheets. Select Other to create a form for other types of document that can be generated for instruments, such as calibration sheets, maintenance documents etc. Front Sheets and Summary Sheets are used when datasheets are merged into a single documents (refer to Merge Datasheets into a Single Document).

4. The Catalogue Information window is then displayed.

   

   The version of the Catalogue Information window displayed above is displayed if the selected datasheet definition type was DataSheet. If the selected type was Front Sheet or Summary Sheet, a different version is displayed:

   

   Note:
   The ... button at the end of the File Name field can be used to locate any existing spreadsheet file and to copy the selected file to the project datasheet template folder. Any Excel file can be used, including Excel workbooks with multiple worksheets.

The template folder for the current project is listed in the Project Data window, accessed by selecting Edit Project in the Project tab.

To Copy an Existing Form Definition

A new form definition can be copied from any other form in the current project or from another AVEVA Electrical project.

To copy an existing form select the Copy Definition button to display the Copy an Existing Datasheet form definition window, used to select an existing datasheet form. Refer to Copy Existing Datasheet Definition for details.

Manually Create a New Form Definition

5. Enter a name for the new form in the Form Name field.

6. Enter a useful Description for the new form.

7. The Max No. of Plant Connections field is not relevant to AVEVA Electrical.

8. Enter the Number of Tags that will be detailed on this form.

   Note:
   The Max No. of Plant Connections and Number of Tags fields are not relevant to Front Sheets and Summary Sheets and are not displayed when they are being defined.

9. Enter the Excel spreadsheet file name in the File Name field. The file must exist in the Project Datasheets template directory.

10. Select the file format (.xls or .xlsx).

    Note:
    The ... button at the end of the File Name field may be used to locate any existing Excel file. The file will then be copied to the template folder for the AVEVA Electrical project and renamed to match the form name entered in this window.

11. Enter the spreadsheet cell dimensions (No. of Columns and No. of Rows). These are used to limit the view of each template to those dimensions. This restricts viewing to the number of columns and rows entered here.

12. From the Equipment Type list, select the equipment type of items to be specified on this datasheet. The equipment type is used to automatically match equipment from the Loads and Supplies lists with the form type definition.

13. This is not relevant to Front Sheet and Summary Sheet definitions and therefore the field in question is not displayed.

14. If the Other form type was selected, the field default to the "Other" principle of operation. A different principle of operation can be selected if required (this will not change the form type).

15. Click Save to save the definition information or Cancel to exit without saving.

Note:
The spreadsheets used for form definitions may include checkboxes. However, checkboxes will not be displayed in the AVEVA Electrical, for example, in the Datasheet Design window or the Datasheet viewer window. Checkboxes therefore must be replaced with a picklist with values of True and False only. Refer to Checkboxes on Datasheets for further information.