Spreadsheet: 814535d1674475205-adding-condition-related-to-named-range-to-a-formula-sample8
Sheet: Sheet1

Machine Profile Name | Work Order Number | Appointment Number | Assigned Resource Number | Machine ID | Serial Number | Work Order ID | Work Type: Work Type Name | Work Type Indicator | Work Type: Work Type Name | Service Appointment ID | Service Territory: Name | Service Resource: Name | Travelling Start | Travelling End | Travelling Time (Minutes) | Machine Description | Machine Brand | Machine Type | Machine Installation Date | Actual Start | Created Date & Time | Actual End | Duration in Minutes | Actual Completion Days | Status | Months from Installation Date | Reason For No Intervention | Country | Created Date | Month | Created Date (Formatted) | End Date (Formatted) | Arrive Date (Formatted) | Customer E2E (Days) | Internal Response Time (Hours) | Internal Response Time (wkg hrs) | blank | 90 Day Effectiveness | E2E
sample | sample | sample | sample | sample | sample | sample | FR Repair Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 14:05 | 06/09/2022 13:38 |  | 4.981250000004366 |  |  |  |  | 1 day, 1:03:00
sample | sample | sample | sample | sample | sample | sample | FR Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 14:14 | 05/09/2022 09:56 | 05/09/2022 09:46 | 3.820833333338669 | 3 |  |  |  | 12:42:00
sample | sample | sample | sample | sample | sample | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 14:27 | 05/09/2022 09:31 | 05/09/2022 09:01 | 3.794444444443798 | 3 |  |  |  | 12:04:00
sample | sample | sample | sample | sample | sample | sample | UK Preventative Maintenance Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:28 | 01/09/2022 14:57 | 01/09/2022 14:56 | 0.06180555555329192 | 1 |  |  |  | 1:29:00
sample | sample | sample | sample | sample | sample | sample | UK Preventative Maintenance Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:33 | 01/09/2022 14:05 | 01/09/2022 13:34 | 0.02222222222189885 | 1 |  |  |  | 0:32:00
sample | sample | sample | sample | sample | sample | sample | UK Revisit Very High | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 14:04 | 12/09/2022 12:00 | 12/09/2022 11:59 | 10.91388888889196 | 8 |  |  |  | 2 days, 9:26:00
sample | sample | sample | sample | sample | sample | sample | UK Repair Medium XX | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 12:48 | 02/09/2022 15:51 | 02/09/2022 13:08 | 1.127083333332848 | 2 |  |  |  | 11:33:00
sample | sample | sample | sample | sample | sample | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:48 | 02/09/2022 13:13 | 02/09/2022 12:54 | 0.9756944444452529 | 2 |  |  |  | 7:55:00
sample | sample | sample | sample | sample | sample | sample | FR Client Care Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:25 | 01/09/2022 14:05 | 01/09/2022 13:51 | 0.02777777777373558 | 1 |  |  |  | 0:40:00
sample | sample | sample | sample | sample | sample | sample | FR Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:25 | 02/09/2022 11:25 | 02/09/2022 11:17 | 0.9166666666642413 | 2 |  |  |  | 6:30:00
sample | sample | sample | sample | sample | sample | sample | DE Repair Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 10:54 | 06/09/2022 13:49 | 06/09/2022 13:02 | 5.121527777773736 | 4 |  |  |  | 1 day, 4:25:00
sample | sample | sample | sample | sample | sample | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 13:38 | 02/09/2022 13:23 | 02/09/2022 13:17 | 0.9895833333284827 | 2 |  |  |  | 8:15:00
sample | sample | sample | sample | sample | sample | sample | FR Repair Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 11:06 | 01/09/2022 13:41 | 01/09/2022 13:24 | 0.1076388888905058 | 1 |  |  |  | 2:35:00
sample | sample | sample | sample | sample | sample | sample | DE Repair Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 11:32 | 05/09/2022 13:19 | 05/09/2022 11:41 | 4.074305555550382 | 3 |  |  |  | 18:47:00
sample | sample | sample | sample | sample | sample | sample | FR Client Care No Priority | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 11:24 | 01/09/2022 11:39 | 01/09/2022 11:27 | 0.01041666667151731 | 1 |  |  |  | 0:15:00
sample | sample | sample | sample | sample | sample | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-01 00:00:00 | September 2022 | 01/09/2022 11:36 | 05/09/2022 12:49 | 05/09/2022 12:46 | 4.050694444449618 | 3 |  |  |  | 18:13:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Very High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Very High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Repair Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Revisit Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Repair High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Revisit High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Repair High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Revisit High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Repair Very High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Revisit Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Repair Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE Revisit Very High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Repair Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Revisit Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Repair High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Revisit High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Repair High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Revisit High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Repair Very High
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Revisit Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Repair Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FR Revisit Very High