Spreadsheet: 52432d1252132892-diagonal-matrix-fill-uh1
Sheet: Convo2

Convolution of The Predicted UHG with Rainfall Excess
Time (hr) | UH | PE ([NAME]) |  |  |  |  |  |  | Calc | Actual Q
0 | 0 | 1.13 | 0 |  |  |  |  |  | 0 | 0 | 0
1 | -0.0399063474696013 | 0 | -0.04509417264064946 | 0 |  |  |  |  | -0.04509417264064946 | 0.03 | -0.04509417264064946
2 | 0.2898698329740896 | 3.52 | 0.3275529112607212 | 0 | 0 |  |  |  | 0.3275529112607212 | 0.11 | 0.3275529112607212
3 | 0.8437128285025588 | 5.55 | 0.9533954962078913 | 0 | -0.1404703430929966 | 0 |  |  | 0.8129251531148948 | 0.62 | 0.8129251531148948
4 | 1.074976371376156 | 1.48 | 1.214723299655057 | 0 | 1.020341812068795 | -0.2214802284562872 | 0 |  | 2.013584883267565 | 2.12 | 2.013584883267565
5 | 0.8521651398102259 | 0.72 | 0.9629466079855552 | 0 | 2.969869156329007 | 1.608777573006197 | -0.05906139425500992 | 0 | 5.48253194306575 | 5.45 | 5.48253194306575
6 | 0.9922837714432854 |  | 1.121280661730912 | 0 | 3.783916827244071 | 4.682606198189201 | 0.4290073528016526 | -0.02873257017811293 | 9.988078469787723 | 10.06 | 9.988078469787723
7 | 0.577650172139234 |  | 0.6527446945173343 | 0 | 2.999621292131995 | 5.966118861137668 | 1.248694986183787 | 0.2087062797413445 | 11.07588611371213 | 11 | 11.07588611371213
8 | 0.6245867024473696 |  | 0.7057829737655276 | 0 | 3.492838875480365 | 4.729516525946754 | 1.590965029636711 | 0.6074732365218423 | 11.1265766413512 | 11.19 | 11.1265766413512
9 | 0.3436750701728931 |  | 0.3883528292953692 | 0 | 2.033328605930103 | 5.507174931510233 | 1.261204406919134 | 0.7739829873908326 | 9.964043761045673 | 9.9 | 9.964043761045673
10 | 0.3880924733821518 |  | 0.4385444949218315 | 0 | 2.198545192614741 | 3.205958455372748 | 1.468579981736062 | 0.6135589006633626 | 7.925187025308746 | 7.99 | 7.925187025308746
11 | 0.1477376953658437 |  | 0.1669435957634033 | 0 | 1.209736247008584 | 3.466456198582901 | 0.8549222547660663 | 0.7144443154391654 | 6.412502611560121 | 6.35 | 6.412502611560121
12 | 0.252338019587771 |  | 0.2851419621341812 | 0 | 1.366085506305174 | 1.907396639459557 | 0.924388319622107 | 0.4159081239402485 | 4.898920551461268 | 4.96 | 4.898920551461268
13 | 0.07776341662963646 |  | 0.08787266079148918 | 0 | 0.5200366876877697 | 2.153913227270942 | 0.5086391038558818 | 0.4497024257621061 | 3.720164105368188 | 3.66 | 3.720164105368188
14 | 0.1690899916826818 |  | 0.1910716906014304 | 0 | 0.888229828948954 | 0.8199442092804323 | 0.5743768606055847 | 0.247446050524483 | 2.721068639960884 | 2.78 | 2.721068639960884
15 | 0.04019566440516566 |  | 0.0454211007778372 | 0 | 0.2737272265363203 | 1.400476008712129 | 0.2186517891414486 | 0.2794265808351493 | 2.217702706002885 | 2.16 | 2.217702706002885
16 | 0.1210675253824527 |  | 0.1368063036821715 | 0 | 0.5951967707230398 | 0.4315869622944823 | 0.3734602689899011 | 0.1063711406634074 | 1.643421446353002 | 1.7 | 1.643421446353002
17 | 0.02545744901785557 |  | 0.0287669173901768 | 0 | 0.1414887387061831 | 0.9384494538388838 | 0.115089856611862 | 0.1816833741031951 | 1.405478340650301 | 1.35 | 1.405478340650301
18 | 0.07971214696678884 |  | 0.09007472607247138 | 0 | 0.4261576893462335 | 0.2230859374486694 | 0.250253187690369 | 0.05598965997333825 | 1.045561200531082 | 1.1 | 1.045561200531082
19 | 0.009365334794697906 |  | 0.01058282831800863 | 0 | 0.08961022054285163 | 0.6719247658726124 | 0.05948958331964518 | 0.1217447940115309 | 0.9533521920646486 | 0.9 | 0.9533521920646486
20 | 0.04263625479521061 |  | 0.04817896791858799 | 0 | 0.2805867573230967 | 0.1412888420490984 | 0.17917993756603 | 0.02894087837171928 | 0.6781753832285325 | 0.73 | 0.6781753832285325
21 | 0 |  | 0 | 0 | 0.03296597847733663 | 0.4424024156656781 | 0.03767702454642625 | 0.08716861827536593 | 0.6002140369648069 | 0.55 | 0.6002140369648069
22 |  |  |  | 0 | 0.1500796168791413 | 0.05197760811057338 | 0.1179739775108475 | 0.01832936329285601 | 0.3383605657934182 | 0.39 | 0.3383605657934182
23 |  |  |  |  | 0 | 0.2366312141134189 | 0.0138606954961529 | 0.05739274581608796 | 0.3078846554256597 | 0.25 | 0.3078846554256597
24 |  |  |  |  |  | 0 | 0.0631016570969117 | 0.006743041052182492 | 0.06984469814909419 | 0.12 | 0.06984469814909419
25 |  |  |  |  |  |  | 0 | 0.03069810345255164 | 0.03069810345255164 | 0.04 | 0.03069810345255164
26 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 85.50999999999999 | 85.71462196624019
 |  |  |  |  |  |  | Total Runoff Volume |  |  | 307835.9999999999 | 308572.6390784647 | m3