Spreadsheet: 708757d1608014765-moving-average-if-the-difference-between-two-date-hours-is-less-than-value-sample
Sheet: Ark1

Date/time | Data
2017-09-06 15:57:00 | 0 | Average between A2 and A16
2017-09-06 16:00:59 | 0 | Average between A3 and A17
2017-09-06 16:04:58 | 8.867 | Average between A4 and A18
2017-09-06 16:09:01 | 8.087 | Average between A5 and A19
2017-09-06 16:13:00 | 6.79 | Average between A6 and A20
2017-09-06 16:16:59 | 5.822 | Average between A7 and A21
2017-09-06 16:20:58 | 4.773 | Average between A8 and A22
2017-09-06 16:25:01 | 4.003 | Average between A9 and A23
2017-09-06 16:29:00 | 3.408 | Average between A10 and A24
2017-09-06 16:32:59 | 2.892 | Average between A11 and A25
2017-09-06 16:36:58 | 2.465 | Average between A12 and A26
2017-09-06 16:41:00 | 2.219 | Average between A13 and A27
2017-09-06 16:45:00 | 2.078 | Average between A14 and A28
2017-09-06 16:48:59 | 1.964 | Average between A15 and A29
2017-09-06 16:53:01 | 1.863 | Average between A16 and A30
2017-09-06 16:57:00 | 1.82 | Average between A17 and A31
2017-09-06 17:00:59 | 1.808 | Average between A18 and A32
2017-09-06 17:04:58 | 1.74 | Average between A19 and A33
2017-09-06 17:09:01 | 1.61 | Average between A20 and A34
2017-09-06 17:13:00 | 1.459 | Average between [NAME] and [NAME]
2017-09-06 17:16:59 | 1.328 | Average between A22 and A36
2017-09-06 17:20:58 | 1.212 | Average between A23 and A37
2017-09-06 17:25:01 | 1.117 | Average between A24 and A38
2017-09-06 17:29:00 | 1.04 | Average between A25 and A39
2017-09-06 17:32:59 | 1.048 | Average between A26 and A40
2017-09-06 17:36:58 | 1.095 | Average between A27 and A41
2017-09-06 17:41:00 | 1.169 | Average between A28 and A42
2017-09-06 17:45:00 | 1.248 | Average between A29 and A43
2017-09-06 17:48:59 | 1.326 | Average between A30 and A44
2017-09-06 17:53:01 | 1.407 | Average between A31 and A45
2017-09-06 17:57:00 | 1.476 | Average between A32 and A46
2017-09-06 18:00:59 | 1.517 | Average between A33 and A47
2017-09-06 18:04:58 | 1.526 | Average between A34 and A48
2017-09-06 18:09:01 | 1.519 | Average between [NAME] and A49
2017-09-06 18:13:00 | 1.505 | Average between A36 and [NAME]
2017-09-06 18:16:59 | 1.488 | Average between A37 and A51
2017-09-06 18:20:58 | 1.475 | Average between A38 and A52
2017-09-06 18:25:01 | 1.473 | Average between A39 and A53
2017-09-06 18:29:00 | 1.488 | Average between A40 and [NAME]
2017-09-06 18:32:59 | 1.537 | Average between A41 and A55
2017-09-06 18:36:58 | 1.66 | Average between A42 and A56
2017-09-06 18:41:00 | 1.863 | Average between A43 and A57
2017-09-06 18:45:00 | 2.124 | Average between A44 and A58
2017-09-06 18:48:59 | 2.364 | Average between A45 and A59
2017-09-06 18:53:01 | 2.57 | Average between A46 and [NAME]
2017-09-06 18:57:00 | 2.723 | Average between A47 and A61
2017-09-06 19:00:59 | 2.853 | Average between A48 and A62
2017-09-06 19:04:58 | 2.959 | Average between A49 and A63
2017-09-06 19:09:01 | 3.082 | Average between [NAME] and A64
2017-09-06 19:13:00 | 3.246 | Average between A51 and A65
2017-09-06 19:16:59 | 3.47 | Average between A52 and A66
2017-09-06 19:20:58 | 3.699 | Average between A53 and A67
2017-09-06 19:25:01 | 3.883 | Average between [NAME] and A68
2017-09-06 19:29:00 | 4.001
2017-09-06 19:32:59 | 4.025
2017-09-06 19:36:58 | 3.942
2017-09-06 19:41:00 | 3.772
2017-09-06 19:45:00 | 3.564
2017-09-06 19:48:59 | 3.323
2017-09-06 19:53:01 | 3.075
2017-09-06 19:57:00 | 2.842
2017-09-06 20:00:59 | 2.64
2017-09-06 20:04:58 | 2.475
2017-09-06 20:09:01 | 2.347
2017-09-06 20:13:00 | 2.257
2017-09-06 20:16:59 | 2.209
2017-09-07 20:20:58 | 0 | Average between A68 and A82
2017-09-07 20:25:01 | 0 | Average between A69 and A83
2017-09-07 20:29:00 | 0 | Average between A70 and A84
2017-09-07 20:32:59 | 2.169 | Average between [NAME] and A85
2017-09-07 20:36:58 | 2.069 | Average between A72 and A86
2017-09-07 20:41:00 | 1.938 | Average between A73 and A87
2017-09-07 20:45:00 | 1.797 | Average between A74 and A88
2017-09-07 20:48:59 | 1.657 | Average between A75 and A89
2017-09-07 20:53:01 | 1.521 | Average between A76 and A90
2017-09-07 20:57:00 | 1.401 | Average between A77 and A91
2017-09-07 21:00:59 | 1.289 | Average between A78 and A92
2017-09-07 21:04:58 | 1.187 | Average between A79 and A93
2017-09-07 21:09:01 | 1.097 | Average between A80 and A94
2017-09-07 21:13:00 | 1.017 | Average between A81 and A95
2017-09-07 21:16:59 | 0.948 | Average between A82 and A96
2017-09-07 21:20:58 | 0.889 | Average between A83 and A97
2017-09-07 21:25:01 | 0.839 | Average between A84 and A98
2017-09-07 21:29:00 | 0.795 | Average between A85 and A99
2017-09-07 21:32:59 | 0.757 | Average between A86 and A100
2017-09-07 21:36:58 | 0.721 | Average between [NAME] and A101
2017-09-07 21:41:00 | 0.688 | Average between A88 and A102
2017-09-07 21:45:00 | 0.656 | Average between A89 and A103
2017-09-07 21:48:59 | 0.625 | Average between A90 and A104
2017-09-07 21:53:01 | 0 | Average between A91 and A105
2017-09-07 21:57:00 | 0.566 | Average between A92 and A106
2017-09-07 22:00:59 | 0.539 | Average between A93 and A107
2017-09-07 22:04:58 | 0 | Average between A94 and A108
2017-09-07 22:09:01 | 0.487 | Average between A95 and A109
2017-09-07 22:13:00 | 0.475 | Average between A96 and A110
2017-09-07 22:16:59 | 0.468 | Average between A97 and A111
2017-09-07 22:20:58 | 0.461 | Average between A98 and A112