Format of the Excel Interface Spreadsheet

The Excel Interface spreadsheet can be generated in two formats: Item Type and Item Group. Each format has a different set of worksheets:

• If a spreadsheet is in the Item Type format, data for each item type that was exported is displayed on its own worksheet.

• If a spreadsheet is in the Item Group format, item type data is grouped into item categories: pipes, instruments, equipment, valves, line fittings, reducers, nozzles and offsheet connectors. There is a worksheet for each category.

In both formats, there is also a worksheet for drawing data.

Note: In the case of exported instrument valves, the valve components of the instrument valves will be exported to the Valve worksheet, and the instrument components to the Instrument worksheet.

The format is selected in the Excel Interface Configuration Category of the AVEVA P&ID Project Administration program.