In GeoSTORM, the Manhole Table Edit command allows the user to view and edit all the parameters of the manholes 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 Manhole Table Edit command:
- From the Input ribbon menu, click the Manhole Structures dropdown menu and select the Manhole Table Edit command.
- The Manhole Table Edit dialog box will be displayed, as shown below.
The following sections describe how to use the Manhole Table Edit command and interact with the above dialog box.
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.
Manhole Parameters
In the Manhole Parameters section, the following panels are available:
- Manhole Data
- Results Data
Manhole Data
This panel displays editable data grid columns listing all the manhole parameters contained in the current scenario.
The following manhole parameters are provided in the data grid columns:
- Manhole ID
This editable column lists all manhole IDs contained in the current scenario.
- Rim Elevation
This editable column lists the manhole rim elevation. The user can manually edit the manhole rim elevation directly from the entry or by clicking the corresponding […] button and measuring the manhole rim elevation from the Map View.
- Invert Elevation
This editable column lists the manhole invert elevation.
- Sump Depth
This editable column lists the sump depth at the manhole. The sump depth of the manhole represents the vertical offset from the manhole bottom invert elevation to the lowest invert of the connected pipes.
- Structure Type
This column contains a dropdown combo box that allows the user to select a type of manhole structure. The following manhole structure types are available:
- Bolted Cover Manhole
- Force Main Connection
- Junction Box
- Standard Manhole
- Footprint Area
This editable column lists the manhole’s interior storage area. Note that this column is enabled only when Junction Box is selected as the structure type. Otherwise, this column is disabled (i.e., grayed out).
- Initial WSEL
This editable column lists the water surface elevation (WSEL) of the manhole at the start of the simulation.
- Overflow Ponding Area
This editable column lists the overflow ponded area. The overflow ponded area is the storage area occupied by the ponded water on the top of the manhole after flooding occurs.
- Baseline Inflow
This editable column lists the constant baseline inflow.
- Time Series Inflow
This column contains a dropdown combo box that allows the user to select the time series inflow. Clicking the […] button displays the Time Series Data dialog box, which allows the user to define time series inflow data for manholes. Refer to this article in our knowledge base to learn more about the Time Series Data dialog box.
Results Data
This panel displays data grid columns listing the corresponding output results for manholes contained in the current scenario after the analysis is successfully computed.
The following manhole parameters are provided in the data grid columns:
- Manhole ID
This editable column lists all manhole IDs contained in the current scenario.
- Peak Inflow
This read-only column lists the computed peak inflow at the manhole during the storm event.
- Maximum WSEL
This read-only column lists the computed maximum water surface elevation (WSEL) at the manhole during the storm event.
- Maximum Depth
This read-only column lists the computed maximum water depth at the manhole during the storm event.
- Minimum Freeboard
This read-only column lists the computed minimum freeboard height at the manhole during the storm event. Freeboard height of the manhole is the distance between the rim elevation of the manhole and the water surface level.
- Max Stored Water Volume
This read-only column lists the computed maximum stored water volume at the manhole during the storm event. Note that this column shows values only for the junction box structure type. Otherwise, this column will show N/A.
- Maximum Pipe Cover
This read-only column lists the computed maximum ground cover measured from the top of the pipe (crown) along the pipe length.
- Minimum Pipe Cover
This read-only column lists the computed minimum ground cover measured from the top of the pipe (crown) along the pipe length.
Sorting the Manhole Table
The data in the Manhole 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 Manhole ID column and click the Up arrow to sort the data in ascending order. Then, while holding down the [Shift] key, select the Invert Elevation column and click the Down arrow to apply a secondary sort.
Copying and Exporting Manhole Table
The data in the Manhole Parameters table can be copied to the clipboard or exported as a Microsoft Excel or PDF document by using 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 manhole parameters, click the [Close] button to close the Manhole Table Edit dialog box.