AnyLogic
Expand
Font size

Exporting experiment data

If you need to analyze the experiment data, you can export it to an Excel book or text file containing raw JSON.

To export the single experiment data to Excel

  1. Select the experiment you would like to export the data from in the sidebar.
  2. Select  Download results >  XLSX: Experiment on the experiment toolbar. Depending on how you have configured your browser, the file will be either downloaded automatically in the location you specified beforehand, or the Save As dialog box will open up.
  3. In the dialog, specify the name and location of the XLSX file and click Save.

The exported file contains the following sheets:

  • Model Version — The general information on the model (as provided in the General section of the AnyLogic Cloud model screen) and the experiment:

  • Inputs — The detailed information on the experiment’s inputs and settings:

  • Outputs — [Available if the experiment has been run before exporting the data] The overview of the experiment’s outputs data. If the output holds a single value, it will appear in the corresponding cell. If the output holds a data set, you will see the <Data> link, which leads to the separate sheet containing the detailed data for the output:

    sheet also contains the information on the output dashboard layout, such as names of sections specified by a user, locations of separator lines, and so on.
  • Outputs sections — [Available if the experiment has been run before exporting the data] The detailed data for the experiment outputs that hold the data in the form of data sets:

    Data may also be represented visually, in the form of modifiable Excel charts.

To export data about all experiment runs to a text file containing raw JSON

  1. While on the experiment screen, select  Download results >  JSON: All runs on the experiment toolbar. Depending on how you have configured your browser, the file will be either downloaded automatically in the location you specified beforehand, or the Save As dialog box will open up.
  2. In the dialog, specify the name and location of the JSON file and click Save.

The resulting JSON file contains data about inputs and outputs of all experiment runs in the raw JSON format.

Due to specifics of AnyLogic Cloud internal logic, all experiments that imply multiple runs are present in JSON as sequences of individual objects. Each such object represents a single run. Currently, such objects do not comprise an object containing all associated runs of a multi-run experiment.
How can we improve this article?