Spreadsheet: 76375d1276876637-sumproduct-across-multiple-sheets-not-working-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-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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-17 00:00:00
2010-06-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-18 00:00:00
2010-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-19 00:00:00
2010-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-20 00:00:00
2010-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-21 00:00:00
2010-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-22 00:00:00
2010-06-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-23 00:00:00
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 (%) | 101.4618547281864 | 106.4255731352922 | 89.36365023653289 |  | 97.37155090390104 | 99.0948845723584 | 106.4340459862848 | 113.3571526728047 | 132.0481335952848 | 104.3673795722566 | 68.98921832884096 | 72.98981426003596 | 60.4933586337761 | 54.6144626448262 |  |  | 87.56 | 61.93999999999999 | 65.53 | 0 | 84.08 | 98.32999999999998 | 99.16000000000001 | 72.77 | 81.44000000000001 | 100.06 | 74.2 | 83.44999999999999 | 79.05 | 75.09
 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-05 00:00:00 | 10.54 |  |  |  |  | 7.5 |  | 11.7 |  |  |  | 5.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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: | 88.84 | 65.92 | 58.56 | 0 | 81.86999999999999 | 97.44 | 105.54 | 82.49 | 107.54 | 104.43 | 51.19 | 60.91 | 47.82 | 41.01