Spreadsheet: 881431d1729516274-need-to-rank-daily-activity-based-upon-date-initials-and-time-arrived-at-the-jobs-ranking-problem
Sheet: Sheet2

AppointmentDate | Technician | Address | AppmntWindow | ClockInTime | JobCount | Rank
2024-10-15 00:00:00 | AE | 8033 ORANGE ST | 8 to 10 | 09:35:00 | 4 | 1
2024-10-15 00:00:00 | AE | 114 W ALONDRA BLVD | 12 to 3 | 11:53:00 | 4 | 2
2024-10-16 00:00:00 | AE | 5671 ASH ST | 8 to 10 | 09:25:00 | 4 | 1
2024-10-16 00:00:00 | AE | 114 W ALONDRA BLVD | 12 to 3 | 14:57:00 | 5 | 2
2024-10-17 00:00:00 | AE | 24400 SILVER CREEK WAY | 8 to 10 | 08:40:00 | 1 | 1
2024-10-18 00:00:00 | AE | 370 COUNTRY CLUB DR #C | 8 to 10 | 13:13:00 | 3 | 1
2024-10-15 00:00:00 | AH | 9809 SHEEP RANCH RD | 8 to 10 | 08:52:00 | 1 | 1
2024-10-15 00:00:00 | AH | 10008 SKYVIEW CT | 9 to 11 | 10:20:00 | 1 | 2
2024-10-15 00:00:00 | AH | 7081 TURNBERRY LN | 11 to 2 | 13:41:00 | 1 | 3
2024-10-15 00:00:00 | AH | 706 MISSION RIDGE DR | 12 to 3 | 16:08:00 | 1 | 4
2024-10-16 00:00:00 | AH | 335 N 1ST AVE | 8 to 10 | 08:33:00 | 1 | 1
2024-10-16 00:00:00 | AH | 5435 ANTIQUE ROSE WAY | 9 to 11 | 09:49:00 | 1 | 2
2024-10-16 00:00:00 | AH | 1135 CEDAR CREEK DR #3 | 10 to 12 | 10:46:00 | 1 | 3
2024-10-16 00:00:00 | AH | 1482 RIVERVIEW CIR W | 11 to 2 | 12:28:00 | 1 | 4
2024-10-16 00:00:00 | AH | 313 PARK AVE | 12 to 3 | 14:24:00 | 1 | 5
2024-10-17 00:00:00 | AH | 4805 DANIELLE PL | 8 to 10 | 09:20:00 | 1 | 1
2024-10-17 00:00:00 | AH | 2312 BANGS AVE | 9 to 11 | 10:44:00 | 1 | 2
2024-10-17 00:00:00 | AH | 3912 WARMERDAM LN | 10 to 12 | 11:12:00 | 1 | 3
2024-10-17 00:00:00 | AH | 6013 E KEYES RD | 12 to 3 | 12:55:00 | 1 | 4
2024-10-17 00:00:00 | AH | 2509 ADRIAN ST | 1 to 4 | 13:39:00 | 1 | 5
2024-10-17 00:00:00 | AH | 2100 EL CAMINO DR | 2 to 5 | 14:36:00 | 1 | 6
2024-10-17 00:00:00 | AH | 1164 CRESCENT AVE | 8 to 9 | 16:39:00 | 1 | 7
2024-10-18 00:00:00 | AH | 10008 SKYVIEW CT | 8 to 10 | 09:04:00 | 1
2024-10-18 00:00:00 | AH | 1522 LEONARD RD | 9 to 11 | 10:00:00 | 1
2024-10-18 00:00:00 | AH | 7081 TURNBERRY LN | 11 to 2 | 13:24:00 | 1
2024-10-18 00:00:00 | AH | 2005 WYLIE DR | 12 to 3 | 14:31:00 | 1
2024-10-19 00:00:00 | AH | 600 LAUREL AVE | 8 to 9 | 08:50:00 | 1
2024-10-19 00:00:00 | AH | 5435 ANTIQUE ROSE WAY | 8 to 10 | 10:10:00 | 1
2024-10-19 00:00:00 | AH | 1002 THOREAU CT | 9 to 11 | 11:23:00 | 1
2024-10-19 00:00:00 | AH | 1002 THOREAU CT | ! | 11:40:00 | 1
2024-10-19 00:00:00 | AH | 313 PARK AVE | 10 to 12 | 12:59:00 | 1
2024-10-19 00:00:00 | AH | 17410 ATWATER DR | 11 to 2 | 13:46:00 | 1
2024-10-14 00:00:00 | AI | 1643 OAKWOOD AVE | 8 to 9 | 08:37:00 | 4
2024-10-14 00:00:00 | AI | 12450 LAKEWOOD BLVD APT 305 | 10 to 12 | 11:22:00 | 2
2024-10-14 00:00:00 | AI | 12611 ATHENS WAY | 12 to 3 | 13:36:00 | 2
2024-10-14 00:00:00 | AI | 803 E VICTORIA ST Unit 127 | 1 to 4 | 14:00:00 | 1
2024-10-14 00:00:00 | AI | 4545 WHITEWOOD AVE | 1 to 4 | 14:48:00 | 1
2024-10-14 00:00:00 | AI | 5315 VISTA REAL | 2 to 5 | 15:40:00 | 1
2024-10-15 00:00:00 | AI | 6475 ATLANTIC AVE SPC 358 | 9 to 11 | 09:44:00 | 1
2024-10-15 00:00:00 | AI | 127 E GORDON ST | 9 to 11 | 10:12:00 | 2
2024-10-15 00:00:00 | AI | 2330 W WARDLOW RD | 10 to 12 | 10:59:00 | 2
2024-10-15 00:00:00 | AI | 21900 MARTIN ST SPC E7 | 11 to 1 | 11:46:00 | 1
2024-10-15 00:00:00 | AI | 2785 PACIFIC COAST HWY STE F | 12 to 3 | 12:18:00 | 1
2024-10-15 00:00:00 | AI | 803 E VICTORIA ST Unit 127 | 12 to 3 | 13:30:00 | 2
2024-10-15 00:00:00 | AI | 2610 N DELTA AVE | 2 to 5 | 14:23:00 | 1
2024-10-16 00:00:00 | AI | 11602 FACULTY DR | 8 to 9 | 08:28:00 | 1
2024-10-16 00:00:00 | AI | 6814 ALONDRA BLVD | 8 to 10 | 09:13:00 | 1
2024-10-16 00:00:00 | AI | 164 W 220TH ST #4 | 9 to 11 | 10:29:00 | 1
2024-10-16 00:00:00 | AI | 609 KNOB HILL AVE | 10 to 12 | 11:02:00 | 1
2024-10-16 00:00:00 | AI | 1217 N SEPULVEDA BLVD | 11 to 1 | 12:03:00 | 1
2024-10-16 00:00:00 | AI | 5370 PACIFIC TER UNIT 104 | 11 to 2 | 12:35:00 | 2
2024-10-16 00:00:00 | AI | 13645 JEFFERSON AVE | 1 to 4 | 13:54:00 | 2
2024-10-17 00:00:00 | AI | 4514 EASTBROOK AVE | 8 to 9 | 08:50:00 | 1
2024-10-17 00:00:00 | AI | 914 W D ST | 8 to 10 | 09:38:00 | 2
2024-10-17 00:00:00 | AI | 2941 VIA ALVARADO | 10 to 12 | 11:23:00 | 2
2024-10-17 00:00:00 | AI | 1009 11TH ST | 11 to 2 | 12:40:00 | 2
2024-10-17 00:00:00 | AI | 18526 S DENKER AVE | 12 to 3 | 13:34:00 | 2
2024-10-17 00:00:00 | AI | 6814 ALONDRA BLVD | 1 to 4 | 14:18:00 | 2
2024-10-18 00:00:00 | AI | 1903 CONDON AVE | 8 to 9 | 07:52:00 | 1
2024-10-18 00:00:00 | AI | 1217 N SEPULVEDA BLVD | 8 to 10 | 09:33:00 | 1
2024-10-18 00:00:00 | AI | 20729 WENDY DR | 9 to 11 | 09:47:00 | 1
2024-10-18 00:00:00 | AI | 20729 WENDY DR | 9 to 11 | 10:22:00 | 1
2024-10-18 00:00:00 | AI | 179 E CLARION DR | 11 to 1 | 11:10:00 | 2
2024-10-18 00:00:00 | AI | 2815 LOMINA AVE | 12 to 3 | 11:53:00 | 2
2024-10-18 00:00:00 | AI | 6321 LA JARA ST | 1 to 4 | 13:35:00 | 2
2024-10-18 00:00:00 | AI | 5127 N LYMAN AVE | 2 to 5 | 15:18:00 | 2