This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
exporting_parameters_to_excel [2023/03/03 14:52] daria |
exporting_parameters_to_excel [2023/04/10 09:46] (current) daria [Export window] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Exporting | + | ====== Exporting |
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. | 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 [[Excel_parameter_format|Excel parameter format]] defines the data structure that must be used for Ecolego to be able to import values from Excel. | ||
The concept of [[Sub-system|sub-systems]] is not realized in the [[Excel_parameter_format|Excel parameter format]]. Instead [[Tag|tags]] and [[excel_parameter_format# | The concept of [[Sub-system|sub-systems]] is not realized in the [[Excel_parameter_format|Excel parameter format]]. Instead [[Tag|tags]] and [[excel_parameter_format# | ||
+ | |||
+ | Any block may be exported to Excel. | ||
+ | |||
+ | Most common blocks for exporting to Excel are : [[Parameter|Parameter]], | ||
===== Export window ===== | ===== Export window ===== | ||
- | {{:ExportToExcelWindow.png}} | + | {{:export_to_excel.png?800|Export window}} |
- | To export values, select **File|Export|Export Values 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 [[Parameter|parameters]] and [[Lookup_table|lookup tables]] in the [[Model|model]]. By using the arrow buttons to the right of the list, model parameters can be selected for each Excel sheet. | + | 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 [[Parameter|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. | 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. | ||
+ | |||
+ | {{: | ||
==== Setting up the Excel workbook ==== | ==== Setting up the Excel workbook ==== | ||
{{: | {{: | ||
+ | |||
By clicking the {{: | By clicking the {{: | ||
==== Selecting parameters ==== | ==== Selecting parameters ==== | ||
- | {{:ExportModel.png}} | + | |
- | The list to the left of the window displays all [[Parameter|parameters]] and [[Lookup_table|lookup tables]] of the current project. Below the list a field allows you to search for [[Block|blocks]] with a specific name. By clicking the **more** button, more search options are shown. | + | {{screenshots:export_model.png|Selecting parameters}} |
+ | |||
+ | The list to the left of the window displays all [[Parameter|parameters]] and [[Lookup_table|lookup tables]] of the current project. Below the list a field allows you to search for [[Block|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. | Use the arrow buttons to move parameters to or from the currently visible sheet. | ||
+ | |||
+ | |||
+ | ==== Select options ==== | ||
+ | |||
+ | Click the **…** button to open Celect options tab. | ||
+ | These options relate to synchronization information stored with each parameter value. More information available [[Synchronizing_parameters|here]]. | ||
+ | |||
+ | * **Add tag(s) for sub-systems** - Add a tag for each sub-system of the parameter. These tags can later be used when importing data back to the model. | ||
+ | |||
+ | * **Add tag for scenario** - Add a tag for the scenario of the parameter. This tag can later be used when importing data back to the model. | ||
+ | |||
+ | * **GUID**. The [[excel_parameter_format|GUID]] represents a strong link between the value and your model, and will remain even if the parameter is moved or renamed in the model. | ||
+ | |||
+ | * **ID** - Export block with ID (// | ||
+ | |||
+ | * **Type** - Add column with type of block exported to Excel. | ||
+ | |||
+ | * **Tags** - Add a tag for each of the blocks. | ||
==== Export options ==== | ==== Export options ==== | ||
- | Click the **…** button to select a name and location for the Excel file. To save the file with a Office 97 format, use the extension .xls. To save the file with a Office 2003-2010 format, use the extension .xlsx. | + | Click the **…** button to open Export options tab. |
* **Export empty rows** - When selected, rows will be added for indices even when no values are available. Select this option when you wish to export a template for somebody else to fill in. | * **Export empty rows** - When selected, rows will be added for indices even when no values are available. Select this option when you wish to export a template for somebody else to fill in. | ||
+ | * **Export default value for empty rows** - When selected and default value is presented, default value will be applied to all indeces. | ||
+ | * **Export default indices** - When selected and default value is presented for indeces, default value will be applied to all dependencies. | ||
+ | * **All definitions on first page** - when selected in Excel file will be presented first page with all definitions. | ||
* **Open file after export** - When selected, the file will be opened in Excel after the export has completed. | * **Open file after export** - When selected, the file will be opened in Excel after the export has completed. | ||
* **Optimize column widths** - Adjust the size of each column to fit its width to its data. For large files, this option can be very time consuming. | * **Optimize column widths** - Adjust the size of each column to fit its width to its data. For large files, this option can be very time consuming. | ||
- | ==== Select options | + | ==== Properties |
- | These options relate | + | Click the **…** button |
+ | 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. | ||
- | * **Add tag(s) for sub-systems** - Add a tag for each sub-system of the parameter. These tags can later be used when importing data back to the model. | ||
- | * **Add tag for category** - Add a tag for the category sub-system of the parameter. This tag can later be used when importing data back to the model. | ||
- | * **Add GUID**. The [[excel_parameter_format|GUID]] represents a strong link between the value and your model, and will remain even if the parameter is moved or renamed in the model. | ||
===== Finalizing the export ===== | ===== Finalizing the export ===== | ||
- | Once you have selected a name and location for the Excel file, the **Export** button | + | Click the **…** button |
+ | |||
+ | |||
+ | 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. | ||
===== See also ===== | ===== See also ===== |