Original source · versioned page text
iWBNM_2019_Beta_25Pavillion_D05.xlsm
From the archive SMP01-V3 Files.zip (folder SMP01-V3 Files/WBNM/005 SMP01-V2). File date in the archive: 2023-10-04 12:05.
This workbook is very large, so its text here is incomplete: it stops after the first 250,000 cells. Sheets not shown: Hyd, Sta, R1, R1_f, R2, R3, IFD, i. The original file has everything.
[Sheet: Readme]
iWBNM2019 version BETA September 2019
WARNING: This is a BETA version and has not yet been subjected to thorough testing! Please email the bugs you find to the iWBNM Development team, see www.wbnm.com.au
iWBNM is an MSExcel based user interface for WBNM2019. It can be used for building, checking, running WBNM models and then viewing results. iWBNM leverages general user familiarity with MSExcel to provide an efficient model building tool. This version of iWBNM has been tested on Excel 2013 and Windows 8.1 64-bit. Every effort has been made to make the interface simple and intuitive. A typical work flow for model construction will generally move left to right and top to bottom sequentially through each worksheet.
Disclaimer: iWBNM is a tool supplied free of charge in the spirit of making hydrologic modelling a simpler task. Whilst we have tried to minimise any issues, please understand that hydrologic models constructed using iWBNM may unknowlingly contain errors. We advise you to always check the runfile using a text editor before relying on results, and of course we won't take responsibility for errors or issues arising from use of iWBNM.
OVERVIEW OF WORKSHEET FUNCTIONS
Run Worksheet with import/build/run command buttons and where the 'Preamble' block, 'Status' block and Project INI file parameters are defined.
Cat Worksheet where catchments, lags, losses and flowpaths are defined ('Topology', 'Flowpaths, and 'Surfaces' blocks)
Des Worksheet where design storms are defined ('Storm' block)
Rec Worksheet where recorded storms (hyetographs) are defined ('Storm' block)
Str1 Worksheet containing the core information for structures ('Local Structure' and 'Outlet Structure' blocks)
Str2 Worksheet containing additional information for structures (Outlets, HSQ, Tailwater Rating, Basins) - Database tables to the right, simplified viewer on the left ('Structure' block)
R1 Results Sheet 1 - Peak Summaries
R1_f Allows filtering of results on Sheet R1
R2 Results Sheet 2 - Extract Hydrographs
R3 Results Sheet 3 - Summary from critdes.out file
Hyd Advanced - by default hidden sheet where imported / recorded hydrographs can be defined ('Storm' block - ADVANCED WORKSHEET)
Sta Advanced - by default hidden sheet where stage hydrographs can be entered for comparison purposes with the WBNM computed stage hydrograph ('Storm' block - ADVANCED WORKSHEET)
IFD Advanced - by default hidden sheet - ARR87 IFD Database ('Storm' block - ADVANCED WORKSHEET)
L Advanced - by default hidden sheet - Lite version of iWBNM for simple applications
i Hidden worksheet to store parameters for macros.
TIPS / KNOWN ISSUES
A iWBNM19 imports old file formats, but no longer supports writing out in pre2019 formats.
B ARR Gauges must be stored as .csv files in the runfile .wbn directory
C ARR87 Gauges can be used but external files are no longer supported, coefficients must be entered on IFD worksheet in iWBNM
D IMPORT Option: "All design storms have the same gauges", gauges per version type will only show once in the Design Gauge table
E Note that WBNMRun.exe uses ARI for 1987 design storms, but AEP for ARR 2019 design storms!
F Storm specific losses are not supported, only one loss model per build file (fixed per catchment). iWBNM2019 imports the losses in the first storm in the Run .wbn file.
G Whilst the WBNM engine supports GLOBAL losses, this has been removed from iWBNM2019 for simplicity, as FILL buttons are provided on the catchment sheet
H Writing of coordinates in the Display Block is currently not supported by iWBNM2019. Do this manually in text editor if important to you.
I When downloading BOM IFD file you must use MGA coordinates not Lat Long, or WBNMrun.exe will not run.
J Keep in mind, if you run a Duration Spectrum, the 7 day storm patterns will be run and will take a substantial amount of computing time. Use Project Ini to constrain durations
K If you crash out the Structure Viewer on Str2, then save and re-open iWBNM, as variables need to be re-initialized
L Scourable weirs are not viewable in the Structure Viewer on the Str2 sheet, but can be edited easily from the Outlet Database adjacent
M WBNMRun.exe has issues with HSQ local structures, problem to be determined. Use a HS structure instead.
N WBNMRun.exe only supports 1 SINK! Use a dummy subarea instead of multiple SINKs
O iWBNM does not support writing out of manual Raingauge Weights, this needs to be edited in the .wbn file manually via START_INPUT_RAINGAUGE_WEIGHTS
P Areal or Point Pattern files per ARR Design Storm are supported.
Q
R
S
T
U
V
BUGS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
[Sheet: Run]
D:\Projects\JustRoso\2016_1 WBNM\iWBNM2019\Exe\*
Build and Run
Initial Setup Build / Run / Results
Clear Entire XL Template Import a WBNM .wbn file
Project INI options Build the WBNM .wbn file
Format Ranges (Calibri 10 Bold) Run a WBNM .wbn File
Select WBNM exe and Runfile Folder Import WBNM Results
WBNM exe file: D:\Programs\WBNM2019\wbnm2019_w64.exe
Runfile (.wbn) folder: D:\Projects\2019 OPT Projects\Balgownie - Subdivision [Flood]\WBNM
Show/Hide Advanced Worksheets
Build Edit 'Preamble'
Project ID:
Project Description:
Comments:
Line 4:
Line 5:
Line 6:
Line 7:
Line 8:
Build Edit 'Status'
Line 1: File Path
Line 2: Date of Last Edit
Line 3: Author
Line 4: WBNM Version Number
IMPORT OPTION RUN OPTIONS
BUILD OPTIONS
Last File Built: D:\Projects\2019 OPT Projects\Balgownie - Subdivision [Flood]\WBNM\100yr_120m_AC.wbn
Last File Run: D:\Projects\2019 OPT Projects\Balgownie - Subdivision [Flood]\WBNM\100yr_120m_AC.wbn
Last File Imported: D:\Projects\2019 OPT Projects\Balgownie - Subdivision [Flood]\WBNM\Balgownie-01.wbn
ARR Datahub Files
Point ARR Pattern Filename Areal ARR Pattern Filename
LOAD
ARR Catchment Filename (from Datahub - must be located in *.wbn folder) [TXT]
LOAD
Constants
Routing Constants
Constant 1: 0.77 Non-linearity exponent [default 0.77]
Constant 2: -99.9 Discharge when routing switches [default -99.9]
[Sheet: L]
iWBNM Lite
Comment#1 33 Pavilion Street
Comment#2 Developed (D05) IMPORT SAVE & RUN
Comment#3 ARR19 IL & CL CLEAR_ALL BROWSE WBNM_Run: C:\Projects (C drive)\33 Pavilion\001\wbnm2019_w64.exe
RESULTS_ONLY BROWSE ARR2019 Gauge C:\Projects (C drive)\33 Pavilion\004 Layout Updates\PomonaIFD.csv Note this must be in same location as runfile
GENERAL_PARAMETERS DEFAULTS BROWSE ARR_Catchment: QLD_ARR_Datahub.txt Note this must be in same location as runfile
Lag Parameter (C) 1.6 Name 5% AEP 2% AEP 1% AEP 1% AEP CC Area BROWSE ARR_Patterns: QLD_ECnorth_Increments.csv Note this must be in same location as runfile
Stream Lag Factor 1 EX2 0.3 0.61799999999999999 0.78200000000000003 1.032 1.96 LAST_BUILD: C:\Projects (C drive)\33 Pavilion\004 Layout Updates\runfiles\004.wbn
Calculation Timestep 1 mins EX1 4.8599999999999997E-2 9.2999999999999999E-2 0.11550000000000001 0.152 0.28699999999999998
Initial Loss 35 mm
Continuing Loss Rate 2.4 mm/hr RAINGAUGE TIPS PomonaIFD
TOPOLOGY STORMS TIPS ARR STRUCTURE
Subarea Name Connects_to Area_ha Imp_% Storm# AEP (ARI) Dura_mins Subarea IWL D-Fact Type %Per to LS %Imp to LS
1 EX2 SUB3 0.78200000000000003 50 1 1 10 HS
2 Ex1 SUB1 0.11550000000000001 50 2 1 15 WEIRS Weir#1 Weir#2 PIPES Pipe#1 Pipe#2 Pipe#3 Elevation_m Storage_m3
3 SUB3 SUB1 1.78 50 3 1 20 Diverts to Sub Diverts to Sub
4 SUB1 SUB2 2.0790000000000002 50 4 1 25 Crest Elev [m] Invert [m]
5 SUB2 SUB4 1.3540000000000001 5 5 1 30 Length [m] No. Barrels
6 SUB4 SINK 0.81899999999999995 6.5 6 1 45 Weir Coeff Ent. Type
7 7 1 60 D_Fact Dia/(Width)[mm]
8 8 1 90 Directed to (Height)[mm]
9 9 1 120 Delay [mins] Disch-Factor
10 10 1 180 Directed to
11 11 1 270 Delay [mins]
12 12 1 360
SINK
RESULTS
1 2 3 4 5 6 7 8 9 10 11 12
Structure Averages 1 AEP 10 mins 1 AEP 15 mins 1 AEP 20 mins 1 AEP 25 mins 1 AEP 30 mins 1 AEP 45 mins 1 AEP 60 mins 1 AEP 90 mins 1 AEP 120 mins 1 AEP 180 mins 1 AEP 270 mins 1 AEP 360 mins
EX2 0.27 0.30480000000000007 0.29930000000000001 0.31660000000000005 0.33120000000000005 0.30159999999999998 0.27900000000000003 0.25170000000000003 0.24259999999999998 0.21340000000000003 0.1827 0.20830000000000001
Ex1 4.4099999999999986E-2 5.3100000000000001E-2 5.1099999999999993E-2 5.3799999999999994E-2 5.4599999999999996E-2 5.1299999999999991E-2 4.5599999999999995E-2 4.0799999999999989E-2 3.8800000000000001E-2 3.2600000000000004E-2 2.7600000000000003E-2 3.1399999999999997E-2
SUB3 0.71640000000000004 0.81850000000000001 0.84239999999999993 0.89129999999999987 0.93149999999999999 0.84150000000000014 0.80950000000000011 0.74409999999999998 0.7137 0.66270000000000007 0.56940000000000002 0.64850000000000008
SUB1 1.0920000000000001 1.3032000000000001 1.3911000000000002 1.4862999999999997 1.5422 1.4206999999999999 1.3867999999999998 1.2979000000000001 1.2349000000000001 1.1662000000000001 1.0093000000000001 1.1442000000000001
SUB2 0.83699999999999997 1.2355 1.4905000000000002 1.6897000000000002 1.7317 1.714 1.6838000000000002 1.5783 1.4912000000000001 1.4039999999999999 1.2272000000000003 1.3992
SUB4 0.74499999999999988 1.1968000000000001 1.5099000000000002 1.7533999999999998 1.8312999999999999 1.8869000000000002 1.8492000000000002 1.7418 1.6463999999999999 1.5329999999999999 1.3517000000000001 1.5457000000000001
Structure_averages
Inflow Peak [m3/s]
Outflow Peak [m3/s]
Inflow Volume [m3]
Max Vol Stored [m3]
Max Water Elev [m]
ARR2019 Actual above mean
EX2 0.27100000000000002 0.316 0.3 0.31900000000000001 0.33400000000000002 0.30199999999999999 0.29799999999999999 0.25700000000000001 0.249 0.219 0.19400000000000001 0.22600000000000001
Ex1 4.4999999999999998E-2 5.6000000000000001E-2 5.1999999999999998E-2 5.5E-2 5.5E-2 5.6000000000000001E-2 4.5999999999999999E-2 4.2999999999999997E-2 0.04 3.4000000000000002E-2 2.9000000000000001E-2 3.4000000000000002E-2
SUB3 0.71799999999999997 0.82 0.86 0.90600000000000003 0.95499999999999996 0.86 0.81699999999999995 0.78300000000000003 0.77 0.69699999999999995 0.60799999999999998 0.65
SUB1 1.0940000000000001 1.3280000000000001 1.4239999999999999 1.496 1.571 1.4259999999999999 1.401 1.359 1.276 1.212 1.012 1.177
SUB2 0.83699999999999997 1.24 1.496 1.6910000000000001 1.7509999999999999 1.8029999999999999 2.2400000000000002 1.605 1.597 1.43 1.238 1.4630000000000001
SUB4 0.745 1.2 1.5209999999999999 1.7649999999999999 1.879 1.9770000000000001 2.4249999999999998 1.7609999999999999 1.7789999999999999 1.5369999999999999 1.36 1.6180000000000001
Structure Actual above mean
Inflow Peak [m3/s]
Outflow Peak [m3/s]
Inflow Volume [m3]
Max Vol Stored [m3]
Max Water Elev [m]
D05 Results
10 15 20 25 30 45 60 90 120 180 270 360 MAX
1 0.74499999999999988 1.1968000000000001 1.5099000000000002 1.7533999999999998 1.8312999999999999 1.8869000000000002 1.8492000000000002 1.7418 1.6463999999999999 1.5329999999999999 1.3517000000000001 1.5457000000000001 1.8869000000000002
2 0.59299999999999986 0.95 1.2161000000000002 1.4338999999999997 1.5112000000000001 1.581 1.5628 1.482 1.4026999999999998 1.3001999999999998 1.1415000000000002 1.3089000000000002 1.581
5 0.47730000000000006 0.64580000000000004 0.85529999999999995 0.98809999999999987 1.0998999999999999 1.2208000000000001 1.1616 1.1648000000000001 1.1994000000000002 1.1141000000000001 1.075 1.0379 1.2208000000000001
10 0.39319999999999994 0.48069999999999996 0.59519999999999995 0.69540000000000002 0.78369999999999995 0.90130000000000021 0.88930000000000009 0.90280000000000005 0.93770000000000009 0.88559999999999994 0.84420000000000006 0.80489999999999995 0.93770000000000009
20 0.32530000000000003 0.40160000000000007 0.4345 0.46889999999999998 0.52360000000000007 0.60829999999999995 0.67100000000000004 0.72699999999999998 0.67020000000000002 0.70669999999999999 0.68870000000000009 0.5958 0.72699999999999998
50 0.22600000000000003 0.2833 0.30829999999999996 0.31619999999999998 0.31779999999999997 0.29320000000000007 0.30669999999999997 0.37500000000000006 0.37860000000000005 0.39750000000000002 0.43380000000000002 0.36459999999999998 0.43380000000000002
63.2 0.19530000000000003 0.24460000000000001 0.26869999999999999 0.27690000000000003 0.27789999999999998 0.25679999999999997 0.24710000000000004 0.25490000000000002 0.27789999999999998 0.30439999999999995 0.34360000000000002 0.29480000000000001 0.34360000000000002
1% CC 1.1724000000000001 1.7951000000000001 2.1869999999999998 2.4777 2.5173000000000001 2.5238 2.4187000000000003 2.2471000000000001 2.1007000000000002 1.9561999999999997 1.7280000000000002 1.9756999999999993 2.5238
[Sheet: Cat]
SUBAREA_NAME DOWNSTREAM_SUB_ID AREA CG_E CG_N OUTLET_E OUTLET_N IMPERVIOUS% LAG_PARAMETER IMPERVIOUS_LAG_FACTOR TYPE INITIAL_LOSS LOSS_RATE IMP_I_L RUNOFF_PROP F0 FC K STREAM_ROUTING_TYPE STREAM_LAG_FACTOR DELAY MUSKINGUM_K
PrimaryKey - Text ForeignKey - Text Number Number Number Number Number Number Number Number Text Number Number Number Number Number Number Number Text Number Number Number
18 characters maximum Subarea ID of each subarea (hectares) East coordinates of centre of subarea North coordinates of centre of subarea East coordinates of subarea outlet ELIMINATE ? North coordinates of subarea outlet ELIMINATE ? for urban subareas, the impervious area, as a percent controls hydrograph shape and peak discharge, used for fitting calculated and recorded hydrographs, value should be about 1.70 (see User Guide for calibrated values) reduction factor for lag time on impervious surfaces compared to natural catchment surfaces, recommend 0.10 LOSSRATES
RUNOFFPROPORTIONS
HORTON
TIMEVARYING on pervious surfaces (mm) (mm/hour) initial loss on impervious surfaces of catchment (mm) runoff proportion (range 0 to 1.0) Horton initial infiltration rates (mm/hour) Horton final infiltration rates (mm/hour) Horton time constant (1/hours) (#####ROUTING, #####DELAY or #####MUSK) for #####ROUTING, value is 1.0 for natural streams. If the stream is modified so that velocities and hence lag times change, use a different factor, eg 0.90 for #####DELAY, time by which hydrograph is delayed in moving through stream segment (minutes) for #####MUSK, Muskingum lag parameter (minutes)
must be the same for all SUBTYPE LOSSRATES
RUNOFFPROPORTIONS SUBTYPE LOSSRATES ALL SUBTYPES SUBTYPE RUNOFFPROPORTIONS SUBTYPE HORTON SUBTYPE HORTON SUBTYPE HORTON R D M
Catchments, Lags, Losses, Flowpaths Location:
Catchment Details Lag Losses Flowpaths
SORT MID/MIF FILL FILL LOSSRATES FILL
Subarea Name D/S Subarea Area [ha] CGE CGN Out E Out N Imp Fraction C Imp Lag Type IL CLR ImpIL N/A N/A N/A N/A Type Stream Lag Factor Delay (mins) Musk K Musk X (mins)
[Sheet: Des]
Design Storms
Parameter Values Rainfall
UPDATE DROP
DES Storm Name Storm Description ARRVersion Design Burst ARI / AEP Design Burst Duration Pattern No. ARF PAC Catchment Embed Envelope ARI Embed Envelope Duration Calc. Step Out Step Areal / Point Pattern Gauge_ID Gauge_Name ARR Version DES Storm Name
[Sheet: Rec]
STORM_ID DESCRIPTION_OF_STORM EVENT_DATE EVENT_TIME TIME_STEP_OF_HYETOGRAPH RAIN_UNITS CALCULATION_TIME_STEP TIME_STEP_FOR_OUTPUT_TO_METAFILE
PrimaryKey - Number Text Date Time Number Text Number Number
128 character description of the storm text string, eg 01/01/2005 text string, eg 0645 of each rain period (minutes) (MM/HOUR or MM/PERIOD or PERCENT) calculations are made at this time step (minutes) to avoid large output files, you can write results at a longer time step. Must be a multiple of the calculation time step (minutes)
SUBTYPE RECORDED RAIN SUBTYPE RECORDED RAIN SUBTYPE RECORDED RAIN
Recorded Storm Data (Hyetographs) Gauge Data
Event Data Event No.
Gauge Name
Number Descr Event Date Event Time Time Step Rain Units Calc. Step Out Step Gauge E
Gauge N
Raintotal [mm]
Multiplier
Values
mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period mm/period
[Sheet: Str1]
Structure Summary Local Basin Details Tailwater_Details Directed Subareas
Lock ID Subarea Type Description of Structure Local / Out %Per to LS %Imp to LS IWL Surf_Area Stor_Fac TW_ELEV CHNL_BED_WIDTH CHNL_S_SLOPE CHNL_BED_SLOPE% CHNL_n DS_CHNL_BED_ELEV 1 2 3 4 5
STRUCTURE_ID SUBAREA_ID DOWNSTREAM_CHANNEL_BED_ELEVATION
PrimaryKey - Number ForeignKey - Text Number
Subarea ID See the original
The page text is free to read. Viewing or downloading an original file needs an account.
Log in to see the originalFull text of the other 1 section
Section 2
(metres) [Sheet: Str2] Structure Details TIPS Details Viewer / Editor Clean all databases (done automatically at BUILD TIME) CLEAN Databases --> ID Subarea MTO-14 OUTLET HS 14 Save Template to Databases SAVE Outlet Database HSQ Tailwater Rating Basins 1 #N/A Weir Subarea Crest Elev. Lenth [m] Weir Coeef. Disch. Fact. Blck_Time Directed To Delay [mins] STRUCTURE_ID OUTLETS_ID STRUCTURE_TYPE SUBAREA_NAME DISCHARGE_FACTOR BLOCKAGE_TIME DELAY_TIME_TO_BOTTOM_OF_SUBAREA DIRECT_TO_TOP_OR_BOTTOM_OF_SUBAREA INVERT_ELEVATION_AT_ENTRANCE WEIR_LENGTH WEIR_COEFFICIENT NUMBER_OF_OUTLETS_IN_THIS_BLOCK ENTRANCE_TYPE BOX_CULVERT_WIDTH or PIPE_CULVERT_DIAMETER BOX_CULVERT_DEPTH ENTRANCE_COEFFICIENT CULVERT_LENGTH OUTLET_INVERT_ELEVATION CULVERT_MANNING_N SCOURABLE_WEIR_CREST_LENGTH SCOURABLE_WEIR_BOTTOM_ELEVATION SCOURABLE_WEIR_TOP_WIDTH SCOURABLE_WEIR_BOTTOM_WIDTH PILOT_CHANNEL_CREST_LENGTH PILOT_CHANNEL_CREST_ELEVATION SCOUR_FACTOR TIME_WHEN_SCOUR_STARTS STRUCTURE_ID SUBAREA_NAME DIRECT_TO_TOP_OR_BOTTOM_OF_SUBAREA DISCHARGE_FACTOR BLOCKAGE_TIME DELAY_TIME_TO_BOTTOM_OF_SUBAREA STRUCTURE_ID H Q STRUCTURE_ID H S Q1 Q2 Q3 Q4 Q5 Q6 2 #N/A 1 3 #N/A 2 4 #N/A 3 5 #N/A 4 6 #N/A 5 7 #N/A Pipes / Box Subarea Invert No. Ent. Type. Dia / Width [mm] Height [mm] Disch. Fact. Blck_Time Directed To Delay [mins] Ent. Coeff. Length [m] Out. Invert n 8 #N/A 1 9 #N/A 2 10 #N/A 3 11 #N/A 4 12 #N/A 5 13 #N/A Height / Storage 14 #N/A H_m S_m3 15 #N/A 16 #N/A 17 #N/A 18 #N/A 19 #N/A 20 #N/A 21 #N/A 22 #N/A 23 #N/A 24 #N/A 25 #N/A 26 #N/A