Editing instrument and signal data in Excel

After you have retrieved instrumentation configuration from SPI and saved it to the DeltaV database from the Data Manager you can edit the following items in Excel. Other rows and columns are visible, but do not edit them or delete them from the worksheet. To edit user-definable columns that are not included in the table (node, card, and channel, for example) it is more efficient and easier to make changes in DeltaV Explorer, then reload the controller into the worksheet.

Row Type	Columns	Editing method in Excel
channel	enable	Select True or False
	description	Text entry
	dst	Text entry
fieldbus device	device	Text entry
	address	Select from list
	description	Text entry
	backup link master	Select True or False
	alarms enabled	Select True or False
Conventional Instrument⁽¹⁾	description	Text entry
	device
	manufacturer
	device type
HART Instrument	description	Text entry
	device	Text entry
	manufacturer	Select valid name from list
	device type	Select valid name from list
	revision	Select valid name from list
Signal⁽¹⁾	description	Text entry
Signal⁽¹⁾	enable	Select True or False
Signal parameter⁽¹⁾
	value	Text entry
	0% of scale	Enter floating-point number
	100% of scale	Enter floating-point number
	engineering unit	EU Dialog
	Alarms	Text entry
	Option Bits	Option Bit Entry Dialog

⁽¹⁾ These items can be edited only in the Excel worksheet.

Note

Option bitstring values are shown in the Excel workbook as an unsigned 16-bit integer. To edit a bitstring parameter (IO_OPTS for example), right-click in the value cell. A dialog appears from which you can select or deselect available options.