Rating Table

How can I save the discharge rating table (level v flow) for a pipe?

Save pipe rating table

From Version 9.00 you can save the rating table for the pipe selected on the Discharge Information screen by selecting "Save Rating Table to File". A suggested filename is provided, based on the pipe size, class, grade and Colebrooke-White value but this can be changed if you wish. The rating table is saved as a .txt file which can be read into Notepad or Excel (for example) and formatted, graphed etc.

To read it into Excel, select “Open” in Excel, then change the file type to All Files or Text Files.  After selecting the required file, the Text Import Wizard will be displayed. Select Next (Delimited data), then “Comma delimited” and Finish from the next page.  The data will be loaded into Excel, and you can then quickly create graphs or format the data as you need to.

Print pipe rating table

From Version 7.20 you can view or print a rating table for flow in the pipe selected on the Discharge Information screen by selecting "View/Print Rating Table". From Version 9.00 there is also an option to output this to a file (see above).

Print cross-section rating table

After loading in (or creating) a cross-section data file, you can select “Output to file” from the “Output” option on the Main Menu. This creates 3 text files in the same folder as the data file.  (A check is done to see whether the files already exist in that folder, and a warning is given if they do.)  These text files contain:

(i)   the Water Surface Elevation, Discharge, Velocity and Area for the whole cross-section,
(ii)  the Table of Results output values, and
(iii) the Overbank Output values.

The output filename contains the name of the input file, some text to identify what output the file contains, and the current calculation increment.  For example,  if the input filename is “yarra_xs_001.dat” and the calculation increment is 0.01, you will get the following output files:

(i)  “yarra_xs_001_Overbank_01.txt”
(ii)  “yarra_xs_001_TableOfResults_01.txt”
(iii) “yarra_xs_001_WSELQVA_01.txt”

By changing the calculation increment to 0.1 you can cut the output down to about 10% of the size but still end up with the same rating table graph.  The calculation increment value you adopt will depend on the amount of detail you need in your results tables etc.  For the above example, if the calculation increment was changed to 0.1 you would get these three files:

(i)   “yarra_xs_001_Overbank_10.txt”
(ii)  “yarra_xs_001_TableOfResults_10.txt”
(iii) “yarra_xs_001_WSELQVA_10.txt”

The files can be read into Excel by selecting “Open”, and then changing the file type to All Files or Text Files.  After selecting the required output file, the Text Import Wizard will be displayed and you select Next (Delimited data), then “Comma delimited” and Finish from the next page.  The data will be loaded into Excel with column headings, and you can then quickly create graphs or format the data as you need to.