Spreadsheet: 757694d1638403835-conditional-formatting-rules-manager-locking-workbook-cf-error-example-tms
Sheet: Handover

Status | Client Caller | Client | Caller | Location | Building or  Address | Town or  City | First  Notified | Right  Now | Ref | 1st [NAME] Ticket | Later Ncall Tickets (not noted elsewhere) | Client Platform | [NAME] | Issue Type and  Description | Issue Type | Short Description | Client Priority | Current Priority | Contractor Status | Contractor Status2 | Contractor  Name | Contractor  Phone | News | Latest / Next / Last | Last   Review
Closed |  | Xenia Estates | Adel |  | [NAME] 2 | Salford | 2021-11-26 21:34:00 | [NAME] |  | 38410 | 38438, 38441, 38446 | 159123 | 2426 |  | Doors & Windows | Door fallen off | Emer-gency | Non-Urgent |  | CCR done | SCPM |  | No | One entry door panel has fallen off. Open doorway to be boarded up. Attended and completed. Photos received from SCPM. | 2021-11-28 06:35:00
Open |  | Student Cribs | [NAME] |  | 123 Madeup Street | Newcastle | 2021-11-26 20:35:00 | Pending |  | 38412 | 38426, 38443, 38445 |  | 2424 |  | Leak (Into) | Kitchen power tripped | Emer-gency | Non-Urgent |  | Arranged | SCPM |  | No | Leak manifesting in kitchen has tripped the power. Contractor scheduled to attend Sunday, between 09:00 and 10:00. Not heard from SCPM to confirm, nor from tenants that they didn't … which would be expected. | 2021-11-29 03:44:00
Open |  | [NAME] | [NAME] |  | 123 Madeup Street | Sunderland | 2021-11-27 12:29:00 | Pending |  | 38579 |  |  | 2425 |  | Doors & Windows | Fabric Repair | Urgent (ND) | Non-Urgent |  | Arranged | SCPM |  | No | 3 balcony doors to be boarded up. SCPM scheduled to attend 28/11 at c. 09:30 - 10:00. Not heard from SCPM to confirm, nor from tenants that they didn't … which would be expected. | 2021-11-29 03:42:00
Open |  | Xenia Estates | A Doe |  | Bridgewater Gate | Salford | 2021-11-27 20:59:00 | Pending |  | 38759 |  |  | 2428 |  | Gates & Barriers | Gates & Barriers | Emer-gency | NFA |  | Arranged | SCPM |  | Updated | No response from client as to who to use. SCPM appointed to attend this morning (28/11). Attendance not confirmed. Shane now in Cyprus! No further calls from site so reasonable to assume actually dealt with. | 2021-11-29 03:28:00
Closed |  | Xenia Lettings | [NAME] |  | Avalon Court | [NAME] | 2021-11-28 06:01:00 | [NAME] |  | 38773 |  |  | 0 |  | Keys & Locks | Lockout | Urgent (ND) | NFA |  | CCR done | Magpie Security |  | No | locked out. Magpie attended. Not followed up, as no call to chase their attendance received. | 2021-11-29 04:50:00
Open |  | [NAME] | Charlotte (?) |  | [NAME] | [NAME] | 2021-11-28 08:48:00 | Action |  | 38782 |  |  | 0 |  | Keys & Locks | Front door insecure | Emer-gency | Urgent (ND) |  | Client 2 Arrange |  |  | No | Front door will not lock, requires locksmith attendance. All comms to go through tenant's sister please. Not resolved by Sunday day team. Needs actioning tomorrow. Unsure if client has been made aware of this. | 2021-11-29 06:51:00
Open |  | Aberdeen PM | Bartholomew |  | 33 [NAME] | Aberdeen | 2021-11-28 22:40:00 | Action |  | 38870 | 38949 |  | 0 |  | No HW, No Heating | Boiler issue | Emer-gency | Urgent (ND) |  | Client 2 Arrange |  |  | No | No hot water or heating. RVA'd. H/w and heat seem to be restored but now over pressure. Requires further investigation. Maintenance form completed. | 2021-11-29 06:51:00
Open |  | [NAME] | [NAME] |  | High Street West | Sunderland | 2021-11-28 21:15:00 | Pending |  | 38940 | 38942, 38945, 38950 |  | 0 |  | Power Out (Full) | External fault (?) | Emer-gency | Emer-gency |  | N/A |  |  | No | Needs key to access meter cupboard in 220. Needs Potts Gray Block Management, [PHONE] or 07815 158414. Left message on mobile for a call back. Details passed to caller. However, power co. website now shows outage again. Caller to monitor and call us again if further assistance is required. | 2021-11-28 22:46:00
Open |  | Lennon Properties | Caroline I_think |  | 16 Cowpen Road | Blyth | 2021-11-28 21:20:00 | Pending |  | 38941 | 38952 |  | 0 |  | Leak (Into) | [NAME] leak worsening | Urgent (ND) | Urgent (ND) |  | Client 2 Arrange |  |  | No | [NAME] leak now dripping through loft onto beds. RVA needed. Called but no answer. Text sent to call us again to set up, or contact office in the morning. | 2021-11-29 02:52:00
Open |  | Xenia Lettings | [NAME] |  | Bard House | [NAME] | 2021-11-28 21:54:00 | Pending |  | 38943 |  |  | 0 |  | Power Issue | Light flashing | Urgent (ND) | Urgent (ND) |  | Client 2 Arrange |  |  | No | Room 116 07443 649580 Main light flashing. Probably a faulty light. Needed RVA. Text sent,requesting call back to do this, or report via portal / see site team | 2021-11-29 03:00:00
Open |  | Student Cribs | [NAME] |  | Somewhere in | Portsmouth | 2021-11-28 21:59:00 | Pending |  | 38944 |  |  | 159382 |  | Power Out (Full) | Unknown Cause | Emer-gency | Urgent (ND) |  | Client 2 Arrange |  |  | No | . Txt sent to call us if RVA tonight, but that it has also been logged as an urgent issue for the daytime team to action tomorrow. | 2021-11-29 03:40:00
Closed |  | Xenia Lettings | [NAME] |  | Avalon Court | [NAME] | 2021-11-28 22:32:00 | [NAME] |  | 38947 |  |  | 0 |  | Keys & Locks | Lockout | Urgent (ND) | NFA |  | CCR done | Magpie Security |  | No | [NAME] | 2021-11-29 05:53:00
Open |  | Amana Lettings | [NAME] |  | 237 Walthall Street | Crewe | 2021-11-28 23:24:00 | Action |  | 38954 |  |  | 0 |  | Power Out (Partial) | Unknown Cause | Emer-gency | Urgent (NWD) |  | Client 2 Arrange |  |  | No | Power outage / fire alarm ?  Fire alarm fault attended but seems to have reoccurred. Separately (?) power outage in the kitchen. Not sockets. [NAME]? Washer? Requires investigation. | 2021-11-29 03:00:00
Open |  | Student Cribs | Robyn Kane |  | Somewhere in | [NAME] | 2021-11-28 23:15:00 | Action |  | 38953 | 38957 |  | 159385 |  | Keys & Locks | Front door insecure | Emer-gency | Emer-gency |  | Client 2 Arrange |  |  | No | New door won't lock or remain shut. RVA'd. [NAME] required.  No success with KeyTek, [NAME], [NAME] 4U. | 2021-11-29 03:00:00
Open |  | [NAME] | [NAME] |  | No Idea | Where |  | Action |  |  |  |  | 0 |  | No HW, No Heating | Not known | Emer-gency | Emer-gency |  | Client 2 Arrange |  |  | No | No action taken since Saturday evening handover
Open |  | Student Cribs | [NAME] |  | No Idea | Where |  | Action |  |  |  |  | 159371 |  | No HW, No Heating | Not known | Emer-gency | Emer-gency |  | Client 2 Arrange |  |  | No | No action taken since Saturday evening handover