Review sequences and export results to Excel

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

Transcript

00:03

There are several ways to view the simulation results for a flush sequence or series of flush sequences.

00:09

You can also export the results data to an Excel spreadsheet.

00:13

To begin, with InfoWater Pro initialized, open a UDF model with at least one flushing sequence already run successfully.

00:22

From the Model Explorer window, UDF tab, click and drag the sequence slider scroll bar left to right.

00:30

Each step corresponds with sequence results highlighted on the map,

00:35

starting with Sequence 1 on the left and proceeding numerically as you drag to the right.

00:40

You can also select a sequence from the drop-down menu next to the slider.

00:45

Another option is to view detailed sequence results in table form.

00:50

From the UDF tab, click Sequence Manager.

00:54

In the Flush Sequence Manager dialog, open the Parameters and Pipe Results tabs to view data such as minimum flushing time,

01:01

desired flushing volume, and pipe flow and velocity.

01:05

The Critical Junctions tab lists any critical junction IDs and their respective pressure readings.

01:11

To export sequence results to a spreadsheet, from the toolbar, click Export to Excel.

01:18

This launches Microsoft Excel and automatically populates a new sheet with results data for all sequences.

01:25

You can then save the Excel workbook to the desired location—for example, to a shared online project folder.

01:32

Click OK to exit the Flush Sequence Manager dialog.

Video transcript

00:03

There are several ways to view the simulation results for a flush sequence or series of flush sequences.

00:09

You can also export the results data to an Excel spreadsheet.

00:13

To begin, with InfoWater Pro initialized, open a UDF model with at least one flushing sequence already run successfully.

00:22

From the Model Explorer window, UDF tab, click and drag the sequence slider scroll bar left to right.

00:30

Each step corresponds with sequence results highlighted on the map,

00:35

starting with Sequence 1 on the left and proceeding numerically as you drag to the right.

00:40

You can also select a sequence from the drop-down menu next to the slider.

00:45

Another option is to view detailed sequence results in table form.

00:50

From the UDF tab, click Sequence Manager.

00:54

In the Flush Sequence Manager dialog, open the Parameters and Pipe Results tabs to view data such as minimum flushing time,

01:01

desired flushing volume, and pipe flow and velocity.

01:05

The Critical Junctions tab lists any critical junction IDs and their respective pressure readings.

01:11

To export sequence results to a spreadsheet, from the toolbar, click Export to Excel.

01:18

This launches Microsoft Excel and automatically populates a new sheet with results data for all sequences.

01:25

You can then save the Excel workbook to the desired location—for example, to a shared online project folder.

01:32

Click OK to exit the Flush Sequence Manager dialog.

Video quiz

Required for course completion

Step-by-step guide

There are several ways to view the simulation results for a flush sequence or series of flush sequences. Results data can also be exported to an Excel spreadsheet.

With InfoWater Pro initialized, open a UDF model with at least one flushing sequence already run successfully.
From the Model Explorer window, switch to the UDF tab.
Click and drag the sequence slider scroll bar left or right to select a sequence from the drop-down menu next to the slider.

The Model Explorer, UDF tab, with the current sequence ID and slider highlighted in red.

Each step corresponds with sequence results highlighted on the map, starting with Sequence 1 on the left and proceeding numerically as the slider is dragged to the right.

In the Model Explorer, UDF tab, Sequence 2 selected, and in the map, Sequence 2 results highlighted.

Another option is to view detailed sequence results in table form:

From the UDF tab, click Sequence Manager.

The Model Explorer, UDF tab, with Sequence Manager highlighted in red.

In the Flush Sequence Manager dialog box, open the Parameters and Pipe Results tabs to view data such as minimum flushing time, desired flushing volume, and pipe flow and velocity.

The Flush Sequence Manager open to the Parameters tab, highlighted in red.

Switch to the Critical Junctions tab for a list of any critical junction IDs and their respective pressure readings.

To export sequence results to a spreadsheet:

From the toolbar, click Export to Excel.

The Flush Sequence Manager, Critical Junctions tab, with Export to Excel highlighted in red in the toolbar.

This launches Microsoft Excel and automatically populates a new sheet with results data for all sequences.

An Excel spreadsheet, with exported flush sequence results.

Save the Excel workbook to the desired location—for example, to a shared online project folder.
Click OK to exit the Flush Sequence Manager dialog box.

Was this information helpful?

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Review sequences and export results to Excel

Video quiz

In the Flush Sequence Manager dialog, which button should you click to export sequence results data to a spreadsheet?

Step-by-step guide

Cookie preferences

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Are you sure you want a less customized experience?

Your experience. Your choice.

In the Flush Sequence Manager dialog, which button should you click to export sequence results data to a spreadsheet?

Cookie preferences

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

THIRD PARTY SERVICES

Strictly necessary – required for our site to work and to provide services to you

Improve your experience – allows us to show you what is relevant to you

Customize your advertising – permits us to offer targeted advertising to you

Are you sure you want a less customized experience?

Your experience. Your choice.