The Excel spreadsheet below illustrates a simple example of a BC database setup in a worksheet that is exported as a .csv file for use by TUFLOW and/or ESTRY.
TUFLOW or ESTRY search through the file until a row is found with the two keywords Name and Source. Name and Source do not have to be located in Columns 1 and 2.
Table 4 .21 describes the purpose of each keyword and the default column where applicable. At present a range of formats are accepted, and other formats can be incorporated upon request.
The example above is interpreted as follows:
-
A BC data event named “h=2” is located in the file heads.csv. The time values are located under a column called “Time” and the BC values are located under a column “h=2”.
-
As an alternative to “h=2” above, a BC data event “h=2 (alternative)” is set a constant value of 2.
-
“River Inflow” is located in flows.csv using time column “Time 1” and BC values from column “River Flow”. Similarly, “Creek Inflow” and “Base Flow” are also located in flows.csv.
-
A BC data event named “RAFTS Inflow” extracts the hydrograph from a RAFTS-XP .tot file named “rafts.tot” for RAFTS node “IN”.
The heads.csv and flows.csv files are created by saving the worksheets “heads.csv” and “flows.csv” as .csv files (see below).
Dostları ilə paylaş: |
