By exporting blocks values to Excel, data can be separated from the model structure. In larger projects this separation is common, as model development usually is the responsibility of a different group of experts compared to the gathering of input data.
The concept of sub-systems is not realized in the Excel parameter format. Instead tags and GUIDs are used to link parameters in the model with parameter data.
Any block may be exported to Excel.
Most common blocks for exporting to Excel are : Parameter, Time series, Lookup table. The Excel parameter format defines the data structure that must be used for Ecolego to be able to import values from Excel.
To export values, select File|Export|Export Blocks to Excel….
In the center of the window is a representation of an Excel file, with tabs for each Excel sheet. To the left is a listing of all parameters. By using the arrow buttons to the right of the list, model parameters can be selected for each Excel sheet. Under the list of available blocks for export by clicking on the button More are presented filters. In the Type pop-up menu is presented list of blocks types.
To the right of the window are fields that allow you to select the name of the Excel file as well as some control options.
By clicking on Toggle button additional window will be presented. This window presents information about selected block.
By clicking the button, to the right of the last tab, a new Excel sheet is added. The name of a sheet can be changed by clicking the tab.
The list to the left of the window displays all parameters and lookup tables of the current project. Below the list a field allows you to search for blocks with a specific name. By clicking the More button, more search options are shown.
Use the arrow buttons to move parameters to or from the currently visible sheet.
Click the … button to open Celect options tab. These options relate to synchronization information stored with each parameter value. More information available here.
Click the … button to open Export options tab.
Click the … button to open properties tab. This tab contains list of additional properties for all types of blocks may be exported. For each block type specific properties are presented and may be selected for export.
Click the … button at thw Select file window to select a name and location for the Excel file.To save the file with a MS Excel Office 97 format, use the extension .xls. To save the file with a Office 2003-2010 format, use the extension .xlsx.
Once you have selected a name and location for the Excel file click Export button the button to finalize the export and close the window.