Spreadsheet: 831884d1685973446-if-statement-with-multiple-criteria-sample-wo
Sheet: WO Raw Data

SAP Account Id | Work Order Number | Appointment Number | Serial Number | Work Type: Work Type Name | Territory | Resource | 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 | 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) | E2E | Medium+repair? | Cust Response Time inc weekends | DE High Response Time | DE Low Response Time | DE Response Time | Total Travel Time (DE) | E2E BI | Customer Response BI | DE High Response BI | DE Low Response BI | Days Worked | Productivity | Sites Visited | Sites Visited per Day1 | Time on Site BI
[PHONE] | 00033066 | SA-33187 | 11233409 | DE Repair Low |  |  | 09/05/2023, 19:10 | 09/05/2023, 19:10 | 110.15 | 110 |  |  |  | 09/05/2023, 19:10 | 09/05/2023, 15:31 | 09/05/2023, 19:11 | Completed | Germany | 09/05/2023 | 0 | Payment System | Cashless | Payment System | Cashless | Not Machine Fault | Price change | Pro/reprogramme
[PHONE] | 00033067 | SA-33188 | 11233411 | DE Repair Low |  |  | 22/05/2023, 08:49 | 22/05/2023, 12:49 | 240.62 |  |  |  |  | 22/05/2023, 12:49 | 09/05/2023, 15:36 | 22/05/2023, 13:05 | Completed | Germany | 09/05/2023 | 15 | Payment System | Cashless | Payment System | Cashless | Control System | GVMC/BV control PCB | Pro/reprogramme
[PHONE] | 00032830 | SA-32952 | 11312369 | UK Repair Medium |  |  | 05/05/2023, 15:02 | 05/05/2023, 15:02 | 0.12 |  |  |  |  | 05/05/2023, 15:02 | 05/05/2023, 14:59 | 05/05/2023, 15:06 | Completed | United Kingdom | 05/05/2023 | 3 | Mechanical Fault | Unit Does Not Brew | Mechanical Fault | Unit Does Not Brew | Not Machine Fault | Parts Ordered (9) | Top up (Parts ordered) |  |  |  |  |  |  |  |  | Should  be blank
[PHONE] | 00032833 | SA-32955 | 11312369 | Uk Revisit Medium |  |  | 09/05/2023, 07:40 | 09/05/2023, 09:00 | 79.9 |  |  |  |  | 09/05/2023, 09:00 | 05/05/2023, 15:03 | 09/05/2023, 11:05 | Completed | United Kingdom | 05/05/2023 | 1 | Mechanical Fault | Unit Does Not Brew | Mechanical Fault | Unit Does Not Brew | Not Machine Fault | Beyond economical repair | No Fault Found |  |  |  |  |  |  |  |  | Should be counting from 05/05/23 to 09/05/23
[PHONE] | 00031805 | SA-31924 | 11520619 | UK Client Care Low |  |  | 27/04/2023, 14:23 | 27/04/2023, 14:23 | 0.15 |  |  |  |  | 27/04/2023, 14:25 | 27/04/2023, 13:52 | 27/04/2023, 15:25 | Completed | United Kingdom | 27/04/2023 | 60 | Other Faults | [NAME] | Other Faults | [NAME] | Not Machine Fault | Programming | Pro/reprogramme
[PHONE] | 00031782 | SA-31901 | 11520624 | UK Client Care Low |  |  | 27/04/2023, 13:06 | 27/04/2023, 13:06 | 0.12 |  |  |  |  | 27/04/2023, 13:06 | 27/04/2023, 13:05 | 27/04/2023, 14:23 | Completed | United Kingdom | 27/04/2023 | 76 | Other Faults | [NAME] | Other Faults | [NAME] | Not Machine Fault | Programming | Pro/reprogramme
[PHONE] | 00006173 | SA-6273 | 12620037 | UK Repair Low XX |  |  | 12/10/2022, 10:23 | 12/10/2022, 10:33 | 9.82 |  |  |  |  | 12/10/2022, 10:33 | 12/10/2022, 09:49 | 12/10/2022, 11:20 | Completed | United Kingdom | 12/10/2022 | 46 | Quality Of The Dispensing | Standard Maintenance | Quality Of The Dispensing | Standard Maintenance | Product Handling | B2C Dispense Arm | Clear
[PHONE] | 00000490 | SA-0506 | 14920662 | DE Installation No Priority XX |  |  | 05/09/2022, 12:42 | 05/09/2022, 12:42 | 0.22 |  |  |  |  | 05/09/2022, 12:42 | 30/08/2022, 12:13 | 05/09/2022, 15:03 | Completed | Germany | 30/08/2022 | 141 | Other Faults | New Mc Installation | Machine Reporting Error | Acoustic Signal Not Working | Not Machine Fault | Machine install | Pro/reprogramme
[PHONE] | 00006369 | SA-6469 | 14920670 | DE Repair High XX |  |  | 14/10/2022, 07:34 | 14/10/2022, [NAME] | 34.28 |  |  |  |  | 14/10/2022, [NAME] | 13/10/2022, 11:00 | 14/10/2022, 09:02 | Completed | Germany | 13/10/2022 | 54 | Quality Of The Dispensing | Prod: Group 1 Does Not Deliver | Quality Of The Dispensing | Brewing Continous And Fast | Product Handling | B2C Dispense Arm | No Fault Found |  |  |  |  |  |  |  |  | Should be blank
[PHONE] | 00006526 | SA-6626 | 14920670 | DE Revisit High XX |  |  | 17/10/2022, 07:40 | 17/10/2022, 11:04 | 203.78 |  |  |  |  | 17/10/2022, 11:04 | 14/10/2022, 08:58 | 17/10/2022, 14:09 | Completed | Germany | 14/10/2022 | 184 |  |  | Quality Of The Dispensing | Brewing Continous And Fast | Control System | GVMC/BV control PCB | Pro/reprogramme |  |  |  |  |  |  |  |  | Should be counting from 13/10/22 to 17/10/22
[PHONE] | 00004032 | SA-4075 | 15020711 | DE Revisit High XX |  |  | 27/09/2022, 06:58 | 27/09/2022, 07:29 | 31.08 |  |  |  |  | 27/09/2022, 07:29 | 26/09/2022, 10:18 | 27/09/2022, 09:15 | Completed | Germany | 26/09/2022 | 105 | Other Faults | Installation Problem | Other Faults | Installation Problem | Control System | Power supply | Replace
[PHONE] | 00010067 | SA-10170 | 15020712 | DE Repair High XX |  |  | 21/11/2022, 13:17 | 21/11/2022, 14:16 | 58.48 |  |  |  |  | 21/11/2022, 14:16 | 08/11/2022, 08:39 | 21/11/2022, 14:17 | Completed | Germany | 08/11/2022 | 0 | Quality Of The Dispensing | Prod: Group 1 Does Not Deliver | Quality Of The Dispensing | Prod: Group 1 Does Not Deliver | Not Machine Fault | Component out of place | No Fault Found
[PHONE] | 00031792 | SA-31911 | 15021166 | UK Repair Medium |  |  | 27/04/2023, 15:03 | 27/04/2023, 15:03 | 0.1 |  |  |  |  | 27/04/2023, 15:03 | 27/04/2023, 13:23 | 27/04/2023, 15:46 | Completed | United Kingdom | 27/04/2023 | 42 | Mechanical Fault | Dispensing Accessories | Mechanical Fault | Dispensing Accessories | Not Machine Fault | Cup jam | Clear
[PHONE] | 00034312 | SA-34429 | 15021166 | UK Repair Medium |  |  | 19/05/2023, 14:10 | 19/05/2023, 15:17 | 67.27 |  |  |  |  | 19/05/2023, 15:17 | 19/05/2023, 08:40 | 19/05/2023, 15:18 | Completed | United Kingdom | 19/05/2023 | 0 | Mechanical Fault | Cup Splitter Issue | Mechanical Fault | Cup Splitter Issue | Not Machine Fault | Cup jam | Clear
[PHONE] | 00004838 | SA-4880 | 15021170 | UK Client Care Low |  |  | 30/09/2022, 16:20 | 30/09/2022, 16:20 | 0.08 |  |  |  |  | 30/09/2022, 16:20 | 30/09/2022, 15:25 | 30/09/2022, 16:20 | Completed | United Kingdom | 30/09/2022 | 0 | Other Faults | [NAME] | Other Faults | [NAME] | Not Machine Fault | Other configurations | No Fault Found
[PHONE] | 00008226 | SA-8327 | 15021170 | UK Repair Low XX |  |  | 25/10/2022, 13:45 | 25/10/2022, 13:52 | 7.02 |  |  |  |  | 25/10/2022, 13:52 | 25/10/2022, 13:17 | 25/10/2022, 13:52 | Completed | United Kingdom | 25/10/2022 | 0 | Other Faults | [NAME] | Other Faults | [NAME] | Cabinet/Door Fit | Door lock | Repair
[PHONE] | 00033080 | SA-33201 | 15021527 | FR Installation No Priority |  |  | 12/05/2023, 07:13 | 12/05/2023, 08:42 | 89.32 |  |  |  |  | 12/05/2023, 08:42 | 09/05/2023, 17:13 | 12/05/2023, 10:39 | Completed | France | 09/05/2023 | 116 | Other Faults | New Mc Installation | Other Faults | New Mc Installation | Not Machine Fault | Ideal cassette float | Upgrade