Spreadsheet: 684786d1593534286-formula-to-copy-certain-criteria-to-another-worksheet-rr_06_26_20-1-
Sheet: Schedule

PMR ROUND ROBIN ASSIGNMENTS
Owners Name | Hours |  | Date Range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-22 00:00:00 |  |  |  |  |  |  |  | 442 | TO |  |  | 2020-06-26 00:00:00
 |  |  | Specialties |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONDAY |  |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY
 |  | BPM | API | CFSIS | CMIS | CMOD | Container | CSS |  | CFSICI | LDAP | FDM/CEBI | FSM | CSE | Collab | RE | SP |  | Order | Prod | PMR | S/P1 |  | Order | Prod | PMR | S/P1 | Order | Prod | PMR | S/P1 | Order | Prod | PMR | S/P1 | Order | Prod | PMR | S/P1
[NAME] | M T TH 9-6                     W F 8-5 |  | 0 | 0 | 0 | 0 |  | X | 0 | X |  |  |  | 0 | 0 | 0 | 0 |  | 7 | CE | TS003852248 |  |  | 11 | CE | TS003858517 |  |  |  |  |  |  |  |  |  | 17 | CE | TS003874979
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | CE | TS003859819 |  |  |  | N/A |  |  |  | N/A
Louis | 6-3          N/A [NAME], Wed. and [NAME]. |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 |  | 1 | LDAP | TS003850674 | P1 |  | 3 | LDAP | TS003856410 |  |  |  |  |  | 7 | LDAP | TS003868289 | S | 9 | LDAP | TS003873886
 |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  | 12 | CE | TS003869172 |  | 11 | LDAP | TS003874056 | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | LDAP | TS003869158 | S | 12 | LDAP | TS003874183 | S
[NAME] | 8-5 |  | 0 | 0 | 0 | 0 |  | X | 0 | 0 |  |  |  | X | 0 | X | 0 |  | 8 | CSS | TS003853273 |  |  | 13 | CE | TS003858804 |  | 6 | CE | TS003862330 |  | 15 | LDAP | TS003869415 |  | 7 | LDAP | TS003862885
 |  |  |  |  |  |  |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | CE | TS003816884 | S1 | 23 | LDAP | TS003870234
Greg | 8-5 |  | X | 0 | X | 0 |  | X | 0 | 0 |  |  |  | X | X | X | X |  | 11 | FDM/CEBI | TS003853647 |  |  | 14 | Container | TS003858842 |  | 8 | Container | TS003863246 |  | 11 | CE | TS003865540 | S/S1 | 2 | CE | TS003869613 | S
 |  |  |  |  |  |  | X |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | CMIS | TS003863406 |  | 25 | CE | TS003869613 | S
Fred | 6:00-3:00 |  | 0 | 0 | 0 | 0 |  | X | 0 | 0 |  |  |  | X | 0 | X | 0 |  |  |  |  |  |  | 1 | XT | TS003853786 |  | 1 | CE | TS003860835 |  | 5 | FDM/CEBI | TS003867717 |  | 5 | CE | TS003873251
 |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  | 10 | CE | TS003863764 |  |  |  |  |  |  |  | first
Larrel | 8-5 |  | 0 | 0 | 0 | 0 |  | X | 0 | 0 |  |  |  | X | 0 | 0 | X |  | 12 | XT | TS003853786 |  |  | 10 | LDAP | TS003858088 |  | 9 | CE | TS003863341 |  | 17 | CE | TS003864506 |  | 6 | CE | TS003873321
 |  |  |  |  |  |  | backup |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | CE | TS003865146 |  | 24 | CE | TS003870278 |  |  |  | MDTO - PM
Ruben | 5:30-2:30 |  | X | X | 0 | 0 |  | X | X | 0 |  |  |  | 0 | 0 | 0 | 0 |  | 9 | CFSIS | TS003853276 | S1/S |  | 2 | CE | TS003856385 |  | 2 | CE | TS003860039 |  | 1 | CE | TS003865547 |  | 1 | CE | TS003872902
 |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  | 12 | CFSIS | TS003858614 |  | 13 | CE | TS003864296 |  | 19 | CE | TS003870077
[NAME] | 8-5 |  | 0 | 0 | 0 | 0 |  | X | 0 | 0 |  |  |  | X | 0 | 0 | 0 |  | 15 | CE | TS003854239 |  |  | 15 | CE | TS003816884 |  |  |  |  |  | 6 | CE | TS003868099 |  | 8 | CE | TS003873757
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  | 20 | CE | TS003870151
[NAME] | 7-4 |  | X | 0 | X | 0 |  | X | 0 | 0 |  |  |  | 0 | X | 0 | 0 |  | 10 | Container | TS003853087 |  |  | 4 | Container | TS003855368 |  |  |  |  |  | 4 | CE | TS003867655
 |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  | 14 | Container | TS003854129 |  |  |  |  | N/A |  |  |  | Container only |  | 10 | Container | TS003868552 |  |  |  | Container only
Pak | 6-3 |  | X | 0 | X | 0 |  | X | X | 0 |  |  |  | 0 | X | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | CE | TS003865561 |  | 10 | CE | TS003873923
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  | N/A
[NAME] | 830-530 |  | 0 | 0 | 0 | X |  | X | 0 | X |  |  |  | 0 | 0 | 0 | 0 |  | 16 | CE | TS003853756 |  |  | 16 | Container | TS003858781 |  | 7 | CFSICI | TS003863200 |  | 16 | CE | TS003869504 |  | 14 | CE | TS003874125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | CE | TS003864347 |  | 20 | CE | TS003869586
[NAME] | 530-230 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 |  | 2 | CE | TS003851370 |  |  | 5 | CE | TS003856896 |  | 3 | CE | TS003860086 |  | 3 | CE | TS003865338 | S | 3 | CE | TS003872415
 |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | next |  |  |  |  |  |  | 15 | CE | TS003864472 |  | 14 | FDM/CEBI | TS003864465
Sharlya | 730-430 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | X | 0 | 0 |  | 3 | CE | TS003851791 |  |  | 8 | CE | TS003857955 |  | 11 | CE | TS003863452 |  | 8 | CE | TS003868330 |  | #15 | CE | TS003874615
 |  |  |  |  |  |  | backup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | CE | TS003859356 |  | 16 | CE | TS003864465 |  | 21 | CE | TS003870196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | first
[NAME] | 8-5 |  | X | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | X | 0 | 0 | 0 | 0 |  | 5 | CE | TS003852691 | S |  | 9 | CE | TS003858206 |  | 4 | CE | TS003862133 |  | 9 | CE | TS003868103 | S1 | 16 | CE | TS003874708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | XT | TS003859391 |  | 17 | CE | TS003864521 |  | 22 | CE | TS003870068
For BPM Case assignments - where ever you left off the day before start with the next SME to assign, just like we do for CPE
 |  | BPM
[NAME] | 9:00 -6:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BPM | TS003852597 |  |  | 6 | BPM | TS003857806 |  | 8 | BPM | TS003863150 |  | 13 | BPM | TS003869289 |  | 13 | BPM | TS003874118
 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | BPM | TS003851182 |  |  | 17 | BPM | TS003858702 |  |  |  | Next
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First
[NAME] | 9:00 -6:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | BPM | TS003852881 | S |  | 7 | BPM | TS003857559 |  | 9 | BPM | TS003863359 |  | 18 | BPM | TS003870068
 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | BPM | TS003859521 | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | first
[NAME] | 10:00 -7:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | BPM | TS003858934 | s | 5 | BPM | TS003862414 |  |  |  |  |  | 4 | BPM | TS003873208
 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MDTO |  |  |  |  | next |  | 18 | BPM | TS003864756
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First
We want ALL container cases to go to [NAME], [NAME] and Neeraja.
Sharlya and Larrel are backup for both [NAME] and Greg
Hosted
CE
Container
AE
XT
CSE
CSS
API
SP
CFSICI
CMOD
CFSIS
RE
DB
CMIS
Collab
DAEJ
LDAP
FDM/CEBI
Storage
FSM
BPM
N/A
 | Total container cases received | 7