Exporting experiment data
If you need to analyze the experiment data, you can export it to an Excel spreadsheet.
To export the experiment data
Select the experiment you would like to export the data from in the sidebar.
Click the Export to Excel button 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.
In the dialog, specify the name and location of the .xlsx file and click the Save button.
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:
This 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.
Tutorial: Exporting a model to