Spreadsheet: 723172d1615551551-formula-to-alter-calculation-dependant-on-drop-down-list-value-peters-version-of-tim-recording-sheet-modbyjt
Sheet: Codes

Code | Description
C1 | Admission patients |  | 06:00 - 06:59 | 6 | WEEK 1 | Monday
C2 | Arrange for tests/procedures e.g. x-rays |  | 07:00 - 07:59 | 7 | WEEK 2 | Tuesday |  | C1 | Admission patients |  | P1 | Book appointments on PAS – Consultant |  | K1 | Appointments |  | N1 | Meeting – minutes/agendas |  | T1 | Answer machine – Playback messages |  | M1 | Circulars – records, distribute, file |  | L1 | Audit of clinic attendances |  | X1 | Annual Leave
[NAME] | Clinic list duties |  | 08:00 - 08:59 | 8 |  | Wednesday |  | C2 | Arrange for tests/procedures e.g. x-rays |  | P2 | Book appointments on PAS – other |  | K2 | Discharges/EDS Perusal sheets |  | N2 | Meeting - other notes |  | T2 | Answer machine – Deal with messages |  | M2 | Computer - power up/down at ends of day |  | L2 | Cancel Clinic |  | X2 | Break - Meal break
C4 | Day case diary list |  | 09:00 - 09:59 | 9 |  | Thursday |  | [NAME] | Clinic list duties |  | P3 | Check queries on PAS for other staff |  | K3 | Patient - letters |  | N3 | Other |  | T3 | Incoming calls – patients |  | M3 | Diaries update |  | L3 | Close Clinic |  | X3 | Break - Tea/Coffee break
C5 | Discussions with patients/carers |  | 10:00 - 10:59 | 10 |  | Friday |  | C4 | Day case diary list |  | P4 | Day Case Admissions onto PAS |  | K4 | Patient - file notes |  | N4 | Legal reports and investigations |  | T4 | Incoming calls – professional |  | M4 | Interruptions – professional/work based |  | [NAME] | Rearrange Clinic |  | X4 | Personal needs
C6 | Fax GPs copies |  | 11:00 - 11:59 | 11 |  |  |  | C5 | Discussions with patients/carers |  | P5 | Update PAS/new details |  | K5 | Patient - other |  |  |  |  | T5 | Incoming calls – contact centre/other hospital |  | M5 | Interruptions – other |  | L5 | Handling queries |  | X5 | Sickness absence
C7 | Give/receive instructions |  | 12:00 - 12:59 | 12 |  |  |  | C6 | Fax GPs copies |  | P6 | Print Clinics/Telephone clinics & Numbers |  | K6 | Waiting Lists |  |  |  |  | T6 | Outgoing calls – patient |  | M6 | Maintain equipment e.g. |  | L6 | Order Supplies |  | X6 | Study leave
C8 | Handling patient queries |  | 13:00 - 13:59 | 13 |  |  |  | C7 | Give/receive instructions |  | P7 | HOPAs |  | K7 | Document Manager work |  |  |  |  | T7 | Outgoing calls – professional |  | M7 | Meetings – organise & arrange |  | L7 | Contract figures |  | X7 | Other absence
C9 | Liaise with OPD |  | 14:00 - 14:59 | 14 |  |  |  | C8 | Handling patient queries |  | P8 | Patient information |  |  |  |  |  |  |  | T8 | Outgoing calls – contact centre/other hospital |  | M8 | Meetings – prepare notes |  | L8 | Theatre lists
C10 | Liaise with staff re patient arrival, etc |  | 15:00 - 15:59 | 15 |  |  |  | C9 | Liaise with OPD |  | P9 | Case note Tracking - inc  running report |  |  |  |  |  |  |  | T9 | Incoming/Outgoing – personal |  | M9 | Post – receive |  | L9 | Stat & Mandatory Training/Training
C11 | Notes - Deliver notes |  | 16:00 - 16:59 | 16 |  |  |  | C10 | Liaise with staff re patient arrival, etc |  | P10 | Adding or removing alerts |  |  |  |  |  |  |  |  |  |  | M10 | Post – sort and distribute |  | L10 | Choose & Book
C12 | Notes - Obtain notes/External notes |  | 17:00 - 17:59 | 17 |  |  |  | C11 | Notes - Deliver notes |  |  |  |  |  |  |  |  |  |  |  |  |  | M11 | Post – dispatch/FIT Test |  | L11 | Sort results (Bloods etc)
C13 | Notes - Return notes to records |  | 18:00 - 18:59 | 18 |  |  |  | C12 | Notes - Obtain notes/External notes |  |  |  |  |  |  |  |  |  |  |  |  |  | M12 | Photocopying - clinical information |  | L12 | Order stationery inc receiving and storing
C14 | Notes - Search for notes |  | 19:00 - 19:59 | 19 |  |  |  | C13 | Notes - Return notes to records |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Photocopying - non clinical information |  | [NAME] | ESR
C15 | Notes - Sort notes |  |  |  |  |  |  | C14 | Notes - Search for notes |  |  |  |  |  |  |  |  |  |  |  |  |  | M14 | Printer/fax/photocopier |  | [NAME] | Travel and Accommodation
C16 | Notes - Track notes in/out |  |  |  |  |  |  | C15 | Notes - Sort notes |  |  |  |  |  |  |  |  |  |  |  |  |  | M15 | Sort and Reply to emails |  | L15 | RTT
C17 | Prepare new files |  |  |  |  |  |  | C16 | Notes - Track notes in/out |  |  |  |  |  |  |  |  |  |  |  |  |  | M16 | IPT/Referrals/Returns |  | L16 | Rotas
C18 | Take/deliver messages |  |  |  |  |  |  | C17 | Prepare new files |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | WL proformas |  | L17 | Transfer of imaging
C19 | Walk to/from records |  |  |  |  |  |  | C18 | Take/deliver messages |  |  |  |  |  |  |  |  |  |  |  |  |  | M18 | Meetings – Attendance/Video links/etc
C20 | Endoscopies |  |  |  |  |  |  | C19 | Walk to/from records |  |  |  |  |  |  |  |  |  |  |  |  |  | M19 | Training and Supervision
C21 | Singleview/SIRIS |  |  |  |  |  |  | C20 | Endoscopies |  |  |  |  |  |  |  |  |  |  |  |  |  | M20 | External Trusts (QEH/FH/RVI/etc)
C22 | Somerset |  |  |  |  |  |  | C21 | Singleview/SIRIS |  |  |  |  |  |  |  |  |  |  |  |  |  | M21 | Training and supervision of staff
C23 | Additional Clinical Sessions |  |  |  |  |  |  | C22 | Somerset
C24 | Excelicare |  |  |  |  |  |  | C23 | Additional Clinical Sessions
C25 | Spreadsheet |  |  |  |  |  |  | C24 | Excelicare
C26 | Sapphire |  |  |  |  |  |  | C25 | Spreadsheet
C27 | MDT |  |  |  |  |  |  | C26 | Sapphire
C28 | Preassessment |  |  |  |  |  |  | C27 | MDT
C29 | Referrals |  |  |  |  |  |  | C28 | Preassessment
K1 | Appointments |  |  |  |  |  |  | C29 | Referrals
K2 | Discharges/EDS Perusal sheets
K3 | Patient - letters
K4 | Patient - file notes
K5 | Patient - other
K6 | Waiting Lists
K7 | Document Manager work
L1 | Audit of clinic attendances
L2 | Cancel Clinic
L3 | Close Clinic
[NAME] | Rearrange Clinic
L5 | Handling queries
L6 | Order Supplies
L7 | Contract figures
L8 | Theatre lists
L9 | Stat & Mandatory Training/Training
L10 | Choose & Book
L11 | Sort results (Bloods etc)
L12 | Order stationery inc receiving and storing
[NAME] | ESR
[NAME] | Travel and Accommodation
L15 | RTT
L16 | Rotas
L17 | Transfer of imaging
M1 | Circulars – records, distribute, file
M2 | Computer - power up/down at ends of day
M3 | Diaries update
M4 | Interruptions – professional/work based
M5 | Interruptions – other
M6 | Maintain equipment e.g.
M7 | Meetings – organise & arrange
M8 | Meetings – prepare notes
M9 | Post – receive
M10 | Post – sort and distribute
M11 | Post – dispatch/FIT Test
M12 | Photocopying - clinical information
[NAME] | Photocopying - non clinical information
M14 | Printer/fax/photocopier
M15 | Sort and Reply to emails
M16 | IPT/Referrals/Returns
[NAME] | WL proformas
M18 | Meetings – Attendance/Video links/etc
M19 | Training and Supervision
M20 | External Trusts (QEH/FH/RVI/etc)
M21 | Training and supervision of staff
N1 | Meeting – minutes/agendas
N2 | Meeting - other notes
N3 | Other
N4 | Legal reports and investigations
P1 | Book appointments on PAS – Consultant
P2 | Book appointments on PAS – other
P3 | Check queries on PAS for other staff
P4 | Day Case Admissions onto PAS
P5 | Update PAS/new details
P6 | Print Clinics/Telephone clinics & Numbers
P7 | HOPAs
P8 | Patient information
P9 | Case note Tracking - inc  running report
P10 | Adding or removing alerts
T1 | Answer machine – Playback messages
T2 | Answer machine – Deal with messages
T3 | Incoming calls – patients
T4 | Incoming calls – professional
T5 | Incoming calls – contact centre/other hospital
T6 | Outgoing calls – patient
T7 | Outgoing calls – professional
T8 | Outgoing calls – contact centre/other hospital
T9 | Incoming/Outgoing – personal
X1 | Annual Leave
X2 | Break - Meal break
X3 | Break - Tea/Coffee break
X4 | Personal needs
X5 | Sickness absence
X6 | Study leave
X7 | Other absence