Spreadsheet: 135308d1325920912-averaging-weekly-data-from-daily-data-from-multiple-spread-sheets-functions-naming-and-indirect-solution
Sheet: employee 1

2011-11-01 00:00:00 | 1.75 | 125 | 10121 |  |  |  | 2011-11-01 00:00:00 | 0.25 | 16 | 2646 |  |  |  | 2011-11-01 00:00:00 | 3.25 | 221 | 6924
2011-11-02 00:00:00 | 6.5 | 537 | 25107 |  |  |  | 2011-11-02 00:00:00 |  |  |  |  |  |  | 2011-11-02 00:00:00
2011-11-03 00:00:00 | 2.75 | 230 | 17028 |  |  |  | 2011-11-03 00:00:00 | 0.25 | 41 | 2973 |  |  |  | 2011-11-03 00:00:00 | 0.5 | 59 | 3046
2011-11-04 00:00:00 | 4.75 | 352 | 31905 |  |  |  | 2011-11-04 00:00:00 |  |  |  |  |  |  | 2011-11-04 00:00:00
2011-11-05 00:00:00 |  |  |  |  |  |  | 2011-11-05 00:00:00 |  |  |  |  |  |  | 2011-11-05 00:00:00
2011-11-06 00:00:00 |  |  |  |  |  |  | 2011-11-06 00:00:00 |  |  |  |  |  |  | 2011-11-06 00:00:00
2011-11-07 00:00:00 |  |  |  |  |  |  | 2011-11-07 00:00:00 | 5.25 | 277 | 8153 |  |  |  | 2011-11-07 00:00:00
2011-11-08 00:00:00 |  |  |  |  |  |  | 2011-11-08 00:00:00 | 2.25 | 174 | 15615 |  |  |  | 2011-11-08 00:00:00 | 0.5 | 20 | 390
2011-11-09 00:00:00 | 3.25 | 282 | 9741 |  |  |  | 2011-11-09 00:00:00 | 0.5 | 26 | 1821 |  |  |  | 2011-11-09 00:00:00 | 1.5 | 98 | 9591
2011-11-10 00:00:00 |  |  |  |  |  |  | 2011-11-10 00:00:00 | 2.5 | 110 | 4878 |  |  |  | 2011-11-10 00:00:00 | 0.75 | 56 | 1485
2011-11-11 00:00:00 | 4.5 | 387 | 17946 |  |  |  | 2011-11-11 00:00:00 |  |  |  |  |  |  | 2011-11-11 00:00:00
2011-11-12 00:00:00 |  |  |  |  |  |  | 2011-11-12 00:00:00 |  |  |  |  |  |  | 2011-11-12 00:00:00
2011-11-13 00:00:00 |  |  |  |  |  |  | 2011-11-13 00:00:00 |  |  |  |  |  |  | 2011-11-13 00:00:00
2011-11-14 00:00:00 | 1.75 | 111 | 10395 |  |  |  | 2011-11-14 00:00:00 | 1.25 | 74 | 3345 |  |  |  | 2011-11-14 00:00:00 | 1 | 85 | 10112
2011-11-15 00:00:00 | 4 | 277 | 27375 |  |  |  | 2011-11-15 00:00:00 | 2.25 | 110 | 5958 |  |  |  | 2011-11-15 00:00:00
2011-11-16 00:00:00 | 5.75 | 555 | 16384 |  |  |  | 2011-11-16 00:00:00 |  |  |  |  |  |  | 2011-11-16 00:00:00
2011-11-17 00:00:00 |  |  |  |  |  |  | 2011-11-17 00:00:00 | 4.25 | 242 | 16275 |  |  |  | 2011-11-17 00:00:00 | 1 | 89 | 3331
2011-11-18 00:00:00 |  |  |  |  |  |  | 2011-11-18 00:00:00 | 1 | 113 | 7230 |  |  |  | 2011-11-18 00:00:00 | 2.5 | 153 | 5428
2011-11-19 00:00:00 |  |  |  |  |  |  | 2011-11-19 00:00:00 |  |  |  |  |  |  | 2011-11-19 00:00:00
2011-11-20 00:00:00 |  |  |  |  |  |  | 2011-11-20 00:00:00 |  |  |  |  |  |  | 2011-11-20 00:00:00
2011-11-21 00:00:00 | 0.75 | 103 | 5277 |  |  |  | 2011-11-21 00:00:00 | 1.25 | 104 | 6228 |  |  |  | 2011-11-21 00:00:00 | 1.25 | 84 | 3467
2011-11-22 00:00:00 | 6.5 | 454 | 22110 |  |  |  | 2011-11-22 00:00:00 |  |  |  |  |  |  | 2011-11-22 00:00:00
2011-11-23 00:00:00 | 4.5 | 326 | 16047 |  |  |  | 2011-11-23 00:00:00 | 0.5 | 49 | 2682 |  |  |  | 2011-11-23 00:00:00
2011-11-24 00:00:00 |  |  |  |  |  |  | 2011-11-24 00:00:00 |  |  |  |  |  |  | 2011-11-24 00:00:00
2011-11-25 00:00:00 |  |  |  |  |  |  | 2011-11-25 00:00:00 |  |  |  |  |  |  | 2011-11-25 00:00:00
2011-11-26 00:00:00 |  |  |  |  |  |  | 2011-11-26 00:00:00 |  |  |  |  |  |  | 2011-11-26 00:00:00
2011-11-27 00:00:00 |  |  |  |  |  |  | 2011-11-27 00:00:00 |  |  |  |  |  |  | 2011-11-27 00:00:00
2011-11-28 00:00:00 |  |  |  |  |  |  | 2011-11-28 00:00:00 | 2 | 213 | 11160 |  |  |  | 2011-11-28 00:00:00 | 0.25 | 20 | 279
2011-11-29 00:00:00 | 6.5 | 392 | 25218 |  |  |  | 2011-11-29 00:00:00 |  |  |  |  |  |  | 2011-11-29 00:00:00
2011-11-30 00:00:00 | 2.5 | 193 | 12297 |  |  |  | 2011-11-30 00:00:00 | 3 | 155 | 7329 |  |  |  | 2011-11-30 00:00:00 |  | 11 | 234
November |  |  |  |  |  |  | November |  |  |  |  |  |  | November
2011-12-01 00:00:00 | 3.75 | 267 | 17367 |  |  |  | 2011-12-01 00:00:00 |  |  |  |  |  |  | 2011-12-01 00:00:00 | 2 | 156 | 5390
2011-12-02 00:00:00 | 1 | 65 | 5640 |  |  |  | 2011-12-02 00:00:00 | 3.25 | 297 | 19080 |  |  |  | 2011-12-02 00:00:00 | 1 | 61 | 2072
2011-12-03 00:00:00 |  |  |  |  |  |  | 2011-12-03 00:00:00 |  |  |  |  |  |  | 2011-12-03 00:00:00
2011-12-04 00:00:00 |  |  |  |  |  |  | 2011-12-04 00:00:00 |  |  |  |  |  |  | 2011-12-04 00:00:00
2011-12-05 00:00:00 | 6.75 | 495 | 25119 |  |  |  | 2011-12-05 00:00:00 |  |  |  |  |  |  | 2011-12-05 00:00:00
2011-12-06 00:00:00 |  |  |  |  |  |  | 2011-12-06 00:00:00 | 3.5 | 155 | 4785 |  |  |  | 2011-12-06 00:00:00 | 1 | 105 | 7012
2011-12-07 00:00:00 | 2.25 | 165 | 7233 |  |  |  | 2011-12-07 00:00:00 | 2.75 | 214 | 18186 |  |  |  | 2011-12-07 00:00:00
2011-12-08 00:00:00 | 1.5 | 71 | 6309 |  |  |  | 2011-12-08 00:00:00 | 3 | 157 | 7083 |  |  |  | 2011-12-08 00:00:00
2011-12-09 00:00:00 | 2.25 | 160 | 9360 |  |  |  | 2011-12-09 00:00:00 | 1.75 | 110 | 7050 |  |  |  | 2011-12-09 00:00:00 |  | 11 | 518
2011-12-10 00:00:00 |  |  |  |  |  |  | 2011-12-10 00:00:00 |  |  |  |  |  |  | 2011-12-10 00:00:00
2011-12-11 00:00:00 |  |  |  |  |  |  | 2011-12-11 00:00:00 |  |  |  |  |  |  | 2011-12-11 00:00:00
2011-12-12 00:00:00 | 6.25 | 565 | 36180 |  |  |  | 2011-12-12 00:00:00 |  |  |  |  |  |  | 2011-12-12 00:00:00
2011-12-13 00:00:00 |  |  |  |  |  |  | 2011-12-13 00:00:00 |  |  |  |  |  |  | 2011-12-13 00:00:00
2011-12-14 00:00:00 | 1.25 | 107 | 5310 |  |  |  | 2011-12-14 00:00:00 | 1.75 | 136 | 6933 |  |  |  | 2011-12-14 00:00:00 | 2.25 | 132 | 13102
2011-12-15 00:00:00 | 6 | 399 | 19605 |  |  |  | 2011-12-15 00:00:00 |  |  |  |  |  |  | 2011-12-15 00:00:00
2011-12-16 00:00:00 | 1.75 | 146 | 7275 |  |  |  | 2011-12-16 00:00:00 | 4 | 162 | 4950 |  |  |  | 2011-12-16 00:00:00 |  | 2 | 90
2011-12-17 00:00:00 |  |  |  |  |  |  | 2011-12-17 00:00:00 |  |  |  |  |  |  | 2011-12-17 00:00:00
2011-12-18 00:00:00 |  |  |  |  |  |  | 2011-12-18 00:00:00 |  |  |  |  |  |  | 2011-12-18 00:00:00
2011-12-19 00:00:00 |  |  |  |  |  |  | 2011-12-19 00:00:00 | 5.5 | 318 | 9501 |  |  |  | 2011-12-19 00:00:00 | 1.25 | 87 | 1596
2011-12-20 00:00:00 | 5.5 | 455 | 21402 |  |  |  | 2011-12-20 00:00:00 | 0.75 | 43 | 1680 |  |  |  | 2011-12-20 00:00:00 | 0.5 | 53 | 2498
2011-12-21 00:00:00 | 2.25 | 197 | 9145 |  |  |  | 2011-12-21 00:00:00 | 3.25 | 268 | 15822 |  |  |  | 2011-12-21 00:00:00
2011-12-22 00:00:00 |  |  |  |  |  |  | 2011-12-22 00:00:00 | 2.25 | 176 | 9591 |  |  |  | 2011-12-22 00:00:00 | 0.75 | 100 | 3989
2011-12-23 00:00:00 | 5.25 | 449 | 28365 |  |  |  | 2011-12-23 00:00:00 |  |  |  |  |  |  | 2011-12-23 00:00:00 | 1.75 | 87 | 3200
2011-12-24 00:00:00 |  |  |  |  |  |  | 2011-12-24 00:00:00 |  |  |  |  |  |  | 2011-12-24 00:00:00
2011-12-25 00:00:00 |  |  |  |  |  |  | 2011-12-25 00:00:00 |  |  |  |  |  |  | 2011-12-25 00:00:00
2011-12-26 00:00:00 |  |  |  |  |  |  | 2011-12-26 00:00:00 |  |  |  |  |  |  | 2011-12-26 00:00:00
2011-12-27 00:00:00 |  |  |  |  |  |  | 2011-12-27 00:00:00 |  |  |  |  |  |  | 2011-12-27 00:00:00
2011-12-28 00:00:00 |  |  |  |  |  |  | 2011-12-28 00:00:00 | 0.25 | 35 | 1950 |  |  |  | 2011-12-28 00:00:00 | 0.25 | 14 | 1940
2011-12-29 00:00:00 | 6.75 | 569 | 18183 |  |  |  | 2011-12-29 00:00:00 |  |  |  |  |  |  | 2011-12-29 00:00:00
2011-12-30 00:00:00 |  |  |  |  |  |  | 2011-12-30 00:00:00 |  |  |  |  |  |  | 2011-12-30 00:00:00
2011-12-31 00:00:00 |  |  |  |  |  |  | 2011-12-31 00:00:00 |  |  |  |  |  |  | 2011-12-31 00:00:00
December |  |  |  |  |  |  | December |  |  |  |  |  |  | December