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: 225 CAA54103

 |  |  |  | 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
 | 225 CAA54103 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
 | 98 |  |  |  |  |  |  | 102km/h |  |  |  |  | 00h33m07s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 10:54:49.080000 |  |  |  | 225 CAA54103 |  | 62 |  | 60 | 00:00:00 | 32 Paradise Road, Newlands, Cape Town, Western Cape
 | 2023-03-03 11:04:25.730000 |  |  |  | 225 CAA54103 |  | 74 |  | 60 | 00:00:00 | 21 La Rhone Road, Kirstenhof, Cape Town, Western Cape
 | 2023-03-03 11:19:21.250000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-03 13:22:00.310000 |  |  |  | 225 CAA54103 |  | 102 |  | 100 | 00:00:00 | [NAME] Stel, Tokai, Cape Town, Western Cape
 | 2023-03-03 16:44:31.430000 |  |  |  | 225 CAA54103 |  | 81 |  | 80 | 00:00:00 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-03 16:47:07.300000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-03 16:47:13.850000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-03 16:47:22.900000 |  |  |  | 225 CAA54103 |  | 75 |  | 60 | 00:00:21 | Cape Town, Cape Town, Western Cape
 | 2023-03-03 22:08:03.850000 |  |  |  | 225 CAA54103 |  | 88 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-03 22:12:19.300000 |  |  |  | 225 CAA54103 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 06:53:54.900000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 06:54:58.040000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 08:23:59.360000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:27 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-04 08:41:13.930000 |  |  |  | 225 CAA54103 |  | 43 |  | 40 | 00:00:00 | 38 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-04 09:03:05.190000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:13 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:03:22.550000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:03:32.310000 |  |  |  | 225 CAA54103 |  | 62 |  | 60 | 00:00:01 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:04:26.630000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:05:55.290000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:06:23.710000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:10:50.620000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:47 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-04 09:19:22.800000 |  |  |  | 225 CAA54103 |  | 34 |  | 20 | 00:00:03 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:19:42.410000 |  |  |  | 225 CAA54103 |  | 35 |  | 20 | 00:00:44 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:20:58.750000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:21:18.670000 |  |  |  | 225 CAA54103 |  | 42 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:24:07.710000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:25:14.530000 |  |  |  | 225 CAA54103 |  | 38 |  | 20 | 00:00:33 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:26:12.340000 |  |  |  | 225 CAA54103 |  | 33 |  | 20 | 00:00:06 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:40:04.070000 |  |  |  | 225 CAA54103 |  | 65 |  | 60 | 00:00:12 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:40:19.530000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:05 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:41:46.060000 |  |  |  | 225 CAA54103 |  | 66 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:43:01.810000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:21 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 10:12:42.610000 |  |  |  | 225 CAA54103 |  | 46 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-04 18:26:39.760000 |  |  |  | 225 CAA54103 |  | 43 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-04 18:49:26.270000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:09 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-04 19:20:51.540000 |  |  |  | 225 CAA54103 |  | 92 |  | 80 | 00:00:12 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 09:59:29.180000 |  |  |  | 225 CAA54103 |  | 75 |  | 60 | 00:00:13 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-05 10:00:28.560000 |  |  |  | 225 CAA54103 |  | 82 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-05 10:06:38.390000 |  |  |  | 225 CAA54103 |  | 69 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-05 10:13:06.430000 |  |  |  | 225 CAA54103 |  | 53 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 10:13:36.700000 |  |  |  | 225 CAA54103 |  | 51 |  | 50 | 00:00:30 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 10:15:06.890000 |  |  |  | 225 CAA54103 |  | 65 |  | 60 | 00:00:15 | Settlers, [NAME], Western Cape
 | 2023-03-05 11:24:06.460000 |  |  |  | 225 CAA54103 |  | 91 |  | 80 | 00:00:00 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-05 11:50:43.420000 |  |  |  | 225 CAA54103 |  | 51 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 12:44:22.400000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:03 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 12:53:23.510000 |  |  |  | 225 CAA54103 |  | 46 |  | 20 | 00:00:23 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 12:54:32.130000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 12:54:56.080000 |  |  |  | 225 CAA54103 |  | 45 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 13:09:46.390000 |  |  |  | 225 CAA54103 |  | 68 |  | 60 | 00:00:00 | Settlers Way (N2), Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 13:25:46.380000 |  |  |  | 225 CAA54103 |  | 79 |  | 70 | 00:00:00 | N2, Somerset West, [NAME]
 | 2023-03-05 13:43:54.540000 |  |  |  | 225 CAA54103 |  | 62 |  | 60 | 00:00:00 | Sir [NAME]'s Pass Road, Mountainside Estate, Strand, Western Cape
 | 2023-03-05 14:37:14.110000 |  |  |  | 225 CAA54103 |  | 84 |  | 60 | 00:00:00 | Main Road (R44), 2.96 km NE of [NAME], Western Cape
 | 2023-03-05 15:01:46.490000 |  |  |  | 225 CAA54103 |  | 65 |  | 60 | 00:00:00 | R320, Sandbaai, Hermanus, Western Cape
 | 2023-03-05 15:02:06.640000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:00 | R320, Hermanus, Hermanus, Western Cape
 | 2023-03-05 15:02:22.570000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:01 | R320, 3.39 km NW of Hermanus, Western Cape
 | 2023-03-05 15:02:47.900000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:01:39 | R320, 3.07 km NW of Hermanus, Western Cape
 | 2023-03-05 15:04:58.670000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:00 | R320, 3.7 km NW of Hermanus, Western Cape
 | 2023-03-05 15:12:58.130000 |  |  |  | 225 CAA54103 |  | 84 |  | 60 | 00:01:04 | R320, 7.51 km NE of Hermanus, Western Cape
 | 2023-03-05 17:10:38.720000 |  |  |  | 225 CAA54103 |  | 80 |  | 60 | 00:02:40 | R320, 8.76 km NE of Hermanus, Western Cape
 | 2023-03-05 17:24:30.900000 |  |  |  | 225 CAA54103 |  | 61 |  | 40 | 00:00:05 | R320, 4.75 km N of Hermanus, Western Cape
 | 2023-03-05 17:26:24.870000 |  |  |  | 225 CAA54103 |  | 68 |  | 60 | 00:00:41 | R320, 3.67 km NW of Hermanus, Western Cape
 | 2023-03-06 11:11:57.630000 |  |  |  | 225 CAA54103 |  | 62 |  | 60 | 00:00:00 | R320, Sandbaai, Hermanus, Western Cape
 | 2023-03-06 11:12:39.580000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | R320, 3.35 km NW of Hermanus, Western Cape
 | 2023-03-06 11:13:24.180000 |  |  |  | 225 CAA54103 |  | 73 |  | 60 | 00:01:45 | R320, 3.06 km NW of Hermanus, Western Cape
 | 2023-03-06 15:52:04.410000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | R320, 3.63 km NW of Hermanus, Western Cape
 | 2023-03-06 15:55:16.840000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:00:00 | R320, Sandbaai, Hermanus, Western Cape
 | 2023-03-06 18:04:52.280000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:40 | R320, Sandbaai, Hermanus, Western Cape
 | 2023-03-06 18:06:28.640000 |  |  |  | 225 CAA54103 |  | 72 |  | 60 | 00:01:36 | R320, 3.09 km NW of Hermanus, Western Cape
 | 2023-03-06 18:09:47.110000 |  |  |  | 225 CAA54103 |  | 45 |  | 40 | 00:00:14 | R320, 4.69 km N of Hermanus, Western Cape
 | 2023-03-06 18:12:52.610000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | R320, 5.95 km NE of Hermanus, Western Cape
 | 2023-03-06 18:21:56.070000 |  |  |  | 225 CAA54103 |  | 61 |  | 60 | 00:02:40 | R320, 6.31 km NE of Hermanus, Western Cape
 | 2023-03-06 18:27:16.160000 |  |  |  | 225 CAA54103 |  | 83 |  | 80 | 00:00:00 | R320, 11.77 km NE of Hermanus, Western Cape
 | 2023-03-06 18:34:44.310000 |  |  |  | 225 CAA54103 |  | 93 |  | 90 | 00:02:40 | R320, 9.67 km NE of Hermanus, Western Cape
 | 2023-03-06 18:44:56.300000 |  |  |  | 225 CAA54103 |  | 66 |  | 60 | 00:00:00 | R320, 5.44 km NE of Hermanus, Western Cape
 | 2023-03-06 18:46:14.800000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | R320, 4.88 km N of Hermanus, Western Cape
 | 2023-03-06 18:46:40.800000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | R320, 4.66 km N of Hermanus, Western Cape
 | 2023-03-06 22:07:54.200000 |  |  |  | 225 CAA54103 |  | 44 |  | 40 | 00:00:00 | R320, 4.83 km N of Hermanus, Western Cape
 | 2023-03-07 09:34:13.850000 |  |  |  | 225 CAA54103 |  | 70 |  | 60 | 00:00:00 | R320, 3.05 km NW of Hermanus, Western Cape
 | 2023-03-07 09:34:45.620000 |  |  |  | 225 CAA54103 |  | 70 |  | 60 | 00:01:04 | R320, 3.11 km NW of Hermanus, Western Cape
 | 2023-03-07 09:43:54.590000 |  |  |  | 225 CAA54103 |  | 41 |  | 40 | 00:00:00 | R320, 4.88 km N of Hermanus, Western Cape
 | 2023-03-07 09:46:29.090000 |  |  |  | 225 CAA54103 |  | 64 |  | 60 | 00:00:00 | R320, 5.82 km NE of Hermanus, Western Cape
 | 2023-03-07 11:28:50.580000 |  |  |  | 225 CAA54103 |  | 92 |  | 90 | 00:02:40 | R320, 9.49 km NE of Hermanus, Western Cape
 | 2023-03-07 11:51:46.440000 |  |  |  | 225 CAA54103 |  | 84 |  | 70 | 00:02:40 | R43, 5.11 km NE of Fisherhaven, Western Cape
 | 2023-03-07 11:56:02.730000 |  |  |  | 225 CAA54103 |  | 75 |  | 70 | 00:01:04 | R43, 4.91 km SW of Botrivier, Western Cape
 | 2023-03-07 12:07:14.390000 |  |  |  | 225 CAA54103 |  | 81 |  | 80 | 00:00:00 | N2, 6.61 km NW of Botrivier, Western Cape
 | 2023-03-07 16:07:00.770000 |  |  |  | 225 CAA54103 |  | 68 |  | 60 | 00:00:00 | [NAME] (M7), Philippi AH, [NAME]'s Plain, Western Cape
 | 2023-03-07 16:21:57.010000 |  |  |  | 225 CAA54103 |  | 73 |  | 60 | 00:00:00 | Camp, Youngsfield, Cape Town, Western Cape
 | 2023-03-07 18:52:24.910000 |  |  |  | 225 CAA54103 |  | 83 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 18:52:56.200000 |  |  |  | 225 CAA54103 |  | 86 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 18:56:40.760000 |  |  |  | 225 CAA54103 |  | 97 |  | 60 | 00:00:00 | Settlers, Heideveld, Cape Town, Western Cape
 | 2023-03-07 20:05:28.270000 |  |  |  | 225 CAA54103 |  | 67 |  | 60 | 00:00:00 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 18:54:32 |  |  |  | 225 CAA54103 |  | 74 |  | 60 | 00:02:08 | Stellenrust, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 18:58:48.420000 |  |  |  | 225 CAA54103 |  | 68 |  | 60 | 00:01:36 | Stellenrust, Steynsrust, [NAME], Western Cape
 | 2023-03-08 22:33:58.370000 |  |  |  | 225 CAA54103 |  | 68 |  | 60 | 00:00:00 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 22:35:34.810000 |  |  |  | 225 CAA54103 |  | 63 |  | 60 | 00:00:00 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 23:05:26.140000 |  |  |  | 225 CAA54103 |  | 77 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-09 11:10:02.660000 |  |  |  | 225 CAA54103 |  | 85 |  | 40 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 11:28:42.920000 |  |  |  | 225 CAA54103 |  | 90 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape