d44d2e67-406f-4630-b64f-00bdbbbee76e 57 4 5 decimal

1. Import Water Level Data (from EXCEL file)

]]>

Directory of  Excel file to import MyDirectory DocumentDirectory : C:\Users\Andrey\Downloads\

Name of Excel File MyFile MyDirectory 1.July WL&RT.xlsx concat :

To import: Sheet Name, Start cell and End cell WL MyFile WL C5 AX35 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 99 mat

WL length 1488

WL rows 31

WL cols 48

WL.col WL mat2sys sys2mat :

WL.col rows 1488

WL.col cols 1

Similarly, Import Rating Table (RT) RT MyFile RT B4 C404 importData.XLSX :

RT as a Matrix to SMath(Only part shown) 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 7112 mat

RT 0.85 1 findrows 0.85 16.75 12 mat

wl rt Q j 1 wl rows range Convert water level (wl) to 2 decimals As Rating Table (rt) has 2 decimals wll j el wl j el 2 round : q j el rt wll j el 1 findrows 2 el : 41 line for q mat2sys sys2mat 21 line :

Discharge WL.col RT Q : 16.75 1111 11.5 10.5 101010 10.5 11.5 10.5 27.4 41.83 38.38 33.4 33.4 34.6 38.38 36.4 38.38 201 mat

Discharge max 74.1

Discharge Mean 28.27

Discharge length 1488