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: CC4 CA529411

 |  |  |  | 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
 | CC4 CA529411 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
 | 82 |  |  |  |  |  |  | 98km/h |  |  |  |  | 00h15m28s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-04 08:04:27.180000 |  |  |  | CC4 CA529411 |  | 43 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-04 10:19:06.880000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-04 18:10:33.390000 |  |  |  | CC4 CA529411 |  | 65 |  | 60 | 00:00:00 | Bhunga, Kewtown, Cape Town, Western Cape
 | 2023-03-04 20:01:15.050000 |  |  |  | CC4 CA529411 |  | 56 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 20:08:11.680000 |  |  |  | CC4 CA529411 |  | 63 |  | 60 | 00:00:00 | Settlers, [NAME], Cape Town, Western Cape
 | 2023-03-06 09:26:28.920000 |  |  |  | CC4 CA529411 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 09:40:16.840000 |  |  |  | CC4 CA529411 |  | 71 |  | 60 | 00:00:07 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-06 09:42:28.770000 |  |  |  | CC4 CA529411 |  | 62 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-06 09:45:40.060000 |  |  |  | CC4 CA529411 |  | 66 |  | 50 | 00:00:04 | Beach Road (M6), Three Anchor Bay, Cape Town, Western Cape
 | 2023-03-06 10:03:25.650000 |  |  |  | CC4 CA529411 |  | 77 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 10:03:27.670000 |  |  |  | CC4 CA529411 |  | 81 |  | 80 | 00:00:02 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 10:09:20.410000 |  |  |  | CC4 CA529411 |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 10:38:15.640000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | [NAME] | Malta Road (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 10:38:47.510000 |  |  |  | CC4 CA529411 |  | 61 |  | 60 | 00:00:00 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 10:42:21.070000 |  |  |  | CC4 CA529411 |  | 84 |  | 80 | 00:00:10 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 10:47:19.250000 |  |  |  | CC4 CA529411 |  | 92 |  | 80 | 00:01:36 | Settlers Way (N2), Montana, Cape Town, Western Cape
 | 2023-03-06 11:46:09.830000 |  |  |  | CC4 CA529411 |  | 60 |  | 50 | 00:01:08 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 11:47:34.290000 |  |  |  | CC4 CA529411 |  | 80 |  | 60 | 00:00:15 | Settlers, [NAME], Western Cape
 | 2023-03-06 11:51:01.200000 |  |  |  | CC4 CA529411 |  | 84 |  | 40 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 11:52:37.370000 |  |  |  | CC4 CA529411 |  | 87 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 11:56:21.090000 |  |  |  | CC4 CA529411 |  | 86 |  | 80 | 00:00:00 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-06 11:58:54.100000 |  |  |  | CC4 CA529411 |  | 67 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 13:41:33.830000 |  |  |  | CC4 CA529411 |  | 65 |  | 60 | 00:00:31 | [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-06 13:42:54.660000 |  |  |  | CC4 CA529411 |  | 82 |  | 80 | 00:00:00 | [NAME] (M3), Table Mountain, Cape Town, Western Cape
 | 2023-03-06 13:44:32.480000 |  |  |  | CC4 CA529411 |  | 61 |  | 60 | 00:00:01 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 13:50:22.460000 |  |  |  | CC4 CA529411 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 16:30:11.820000 |  |  |  | CC4 CA529411 |  | 65 |  | 60 | 00:00:17 | Malta, Observatory, Cape Town, Western Cape
 | 2023-03-06 17:14:49.670000 |  |  |  | CC4 CA529411 |  | 46 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 17:16:57.720000 |  |  |  | CC4 CA529411 |  | 47 |  | 40 | 00:00:25 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 17:42:50.300000 |  |  |  | CC4 CA529411 |  | 42 |  | 20 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 18:30:42.690000 |  |  |  | CC4 CA529411 |  | 53 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 18:31:46.270000 |  |  |  | CC4 CA529411 |  | 60 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 18:33:15.730000 |  |  |  | CC4 CA529411 |  | 73 |  | 60 | 00:00:13 | Settlers, [NAME], Western Cape
 | 2023-03-06 18:38:10.470000 |  |  |  | CC4 CA529411 |  | 98 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 18:39:46.400000 |  |  |  | CC4 CA529411 |  | 87 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 18:41:16.170000 |  |  |  | CC4 CA529411 |  | 83 |  | 80 | 00:00:24 | [NAME] (N2/M3), [NAME], Cape Town, Western Cape
 | 2023-03-06 18:42:26.940000 |  |  |  | CC4 CA529411 |  | 89 |  | 80 | 00:00:00 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 18:44:13.460000 |  |  |  | CC4 CA529411 |  | 78 |  | 70 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 18:44:34.450000 |  |  |  | CC4 CA529411 |  | 77 |  | 60 | 00:00:00 | [NAME] (N2), Cape Town, Cape Town, Western Cape
 | 2023-03-06 19:01:39.260000 |  |  |  | CC4 CA529411 |  | 71 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-06 19:02:43.510000 |  |  |  | CC4 CA529411 |  | 82 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:09:15.420000 |  |  |  | CC4 CA529411 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 06:03:48.320000 |  |  |  | CC4 CA529411 |  | 72 |  | 60 | 00:00:00 | 182 Voortrekker Road, Maitland, Cape Town, Western Cape
 | 2023-03-08 06:05:56.700000 |  |  |  | CC4 CA529411 |  | 82 |  | 80 | 00:00:00 | Black River, Maitland Garden Village, Cape Town, Western Cape
 | 2023-03-08 06:07:32.170000 |  |  |  | CC4 CA529411 |  | 87 |  | 80 | 00:00:14 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 06:14:15 |  |  |  | CC4 CA529411 |  | 62 |  | 60 | 00:00:00 | Borcherds [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 06:15:32.110000 |  |  |  | CC4 CA529411 |  | 67 |  | 60 | 00:00:00 | Borcherds [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 06:16:04.910000 |  |  |  | CC4 CA529411 |  | 62 |  | 60 | 00:00:00 | 19 Michigan Street, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 06:29:30.390000 |  |  |  | CC4 CA529411 |  | 57 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 07:03:36.870000 |  |  |  | CC4 CA529411 |  | 51 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 07:09:28.910000 |  |  |  | CC4 CA529411 |  | 45 |  | 40 | 00:02:08 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 07:12:16.220000 |  |  |  | CC4 CA529411 |  | 74 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-08 08:35:20.270000 |  |  |  | CC4 CA529411 |  | 85 |  | 80 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-08 08:36:44.010000 |  |  |  | CC4 CA529411 |  | 72 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 08:36:47.440000 |  |  |  | CC4 CA529411 |  | 71 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 08:37:08.060000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 08:47:51.800000 |  |  |  | CC4 CA529411 |  | 63 |  | 60 | 00:00:16 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-08 08:48:08.670000 |  |  |  | CC4 CA529411 |  | 68 |  | 60 | 00:00:15 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-08 08:50:16.630000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | 00:00:00 | Somerset, Green Point, Cape Town, Western Cape
 | 2023-03-08 09:12:07.280000 |  |  |  | CC4 CA529411 |  | 78 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 05:49:05.130000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-09 05:52:26.720000 |  |  |  | CC4 CA529411 |  | 74 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 05:57:46.020000 |  |  |  | CC4 CA529411 |  | 70 |  | 60 | 00:00:25 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-09 05:58:48.850000 |  |  |  | CC4 CA529411 |  | 66 |  | 60 | 00:00:02 | Portswood Road, Green Point, Cape Town, Western Cape
 | 2023-03-09 06:07:21.660000 |  |  |  | CC4 CA529411 |  | 74 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-09 06:08:01.170000 |  |  |  | CC4 CA529411 |  | 64 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 06:08:23.460000 |  |  |  | CC4 CA529411 |  | 68 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 06:08:26.240000 |  |  |  | CC4 CA529411 |  | 69 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 06:20:09.620000 |  |  |  | CC4 CA529411 |  | 82 |  | 80 | 00:00:00 | 13 Toledo Street, Montevideo, Cape Town, Western Cape
 | 2023-03-09 06:21:13.480000 |  |  |  | CC4 CA529411 |  | 76 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 06:26:04.740000 |  |  |  | CC4 CA529411 |  | 44 |  | 40 | 00:00:01 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 06:26:53.790000 |  |  |  | CC4 CA529411 |  | 56 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 06:28:57.580000 |  |  |  | CC4 CA529411 |  | 75 |  | 60 | 00:00:14 | Settlers, [NAME], Western Cape
 | 2023-03-09 06:35:10.590000 |  |  |  | CC4 CA529411 |  | 67 |  | 60 | 00:00:00 | Settlers, [NAME], Cape Town, Western Cape
 | 2023-03-09 06:55:50.280000 |  |  |  | CC4 CA529411 |  | 81 |  | 80 | 00:00:04 | [NAME] (M3), Woodstock, Cape Town, Western Cape
 | 2023-03-09 06:55:57.220000 |  |  |  | CC4 CA529411 |  | 82 |  | 80 | 00:00:03 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-09 08:10:10.460000 |  |  |  | CC4 CA529411 |  | 65 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 08:10:42.060000 |  |  |  | CC4 CA529411 |  | 53 |  | 40 | 00:00:32 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:14:58.760000 |  |  |  | CC4 CA529411 |  | 48 |  | 40 | 00:00:32 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:51:55.800000 |  |  |  | CC4 CA529411 |  | 63 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 08:53:17.370000 |  |  |  | CC4 CA529411 |  | 68 |  | 60 | 00:00:01 | Settlers Way (N2), [NAME], Western Cape
 | 2023-03-09 09:30:00.080000 |  |  |  | CC4 CA529411 |  | 66 |  | 60 | 00:00:01 | Black River, Maitland, Cape Town, Western Cape