Spreadsheet: 106452d1303745665-sumifs-across-sheets-copy-of-central-region-2010-2011-with-formulas
Sheet: Sups Conf

FIRST NAME | EMP # | 2010-07-09 00:00:00 | 2010-08-10 00:00:00 | 2010-09-10 00:00:00 | 2010-10-10 00:00:00 | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | 2011-01-11 00:00:00 | 2011-02-11 00:00:00 | 2011-03-11 00:00:00 | 2011-04-11 00:00:00 | 2011-05-11 00:00:00 | 2011-06-11 00:00:00 | Total Hours
[NAME] | 469134 |  | 1 | 1 | 1 | 1 | 1
Timothy | 529229 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 13664 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2
[NAME] | 460396 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 544669 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
Christine | 679672 |  |  |  |  | 1 | 1 | 1 | 1
[NAME] | 500359 |  | 1 |  | 1 | 1 | 1.5 | 2 | 2 | 2
[NAME] | 667628 |  | 1 | 1 | 2 | 2 | 1
Travis | 680051 |  |  |  |  |  | 1 | 2 | 2
[NAME] | 470682 |  | 1 | 1 | 2 | 2 | 2.5 | 2 | 2 | 2
Erin | 667936 |  | 1 | 1 | 1 | 1 | 1 | 2
Ray | 439281 |  | 1 | 1 | 1 | 1 | 1.5 | 2 | 2 | 2
[NAME] | 664807 |  | 1
Traci | 609516 |  |  |  |  |  |  | 1 | 1
Travis | 609332 |  | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
Jared | 662728 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2
[NAME] | 523760 |  | 1 | 1 | 1 | 1 | 1.5 | 2 | 2 | 2
Jessica | 677095
[NAME] | 674404
[NAME] | 616141 |  | 1 | 1 | 1 | 1 | 1.5 | 2 | 2 | 2
Derek | 677036 |  |  | 1 | 1 | 1 | 4 | 1 | 2
[NAME] | 609516 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Bradley | 516080 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 497828 |  | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
Krystena | 653331 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 430190 |  | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
[NAME] | 635528 |  | 2 | 2 | 1 | 2 | 1 | 1 | 1 | 1
[NAME] | 645907 |  | 1 | 1 | 1 | 1 | 1 | 2 | 1
[NAME] | 673951 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
[NAME] | 446201 |  | 1 |  | ML | ML | ML | ML | ML | ML
[NAME] | 622915 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 608660 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 675919 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 515008
[NAME] | 455898
[NAME] | 670776
[NAME] | 19102
[NAME] | 405226
Lula | 610967
Rochelle | 615409
[NAME] | 474081
[NAME] | 247860
Amanda | 673873
[NAME] | 620620
Carin | 514929
[NAME] | 513618
[NAME] | 674203
[NAME] | 655054
[NAME] | 462583
[NAME] | 507182 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
George | 616243 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 477359 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 483062 |  | 1 | 1 | 1 | 1 | 1
[NAME] | 606909 |  | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 488349 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 32707 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Franklin | 679682 |  |  |  |  |  | 1 | 1 | 1 | 1
[NAME] | 613122 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 679685 |  |  |  |  |  | 1 | 1 | 1 | 1
[NAME] | 674083
Dale | 513698 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
Jessica | 677095 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 639703 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 664787 |  | 1 | 1 | 1 | 1 |  | 2 | 2 | 2
Justin | 653789 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 448181
Nikki | 7958
[NAME] | 656721
[NAME] | 616996
Tami | 450916
Kimberly | 432808
Lona | 5823
[NAME] | 528693
[NAME] | 489290
[NAME] | 520779
[NAME] | 9708
[NAME] | 347677
[NAME] | 452174
[NAME] | 455330 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 628827 |  | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Timothy | 470257 |  | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Todd | 618982 |  |  |  |  |  | 1 | 2 | 2 | 2
[NAME] | 618446
Nicole | 638671 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 622727 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 645303 |  | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 617440
[NAME] | 606446 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 460355 |  | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Zachary | 652027 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Shawn | 663678 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 499698 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
[NAME] | 676977 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 641947 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
Juan | 446827 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Bradley | 602003 |  | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 2
George | 502168
Randall | 663837
[NAME] | 659715
[NAME] | 636091
[NAME] | 12748
[NAME] | 614801
[NAME] | 466925
Emory | 160816
Daryl | 653599
Justin | 515384
[NAME] | 649674
[NAME] | 527388
[NAME] | 89729
Caroline | 12916
[NAME] | 669217
Kelly | 673901
[NAME] | 446490
[NAME] | 669006
[NAME] | 394995
[NAME] | 43209
Caroline | 667633
[NAME] | 623267
[NAME] | 56717
Kathy | 623481 |  | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
[NAME] | 533268 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 475530 |  | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
[NAME] | 473273 |  | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
[NAME] | 659747
[NAME] | 448956
[NAME] | 534616
Shawn | 81586
Todd | 504829
[NAME] | 541449
Timothy | 56710 |  | 2 | 1 | 4 | 2 | 2 | 2 | 2
[NAME] | 621258 |  | 2 | 1 | 4 |  | ML
Sandra | 492810 |  | 2
[NAME] | 53181 |  | 2 | 1 |  |  | ML
[NAME] | 635975 |  | 2 | 1 | 3 | 2 | 2 | 2 | 2
[NAME] | 59810 |  | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
[NAME] | 675416 |  | 2 | 1 | 4 | 2 | 2 | 1 | 2
[NAME] | 450487 |  | 2 | 2 | 4 | 2 | 2 | 2 | 2 | 2
Vicky | 446830 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 635084 |  | 2 | 2 | 4 | 2 | 2 | 2 | 2 | 2
Galen | 680213 |  |  |  |  |  | 2
[NAME] | 502960 |  | 2 | 2 | 4 | 2 | 2 | 2 | 2 | 2
[NAME] | 645186
Joel | 619665 |  | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2
Scott | 636016 |  | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 2
Todd | 619982 |  | 2 | 2 | 1 | 1 |  |  | 1
Troy | 676978 |  | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2
Shane | 488803 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Michelle | 520825 |  | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2
Kristopher | 613336 |  | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 1
[NAME] | 411495 |  | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 2
[NAME] | 98009 |  | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2
Irlene | 645301 |  | 2 | 2
[NAME] | 644906 |  | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 2 | 2 | 2
[NAME] | 671174
Todd | 639672 |  | 2 | 2 | 1 | 2 | 2 | ML | ML | 2
Terrance | 461313 |  | 1 |  | 2 | 2 | 1 | 1 | 2 | 4
[NAME] | 663729 |  | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2
Vincent | 674110 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
[NAME] | 488249 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 677203 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
Miguel | 674248 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
Romina | 676896 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
[NAME] | 670906 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
[NAME] | 526682 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
Chad | 607586 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
[NAME] | 626646 | 1 | 2 | 2 | 2
Jedd | 530264 |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vidette | 657385
Zachary | 616149 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
[NAME] | 628918 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
[NAME] | 426168 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
[NAME] | 666271 |  | 1 | 1 | 1 | 1 | 3 | 2 | 2
[NAME] | 626639 |  | 1 | 1 | 1 | 1 |  | 2 | 2
[NAME] | 662452 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 521510
Calvin | 283884 |  | 1 | 1 | 1 | 1 | 3 | 1
Garry | 677053 |  | 1 | 1 | 1
Jeremiah | 679832 |  |  |  |  |  | 4 | 1 | 1
[NAME] | 670907 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
[NAME] | 431668 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 497127 |  | 1 | 1 | 1 | 1 |  | 2 | 2
[NAME] | 446556 |  | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1
[NAME] | 632630
[NAME] | 602369 |  | ML | ML | 1 | 1 | 1
Brett | 444123 |  | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
[NAME] | 131166
[NAME] | 493420 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 494027 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Gerard | 11315
[NAME] | 489660
Treasure | 530695
Randall | 615481
[NAME] | 179032
[NAME] | 465566 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 666299 |  | 1 | 1 | 1 | 1 | 1 | 3 | 1 | 1
[NAME] | 538209 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Lauren | 645588 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 265972 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 417389 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 506229 |  | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 1
Harold | 21348
[NAME] | 514125 |  | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 2 | 2 | 2
Leisa | 493590 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
[NAME] | 472600 |  | 1 | 0.5 | 0.5 | 0.5 | 1 | 2 | 2 | 2
[NAME] | 644916 |  |  | 1 | 1
[NAME] | 634416 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
Shane | 659744 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
Adam | 677139 |  |  | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
[NAME] | 641958 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
[NAME] | 616127 |  | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 2 | 2 | 2
[NAME] | 653330
[NAME] | 452665 |  | 1 | 0.5 | 0.5 | 0.5 | 1 | 2 | 2 | 2
[NAME] | 658222 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
Derek | 525222 |  | 1 | 1 | 1 | 1 | 1.5 | 2 | 2 | 2
[NAME] | 495944 |  | 1 | 1 | 1 | 1 | 1.5 | 1 | 1 | 1
Trent | 489598 |  | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1
[NAME] | 663625 |  | 1 |  | 1 | 1 | 1
[NAME] | 473485 |  | ML | 0.5 | 0.5 | 0.5 | 1 | 2 | 2 | 2
[NAME] | 461290 |  | 1 | 1 | 1 | 1 | 1
[NAME] | 475267 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 455170 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 430731 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 677200 |  | 2 | 2 | 2
Shane | 527607 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Sherrick | 6674220 |  | 1 | 1 | 1 | 1
[NAME] | 27775 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 527393 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 533251 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 681481 |  |  |  |  |  |  |  | 1 | 1
Arlyn | 522112 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 642019 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
Shane | 680150 |  |  |  |  |  | 2 | 2 | 1 | 2
[NAME] | 681801 |  |  |  |  |  |  |  |  | 2
[NAME] | 112831 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 607990 |  |  |  |  |  | 1 | 1 | 1 | 1
Peter-Justin | 537886 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2
Colby | 540668 |  | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 521483 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 85483
[NAME] | 501384 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 662962
Adinah | 638503
[NAME] | 652070
Adam | 675404
Marcus | 631743
[NAME] | 647088
[NAME] | 657343
[NAME] | 633504
[NAME] | 669270
Shane | 646384
Shannon | 653310
[NAME] | 645571
[NAME] | 646857
Kaddu | 640408
Heather | 654488
[NAME] | 663148
Timothy | 654750
[NAME] | 658921
[NAME] | 653332
[NAME] | 631557
MaryAnn | 654754
[NAME] | 644988
Justin | 638658
Mark | 662983
[NAME] | 647704
Stephan | 659642
[NAME] | 653428
[NAME] | 438421
[NAME] | 631552
Christina | 631531
[NAME] | 134613
[NAME] | 659847
Louis | 631545
[NAME] | 674588
[NAME] | 498252
[NAME] | 378851 |  | 2 | 2 | 1 | 1 | 1 | 1 |  | 2
Derek | 643248
[NAME] | 662909
[NAME] | 631506
Darcie | 662837
Kaitlin
[NAME] | 633896
[NAME] | 674512
Blaine | 674558
[NAME] | 659731
[NAME] | 651260
Mario | 670686
[NAME] | 531422
Whitney | 662634
Julia | 626586
Kimberly | 632724
[NAME] | 659649
[NAME] | 620081
[NAME] | 644194
[NAME] | 487267
Grace | 657347
Connie | 657315
Mark | 59590
Caleb | 660034
[NAME] | 662729
Kerry | 657309
Michelle | 659769
Amanda | 618316
Nathan | 637561
[NAME] | 632691
[NAME] | 658840
Randall | 666606
[NAME] | 81663
[NAME] | 647449
Ricky | 633355
[NAME] | 659645
[NAME] | 631699
[NAME] | 474665
[NAME] | 662855
[NAME] | 456153
[NAME] | 468045
Anna | 671050
Christian | 638668
[NAME] | 658923
Chad | 609911
Mark | 439635
[NAME] | 489455
Marlin | 54869
Candace | 645099
Daren | 421243
[NAME] | 502130
Heather | 648924
[NAME] | 623503
[NAME] | 653314
[NAME] | 657256
[NAME] | 526459
[NAME] | 645759
Timothy | 478371
[NAME] | 83511
Chastity | 446146
Mark | 47386
[NAME] | 104814
[NAME] | 645762
Martin | 475845
[NAME] | 668272 |  | 2 | 2 | 1 | 1 | 1 | 1 | 1
[NAME] | 656910
[NAME] | 549324
Connie | 413925
[NAME] | 463688
[NAME] | 618446
[NAME] | 134088
[NAME] | 527391
[NAME] | 641507
[NAME] | 620287
Gregory | 520824
Lewis | 87065
[NAME] | 610838
Maxton | 645755
[NAME] | 403223
[NAME] | 653521
[NAME] | 513363
[NAME] | 659292
Edgar | 661952 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 106684
Christian | 134811
Chad | 610698
Shane | 646463
[NAME] | 13909
[NAME] | 17505
[NAME] | 623484
[NAME] | 638037
[NAME] | 537857
[NAME] | 520061
Jaime | 525057
[NAME] | 653803
[NAME] | 604793
[NAME] | 622883
[NAME] | 627474
Wilson | 620957
Adrian | 638862
[NAME] | 603879
Gregory | 406433
Shane | 480627
[NAME] | 610403
Bradley | 628908