This command is an alternative method to the Edit Sewer Structure command for editing existing sewer networks. From the Network menu in the Hydrology Module, select Spreadsheet Sewer Editor to open the spreadsheet dialog. In the Select Pipe Line list box, all pipe line entrances are listed. Select one pipe line to display its parameters for editing. Select All Pipe Lines toggle allows you to choose between displaying all pipe lines or one pipe line in the spreadsheet. After editing the pipe line data, click on the Apply button to perform hydraulic calculation and display the new result.
In the Hydraulic Calculation Results section, the hydraulic results are shown in the result list box. Usually one pipe is displayed, but you can display the result of all pipe segments by turning on the Show Results of the Whole Pipe Line(s) toggle. On the right side of the dialog, a graphic box shows the hydraulic and energy grade lines, pipe structures and the ground surface. You can also modify the Return Period of the rainfall, the Friction Slope Average Method and the Tailwater Elevation At Outfall to get different hydraulic results, which would help you to edit the sewer network.
Apply button conducts the hydraulic calculation based on your current changes. Save button saves current changes, SaveAs button saves the network data to another file. OK button saves the changes and exit the dialog, while Cancel button abandons the changes and exit the dialog.
|
| Spreadsheet Sewer Editor |
Spreadsheet Sewer Editor dialog: Fill
in
values.
Pulldown Menu Location: Network
> Spreadsheet Sewer Editor
Keyboard Command: sizeswr
Prerequisite: a sewer file
(.SEW), ...\USER\RainLib.dta, ...\USER\inlet.dta, ...\USER\pipesize.dta
(mpipesize.dta in Metric unit)
File Name: \lsp\cntr_grd16.arx