• InfoWorks WS Pro

Exporting time varying data

Export time varying data.


Tutorial resources

These downloadable resources will be used to complete this tutorial:


00:03

Info works. WS pro allows you to export both time, varying data, TVD and summary data

00:11

time,

00:12

varying data like pressure or flow changes at each time step of the simulation,

00:19

create a folder on your desktop and name it results.

00:23

This is where you will save the results of this exercise.

00:27

Open a completed run with results by dragging the simulation into the workspace

00:33

zoom into a part of the network populated with nodes.

00:36

In this case, several hydrants are nearby

00:40

with the polygon select tool active, draw a polygon around several nodes.

00:46

Keep in mind that the more you select the longer the export process will take

00:52

from the results tab click export to files to open the export results, data files,

00:57

dialogue

00:58

next to the folder for output files field,

01:01

click the browse button with ellipses and

01:03

navigate to the folder you created earlier.

01:06

In this case, the file path should be this PC

01:10

desktop

01:11

results

01:12

then click select folder

01:16

in the selection list area,

01:17

click the ellipses button to use the currently selected group of objects.

01:22

If you fail to do this, the results for every object in the model will be exported,

01:27

which may take a long time

01:29

in the output group box, number of files

01:32

expand the dropdown and select file for each object type

01:38

group results should be group by name,

01:41

then click produce files,

01:44

open file explorer and navigate to the output folder you created earlier.

01:49

There are several CSV files. One for each type of object selected in the polygon,

01:55

select one such as the file of selected

01:57

hydrants and open it in a spreadsheet application.

02:01

You may need to expand the first column.

02:04

The data is arranged with each object id acting

02:07

as a header with the time varying results below it

02:11

to export the results in a more spreadsheet friendly format

02:14

with the objects still selected in the GEO plan.

02:17

Click the grid selected objects button in the toolbar

02:22

in the grid selection dialogue enable nodes in the object type group box

02:27

select pressure M as the attribute

02:30

click OK to open a grid with the time series data

02:35

to easily transfer the contents of the grid to your spreadsheet.

02:38

Click the top left cell and press control C

02:42

you can then paste the data into a blank spreadsheet by pressing control V.

Video transcript

00:03

Info works. WS pro allows you to export both time, varying data, TVD and summary data

00:11

time,

00:12

varying data like pressure or flow changes at each time step of the simulation,

00:19

create a folder on your desktop and name it results.

00:23

This is where you will save the results of this exercise.

00:27

Open a completed run with results by dragging the simulation into the workspace

00:33

zoom into a part of the network populated with nodes.

00:36

In this case, several hydrants are nearby

00:40

with the polygon select tool active, draw a polygon around several nodes.

00:46

Keep in mind that the more you select the longer the export process will take

00:52

from the results tab click export to files to open the export results, data files,

00:57

dialogue

00:58

next to the folder for output files field,

01:01

click the browse button with ellipses and

01:03

navigate to the folder you created earlier.

01:06

In this case, the file path should be this PC

01:10

desktop

01:11

results

01:12

then click select folder

01:16

in the selection list area,

01:17

click the ellipses button to use the currently selected group of objects.

01:22

If you fail to do this, the results for every object in the model will be exported,

01:27

which may take a long time

01:29

in the output group box, number of files

01:32

expand the dropdown and select file for each object type

01:38

group results should be group by name,

01:41

then click produce files,

01:44

open file explorer and navigate to the output folder you created earlier.

01:49

There are several CSV files. One for each type of object selected in the polygon,

01:55

select one such as the file of selected

01:57

hydrants and open it in a spreadsheet application.

02:01

You may need to expand the first column.

02:04

The data is arranged with each object id acting

02:07

as a header with the time varying results below it

02:11

to export the results in a more spreadsheet friendly format

02:14

with the objects still selected in the GEO plan.

02:17

Click the grid selected objects button in the toolbar

02:22

in the grid selection dialogue enable nodes in the object type group box

02:27

select pressure M as the attribute

02:30

click OK to open a grid with the time series data

02:35

to easily transfer the contents of the grid to your spreadsheet.

02:38

Click the top left cell and press control C

02:42

you can then paste the data into a blank spreadsheet by pressing control V.

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.

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

The InfoWorks WS Pro interface with the BridgeCon run open and zoomed in, and a red polygon drawn around a selection of nodes.

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

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

In the Results menu, Export to files selected and called out, and in the GeoPlan, the selected nodes highlighted in red.

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

The Export Results Data Files dialog box, with options configured and the Browse (…) button highlighted in red.

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

The file browser window with the Results folder and the Select Folder button selected.

  1. 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.

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

In the Export Results Data Files dialog box, the Selection List group box with the Current (…) button highlighted in red, and other options configured.

  1. 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.

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

The file browser, Results folder, with separate CSV files for each object type and the hydrants file selected.

  1. Open the file in a spreadsheet application.
  2. Expand the first column, if needed.

. A Microsoft Excel spreadsheet displaying data from the selected file.

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:

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

In the Operations toolbar, Grid selected objects selected and called out, and in the GeoPlan, selected nodes highlighted in red.

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

The Grid Selection dialog box with Nodes enabled, Pressure (m) selected in the Attributes list, and OK selected.

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

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

The TDV Results: Pressure (m) grid will all data selected for copying.

Was this information helpful?