Spreadsheet: 698291d1601906336-index-match-with-2-column-criteria-and-dynamic-row-index-match-with-dynamic-columns
Sheet: test

DATE_TIME_FORMAT
dd/MM/yyyy H:[NAME]
Work Queue Name | Date | Time | Time Interval | Staffing (Absolute For) | Volume (Absolute Act) | Volume (Absolute For) | Activity Handling Time (Absolute Act) | Activity Handling Time (Absolute For) | Abandons (Absolute For) | Net Staffing (Absolute For) | Service Level (Absolute For) | Occupancy (Absolute For) | Average Speed to Answer (Absolute For)
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 00:00:00 | 00:15:00 |  | 4
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 00:15:00 | 00:15:00 |  | 5
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 00:30:00 | 00:15:00 |  | 6
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 00:45:00 | 00:15:00 |  | 7
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 01:00:00 | 00:15:00 |  | 8
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 01:15:00 | 00:15:00 |  | 9 |  |  |  |  |  |  |  |  | Criteria 1 | 2020-09-21 00:00:00
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 01:30:00 | 00:15:00 |  | 10 |  |  |  |  |  |  |  |  | [NAME] | 02:00:00
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 01:45:00 | 00:15:00 |  | 11 |  |  |  |  |  |  |  |  | Criteria 3 | Volume (Absolute Act)
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 02:00:00 | 00:15:00 |  | 12 |  |  |  |  |  |  |  |  | Answer | 12
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 02:15:00 | 00:15:00 |  | 13
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 02:30:00 | 00:15:00 |  | 14
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 02:45:00 | 00:15:00 |  | 15
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 03:00:00 | 00:15:00 |  | 16
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 03:15:00 | 00:15:00 |  | 17
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 03:30:00 | 00:15:00 |  | 18
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 03:45:00 | 00:15:00 |  | 19
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 04:00:00 | 00:15:00 |  | 20
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 04:15:00 | 00:15:00 |  | 21
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 04:30:00 | 00:15:00 |  | 22
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 04:45:00 | 00:15:00 |  | 23
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 05:00:00 | 00:15:00 |  | 24
Combined - Phone (LSL_AOE (158), [NAME] (157), LSL_Claim (153), LSL_Complaints (162), LSL_Court (160), LSL_Defence (156), LSL_Judgement (155), LSL_Pre Claim (151), LSL_PreAction Protocall (163), LSL_Recoveries (161), LSL_Utilities (164), LSL_Warrant (159)) | 2020-09-21 00:00:00 | 05:15:00 | 00:15:00 |  | 25