Spreadsheet: 809042d1670856990-looking-up-two-cells-to-find-result-in-another-cell-match-and-index-example-rota-and-appt-number-planning-for-13th-december-meeting
Sheet: Sheet1

 |  |  | WEEK 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes/Changes
 |  |  |  | Room | AMC - ROOM 1 | AMC - ROOM 2 | AMC - ROOM 3 | AMC - ROOM 4 | AMC - ROOM 5 | AMC - ROOM 6 | AMC - ROOM 7 | AMC - ROOM 8 (minor ops) | AMC - ROOM 9 (treatment rm) | AMC - GoTo RECEPTION | AMC - GoTo RECEPTION 2 | AMC - ROOM 10 HOT ROOM | E-consult Desk | HOME | HOME | CP - ROOM 1 | CP - ROOM 2 | CP - ROOM 3 | CP - ROOM 4 | CP - TR | CP - R | CP - ECG
 | Monday
WK 1 |  | 2022-12-05 00:00:00 | AM | Name |  | SL | EB |  |  |  |  |  |  | RP | AW |  |  |  |  |  |  | TM | ZS
 |  |  |  | Shift |  | [NAME] | S/D ACP |  |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  | ACP Green | RED BLOODS
 |  |  | PM | Name |  |  | EB |  | BR |  |  |  |  | RP | SL |  | AW |  |  |  |  | TM | ZS
 |  |  |  | Shift |  |  | S/D ACP |  | S/D GP |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP |  |  |  |  | S/D ACP | E Consults |  |  |  | Move BR back to AMC in the afternoon - more likely to be filled
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | RP
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only)
 | Tuesday |  | AM | Name |  | SL | J Wadey |  |  |  |  | RP |  | MH | TM |  |  | AW | JM |  |  | EB | YM
 |  |  |  | Shift |  | S/D ACP | [NAME] |  |  |  |  | Microsuction |  | Go2GP | SIGNPOSTING & Results |  |  | NH WR | PCN |  |  | REPORTS | RED BLOODS |  |  |  | MH to be Go2GP all day
 |  |  | PM | Name |  |  | TM | RP |  |  |  |  |  | MH | SL |  | J Wadey | AW | JM |  |  | EB | YM |  |  |  | [NAME] to move back to Coppice to do Imms
 |  |  |  | Shift |  |  | S/D ACP | S/D GP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP | NH WR | [NAME] |  |  | Hyper | E Consults
 |  |  |  | Jobs |  |  | TM |  |  |  |  |  |  | YM
 |  |  |  | Jobs |  |  | Extended Access |  |  |  |  |  |  | Extended Access
 | Wednesday |  | AM | Name | J Wadey | ZS |  | TM |  |  | AW | JM or MH | MC | BR | EB |  |  |  |  |  |  |  | JM or MH
 |  |  |  | Shift | [NAME] | [NAME] |  | S/D ACP |  |  | [NAME] | Minor Ops Clinic | Minor Ops Clinic | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  |  | RED BLOODS |  |  |  | Alternate S/D GP with LTC for Zoe in the afternoon? So that JM can do some greens?
 |  |  | PM | Name | JM | ZS or MH | EB | J Wadey |  |  |  |  |  | BR | AW |  | TM |  |  |  |  |  | JM or MH |  |  |  | Or, Alternate JM and S/D GP with MH at Coppice?
 |  |  |  | Shift | S/D GP | [NAME] | ACP Green | S/D ACP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP |  |  |  |  |  | E Consults |  |  |  | Who do to urines at Coppice? Can a nurse do instead?
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | JM | AW |  | TM
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access | Extended Access |  | Extended Access
 | Thursday |  | AM | Name |  | SL |  |  | MH |  | AW |  |  | ZS | TM | J Wadey |  | JM |  | Social Prescribers |  |  | RP
 |  |  |  | Shift |  | [NAME] |  |  | Practice [NAME] |  | [NAME] |  |  | Go2GP | SIGNPOSTING & Results | S/D ACP |  | Practice [NAME] |  |  |  |  | RED BLOODS
 |  |  | PM | Name |  | SL |  |  | MH |  | AW |  |  | ZS | AW | J Wadey | TM |  |  | Social Prescribers |  |  | RP
 |  |  |  | Shift |  | HV ACP |  |  | S/D GP |  | S/D ACP |  |  | Go2GP | SIGNPOSTING & Results | ADHD | [NAME] |  |  |  |  |  | E Consults
 |  |  |  | Jobs |  |  | ?? |  | MH
 |  |  |  | Jobs |  |  | Extended Access |  | Extended Access
 | Friday |  | AM | Name |  | SL | J Wadey | YM |  |  |  |  |  | JM | TM |  |  |  |  |  |  |  | ZS
 |  |  |  | Shift |  | S/D ACP | [NAME] | GP Green |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  |  |  |  |  |  |  | RED BLOODS
 |  |  | PM | Name |  | SL |  | YM |  |  |  |  |  | JM | TM |  | J Wadey | MH | RP |  |  |  | ZS
 |  |  |  | Shift |  | S/D ACP |  | S/D GP |  |  |  |  |  | Go2GP | SIGNPOSTING & Results |  | HV ACP | [NAME] | [NAME] |  |  |  | E Consults
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  |  |  |  |  |  |  |  | Check Defib/Oxygen | [NAME]
 |  |  |  | Jobs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Defib/Oxygen | [NAME]
 | Saturday |  | AM | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACP |  |  | Partner
 |  |  |  | Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  | Extended Access ([NAME] only)
 |  |  | PM | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACP |  |  | Partner
 |  |  |  | Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extended Access ([NAME] only) |  |  | Extended Access ([NAME] only)
 |  |  |  | Jobs
 |  |  |  | Jobs
 | Appointment Type | Session Type Used | JM | MH | RP | YM | BR | ZS | AW | SL | EB | TM | J Wadey | JK | AD | RR | CM | MC | SOC | LL | Total Appts
 | Same Day Appt | S/D GP
 | Medical Reports/Baby Checks | RED BLOODS
 | Same Day Appt | S/D ACP
 | [NAME] | [NAME]
 | [NAME] | ACP Green
 | Red Bloods | RED BLOODS
 | E-Consults | E Consults
 | Dressings | DRESSINGS - AM
 | Dressings | DRESSINGS - PM
 | Bloods | Bloods Clinic
 | B12 | Bloods Clinic
 | ABPM | Bloods Clinic
 | DM1 | Bloods Clinic
 | HRT | Nurse Session - AM
 | Ear Checks | Nurse Session - PM
 | General [NAME] | Nurse Session - PM
 | [NAME] | [NAME]
 | DM2 | Nurse DM Clinic - AM
 | DM2 | Nurse DM Clinic - PM
 | [NAME] | ADHD
 | [NAME] | GP Green
 | Smears | Smears
 | Imms | Imms
 | Mental Health - SMI | Mental Health
 | HCA | HCA Session
 | NHS Health Checks | NHS HEALTH CHECKS
 | Home Visits | HV ACP
 | Nursing Home Ward Rounds | NH WR
 | Asthma | Asthma Clinic