Spreadsheet: 750794d1633635025-using-aggregate-with-filter-book1
Sheet: Analyze

 |  |  | [NAME] |  | Closed [NAME] | Cancelled | Closed Incomplete |  |  |  |  |  |  |  |  | Lavoie, [NAME]
 |  |  | Monseur, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Monseur, [NAME]
Number of Call | Month |  |  |  |  |  |  |  |  | Travel | Repair | Total | Covertion Table |  |  | Saleh, Khodr
 | Sep |  |  |  |  |  |  |  |  |  |  |  | Minute | SAP
 |  | Date of Visit | Travel Time | Covertion | Activity Type | Technician | Date Complete | Repair Time | Call Status |  |  |  | 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:01:00 | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:02:00 | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:03:00 | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:04:00 | 0.07
 |  |  |  |  |  |  |  |  |  |  |  | ` | 00:05:00 | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:06:00 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:07:00 | 0.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:08:00 | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:09:00 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:10:00 | 0.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:11:00 | 0.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:12:00 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:13:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:14:00 | 0.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:15:00 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:16:00 | 0.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:17:00 | 0.28
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:18:00 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:19:00 | 0.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:20:00 | 0.33
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:21:00 | 0.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:22:00 | 0.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:23:00 | 0.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:24:00 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:25:00 | 0.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:26:00 | 0.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:27:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:28:00 | 0.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:29:00 | 0.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:31:00 | 0.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:32:00 | 0.53
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:33:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:34:00 | 0.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:35:00 | 0.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:36:00 | 0.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:37:00 | 0.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:38:00 | 0.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:39:00 | 0.65
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:40:00 | 0.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:41:00 | 0.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:42:00 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:43:00 | 0.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:44:00 | 0.73
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:45:00 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:46:00 | 0.77
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:47:00 | 0.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:48:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:49:00 | 0.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:50:00 | 0.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:51:00 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:52:00 | 0.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:53:00 | 0.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:54:00 | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:55:00 | 0.92
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:56:00 | 0.93
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:57:00 | 0.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:58:00 | 0.97
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:59:00 | 0.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:01:00 | 1.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:02:00 | 1.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:03:00 | 1.05
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:04:00 | 1.07
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:05:00 | 1.08
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:06:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:07:00 | 1.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:08:00 | 1.13
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:09:00 | 1.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:10:00 | 1.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:11:00 | 1.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:12:00 | 1.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:13:00 | 1.22
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:14:00 | 1.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:15:00 | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:16:00 | 1.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:17:00 | 1.28
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:18:00 | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:19:00 | 1.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:20:00 | 1.33
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:21:00 | 1.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:22:00 | 1.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:23:00 | 1.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:24:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:25:00 | 1.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:26:00 | 1.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:27:00 | 1.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:28:00 | 1.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:29:00 | 1.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:30:00 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:31:00 | 1.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:32:00 | 1.53
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:33:00 | 1.55
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:34:00 | 1.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:35:00 | 1.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:36:00 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:37:00 | 1.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:38:00 | 1.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:39:00 | 1.65
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:40:00 | 1.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:41:00 | 1.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:42:00 | 1.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:43:00 | 1.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:44:00 | 1.73
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:45:00 | 1.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:46:00 | 1.77
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:47:00 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:48:00 | 1.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:49:00 | 1.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:50:00 | 1.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:51:00 | 1.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:52:00 | 1.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:53:00 | 1.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:54:00 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:55:00 | 1.92
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:56:00 | 1.93
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:57:00 | 1.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:58:00 | 1.97
 |  |  |  |  |  |  |  |  |  |  |  |  | 01:59:00 | 1.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:01:00 | 2.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:02:00 | 2.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:03:00 | 2.05
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:04:00 | 2.065
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:05:00 | 2.081
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:06:00 | 2.097
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:07:00 | 2.113
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:08:00 | 2.129
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:09:00 | 2.145
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:10:00 | 2.161
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:11:00 | 2.177
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:12:00 | 2.193
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:13:00 | 2.209
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:14:00 | 2.225
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:15:00 | 2.241
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:16:00 | 2.257
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:17:00 | 2.273
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:18:00 | 2.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:19:00 | 2.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:20:00 | 2.33
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:21:00 | 2.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:22:00 | 2.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:23:00 | 2.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:24:00 | 2.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:25:00 | 2.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:26:00 | 2.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:27:00 | 2.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:28:00 | 2.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:29:00 | 2.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:00 | 2.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:31:00 | 2.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:32:00 | 2.53
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:33:00 | 2.55
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:34:00 | 2.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:35:00 | 2.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:36:00 | 2.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:37:00 | 2.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:38:00 | 2.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:39:00 | 2.65
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:40:00 | 2.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:41:00 | 2.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:42:00 | 2.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:43:00 | 2.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:44:00 | 2.73
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:45:00 | 2.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:46:00 | 2.77
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:47:00 | 2.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:48:00 | 2.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:49:00 | 2.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:50:00 | 2.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:51:00 | 2.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:52:00 | 2.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:53:00 | 2.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:54:00 | 2.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:55:00 | 2.92
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:56:00 | 2.93
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:57:00 | 2.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:58:00 | 2.97
 |  |  |  |  |  |  |  |  |  |  |  |  | 02:59:00 | 2.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00 | 3