Exporting time varying data

Step-by-step Guide

InfoWorks WS Pro allows users to export both time varying data (TVD) and summary data.

Time Varying Data, like pressure or flow, changes at each timestep of the simulation.

1. Create a new folder with the name “Results” to store the results of this exercise.
2. From the Model Group window, drag-and-drop a completed run with results into the workspace to open the simulation GeoPlan.
3. Zoom into a part of the network populated with nodes.

In this case, several hydrants are nearby.

4. In the Tools toolbar, click the Polygon select tool.
5. Click repeatedly to draw a polygon around several nodes.

Note: The more points you select, the longer the export process will take.

6. From the Results menu, click Export to files.

7. In the Export Results Data Files dialog box, next to the Folder for output files field, click the Browse (…) button.

8. In the file browser, navigate to the folder created in Step 1; in this case, This PC > Desktop > Results.
9. Click Select Folder.

10. In the Export Results Data Files dialog box, Selection List box, click the Current (…) button to use the currently selected group of objects.

Important: If you skip Step 10, the results for every object in the model will be exported, which may take a long time.

11. In the Output group box, expand the Number of Files drop-down and select File for each object type.
12. Expand Group results and select Group by name.
13. Click Produce Files.

14. Open the file browser and navigate to the Results folder created in Step 1.

Notice there are now several CSV files, one for each type of object selected in the polygon.

15. For this example, select BridgeCon_ts_hyd_obj_.CSV, the file for hydrants.

16. Open the file in a spreadsheet application.
17. Expand the first column, if needed.

The data is arranged with each object ID acting as a header, with the time varying results below it.

To export the results in a more spreadsheet-friendly format:

18. With the objects still selected in the GeoPlan, in the Operations toolbar, click the Grid selected objects button.

19. In the Grid Selection dialog box, in the Object Type group box, enable Nodes.
20. In the Attribute list, select Pressure (m).
21. Click OK to open a grid with the timeseries data.

To easily transfer the contents of the grid to a spreadsheet:

22. Click the top-left cell to select all the data.
23. On your keyboard, press CTRL+C.
24. Press CTRL+V to paste the data into a blank spreadsheet.