The Legend sheet defines the keywords that you can use in the Excel workbooks for reference data. This sheet also contains a description of what each keyword does. The Bulkload utility does not read or modify this sheet.
You can modify the format and content of the Legend sheet as needed. The only item that must remain unchanged is the name of the sheet.
Below is some suggested information to include on this sheet.
Keyword
Lists the keywords used on many part class sheets.
Meaning
Contains a description of each keyword.
Keyword |
Meaning |
---|---|
! |
Denotes comment text. The Bulkload utility ignores workbook rows that begin with an exclamation point (!). You can insert a comment anywhere in the workbook. |
Head |
Denotes the header row of the part data. The header row contains the names of the properties for the parts, not the actual values. The actual values are in the rows beneath this keyword, in the Start/End section. |
Start |
Denotes the beginning of the part data. This section contains actual values for the properties. |
End |
Denotes the end of the properties data for parts. The Bulkload utility ignores anything after the row marked with the End keyword. |
Definition |
Denotes the overall definition of the part class, including the part class type, symbol definition, and nozzle identification and types. The Definition section can contain occurrence attributes, which are properties that you can change for a specific part in the model. You define an occurrence attribute by entering oa: in front of the property name on the part class sheet in the workbook. These properties appear on the Occurrence tab of a Properties dialog box. |
SheetName (without the prefix R-) |
Denotes a worksheet name in the Excel workbook. |
ObjectName |
Denotes a unique object identifier. |
LikeThis |
Denotes a column heading. Italicize the column headings in the workbook. |
Nozzle(i):Type |
Denotes a nozzle type such as Piping or HVAC. The designation (i) is the nozzle number. The Nozzle(i):Type keyword appears in the Definition section of a part class sheet. |
Nozzle(i):XXX |
Denotes a nozzle property on the nozzle type or generic nozzle. Some properties that can be defined are NPD (nominal piping diameter) and end preparation. |
RelationSource |
Denotes the unique identifier for a source object. |
RelationDestination |
Denotes the unique identifier for a destination object. |
CreateTable |
Creates a codelist table in the database. |