Spreadsheet: 889307d1740068746-filtering-out-calls-which-were-outside-office-hours-gouldinho83-scheme-alarm-calls-sample
Sheet: Sheet1

Column5 | Date/Time | Column1 | Type | In/Out | Alarm Desc. | Alarm Code | Person | Column2 | Column3 | Column6 | Column4 | Terminal | Call Reason | Client Area | Office Hours?
 | 2025-01-31 00:00:00 | 15:00:00 | Alarm | In | Door sensor - Front door - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5014 | [NAME] | SCHEME |  | Office Hours Calls
 | 2025-01-31 00:00:00 | 23:00:00 | Alarm | In | Door sensor - Front door - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5009 | Carer On Site | SCHEME |  | Out of Hours Calls
 | 2025-01-30 00:00:00 | 1900-01-01 07:00:00 | Alarm | In | Personal trigger 1 - No location | 019 | Client |  |  |  |  | 5014 | Carer On Site | SCHEME
 | 2025-01-30 00:00:00 | 1900-01-01 15:00:00 | Alarm | In | Personal trigger 1 - No location | 019 | Client |  |  |  |  | 5009 | No Speech | SCHEME
 | 2025-01-29 00:00:00 | 1900-01-01 23:00:00 | Voice | Out |  |  | Client |  |  |  |  | 5009 | Telephone Client | SCHEME
 | 2025-01-29 00:00:00 | 1900-01-02 07:00:00 | Manual | None |  |  | Client |  |  |  |  | 5014 | Other - State in Notes | SCHEME
 | 2025-01-28 00:00:00 | 1900-01-02 15:00:00 | Alarm | In | Pull cord / [NAME] | 2 | Client |  |  |  |  | 5014 | [NAME] (S) | SCHEME
 | 2025-01-28 00:00:00 | 1900-01-02 23:00:00 | Manual | None |  |  | Client |  |  |  |  | 5013 | [NAME] (Manual) (S) | SCHEME
 | 2025-01-27 00:00:00 | 1900-01-03 07:00:00 | Alarm | In | Personal trigger 1 - No location | 019 | Client |  |  |  |  | 5013 | No Speech | SCHEME
 | 2025-01-27 00:00:00 | 1900-01-03 15:00:00 | Alarm | In | Fixed trigger 1 - No location | 010 | Client |  |  |  |  | 5009 | Carer required | SCHEME
 | 2025-01-26 00:00:00 | 1900-01-03 23:00:00 | Alarm | Out |  |  | Client |  |  |  |  | 5013 | Concern for Welfare | SCHEME
 | 2025-01-26 00:00:00 | 1900-01-04 07:00:00 | Voice | Out |  |  | Client |  |  |  |  | 5013 | Telecare Officer | SCHEME
 | 2025-01-25 00:00:00 | 1900-01-04 15:00:00 | Alarm | In | Pull cord / [NAME] | 2 | Client |  |  |  |  | 5013 | Fallen | SCHEME
 | 2025-01-25 00:00:00 | 1900-01-04 23:00:00 | Alarm | In | Fall trig/detector - Unknown - Alarm (automatic) | 0005000 | Client |  |  |  |  | 5013 | [NAME] | SCHEME
 | 2025-01-24 00:00:00 | 1900-01-05 07:00:00 | Alarm | In | Fixed trigger 1 - No location | 010 | Client |  |  |  |  | 5020 | [NAME] | SCHEME
 | 2025-01-24 00:00:00 | 1900-01-05 15:00:00 | Alarm | In | Pers trig/pendant - Unknown - Alarm (manual) | 0003000 | Client |  |  |  |  | 5013 | Carer required | SCHEME
 | 2025-01-23 00:00:00 | 1900-01-05 23:00:00 | Voice | Out |  |  | Client |  |  |  |  | 5009 | Telephone Client | SCHEME
 | 2025-01-23 00:00:00 | 1900-01-06 07:00:00 | Alarm | In | Fall trig/detector - Unknown - Alarm (automatic) | 0005000 | Client |  |  |  |  | 5009 | No Speech | SCHEME
 | 2025-01-22 00:00:00 | 1900-01-06 15:00:00 | Alarm | In | Personal trigger 1 - No location | 019 | Client |  |  |  |  | 5009 | No Speech | SCHEME
 | 2025-01-22 00:00:00 | 1900-01-06 23:00:00 | Alarm | In | Door sensor - Unknown - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5013 | Carer On Site | SCHEME
 | 2025-01-21 00:00:00 | 1900-01-07 07:00:00 | Alarm | In | Door sensor - Unknown - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5009 | [NAME] | SCHEME
 | 2025-01-21 00:00:00 | 1900-01-07 15:00:00 | Alarm | In | Pers trig/pendant - Unknown - Alarm (manual) | 0003000 | Client |  |  |  |  | 5020 | Carer required | SCHEME
 | 2025-01-20 00:00:00 | 1900-01-07 23:00:00 | Alarm | In | Door sensor - Unknown - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5013 | Carer On Site | SCHEME
 | 2025-01-20 00:00:00 | 1900-01-08 07:00:00 | Alarm | In | Pers trig/pendant - Unknown - Alarm (manual) | 0003000 | Client |  |  |  |  | 5020 | [NAME] | SCHEME
 | 2025-01-19 00:00:00 | 1900-01-08 15:00:00 | Alarm | In | Personal trigger 1 - No location | 019 | Client |  |  |  |  | 5009 | Carer On Site | SCHEME
 | 2025-01-19 00:00:00 | 1900-01-08 23:00:00 | Alarm | In | Property exit 1 - No location | 030 | Client |  |  |  |  | 5009 | Carer On Site | SCHEME
 | 2025-01-19 00:00:00 | 1900-01-09 07:00:00 | Alarm | In | Door sensor - Unknown - Alarm (automatic) | 0014000 | Client |  |  |  |  | 5013 | [NAME] | SCHEME
 | 2025-01-18 00:00:00 | 1900-01-09 15:00:00 | Voice | Out |  |  | Client |  |  |  |  | 5013 | Welfare Check | TELECARE SCHEME (HEALTH)
 | 2025-01-18 00:00:00 | 1900-01-09 23:00:00 | Alarm | In | Pull cord / [NAME] | 2 | Client |  |  |  |  | 5013 | Waiting For Carers | SCHEME
 | 2025-01-17 00:00:00 | 1900-01-10 07:00:00 | Alarm | In | Radio Trig/Low batt | 5 | Client |  |  |  |  | 5013 | Equipment Fault | SCHEME
 | 2025-01-17 00:00:00 | 1900-01-10 15:00:00 | Alarm | In | Radio Trig/Low batt | 5 | Client |  |  |  |  | 5013 | Equipment Fault | SCHEME