Font size

Exporting Data to Excel

anyLogistix allows you to export data from your project to an MS Excel file. You can export:

To export scenario data to MS Excel file

  1. Right-click the required scenario and select Export.

    The Export dialog box will open.

  2. Select the scenario, that you want to export from the Select scenario drop-down list.

    The Select scenario drop-down list by default offers the scenario you right-clicked.

  3. Leave the selected Excel tab, since we are exporting to an MS Excel file.
  4. If required, change the name of the resulting file in the File name field.
  5. Disable the Export experiments toggle button if you do not wish to export the experiments of the scenario.
  6. Enable the Export empty data tables toggle button if you wish to export the empty tables of the scenario and the default parameters of the experiments into the MS Excel file.
  7. Click Export. anyLogistix Server Professional exports to the default system's download folder, while the desktop version allows you to specify the destination folder.

    If export takes too long, you can cancel it by right-clicking the scenario's tab and selecting Cancel export. This option is available only during the scenario export.

The exported file will contain the worksheets corresponding to the anyLogistix data tables as well as the scenario data.

To export a statistics page from experiment results

  1. Right-click the results page. A pop-up menu will appear.

  2. Select the required export option:
    • Export all data from this page — exports raw data to an MS Excel file. It is the source data generated by the experiment that is later processed to fill the BMW, histogram charts. So you will get much more data to analyze if you select this option.
    • Export plotted data from this page — exports data to an MS Excel file with the user-defined settings (as it is on the dashboard).

Scenario export exception

anyLogistix exports only the currently used data, i.e., the data that is or can be stored in the tables of the current scenario.

E.g. the result of the GFA experiment is converted to a new GFA scenario. This scenario apart from the data stored in its tables also considers paths between the objects (this data is generated as the result of the GFA experiment). Now, if you:

  • Convert this scenario to any other scenario type the Paths table will contain proper data derived from the GFA scenario.
  • Export the new GFA scenario to MS Excel file, the data on Paths will be lost, since there is no Paths table in the GFA experiment that could contain this data. The imported scenario will be operating as expected, but if you convert it to any other type, the Paths table will contain the default record, allowing connections from any location to any location.
How can we improve this article?