Exporting simulation results

You can export the results of a Multiple-case simulation as XLS (Microsoft Excel) files. To export the results, click the Excel Export button below the simulation tiles. An Excel (XLS) file is generated. The file is saved to your browser's download folder.

The following tabs are available in the Excel file:

  • Overview

  • Costs

  • Total cost charts

  • Total time charts

  • Resource consumption

  • Bottlenecks

  • Bottleneck charts

  • If more than one simulation scenario was executed, the Excel file includes two extra tabs, one for each scenario run in the simulation.

If you are using Microsoft Excel 2010, make sure to deactivate the Protected View, by clicking Enable Editing to make sure the spreadsheet is displayed correctly.

If there are problems with displaying the charts in the report, check if you have opened the report with a program that allows the editing Excel diagrams. If this is not the case, we recommend to open the report with one of the more recent versions of Microsoft Excel.

Overview

The Overview tab contains general information about the simulation runs.

Costs

The Costs tab displays the minimum, maximum and average costs of the simulation runs and task executions.

Values that are especially high are highlighted according to the layout displayed below the calculation table in the sheet.

The same layout applies to the other calculation tables as well.

Total costs charts

The Total cost charts tab visualizes the cost relation of executed tasks in the latest runs. If multiple runs were executed the latest and previous runs of total costs data display in the tab.

Total cycle time

The Total cycle time of a process instance measures the time between process start and process completion. The tab shows process instance cycle times and activity execution times:

Total time charts

The Total time charts tab visualizes the data of the Total cycle time tab. If multiple runs were executed the latest and previous runs of the total cycle time data display in the tab.

Resource consumption

The Resource consumption tab contains information about all Resources (lanes) which where occupied with a task and displays their workloads in relation to reach other:

Resource consumption charts

The Resource consumption charts tab visualizes the data of the Resource consumption tab. If multiple runs were executed the latest and previous runs of the resource consumption data display in the tab.

Bottlenecks

The Bottlenecks tab contains information about process bottlenecks:

Bottlenecks charts

The Bottlenecks charts tab visualizes the data in the Bottlenecks tab:

Scenario tabs

The last two tabs contain information about each scenario's properties: