Working with Excel: Devices and Variables

A special ‘ID‘ column/row is required on all data sheets. This column/row tells Gen IT how to link together the data fields spread across multiple sheets. The ‘ID’ column/row must be identical between data sheets, and must not contain any duplicate values. The ID column/row entries are formatted as ‘ID:XX’

As of version 2.6, Device and Data sheets can use a column or row format. The format may be selected in the Settings -> Edit XLS Settings menu.

The function and content remains the same between the 2 options, but the content is rotated by 90 degrees.

See the included sample spreadsheets for examples.

*** The setting does not apply to Template tabs.