This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

COLUMN FOR CUMULATIVE LENGTH ON THE FLEX TABLE and HOW TO SORT HGL FROM UPSTREAM TO DOWNSTREAM ON T-BRANCHED NETWORKS

Hello guys, I have a very long water distribution network imported via model builder from a GIS-based data.My questions are;-

1. Is there a way to create a new column on the "pipe" flex table to show the cumulative length of the length of pipes available?Its quite tiresome to input certain varying parameters like the size/type of pipes along the total length of pipe at certain specified distances(Let us say in 3000m, the pipe diameter varies as follows,1200m=16",800m=12" then the rest 1000m=8").How can I easily achieve this?Creating a flex table cumulative column looks like the best method for me.

You can also assist by defining a new user data extension.

2. On a dense network model or a branched /T-network, how can I easily sort  my HGL from upstream to downstream along one branch then finish up with HGL data from the junction to the 2nd branch lets say on a T-network.(R1 to  J 1,then J1 to node 1 and J 1 to node 2: How can I sort my HGL data on the flex table from upstream to downstream from R 1 to  node 1 through J 1 then the rest of the network HGL data from J 1 to node 2 to follow right below.

Parents
• Hello Allan,

The cumulative length of a water supply line denotes the total distance between the source till the end demand node. For a large distribution network there are typically multiple sources and many demand nodes. To create a cumulative length the upstream length must be added to the downstream length to get a cumulative length. This feature cannot be created in a Pipe Flex Table or a new User Data Extension as these upstream & downstream lengths are not available separately. However you can export the Pipe Flex Table to Excel and edit as required.

As far as arranging the data upstream to downstream, you can rename the pipes and junctions from the source to your demand end point serially and sort in an ascending order to get the elements sorted in an upstream to downstream fashion.

Please share the product name and version that you are using so that we can help you better. You can find out the current version number you are using by going in the Help Menu and clicking on "About". The version will be at the bottom left corner. The following article explains how to find out your version number.

How to find version of my product?

Hope this helps.

Regards,

Yashodhan Joshi

Technical Support Engineer

Regards,

Yashodhan Joshi

Bentley Technical Support

• Hello Allan,

The cumulative length of a water supply line denotes the total distance between the source till the end demand node. For a large distribution network there are typically multiple sources and many demand nodes. To create a cumulative length the upstream length must be added to the downstream length to get a cumulative length. This feature cannot be created in a Pipe Flex Table or a new User Data Extension as these upstream & downstream lengths are not available separately. However you can export the Pipe Flex Table to Excel and edit as required.

As far as arranging the data upstream to downstream, you can rename the pipes and junctions from the source to your demand end point serially and sort in an ascending order to get the elements sorted in an upstream to downstream fashion.

Please share the product name and version that you are using so that we can help you better. You can find out the current version number you are using by going in the Help Menu and clicking on "About". The version will be at the bottom left corner. The following article explains how to find out your version number.

How to find version of my product?

Hope this helps.

Regards,

Yashodhan Joshi

Technical Support Engineer

Regards,

Yashodhan Joshi

Bentley Technical Support

Children