Spreadsheet: 812990d1673481417-formula-to-pull-in-an-adjacent-cell-if-one-cell-matches-another-master-schedule-need-help-elective-online
Sheet: Blank year template 6 residents

 | XXXX-XXXX Academic Rotation Schedule
 | Start Date
PGY1 | BLOCK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Rotation Start Date
Replace these with names | 1A | Orient/FM-OP | PED-OP | FM-IM | OB | ORTHO/SM | FM-IM | FM-IP | swing FMIM | NICU | PSYCH | RAD | [NAME] | SURG
 | 1B | Orient/FM-OP | [NAME] | ORTHO/SM | FM-IM | OB | PED-OP | FM-IM | FM-IP | [NAME] | swing FMIM | PSYCH | SURG | NICU
 | 1C | Orient/FM-OP | FM-IM | [NAME] | SURG | RAD | ORTHO/SM | OB | PED-OP | FM-IM | FM-IP | NICU | swing FMIM | PSYCH
 | 1E | Orient/FM-OP | RAD | FM-IM | [NAME] | SURG | OB | PED-OP | FM-IM | FM-IP | NICU | swing FMIM | PSYCH | ORTHO/SM
 | 1F | Orient/FM-OP | ORTHO/SM | PED-OP | FM-IM | FM-IP | SURG | RAD | OB | PSYCH | FM-IM | Derm | NICU | swing FMIM
 | 1G | Orient/FM-OP | FM-IM | RAD | PED-OP | PSYCH | FM-IP | FM-IM | NICU | swing FMIM | OB | SURG | ORTHO/SM | Derm
PGY2 | BLOCK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Rotation Start Date
Replace these with names | 2A | UC/Comm | Elect | swing FMIM | Ophth/ENT | Hospice/LC | FM-OP | EM 2 | Elect | FM-IM | Geri/Gyn | PH/HSM | FM-IM | OB
 | 2B | Ophth/ENT | EM 2 | FM-IM | UC/Comm | FM-OP | swing FMIM | Hospice/LC | Geri/Gyn | OB | Elect | HSM/PH | Elect | FM-IM
 | 2C | FM-IM | FM-OP | EM 2 | Elect | swing FMIM | Ophth/ENT | LC/Hospice | FM-IM | HSM/PH | Elect | OB | Geri/Gyn | UC/Comm
 | 2D | EM | OB | FM-OP | swing FMIM | Elect | FM-IM | Ophth/ENT | Elect | LC/Hospice | FM-IM | UC/Comm | HSM/PH | Geri/Gyn
 | 2E | FM-OP | swing FMIM | OB | Comm/UC | FM-IM | EM 2 | Elect | LC/Hospice | Geri/Gyn | PH/HSM | FM-IM | Ophth/ENT | Elect
 | 2F | OB | FM-IM | ENT/Ophth | FM-OP | LC/Hospice | Elect | swing FMIM | PH/HSM | UC/Comm | EM 2 | Geri/Gyn | Elect | FM-IM
PGY3 | BLOCK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Rotation Start Date
Replace these with names | 3A | Ped-OP | Geri/Gyn | Cardio/GI | [NAME]/Uro | Elect | FM-IM | FM-OP | EM 3 | ORTHO/SM | HemeOnc/LC | Elect | FM-IM | FM-OP
 | 3B | Geri/Gyn | Cardio/GI | EM 3 | Elect | FM-IM | FM-OP | ORTHO/SM | HemeOnc/LC | Ped-OP | Elect | FM-IM | FM-OP | Uro/Neuro
 | 3C | EM | HemeOnc/LC | Geri/Gyn | FM-IM | FM-OP | Elective | Cardio/GI | Ortho/SM | Elect | FM-IM | FM-OP | Uro/Neuro | Ped-OP
 | 3D | ORTHO/SM | Elective | FM-IM | FM-OP | HemeOnc/LC | Geri/Gyn | [NAME]/Uro | Elect | FM-IM | FM-OP | Ped-OP | EM 3 | Cardio/GI
 | 3E | E - cardio | FM-IM | FM-OP | ORTHO/SM | Geri/Gyn | HemeOnc/LC | Elect | FM-IM | FM-OP | EM 3 | Cardio/GI | Ped-OP | [NAME]/Uro
 | 3F | FM-IM | FM-OP | HemeOnc/LC | Geri/Gyn | EM 3 | Elect | FM-IM | FM-OP | Cardio/GI | Ped-OP | ORTHO/SM | [NAME]/Uro | Elect
 | Back Up Schedule
 | 1st ABC
 | 1st DEF
 | 2nd ABD
 | 2nd DEF
 | FM OB Continuity Clinic & On-call Schedule |  |  |  |  |  | Residents:
 | Block | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Rotation Start Date
 | Resident | OB | OB | OB | OB | OB | OB | OB | OB | OB | OB | OB | OB | OB
 | Backup resident
 |  | Residents | First call # | Cell phone |  | Faculty | Cell phone |  | Notes:
 |  |  | [PHONE] |  |  | [NAME] | [PHONE] |  | Avoid:  IM, EM, FM-OP, OB only if swap clinic day
 |  |  | [PHONE] |  |  |  |  |  | For backup, try to rotate on-call resident from prior month for continuity
 |  |  | [PHONE]
 |  |  | [PHONE]