Spreadsheet: 123592d1317745411-keeping-formula-rolling-customer-care-attendance-tracker-proposed-10-4-2011-mgm-
Sheet: daily

Agent | Schedule |  |  |  | Actual |  |  |  |  | Time |  |  | [NAME] |  |  | Violation |  |  | Verified By: |  |  | [NAME]
 | (mins) | (hrs:mins) | (mins) | (hrs:mins) | (mins) | (hrs:mins) | (mins) | (hrs:mins) |  | In | Out |  | Sch Duration | % Miss |  | Tardy/Abs | IEX |  |  |  |  | Brock Soper
[NAME], Sean | 435 | 7.15 | 975 | 16.15 | 435 | 2010-02-09 07:15:58 | 975 | 2010-02-09 16:15:28 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME], [NAME] | 480 | 8 | 930 | 15.3 | 481 | 2010-02-09 08:01:21 | 930 | 2010-02-09 15:30:18 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Barranco, [NAME] | 540 | 9 | 1080 | 18 | 625 | 2010-02-09 10:25:54 | 1080 | 2010-02-09 18:00:19 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Barron, [NAME] | 450 | 7.3 | 900 | 15 | 452 | 2010-02-09 07:32:58 | 901 | 2010-02-09 15:01:44 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Bartley, [NAME] | 510 | 8.3 | 990 | 16.3 | 519 | 2010-02-09 08:39:17 | 992 | 2010-02-09 16:32:47 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Batson, Erick | 480 | 8 | 1140 | 19 | 477 | 2010-02-09 07:57:24 | 1103 | 2010-02-09 18:23:57 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Beato, [NAME] | 540 | 9 | 1080 | 18 | 539 | 2010-02-09 08:59:28 | 1082 | 2010-02-09 18:02:28
Beltran, Ricardo | 540 | 9 | 1080 | 18 | 541 | 2010-02-09 09:01:08 | 1081 | 2010-02-09 18:01:19
Boosinger, [NAME] | 525 | 8.45 | 1185 | 19.45 | 543 | 2010-02-09 09:03:15 | 1122 | 2010-02-09 18:42:23
[NAME], [NAME] | 510 | 8.3 | 1050 | 17.3 | 509 | 2010-02-09 08:29:26 | 1050 | 2010-02-09 17:30:40
Cage, Canara | 600 | 10 | 840 | 14 | 608 | 2010-02-09 10:08:05 | 847 | 2010-02-09 14:07:26
Camarena, Gustavo | 480 | 8 | 1080 | 18 | 540 | 2010-02-09 09:00:59 | 1081 | 2010-02-09 18:01:06
Cantey, Kenyatta | 495 | 8.15 | 1155 | 19.15 | 507 | 2010-02-09 08:27:16 | 1118 | 2010-02-09 18:38:08
[NAME], Stephen | 510 | 8.3 | 1110 | 18.3 | 505 | 2010-02-09 08:25:53 | 1113 | 2010-02-09 18:33:20
Cash, [NAME] | 570 | 9.3 | 1020 | 17 | 549 | 2010-02-09 09:09:20 | 1020 | 2010-02-09 17:00:33
[NAME], [NAME] | 510 | 8.3 | 1170 | 19.3 | 509 | 2010-02-09 08:29:41 | 1130 | 2010-02-09 18:50:59
Chapman, Rabiyyah | 525 | 8.45 | 1065 | 17.45
Copeland, Deronda | 510 | 8.3 | 1170 | 19.3
Cornelius, Al | 570 | 9.3 | 960 | 16 | 569 | 2010-02-09 09:29:50 | 960 | 2010-02-09 16:00:02
Crawford,Tramona | 495 | 8.15 | 1035 | 17.15 | 495 | 2010-02-09 08:15:22 | 1043 | 2010-02-09 17:23:40
Cunningham, Marcus | 540 | 9 | 1080 | 18 | 540 | 2010-02-09 09:00:46 | 1080 | 2010-02-09 18:00:24
Cushman, [NAME] | 660 | 11 | 990 | 16.3 | 659 | 2010-02-09 10:59:13 | 991 | 2010-02-09 16:31:16
Cutrone, [NAME] | 630 | 10.3 | 1080 | 18 | 635 | 2010-02-09 10:35:14 | 1084 | 2010-02-09 18:04:26
[NAME], [NAME] | 660 | 11 | 1200 | 20 | 659 | 2010-02-09 10:59:33 | 1206 | 2010-02-09 20:06:26
[NAME], Kesha | 480 | 8 | 1140 | 19 | 482 | 2010-02-09 08:02:34 | 1140 | 2010-02-09 19:00:19
[NAME], Nesha | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:40 | 1055 | 2010-02-09 17:35:07
[NAME], Tanya | 480 | 8 | 1140 | 19 | 480 | 2010-02-09 08:00:38 | 1101 | 2010-02-09 18:21:37
Dennis, [NAME] | 420 | 7 | 1080 | 18 | 420 | 2010-02-09 07:00:23 | 1046 | 2010-02-09 17:26:50
Ferrell, Amber | 600 | 10 | 900 | 15 | 601 | 2010-02-09 10:01:58 | 919 | 2010-02-09 15:19:01
Frazier, [NAME] | 435 | 7.15 | 885 | 14.45
Frazier, [NAME] | 600 | 10 | 960 | 16
Fuentes, Maria | 480 | 8 | 1020 | 17 | 483 | 2010-02-09 08:03:10 | 1021 | 2010-02-09 17:01:49
Galmore, Mario | 510 | 8.3 | 1050 | 17.3 | 506 | 2010-02-09 08:26:31 | 1050 | 2010-02-09 17:30:14
Gentile, [NAME] | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:04 | 1049 | 2010-02-09 17:29:37
George, Daniel | 420 | 7 | 1020 | 17 | 418 | 2010-02-09 06:58:42 | 1018 | 2010-02-09 16:58:56
[NAME], Sergio | 480 | 8 | 870 | 14.3
[NAME], [NAME] | 510 | 8.3 | 1170 | 19.3 | 509 | 2010-02-09 08:29:10 | 1140 | 2010-02-09 19:00:16
[NAME], [NAME] | 540 | 9 | 1080 | 18 | 540 | 2010-02-09 09:00:02 | 1082 | 2010-02-09 18:02:32
Gordon, Levar | 480 | 8 | 1020 | 17 | 480 | 2010-02-09 08:00:27 | 1018 | 2010-02-09 16:58:19
[NAME], [NAME] | 540 | 9 | 1080 | 18 | 540 | 2010-02-09 09:00:09 | 1080 | 2010-02-09 18:00:59
Green, Arletrice | 540 | 9 | 930 | 15.3 | 540 | 2010-02-09 09:00:11 | 931 | 2010-02-09 15:31:35
Greer, Twaneka | 540 | 9 | 930 | 15.3 | 541 | 2010-02-09 09:01:04 | 939 | 2010-02-09 15:39:23
Griffin, Quintavious | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:20 | 1048 | 2010-02-09 17:28:35
[NAME], [NAME] | 555 | 9.15 | 1095 | 18.15 | 553 | 2010-02-09 09:13:27 | 1096 | 2010-02-09 18:16:17
Hale, [NAME] | 540 | 9 | 1080 | 18 | 536 | 2010-02-09 08:56:40 | 1080 | 2010-02-09 18:00:30
Hale, Darryl | 420 | 7 | 1020 | 17
[NAME], [NAME] | 435 | 7.15 | 1035 | 17.15 | 447 | 2010-02-09 07:27:39 | 1040 | 2010-02-09 17:20:45
Harvey, Roberteen | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:36 | 1051 | 2010-02-09 17:31:54
Hatcher, [NAME] | 480 | 8 | 1140 | 19 | 486 | 2010-02-09 08:06:34 | 1108 | 2010-02-09 18:28:10
Hendrick, [NAME] | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:47 | 1050 | 2010-02-09 17:30:33
Herring, [NAME] | 510 | 8.3 | 1110 | 18.3 | 509 | 2010-02-09 08:29:58 | 1104 | 2010-02-09 18:24:25
Hill, Sassieon | 525 | 8.45 | 765 | 12.45 | 524 | 2010-02-09 08:44:22 | 766 | 2010-02-09 12:46:06
Holston, [NAME] | 615 | 10.15 | 1095 | 18.15 | 618 | 2010-02-09 10:18:17 | 1095 | 2010-02-09 18:15:43
Horton, Demorio | 660 | 11 | 990 | 16.3 | 655 | 2010-02-09 10:55:32 | 998 | 2010-02-09 16:38:29
Hubbert, Cyreous | 480 | 8 | 870 | 14.3 | 480 | 2010-02-09 08:00:06 | 870 | 2010-02-09 14:30:27
Huckleby, [NAME] | 495 | 8.15 | 1035 | 17.15 | 507 | 2010-02-09 08:27:12 | 1042 | 2010-02-09 17:22:17
[NAME], [NAME] | 600 | 10 | 1050 | 17.3 | 598 | 2010-02-09 09:58:58 | 1054 | 2010-02-09 17:34:56
[NAME], April | 570 | 9.3 | 960 | 16 | 569 | 2010-02-09 09:29:18 | 968 | 2010-02-09 16:08:25
Jackson, Kneisha | 465 | 7.45 | 855 | 14.15
[NAME], Tyrone | 660 | 11 | 1200 | 20 | 661 | 2010-02-09 11:01:10 | 1200 | 2010-02-09 20:00:25
Jackson, Wilmer | 630 | 10.3 | 1080 | 18 | 632 | 2010-02-09 10:32:37 | 1085 | 2010-02-09 18:05:33
[NAME], [NAME] | 480 | 8 | 855 | 14.15 | 478 | 2010-02-09 07:58:13 | 854 | 2010-02-09 14:14:42
[NAME], Gracie | 510 | 8.3 | 1050 | 17.3
[NAME], [NAME] | 480 | 8 | 930 | 15.3 | 480 | 2010-02-09 08:00:24 | 953 | 2010-02-09 15:53:31
[NAME], Natali | 540 | 9 | 930 | 15.3 | 539 | 2010-02-09 08:59:17 | 930 | 2010-02-09 15:30:29
Jones, [NAME] | 540 | 9 | 930 | 15.3
Kellogg, [NAME] | 450 | 7.3 | 1050 | 17.3 | 450 | 2010-02-09 07:30:25 | 1050 | 2010-02-09 17:30:02
Krayeva, Alla | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:27 | 1050 | 2010-02-09 17:30:28
Laurence, [NAME] | 630 | 10.3 | 1080 | 18 | 630 | 2010-02-09 10:30:00 | 1081 | 2010-02-09 18:01:09
[NAME], Marvin | 510 | 8.3 | 1050 | 17.3 | 507 | 2010-02-09 08:27:30 | 1051 | 2010-02-09 17:31:31
[NAME], [NAME] | 570 | 9.3 | 1020 | 17 | 568 | 2010-02-09 09:28:35 | 1030 | 2010-02-09 17:10:21
Little, [NAME] | 540 | 9 | 1200 | 20 | 539 | 2010-02-09 08:59:37 | 1201 | 2010-02-09 20:01:12
Livingston,[NAME] | 510 | 8.3 | 1050 | 17.3 | 513 | 2010-02-09 08:33:08 | 1050 | 2010-02-09 17:30:23
Lloyd, [NAME] | 510 | 8.3 | 1050 | 17.3 | 476 | 2010-02-09 07:56:59 | 1050 | 2010-02-09 17:30:43
Lockwood, [NAME] | 630 | 10.3 | 1080 | 18 | 629 | 2010-02-09 10:29:31 | 1080 | 2010-02-09 18:00:09
Lovell, [NAME] | 495 | 8.15 | 1035 | 17.15 | 510 | 2010-02-09 08:30:33 | 1049 | 2010-02-09 17:29:15
[NAME], [NAME] | 630 | 10.3 | 1185 | 19.45 | 628 | 2010-02-09 10:28:47 | 1189 | 2010-02-09 19:49:42
[NAME], [NAME] | 540 | 9 | 930 | 15.3 | 581 | 2010-02-09 09:41:31 | 948 | 2010-02-09 15:48:37
Manning, [NAME] | 450 | 7.3 | 900 | 15 | 448 | 2010-02-09 07:28:06 | 908 | 2010-02-09 15:08:59
Martin, [NAME] | 435 | 7.15 | 885 | 14.45 | 459 | 2010-02-09 07:39:17 | 885 | 2010-02-09 14:45:09
Massey, Carlie | 480 | 8 | 1020 | 17 | 482 | 2010-02-09 08:02:50 | 1020 | 2010-02-09 17:00:05
Matthews, Sean | 435 | 7.15 | 975 | 16.15 | 434 | 2010-02-09 07:14:29 | 974 | 2010-02-09 16:14:20
McKeel, Clabrone | 525 | 8.45 | 1185 | 19.45 | 532 | 2010-02-09 08:52:08 | 1185 | 2010-02-09 19:45:28
McKenzie, Samantha | 435 | 7.15 | 885 | 14.45 | 435 | 2010-02-09 07:15:23 | 958 | 2010-02-09 15:58:44
[NAME], [NAME] | 420 | 7 | 1080 | 18 | 420 | 2010-02-09 07:00:15 | 1080 | 2010-02-09 18:00:55
[NAME], [NAME] | 450 | 7.3 | 990 | 16.3 | 449 | 2010-02-09 07:29:56 | 990 | 2010-02-09 16:30:12
Mills, [NAME] | 525 | 8.45 | 1065 | 17.45 | 526 | 2010-02-09 08:46:13 | 1055 | 2010-02-09 17:35:02
Moore, Kimberly | 540 | 9 | 1080 | 18 | 514 | 2010-02-09 08:34:54 | 1099 | 2010-02-09 18:19:41
Moore, [NAME] | 480 | 8 | 870 | 14.3 | 479 | 2010-02-09 07:59:52 | 903 | 2010-02-09 15:03:47
Morales, [NAME] | 540 | 9 | 840 | 14 | 540 | 2010-02-09 09:00:09 | 840 | 2010-02-09 14:00:52
[NAME], [NAME] | 435 | 7.15 | 885 | 14.45
Munthali, [NAME] | 510 | 8.3 | 1050 | 17.3 | 510 | 2010-02-09 08:30:46 | 1048 | 2010-02-09 17:28:05
Murillo, Javier | 480 | 8 | 1020 | 17 | 479 | 2010-02-09 07:59:10 | 1024 | 2010-02-09 17:04:17
Okunowo, [NAME] | 465 | 7.45 | 855 | 14.15 | 465 | 2010-02-09 07:45:23 | 861 | 2010-02-09 14:21:15
[NAME], [NAME] | 510 | 8.3 | 1050 | 17.3 | 521 | 2010-02-09 08:41:42 | 1050 | 2010-02-09 17:30:25
[NAME], [NAME] | 540 | 9 | 900 | 15 | 535 | 2010-02-09 08:55:33 | 904 | 2010-02-09 15:04:45
Paul, Adia | 540 | 9 | 930 | 15.3
Peart, [NAME] | 510 | 8.3 | 1170 | 19.3 | 510 | 2010-02-09 08:30:28 | 1115 | 2010-02-09 18:35:47
Pineda, [NAME] | 540 | 9 | 1080 | 18 | 540 | 2010-02-09 09:00:03 | 1084 | 2010-02-09 18:04:56
Ramos, Vanity | 450 | 7.3 | 900 | 15 | 449 | 2010-02-09 07:29:10 | 900 | 2010-02-09 15:00:02
Ray, Demerius | 540 | 9 | 990 | 16.3 | 539 | 2010-02-09 08:59:27 | 1007 | 2010-02-09 16:47:48
Real, Ricardo | 420 | 7 | 960 | 16 | 419 | 2010-02-09 06:59:47 | 962 | 2010-02-09 16:02:17
Remy, [NAME] | 510 | 8.3 | 1170 | 19.3 | 510 | 2010-02-09 08:30:10 | 1111 | 2010-02-09 18:31:26
[NAME], Cory | 540 | 9 | 1080 | 18 | 662 | 2010-02-09 11:02:15 | 1092 | 2010-02-09 18:12:37
[NAME], [NAME] | 510 | 8.3 | 870 | 14.3 | 508 | 2010-02-09 08:28:33 | 872 | 2010-02-09 14:32:50
Rogers, Dwayne | 540 | 9 | 930 | 15.3 | 554 | 2010-02-09 09:14:24 | 970 | 2010-02-09 16:10:20
Rose, Ebony | 495 | 8.15 | 1035 | 17.15 | 495 | 2010-02-09 08:15:08 | 1035 | 2010-02-09 17:15:44
Salcedo, Rafael | 480 | 8 | 1020 | 17 | 479 | 2010-02-09 07:59:09 | 1023 | 2010-02-09 17:03:46
Sanchez, Eduardo | 420 | 7 | 960 | 16 | 419 | 2010-02-09 06:59:55 | 961 | 2010-02-09 16:01:50
[NAME], Joel | 510 | 8.3 | 1050 | 17.3 | 512 | 2010-02-09 08:32:02 | 1052 | 2010-02-09 17:32:36
Shadow | 480 | 8 | 1020 | 17 | 478 | 2010-02-09 07:58:18 | 1022 | 2010-02-09 17:02:06
Simmons, [NAME] | 420 | 7 | 1080 | 18 | 423 | 2010-02-09 07:03:46 | 1082 | 2010-02-09 18:02:39
[NAME], [NAME] | 420 | 7 | 840 | 14 | 418 | 2010-02-09 06:58:10 | 848 | 2010-02-09 14:08:48
Simpson, [NAME] | 480 | 8 | 1080 | 18 | 478 | 2010-02-09 07:58:57 | 1080 | 2010-02-09 18:00:25
Smith, Aja | 555 | 9.15 | 1095 | 18.15
Smith, [NAME] | 480 | 8 | 1020 | 17 | 482 | 2010-02-09 08:02:13 | 1020 | 2010-02-09 17:00:05
Smith, [NAME] | 480 | 8 | 1140 | 19 | 495 | 2010-02-09 08:15:49 | 1151 | 2010-02-09 19:11:16
Spinks, Macah | 510 | 8.3 | 1050 | 17.3 | 518 | 2010-02-09 08:38:38 | 1050 | 2010-02-09 17:30:11
Springer, Candice | 480 | 8 | 1020 | 17 | 481 | 2010-02-09 08:01:16 | 1021 | 2010-02-09 17:01:56
Standberry, Anthony | 450 | 7.3 | 990 | 16.3 | 451 | 2010-02-09 07:31:09 | 990 | 2010-02-09 16:30:51
[NAME], [NAME] | 540 | 9 | 1020 | 17 | 539 | 2010-02-09 08:59:49 | 1027 | 2010-02-09 17:07:23
[NAME], [NAME] | 540 | 9 | 930 | 15.3 | 542 | 2010-02-09 09:02:10 | 800 | 2010-02-09 13:20:42
[NAME], Kendall | 480 | 8 | 1140 | 19 | 486 | 2010-02-09 08:06:21 | 1107 | 2010-02-09 18:27:56
Sycks, [NAME] | 480 | 8 | 1140 | 19 | 482 | 2010-02-09 08:02:48 | 1114 | 2010-02-09 18:34:19
[NAME], [NAME] | 450 | 7.3 | 900 | 15 | 450 | 2010-02-09 07:30:58 | 904 | 2010-02-09 15:04:18
Tillman, [NAME] | 540 | 9 | 960 | 16 | 540 | 2010-02-09 09:00:07 | 960 | 2010-02-09 16:00:02
Valcin, [NAME] | 480 | 8 | 1140 | 19 | 478 | 2010-02-09 07:58:53 | 1143 | 2010-02-09 19:03:36
[NAME], [NAME] | 510 | 8.3 | 990 | 16.3 | 511 | 2010-02-09 08:31:24 | 1013 | 2010-02-09 16:53:43
Vandunk, [NAME] | 480 | 8 | 1140 | 19 | 483 | 2010-02-09 08:03:07 | 1127 | 2010-02-09 18:47:38
Veasey, [NAME] | 480 | 8 | 1020 | 17 | 479 | 2010-02-09 07:59:46 | 1020 | 2010-02-09 17:00:02
Ventus, Traci | 465 | 7.45 | 855 | 14.15 | 464 | 2010-02-09 07:44:49 | 863 | 2010-02-09 14:23:03
Waggoner, Angelina | 510 | 8.3 | 1050 | 17.3 | 511 | 2010-02-09 08:31:36 | 1050 | 2010-02-09 17:30:46
Warner, [NAME] | 480 | 8 | 1080 | 18
Washington, [NAME] | 540 | 9 | 930 | 15.3 | 537 | 2010-02-09 08:57:58 | 943 | 2010-02-09 15:43:09
Watts, [NAME] | 510 | 8.3 | 1050 | 17.3 | 512 | 2010-02-09 08:32:03 | 1058 | 2010-02-09 17:38:39
Wells, Ashley | 450 | 7.3 | 1110 | 18.3 | 450 | 2010-02-09 07:30:22 | 1114 | 2010-02-09 18:34:19
Wilcox, [NAME] | 480 | 8 | 960 | 16 | 487 | 2010-02-09 08:07:21 | 1036 | 2010-02-09 17:16:21
Willems, Flint | 630 | 10.3 | 2070 | 34.3 | 631 | 2010-02-09 10:31:39 | 1131 | 2010-02-09 18:51:19
[NAME], [NAME] | 600 | 10 | 990 | 16.3 | 600 | 2010-02-09 10:00:14 | 990 | 2010-02-09 16:30:39
Wills, [NAME] | 660 | 11 | 1200 | 20 | 661 | 2010-02-09 11:01:04 | 1200 | 2010-02-09 20:00:25
Wilson, Kristy | 540 | 9 | 1080 | 18
Wise, [NAME] | 660 | 11 | 1200 | 20 | 662 | 2010-02-09 11:02:15 | 1198 | 2010-02-09 19:58:15
Wood, Shakita | 630 | 10.3 | 990 | 16.3 | 629 | 2010-02-09 10:29:24 | 990 | 2010-02-09 16:30:07
Woods, [NAME] | 540 | 9 | 1080 | 18 | 544 | 2010-02-09 09:04:29 | 1091 | 2010-02-09 18:11:02
Yasuda, Kenny | 630 | 10.3 | 1080 | 18 | 641 | 2010-02-09 10:41:33 | 1086 | 2010-02-09 18:06:10