Spreadsheet: 821092d1678441984-vba-code-compiles-data-in-new-sheet-except-if-there-is-only-one-line-of-data-road-speed-limit-violations-new-_2023-03-10_0728
Sheet: 205 CA615269

 |  |  |  | Road Speed Limit Violations
 |  |  |  | Time frame: Manual | Resource type: 90 Resources In 3 groups | Duration: All
 |  |  |  | Created: 10/03/2023 07:28:13 | Account: Hylton Ross Tours (Pty) Ltd
 | 205 CA615269 Report Totals for 03/03/2023 06:30:00 - 10/03/2023 06:15:00 (UTC+02:00) Harare, Pretoria
 | No. of Events |  |  |  |  |  |  | [NAME] |  |  |  |  | Total Duration
 | 26 |  |  |  |  |  |  | 86km/h |  |  |  |  | 00h04m31s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-06 06:28:02.850000 |  |  |  | 205 CA615269 |  | 73 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 07:48:47.120000 |  |  |  | 205 CA615269 |  | 73 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:48:47.480000 |  |  |  | 205 CA615269 |  | 61 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 08:49:07.450000 |  |  |  | 205 CA615269 |  | 66 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 09:15:43.650000 |  |  |  | 205 CA615269 |  | 82 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 14:13:29.460000 |  |  |  | 205 CA615269 |  | 71 |  | 60 | 00:00:00 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-06 14:16:41.350000 |  |  |  | 205 CA615269 |  | 81 |  | 80 | 00:00:00 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-06 14:19:21.370000 |  |  |  | 205 CA615269 |  | 82 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 14:20:25.840000 |  |  |  | 205 CA615269 |  | 84 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 14:26:17.720000 |  |  |  | 205 CA615269 |  | 83 |  | 80 | 00:00:00 | Airport Approach Road, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 14:39:05.610000 |  |  |  | 205 CA615269 |  | 55 |  | 50 | 00:00:15 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 14:39:37.210000 |  |  |  | 205 CA615269 |  | 63 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 14:41:00.210000 |  |  |  | 205 CA615269 |  | 73 |  | 60 | 00:00:13 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 14:46:01.610000 |  |  |  | 205 CA615269 |  | 86 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 14:46:33.780000 |  |  |  | 205 CA615269 |  | 86 |  | 80 | 00:01:04 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:20:58.630000 |  |  |  | 205 CA615269 |  | 67 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:23:06.200000 |  |  |  | 205 CA615269 |  | 82 |  | 80 | 00:00:00 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 19:25:00.740000 |  |  |  | 205 CA615269 |  | 77 |  | 70 | 00:00:46 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:27:22.610000 |  |  |  | 205 CA615269 |  | 85 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 19:32:42.110000 |  |  |  | 205 CA615269 |  | 82 |  | 80 | 00:00:00 | Settlers Way, Montana, Cape Town, Western Cape
 | 2023-03-06 19:34:18.850000 |  |  |  | 205 CA615269 |  | 43 |  | 40 | 00:00:32 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:40:42.010000 |  |  |  | 205 CA615269 |  | 61 |  | 60 | 00:00:00 | [NAME], Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:40:50.670000 |  |  |  | 205 CA615269 |  | 73 |  | 50 | 00:00:56 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 19:42:02.540000 |  |  |  | 205 CA615269 |  | 75 |  | 60 | 00:00:13 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 19:47:38.460000 |  |  |  | 205 CA615269 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:48:33.460000 |  |  |  | 205 CA615269 |  | 63 |  | 60 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape