Spreadsheet: 674204d1587716189-need-help-with-sum-and-average-calc-item_balance
Sheet: item_balance

date | item | value | factor |  | trying to accomplish
2020-04-24T07:00:00+00:00 | rood | 0.00810314 | 0.000015 |  | * total sum of values in  column C =
2020-04-24T06:00:00+00:00 | rood | 0.00754312 | 0.000014 |  | * the average of all the values in column D =
2020-04-24T05:00:00+00:00 | rood | 0.01622626 | 0.00003 |  | * the amount of cells in column D with positive values =
2020-04-24T04:00:00+00:00 | rood | 0.01185164 | 0.000022 |  | * the amount of cells in column D with negative values =
2020-04-24T03:00:00+00:00 | rood | 0.01721477 | 0.000032
2020-04-24T02:00:00+00:00 | rood | 0.01392423 | 0.000026
2020-04-24T01:00:00+00:00 | rood | 0.01072427 | 0.00002
2020-04-24T00:00:00+00:00 | rood | 0.02033498 | 0.000038
2020-04-23T23:00:00+00:00 | rood | 0.00539793 | 0.00001
2020-04-23T22:00:00+00:00 | rood | 0.0151818 | 0.000028
2020-04-23T21:00:00+00:00 | rood | -0.00430502 | -0.000008
2020-04-23T20:00:00+00:00 | rood | 0.00376107 | 0.000007
2020-04-23T19:00:00+00:00 | rood | 0.01887236 | 0.000035
2020-04-23T18:00:00+00:00 | rood | -0.00107626 | -0.000002
2020-04-23T17:00:00+00:00 | rood | -0.00429104 | -0.000008
2020-04-23T16:00:00+00:00 | rood | -0.00701947 | -0.000013
2020-04-23T15:00:00+00:00 | rood | 0.01725206 | 0.000032
2020-04-23T14:00:00+00:00 | rood | 0.00423376 | 0.000008
2020-04-23T13:00:00+00:00 | rood | 0.00736479 | 0.000014
2020-04-23T12:00:00+00:00 | rood | 0.00732633 | 0.000014
2020-04-23T11:00:00+00:00 | rood | -0.00519064 | -0.00001
2020-04-23T10:00:00+00:00 | rood | 0.00520812 | 0.00001
2020-04-23T09:00:00+00:00 | rood | -0.02853019 | -0.000055
2020-04-23T08:00:00+00:00 | rood | -0.03777619 | -0.000073
2020-04-23T07:00:00+00:00 | rood | -0.0365639 | -0.000071
2020-04-23T06:00:00+00:00 | rood | -0.04369226 | -0.000084
2020-04-23T05:00:00+00:00 | rood | -0.06714179 | -0.000129
2020-04-23T04:00:00+00:00 | rood | -0.03864482 | -0.000074
2020-04-23T03:00:00+00:00 | rood | -0.01887211 | -0.000036
2020-04-23T02:00:00+00:00 | rood | -0.0147156 | -0.000028
2020-04-23T01:00:00+00:00 | rood | -0.03340656 | -0.000064
2020-04-23T00:00:00+00:00 | rood | -0.01410463 | -0.000027
2020-04-22T23:00:00+00:00 | rood | -0.00104279 | -0.000002
2020-04-22T22:00:00+00:00 | rood | -0.00155994 | -0.000003
2020-04-22T21:00:00+00:00 | rood | 0.00313436 | 0.000006
2020-04-22T20:00:00+00:00 | rood | -0.00260281 | -0.000005
2020-04-22T19:00:00+00:00 | rood | 0.00052173 | 0.000001
2020-04-22T18:00:00+00:00 | rood | 0.00155869 | 0.000003
2020-04-22T17:00:00+00:00 | rood | -0.00575457 | -0.000011
2020-04-22T16:00:00+00:00 | rood | -0.00052472 | -0.000001
2020-04-22T15:00:00+00:00 | rood | 0.00575366 | 0.000011
2020-04-22T14:00:00+00:00 | rood | -0.01038294 | -0.00002
2020-04-22T13:00:00+00:00 | rood | -0.01739625 | -0.000034
2020-04-22T12:00:00+00:00 | rood | -0.03012867 | -0.000059
2020-04-22T11:00:00+00:00 | rood | -0.02093688 | -0.000041
2020-04-22T10:00:00+00:00 | rood | -0.00410589 | -0.000008
2020-04-22T09:00:00+00:00 | rood | -0.01377421 | -0.000027
2020-04-22T08:00:00+00:00 | rood | -0.03484912 | -0.000068
2020-04-22T07:00:00+00:00 | rood | -0.02046951 | -0.00004
2020-04-22T06:00:00+00:00 | rood | -0.01375398 | -0.000027
2020-04-22T05:00:00+00:00 | rood | -0.02928002 | -0.000058
2020-04-22T04:00:00+00:00 | rood | -0.04622207 | -0.000092
2020-04-22T03:00:00+00:00 | rood | -0.01672801 | -0.000033
2020-04-22T02:00:00+00:00 | rood | -0.02905791 | -0.000058
2020-04-22T01:00:00+00:00 | rood | -0.04508237 | -0.00009
2020-04-22T00:00:00+00:00 | rood | -0.03971042 | -0.000079
2020-04-21T23:00:00+00:00 | rood | -0.06119499 | -0.000121
2020-04-21T22:00:00+00:00 | rood | -0.0498158 | -0.000098
2020-04-21T21:00:00+00:00 | rood | -0.03353843 | -0.000066
2020-04-21T20:00:00+00:00 | rood | -0.04887141 | -0.000097
2020-04-21T19:00:00+00:00 | rood | -0.05124828 | -0.000101
2020-04-21T18:00:00+00:00 | rood | -0.05374121 | -0.000106
2020-04-21T17:00:00+00:00 | rood | -0.05675394 | -0.000113
2020-03-11T20:00:00+00:00 | rood | -0.00928697 | 0.000017
2020-03-11T19:00:00+00:00 | rood | -0.00814115 | 0.000015
2020-03-11T18:00:00+00:00 | rood | -0.00960816 | 0.000018
2020-03-11T17:00:00+00:00 | rood | 0 | 0
2020-03-11T16:00:00+00:00 | rood | -0.01202401 | 0.000022