Spreadsheet: 79713d1279900615-keeping-count-total-after-cells-have-been-deleted-service-dispatch-w-tabs
Sheet: DAILY LABOR TRACKING

EFFICIENCY | BF | BS | DA | DB | DH | JZ | RA | RG | TF | TP | MH | MK | RS | AC |  | ACTUAL HOURS | BF | BS | DA | DB | DH | JZ | RA | RG | TF | TP | MH | MK | RS | AC
2010-07-01 00:00:00 | 138.5276073619632 | 144.6960667461263 | 103.6458333333333 |  | 103.7790697674419 | 141.8956043956044 | 133.477789815818 | 127.6315789473684 | 128.7917737789203 | 129.7482837528604 |  |  | 99.26686217008796 | 59.29304446978336 |  | 2010-07-01 00:00:00 | 8.15 | 8.39 | 7.68 |  | 6.88 | 7.28 | 9.23 | 7.6 | 7.78 | 8.74 |  |  | 6.82 | 8.77
2010-07-02 00:00:00 | 110.0103199174407 | 111.5338882282997 | 104.3290043290043 |  | 112.6874279123414 | 109.9344978165939 | 107.0405727923628 | 118.6842105263158 | 140.4589371980676 | 99.77851605758583 | 125.3644314868805 |  | 125.0877192982456 | 39.44444444444444 |  | 2010-07-02 00:00:00 | 9.69 | 8.41 | 6.93 |  | 8.67 | 9.16 | 8.38 | 3.8 | 8.28 | 9.03 | 3.43 |  | 5.7 | 3.6
2010-07-03 00:00:00 | 116.6887417218543 |  |  |  |  | 121.3282247765006 |  |  |  |  | 68.75934230194319 |  |  |  |  | 2010-07-03 00:00:00 | 7.55 |  |  |  |  | 7.83 |  |  |  |  | 6.69
2010-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-04 00:00:00
2010-07-05 00:00:00 | 245.2072538860103 |  | 102.0833333333333 |  |  | 95.82863585118378 |  |  |  |  | 41.35338345864662 | 94.56366237482118 |  |  |  | 2010-07-05 00:00:00 | 7.72 |  | 7.68 |  |  | 8.87 |  |  |  |  | 5.32 | 6.99
2010-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-06 00:00:00
2010-07-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-07 00:00:00
2010-07-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-08 00:00:00
2010-07-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00
2010-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00
2010-07-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-11 00:00:00
2010-07-12 00:00:00 |  | 82.61421319796955 | 100 |  |  |  | 83.24324324324324 |  |  | 69.71153846153845 |  |  | 59.02192242833053 | 100 |  | 2010-07-12 00:00:00 |  | 7.88 | 7.68 |  |  |  | 7.4 |  |  | 8.32 |  |  | 5.93 | 7.57
2010-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00
2010-07-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00
2010-07-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-15 00:00:00
2010-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00
2010-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00
2010-07-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-18 00:00:00
2010-07-19 00:00:00 | 130.1745635910224 |  | 98.7012987012987 |  | 98.57954545454545 | 103.3036848792885 |  | 47.16981132075471 |  |  | 60.64610866372981 |  |  |  |  | 2010-07-19 00:00:00 | 8.02 |  | 6.93 |  | 7.04 | 7.87 |  | 6.36 |  |  | 6.81
2010-07-20 00:00:00 | 124.9343832020997 | 100 | 105.421686746988 |  | 119.2307692307692 | 54.5876887340302 | 87.15710723192021 | 168.7116564417178 | 100 | 117.0059880239521 | 61.32756132756133 |  | 98.78706199460918 | 15.30612244897959 |  | 2010-07-20 00:00:00 | 7.62 | 7.77 | 3.32 |  | 8.06 | 8.61 | 8.02 | 8.15 | 7.72 | 8.35 | 6.93 |  | 7.42 | 2.94
2010-07-21 00:00:00 | 113.9240506329114 | 125.0909090909091 |  |  | 92.49658935879945 | 14.15094339622642 | 93.10776942355888 | 135.8695652173913 | 131.3648293963255 | 101.4319809069212 | 72.46376811594203 |  | 29.75543478260869 |  |  | 2010-07-21 00:00:00 | 7.9 | 8.25 |  |  | 7.33 | 6.36 | 7.98 | 7.36 | 7.62 | 8.38 | 6.9 |  | 7.36
2010-07-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00
2010-07-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00
2010-07-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00
2010-07-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-25 00:00:00
2010-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-26 00:00:00
2010-07-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-27 00:00:00
2010-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-28 00:00:00
2010-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-29 00:00:00
2010-07-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-30 00:00:00
2010-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-31 00:00:00
EFFICIENCY (%) | 138.8349514563107 | 113.3169533169533 | 102.0636499254102 |  | 105.9505002632965 | 93.1225437656306 | 102.0970495001219 | 123.1139164412384 | 125.4140127388535 | 103.7365716954694 | 67.84922394678492 | 94.56366237482118 | 81.01113451700272 | 63.98601398601399 |  |  | 56.64999999999999 | 40.7 | 40.22 | 0 | 37.98 | 55.98 | 41.01000000000001 | 33.27 | 31.4 | 42.82 | 36.08 | 6.99 | 33.23 | 22.88
 | BF | BS | DA | DB | DH | JZ | RA | RG | TF | TP | MH | MK | RS | AC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BILLED HOURS | BF | BS | DA | DB | DH | JZ | RA | RG | TF | TP | MH | MK | RS | AC
[NAME] | 102.24 | 104.49 | 91.69 |  | 90.62 | 101.82 | 108.25 | 107.12 | 136.06 | 109.05 | 63.64 | 72 | 55.91 | 43.06 |  | 2010-07-01 00:00:00 | 11.29 | 12.14 | 7.96 |  | 7.14 | 10.33 | 12.32 | 9.7 | 10.02 | 11.34 |  |  | 6.77 | 5.2
JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-02 00:00:00 | 10.66 | 9.38 | 7.23 |  | 9.77 | 10.07 | 8.97 | 4.51 | 11.63 | 9.01 | 4.3 |  | 7.13 | 1.42
AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-03 00:00:00 | 8.81 |  |  |  |  | 9.5 |  |  |  |  | 4.6
SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-04 00:00:00
OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-05 00:00:00 | 18.93 |  | 7.84 |  |  | 8.5 |  |  |  |  | 2.2 | 6.61
NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-06 00:00:00
DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00 |  | 6.51 | 7.68 |  |  |  | 6.16 |  |  | 5.8 |  |  | 3.5 | 7.57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-19 00:00:00 | 10.44 |  | 6.84 |  | 6.94 | 8.13 |  | 3 |  |  | 4.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00 | 9.52 | 7.77 | 3.5 |  | 9.61 | 4.7 | 6.99 | 13.75 | 7.72 | 9.77 | 4.25 |  | 7.33 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-21 00:00:00 | 9 | 10.32 |  |  | 6.78 | 0.9 | 7.43 | 10 | 10.01 | 8.5 | 5 |  | 2.19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY TOTAL: | 78.64999999999999 | 46.12 | 41.05 | 0 | 40.24 | 52.13 | 41.87 | 40.96 | 39.38 | 44.42 | 24.48 | 6.61 | 26.92 | 14.64