Differences

This shows you the differences between two versions of the page.

--- exporting_parameters_to_excel [2023/03/03 15:05]
daria [Exporting parameters to Excel]
+++ exporting_parameters_to_excel [2023/04/10 09:46] (current)
daria [Export window]
@@ Line 11: / Line 11: @@
 ===== 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.
+By clicking on **Toggle** button additional window will be presented. This window presents information about selected block.
+{{:toogle_export_excel.png?700|Toggle window}}
 ==== Setting up the Excel workbook ====
 {{:ExcelSheet.png}}
 By clicking the {{:New24.png}} 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.
 ==== 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.
+==== 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 (//Sub-system name.Name of block//).
+  * **Type** -  Add column with type of block exported to Excel.
+  * **Tags** - Add a tag for each of the blocks.
 ==== 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 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.
   * **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 to synchronization information stored with each parameter value. More information available [[Synchronizing_parameters|here]].
+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.
-  * **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 =====
-Once you have selected a name and location for the Excel file, the **Export** button will be activated. Click the button to finalize the export and close the window.
+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.
 ===== See also =====

Ecolego Wiki

User Tools

Site Tools

Differences

Page Tools