Spreadsheet: 474012d1470575256-need-a-overview-as-a-chart-or-easy-access-widget-0eldere-427328d1445985346-sum-only-the-rows-which-have-the-same-date-but-a-little-more-compli
Sheet: Sheet1

Vehicle | EventType | EventDate | EventTime | Speed | ADDED | TimeInGeofence | TripInGeofence | TripUnits | Driver | TIME Out of Geofence | TOTAL TIME
PM333 | [NAME] | 2015-10-16 00:00:00 | 14:00:00 | 53 km/h | 0 | 0 min |  |  | Unknown Driver
PM333 | Geofence Entered | 2015-10-16 00:00:00 | 14:01:00 | 34 km/h |  |  |  |  | Unknown Driver
PM596 | [NAME] | 2015-10-16 00:00:00 | 10:13:00 | 27 km/h | 0 | 0 min |  |  | Unknown Driver
PM596 | Geofence Entered | 2015-10-16 00:00:00 | 18:19:00 | 40 km/h |  |  |  |  | Unknown Driver
PM604 | Geofence Entered | 2015-10-16 00:00:00 | 05:51:00 | 40 km/h |  |  |  |  | Unknown Driver
PM604 | [NAME] | 2015-10-16 00:00:00 | 06:39:00 | 23 km/h | 48 | 48 min | 1.1 | km | Unknown Driver
PM604 | Geofence Entered | 2015-10-16 00:00:00 | 12:16:00 | 35 km/h |  |  |  |  | Unknown Driver
PM607 | [NAME] | 2015-10-16 00:00:00 | 03:06:00 | 23 km/h | 0 | 0 min |  |  | Unknown Driver
PM607 | Geofence Entered | 2015-10-16 00:00:00 | 15:01:00 | 28 km/h |  |  |  |  | Unknown Driver
[NAME] | [NAME] | 2015-10-16 00:00:00 | 05:45:00 | 13 km/h | 0 | 0 min |  |  | Unknown Driver
[NAME] | Geofence Entered | 2015-10-16 00:00:00 | 10:46:00 | 25 km/h |  |  |  |  | Unknown Driver
[NAME] | [NAME] | 2015-10-16 00:00:00 | 11:21:00 | 14 km/h | 35 | 35 min | 1.5 | km | Unknown Driver
[NAME] | Geofence Entered | 2015-10-16 00:00:00 | 13:23:00 | 36 km/h |  |  |  |  | Unknown Driver
PM669 | [NAME] | 2015-10-16 00:00:00 | 03:51:00 | 24 km/h |  | 0 min |  |  | Unknown Driver
PM669 | Geofence Entered | 2015-10-16 00:00:00 | 13:44:00 | 32 km/h |  |  |  |  | Unknown Driver
PM669 | [NAME] | 2015-10-16 00:00:00 | 18:50:00 | - | 306 | 5hr 06 min | 0.8 | km | Unknown Driver
PM669 | Geofence Entered | 2015-10-16 00:00:00 | 18:50:00 | - |  |  |  |  | Unknown Driver
R496 | [NAME] | 2015-10-16 00:00:00 | 08:04:00 | 23 km/h | 0 | 0 min |  |  | Unknown Driver
R496 | Geofence Entered | 2015-10-16 00:00:00 | 09:32:00 | 28 km/h |  |  |  |  | Unknown Driver
R496 | [NAME] | 2015-10-16 00:00:00 | 10:36:00 | 24 km/h | 64 | 1hr 04 min | 1 | km | Unknown Driver
R496 | Geofence Entered | 2015-10-16 00:00:00 | 16:06:00 | 27 km/h |  |  |  |  | Unknown Driver
R497 | [NAME] | 2015-10-16 00:00:00 | 03:35:00 | 16 km/h | 0 | 0 min |  |  | Unknown Driver
R497 | Geofence Entered | 2015-10-16 00:00:00 | 12:32:00 | 39 km/h |  |  |  |  | Unknown Driver
C-17 | Geofence Entered | 2015-10-16 00:00:00 | 04:27:00 | 48 km/h |  |  |  |  | Unknown Driver
C-17 | [NAME] | 2015-10-16 00:00:00 | 05:20:00 | 17 km/h | 53 | 53 min | 1 | km | Unknown Driver
C-17 | Geofence Entered | 2015-10-16 00:00:00 | 05:27:00 | 30 km/h |  |  |  |  | Unknown Driver
C-17 | [NAME] | 2015-10-16 00:00:00 | 06:34:00 | 23 km/h | 67 | 1hr 07 min | 0.7 | km | Unknown Driver
C-17 | Geofence Entered | 2015-10-16 00:00:00 | 10:48:00 | 55 km/h |  |  |  |  | Unknown Driver
C-17 | [NAME] | 2015-10-16 00:00:00 | 12:57:00 | 27 km/h | 129 | 2hr 09 min | 2.9 | km | Unknown Driver
C-17 | Geofence Entered | 2015-10-16 00:00:00 | 14:38:00 | 30 km/h |  |  |  |  | Unknown Driver
PM551 | Geofence Entered | 2015-10-16 00:00:00 | 03:40:00 | 23 km/h |  |  |  |  | Unknown Driver
PM551 | [NAME] | 2015-10-16 00:00:00 | 04:50:00 | 13 km/h | 70 | 1hr 10 min | 2.3 | km | Unknown Driver
PM551 | Geofence Entered | 2015-10-16 00:00:00 | 13:15:00 | 18 km/h |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 03:25:00 | 32 km/h | 0 | 0 min |  |  | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 06:01:00 | 28 km/h |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 07:39:00 | 26 km/h | 98 | 1hr 38 min | 1.6 | km | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 09:47:00 | 38 km/h |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 11:19:00 | 26 km/h | 92 | 1hr 32 min | 1.6 | km | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 15:06:00 | 43 km/h |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 18:21:00 | 11 km/h | 195 | 3hr 15 min | 1.7 | km | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 18:23:00 | - |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 18:45:00 | 13 km/h | 22 | 22 min | 1.5 | km | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 18:45:00 | 1 km/h |  |  |  |  | Unknown Driver
PM586 | [NAME] | 2015-10-16 00:00:00 | 19:27:00 | 4 km/h | 42 | 42 min | 0.5 | km | Unknown Driver
PM586 | Geofence Entered | 2015-10-16 00:00:00 | 19:28:00 | - |  |  |  |  | Unknown Driver
PM601 | [NAME] | 2015-10-16 00:00:00 | 05:20:00 | 8 km/h | 0 | 0 min |  |  | Unknown Driver
PM601 | Geofence Entered | 2015-10-16 00:00:00 | 11:45:00 | 24 km/h |  |  |  |  | Unknown Driver
PM601 | [NAME] | 2015-10-16 00:00:00 | 13:01:00 | 18 km/h | 76 | 1hr 16 min | 2.7 | km | Unknown Driver
PM601 | Geofence Entered | 2015-10-16 00:00:00 | 17:55:00 | 32 km/h |  |  |  |  | Unknown Driver
PM603 | [NAME] | 2015-10-16 00:00:00 | 05:20:00 | - | 0 | 0 min |  |  | Unknown Driver
PM603 | Geofence Entered | 2015-10-16 00:00:00 | 09:59:00 | 23 km/h |  |  |  |  | Unknown Driver
PM606 | Geofence Entered | 2015-10-16 00:00:00 | 02:57:00 | 33 km/h |  |  |  |  | Unknown Driver
PM606 | [NAME] | 2015-10-16 00:00:00 | 10:48:00 | 17 km/h | 471 | 7hr 51 min | 1.1 | km | Unknown Driver
PM641 | Geofence Entered | 2015-10-16 00:00:00 | 04:05:00 | 46 km/h |  |  |  |  | Unknown Driver
PM641 | [NAME] | 2015-10-16 00:00:00 | 04:48:00 | 36 km/h | 43 | 43 min | 1 | km | Unknown Driver
PM641 | Geofence Entered | 2015-10-16 00:00:00 | 08:04:00 | 31 km/h |  |  |  |  | Unknown Driver
PM641 | [NAME] | 2015-10-16 00:00:00 | 09:37:00 | 27 km/h | 93 | 1hr 33 min | 1.1 | km | Unknown Driver
PM641 | Geofence Entered | 2015-10-16 00:00:00 | 11:19:00 | 28 km/h |  |  |  |  | Unknown Driver
PM641 | [NAME] | 2015-10-16 00:00:00 | 11:45:00 | 25 km/h | 26 | 26 min | 1 | km | Unknown Driver
PM641 | Geofence Entered | 2015-10-16 00:00:00 | 14:05:00 | 38 km/h |  |  |  |  | Unknown Driver
R316 | [NAME] | 2015-10-16 00:00:00 | 06:44:00 | 17 km/h | 0 | 0 min |  |  | Unknown Driver
R316 | Geofence Entered | 2015-10-16 00:00:00 | 14:23:00 | 19 km/h |  |  |  |  | Unknown Driver
R401 | [NAME] | 2015-10-16 00:00:00 | 03:41:00 | 26 km/h | 0 | 0 min |  |  | Unknown Driver
R401 | Geofence Entered | 2015-10-16 00:00:00 | 09:43:00 | 19 km/h |  |  |  |  | Unknown Driver
R401 | [NAME] | 2015-10-16 00:00:00 | 13:25:00 | 17 km/h | 222 | 3hr 42 min | 2 | km | Unknown Driver
R401 | Geofence Entered | 2015-10-16 00:00:00 | 15:06:00 | 57 km/h |  |  |  |  | Unknown Driver
R404 | [NAME] | 2015-10-16 00:00:00 | 05:12:00 | 26 km/h | 0 | 0 min |  |  | Unknown Driver
R404 | Geofence Entered | 2015-10-16 00:00:00 | 11:01:00 | 16 km/h |  |  |  |  | Unknown Driver
R404 | [NAME] | 2015-10-16 00:00:00 | 12:26:00 | 20 km/h | 85 | 1hr 25 min | 2.1 | km | Unknown Driver
R404 | Geofence Entered | 2015-10-16 00:00:00 | 18:14:00 | 21 km/h |  |  |  |  | Unknown Driver
R405 | [NAME] | 2015-10-16 00:00:00 | 04:23:00 | 47 km/h | 0 | 0 min |  |  | Unknown Driver
R405 | Geofence Entered | 2015-10-16 00:00:00 | 13:03:00 | 23 km/h |  |  |  |  | Unknown Driver
R408 | [NAME] | 2015-10-16 00:00:00 | 07:37:00 | 17 km/h | 0 | 0 min |  |  | Unknown Driver
R408 | Geofence Entered | 2015-10-16 00:00:00 | 14:42:00 | 24 km/h |  |  |  |  | Unknown Driver
R435 | [NAME] | 2015-10-16 00:00:00 | 04:31:00 | 14 km/h | 0 | 0 min |  |  | Unknown Driver
R435 | Geofence Entered | 2015-10-16 00:00:00 | 08:14:00 | 23 km/h |  |  |  |  | Unknown Driver
R435 | [NAME] | 2015-10-16 00:00:00 | 13:37:00 | 44 km/h | 323 | 5hr 23 min | 2.2 | km | Unknown Driver
R435 | Geofence Entered | 2015-10-16 00:00:00 | 15:02:00 | 42 km/h |  |  |  |  | Unknown Driver
R436 | [NAME] | 2015-10-16 00:00:00 | 10:17:00 | 19 km/h | 0 | 0 min |  |  | Unknown Driver
R436 | Geofence Entered | 2015-10-16 00:00:00 | 14:50:00 | 34 km/h |  |  |  |  | Unknown Driver
R573 | [NAME] | 2015-10-16 00:00:00 | 06:55:00 | 27 km/h | 0 | 0 min |  |  | Unknown Driver
R573 | Geofence Entered | 2015-10-16 00:00:00 | 16:47:00 | 29 km/h |  |  |  |  | Unknown Driver
R576 | [NAME] | 2015-10-16 00:00:00 | 04:34:00 | 19 km/h | 0 | 0 min |  |  | Unknown Driver
R576 | Geofence Entered | 2015-10-16 00:00:00 | 10:54:00 | 27 km/h |  |  |  |  | Unknown Driver
R576 | [NAME] | 2015-10-16 00:00:00 | 11:18:00 | 23 km/h | 24 | 24 min | 0.9 | km | Unknown Driver
R576 | Geofence Entered | 2015-10-16 00:00:00 | 13:14:00 | 52 km/h |  |  |  |  | Unknown Driver
R579 | [NAME] | 2015-10-16 00:00:00 | 04:33:00 | 17 km/h | 0 | 0 min |  |  | Unknown Driver
R579 | Geofence Entered | 2015-10-16 00:00:00 | 08:36:00 | 22 km/h |  |  |  |  | Unknown Driver
R579 | [NAME] | 2015-10-16 00:00:00 | 11:19:00 | 22 km/h | 164 | 2hr 43 min | 3 | km | Unknown Driver
R579 | Geofence Entered | 2015-10-16 00:00:00 | 12:56:00 | 33 km/h |  |  |  |  | Unknown Driver
R579 | [NAME] | 2015-10-16 00:00:00 | 14:41:00 | 19 km/h | 105 | 1hr 45 min | 1.6 | km | Unknown Driver
R579 | Geofence Entered | 2015-10-16 00:00:00 | 14:57:00 | 58 km/h |  |  |  |  | Unknown Driver
R633 | [NAME] | 2015-10-16 00:00:00 | 07:44:00 | 17 km/h | 0 | 0 min |  |  | Unknown Driver
R633 | Geofence Entered | 2015-10-16 00:00:00 | 09:04:00 | 25 km/h |  |  |  |  | Unknown Driver
R633 | [NAME] | 2015-10-16 00:00:00 | 11:44:00 | 20 km/h | 200 | 2hr 40 min | 1.6 | km | Unknown Driver
R633 | Geofence Entered | 2015-10-16 00:00:00 | 14:51:00 | 41 km/h |  |  |  |  | Unknown Driver
R540 | [NAME] | 2015-10-16 00:00:00 | 06:03:00 | 45 km/h | 0 | 0 min |  |  | Unknown Driver
R540 | Geofence Entered | 2015-10-16 00:00:00 | 11:51:00 | 52 km/h |  |  |  |  | Unknown Driver
R540 | [NAME] | 2015-10-16 00:00:00 | 12:07:00 | 54 km/h | 16 | 16 min | 0.8 | km | Unknown Driver
R540 | Geofence Entered | 2015-10-16 00:00:00 | 13:26:00 | 39 km/h |  |  |  |  | Unknown Driver
R540 | [NAME] | 2015-10-16 00:00:00 | 15:58:00 | 50 km/h | 152 | 2hr 32 min | 5.5 | km | Unknown Driver
R540 | Geofence Entered | 2015-10-16 00:00:00 | 15:59:00 | - |  |  |  |  | Unknown Driver
R520 | Geofence Entered | 2015-10-16 00:00:00 | 06:16:00 | 25 km/h |  |  |  |  | Unknown Driver
R520 | [NAME] | 2015-10-16 00:00:00 | 07:54:00 | 36 km/h | 98 | 1hr 38 min | 0.4 | km | Unknown Driver
R521 | [NAME] | 2015-10-16 00:00:00 | 06:33:00 | 46 km/h | 0 | 0 min |  |  | Unknown Driver
R521 | Geofence Entered | 2015-10-16 00:00:00 | 08:17:00 | 48 km/h |  |  |  |  | Unknown Driver
R521 | [NAME] | 2015-10-16 00:00:00 | 09:03:00 | 44 km/h | 46 | 46 min | 0.9 | km | Unknown Driver
R521 | Geofence Entered | 2015-10-16 00:00:00 | 13:43:00 | 47 km/h |  |  |  |  | Unknown Driver
R530 | [NAME] | 2015-10-16 00:00:00 | 05:20:00 | 28 km/h | 0 | 0 min |  |  | Unknown Driver
R530 | Geofence Entered | 2015-10-16 00:00:00 | 10:35:00 | 61 km/h |  |  |  |  | Unknown Driver
R530 | [NAME] | 2015-10-16 00:00:00 | 11:07:00 | 56 km/h | 32 | 32 min | 0.9 | km | Unknown Driver
R530 | Geofence Entered | 2015-10-16 00:00:00 | 12:48:00 | 19 km/h |  |  |  |  | Unknown Driver
R531 | [NAME] | 2015-10-16 00:00:00 | 05:13:00 | 32 km/h | 0 | 0 min |  |  | Unknown Driver
R531 | Geofence Entered | 2015-10-16 00:00:00 | 10:27:00 | 13 km/h |  |  |  |  | Unknown Driver
R538 | [NAME] | 2015-10-16 00:00:00 | 06:01:00 | 49 km/h | 0 | 0 min |  |  | Unknown Driver
R538 | Geofence Entered | 2015-10-16 00:00:00 | 14:20:00 | 51 km/h |  |  |  |  | Unknown Driver
R543 | [NAME] | 2015-10-16 00:00:00 | 06:04:00 | 46 km/h | 0 | 0 min |  |  | Unknown Driver
R543 | Geofence Entered | 2015-10-16 00:00:00 | 06:27:00 | 59 km/h |  |  |  |  | Unknown Driver
R543 | [NAME] | 2015-10-16 00:00:00 | 06:28:00 | 53 km/h | 1 | 01 min | 0.9 | km | Unknown Driver
R543 | Geofence Entered | 2015-10-16 00:00:00 | 08:56:00 | 46 km/h |  |  |  |  | Unknown Driver
R543 | [NAME] | 2015-10-16 00:00:00 | 09:30:00 | 49 km/h | 34 | 34 min | 0.9 | km | Unknown Driver
R543 | Geofence Entered | 2015-10-16 00:00:00 | 10:26:00 | 55 km/h |  |  |  |  | Unknown Driver
R543 | [NAME] | 2015-10-16 00:00:00 | 10:27:00 | 30 km/h | 1 | 01 min | 0.3 | km | Unknown Driver
R543 | Geofence Entered | 2015-10-16 00:00:00 | 10:35:00 | 21 km/h |  |  |  |  | Unknown Driver
R543 | [NAME] | 2015-10-16 00:00:00 | 10:35:00 | 51 km/h | 0 | 0 min | 0.3 | km | Unknown Driver
R543 | Geofence Entered | 2015-10-16 00:00:00 | 15:52:00 | 53 km/h |  |  |  |  | Unknown Driver
R544 | [NAME] | 2015-10-16 00:00:00 | 06:06:00 | 49 km/h | 0 | 0 min |  |  | Unknown Driver
R544 | Geofence Entered | 2015-10-16 00:00:00 | 07:54:00 | 49 km/h |  |  |  |  | Unknown Driver
R544 | [NAME] | 2015-10-16 00:00:00 | 07:56:00 | 59 km/h | 2 | 02 min | 1 | km | Unknown Driver
R675 | [NAME] | 2015-10-16 00:00:00 | 05:24:00 | 28 km/h | 0 | 0 min |  |  | Unknown Driver
R675 | Geofence Entered | 2015-10-16 00:00:00 | 12:51:00 | 22 km/h |  |  |  |  | Unknown Driver
R524 | [NAME] | 2015-10-16 00:00:00 | 05:49:00 | 10 km/h | 0 | 0 min |  |  | Unknown Driver
R524 | Geofence Entered | 2015-10-16 00:00:00 | 05:51:00 | 1 km/h |  |  |  |  | Unknown Driver
R524 | [NAME] | 2015-10-16 00:00:00 | 06:35:00 | 72 km/h | 44 | 44 min | 1.8 | km | Unknown Driver
R524 | Geofence Entered | 2015-10-16 00:00:00 | 15:14:00 | 73 km/h |  |  |  |  | Unknown Driver
R524 | [NAME] | 2015-10-16 00:00:00 | 18:18:00 | 25 km/h | 184 | 3hr 04 min | 4.5 | km | Unknown Driver
R524 | Geofence Entered | 2015-10-16 00:00:00 | 18:20:00 | - |  |  |  |  | Unknown Driver
R525 | Geofence Entered | 2015-10-16 00:00:00 | 04:56:00 | 64 km/h |  |  |  |  | Unknown Driver
R525 | [NAME] | 2015-10-16 00:00:00 | 05:33:00 | 72 km/h | 37 | 37 min | 2.5 | km | Unknown Driver
R525 | Geofence Entered | 2015-10-16 00:00:00 | 08:03:00 | 83 km/h |  |  |  |  | Unknown Driver
R525 | [NAME] | 2015-10-16 00:00:00 | 08:43:00 | 68 km/h | 40 | 40 min | 2.5 | km | Unknown Driver
R526 | [NAME] | 2015-10-16 00:00:00 | 05:31:00 | 10 km/h | 0 | 0 min |  |  | Unknown Driver
R526 | Geofence Entered | 2015-10-16 00:00:00 | 12:45:00 | 30 km/h |  |  |  |  | Unknown Driver
R529 | [NAME] | 2015-10-16 00:00:00 | 06:22:00 | 71 km/h | 0 | 0 min |  |  | Unknown Driver
R529 | Geofence Entered | 2015-10-16 00:00:00 | 14:14:00 | 59 km/h |  |  |  |  | Unknown Driver
R533 | [NAME] | 2015-10-16 00:00:00 | 05:19:00 | 23 km/h | 0 | 0 min |  |  | Unknown Driver
R533 | Geofence Entered | 2015-10-16 00:00:00 | 11:56:00 | 14 km/h |  |  |  |  | Unknown Driver