Reported Date | Day of the Week | SDT Number | Machine Type | Serial Number | Reported Fault | Status | Action Taken | Call Out Response Date | Call Out Response Time | Job Completion Date/Time | Machine Down Time | Engineer | Area | Reason for unit still OOS | Additional info | SLA | SLA MET/NOT MET |
21/10/2018 22:43 | Sunday | SDT23578 | Ionscan 400B | 31207 | Unable to verify | Not complete | Verific but wont print out | 22/10/2018 15:30 | 16:47:00 | 31/10/2018 23:59 | 241:16:59 | Neil Redmond | T2 lane 8 | Parts required | comms board | 0 | |
22/10/2018 03:56 | Monday | SDT23641 | Ionscan 400B | 12513 | Unable to verify | Not complete | Slide tray damaged | 22/10/2018 16:00 | 12:04:00 | 31/10/2018 23:59 | 236:03:59 | Neil Redmond | T2 Staff | Parts required | New slide tray | 0 | |
22/10/2018 13:49 | Monday | SDT23646 | Ionscan 400B | 12515 | Unable to verify | Complete | Sample inlet and APT reset | 23/10/2018 11:45 | 21:56:00 | 23/10/2018 12:14 | 22:25:00 | Neil Redmond | T1 Lane 8 | N/A | BIS | 1 | |
23/10/2018 07:36 | Tuesday | SDT23659 | Ionscan 400B | 25609 | Unable to verify | Complete | Sample inlet and APT reset | 23/10/2018 12:30 | 4:54:00 | 23/10/2018 12:45 | 5:09:00 | Neil Redmond | T1 Bravo Lane 18 | N/A | BIS | 1 | |
22/10/2018 23:48 | Monday | SDT23658 | Ionscan 400B | 33098 | Unable to verify | Complete | Sample inlet and APT reset | 23/10/2018 15:00 | 15:12:00 | 23/10/2018 15:20 | 15:32:00 | Neil Redmond | T2 Lane 8 | N/A | BIS | 1 | |
30/10/2018 00:05 | Tuesday | SDT23679 | Ionscan 400B | 33098 | Calibrant not stable | Complete | APT reset & Ref peak adjust | 30/10/2018 16:15 | 16:10:00 | 30/10/2018 17:15 | 17:10:00 | Neil Redmond | T2 Lane 6 | N/A | BIS | 1 | |
31/10/2018 10:54 | Wednesday | SDT23730 | Ionscan 400B | 31207 | Loose slide tray assembly | Complete | Refitted slide tray assembly | 31/10/2018 12:00 | 1:06:00 | 31/10/2018 12:30 | 1:36:00 | Neil Redmond | T2 Lane 6 | N/A | BIS | 1 | |
26/10/2018 22:47 | Friday | SDT23695 | Ionscan 400B | 25609 | Unable to verify | Complete | Sample inlet and APT reset | 31/10/2018 14:15 | 111:28:00 | 31/10/2018 14:45 | 111:58:00 | Neil Redmond | T1 Bravo Lane 18 | N/A | BIS | 4 | |
30/10/2018 05:17 | Tuesday | SDT23720 | Ionscan 400B | 32549 | False activations | Complete | Clean and condenser filter | 02/11/2018 09:00 | 75:43:00 | 02/11/2018 10:30 | 77:13:00 | Neil Redmond | T3 Service yard | N/A | BIS | 4 |
<colgroup><col span="2"><col><col span="2"><col><col><col span="11"></colgroup><tbody>
</tbody>
Ok I need help as i am not good with excel!!
I need a sla met/not met to match the following criteria :
Reported Date needs to be attended within 24hrs, but excludes weekends- We only work between hrs 07:30 - 17:00
Help!!