Export to Excel

We provide the option to export data from a driver model to Excel. Only scenarios that have been executed will appear in the exported Excel document.

There are three ways to perform an export of VDM scenario data to Excel:

  • Model: Exports all studies and their associated scenarios to Excel. Only exported scenarios will appear in the Excel document. Application - Export to Excel Application - Export to Excel

  • Study: Exports an individual study and its associated scenarios to Excel. Only exported scenarios will appear in the Excel document. Study - Export to Excel Study - Export to Excel

  • Scenario: Exports an individual scenario to Excel. This is performed by right-clicking the scenario and selecting Export Scenario to Excel. Note that this option will only appear if the scenario has been executed. Scenario - Export to Excel Scenario - Export to Excel

Note

Calculation nodes do not appear in the exported Excel document by default. For these nodes to appear, they need to first be published to the research grid. This can be done as follows:

  • Go to Properties for the calculation node as shown in the image below. Calculation Nodes - Properties Calculation Nodes - Properties
  • Ensure Publish to Research has been ticked. Calculation Nodes - Properties Calculation Nodes - Properties