Spreadsheet: 132820d1323962767-formula-needed-to-calculate-mean-avg-of-columns-based-on-time-pt-time-col-average-and-median
Sheet: Sheet1

Time | Time | c | d | e | f | g
10:35:01 | 10:35 | 306 | 342 | 0.89 | 9.73 | 8.88
10:35:07 | 10:35 | 306 | 337 | 0.91 | 9.94 | 9.4
10:35:13 | 10:35 | 270 | 295 | 0.91 | 9.05 | 9.37
10:35:32 | 10:35 | 270 | 295 | 0.91 | 9.05 | 9.37
10:35:39 | 10:35 | 248 | 267 | 0.93 | 8.56 | 9.28
10:35:47 | 10:35 | 248 | 267 | 0.93 | 8.56 | 9.28 |  |  | Row Labels | Average of c | Average of d | Average of e | Average of f | Average of g | Median C | Median D | Median E | Median F | Median G
10:35:59 | 10:35 | 217 | 236 | 0.92 | 7.23 | 6.83 |  |  | 10:35 | 266.4285714285714 | 291.2857142857143 | 0.9142857142857143 | 8.874285714285715 | 8.915714285714285
10:36:07 | 10:36 | 237 | 251 | 0.95 | 7.86 | 6.55 |  |  | 10:36 | 230 | 250 | 0.9199999999999999 | 7.69875 | 7.50375
10:36:16 | 10:36 | 258 | 274 | 0.94 | 8.24 | 6.14 |  |  | 10:37 | 172 | 209.4545454545455 | 0.8218181818181819 | 6.577272727272727 | 9.843636363636364
10:36:23 | 10:36 | 246 | 261 | 0.94 | 7.92 | 6.12 |  |  | 10:38 | 171.1111111111111 | 217.3333333333333 | 0.788888888888889 | 6.735555555555555 | 10.03777777777778
10:36:29 | 10:36 | 256 | 268 | 0.96 | 8.73 | 8.24 |  |  | 10:39 | 220 | 276.875 | 0.7925 | 7.73 | 9.181249999999999
10:36:35 | 10:36 | 212 | 224 | 0.95 | 7.21 | 7.09 |  |  | 10:40 | 260.375 | 287.625 | 0.9112499999999999 | 8.49 | 8.69625
10:36:41 | 10:36 | 194 | 218 | 0.89 | 6.54 | 7.53 |  |  | 10:41 | 180.875 | 192.75 | 0.9375 | 6.44625 | 8.27
10:36:47 | 10:36 | 241 | 274 | 0.88 | 8.05 | 8.86 |  |  | 10:42 | 135.3333333333333 | 147.6666666666667 | 0.9133333333333334 | 4.486666666666667 | 5.576666666666667
10:36:54 | 10:36 | 196 | 230 | 0.85 | 7.04 | 9.5 |  |  | 10:43 | 125.6 | 138.4 | 0.9039999999999999 | 4.15 | 5.694
10:37:00 | 10:37 | 156 | 179 | 0.87 | 6.04 | 9.17 |  |  | 10:44 | 167 | 194.875 | 0.8574999999999998 | 5.5225 | 6.802499999999998
10:37:06 | 10:37 | 167 | 199 | 0.84 | 6.35 | 9.46 |  |  | 10:45 | 147.4444444444445 | 171.2222222222222 | 0.86 | 5.732222222222222 | 9.607777777777777
10:37:12 | 10:37 | 178 | 216 | 0.82 | 6.55 | 9.54 |  |  | 10:46 | 112 | 136.3333333333333 | 0.8249999999999998 | 4.853333333333334 | 10.44333333333333
10:37:18 | 10:37 | 205 | 249 | 0.82 | 7.32 | 9.66 |  |  | 10:47 | 195.4 | 239.9 | 0.8140000000000001 | 7.528 | 10.76
10:37:23 | 10:37 | 180 | 215 | 0.84 | 6.78 | 10.06 |  |  | 10:48 | 225.1 | 255.9 | 0.881 | 8.603 | 11.649
10:37:30 | 10:37 | 145 | 176 | 0.82 | 5.87 | 9.84 |  |  | 10:49 | 260 | 290.4 | 0.892 | 8.436 | 8.904
10:37:36 | 10:37 | 161 | 199 | 0.81 | 6.34 | 10.24 |  |  | 10:50 | 238.75 | 265.5 | 0.895 | 7.944999999999999 | 8.8275
10:37:40 | 10:37 | 187 | 234 | 0.8 | 6.9 | 9.83 |  |  | 10:51 | 157.25 | 191 | 0.8200000000000001 | 5.945 | 9.42
10:37:46 | 10:37 | 183 | 227 | 0.81 | 6.9 | 9.92 |  |  | 10:52 | 127.2857142857143 | 161.8571428571429 | 0.7828571428571429 | 5.002857142857144 | 8.528571428571428
10:37:52 | 10:37 | 176 | 218 | 0.81 | 6.87 | 10.02 |  |  | Grand Total | 190.5846153846154 | 221.3769230769231 | 0.858384615384615 | 6.855230769230769 | 9.079153846153847
10:37:58 | 10:37 | 154 | 192 | 0.8 | 6.43 | 10.54
10:38:04 | 10:38 | 158 | 199 | 0.8 | 6.42 | 10.03
10:38:10 | 10:38 | 175 | 222 | 0.79 | 6.97 | 10.59
10:38:16 | 10:38 | 176 | 222 | 0.79 | 7.04 | 10.8
10:38:22 | 10:38 | 172 | 216 | 0.8 | 6.87 | 10.28
10:38:29 | 10:38 | 144 | 182 | 0.79 | 6.08 | 9.98
10:38:35 | 10:38 | 151 | 192 | 0.79 | 6.12 | 9.65
10:38:42 | 10:38 | 177 | 226 | 0.78 | 6.79 | 9.72
10:38:48 | 10:38 | 183 | 235 | 0.78 | 6.94 | 9.7
10:38:54 | 10:38 | 204 | 262 | 0.78 | 7.39 | 9.59
10:39:00 | 10:39 | 212 | 271 | 0.78 | 7.65 | 9.53
10:39:06 | 10:39 | 195 | 248 | 0.78 | 7.23 | 9.57
10:39:13 | 10:39 | 195 | 250 | 0.78 | 7.14 | 9.34
10:39:21 | 10:39 | 203 | 260 | 0.78 | 7.24 | 9.13
10:39:27 | 10:39 | 226 | 284 | 0.8 | 7.88 | 9.12
10:39:34 | 10:39 | 266 | 331 | 0.8 | 8.83 | 9.04
10:39:50 | 10:39 | 229 | 282 | 0.81 | 7.97 | 9.04
10:39:57 | 10:39 | 234 | 289 | 0.81 | 7.9 | 8.68
10:40:04 | 10:40 | 281 | 337 | 0.83 | 8.98 | 8.55
10:40:10 | 10:40 | 294 | 343 | 0.86 | 9.35 | 8.66
10:40:17 | 10:40 | 270 | 304 | 0.89 | 8.75 | 8.78
10:40:22 | 10:40 | 263 | 287 | 0.91 | 8.63 | 9.18
10:40:31 | 10:40 | 251 | 272 | 0.92 | 8.15 | 8.66
10:40:39 | 10:40 | 265 | 285 | 0.93 | 8.49 | 8.43
10:40:45 | 10:40 | 246 | 255 | 0.97 | 8.21 | 8.9
10:40:51 | 10:40 | 213 | 218 | 0.98 | 7.36 | 8.41
10:41:03 | 10:41 | 198 | 203 | 0.98 | 6.87 | 8.27
10:41:10 | 10:41 | 231 | 241 | 0.96 | 7.7 | 8.28
10:41:19 | 10:41 | 194 | 199 | 0.97 | 6.72 | 7.74
10:41:26 | 10:41 | 156 | 163 | 0.96 | 5.92 | 8.2
10:41:34 | 10:41 | 173 | 186 | 0.93 | 6.35 | 8.43
10:41:46 | 10:41 | 147 | 161 | 0.91 | 5.6 | 8.48
10:41:53 | 10:41 | 164 | 184 | 0.89 | 5.97 | 8.44
10:41:59 | 10:41 | 184 | 205 | 0.9 | 6.44 | 8.32
10:42:24 | 10:42 | 125 | 138 | 0.91 | 4.34 | 5.53
10:42:33 | 10:42 | 131 | 143 | 0.91 | 4.33 | 5.58
10:42:53 | 10:42 | 150 | 162 | 0.92 | 4.79 | 5.62
10:43:05 | 10:43 | 123 | 134 | 0.92 | 4.02 | 5.06
10:43:21 | 10:43 | 138 | 151 | 0.91 | 4.46 | 5.93
10:43:27 | 10:43 | 126 | 139 | 0.9 | 4.16 | 6.08
10:43:36 | 10:43 | 119 | 132 | 0.9 | 4.02 | 5.73
10:43:49 | 10:43 | 122 | 136 | 0.89 | 4.09 | 5.67
10:44:02 | 10:44 | 129 | 149 | 0.87 | 4.18 | 5.23
10:44:10 | 10:44 | 129 | 149 | 0.87 | 4.18 | 5.23
10:44:21 | 10:44 | 146 | 171 | 0.85 | 4.82 | 6.16
10:44:30 | 10:44 | 171 | 199 | 0.86 | 5.53 | 6.6
10:44:36 | 10:44 | 179 | 208 | 0.86 | 5.76 | 6.56
10:44:42 | 10:44 | 186 | 219 | 0.85 | 6.05 | 7.1
10:44:47 | 10:44 | 198 | 232 | 0.85 | 6.83 | 8.77
10:44:54 | 10:44 | 198 | 232 | 0.85 | 6.83 | 8.77
10:45:00 | 10:45 | 195 | 226 | 0.86 | 6.87 | 9.04
10:45:07 | 10:45 | 182 | 211 | 0.86 | 6.56 | 8.89
10:45:12 | 10:45 | 164 | 191 | 0.86 | 6.27 | 9.63
10:45:19 | 10:45 | 145 | 168 | 0.86 | 5.74 | 9.79
10:45:35 | 10:45 | 150 | 173 | 0.87 | 5.8 | 9.87
10:45:41 | 10:45 | 132 | 152 | 0.86 | 5.33 | 9.75
10:45:48 | 10:45 | 128 | 149 | 0.86 | 5.23 | 9.84
10:45:54 | 10:45 | 118 | 138 | 0.86 | 4.97 | 9.72
10:45:59 | 10:45 | 113 | 133 | 0.85 | 4.82 | 9.94
10:46:17 | 10:46 | 107 | 127 | 0.85 | 4.73 | 10.07
10:46:36 | 10:46 | 109 | 132 | 0.83 | 4.74 | 10.26
10:46:42 | 10:46 | 104 | 127 | 0.82 | 4.67 | 10.7
10:46:48 | 10:46 | 110 | 133 | 0.82 | 4.78 | 10.41
10:46:53 | 10:46 | 113 | 139 | 0.82 | 4.85 | 10.6
10:46:59 | 10:46 | 129 | 160 | 0.81 | 5.35 | 10.62
10:47:05 | 10:47 | 148 | 185 | 0.8 | 5.86 | 10.47
10:47:10 | 10:47 | 168 | 208 | 0.81 | 6.52 | 10.59
10:47:16 | 10:47 | 187 | 235 | 0.8 | 7.05 | 10.5
10:47:22 | 10:47 | 199 | 249 | 0.8 | 7.59 | 10.68
10:47:26 | 10:47 | 204 | 254 | 0.8 | 7.9 | 11.11
10:47:32 | 10:47 | 216 | 267 | 0.81 | 8.22 | 11.09
10:47:38 | 10:47 | 219 | 266 | 0.82 | 8.37 | 11.08
10:47:43 | 10:47 | 219 | 267 | 0.82 | 8.37 | 11.08
10:47:50 | 10:47 | 197 | 234 | 0.84 | 7.7 | 10.5
10:47:55 | 10:47 | 197 | 234 | 0.84 | 7.7 | 10.5
10:48:00 | 10:48 | 205 | 241 | 0.85 | 7.93 | 10.8
10:48:05 | 10:48 | 215 | 251 | 0.86 | 8.17 | 10.75
10:48:09 | 10:48 | 215 | 249 | 0.86 | 8.21 | 11.05
10:48:14 | 10:48 | 227 | 260 | 0.87 | 8.6 | 11.57
10:48:19 | 10:48 | 249 | 281 | 0.89 | 9.47 | 12.68
10:48:24 | 10:48 | 249 | 281 | 0.89 | 9.47 | 12.68
10:48:28 | 10:48 | 249 | 281 | 0.89 | 9.47 | 12.68
10:48:34 | 10:48 | 225 | 251 | 0.9 | 8.83 | 12.46
10:48:41 | 10:48 | 204 | 228 | 0.9 | 7.94 | 11.22
10:48:47 | 10:48 | 213 | 236 | 0.9 | 7.94 | 10.6
10:49:10 | 10:49 | 237 | 267 | 0.89 | 8.06 | 9.57
10:49:20 | 10:49 | 256 | 289 | 0.88 | 8.45 | 9.76
10:49:33 | 10:49 | 253 | 287 | 0.88 | 8.22 | 9.63
10:49:48 | 10:49 | 270 | 298 | 0.9 | 8.52 | 7.82
10:49:54 | 10:49 | 284 | 311 | 0.91 | 8.93 | 7.74
10:50:31 | 10:50 | 297 | 328 | 0.91 | 9.29 | 8.14
10:50:37 | 10:50 | 273 | 303 | 0.9 | 8.72 | 8.26
10:50:49 | 10:50 | 226 | 247 | 0.91 | 7.72 | 8.75
10:50:56 | 10:50 | 159 | 184 | 0.86 | 6.05 | 10.16
10:51:03 | 10:51 | 182 | 214 | 0.85 | 6.6 | 9.56
10:51:24 | 10:51 | 152 | 187 | 0.81 | 5.77 | 9.38
10:51:36 | 10:51 | 152 | 187 | 0.81 | 5.77 | 9.38
10:51:42 | 10:51 | 143 | 176 | 0.81 | 5.64 | 9.36
10:52:05 | 10:52 | 135 | 171 | 0.79 | 5.26 | 8.59
10:52:11 | 10:52 | 137 | 173 | 0.79 | 5.29 | 8.57
10:52:20 | 10:52 | 135 | 170 | 0.79 | 5.12 | 8.02
10:52:27 | 10:52 | 120 | 153 | 0.78 | 4.76 | 8.18
10:52:32 | 10:52 | 125 | 159 | 0.78 | 5.03 | 9.06
10:52:38 | 10:52 | 125 | 159 | 0.78 | 5.03 | 9.06
10:52:53 | 10:52 | 114 | 148 | 0.77 | 4.53 | 8.22