• InfoWorks WS Pro

Introduction to Price of Water Analysis in InfoWorks WS Pro

Conduct a Price of Water analysis in WS Pro, for example, to calculate the cost of water imported to or exported from the water supply system.


Tutorial resources

These downloadable resources will be used to complete this tutorial:


00:03

You can make an estimate for the cost of water in your water supply system

00:07

by including a unit price for water transfer through any pipe control.

00:12

You can apply a different unit price to flow in the usual direction (From Node to Node)

00:17

and the opposite direction (To Node to From Node).

00:21

To allow you to apply prices to both import and export, or the bulk sale of water,

00:27

negative unit prices are allowed.

00:29

As an aid to reporting, the cost at a particular pipe can be given a category.

00:35

There are built-in categories to choose from, and you can add your own categories, if needed.

00:41

A common use of this facility would be to calculate the cost of water imported to or exported from the water supply system.

00:49

You would apply a positive price on links attached to transfer nodes for all imported water,

00:55

and a negative price on the same links for flow out of the system.

00:59

You can also come up with a comprehensive estimate of the total cost of water in the system, by applying a cost to all links.

01:07

For pumps, this cost will represent costs in addition to the electricity cost calculated from the Electricity Tariff.

01:14

You can then add the Price of Water figures to the electricity costs to get a total cost estimate.

01:20

For each link, you can include the cost of water in each direction to a category.

01:25

For example, you may include the price of water in the From Node - To Node direction in the Export category.

01:31

The available categories are: Treatment - total cost of water treatment,

01:37

which may include filtration or chemical treatment

01:39

Chemical Treatment - total cost of chemical water treatment

01:43

Chlorination - cost of chlorine injection and dosing

01:48

Import - cost of bulk water imported to the network

01:52

Export - cost of bulk water exported out of the network (this cost would be negative)

01:59

Transport - transport costs or revenue for water transfer

02:04

Extraction - cost of well or borehole extraction

02:08

Pumping - any costs other than electricity costs from the electricity tariff.

02:14

For example, maintenance or depreciation costs

02:17

Other - user defined

02:21

To calculate the price of water in a simulation, a cost associated with the movement of water within at least one pipe

02:27

needs to be included.

02:29

Begin by opening the PoW Network and Control by double-clicking on the PoW Network in the Model Group.

02:37

Expand the Stored Query Group and then double-click the provided PoW stored query to open it.

02:44

You will see a query already populated, which assumes that the unit cost of forward and reverse transport is £2/kL.

02:52

Before running the query, click Test to make sure it is valid.

02:57

Then, click Run.

02:59

The PoW value in the Pipe Control should now be updated.

03:03

Open the properties of any pipe, then check that the PoW Unit Cost under Pipe Control has been updated.

03:11

You can also check this by using the New Links Window.

03:15

Commit the changes to the Control.

03:18

Right-click the Run Group and select New > Run.

03:24

The Schedule Hydraulic Run dialog opens.

03:28

Type a name for the run.

03:30

In this example, “PoW” is entered.

03:33

Check the box next to Experimental.

03:36

Then, in the Model Group window, click and drag the PoW network into the Network group box in the dialog to populate the Network,

03:44

Control, and Demand Diagram fields.

03:47

Click Save, and then Run.

03:50

When the simulation is complete, double click the PoW Control simulation to open it.

03:55

Then, expand the Grid Windows tool and choose Link Results.

04:01

In the Link Results table, you will see a column for the Forward and Reverse cost of water for each pipe.

04:07

You can export or copy this table to Excel or a similar program to further manipulate the data.

Video transcript

00:03

You can make an estimate for the cost of water in your water supply system

00:07

by including a unit price for water transfer through any pipe control.

00:12

You can apply a different unit price to flow in the usual direction (From Node to Node)

00:17

and the opposite direction (To Node to From Node).

00:21

To allow you to apply prices to both import and export, or the bulk sale of water,

00:27

negative unit prices are allowed.

00:29

As an aid to reporting, the cost at a particular pipe can be given a category.

00:35

There are built-in categories to choose from, and you can add your own categories, if needed.

00:41

A common use of this facility would be to calculate the cost of water imported to or exported from the water supply system.

00:49

You would apply a positive price on links attached to transfer nodes for all imported water,

00:55

and a negative price on the same links for flow out of the system.

00:59

You can also come up with a comprehensive estimate of the total cost of water in the system, by applying a cost to all links.

01:07

For pumps, this cost will represent costs in addition to the electricity cost calculated from the Electricity Tariff.

01:14

You can then add the Price of Water figures to the electricity costs to get a total cost estimate.

01:20

For each link, you can include the cost of water in each direction to a category.

01:25

For example, you may include the price of water in the From Node - To Node direction in the Export category.

01:31

The available categories are: Treatment - total cost of water treatment,

01:37

which may include filtration or chemical treatment

01:39

Chemical Treatment - total cost of chemical water treatment

01:43

Chlorination - cost of chlorine injection and dosing

01:48

Import - cost of bulk water imported to the network

01:52

Export - cost of bulk water exported out of the network (this cost would be negative)

01:59

Transport - transport costs or revenue for water transfer

02:04

Extraction - cost of well or borehole extraction

02:08

Pumping - any costs other than electricity costs from the electricity tariff.

02:14

For example, maintenance or depreciation costs

02:17

Other - user defined

02:21

To calculate the price of water in a simulation, a cost associated with the movement of water within at least one pipe

02:27

needs to be included.

02:29

Begin by opening the PoW Network and Control by double-clicking on the PoW Network in the Model Group.

02:37

Expand the Stored Query Group and then double-click the provided PoW stored query to open it.

02:44

You will see a query already populated, which assumes that the unit cost of forward and reverse transport is £2/kL.

02:52

Before running the query, click Test to make sure it is valid.

02:57

Then, click Run.

02:59

The PoW value in the Pipe Control should now be updated.

03:03

Open the properties of any pipe, then check that the PoW Unit Cost under Pipe Control has been updated.

03:11

You can also check this by using the New Links Window.

03:15

Commit the changes to the Control.

03:18

Right-click the Run Group and select New > Run.

03:24

The Schedule Hydraulic Run dialog opens.

03:28

Type a name for the run.

03:30

In this example, “PoW” is entered.

03:33

Check the box next to Experimental.

03:36

Then, in the Model Group window, click and drag the PoW network into the Network group box in the dialog to populate the Network,

03:44

Control, and Demand Diagram fields.

03:47

Click Save, and then Run.

03:50

When the simulation is complete, double click the PoW Control simulation to open it.

03:55

Then, expand the Grid Windows tool and choose Link Results.

04:01

In the Link Results table, you will see a column for the Forward and Reverse cost of water for each pipe.

04:07

You can export or copy this table to Excel or a similar program to further manipulate the data.

Step-by-step guide

An estimate for the cost of water in a water supply system can be made by including a unit price for water transfer through any pipe control. A different unit price can be applied to flow in the usual direction (From Node to To Node) and the opposite direction (To Node to From Node).

To allow prices to be applied to both import and export, or the bulk sale of water, negative unit prices are allowed.

As an aid to reporting, the cost at a particular pipe can be given a category. There are built-in categories to choose from, and custom categories can be made, if needed.

A common use of this facility would be to calculate the cost of water imported to, or exported from, the water supply system. A positive price is applied on links attached to transfer nodes for all imported water, and a negative price is applied on the same links for flow out of the system.

A comprehensive estimate of the total cost of water in the system can be made by applying a cost to all links. For pumps, this cost will represent costs in addition to the electricity cost calculated from the Electricity Tariff. The Price of Water figures are then added to the electricity costs to get a total cost estimate.

A presentation slide listing some reasons to calculate the price of water, such as prices to import and export, the bulk sale of water, and the cost of water treatment, with an image of a water treatment plant and a major pipeline.

For each link, the cost of water can be included in each direction to a category. For example, include the price of water in the From Node - To Node direction in the Export category.

Available categories:

  • Treatment - total cost of water treatment, which may include filtration or chemical treatment
  • Chemical Treatment - total cost of chemical water treatment
  • Chlorination - cost of chlorine injection and dosing
  • Import - cost of bulk water imported to the network
  • Export - cost of bulk water exported out of the network (this cost would be negative)
  • Transport - transport costs or revenue for water transfer
  • Extraction - cost of well or borehole extraction
  • Pumping - any costs other than electricity costs from the electricity tariff. For example, maintenance or depreciation costs
  • Other - user defined

To calculate the price of water in a simulation:

NOTE: a cost associated with the movement of water within at least one pipe needs to be included.

  1. To open the PoW Network and Control, in the Model Group, double-click the PoW Network.
  2. Expand the Stored Query Group.
  3. Double-click the PoW stored query to open it.

NOTE: For this example, a query is already populated, which assumes that the unit cost of forward and reverse transport is £2/kL.

The InfoWorks WS Pro interface, showing the populated GeoPlan in the background, PoW selected from the Model Group, and the PoW dialog box in the foreground, with the provided query showing in the query panel.

  1. Click Test to ensure the query is valid.
  2. If it is valid, in the popup, click OK.
  3. Click Run.

The SQL: PoW dialog box open in the background, with the validation message open in the foreground, stating that the query syntax is valid and the network can be run.

The PoW value in the Pipe Control should now be updated.

  1. On the GeoPlan, click any pipe to open its Properties.
  2. Under Pipe Control, check that the PoW Unit Cost is updated to 2.00 £/m3. This can also be checked using a New links window.

The Properties panel open on the left for a selected pipe from the GeoPlan on the right, with the PoW unit Cost highlighted for the selected pipe under Pipe Control.

  1. Commit the changes to the Control.
  2. Right-click the Run Group and select New > Run.
  3. In the Schedule Hydraulic Run dialog box, type a name for the run, such as “PoW” for this example.
  4. Enable Experimental.
  5. From the Model Group, drag and drop the PoW network into the Network box to populate the Network, Control, and Demand Diagram fields.
  6. Click Save.
  7. Click Run.

The Schedule Hydraulic Run dialog box configured for the PoW run, with the network, control, and demand diagram populated.

  1. When the simulation is complete, expand Run Group.
  2. Expand PoW.
  3. Double-click the PoW Control simulation OR drag and drop it into the GeoPlan to open it.
  4. From the Windows toolbar, expand the Grid windows drop-down and select Link results.

The Grid windows drop-down expanded, and Link results being selected from the list.

The Link Results table reports the Forward and Reverse cost of water for each pipe:

The PoW > PoW Control link results table, with the Forward cost of water and Reverse cost of water columns highlighted.

  1. Export the table to Excel or a similar program to further manipulate the data.
Was this information helpful?