Spreadsheet: 77137d1277629330-does-this-require-vlookup-service-dispatch-w-tabs2
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-06-01 00:00:00 | 116.3487738419618 |  | 98 |  | 96.11650485436894 | 80.09313154831199 | 99.47984395318595 | 123.7341772151899 | 104.2321644498186 | 161.7169373549884 |  | 84.0966921119593 | 23.14814814814815 |  |  | 2010-06-01 00:00:00 | 7.34 |  | 7.5 |  | 8.24 | 8.59 | 7.69 | 6.32 | 8.27 | 8.62 |  | 7.86 | 6.48
2010-06-02 00:00:00 | 99.48849104859335 |  | 102.3391812865497 |  | 133.7442218798151 | 100 | 123.6907730673317 | 95.73643410852713 | 100 | 93.99759903961584 | 88.17480719794345 | 68.80733944954129 | 112.0068610634648 | 0 |  | 2010-06-02 00:00:00 | 7.82 |  | 6.84 |  | 6.49 | 8.15 | 8.02 | 7.74 | 10.49 | 8.33 | 3.89 | 5.45 | 5.83 | 8.69
2010-06-03 00:00:00 | 125.7594167679222 |  |  |  | 92.81437125748504 | 100 | 109.375 | 125.6892230576441 | 123.8651102464332 | 119.4011976047904 | 100 | 62.06482593037214 | 86.3049095607235 | 100 |  | 2010-06-03 00:00:00 | 8.23 |  |  |  | 6.68 | 7.36 | 8.64 | 7.98 | 7.71 | 8.35 | 8.99 | 8.33 | 7.74 | 6.82
2010-06-04 00:00:00 | 89.14473684210527 |  |  |  | 105.4022988505747 | 86.65158371040724 | 161.1806797853309 | 100 | 198.6714975845411 | 47.02517162471396 | 100 | 82.28882833787466 | 71.12359550561797 |  |  | 2010-06-04 00:00:00 | 9.12 |  |  |  | 8.7 | 8.84 | 11.18 | 7.84 | 8.28 | 8.74 | 8.19 | 7.34 | 8.9
2010-06-05 00:00:00 | 149.0806223479491 |  |  |  |  | 118.8589540412044 |  | 173.5905044510386 |  |  |  | 84.31952662721895 |  |  |  | 2010-06-05 00:00:00 | 7.07 |  |  |  |  | 6.31 |  | 6.74 |  |  |  | 6.76
2010-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-06 00:00:00
2010-06-07 00:00:00 | 103.6895674300254 |  | 98.25396825396825 |  | 98.88059701492539 | 108.3798882681564 |  |  |  |  | 32.84132841328412 | 53.67231638418078 |  |  |  | 2010-06-07 00:00:00 | 7.86 |  | 6.3 |  | 8.04 | 8.95 |  |  |  |  | 8.13 | 7.08
2010-06-08 00:00:00 | 79.67171717171718 | 101.9777503090235 | 6.510416666666667 |  | 86.33193863319387 | 60.89663760896637 | 91.92546583850931 | 100 | 104.5287637698898 | 105.7109557109557 | 74.93857493857493 | 72.67373380447584 | 20.16129032258064 | 50.83056478405316 |  | 2010-06-08 00:00:00 | 7.92 | 8.09 | 7.68 |  | 7.17 | 8.03 | 8.05 | 7.39 | 8.17 | 8.58 | 8.14 | 8.49 | 7.44 | 9.03
2010-06-09 00:00:00 | 76.39060568603213 | 125.3462603878117 | 102.3498694516971 |  | 38.51091142490372 | 125.1152073732719 | 133.9506172839506 | 119.4407456724368 | 151.1140235910878 | 140.1902497027348 | 64.61949265687583 | 43.65620736698499 | 63.75739644970414 | 23.99565689467969 |  | 2010-06-09 00:00:00 | 8.09 | 7.22 | 7.66 |  | 7.79 | 8.68 | 8.1 | 7.51 | 7.63 | 8.41 | 7.49 | 7.33 | 6.76 | 9.21
2010-06-10 00:00:00 | 91.61528976572133 | 108.0357142857143 | 102.0833333333333 |  | 72.50608272506082 | 112.0137299771167 | 81.15468409586057 | 58.69565217391304 | 176.328502415459 | 82.36024844720497 | 43.45165238678091 | 67.20741599073 | 90.5982905982906 | 53.3748701973001 |  | 2010-06-10 00:00:00 | 8.11 | 7.84 | 7.68 |  | 8.22 | 8.74 | 9.18 | 5.98 | 8.28 | 8.05 | 8.17 | 8.63 | 5.85 | 9.63
2010-06-11 00:00:00 |  | 90.4639175257732 | 101.1780104712042 |  | 114.1361256544503 | 108.0346106304079 | 105.521472392638 |  | 151.2690355329949 | 117.5707547169811 | 63.30597889800704 |  | 50.26737967914438 | 100 |  | 2010-06-11 00:00:00 | 7.91 | 7.76 | 7.64 |  | 7.64 | 8.09 | 8.15 |  | 7.88 | 8.48 | 8.53 |  | 9.35 | 9.12
2010-06-12 00:00:00 |  | 116.3817663817664 |  |  |  |  | 122.2377622377622 |  |  | 127.9672578444748 |  |  | 40.84507042253522 | 87.46223564954683 |  | 2010-06-12 00:00:00 |  | 7.02 |  |  |  |  | 7.15 |  |  | 7.33 |  |  | 7.1 | 6.62
2010-06-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-13 00:00:00
2010-06-14 00:00:00 |  | 91.82389937106917 |  |  |  |  | 92.92035398230087 |  |  | 84.90566037735849 |  |  |  |  |  | 2010-06-14 00:00:00 |  | 7.95 |  |  |  |  | 7.91 |  |  | 8.48
2010-06-15 00:00:00 |  | 115.994623655914 | 100 |  | 133.9568345323741 | 91.02402022756006 | 84.03693931398418 | 138.6519944979367 | 105.2998605299861 | 71.85273159144893 | 53.18892900120337 | 90.6832298136646 | 100 | 27.71739130434783 |  | 2010-06-15 00:00:00 |  | 7.44 | 6.59 |  | 6.95 | 7.91 | 7.58 | 7.27 | 7.17 | 8.42 | 8.31 | 8.05 | 6.97 | 7.36
2010-06-16 00:00:00 | 100 | 104.7563805104408 | 98.42931937172776 |  | 107.4754901960784 | 100.3456221198157 | 49.80026631158456 | 96.75 | 109.6560846560847 | 102.6602176541717 | 82.56880733944953 | 90.65190651906518 | 16.59125188536953 | 61.55632984901278 |  | 2010-06-16 00:00:00 | 8.09 | 8.62 | 7.64 |  | 8.16 | 8.68 | 7.51 | 8 | 7.56 | 8.27 | 4.36 | 8.13 | 6.63 | 8.61
2010-06-17 00:00:00 | 85.69682151589242 | 100 | 77.53001715265866 |  | 99.6204933586338 | 178.9667896678967 | 92.85714285714285 | 104.9900199600798 | 144.1054091539528 | 113.3734939759036 | 69.44444444444444 | 81.08108108108108 | 16.87763713080169 | 6.417736289381564 |  | 2010-06-17 00:00:00 | 8.18 | 6.92 | 5.83 |  | 5.27 | 8.13 | 7.98 | 5.01 | 7.21 | 8.3 | 6.84 | 5.18 | 7.11 | 8.57
2010-06-18 00:00:00 | 48.9414694894147 | 119.0420560747664 | 59.93150684931508 |  |  | 106.3291139240506 | 138.6100386100386 | 74.12223667100129 | 162.9072681704261 | 110.3225806451613 | 74.61809635722679 | 30.06535947712418 | 19.57040572792362 | 0 |  | 2010-06-18 00:00:00 | 8.03 | 8.56 | 5.84 |  |  | 7.9 | 7.77 | 7.69 | 7.98 | 7.75 | 8.51 | 7.65 | 8.38 | 9.26
2010-06-19 00:00:00 | 107.9207920792079 |  |  |  |  | 111.8942731277533 |  | 96.7741935483871 |  |  | 52.66558966074313 | 26.01626016260162 |  |  |  | 2010-06-19 00:00:00 | 8.08 |  |  |  |  | 6.81 |  | 7.13 |  |  | 6.19 | 6.15
2010-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-20 00:00:00
2010-06-21 00:00:00 | 97.66949152542375 |  |  |  |  | 68.51520572450805 |  | 100 |  |  |  |  |  |  |  | 2010-06-21 00:00:00 | 4.72 |  |  |  |  | 5.59 |  | 3.95
2010-06-22 00:00:00 | 100 | 94.42815249266863 | 100 |  | 62.51511487303507 | 90.41769041769041 | 99.87484355444306 | 112.0261437908497 | 127.5613275613276 |  | 7.077625570776255 | 75.52941176470588 | 130.4054054054054 | 79.29901423877327 |  | 2010-06-22 00:00:00 | 7.96 | 6.82 | 5.84 |  | 8.27 | 8.14 | 7.99 | 7.65 | 6.93 |  | 8.76 | 4.25 | 1.48 | 9.13
2010-06-23 00:00:00 | 100.7425742574257 | 97.0550576184379 | 100 |  | 81.51093439363815 | 71.71597633136095 | 156.6831683168317 | 108.0474934036939 | 121.1800302571861 | 97.0059880239521 | 10.8695652173913 | 109.53125 | 0 | 66.66666666666666 |  | 2010-06-23 00:00:00 | 8.08 | 7.81 | 2.84 |  | 5.03 | 8.45 | 8.08 | 7.58 | 6.61 | 8.35 | 2.3 | 6.4 | 0.4 | 7.86
2010-06-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-24 00:00:00
2010-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-25 00:00:00
2010-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-26 00:00:00
2010-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-27 00:00:00
2010-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-28 00:00:00
2010-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-29 00:00:00
2010-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-30 00:00:00
EFFICIENCY (%) | 97.43609079254958 | 105.4318305268876 | 87.6339077782953 |  | 93.90160740379932 | 101.3324032089292 | 110.2153000458085 | 108.3020218285919 | 134.1381501316148 | 104.8449300980235 | 62.19101123595505 | 70.06544039617968 | 54.542626011201 | 49.16750068237649 |  |  | 132.61 | 92.04999999999998 | 85.88000000000001 | 0 | 102.65 | 143.35 | 130.98 | 111.78 | 110.17 | 124.46 | 106.8 | 113.08 | 96.42 | 109.91
 | 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] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00 | 8.54 |  | 7.35 |  | 7.92 | 6.88 | 7.65 | 7.82 | 8.62 | 13.94 |  | 6.61 | 1.5
JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-02 00:00:00 | 7.78 |  | 7 |  | 8.68 | 8.15 | 9.92 | 7.41 | 10.49 | 7.83 | 3.43 | 3.75 | 6.53
AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-03 00:00:00 | 10.35 |  |  |  | 6.2 | 7.36 | 9.45 | 10.03 | 9.55 | 9.97 | 8.99 | 5.17 | 6.68 | 6.82
SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-04 00:00:00 | 8.13 |  |  |  | 9.17 | 7.66 | 18.02 | 7.84 | 16.45 | 4.11 | 8.19 | 6.04 | 6.33
OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-05 00:00:00 | 10.54 |  |  |  |  | 7.5 |  | 11.7 |  |  |  | 5.7
NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-06 00:00:00
DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-07 00:00:00 | 8.15 |  | 6.19 |  | 7.95 | 9.7 |  |  |  |  | 2.67 | 3.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-08 00:00:00 | 6.31 | 8.25 | 0.5 |  | 6.19 | 4.89 | 7.4 | 7.39 | 8.54 | 9.07 | 6.1 | 6.17 | 1.5 | 4.59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-09 00:00:00 | 6.18 | 9.05 | 7.84 |  | 3 | 10.86 | 10.85 | 8.97 | 11.53 | 11.79 | 4.84 | 3.2 | 4.31 | 2.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-10 00:00:00 | 7.43 | 8.47 | 7.84 |  | 5.96 | 9.79 | 7.45 | 3.51 | 14.6 | 6.63 | 3.55 | 5.8 | 5.3 | 5.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-11 00:00:00 | 7.34 | 7.02 | 7.73 |  | 8.72 | 8.74 | 8.6 |  | 11.92 | 9.97 | 5.4 |  | 4.7 | 9.12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-12 00:00:00 |  | 8.17 |  |  |  |  | 8.74 |  |  | 9.38 |  |  | 2.9 | 5.79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-14 00:00:00 |  | 7.3 |  |  |  |  | 7.35 |  |  | 7.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-15 00:00:00 |  | 8.63 | 6.59 |  | 9.31 | 7.2 | 6.37 | 10.08 | 7.55 | 6.05 | 4.42 | 7.3 | 6.97 | 2.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-16 00:00:00 | 8.09 | 9.03 | 7.52 |  | 8.77 | 8.71 | 3.74 | 7.74 | 8.29 | 8.49 | 3.6 | 7.37 | 1.1 | 5.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-17 00:00:00 | 7.01 | 6.92 | 4.52 |  | 5.25 | 14.55 | 7.41 | 5.26 | 10.39 | 9.41 | 4.75 | 4.2 | 1.2 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-18 00:00:00 | 3.93 | 10.19 | 3.5 |  |  | 8.4 | 10.77 | 5.7 | 13 | 8.55 | 6.35 | 2.3 | 1.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-19 00:00:00 | 8.72 |  |  |  |  | 7.62 |  | 6.9 |  |  | 3.26 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-21 00:00:00 | 4.61 |  |  |  |  | 3.83 |  | 3.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-22 00:00:00 | 7.96 | 6.44 | 5.84 |  | 5.17 | 7.36 | 7.98 | 8.57 | 8.84 |  | 0.62 | 3.21 | 1.93 | 7.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-23 00:00:00 | 8.14 | 7.58 | 2.84 |  | 4.1 | 6.06 | 12.66 | 8.19 | 8.01 | 8.1 | 0.25 | 7.01 | 0 | 5.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY TOTAL: | 129.21 | 97.05 | 75.26 | 0 | 96.38999999999999 | 145.26 | 144.36 | 121.06 | 147.78 | 130.49 | 66.42 | 79.22999999999999 | 52.59 | 54.04