Importing and Exporting Time Series Data from File

Results Files (*.res.csv)

Note: For simplicity, any loaded files (*.res.csv or time series) are called results.

Loading results

Results can be loaded into the Results Manager using:

The File menu;
The Results Manager toolbar; or
The equivalent Hot Keys (Figure 5).

There are several ways to load data:

Load Results Files – loads all *.res.csv files in a specified folder (even if there are other time series in the folder). This is non-recursive, ie. it does not load files within sub-folders. The loaded files are listed under Loaded Result Files at the bottom of the tree menu.
Load Time Series – loads any time series file type compatible with Source (refer to a complete list in Data file formats). Multiple files can be selected and imported at once. The imported files are listed under Loaded Time Series at the bottom of the tree menu. Just like data sources, if a file has multiple columns, all columns will be imported. Unlike data sources, there is no choice to only import some of the data columns.

To set units on loaded time series, select the time series file name. The right side of the Results Manager window will display the Unit Preferences options as shown in Figure 6 below. To select the preferred unit, click on 'no unit selected' and then choose from the list of available units.

Figure 6. Unit Preferences for Loaded Time Series

Exporting results

To export a result, result set or custom chart, right click on it in the tree menu panel and choose one of the two export options from the contextual menu:

Export Time Series – this allows you to save the result(s) as a *.res.csv file, which can then be re-imported for future use maintaining the same data structure; or
Export to Excel – opens the result(s) in Excel, allowing you to save a *.csv file.

For single results, both export methods allow you to export for either the Current Run only or All Runs. All Runs will export that result for all runs in the current session.

Note: When you right click on any entry in the tree menu, apart from a single result, you can choose to export data for all series beneath it. So to save all results for a scenario, right click on the scenario name. This will export results for a scenario, which is not the same as saving a run in your project.