anyLogistix anyLogistix
Expand
Font size

Exporting Scenario Data

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

To export scenario data to MS Excel file

  1. You may open the Export dialog by doing either of the following:
    • Choose File > Export Scenario... from the main menu or
    • Right-click the required scenario and select Export Scenario...

    • Press Ctrl + E

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

    if you right-click the scenario to export it, the Select scenario will automatically offer the required scenario to export.

  3. By default scenario is exported to the user profile folder. If required you can specify a custom folder by clicking the Browse button to the right of the Select file field.
  4. In the opened window select the destination and specify the file name that the scenario data should be saved to.
  5. Disable Save to save the changes and close the window. The pop-up dialog box will now contain full address to the specified file with its name.
  6. Disable the Export experiments toggle button if you do not wish to export the experiments of the scenario.
  7. Disable the Export external tables toggle button if you do not wish to export the external tables of the scenario.
  8. Enable the Export empty and default data toggle button if you do not wish to export the empty tables of the scenario and the default parameters of the experiments into the MS excel file.
  9. Enable the Open exported file option if you want the exporting file to be automatically opened once you export it.
  10. Click OK.

    If you are exporting to an existing file, you will see a warning message, prompting you to confirm your action.
    If you wish to proceed and overwrite the specified file click OK, otherwise click Cancel.

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

To export table data to MS Excel file

  1. Navigate to the table you want to export.
  2. Click # to select all cells.

  3. Press Ctrl + C to copy data values.
  4. Create or open the MS Excel file, to which you want to import the table data.
  5. Press Ctrl + V to paste data values.

To export a statistics page from experiment results

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

  2. Click the Export to excel option. A pop-up dialog box will open prompting to specify the file to export the data to.

  3. Click the Browse... button to the right of the Select file field to navigate to the file that you want to save the experiment results to.
  4. In the opened window select the destination and specify the file name that the results should be saved to.
  5. Click Save to confirm the changes and close the window. The pop-up dialog box will now contain full address to the specified file with its name.
  6. Click OK to export the data.

    If you are exporting to an existing file, you will see a warning message, prompting you to confirm your action.
    If you wish to proceed and overwrite the specified file click OK, otherwise click Cancel.

  7. Once the export is completed, a dialog box will pop-up asking if you would like to instantly open the file that you have just exported the data to.

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 (NO, SIM, TO) 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?