Rational method Check HGL outputs

Rational method Check HGL outputs

Detailed results from rational method calculations can be obtained in tables suitable for checking using the Copy Check HGL to Spreadsheet option in the Edit menu. Currently a 56-column output is provided, illustrated by the example shown below.  

  

Information on approach flow characteristics in is presented in Columns L to O. The information on pit pressure changes is shown below, with the QUDM Chart number and the ratios used to derive the K values being noted in Columns AH and AI.

Note that this table does not exactly reproduce the DRAINS results given in the spreadsheet Results output in the Edit menu, which is based on extensive calculations that cannot be practically duplicated by hand. The check calculations should be viewed as a conservative, parallel set of calculations to the DRAINS computations. If the results they portray are considered to be inadequate, the model can be changed manually.  

A Rational Method Output Converter Spreadsheet, available for download on www.watercom.com.au, converts rational method Check HGL outputs from minor and major runs into formats in QUDM and in manuals prepared by Brisbane City Council and Pine Rivers Shire Council (now part of the Moreton Bay Regional Council). Macros in the spreadsheet re-arrange the results to produce an output such as that shown below:

There is also a more general spreadsheet named DRAINS Output Converter.xls, which also processes rational method data.

The Main worksheet contains instructions and runs the macros that convert DRAINS outputs in the worksheets with yellow tags to reformatted sheets with the green tags.