Item Worksheets

The first column of every item worksheet is the HANDLE column. This displays the unique identifier of each item on the worksheet. This must not be edited.

Typical items are listed after the item that is typical of them. They will have the same handle as that of the representative item, followed by a #. The first typical item handle will be followed by a # only. Further items will be followed by a # and a number, for example, #1, #2 etc.

The second column of every item worksheet is the DRAWING column. This displays the number of the drawing on which each item is located. Changes made in this column are ignored.

Subsequent columns display item data for editing. For guidance on editing item data, refer to the Edit P&ID Data in an Excel Spreadsheet procedure.

The third column displays the drawing grid in which each item is located. The next three columns, if applicable to the category of item, display coordinates of the item and its angle of rotation.

For tagged items, the item tag numbers are displayed in the next column or columns, followed where applicable by the offset from the item and angle of rotation of the label.

Other columns include item types, the parent tags of nozzles, the upstream and downstream sizes of reducers, the drawing number that offsheet connectors reference, pipe attributes such insulation and paint codes, and instrument loop and alarm details.

A number of other fields, displaying additional item data for information are also included. These cannot be edited.