Details on “Synchronize Excel Room Data Sheet”
Information on the Synchronize Excel Room Data Sheet dialog.
In this dialog, you can configure the settings for synchronizing room data between LINEAR Building and Excel room data sheets.
When synchronizing with Excel room data sheets that are already linked, most of the settings are usually already preset correctly. Additional rows can be added at any time.
When transferring room data to Excel room data sheets for the first time, all relevant settings must be made. You can enter the names of the Excel columns in the Excel file of the room data sheet before the transfer so that you do not have to do this in the dialog.
You are here
Selected Room Data Sheet
Path of the Excel room data sheet that is used for synchronization. Clicking on 
opens the file explorer for selecting a room data sheet in Excel format. For room data sheets that are already linked, the corresponding file is already preset and can be adjusted if necessary.
Settings
Worksheet
Drop-down list for selecting the spreadsheet containing the Excel room data sheet data or the spreadsheet to which the room data will be transferred.
ID Column
Drop-down list for selecting the column in which LINEAR Building IDs for unique identification of the rooms will be written.
Header Row
Number of the row containing the Excel room data sheet headers or to which the column headers are transferred.
Data starting from row
Specifies the first row in the Excel room data sheet in which the room data sheet data, such as the areas of the individual rooms, begins or is transferred.
Table
In this table, you assign the room parameters for synchronization to the Excel columns. Click in an empty row or use the F5 key to add rows.
| Table Column | Description |
|---|---|
| Excel Column | Defines the name of the column in the Excel room data sheet or displays the name. For already linked Excel room data sheets and new Excel room data sheets with column headers, the column headers from the linked Excel room data sheet are displayed. If you add additional rows, you can then enter the names of the individual Excel columns. When transferring data to new Excel room data sheets without column headers, you define the names of the individual Excel columns in this column. |
| Room Parameters | Defines the room parameter assigned to the Excel column and used for synchronization. For Excel room data sheets that are already linked, existing entries retain their assignments by default. If you select a different Excel room data sheet for synchronization, suitable assignments are automatically set if they match the room data sheet columns of the last mapping.
|
| Unit | Shows the unit with which an assigned parameter is imported. The unit is only displayed here and can not be edited. |
| Option | Shows how a parameter is handled in the case of synchronization. A parameter can either always be imported from the Excel room data sheet, always only be exported to the selected Excel room data sheet, or synchronize the current value when a parameter is changed. This option can be adjusted for each parameter in the Configuration in the Synchronization section. |
: Opens a context menu for selecting the room parameter. You can also create new parameters using the context menu. This is necessary, for example, if you transfer data from an Excel room data sheet for which there are no matching Synchronization Configuration
Drop-down list for selecting the desired synchronization configuration. In the Configuration for LINEAR Building, you can determine in the Synchronization section which parameters are synchronized and how. You can save each custom synchronization configuration and then select it from this dropdown list alongside the default configurations.
: Opens the the Synchronization section in the Configuration of LINEAR Building.