Pipe Table Edit Command
In GeoSTORM software, the Pipe Table Edit command allows the user to view and edit all the parameters of the pipes in a single editable data grid. The user can also view the corresponding output results from this data grid.
Follow the steps below to use the Pipe Table Edit command:
- From the Input ribbon menu, click the Stormwater Pipes dropdown menu and select the Pipe Table Edit command.
- The Pipe Table Edit dialog box will be displayed, as shown below.
Selecting Storm Results
In the Select Storm Results section, the Storm result to display dropdown combo box allows the user to select the storm frequency whose result is to be displayed.
Note: The Select Storm Results section is only available when either the Dekalb Rational Method, Modified Rational or Rational Method is selected as the hydrology analysis engine in the Scenario Manager dialog box. Otherwise, this section is unavailable. Refer to this article in our knowledge base to learn more about the hydrology analysis engine.
Pipe Parameters Table
In the Pipe Parameters section, the following panels are available:
- Pipe Data
- Results Data
Pipe Data
This panel displays editable data grid columns listing all the pipe parameters defined in the current scenario.
The following pipe parameters are provided in the data grid column entries:
- Pipe ID
This editable entry lists all pipe IDs defined in the current scenario.
- Pipe Diameter
This dropdown combo box lists the internal diameter of the pipe. The user can change the internal diameter for any pipe from the corresponding dropdown combo box.
- Pipe Length
This editable entry lists the length of the pipe. The user can manually edit the pipe length directly from the entry or by clicking the corresponding […] button and measuring the pipe length from the Map View.
- Inlet Invert Elevation
This editable entry lists the pipe invert elevation on the upstream end.
- Outlet Invert Elevation
This editable entry lists the pipe invert elevation on the downstream end.
- Manning’s Roughness
This editable entry lists the Manning’s roughness of the pipe. Clicking the […] button displays the Channel and Pipe Manning’s Roughness dialog box, which allows the user to select the Manning’s roughness coefficient to be assigned to a pipe.
- Entrance Loss Coefficient
This editable entry lists the head loss coefficient at the inlet of the pipe associated with energy losses as the flow enters the pipe from a node (i.e., manhole, junction box, routing junction, catch basin, or storage area). Clicking the […] button displays the Entrance Loss Coefficients for Pipes dialog box, which allows the user to select the entrance loss coefficient to be assigned to a pipe.
- Exit/Bend Loss Coefficient
This editable entry lists the head loss coefficient at the outlet of the pipe associated with energy losses as the flow leaves the pipe and enters a node (i.e., manhole, junction box, routing junction, catch basin, or storage area). Clicking the […] button displays the Exit Loss Coefficients for Pipes dialog box, which allows the user to select the exit loss coefficient to be assigned to a pipe.
- Average Loss Coefficient
This editable entry lists the head loss coefficient associated with energy losses along the length of the pipe.
- Pipe Slope (H:V)
This read-only entry lists the slope of the pipe.
Results Data
The data grid columns in this panel list corresponding output results for pipes contained in the current scenario after the analysis is successfully computed.
The following pipe parameters are provided in the data grid column entries:
- Pipe ID
This editable entry lists all pipe IDs defined in the current scenario.
- Peak Flow Rate
This read-only entry lists the peak flow rate in the pipe during the storm event.
- Design Flow Capacity
This read-only entry lists the flow rate capacity of the pipe for gravity flow conditions (i.e., non-pressurized).
- Maximum Velocity
This read-only entry lists the maximum flow velocity in the pipe during the storm event.
- Max/Design Flow Ratio
This read-only entry lists the ratio of the Peak flow rate to the Design flow capacity values.
- Max/Total Depth Ratio
This read-only entry lists the ratio of pipe flow depth to the pipe diameter.
- Maximum Pipe Cover
This read-only entry lists the computed maximum ground cover measured from the top of the pipe (crown) along the pipe length.
- Minimum Pipe Cover
This read-only entry lists the computed minimum ground cover measured from the top of the pipe (crown) along the pipe length.
Sorting the Pipe Table
The data in the Pipe Parameters table can be sorted by multiple columns. Users can sort the data by holding down the [Shift] key while clicking the Up or Down arrows in the column headers. This allows for multi-column sorting without losing the previous sort. The sorting order is determined by the sequence in which the column headers are selected.
Follow the steps below to sort the data by using multiple columns:
- Select the header of the first column and click the Up or Down arrow to sort the data in ascending or descending order.
- Hold down the [Shift] key, then select the header of the second column and click the Up or Down arrow to sort the second column.
- Repeat step 2 to sort the data for any additional column.
For example, first, select the Pipe ID column and click the Up arrow to sort the data in ascending order. Then, while holding down the [Shift] key, select the Pipe Length column and click the Down arrow to apply a secondary sort.
Copying and Exporting Pipe Table
The data in the Pipe Parameters table can be copied to the clipboard or exported as a Microsoft Excel or PDF document by using the right-click context menu commands such as Copy, Copy Table to Clipboard, Export Table to Excel, or Export Table to PDF.
After editing the required pipe parameters, click the [Close] button to close the Pipe Table Edit dialog box.