This tutorial introduces InfoWater Pro's Model Scenario Management capability. Using InfoWater Pro's Scenario Explorer, you can develop numerous alternative representations of your distribution system, store those alternatives individually, quickly retrieve and analyze those scenarios, and compare modeling results.
By default, when you work in InfoWater Pro, you are using a scenario entitled “BASE”. The data you have developed and analyzed up to this point in the Quick Start tutorial (including fireflow and energy management) have been part of this BASE scenario.
Whichever scenario is currently loaded (i.e., whose associated data is loaded into the open InfoWater Pro project and is available for editing, simulation, and analysis) is referred to as the “ACTIVE” scenario. Because the BASE scenario is currently loaded, it is referred to as the “ACTIVE” scenario. Until you decide to start developing custom scenarios, you will always be working with the BASE scenario.
A developer is proposing a new subdivision in the community. Proposed date of construction is sometime in the future. You need to add that new development to the model and determine system performance given that new development. In this tutorial, you will create three custom scenarios.
Upon running each of the three separate scenarios, you will use several tools to compare system performance among the three scenarios.
The first step is to add piping associated with the new development to the tutorial model. At this stage of planning, a very simple piping representation is sufficient. You will add two pipes representing the planned connections to the existing system and will add a single junction node representing the estimated demand at the new development. The two pipes and one junction node representing the future development will be distinguished from existing components by flagging the three new components with a Zone value of “Proposed”.
Note: This tutorial is a continuation of the model used in the main Quick Start Tutorial, and you are expected to use the completed model from the tutorial as the starting basis for this Scenario tutorial. If you have not already completed the Quick Start Tutorial, Innovyze strongly recommends that you complete it first before you attempt to work through this extended tutorial on Scenario Management. If you have not completed the Quick Start Tutorial, please use the Sample.aprx model in the Quick Start Tutorial Example files for use with this tutorial, but you will have to use different scenario names as the scenarios and elements are already added.
NOTE: Please Review Step 3 of the Quick Start tutorial if you need further detail of how to manually add new elements to the model.
Insert Pipe 900 from Junction 19 to Junction 900.
Insert Pipe 910 from Junction 47 to Junction 900.
Junction Attributes | |||
Junction ID | Elevation | Demand 1 | Pattern 1 |
900 | 110 | 800.00 | 1, Average Day Demand |
Pipe Attributes | |||||
Pipe ID | Start Node | End Node | Diameter (in) | Length (ft) | Roughness Coefficient |
900 | 19 | 900 | 12.00 | 235 | 130.00 |
910 | 47 | 900 | 8.00 | 215 | 130.00 |
Edit the Zone field to store a flag indicating that the new components (i.e., junction 900 and pipes 900 and 910 as shown above) are proposed.
To add a baseline demand for junction 900, perform the following:
Your first custom scenario will contain the following:
Create your first custom scenario by clicking on the New Scenario button. When prompted, enter a scenario name and description (separated by comma) of “FUTURE1, Future Demands – No New Development”. Click once on the OK button to close the New Data Scenario dialog box. The FUTURE1 scenario is now a child of the BASE scenario as shown in the Scenario Explorer dialog box below. NOTE: Datasets for a child scenario can be set to be either Inherited from the Parent Scenario or they can use a Scenario Specific Dataset. An Inherited Dataset will update automatically in the child scenario to match if changed in the Parent Scenario, while a Scenario Specific Dataset will not change if the Parent scenario is changed. The icon shown next to the dataset will indicate which type has been selected for that dataset . To change from a Scenario Specific dataset to Inherited, right click on the dataset in question and select "Inherited". If you open the specific Dataset browser with a double click on the dataset Category name or by right clicking and choosing the Select option and select a specific dataset so it is highlighted and select the green button, it will reset the dataset type to be Scenario Specific. See Scenario Explorer - Dataset for more details.
Two elements of the new FUTURE1 scenario will be unique. You will first create a unique demand set to store future demands.
The facility tab of the Scenario Explorer defines which elements are active for that given scenario. You will now define a facility set representing existing facilities. Earlier in this scenario tutorial you added two pipes and a junction node and flagged those elements with a Zone value of “PROPOSED”. Using an InfoWater Pro Query Set (collection of database query statements), you can exclude the proposed components. Note: See the Scenario Explorer - Facility tab for further details regarding the Facility Tab options.
Click on the Preferences button in the Project Group of the InfoWater Pro ribbon. From the Operation Settings tab, select the Auto Pipe Node Inclusion box to be on.
NOTE: The Auto Pipe Node Inclusion check box will allow a Facility Query Set to only use a single Pipe Query rather than to use 6 separate queries with one for each element type. This can greatly simplify managing fields used in Facility Query Sets as only Pipe fields would need to be managed. When checked on the Model will automatically select Node elements at the endpoints of the pipes selected by the by the Facility Query Set to be active when the scenario is made active. But please note that if the Query set contains any Node element query the software will not use the Auto Pipe Node Inclusion and will expect the Facility Query Set to select all element types.
It is suggested that you review the contents of this query set before continuing. Choose the Browse button to the right of the drop-down list to open the Query Set dialog box. You will note that the query set is comprised of six individual query statements entitled “EX1” through “EX6”. Examine the first query statement by clicking once on “EX1” in the Query ID panel on the dialog box. You can now examine the contents of the query. The query should appear as (the symbol “ < >” designates “not equal to”): JUNCTION→ZONE < > 'PROPOSED' The other five queries have an identical structure and represent the other five InfoWater Pro network component types (pipes, pumps, valves, tanks, and reservoirs).
To illustrate the advantage of using the Auto Pipe Node Inclusion option from the Preferences, select New on the Query Set box and name the New Query Set as "FAC_EXISTING, Existing Facilities 2".
When the DB Query Set box opens and with the new FAC_EXISTING Query Set Selected, click on the Browse button in the DB Query section to open the DB Query List.
Select the "EX2" query for Pipes and right click and select the Clone option. Name the New Query "EX_PIPES, Existing Pipes" and select OK to create the query.
Note: Making use of Queries that have names that indicate what they represent can be very useful and helpful in managing a model. The EX_PIPES Query by Name tells us that is a Pipes Query for Existing Pipes. This is much more meaningful than the "EX2" which you would have to investigate further to learn it is for Pipe elements. Keep this in mind as a tip that can help make a model more user friendly.
With the EX_PIPES query selected click on the green button. This will add the EX_PIPES query to the FAC_EXISTING Query Set. If all went properly the FAC_Existing Query set should appear as shown below.
Note: If any other Queries were accidentally added to the "Associated DB Queries & Colors" List besides the EX_PIPES, select that query and click Delete to remove it.
Close the Query Set dialog box by clicking on the OK button and return to the Scenario Explorer dialog box.
Before you close the Scenario Explorer by clicking on the Exit button, as indicated by the BASE scenario that is still highlighted in blue .
To modify the demand data in your new scenario, you must activate that scenario. When activating a scenario, the current data in your Tutorial project (BASE data sets) are replaced by the data sets associated with the new active scenario.
You can activate a scenario directly from the Scenario Explorer dialog box or from the InfoWater Pro Model Explorer. The latter is illustrated here.
When you activate the FUTURE1 scenario, InfoWater Pro applies the database query statements in the FAC_EXISTING Query Set to include and exclude network facilities in the model. Notice that when you load the FUTURE1 scenario the proposed facilities are no longer active and appear light gray. They remain in the project but are not active for the current scenario. Finally, InfoWater Pro loads your custom demand set FUTURE1.
Now that your custom demand set is loaded and active, you can adjust those demands to represent future water usage without overwriting your existing demands, which are stored in the BASE demand set.
Note: When you create a new scenario, the Facility Tab will default to using the Active Network option. This will keep all elements that were currently active in the active scenario as the same elements active in the new scenario, but should be used with caution as it will keep active whatever elements are active at the time in the last scenario used when you switch to this scenario. This can easily result in unexpected changes in what elements are active in the given scenario. As such it is recommended to always review and adjust the Facility Tab when making a new scenario to avoid confusion. The most commonly used Facility options for new scenarios include The Query Set option and the Intelli-Selection options as these give the user better control over which elements should be active in the new scenario.
You have created your first custom scenario, representing the existing network components with estimated future demands. Now, while this custom scenario is active and its associated data loaded into the open InfoWater Pro project, run the model to obtain hydraulic and water quality results.
Now run a standard (hydraulic and water quality) simulation while the FUTURE1 scenario is active.
.Note that the Name of the Output Source that will store the simulation results is *ACTIVE*:STANDARD. The Active Standard Output Source will store the results of the FUTURE1 scenario simulation. Note that the FUTURE1 scenario will use the same simulation options and time settings (duration, timesteps) as the BASE, or default, scenario. Although not instructed to do so as part of this tutorial, you could associate a unique set of simulation options with this custom scenario.
Review the results of the simulation using the Map Display. Please review Step 9 of the Quick Start tutorial if you need assistance in reviewing model output.
Now you will create the next scenario representing future demands, in the Quick Start Tutorial incorporating the new development and then run a simulation with that scenario.
Your second custom scenario will contain the following:
This new scenario will inherit its properties from the first custom scenario. If you were to modify the demands in the first custom scenario, the demands in this new scenario would also be modified.
Note, however, that scenarios do not inherit their facility set (network components) from their parent. Therefore you must explicitly define the network components that will be activated for modeling when you activate (load) the FUTURE2 scenario. The FUTURE2 scenario will include the entire suite of network components, existing and proposed.
On the Scenario Explorer dialog box, choose the Facility tab. When the Facility panel appears, choose the Entire Network option.
You can now run a simulation using data from the second scenario.
You can activate a scenario directly from the Scenario Explorer dialog box or from the InfoWater Pro ribbon. The former is illustrated here.
When you activate the FUTURE2 scenario, InfoWater Pro activates all existing and proposed facilities. Notice on the map display that the two pipes and one junction node added at the beginning of this tutorial re-appear on the screen. This occurs because this scenario used the Entire Network option on the Scenario Facility Tab. The Entire Network option will include all elements in the model and make them active. For this reason, this option often has limited value for most models unless all elements are indeed active for the scenario. No additional data modification is necessary. You may now run a simulation using the FUTURE2 scenario.
Now run a standard (hydraulic and water quality) simulation while the FUTURE2 scenario is active.
Select the Run button from the Analysis Group in the InfoWater Pro ribbon. The Run Manager dialog box appears on the screen.
Note the Name of the Output Source that will store the simulation results is *ACTIVE*:STANDARD. The Active Standard Output Source will store the results of the FUTURE2 scenario simulation.
The previous simulation results, those associated with the FUTURE1 scenario, are automatically moved to a new Output Source entitled FUTURE1:STANDARD.
Select the Locate Node button in the Edit group of the InfoWater Pro ribbon. This will open up the Locate Node window. Enter 19 and select the OK button to close. This will make Junction 19 the active element in the Model Explorer.
Click the Graph button in the Model Explorer to graph this element in the Report Manager. A graph of Junction 19 should automatically appear.
From the Icons in the active junction, select the Reference Graph button.
Select the "Pressure" References sources tab at the top.
Check the box for "Data from Other Output Source(s)" and click on the Select button to open the Select Output Source(s) to Compare box.
Select the FUTURE1:Standard from the list and click OK to close. Select OK once again to close the remaining dialog box that is open.
The graph should now show Pressure data from the Active FUTURE2 scenario (in the Active:Standard Output) as well as the Pressure Data from the FUTURE1:Standard scenario.
Review the graph and notice the impact of the new 800 GPM demand on Node 900 has on the pressure at the nearby Junction 19 that was graphed.
Select the Hide button to close the Report Manager.
Select the Locate Pipe button in the Edit group of the InfoWater Pro ribbon. This will open up the Locate pipe window. Enter 18 and select the OK button to close. This will make Pipe 18 the active element in the Model Explorer.
Click the Graph button in the Model Explorer to graph this element in the Report Manager. A graph of Pipe 18 should automatically appear. Keep the Default Output field of Flow as the active output field.
From the icons in the active pipe Graph, select the Reference Graph button.
Select the "Flow" References sources tab at the top.
Check the box for "Data from Other Output Source(s)" and click on the Select button to open the Select Output Source(s) to Compare box.
Select the FUTURE1:Standard from the list and click OK to close. Select OK once again to close the remaining dialog box that is open.
The graph should now show Flow data from the Active FUTURE2 scenario (in the Active:Standard Output) as well as the Flow Data from the FUTURE1:Standard scenario.
Review the graph and notice the impact of the new 800 GPM demand on Node 900 has on the flow at the nearby pipe 18 that was graphed.
Select the Hide button to close the Report Manager.
Review the results of the simulation using the Map Display. We recommend color coding Pipes by Flow and Junctions by Pressure to compare differences. By Switching the Output source from ACTIVE:STANDARD to FUTURE1:STANDARD, you can see the Map display change output without having to switch scenarios. Please review Step 9 of the Quick Start tutorial if you need assistance in reviewing model output and use of the Map Display.
Your third custom scenario will contain the following:
This new scenario will inherit its properties from the second custom scenario. If you were to modify the demands in the second custom scenario (FUTURE2), the demands in this new scenario would also be modified.
You can now run a simulation using data from the third scenario FUTURE3.
You can activate a scenario directly from the Scenario Explorer dialog box or from the InfoWater Pro ribbon. The former is illustrated here.
When you activate the FUTURE3 scenario, InfoWater Pro activates all existing and proposed facilities. Moreover, InfoWater Pro loads your custom demand set “FUTURE2 – New Development 1200 gpm”, which at this point in the tutorial contains the future demand values. The new proposed node still has a demand of 800 gpm.
Before continuing, increase the demand at junction 900 from 800 gpm to 1,200 gpm:
The adjusted demand is automatically saved in the active demand set, “FUTURE2, New Development 1200 gpm”.
Note: If the Auto Record Saving box is checked in Preferences dialog box (see the Project Group in the InfoWater Pro ribbon) under the Operations Settings tab, changes made in the Model Explorer fields should automatically save. If this check box is left unchecked, then any change made would need to be saved in the Model Explorer manually. For this reason, Innovyze recommends checking this option on for normal model operations.
Now run a standard (hydraulic and water quality) simulation while the FUTURE3 scenario is active.
Note the Name of the Output Source that will store the simulation results is *ACTIVE*:STANDARD. The Active Standard Output Source will store the results of the FUTURE3 scenario simulation.
The previous simulation results, those associated with the FUTURE2 scenario, are automatically moved to a new Output Source entitled FUTURE2:STANDARD. Upon completion of this simulation, you should have the following Output Sources available:
Review the results of the simulation using the Map Display after the FUTURE2 run completion.
Similar to what was completed after the FUTURE2 run, let's compare run results for Junction 19 and Pipe 18.
Note: (OPTIONAL) This drop in pressure appears to indicate that the proposed development is identifying some deficiency in the current system. While this is beyond this tutorial, if you graph the Tank 103 the tank appears to be undersized for the future Demand or the pumps provided are undersized to handle the proposed large development.
Try Increasing the Tank Diameter to 200 ft as this will greatly increase the Storage capacity of the system. You can re-run all of the scenarios quickly by using the Command Center tab of the Model Explorer under Tools - > Batch Simulation if interested. In a Batch Simulation make sure to select the FUTURE1, FUTURE2, and FUTURE3 so they are highlighted in Blue before you select the Run button. See below for how the batch run should look before running.
Finally, you will display on the same graph the (time-varying) pressure results for junction node 900 (new development) loaded with an external demand of 800 gpm and 1,200 gpm. You will also create a custom output report showing for every junction node in the system the demand and head associated with both FUTURE2 and FUTURE3 modeling scenarios at any simulation timestep.
Now load the output data for junction 900 from the previous scenario run, i.e. FUTURE2:Standard. Click on the Reference Graph button. Click on the Demand Reference Sources tab and check on Data From Other Output Sources. Click on the Select button. The Select Output Source(s) to Compare dialog box appears on the screen.
Finally, customize the graph legend, renaming legend entries such that they are intuitive.
Close the Properties dialog box by clicking on the OK button. The graph legend should now reflect your changes in the Report Manager Graph window.
In the Report Manager, select New to open a new Tabular Report. Using the Active:Standard Output Source, select the Tabular Report tab, choose the Junction Report option, and use the default "Complete Report/Graph" for Data Scope. Select Open to open the report.
Select the Compare Report button from the Junction Report icon.
Now customize your report to display only the demand and head results for both scenarios. Select the Format Report button from the junction report icon and the Format All dialog box appears on the screen. The Display Columns area initially contains all the output variables for display. Click on the button and the output variables are shifted to the Available Columns area. Hold down the CTRL key and select “Demand”, “Demand [FUTURE2:Standard]”, “Head”, and “Head [FUTURE2:Standard]” and select the button to add these 4 output fields to the report. The Display Columns area now only shows the four selected output variables.
With InfoWater Pro, you can change the units of any output variable in any report and graph display. You can even mix US customary and SI units in the same project if you so desire. For this exercise, we will use the Output Unit Manager to display the junction demand in million gallons per day (mgd) and the junction, tank and reservoir head in meter (m).
Click on the Model Explorer and select the Command Center tab. Under the Tools menu, choose the Output Unit Manager. The Output Unit Manager appears on the screen as shown below. The Output Unit Manager stores the selected output display units.
Select the Attribute tab of the Model Explorer and select any Junction as the active element (if not already on a junction). Notice that under Output section that the Demand now shows as MGD and the Head now shows results in Meters.
Note: It is often good modeling practice to maintain consistent units for Input Units and Output Units to avoid easily getting confused; but it is handy that one can easily change Output units on the fly if so desired. To reset Output Units to match Input units, select the Project button in the Output Unit Manager. This will reset output units to match the current model input units.
Refer to the Analyzing Output Results → Output Unit Manager topic in the Online InfoWater Pro Help for more information on specifying units for use on graphs and reports.
Using InfoWater Pro's scenario management capabilities will allow you to take a single InfoWater Pro project, representing your existing distribution system under current average day conditions, and create three additional alternative model representations. These model representations represent your existing system under future demand conditions, your existing system with the proposed development, and the proposed development under significantly increased demands.
You have seen how, after developing modeling scenarios with the Scenario Explorer, you can quickly retrieve each separate scenario and can easily compare the results between the different scenarios.
You have now completed the InfoWater Pro's Extended Tutorial 3: Model Scenario Management. You should now have the skills necessary to develop and analyze distribution system network models with the extensive and powerful suite of tools provided by InfoWater.