Spreadsheet: 136824d1326834647-excel-gets-extremely-slow-adding-formulas-copy-of-refill-tech-activity-jul-dec-2011
Sheet: July 2011

User ID | User Name | Stations Filled | Time Finish | Time  Start | [NAME] | Date | Total Refill Time | lines per hour | time per station | lines per station | time per line per station | full date |  |  | move Date (D) to (G) before Sort/SubT
E38205 | Appleton, [NAME] | 10 | 08:44 | 05:40 | 150 | Jul 06 | 183.9999999999999 | 48.91304347826089 | 18.4 | 15 | 1.226666666666666 | 2011-07-06 00:00:00
E38205 | Appleton, [NAME] | 10 | 09:43 | 05:26 | 146 | Jul 08 | 257 | 34.08560311284047 | 25.7 | 14.6 | 1.76027397260274 | 2011-07-08 00:00:00
E38205 | Appleton, [NAME] | 11 | 10:01 | 05:43 | 140 | Jul 11 | 258 | 32.55813953488372 | 23.45454545454545 | 12.72727272727273 | 1.842857142857143 | 2011-07-11 00:00:00
E38205 | Appleton, [NAME] | 3 | 09:10 | 05:59 | 130 | Jul 13 | 191 | 40.83769633507854 | 63.66666666666666 | 43.33333333333334 | 1.469230769230769 | 2011-07-13 00:00:00
E38205 | Appleton, [NAME] | 6 | 09:48 | 06:05 | 150 | Jul 15 | 223.0000000000001 | 40.35874439461882 | 37.16666666666668 | 25 | 1.486666666666667 | 2011-07-15 00:00:00
E38205 | Appleton, [NAME] | 7 | 09:32 | 05:45 | 153 | Jul 18 | 226.9999999999999 | 40.44052863436124 | 32.42857142857142 | 21.85714285714286 | 1.483660130718954 | 2011-07-18 00:00:00
E38205 | Appleton, [NAME] | 8 | 09:56 | 06:02 | 123 | Jul 20 | 234.0000000000001 | 31.53846153846153 | 29.25000000000001 | 15.375 | 1.902439024390244 | 2011-07-20 00:00:00
E38205 | Appleton, [NAME] | 6 | 09:55 | 06:00 | 110 | Jul 22 | 235 | 28.08510638297873 | 39.16666666666666 | 18.33333333333333 | 2.136363636363636 | 2011-07-22 00:00:00
E38205 | Appleton, [NAME] | 6 | 10:10 | 05:47 | 169 | Jul 25 | 263 | 38.55513307984791 | 43.83333333333334 | 28.16666666666667 | 1.556213017751479 | 2011-07-25 00:00:00
E38205 | Appleton, [NAME] | 5 | 09:51 | 05:48 | 128 | Jul 27 | 243 | 31.60493827160494 | 48.59999999999999 | 25.6 | 1.8984375 | 2011-07-27 00:00:00
E38205 | Appleton, [NAME] | 8 | 09:55 | 06:02 | 181 | Jul 29 | 233 | 46.60944206008584 | 29.125 | 22.625 | 1.287292817679558 | 2011-07-29 00:00:00
E38205 | Appleton, [NAME] | 7 | 09:36 | 05:31 | 164 | Aug 01 | 245 | 40.16326530612245 | 34.99999999999999 | 23.42857142857143 | 1.49390243902439 | 2011-08-01 00:00:00
E37700 | [NAME], George | 14 | 08:18 | 01:08 | 278 | Jul 04 | 430.0000000000001 | 38.7906976744186 | 30.71428571428572 | 19.85714285714286 | 1.546762589928058 | 2011-07-04 00:00:00
E37700 | [NAME], George | 10 | 23:31 | 01:32 | 170 | Jul 06 | 121 | 84.29752066115702 | 12.1 | 17 | 0.711764705882353 | 2011-07-06 00:00:00
E37700 | [NAME], George | 12 | 23:33 | 00:57 | 176 | Jul 08 | 84 | 125.7142857142857 | 7 | 14.66666666666667 | 0.4772727272727273 | 2011-07-08 00:00:00
E37700 | [NAME], George | 11 | 23:14 | 01:47 | 250 | Jul 11 | 153 | 98.0392156862745 | 13.90909090909091 | 22.72727272727273 | 0.612 | 2011-07-11 00:00:00
E37700 | [NAME], George | 10 | 23:23 | 01:15 | 137 | Jul 13 | 112 | 73.39285714285715 | 11.2 | 13.7 | 0.8175182481751825 | 2011-07-13 00:00:00
E37700 | [NAME], George | 10 | 06:12 | 01:04 | 190 | Jul 15 | 308 | 37.01298701298702 | 30.8 | 19 | 1.621052631578947 | 2011-07-15 00:00:00
E37700 | [NAME], George | 10 | 06:48 | 00:56 | 225 | Jul 18 | 352 | 38.35227272727273 | 35.2 | 22.5 | 1.564444444444445 | 2011-07-18 00:00:00
E37700 | [NAME], George | 10 | 05:54 | 01:40 | 160 | Jul 20 | 254.0000000000001 | 37.79527559055117 | 25.40000000000001 | 16 | 1.5875 | 2011-07-20 00:00:00
E37700 | [NAME], George | 11 | 23:28 | 01:49 | 247 | Jul 22 | 141 | 105.1063829787234 | 12.81818181818182 | 22.45454545454545 | 0.5708502024291499 | 2011-07-22 00:00:00
E37700 | [NAME], George | 11 | 06:46 | 01:45 | 262 | Jul 25 | 300.9999999999999 | 52.22591362126246 | 27.36363636363636 | 23.81818181818182 | 1.148854961832061 | 2011-07-25 00:00:00
E37700 | [NAME], George | 9 | 23:18 | 01:53 | 168 | Jul 27 | 155 | 65.03225806451613 | 17.22222222222222 | 18.66666666666667 | 0.9226190476190476 | 2011-07-27 00:00:00
E37700 | [NAME], George | 10 | 23:13 | 00:45 | 198 | Jul 29 | 92.00000000000023 | 129.1304347826084 | 9.200000000000022 | 19.8 | 0.4646464646464658 | 2011-07-29 00:00:00
E37700 | [NAME], George | 10 | 23:09 | 01:22 | 222 | Aug 01 | 133.0000000000002 | 100.1503759398495 | 13.30000000000002 | 22.2 | 0.5990990990991001 | 2011-08-01 00:00:00
E30527 | Culler, Josephine M | 5 | 05:36 | 05:07 | 39 | Jul 11 | 28.99999999999998 | 80.68965517241385 | 5.799999999999995 | 7.8 | 0.7435897435897431 | 2011-07-11 00:00:00
E30527 | Culler, Josephine M | 7 | 08:43 | 05:19 | 114 | Jul 13 | 204 | 33.52941176470588 | 29.14285714285714 | 16.28571428571428 | 1.789473684210526 | 2011-07-13 00:00:00
E30527 | Culler, Josephine M | 5 | 06:00 | 05:20 | 44 | Jul 15 | 40.00000000000001 | 65.99999999999997 | 8.000000000000004 | 8.8 | 0.9090909090909094 | 2011-07-15 00:00:00
E30527 | Culler, Josephine M | 6 | 06:39 | 05:27 | 80 | Jul 18 | 72.00000000000003 | 66.66666666666664 | 12.00000000000001 | 13.33333333333333 | 0.9000000000000004 | 2011-07-18 00:00:00
E30527 | Culler, Josephine M | 5 | 06:08 | 05:18 | 61 | Jul 20 | 50.00000000000006 | 73.1999999999999 | 10.00000000000001 | 12.2 | 0.819672131147542 | 2011-07-20 00:00:00
E30527 | Culler, Josephine M | 5 | 06:24 | 05:42 | 71 | Jul 25 | 41.99999999999997 | 101.4285714285715 | 8.399999999999995 | 14.2 | 0.5915492957746475 | 2011-07-25 00:00:00
E30527 | Culler, Josephine M | 5 | 05:55 | 05:09 | 69 | Jul 27 | 46 | 90 | 9.2 | 13.8 | 0.6666666666666666 | 2011-07-27 00:00:00
E30527 | Culler, Josephine M | 5 | 06:05 | 05:25 | 69 | Jul 29 | 39.99999999999998 | 103.5000000000001 | 7.999999999999996 | 13.8 | 0.5797101449275359 | 2011-07-29 00:00:00
E30527 | Culler, Josephine M | 5 | 06:04 | 05:20 | 59 | Aug 01 | 44 | 80.45454545454545 | 8.8 | 11.8 | 0.7457627118644068 | 2011-08-01 00:00:00
E18766 | Curry, Christine | 14 | 07:39 | 02:13 | 235 | Jul 04 | 326.0000000000001 | 43.25153374233128 | 23.28571428571429 | 16.78571428571428 | 1.387234042553192 | 2011-07-04 00:00:00
E18766 | Curry, Christine | 11 | 06:32 | 02:36 | 195 | Jul 06 | 236 | 49.57627118644069 | 21.45454545454545 | 17.72727272727273 | 1.21025641025641 | 2011-07-06 00:00:00
E18766 | Curry, Christine | 10 | 06:42 | 02:36 | 223 | Jul 08 | 246 | 54.39024390243902 | 24.6 | 22.3 | 1.103139013452915 | 2011-07-08 00:00:00
E18766 | Curry, Christine | 12 | 06:18 | 02:54 | 265 | Jul 11 | 204 | 77.94117647058823 | 17 | 22.08333333333333 | 0.769811320754717 | 2011-07-11 00:00:00
E18766 | Curry, Christine | 9 | 05:40 | 02:16 | 151 | Jul 13 | 204 | 44.41176470588235 | 22.66666666666667 | 16.77777777777778 | 1.350993377483444 | 2011-07-13 00:00:00
E18766 | Curry, Christine | 9 | 06:18 | 02:22 | 226 | Jul 15 | 236 | 57.45762711864406 | 26.22222222222222 | 25.11111111111111 | 1.04424778761062 | 2011-07-15 00:00:00
E18766 | Curry, Christine | 9 | 05:47 | 02:33 | 154 | Jul 27 | 194 | 47.62886597938143 | 21.55555555555556 | 17.11111111111111 | 1.25974025974026 | 2011-07-27 00:00:00
E18766 | Curry, Christine | 9 | 05:55 | 02:16 | 178 | Jul 29 | 219 | 48.76712328767123 | 24.33333333333334 | 19.77777777777778 | 1.230337078651685 | 2011-07-29 00:00:00
E18766 | Curry, Christine | 11 | 06:01 | 01:59 | 213 | Aug 01 | 242 | 52.80991735537189 | 22 | 19.36363636363636 | 1.136150234741784 | 2011-08-01 00:00:00
E39176 | Flores, [NAME] | 1 | 09:14 | 09:14 | 1 | Jul 27 | 1 | 60 | 1 | 1 | 1 | 2011-07-27 00:00:00
E17682 | [NAME], [NAME] | 4 | 05:51 | 02:24 | 146 | Jul 13 | 207 | 42.31884057971016 | 51.74999999999999 | 36.5 | 1.417808219178082 | 2011-07-13 00:00:00
E17682 | [NAME], [NAME] | 4 | 23:01 | 02:03 | 134 | Jul 15 | 182 | 44.17582417582418 | 45.5 | 33.5 | 1.358208955223881 | 2011-07-15 00:00:00
E17682 | [NAME], [NAME] | 9 | 06:37 | 02:25 | 178 | Jul 18 | 252.0000000000001 | 42.38095238095237 | 28.00000000000001 | 19.77777777777778 | 1.415730337078652 | 2011-07-18 00:00:00
E17682 | [NAME], [NAME] | 6 | 05:46 | 02:18 | 123 | Jul 20 | 208 | 35.48076923076923 | 34.66666666666667 | 20.5 | 1.691056910569106 | 2011-07-20 00:00:00
E17682 | [NAME], [NAME] | 8 | 06:02 | 01:12 | 178 | Jul 22 | 290 | 36.82758620689656 | 36.25 | 22.25 | 1.629213483146067 | 2011-07-22 00:00:00
E17682 | [NAME], [NAME] | 9 | 07:15 | 03:11 | 226 | Jul 25 | 244 | 55.57377049180329 | 27.11111111111111 | 25.11111111111111 | 1.079646017699115 | 2011-07-25 00:00:00
E17682 | [NAME], [NAME] | 5 | 06:04 | 03:04 | 147 | Jul 27 | 180 | 49.00000000000001 | 35.99999999999999 | 29.4 | 1.224489795918367 | 2011-07-27 00:00:00
E17682 | [NAME], [NAME] | 5 | 06:07 | 01:10 | 152 | Jul 29 | 297 | 30.70707070707071 | 59.4 | 30.4 | 1.953947368421053 | 2011-07-29 00:00:00
E17682 | [NAME], [NAME] | 5 | 23:06 | 02:01 | 178 | Aug 01 | 175 | 61.02857142857142 | 35 | 35.6 | 0.9831460674157303 | 2011-08-01 00:00:00
E38713 | Huffman, Justin | 1 | 08:36 | 08:36 | 1 | Jul 22 | 1 | 60 | 1 | 1 | 1 | 2011-07-22 00:00:00
E37982 | [NAME] | 4 | 07:56 | 06:18 | 127 | Jul 08 | 97.99999999999997 | 77.75510204081635 | 24.49999999999999 | 31.75 | 0.7716535433070864 | 2011-07-08 00:00:00
E37982 | [NAME] | 2 | 07:46 | 06:38 | 135 | Jul 11 | 68.00000000000009 | 119.1176470588234 | 34.00000000000004 | 67.5 | 0.5037037037037043 | 2011-07-11 00:00:00
E37982 | [NAME] | 2 | 07:11 | 06:22 | 100 | Jul 13 | 48.99999999999999 | 122.4489795918368 | 24.49999999999999 | 50 | 0.4899999999999999 | 2011-07-13 00:00:00
E37982 | [NAME] | 2 | 07:17 | 06:15 | 98 | Jul 20 | 61.99999999999994 | 94.83870967741944 | 30.99999999999997 | 49 | 0.6326530612244892 | 2011-07-20 00:00:00
E37982 | [NAME] | 6 | 08:52 | 06:28 | 162 | Jul 22 | 144.0000000000001 | 67.49999999999997 | 24.00000000000001 | 27 | 0.8888888888888893 | 2011-07-22 00:00:00
E37982 | [NAME] | 2 | 07:48 | 06:42 | 135 | Jul 25 | 66 | 122.7272727272727 | 33 | 67.5 | 0.4888888888888889 | 2011-07-25 00:00:00
E37982 | [NAME] | 3 | 07:49 | 06:39 | 112 | Jul 27 | 69.99999999999999 | 96.00000000000001 | 23.33333333333333 | 37.33333333333334 | 0.6249999999999998 | 2011-07-27 00:00:00
E37982 | [NAME] | 3 | 07:39 | 06:36 | 111 | Jul 29 | 63.0000000000001 | 105.7142857142856 | 21.00000000000003 | 37 | 0.5675675675675684 | 2011-07-29 00:00:00
E37982 | [NAME] | 2 | 07:50 | 06:08 | 129 | Aug 01 | 102 | 75.8823529411765 | 50.99999999999998 | 64.5 | 0.7906976744186043 | 2011-08-01 00:00:00
E39303 | Meyers, [NAME] | 9 | 06:01 | 02:34 | 376 | Jul 04 | 207 | 108.9855072463768 | 23 | 41.77777777777778 | 0.550531914893617 | 2011-07-04 00:00:00
E39303 | Meyers, [NAME] | 15 | 04:59 | 02:03 | 287 | Jul 06 | 176 | 97.84090909090908 | 11.73333333333334 | 19.13333333333333 | 0.6132404181184671 | 2011-07-06 00:00:00
E39303 | Meyers, [NAME] | 11 | 04:38 | 01:39 | 260 | Jul 08 | 179 | 87.15083798882684 | 16.27272727272727 | 23.63636363636364 | 0.6884615384615383 | 2011-07-08 00:00:00
E39303 | Meyers, [NAME] | 10 | 05:41 | 02:22 | 333 | Jul 11 | 199 | 100.4020100502513 | 19.9 | 33.3 | 0.5975975975975976 | 2011-07-11 00:00:00
E39303 | Meyers, [NAME] | 9 | 04:07 | 01:19 | 204 | Jul 13 | 168 | 72.85714285714286 | 18.66666666666666 | 22.66666666666667 | 0.8235294117647057 | 2011-07-13 00:00:00
E39303 | Meyers, [NAME] | 12 | 04:54 | 01:48 | 254 | Jul 15 | 186.0000000000001 | 81.93548387096772 | 15.50000000000001 | 21.16666666666667 | 0.7322834645669294 | 2011-07-15 00:00:00
E39303 | Meyers, [NAME] | 12 | 06:05 | 02:25 | 380 | Jul 18 | 220 | 103.6363636363636 | 18.33333333333334 | 31.66666666666667 | 0.5789473684210527 | 2011-07-18 00:00:00
E39303 | Meyers, [NAME] | 11 | 04:57 | 01:55 | 222 | Jul 20 | 182 | 73.18681318681318 | 16.54545454545455 | 20.18181818181818 | 0.8198198198198198 | 2011-07-20 00:00:00
E39303 | Meyers, [NAME] | 12 | 05:25 | 01:54 | 305 | Jul 22 | 211 | 86.7298578199052 | 17.58333333333333 | 25.41666666666667 | 0.6918032786885245 | 2011-07-22 00:00:00
E39303 | Meyers, [NAME] | 10 | 06:15 | 02:28 | 349 | Jul 25 | 227 | 92.2466960352423 | 22.7 | 34.9 | 0.6504297994269341 | 2011-07-25 00:00:00
E39303 | Meyers, [NAME] | 7 | 04:44 | 02:04 | 219 | Jul 27 | 160 | 82.12500000000001 | 22.85714285714285 | 31.28571428571428 | 0.730593607305936 | 2011-07-27 00:00:00
E39303 | Meyers, [NAME] | 9 | 05:05 | 01:46 | 287 | Jul 29 | 199 | 86.53266331658291 | 22.11111111111111 | 31.88888888888889 | 0.6933797909407665 | 2011-07-29 00:00:00
E39303 | Meyers, [NAME] | 8 | 04:43 | 01:51 | 283 | Aug 01 | 172 | 98.72093023255815 | 21.5 | 35.375 | 0.607773851590106 | 2011-08-01 00:00:00
E17329 | [NAME], [NAME] | 2 | 04:05 | 03:37 | 23 | Jul 08 | 27.99999999999998 | 49.28571428571432 | 13.99999999999999 | 11.5 | 1.217391304347825 | 2011-07-08 00:00:00
E17329 | [NAME], [NAME] | 2 | 03:36 | 03:18 | 20 | Jul 13 | 18.00000000000001 | 66.66666666666661 | 9.000000000000007 | 10 | 0.9000000000000007 | 2011-07-13 00:00:00
E17329 | [NAME], [NAME] | 2 | 03:27 | 03:07 | 25 | Jul 20 | 20.00000000000001 | 74.99999999999997 | 10 | 12.5 | 0.8000000000000003 | 2011-07-20 00:00:00
E17329 | [NAME], [NAME] | 2 | 03:52 | 03:34 | 20 | Jul 22 | 18.00000000000001 | 66.66666666666661 | 9.000000000000007 | 10 | 0.9000000000000007 | 2011-07-22 00:00:00
E17329 | [NAME], [NAME] | 2 | 03:29 | 02:54 | 38 | Jul 27 | 35.00000000000001 | 65.14285714285711 | 17.50000000000001 | 19 | 0.9210526315789478 | 2011-07-27 00:00:00
E17329 | [NAME], [NAME] | 2 | 04:21 | 03:35 | 28 | Jul 29 | 46 | 36.52173913043478 | 23 | 14 | 1.642857142857143 | 2011-07-29 00:00:00
E38440 | [NAME], [NAME] | 24 | 07:31 | 03:01 | 303 | Jul 04 | 270 | 67.33333333333333 | 11.25 | 12.625 | 0.8910891089108911 | 2011-07-04 00:00:00
E38440 | [NAME], [NAME] | 21 | 06:01 | 02:26 | 241 | Jul 06 | 214.9999999999999 | 67.25581395348838 | 10.23809523809524 | 11.47619047619048 | 0.8921161825726138 | 2011-07-06 00:00:00
E38440 | [NAME], [NAME] | 26 | 04:39 | 01:59 | 190 | Jul 08 | 160 | 71.25 | 6.153846153846154 | 7.307692307692307 | 0.8421052631578948 | 2011-07-08 00:00:00
E38440 | [NAME], [NAME] | 25 | 05:46 | 02:26 | 263 | Jul 11 | 200 | 78.89999999999999 | 8 | 10.52 | 0.7604562737642586 | 2011-07-11 00:00:00
E38440 | [NAME], [NAME] | 22 | 06:06 | 01:45 | 211 | Jul 13 | 260.9999999999999 | 48.50574712643679 | 11.86363636363636 | 9.590909090909092 | 1.23696682464455 | 2011-07-13 00:00:00
E38440 | [NAME], [NAME] | 20 | 06:00 | 01:40 | 223 | Jul 15 | 260.0000000000001 | 51.46153846153845 | 13 | 11.15 | 1.165919282511211 | 2011-07-15 00:00:00
E38440 | [NAME], [NAME] | 24 | 06:20 | 02:28 | 316 | Jul 18 | 232 | 81.72413793103449 | 9.666666666666666 | 13.16666666666667 | 0.7341772151898734 | 2011-07-18 00:00:00
E38440 | [NAME], [NAME] | 27 | 04:52 | 02:06 | 285 | Jul 20 | 166 | 103.0120481927711 | 6.148148148148149 | 10.55555555555556 | 0.5824561403508772 | 2011-07-20 00:00:00
E38440 | [NAME], [NAME] | 22 | 05:27 | 01:58 | 218 | Jul 22 | 209 | 62.58373205741628 | 9.499999999999998 | 9.909090909090908 | 0.9587155963302751 | 2011-07-22 00:00:00
E38440 | [NAME], [NAME] | 26 | 05:47 | 02:22 | 317 | Jul 25 | 205 | 92.78048780487805 | 7.884615384615385 | 12.19230769230769 | 0.6466876971608834 | 2011-07-25 00:00:00
E38440 | [NAME], [NAME] | 21 | 04:37 | 02:06 | 217 | Jul 27 | 151 | 86.2251655629139 | 7.190476190476191 | 10.33333333333333 | 0.695852534562212 | 2011-07-27 00:00:00
E38440 | [NAME], [NAME] | 21 | 06:21 | 01:50 | 221 | Jul 29 | 271 | 48.92988929889299 | 12.90476190476191 | 10.52380952380952 | 1.226244343891403 | 2011-07-29 00:00:00
E38440 | [NAME], [NAME] | 22 | 04:45 | 01:51 | 236 | Aug 01 | 174 | 81.37931034482759 | 7.909090909090907 | 10.72727272727273 | 0.7372881355932203 | 2011-08-01 00:00:00
E35223 | Wilson, Leroy | 1 | 08:49 | 08:30 | 7 | Jul 15 | 18.99999999999993 | 22.10526315789481 | 18.99999999999993 | 7 | 2.714285714285705 | 2011-07-15 00:00:00
E35223 | Wilson, Leroy | 1 | 10:09 | 09:55 | 13 | Jul 29 | 14.00000000000003 | 55.71428571428559 | 14.00000000000003 | 13 | 1.076923076923079 | 2011-07-29 00:00:00