d44d2e67-406f-4630-b64f-00bdbbbee76e 236 3 5 false false 0 decimal
&[FILENAME] - &[PAGENUM] / &[COUNT]
yr 417.693951481753
1. Import Water Level Data (from EXCEL file)
]]> 748 AX748

Directory of Excel file to import

MyDirectory DocumentDirectory : F:\0001. Training ID\1. Vlookup Delay2\

Name of Excel File

MyFile MyDirectory 1.July WL&RT.xlsx concat :

Import Water Levels

WL MyFile WL C5 nn importData.XLSX :

Similarly, Import Rating Table (RT)

RT MyFile RT B4 C404 importData.XLSX :

WL imported as a Matrix to SMath(Only part shown)

WL 0.85 0.74 0.74 0.75 0.73 0.72 0.72 0.72 0.73 0.72 0.71 0.69 0.7 0.71 0.72 0.7 0.7 0.7 0.67 0.71 0.7 0.7 0.68 0.68 0.69 0.69 0.69 0.67 0.67 0.67 0.68 0.7 0.68 0.67 0.68 0.67 0.67 0.67 0.66 0.68 0.68 0.67 0.67 0.66 0.65 0.86 0.9 0.9 0.89 0.93 0.9 0.9 1.11 1.13 0.89 0.9 0.95 0.98 0.9 0.9 0.87 0.87 0.89 0.64 0.63 0.63 0.65 0.64 0.63 0.62 0.63 0.62 0.85 0.92 0.9 0.9 0.91 0.91 0.9 0.93 0.94 9 9 mat 35712 48 744 0.85000002 0.74000001 0.72000003 0.70999998 0.67000002 0.70999998 3 2 mat 35712 1

Rating Table

RT 0.5 4.3 0.51 4.57 0.52 4.84 0.53 5.11 0.54 5.38 0.55 5.65 0.56 5.92 0.57 6.19 0.58 6.46 0.59 6.73 0.6 7 0.61 7.2 12 2 mat

Water level (vector)

WL.col 0.85 0.74 0.74 0.75 0.73 0.72 0.72 0.72 0.73 0.75 0.73 1.04 12 1 mat 0.85 16.75 1 2 mat

wl rt Q Roundoff water level (wl) to 2 decimals, as Rating Table (rt) has 2 decimals Vectorize operator is much faster than element-wise operation in the loop wll wl 2 round vectorize : j 1 wl rows range 'findrows()' suggested by Andey Ivashov to speed up execution q j el rt wll j el 1 findrows 2 el : 2 1 line for q 5 1 line : 16.75 11 11 11.5 10.5 10 10 10 10.5 11.5 10.5 27.4 41.83 38.38 33.4 33.4 34.6 38.38 36.4 38.38 20 1 mat 74.1 28.27 35712 19.774 s * yr 417.693952108366

Program to find daily OR p_day avg flow. There are 48 readings for a day)

A p Find_Q Find daily avg. flow from 'Q.hr' vector r 1 A rows p / trunc range B = vector of 'p' elements B r el A 1 r 1 - ( p * + ( r p * ( range el Mean : 2 1 line for B 3 1 line :
1. Find daily average flows from given half hourly data
]]>
2. Find 'p' day average flows from daily flows
]]>

There are 48 readings for a day

n_read WL cols : 48

Period for analysis

p_day 7 :

Daily avg. flow

Q.daily Q.hr n_read Find_Q :

p_day avg. flow

Q.p_day Q.daily p_day Find_Q :

Daily avg. flow.

Q.daily 24.5638 26.0917 25.376 27.5812 23.939 28.3288 29.2402 24.196 20.7865 31.5275 25.7379 32.0979 32.2281 27.1644 23.3781 31.8506 26.3692 34.4531 32.4712 33.5802 26.806 26.4973 29.6108 23 1 mat

p_day avg. flow

Q.p_day 26.4458 27.6769 29.8441 28.7244 27.3252 26.2508 29.6488 29.51 28.5122 26.3933 27.5601 30.2897 29.446 26.2381 27.4164 29.7021 28.864 28.2469 25.6354 29.1407 29.9697 29.7065 25.7945 23 1 mat 744 106

Program to find p_day moving avg.

A p Find_Q_MA Find 'p_day' moving avg. from daily Q.hr r 1 A rows p - 1 + ( range B r el A r r p + 1 - ( range el Mean : 1 1 line for B 3 1 line : 26.4458 26.3933 25.6354 26.5142 26.2508 27.4164 27.9735 27.6769 27.5601 29.1407 28.4038 29.6488 29.7021 29.8953 29.8441 30.2897 29.9697 30.7111 29.51 28.864 28.409 28.7244 29.446 23 1 mat 7 738 744 738