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: 226 CAA54088

 |  |  |  | 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
 | 226 CAA54088 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
 | 113 |  |  |  |  |  |  | 100km/h |  |  |  |  | 00h16m18s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 14:35:01.940000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:02 | Rhodes, Observatory, Cape Town, Western Cape
 | 2023-03-03 18:59:10.740000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:00 | [NAME], [NAME], Cape Town, Western Cape
 | 2023-03-03 19:36:25.700000 |  |  |  | 226 CAA54088 |  | 59 |  | 50 | 00:00:00 | 113 High Level Road, Green Point, Cape Town, Western Cape
 | 2023-03-03 19:37:24.610000 |  |  |  | 226 CAA54088 |  | 57 |  | 50 | 00:00:09 | 27 High Level Road, Green Point, Cape Town, Western Cape
 | 2023-03-03 19:38:01.810000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:00 | Strand Street, Green Point, Cape Town, Western Cape
 | 2023-03-03 22:07:14.460000 |  |  |  | 226 CAA54088 |  | 70 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-03 22:11:36.480000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:11 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-03 22:45:34.670000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:02 | [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-03 22:59:50.810000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:10 | Newlands Avenue, Rondebosch, Cape Town, Western Cape
 | 2023-03-03 23:08:02.870000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 10:51:10.920000 |  |  |  | 226 CAA54088 |  | 88 |  | 80 | 00:00:04 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 10:57:38.930000 |  |  |  | 226 CAA54088 |  | 74 |  | 60 | [NAME] | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 11:00:49.510000 |  |  |  | 226 CAA54088 |  | 54 |  | 20 | 00:00:12 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 12:19:26.680000 |  |  |  | 226 CAA54088 |  | 64 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 12:19:58.380000 |  |  |  | 226 CAA54088 |  | 86 |  | 50 | 00:00:00 | Airport Approach Road, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 12:20:40.800000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:13 | Settlers Way, [NAME], Western Cape
 | 2023-03-04 12:25:50.660000 |  |  |  | 226 CAA54088 |  | 88 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 12:26:22.470000 |  |  |  | 226 CAA54088 |  | 85 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 12:32:08.800000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-04 15:03:11.660000 |  |  |  | 226 CAA54088 |  | 44 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-04 15:37:42.020000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | 115 [NAME], Gardens, Cape Town, Western Cape
 | 2023-03-04 15:49:34.860000 |  |  |  | 226 CAA54088 |  | 74 |  | 60 | 00:00:01 | 23 Strand Street, Cape Town, Western Cape
 | 2023-03-04 15:52:38.880000 |  |  |  | 226 CAA54088 |  | 81 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 15:57:26.470000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 07:24:42.940000 |  |  |  | 226 CAA54088 |  | 70 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 07:25:46.790000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | 289 [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-05 07:28:40.020000 |  |  |  | 226 CAA54088 |  | 91 |  | 80 | [NAME] | F.W. de Klerk Boulevard (N1), Cape Town, Cape Town, Western Cape
 | 2023-03-05 07:29:22.890000 |  |  |  | 226 CAA54088 |  | 68 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-05 07:29:43.300000 |  |  |  | 226 CAA54088 |  | 62 |  | 60 | 00:00:00 | Dock, Foreshore, Cape Town, Western Cape
 | 2023-03-05 10:41:47.680000 |  |  |  | 226 CAA54088 |  | 71 |  | 60 | 00:00:04 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-05 10:43:55.260000 |  |  |  | 226 CAA54088 |  | 86 |  | 80 | 00:00:00 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-05 10:44:54.310000 |  |  |  | 226 CAA54088 |  | 83 |  | 80 | 00:00:05 | [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-05 10:48:46.050000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | 46 Paradise Road, Newlands, Cape Town, Western Cape
 | 2023-03-05 10:51:59.150000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] der [NAME] (M3), Bishopscourt, Cape Town, Western Cape
 | 2023-03-05 10:57:56.310000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:08 | 35 Ladies Mile Road Extension , Constantia, Cape Town, Western Cape
 | 2023-03-05 13:11:54.530000 |  |  |  | 226 CAA54088 |  | 71 |  | 60 | 00:00:00 | Rhodes, Observatory, Cape Town, Western Cape
 | 2023-03-05 13:13:19.080000 |  |  |  | 226 CAA54088 |  | 85 |  | 80 | 00:00:03 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-05 13:13:51.570000 |  |  |  | 226 CAA54088 |  | 84 |  | 80 | 00:00:32 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 06:33:25.010000 |  |  |  | 226 CAA54088 |  | 71 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 08:10:24.770000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:17 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-06 08:37:46.020000 |  |  |  | 226 CAA54088 |  | 44 |  | 40 | 00:00:12 | The [NAME], Clifton, Cape Town, Western Cape
 | 2023-03-06 09:00:02.080000 |  |  |  | 226 CAA54088 |  | 42 |  | 40 | 00:00:00 | 107 Victoria Road, Bakoven, Cape Town, Western Cape
 | 2023-03-06 09:02:43.210000 |  |  |  | 226 CAA54088 |  | 62 |  | 40 | 00:00:17 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-06 09:03:24.330000 |  |  |  | 226 CAA54088 |  | 70 |  | 60 | 00:00:47 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:16.700000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:03 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:27.570000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:28.590000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:32.380000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:50.730000 |  |  |  | 226 CAA54088 |  | 62 |  | 60 | 00:00:03 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:54.580000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:04:55.270000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:05:00.280000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:05:03.290000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:05:04.300000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:08 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:05:31.910000 |  |  |  | 226 CAA54088 |  | 67 |  | 60 | 00:00:01 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:05:55.100000 |  |  |  | 226 CAA54088 |  | 64 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 09:10:15.270000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-06 09:17:34.760000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | [NAME] (M63), [NAME], Hout Bay, Western Cape
 | 2023-03-06 09:23:08.330000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | Constantia Main Road (M41), Witteboomen, Cape Town, Western Cape
 | 2023-03-06 09:23:40.430000 |  |  |  | 226 CAA54088 |  | 67 |  | 60 | 00:00:16 | Constantia Main Road (M41), Constantia, Cape Town, Western Cape
 | 2023-03-06 09:31:08.820000 |  |  |  | 226 CAA54088 |  | 83 |  | 60 | 00:00:12 | 21 La Rhone Road, Kirstenhof, Cape Town, Western Cape
 | 2023-03-06 09:46:36.470000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:02 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-06 09:55:08.820000 |  |  |  | 226 CAA54088 |  | 73 |  | 70 | 00:00:32 | Slangkop Road (M65), Ocean View, Cape Town, Western Cape
 | 2023-03-06 10:21:48.860000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | Cape Point, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 10:22:52.870000 |  |  |  | 226 CAA54088 |  | 71 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 10:24:28.760000 |  |  |  | 226 CAA54088 |  | 70 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 10:25:15.140000 |  |  |  | 226 CAA54088 |  | 70 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 13:26:35.190000 |  |  |  | 226 CAA54088 |  | 62 |  | 60 | 00:00:06 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 14:46:16.180000 |  |  |  | 226 CAA54088 |  | 71 |  | 60 | 00:00:00 | Main, Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-06 14:46:40.940000 |  |  |  | 226 CAA54088 |  | 64 |  | 60 | 00:00:00 | Main Road (M4), Cape Farms, [NAME]'s Town, Western Cape
 | 2023-03-06 14:47:20.710000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:00 | Main Road (M4), Marine Oil Refinery, [NAME]'s Town, Western Cape
 | 2023-03-06 14:49:28.240000 |  |  |  | 226 CAA54088 |  | 69 |  | 60 | 00:00:00 | [NAME] (M6), Glencairn, [NAME]'s Town, Western Cape
 | 2023-03-06 15:10:48.510000 |  |  |  | 226 CAA54088 |  | 84 |  | 60 | 00:00:00 | 15 La Rhone Road, Kirstenhof, Cape Town, Western Cape
 | 2023-03-06 15:15:04.870000 |  |  |  | 226 CAA54088 |  | 93 |  | 60 | 00:00:00 | [NAME] Stel, Barbarossa, Cape Town, Western Cape
 | 2023-03-06 17:25:39.260000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:05 | Rhodes, Kirstenbosch National Botanical Gardens, Cape Town, Western Cape
 | 2023-03-06 17:34:11.510000 |  |  |  | 226 CAA54088 |  | 84 |  | 80 | 00:00:32 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 18:20:03.460000 |  |  |  | 226 CAA54088 |  | 64 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 18:21:07.670000 |  |  |  | 226 CAA54088 |  | 72 |  | 60 | 00:00:00 | 164 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-06 18:23:47.550000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 03:22:36.890000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:01:04 | 170 New Market Street, Woodstock, Cape Town, Western Cape
 | 2023-03-07 04:03:27.380000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:02 | Jutland, Gardens, Cape Town, Western Cape
 | 2023-03-07 04:08:21.650000 |  |  |  | 226 CAA54088 |  | 65 |  | 60 | 00:00:01 | [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-07 04:09:21.480000 |  |  |  | 226 CAA54088 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 04:10:50.050000 |  |  |  | 226 CAA54088 |  | 82 |  | 80 | 00:00:08 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 04:16:17.560000 |  |  |  | 226 CAA54088 |  | 86 |  | 80 | 00:01:05 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-07 04:22:40.370000 |  |  |  | 226 CAA54088 |  | 47 |  | 20 | 00:00:01 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 04:22:54.020000 |  |  |  | 226 CAA54088 |  | 64 |  | 50 | 00:01:41 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 04:26:25.020000 |  |  |  | 226 CAA54088 |  | 95 |  | 60 | 00:00:00 | [NAME] (M7), [NAME], Cape Town, Western Cape
 | 2023-03-07 04:29:24.290000 |  |  |  | 226 CAA54088 |  | 92 |  | 80 | 00:00:45 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 04:31:12.100000 |  |  |  | 226 CAA54088 |  | 100 |  | 80 | 00:00:33 | Black River Parkway (M5), [NAME], Cape Town, Western Cape
 | 2023-03-07 04:33:53.510000 |  |  |  | 226 CAA54088 |  | 91 |  | 60 | 00:00:00 | 118 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-07 08:58:27.730000 |  |  |  | 226 CAA54088 |  | 86 |  | 80 | 00:00:32 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-07 08:59:31.320000 |  |  |  | 226 CAA54088 |  | 63 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-07 09:34:43.840000 |  |  |  | 226 CAA54088 |  | 66 |  | 60 | 00:00:00 | N1, 3.47 km SE of [NAME], Western Cape
 | 2023-03-07 09:55:31.560000 |  |  |  | 226 CAA54088 |  | 85 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 09:57:07.870000 |  |  |  | 226 CAA54088 |  | 82 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 09:57:39.380000 |  |  |  | 226 CAA54088 |  | 81 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 11:26:17.790000 |  |  |  | 226 CAA54088 |  | 82 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 11:27:53.080000 |  |  |  | 226 CAA54088 |  | 81 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-07 16:22:17.020000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:32 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 09:08:42.320000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-08 09:18:18.540000 |  |  |  | 226 CAA54088 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:18:52.450000 |  |  |  | 226 CAA54088 |  | 30 |  | 20 | 00:00:14 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:19:17.070000 |  |  |  | 226 CAA54088 |  | 37 |  | 20 | 00:00:09 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:22:03.390000 |  |  |  | 226 CAA54088 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:22:34.260000 |  |  |  | 226 CAA54088 |  | 46 |  | 40 | 00:00:32 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:37:06.590000 |  |  |  | 226 CAA54088 |  | 37 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:40:42.460000 |  |  |  | 226 CAA54088 |  | 31 |  | 20 | 00:00:08 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:41:17.580000 |  |  |  | 226 CAA54088 |  | 32 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:45:38.430000 |  |  |  | 226 CAA54088 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-08 09:46:10.890000 |  |  |  | 226 CAA54088 |  | 45 |  | 40 | 00:00:01 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-08 15:00:53.370000 |  |  |  | 226 CAA54088 |  | 61 |  | 60 | 00:00:36 | 205 [NAME], Muizenberg, Cape Town, Western Cape
 | 2023-03-08 15:08:53.920000 |  |  |  | 226 CAA54088 |  | 75 |  | 60 | 00:00:00 | [NAME] Stel, Kirstenhof, Cape Town, Western Cape