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: 229 CAA95883

 |  |  |  | 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
 | 229 CAA95883 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
 | 108 |  |  |  |  |  |  | 101km/h |  |  |  |  | 00h38m00s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 09:30:34.300000 |  |  |  | 229 [NAME] |  | 46 |  | 40 | 00:00:16 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-03 10:05:14.400000 |  |  |  | 229 [NAME] |  | 37 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 10:08:26.520000 |  |  |  | 229 [NAME] |  | 42 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 10:29:46.310000 |  |  |  | 229 [NAME] |  | 42 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 10:31:22.890000 |  |  |  | 229 [NAME] |  | 39 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 10:40:26.940000 |  |  |  | 229 [NAME] |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-03 10:41:30.670000 |  |  |  | 229 [NAME] |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-03 10:43:06.830000 |  |  |  | 229 [NAME] |  | 72 |  | 70 | 00:00:00 | [NAME] (M6), Meadowsteads, Noordhoek, Western Cape
 | 2023-03-03 10:53:50.930000 |  |  |  | 229 [NAME] |  | 71 |  | 70 | 00:00:28 | Slangkop, Ocean View, Cape Town, Western Cape
 | 2023-03-03 10:54:50.740000 |  |  |  | 229 [NAME] |  | 79 |  | 70 | 00:00:00 | Slangkop, Ocean View, Cape Town, Western Cape
 | 2023-03-03 16:35:19.720000 |  |  |  | 229 [NAME] |  | 64 |  | 60 | 00:01:36 | Main, Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-03 16:39:03.660000 |  |  |  | 229 [NAME] |  | 61 |  | 60 | 00:00:00 | Simonstown, [NAME], [NAME]'s Town, Western Cape
 | 2023-03-03 16:54:31.020000 |  |  |  | 229 [NAME] |  | 61 |  | 60 | 00:00:00 | 24 Verwood Road, Lakeside, Cape Town, Western Cape
 | 2023-03-03 17:07:19.640000 |  |  |  | 229 [NAME] |  | 64 |  | 60 | 00:00:00 | [NAME] Stel, Wynberg, Cape Town, Western Cape
 | 2023-03-03 17:07:29.300000 |  |  |  | 229 [NAME] |  | 61 |  | 60 | 00:00:04 | [NAME] der [NAME] (M3), Bishopscourt, Cape Town, Western Cape
 | 2023-03-03 17:13:32.360000 |  |  |  | 229 [NAME] |  | 62 |  | 40 | 00:00:00 | Rugby, Rondebosch, Cape Town, Western Cape
 | 2023-03-03 17:16:55.570000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:00 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-03 17:20:07.850000 |  |  |  | 229 [NAME] |  | 75 |  | 60 | 00:00:00 | Cape Town, Cape Town, Western Cape
 | 2023-03-03 17:26:31.370000 |  |  |  | 229 [NAME] |  | 42 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-03 17:43:01.340000 |  |  |  | 229 [NAME] |  | 67 |  | 60 | 00:00:02 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-03 18:11:18.500000 |  |  |  | 229 [NAME] |  | 64 |  | 60 | 00:00:33 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-03 18:17:11.770000 |  |  |  | 229 [NAME] |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:14:06.640000 |  |  |  | 229 [NAME] |  | 71 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:22:06.280000 |  |  |  | 229 [NAME] |  | 63 |  | 60 | 00:00:32 | 82 New Market Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 07:31:56.770000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:20 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-04 08:25:57.710000 |  |  |  | 229 [NAME] |  | 76 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-04 08:30:06.530000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:31:10.190000 |  |  |  | 229 [NAME] |  | 66 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 08:32:01.260000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | 00:00:13 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:38:06.380000 |  |  |  | 229 [NAME] |  | 65 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 08:51:26.700000 |  |  |  | 229 [NAME] |  | 50 |  | 20 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 08:53:34.430000 |  |  |  | 229 [NAME] |  | 76 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-04 08:58:22.810000 |  |  |  | 229 [NAME] |  | 82 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:59:58.530000 |  |  |  | 229 [NAME] |  | 66 |  | 60 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-04 09:07:26.750000 |  |  |  | 229 [NAME] |  | 67 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 07:42:49.170000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 07:49:13.910000 |  |  |  | 229 [NAME] |  | 73 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:57:29.030000 |  |  |  | 229 [NAME] |  | 61 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:58:54.430000 |  |  |  | 229 [NAME] |  | 70 |  | 60 | 00:00:02 | Settlers, [NAME], Western Cape
 | 2023-03-06 09:43:32.220000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 10:12:41.330000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 18:05:11.480000 |  |  |  | 229 [NAME] |  | 68 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 18:22:15.550000 |  |  |  | 229 [NAME] |  | 87 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-06 18:37:11.450000 |  |  |  | 229 [NAME] |  | 63 |  | 60 | 00:00:00 | [NAME], Plankenbrug, [NAME], Western Cape
 | 2023-03-06 18:40:49.890000 |  |  |  | 229 [NAME] |  | 62 |  | 60 | 00:00:06 | Helshoogte, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 18:43:35.170000 |  |  |  | 229 [NAME] |  | 66 |  | 60 | 00:00:00 | Helshoogte, Idas Valley, Stellenbosch, Western Cape
 | 2023-03-06 18:51:03.900000 |  |  |  | 229 [NAME] |  | 63 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Franschhoek, Western Cape
 | 2023-03-06 19:02:15.930000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:02:40 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-06 19:44:23.760000 |  |  |  | 229 [NAME] |  | 90 |  | 80 | [NAME] | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-06 19:53:59.270000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | 00:00:00 | R45, 8.1 km NE of Kylemore, Western Cape
 | 2023-03-06 20:27:35.840000 |  |  |  | 229 [NAME] |  | 83 |  | 60 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-06 20:47:51.940000 |  |  |  | 229 [NAME] |  | 70 |  | 60 | 00:00:32 | 120 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-06 20:49:59.290000 |  |  |  | 229 [NAME] |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 06:40:02.380000 |  |  |  | 229 [NAME] |  | 95 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-07 06:43:46.380000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:00:00 | N1, North Camp Wingfield, Goodwood, Western Cape
 | 2023-03-07 07:07:46.920000 |  |  |  | 229 [NAME] |  | 66 |  | 60 | 00:00:00 | [NAME], Stellenbosch NU Outlying, [NAME], Western Cape
 | 2023-03-07 07:11:05.180000 |  |  |  | 229 [NAME] |  | 66 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-07 07:16:50.120000 |  |  |  | 229 [NAME] |  | 67 |  | 60 | 00:00:00 | R45, 8.37 km SE of Klapmuts, Western Cape
 | 2023-03-07 07:23:41.250000 |  |  |  | 229 [NAME] |  | 94 |  | 60 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-07 07:26:26.650000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 08:30:29.470000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:02:40 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 08:34:45.780000 |  |  |  | 229 [NAME] |  | 88 |  | 80 | 00:00:32 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-07 08:36:53.110000 |  |  |  | 229 [NAME] |  | 82 |  | 80 | 00:00:32 | [NAME] (R301), [NAME], Franschhoek, Western Cape
 | 2023-03-07 08:39:33.460000 |  |  |  | 229 [NAME] |  | 90 |  | 80 | 00:00:32 | [NAME] (R301), 10.52 km NE of Kylemore, Western Cape
 | 2023-03-07 10:57:11.830000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | 00:00:00 | [NAME] (R301), 10.08 km NE of Kylemore, Western Cape
 | 2023-03-07 10:58:47.730000 |  |  |  | 229 [NAME] |  | 86 |  | 80 | 00:00:00 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-07 11:00:23.600000 |  |  |  | 229 [NAME] |  | 83 |  | 80 | 00:00:00 | [NAME] (R301), [NAME], Franschhoek, Western Cape
 | 2023-03-07 11:03:03.080000 |  |  |  | 229 [NAME] |  | 89 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:21:18.280000 |  |  |  | 229 [NAME] |  | 91 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:29:18.270000 |  |  |  | 229 [NAME] |  | 85 |  | 80 | 00:00:32 | [NAME], 10.6 km NE of Kylemore, Western Cape
 | 2023-03-07 15:59:14.140000 |  |  |  | 229 [NAME] |  | 85 |  | 80 | 00:01:04 | [NAME], 11.04 km NE of Kylemore, Western Cape
 | 2023-03-07 16:06:42.510000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-07 17:33:07.330000 |  |  |  | 229 [NAME] |  | 85 |  | 80 | 00:03:44 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-07 18:19:31.650000 |  |  |  | 229 [NAME] |  | 83 |  | 60 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-07 18:41:55.220000 |  |  |  | 229 [NAME] |  | 79 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 18:43:31.700000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 06:54:50.430000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:00:00 | N1, North Camp Wingfield, Goodwood, Western Cape
 | 2023-03-08 06:55:54.080000 |  |  |  | 229 [NAME] |  | 95 |  | 60 | 00:00:00 | [NAME], [NAME], Goodwood, Western Cape
 | 2023-03-08 07:41:14.580000 |  |  |  | 229 [NAME] |  | 87 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 08:44:56.910000 |  |  |  | 229 [NAME] |  | 88 |  | 80 | 00:01:04 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 15:02:04.650000 |  |  |  | 229 [NAME] |  | 63 |  | 60 | 00:00:32 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:04:44.440000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:00 | Helshoogte, Idas Valley, Stellenbosch, Western Cape
 | 2023-03-08 15:08:37.880000 |  |  |  | 229 [NAME] |  | 63 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:11:08.870000 |  |  |  | 229 [NAME] |  | 73 |  | 60 | 00:00:00 | Helshoogte, [NAME], Franschhoek, Western Cape
 | 2023-03-08 15:24:28.240000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:01:04 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-08 15:26:37.680000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:00 | [NAME] (R301), [NAME], Franschhoek, Western Cape
 | 2023-03-08 15:27:40.020000 |  |  |  | 229 [NAME] |  | 86 |  | 80 | 00:00:00 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:00:44.200000 |  |  |  | 229 [NAME] |  | 85 |  | 80 | 00:00:00 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:03:24.550000 |  |  |  | 229 [NAME] |  | 95 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:03:56.700000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 18:01:04.220000 |  |  |  | 229 [NAME] |  | 84 |  | 80 | [NAME] | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 18:11:44.530000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:00 | R45, 8.13 km NE of Kylemore, Western Cape
 | 2023-03-08 18:21:52.520000 |  |  |  | 229 [NAME] |  | 68 |  | 60 | 00:00:00 | [NAME] (R44), Stellenbosch NU Outlying, [NAME], Western Cape
 | 2023-03-08 18:47:28.740000 |  |  |  | 229 [NAME] |  | 75 |  | 60 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-08 19:11:28.840000 |  |  |  | 229 [NAME] |  | 69 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 19:13:04.340000 |  |  |  | 229 [NAME] |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 04:42:47.450000 |  |  |  | 229 [NAME] |  | 96 |  | 80 | 00:00:00 | N1, North Camp Wingfield, Goodwood, Western Cape
 | 2023-03-09 04:46:31.170000 |  |  |  | 229 [NAME] |  | 96 |  | 60 | 00:00:00 | N1, [NAME], Parow, Western Cape
 | 2023-03-09 05:09:59.110000 |  |  |  | 229 [NAME] |  | 101 |  | 100 | 00:00:00 | R45, 6.85 km SE of Klapmuts, Western Cape
 | 2023-03-09 05:11:03.130000 |  |  |  | 229 [NAME] |  | 67 |  | 60 | 00:00:00 | R45, 8.37 km SE of Klapmuts, Western Cape
 | 2023-03-09 05:19:03 |  |  |  | 229 [NAME] |  | 95 |  | 80 | 00:04:16 | Huguenot Road (R45), Wemmershoek Forest Reserve, Franschhoek, Western Cape
 | 2023-03-09 06:09:11.020000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | [NAME] | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-09 06:26:47.250000 |  |  |  | 229 [NAME] |  | 71 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-09 06:43:51.920000 |  |  |  | 229 [NAME] |  | 91 |  | 60 | 00:00:32 | R312, 1.35 km NE of Fisantkraal, Western Cape
 | 2023-03-09 06:47:03.350000 |  |  |  | 229 [NAME] |  | 81 |  | 80 | 00:00:00 | [NAME] (R302), Fisantkraal, Western Cape
 | 2023-03-09 07:07:50.300000 |  |  |  | 229 [NAME] |  | 62 |  | 60 | 00:00:00 | 45 Vissershok Road, [NAME], Durbanville, Western Cape
 | 2023-03-09 07:09:27.620000 |  |  |  | 229 [NAME] |  | 61 |  | 60 | 00:00:00 | 11 Rooivalk Close, [NAME], Western Cape
 | 2023-03-09 10:21:42.490000 |  |  |  | 229 [NAME] |  | 70 |  | 60 | 00:00:00 | [NAME] (R27), Metro Industrial Township, Milnerton, Western Cape