Spreadsheet: 708566d1607932275-need-help-with-calculating-averages-over-dynamic-ranges-test-data
Sheet: Blad1

Time | Measurement | Floor
00:00:01 | 85
00:00:02 | 79
00:00:02 | 77
00:00:03 | 75
00:00:04 | 76 |  |  |  |  |  | Row Labels | Average of Measurement
00:00:05 | 65 |  |  |  |  |  | 00:00:00 | 74.33333333333333
00:00:06 | 68 |  |  |  |  |  | 00:00:20 | 71
00:00:07 | 69 |  |  |  |  |  | 00:00:40 | 73.625
00:00:07 | 66 |  |  |  |  |  | 00:01:00 | 71.08333333333333
00:00:08 | 64 |  |  |  |  |  | 00:01:20 | 74.85714285714286
00:00:09 | 64 |  |  |  |  |  | 00:01:40 | 74.56521739130434
00:00:09 | 63 |  |  |  |  |  | Grand Total | 73.23188405797102
00:00:10 | 70
00:00:11 | 75
00:00:12 | 72
00:00:13 | 73
00:00:13 | 74
00:00:14 | 76
00:00:15 | 78
00:00:15 | 81
00:00:16 | 82
00:00:17 | 84
00:00:18 | 83
00:00:19 | 85
00:00:20 | 86
00:00:20.798000 | 77
00:00:21.963000 | 55
00:00:23.352000 | 82
00:00:23.890000 | 82
00:00:25.127000 | 82
00:00:25.687000 | 82
00:00:26.771000 | 82
00:00:27.359000 | 61
00:00:28.483000 | 85
00:00:29.084000 | 66
00:00:32.006000 | 66
00:00:32.606000 | 66
00:00:33.574000 | 66
00:00:34.148000 | 66
00:00:35.573000 | 66
00:00:36.182000 | 61
00:00:37.334000 | 55
00:00:37.737000 | 87
00:00:38.347000 | 63
00:00:39.239000 | 63
00:00:39.843000 | 63
00:00:40.825000 | 63
00:00:41.390000 | 63
00:00:42.272000 | 63
00:00:42.837000 | 63
00:00:43.818000 | 57
00:00:44.204000 | 90
00:00:44.831000 | 68
00:00:45.660000 | 68
00:00:46.261000 | 68
00:00:47.520000 | 68
00:00:48.098000 | 68
00:00:49.572000 | 68
00:00:50.092000 | 61
00:00:51.517000 | 91
00:00:52.109000 | 61
00:00:52.933000 | 89
00:00:53.489000 | 89
00:00:54.748000 | 89
00:00:55.322000 | 89
00:00:56.156000 | 89
00:00:56.729000 | 64
00:00:57.670000 | 90
00:00:58.248000 | 61
00:00:59.700000 | 87
00:01:00.323000 | 61
00:01:00.852000 | 57
00:01:01.865000 | 85
00:01:02.470000 | 60
00:01:03.554000 | 87
00:01:04.105000 | 87
00:01:05.194000 | 87
00:01:05.763000 | 87
00:01:07.014000 | 87
00:01:07.336000 | 59
00:01:08.349000 | 59
00:01:08.761000 | 66
00:01:10.666000 | 86
00:01:11.262000 | 57
00:01:12.454000 | 82
00:01:13.050000 | 60
00:01:14.260000 | 84
00:01:14.843000 | 64
00:01:15.725000 | 64
00:01:16.344000 | 64
00:01:17.209000 | 64
00:01:17.778000 | 64
00:01:18.822000 | 64
00:01:19.396000 | 71
00:01:20.341000 | 103
00:01:20.897000 | 65
00:01:22.255000 | 92
00:01:22.869000 | 61
00:01:24.419000 | 90
00:01:25.042000 | 63
00:01:26.364000 | 90
00:01:26.956000 | 70
00:01:27.453000 | 70
00:01:28.892000 | 70
00:01:29.416000 | 70
00:01:30.644000 | 70
00:01:31.217000 | 61
00:01:32.665000 | 93
00:01:33.256000 | 63
00:01:34.462000 | 89
00:01:35.044000 | 60
00:01:36.564000 | 88
00:01:37.204000 | 59
00:01:38.652000 | 85
00:01:39.248000 | 60
00:01:40.467000 | 60
00:01:41.076000 | 60
00:01:42.515000 | 60
00:01:43.102000 | 60
00:01:44.173000 | 60
00:01:44.715000 | 68
00:01:46.104000 | 100
00:01:46.687000 | 72
00:01:47.453000 | 56
00:01:48.139000 | 95
00:01:48.775000 | 63
00:01:50.223000 | 87
00:01:50.823000 | 63
00:01:51.993000 | 91
00:01:52.566000 | 91
00:01:53.678000 | 91
00:01:54.242000 | 91
00:01:55.502000 | 91
00:01:56.089000 | 58
00:01:57.500000 | 87
00:01:58.092000 | 60
00:01:59.212000 | 87
00:01:59.786000 | 64