exporting_parameters_to_excel
Differences
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/04/07 12:21] daria |
exporting_parameters_to_excel [2023/04/10 09:46] (current) daria [Export window] |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| ===== Export window ===== | ===== Export window ===== | ||
| - | {{: | + | {{: |
| To export values, select **File|Export|Export Blocks to Excel…**. | To export values, select **File|Export|Export Blocks to Excel…**. | ||
| Line 22: | Line 22: | ||
| By clicking on **Toggle** button additional window will be presented. This window presents information about selected block. | 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 ==== | ||
| Line 32: | Line 32: | ||
| ==== Selecting parameters ==== | ==== Selecting parameters ==== | ||
| - | {{:exportmodel.png|Selecting parameters}} | + | |
| + | {{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. | 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. | ||
| Line 50: | Line 51: | ||
| * **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. | * **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 ==== | ||
| Line 70: | Line 71: | ||
| Click the **…** button to open properties tab. | Click the **…** button to open properties tab. | ||
| - | This tab contains list of additional properties for all types of blocks may be exported. For eacg block type specific properties are presented and may be selected for export. | + | 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. |
exporting_parameters_to_excel.1680862865.txt.gz · Last modified: 2023/04/07 12:21 by daria
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
