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: 227 CAA54093

 |  |  |  | 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
 | 227 CAA54093 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
 | 97 |  |  |  |  |  |  | 92km/h |  |  |  |  | 00h18m48s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 14:54:21.270000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | 00:00:00 | Woolsack, [NAME], Cape Town, Western Cape
 | 2023-03-03 22:07:11.890000 |  |  |  | 227 CAA54093 |  | 51 |  | 50 | 00:00:00 | Beach, Sea Point, Cape Town, Western Cape
 | 2023-03-03 22:13:35.750000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-03 22:46:39.930000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:32 | 214 [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:56:44.020000 |  |  |  | 227 CAA54093 |  | 71 |  | 60 | 00:00:00 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-04 10:10:31.050000 |  |  |  | 227 CAA54093 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 11:28:03.740000 |  |  |  | 227 CAA54093 |  | 63 |  | 60 | 00:00:00 | [NAME] (M7), [NAME], Cape Town, Western Cape
 | 2023-03-04 11:33:55.670000 |  |  |  | 227 CAA54093 |  | 85 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-05 07:25:30.900000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | 60 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-05 08:16:57.610000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-05 08:56:11.670000 |  |  |  | 227 CAA54093 |  | 63 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-05 10:38:41.880000 |  |  |  | 227 CAA54093 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-05 10:39:11.020000 |  |  |  | 227 CAA54093 |  | 36 |  | 20 | 00:00:33 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 10:43:00.840000 |  |  |  | 227 CAA54093 |  | 44 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-05 10:57:24.590000 |  |  |  | 227 CAA54093 |  | 42 |  | 40 | [NAME] | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 10:58:53.340000 |  |  |  | 227 CAA54093 |  | 42 |  | 40 | 00:00:07 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 11:03:16.350000 |  |  |  | 227 CAA54093 |  | 31 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 11:03:48.500000 |  |  |  | 227 CAA54093 |  | 30 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 11:07:31.520000 |  |  |  | 227 CAA54093 |  | 43 |  | 40 | 00:00:01 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-05 11:08:04.430000 |  |  |  | 227 CAA54093 |  | 63 |  | 40 | 00:00:03 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-05 11:09:01.470000 |  |  |  | 227 CAA54093 |  | 74 |  | 70 | [NAME] | [NAME], Meadowsteads, Noordhoek, Western Cape
 | 2023-03-05 11:10:12.300000 |  |  |  | 227 CAA54093 |  | 71 |  | 70 | 00:00:00 | [NAME], [NAME], Noordhoek, Western Cape
 | 2023-03-05 11:11:48.430000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-05 11:19:48.120000 |  |  |  | 227 CAA54093 |  | 67 |  | 60 | 00:00:00 | Main, Cape Farms, [NAME]'s Town, Western Cape
 | 2023-03-05 16:34:14.580000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | Witsand Road (M65), [NAME], Scarborough, Western Cape
 | 2023-03-05 16:40:00.800000 |  |  |  | 227 CAA54093 |  | 74 |  | 70 | 00:00:38 | Slangkop Road (M65), Ocean View, Cape Town, Western Cape
 | 2023-03-05 16:47:02.710000 |  |  |  | 227 CAA54093 |  | 70 |  | 60 | 00:00:00 | [NAME] (M65), Sunnydale, [NAME], Western Cape
 | 2023-03-05 17:52:05.910000 |  |  |  | 227 CAA54093 |  | 69 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 08:23:13.120000 |  |  |  | 227 CAA54093 |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 10:04:26.330000 |  |  |  | 227 CAA54093 |  | 75 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 10:06:02.420000 |  |  |  | 227 CAA54093 |  | 83 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-06 10:42:18.140000 |  |  |  | 227 CAA54093 |  | 83 |  | 80 | 00:00:00 | Suid Agter Paarl Road (R44), 6.07 km SW of Paarl, Western Cape
 | 2023-03-06 14:45:47.250000 |  |  |  | 227 CAA54093 |  | 82 |  | 80 | 00:00:00 | Strand, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 14:53:16.630000 |  |  |  | 227 CAA54093 |  | 76 |  | 60 | 00:00:00 | Broadway, [NAME], [NAME], Western Cape
 | 2023-03-06 14:57:32.630000 |  |  |  | 227 CAA54093 |  | 63 |  | 60 | 00:00:00 | Broadway, The Links SH, [NAME]
 | 2023-03-06 16:33:52.450000 |  |  |  | 227 CAA54093 |  | 88 |  | 80 | 00:00:15 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 16:35:28.750000 |  |  |  | 227 CAA54093 |  | 87 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 16:38:40.940000 |  |  |  | 227 CAA54093 |  | 79 |  | 60 | 00:00:00 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 16:40:16.040000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 17:20:44.160000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 06:16:31.880000 |  |  |  | 227 CAA54093 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 06:19:36.120000 |  |  |  | 227 CAA54093 |  | 63 |  | 60 | 00:00:07 | 66 New Market Street, Foreshore, Cape Town, Western Cape
 | 2023-03-07 06:20:32.910000 |  |  |  | 227 CAA54093 |  | 67 |  | 60 | 00:00:15 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-07 07:12:28.290000 |  |  |  | 227 CAA54093 |  | 82 |  | 80 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-07 07:16:43.880000 |  |  |  | 227 CAA54093 |  | 88 |  | 80 | 00:00:06 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 07:23:13.220000 |  |  |  | 227 CAA54093 |  | 50 |  | 40 | [NAME] | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 07:24:11.410000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 07:54:08.280000 |  |  |  | 227 CAA54093 |  | 52 |  | 50 | 00:01:09 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 08:35:47.860000 |  |  |  | 227 CAA54093 |  | 76 |  | 60 | 00:00:02 | Liesbeek, Observatory, Cape Town, Western Cape
 | 2023-03-07 08:37:17.530000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-07 08:37:57.670000 |  |  |  | 227 CAA54093 |  | 67 |  | 60 | 00:00:00 | 36 Malta Road, Observatory, City Bowl, Cape Town, Western Cape
 | 2023-03-07 08:40:37.370000 |  |  |  | 227 CAA54093 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 16:19:35.920000 |  |  |  | 227 CAA54093 |  | 56 |  | 50 | 00:00:00 | 96 High Level Road, Green Point, Cape Town, Western Cape
 | 2023-03-08 07:30:15.770000 |  |  |  | 227 CAA54093 |  | 70 |  | 60 | 00:00:00 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 07:31:19.070000 |  |  |  | 227 CAA54093 |  | 75 |  | 60 | 00:02:08 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 13:29:11.910000 |  |  |  | 227 CAA54093 |  | 81 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 13:30:47.230000 |  |  |  | 227 CAA54093 |  | 85 |  | 80 | 00:00:32 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 14:57:59.360000 |  |  |  | 227 CAA54093 |  | 89 |  | 80 | 00:02:40 | [NAME] (R44), [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:09:43.560000 |  |  |  | 227 CAA54093 |  | 65 |  | 60 | 00:00:00 | Strand, Krigeville, Stellenbosch, Western Cape
 | 2023-03-08 15:26:29.430000 |  |  |  | 227 CAA54093 |  | 77 |  | 60 | 00:00:00 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:28:55.530000 |  |  |  | 227 CAA54093 |  | 68 |  | 60 | 00:01:04 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:32:39.380000 |  |  |  | 227 CAA54093 |  | 92 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:33:43.360000 |  |  |  | 227 CAA54093 |  | 91 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 15:54:31.180000 |  |  |  | 227 CAA54093 |  | 83 |  | 80 | 00:00:15 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 15:56:07.890000 |  |  |  | 227 CAA54093 |  | 82 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-08 15:59:19.910000 |  |  |  | 227 CAA54093 |  | 81 |  | 80 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-08 16:28:10 |  |  |  | 227 CAA54093 |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 10:20:21.100000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | 00:00:00 | 107 Victoria Road, Bakoven, Cape Town, Western Cape
 | 2023-03-09 10:22:25.550000 |  |  |  | 227 CAA54093 |  | 44 |  | 40 | 00:00:14 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 10:22:40.410000 |  |  |  | 227 CAA54093 |  | 67 |  | 60 | 00:00:10 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 10:22:52 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 10:23:01.410000 |  |  |  | 227 CAA54093 |  | 71 |  | 70 | 00:00:32 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 10:24:02.870000 |  |  |  | 227 CAA54093 |  | 64 |  | 60 | 00:00:07 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:24:11.230000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:24:20.270000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:25:06.550000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:01 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:25:22.360000 |  |  |  | 227 CAA54093 |  | 65 |  | 60 | 00:00:13 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:25:38.660000 |  |  |  | 227 CAA54093 |  | 62 |  | 60 | 00:00:03 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 10:29:57.680000 |  |  |  | 227 CAA54093 |  | 65 |  | 60 | 00:00:00 | [NAME] (M6), [NAME], Hout Bay, Western Cape
 | 2023-03-09 11:55:17.380000 |  |  |  | 227 CAA54093 |  | 44 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 11:55:49.020000 |  |  |  | 227 CAA54093 |  | 30 |  | 20 | 00:00:12 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 11:56:10.790000 |  |  |  | 227 CAA54093 |  | 45 |  | 20 | 00:00:24 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 11:59:46.890000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | [NAME] | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:00:40.780000 |  |  |  | 227 CAA54093 |  | 52 |  | 40 | [NAME] | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:01:34.600000 |  |  |  | 227 CAA54093 |  | 43 |  | 40 | 00:00:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:01:47.750000 |  |  |  | 227 CAA54093 |  | 44 |  | 40 | 00:00:10 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:02:17.880000 |  |  |  | 227 CAA54093 |  | 43 |  | 40 | 00:00:28 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:03:29.800000 |  |  |  | 227 CAA54093 |  | 31 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:04:53.480000 |  |  |  | 227 CAA54093 |  | 30 |  | 20 | 00:00:02 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:05:53.490000 |  |  |  | 227 CAA54093 |  | 30 |  | 20 | 00:00:44 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:07:10.140000 |  |  |  | 227 CAA54093 |  | 46 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:07:55.390000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 12:08:25.820000 |  |  |  | 227 CAA54093 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-09 12:09:09.880000 |  |  |  | 227 CAA54093 |  | 44 |  | 40 | 00:00:48 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-09 12:17:09.220000 |  |  |  | 227 CAA54093 |  | 61 |  | 60 | 00:00:00 | Glencairn, Sunnydale, [NAME], Western Cape
 | 2023-03-09 12:19:49.440000 |  |  |  | 227 CAA54093 |  | 91 |  | 90 | 00:00:00 | Glencairn, [NAME]'s Town SP, [NAME]'s Town, Western Cape
 | 2023-03-09 12:24:05.050000 |  |  |  | 227 CAA54093 |  | 66 |  | 60 | 00:00:00 | Main, Bay View Village, [NAME]'s Town, Western Cape