Spreadsheet: 858473d1707150529-count-days-between-latest-and-previous-data-match-sample-3
Sheet: Sheet1

SAP Account Id | Channel | Work Order Number | Created By | Appointment Number | Serial Number | Longitude | Latitude | Work Type: Work Type Name |  |  | Travelling Start | Travelling End | Travelling Time (Minutes) | Travel Back Home Time (Minutes) | Machine Description | Machine Brand | Machine Type | Actual Start | Created Date & Time | Actual End | Status | Country | Created Date | Time On Site | [NAME] | [NAME] | Symptom AT | Symptom AT 2 | Fault Lvl 1 | Fault Lvl 2 | Action Code | Case Number | Solution CC | Status | Reason For No Intervention | Month | Created Date (Formatted) | End Date (Formatted) | Arrive Date (Formatted) | [NAME] without time | Customer E2E (Days) | Internal Response Time (wkg hrs) | Effectiveness (Days Since Last Visit) | Expected Result
 | LOCL |  |  | SA-1553 |  |  |  | UK Preventative Maintenance Low |  |  | 06/09/2022, 15:17 | 06/09/2022, 15:18 | 0.12 |  |  |  |  | 06/09/2022, 15:18 | 06/09/2022, 13:35 | 06/09/2022, 15:19 | Completed | United Kingdom | 06/09/2022 | 1 | Other Faults | New Mc Installation | Other Faults | New Mc Installation | 9 - Not Machine Fault | 364 - Machine install | 6 - Clear |  |  | Completed
 | FMSN |  |  | SA-27764 | 10237422 |  |  | UK Repair Medium |  |  | 22/03/2023, 11:49 | 22/03/2023, 11:49 | 0.1 |  |  |  |  | 22/03/2023, 11:49 | 22/03/2023, 11:48 | 22/03/2023, 12:22 | Completed | United Kingdom | 22/03/2023 | 33 |  |  | Water/Steam Failure | Machine Leaking | 5 - Hot Water System | 215 - B2C Whipper Motor | 2 - Repair | 00151953 |  | Completed
 | FMSN |  |  | SA-1175 | 10237426 |  |  | UK Repair Medium XX |  |  | 05/09/2022, 11:07 | 05/09/2022, 11:38 | 30.9 |  |  |  |  | 05/09/2022, 11:38 | 02/09/2022, 14:43 | 05/09/2022, 12:56 | Completed | United Kingdom | 02/09/2022 | 77 | Water/Steam Failure | Water Tank Empty | Mechanical Fault | Cup Splitter Issue | 2 - Product Handling | 63 - Splitter & Scrolls | 4 - Adjust | 00124510 |  | Completed
 | FMSN |  |  | SA-19095 | 10237427 |  |  | UK Client Care Low |  |  | 17/01/2023, 14:24 | 17/01/2023, 14:25 | 0.97 |  |  |  |  | 17/01/2023, 14:25 | 17/01/2023, 14:13 | 17/01/2023, 14:48 | Completed | United Kingdom | 17/01/2023 | 23 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 351 - Water/scale filter | 3 - Replace |  |  | Completed
 | FMSN |  |  | SA-22515 | 10237427 |  |  | UK Repair Medium XX |  |  | 10/02/2023, 12:56 | 10/02/2023, 13:16 | 20.72 |  |  |  |  | 10/02/2023, 13:16 | 10/02/2023, 12:23 | 10/02/2023, 14:12 | Completed | United Kingdom | 10/02/2023 | 55 | Quality Of The Dispensing | Dose More/Less Than Standard | Quality Of The Dispensing | Dose More/Less Than Standard | 9 - Not Machine Fault | 336 - Drink/product type | 4 - Adjust | 00146305 |  | Completed
 | FMSN |  |  | SA-2506 | 10237428 |  |  | UK Repair Medium XX |  |  | 14/09/2022, 08:14 | 14/09/2022, 09:33 | 79.62 |  |  |  |  | 14/09/2022, 09:33 | 13/09/2022, 13:34 | 14/09/2022, 12:16 | Completed | United Kingdom | 13/09/2022 | 163 | Mechanical Fault | Dispensing Accessories | Mechanical Fault | Dispensing Accessories | 2 - Product Handling | 61 - B2C Dispense Arm | 3 - Replace | 00125552 |  | Completed
 | LOCL |  |  | SA-10915 | 10237431 |  |  | UK Client Care Medium |  |  | 16/11/2022, 09:12 | 16/11/2022, 11:37 | 144.22 |  |  |  |  | 16/11/2022, 11:37 | 14/11/2022, 10:16 | 16/11/2022, 13:23 | Completed | United Kingdom | 14/11/2022 | 106 | Mechanical Fault | Dispensing Accessories | Mechanical Fault | Dispensing Accessories | 5 - Hot Water System | 216 - B2C Grinder | 2 - Repair | 00132669 |  | Completed
 | LOCL |  |  | SA-36309 | 10237431 |  |  | UK Repair Medium |  |  | 06/06/2023, 13:14 | 06/06/2023, 13:14 | 0.07 |  |  |  |  | 06/06/2023, 13:14 | 05/06/2023, 13:21 | 06/06/2023, 13:40 | Completed | United Kingdom | 05/06/2023 | 26 | Mechanical Fault | Unit Does Not Brew | Mechanical Fault | Unit Does Not Brew | 5 - Hot Water System | 212 - Nozzle/cobra jet | 5 - Clean | 00162017 |  | Completed
 | FOLC |  |  | SA-4122 | 10237435 |  |  | UK Client Care Low |  |  | 26/09/2022, 12:47 | 26/09/2022, 13:05 | 17.98 |  |  |  |  | 26/09/2022, 13:05 | 26/09/2022, 12:45 | 26/09/2022, 14:12 | Completed | United Kingdom | 26/09/2022 | 67 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 371 - Cleanliness | 1 - No Fault Found |  |  | Completed
 | LOCL |  |  | SA-27714 | 10237440 |  |  | UK Repair Medium |  |  | 23/03/2023, 14:57 | 23/03/2023, 14:57 | 0.08 |  |  |  |  | 23/03/2023, 14:57 | 22/03/2023, 10:39 | 23/03/2023, 14:57 | Completed | United Kingdom | 22/03/2023 | 0 | Mechanical Fault | Cup Stand Issue | Mechanical Fault | Cup Stand Issue | 2 - Product Handling | 61 - B2C Dispense Arm | 2 - Repair | 00152275 |  | Completed
 | LOCL |  |  | SA-40077 | 10237440 |  |  | UK Repair Medium |  |  | 04/07/2023, 14:58 | 04/07/2023, 14:58 | 0.08 |  |  |  |  | 04/07/2023, 14:58 | 03/07/2023, 10:41 | 04/07/2023, 14:59 | Completed | United Kingdom | 03/07/2023 | 0 | Blocking Fault-Machine Standstill | Not Dispensing | Blocking Fault-Machine Standstill | Not Dispensing | 2 - Product Handling | 61 - B2C Dispense Arm | 2 - Repair | 00166064 |  | Completed
 | LOCL |  |  | SA-40371 | 10237440 |  |  | UK Preventative Maintenance Low |  |  | 04/07/2023, 15:20 | 04/07/2023, 15:20 | 0.1 |  |  |  |  | 04/07/2023, 15:20 | 04/07/2023, 14:21 | 04/07/2023, 15:22 | Completed | United Kingdom | 04/07/2023 | 2 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 351 - Water/scale filter | 3 - Replace |  |  | Completed
 | LOCL |  |  | SA-4605 | 10237443 |  |  | UK Repair Medium XX |  |  | 05/10/2022, 12:33 | 05/10/2022, 12:51 | 18.57 |  |  |  |  | 05/10/2022, 12:51 | 29/09/2022, 09:06 | 05/10/2022, 13:52 | Completed | United Kingdom | 29/09/2022 | 60 | Mechanical Fault | Spiral Problem | Mechanical Fault | Spiral Problem | 9 - Not Machine Fault | 368 - Parts Ordered (9) | 10 - Top up (Parts ordered) | 00127258 |  | Completed
 | LOCL |  |  | SA-5380 | 10237443 |  |  | UK Revisit Medium XX |  |  | 13/10/2022, 10:28 | 13/10/2022, 11:26 | 57.93 |  |  |  |  | 13/10/2022, 11:26 | 05/10/2022, 13:50 | 13/10/2022, 12:51 | Completed | United Kingdom | 05/10/2022 | 84 |  |  | Blocking Fault-Machine Standstill | Not Dispensing | 5 - Hot Water System | 239 - Water pump | 3 - Replace | 00127258 |  | Completed
 | LOCL |  |  | SA-18726 | 10237446 |  |  | UK Client Care Medium |  |  | 19/01/2023, 14:13 | 19/01/2023, 14:13 | 0.1 |  |  |  |  | 19/01/2023, 14:13 | 13/01/2023, 15:33 | 19/01/2023, 15:55 | Completed | United Kingdom | 13/01/2023 | 102 | Other Faults | [NAME] | Other Faults | [NAME] | 2 - Product Handling | 61 - B2C Dispense Arm | 2 - Repair | 00141696 |  | Completed
 | LOCL |  |  | SA-40373 | 10237446 |  |  | UK Preventative Maintenance Low |  |  | 04/07/2023, 15:24 | 04/07/2023, 15:24 | 0.1 |  |  |  |  | 04/07/2023, 15:24 | 04/07/2023, 14:22 | 04/07/2023, 15:25 | Completed | United Kingdom | 04/07/2023 | 0 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 351 - Water/scale filter | 3 - Replace |  |  | Completed
 | LOCL |  |  | SA-4272 | 10237450 |  |  | UK Repair Medium XX |  |  | 04/10/2022, 15:51 | 04/10/2022, 15:51 | 0.1 |  |  |  |  | 04/10/2022, 15:51 | 27/09/2022, 10:45 | 04/10/2022, 15:52 | Completed | United Kingdom | 27/09/2022 | 0 | Mechanical Fault | Unit Does Not Brew | Mechanical Fault | Unit Does Not Brew | 2 - Product Handling | 61 - B2C Dispense Arm | 10 - Top up (Parts ordered) | 00126994 |  | Completed
 | LOCL |  |  | [NAME] | 10237450 |  |  | UK Preventative Maintenance Low |  |  | 25/10/2022, 14:02 | 25/10/2022, 14:02 | 0.08 |  |  |  |  | 25/10/2022, 14:02 | 18/10/2022, 16:06 | 25/10/2022, 14:04 | Completed | United Kingdom | 18/10/2022 | 1 | Other Faults | [NAME] | Other Faults | [NAME] | 7 - Cold Water and Refrigeration | 307 - Aquatec pump | 3 - Replace |  |  | Completed
 | LOCL |  |  | SA-10454 | 10237450 |  |  | UK Repair High XX |  |  | 10/11/2022, 16:20 | 10/11/2022, 16:20 | 0.07 |  |  |  |  | 10/11/2022, 16:20 | 09/11/2022, 14:07 | 10/11/2022, 16:21 | Completed | United Kingdom | 09/11/2022 | 0 | Water/Steam Failure | Machine Leaking | Water/Steam Failure | Machine Leaking | 5 - Hot Water System | 205 - Inlet valve | 2 - Repair | 00132113 |  | Completed
 | LOCL |  |  | SA-31769 | 10237450 |  |  | UK Repair Medium |  |  | 05/05/2023, 15:21 | 05/05/2023, 15:21 | 0.1 |  |  |  |  | 05/05/2023, 15:21 | 26/04/2023, 16:08 | 05/05/2023, 15:22 | Completed | United Kingdom | 26/04/2023 | 0 | Blocking Fault-Machine Standstill | Grinder Not Working | Blocking Fault-Machine Standstill | Grinder Not Working | 5 - Hot Water System | 198 - B2C Brewer | 10 - Top up (Parts ordered) | 00157025 |  | Completed
 | LOCL |  |  | SA-32934 | 10237450 |  |  | UK Repair Medium |  |  | 12/05/2023, 16:23 | 12/05/2023, 16:23 | 0.08 |  |  |  |  | 12/05/2023, 16:23 | 05/05/2023, 13:42 | 12/05/2023, 16:23 | Completed | United Kingdom | 05/05/2023 | 0 | Mechanical Fault | [NAME] | Mechanical Fault | [NAME] | 5 - Hot Water System | 199 - B2C Valve block | 10 - Top up (Parts ordered) | 00158231 |  | Completed
 | LOCL |  |  | SA-34239 | 10237450 |  |  | UK Preventative Maintenance Low |  |  | 02/06/2023, 16:06 | 02/06/2023, 16:06 | 0.1 |  |  |  |  | 02/06/2023, 16:06 | 17/05/2023, 12:44 | 02/06/2023, 16:07 | Completed | United Kingdom | 17/05/2023 | 0 | Other Faults | [NAME] | Other Faults | [NAME] | 5 - Hot Water System | 199 - B2C Valve block | 2 - Repair |  |  | Completed
 | LOCL |  |  | SA-36161 | 10237450 |  |  | UK Repair Medium |  |  | 09/06/2023, 16:04 | 09/06/2023, 16:04 | 0.08 |  |  |  |  | 09/06/2023, 16:04 | 02/06/2023, 16:03 | 09/06/2023, 16:05 | Completed | United Kingdom | 02/06/2023 | 1 | Mechanical Fault | [NAME] | Mechanical Fault | [NAME] | 5 - Hot Water System | Cleared by Phone | 3 - Replace | 00161856 |  | Completed
 | LOCL |  |  | SA-42897 | 10237450 |  |  | UK Repair High |  |  | 26/07/2023, 15:20 | 26/07/2023, 15:40 | 59.6 | 40 |  |  |  | 26/07/2023, 15:40 | 24/07/2023, 16:43 | 26/07/2023, 15:41 | Completed | United Kingdom | 24/07/2023 | 1 | Water/Steam Failure | Machine Leaking | Water/Steam Failure | Machine Leaking | 5 - Hot Water System | 198 - B2C Brewer | 2 - Repair | 00169139 |  | Completed |  |  |  |  |  |  |  |  | =IF(AND(ISNUMBER(MATCH(I25,REPAIRONLY,0)),ISNUMBER(MATCH(LOOKUP(2,1/(F$1:F24=F25),I$1:I24),RepairPM,0))),IFERROR(X25-LOOKUP(2,1/(F$1:F24=F25),X$1:X24),""),"") | 68 (the number of days from the date in row 23 to the date in this row)
 | FOLC |  |  | SA-1114 | 10237456 |  |  | UK Client Care Medium |  |  | 05/09/2022, 04:16 | 05/09/2022, 07:45 | 209.68 |  |  |  |  | 05/09/2022, 07:45 | 02/09/2022, 11:34 | 05/09/2022, 08:28 | Completed | United Kingdom | 02/09/2022 | 42 | Mechanical Fault | Cups Jamming | Mechanical Fault | Cups Jamming | 5 - Hot Water System | 217 - B2C Doser | 4 - Adjust | 00124467 |  | Completed
 | FOLC |  |  | SA-19571 | 10237456 |  |  | UK Repair Medium XX |  |  | 20/01/2023, 10:06 | 20/01/2023, 10:43 | 36.78 |  |  |  |  | 20/01/2023, 10:43 | 20/01/2023, 10:05 | 20/01/2023, 12:28 | Completed | United Kingdom | 20/01/2023 | 104 | Blocking Fault-Machine Standstill | Not Dispensing | Blocking Fault-Machine Standstill | Not Dispensing | 5 - Hot Water System | 215 - B2C Whipper Motor | 3 - Replace | 00142642 |  | Completed
 | FOLC |  |  | SA-21573 | 10237456 |  |  | UK Repair Medium XX |  |  | 03/02/2023, 15:32 | 03/02/2023, 15:32 | 0.13 |  |  |  |  | 03/02/2023, 15:32 | 03/02/2023, 13:13 | 03/02/2023, 15:35 | Completed | United Kingdom | 03/02/2023 | 2 | Payment System | Cashless | Payment System | Cashless | 1 - Payment System | 32 - Other | 8 - Upgrade | 00145098 |  | Completed
 | FOLC |  |  | SA-30951 | 10237456 |  |  | UK Preventative Maintenance Low |  |  | 20/04/2023, 10:22 | 20/04/2023, 11:29 | 67 |  |  |  |  | 20/04/2023, 11:29 | 20/04/2023, 12:18 | 20/04/2023, 13:54 | Completed | United Kingdom | 20/04/2023 | 95 | Quality Of The Dispensing | [NAME] | Quality Of The Dispensing | [NAME] | 9 - Not Machine Fault | 368 - Parts Ordered (9) | 10 - Top up (Parts ordered) |  |  | Completed
 | FOLC |  |  | SA-30999 | 10237456 |  |  | DE Preventative Maintenance Low |  |  | 21/04/2023, 09:10 | 21/04/2023, 10:39 | 89.43 |  |  |  |  | 21/04/2023, 10:39 | 20/04/2023, 13:53 | 21/04/2023, 11:16 | Completed | United Kingdom | 20/04/2023 | 37 | Quality Of The Dispensing | [NAME] | Quality Of The Dispensing | [NAME] | 5 - Hot Water System | 199 - B2C Valve block | 2 - Repair |  |  | Completed
 | FOLC |  |  | SA-50247 | 10237456 |  |  | UK Client Care Low |  |  | 18/09/2023, 10:00 | 18/09/2023, 11:49 | 109 |  |  |  |  | 18/09/2023, 11:49 | 18/09/2023, 13:07 | 18/09/2023, 13:35 | Completed | United Kingdom | 18/09/2023 | 2 | Blocking Fault-Machine Standstill | Not Dispensing | Blocking Fault-Machine Standstill | Not Dispensing | 5 - Hot Water System | 215 - B2C Whipper Motor | 10 - Top up (Parts ordered) | 00177512 |  | Completed
 | FOLC |  |  | SA-50331 | 10237456 |  |  | UK Repair Low XX |  |  | 27/09/2023, 11:21 | 27/09/2023, 11:44 | 23 |  |  |  |  | 27/09/2023, 11:44 | 18/09/2023, 20:11 | 27/09/2023, 12:56 | Completed | United Kingdom | 18/09/2023 | 10 | Blocking Fault-Machine Standstill | Not Dispensing | Blocking Fault-Machine Standstill | Not Dispensing | 9 - Not Machine Fault | 371 - Cleanliness | 5 - Clean | 00177512 |  | Completed
 | FOLC |  |  | SA-51675 | 10237456 |  |  | UK Revisit Low XX |  |  | 05/10/2023, 08:26 | 05/10/2023, 11:38 | 192.07 |  |  |  |  | 05/10/2023, 11:38 | 27/09/2023, 21:18 | 05/10/2023, 11:39 | Completed | United Kingdom | 27/09/2023 | 0 | Blocking Fault-Machine Standstill | Not Dispensing | Blocking Fault-Machine Standstill | Not Dispensing | 5 - Hot Water System | 215 - B2C Whipper Motor | 2 - Repair | 00177512 |  | Completed
 | FMSN |  |  | SA-5314 | 10238061 |  |  | UK Repair Medium XX |  |  | 07/10/2022, 10:13 | 07/10/2022, 11:02 | 49.2 |  |  |  |  | 07/10/2022, 11:02 | 05/10/2022, 10:32 | 07/10/2022, 11:04 | Completed | United Kingdom | 05/10/2022 | 1 | Mechanical Fault | Cups Jamming | Mechanical Fault | Cups Jamming | 9 - Not Machine Fault | 344 - Cup jam | 1 - No Fault Found | 00127831 |  | Completed
 | FMSN |  |  | SA-7356 | 10238061 |  |  | UK Client Care Low |  |  | 19/10/2022, 14:19 | 19/10/2022, 14:19 | 0.1 |  |  |  |  | 19/10/2022, 14:19 | 19/10/2022, 14:17 | 19/10/2022, 14:25 | Completed | United Kingdom | 19/10/2022 | 6 | Mechanical Fault | Cups Jamming | Mechanical Fault | Cups Jamming | 2 - Product Handling | 63 - Splitter & Scrolls | 4 - Adjust |  |  | Completed
 | FMSN |  |  | SA-17598 | 10238061 |  |  | UK Repair Medium XX |  |  | 09/01/2023, 11:01 | 09/01/2023, 12:27 | 85.68 |  |  |  |  | 09/01/2023, 12:27 | 05/01/2023, 16:25 | 09/01/2023, 13:53 | Completed | United Kingdom | 05/01/2023 | 86 | Mechanical Fault | Unit Does Not Brew | Mechanical Fault | Unit Does Not Brew | 9 - Not Machine Fault | 356 - Machine not on site | 1 - No Fault Found | 00140368 |  | Completed
 | FMSN |  |  | SA-19115 | 10238061 |  |  | UK Client Care Low |  |  | 17/01/2023, 15:00 | 17/01/2023, 15:00 | 0.12 |  |  |  |  | 17/01/2023, 15:00 | 17/01/2023, 14:59 | 17/01/2023, 15:01 | Completed | United Kingdom | 17/01/2023 | 1 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 351 - Water/scale filter | 3 - Replace |  |  | Completed
 | FMSN |  |  | SA-19097 | 10238063 |  |  | UK Client Care Low |  |  | 17/01/2023, 14:21 | 17/01/2023, 14:22 | 0.27 |  |  |  |  | 17/01/2023, 14:22 | 17/01/2023, 14:17 | 17/01/2023, 14:23 | Completed | United Kingdom | 17/01/2023 | 1 | Other Faults | [NAME] | Other Faults | [NAME] | 9 - Not Machine Fault | 351 - Water/scale filter | 3 - Replace |  |  | Completed
 | FMSN |  |  | SA-35620 | 10238063 |  |  | UK Repair Medium |  |  | 31/05/2023, 14:27 | 31/05/2023, 14:55 | 27.47 |  |  |  |  | 31/05/2023, 14:55 | 30/05/2023, 15:11 | 31/05/2023, 15:49 | Completed | United Kingdom | 30/05/2023 | 53 | Quality Of The Dispensing | Taint | Quality Of The Dispensing | Taint | 5 - Hot Water System | 219 - B2C Cannisters | 4 - Adjust | 00161240 |  | Completed
 | FMSN |  |  | SA-10369 | 10238064 |  |  | UK Repair High XX |  |  | 09/11/2022, 13:14 | 09/11/2022, 13:18 | 4.23 |  |  |  |  | 09/11/2022, 13:18 | 09/11/2022, 10:14 | 09/11/2022, 13:21 | Completed | United Kingdom | 09/11/2022 | 3 | Water/Steam Failure | Machine Leaking | Water/Steam Failure | Machine Leaking | 5 - Hot Water System | 204 - Inlet hose | 4 - Adjust | 00132006 |  | Completed
 | FMSN |  |  | SA-56053 | 10238064 |  |  | UK Repair High XX |  |  | 30/10/2023, 11:42 | 30/10/2023, 12:20 | 37.32 |  |  |  |  | 30/10/2023, 12:20 | 30/10/2023, 09:24 | 30/10/2023, 13:08 | Completed | United Kingdom | 30/10/2023 | 48 | Water/Steam Failure | Machine Leaking | Water/Steam Failure | Machine Leaking | 9 - Not Machine Fault | 374 - Product loading | 2 - Repair | 00184069 |  | Completed