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: 210 CA171553

 |  |  |  | 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
 | 210 CA171553 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
 | 62 |  |  |  |  |  |  | 104km/h |  |  |  |  | 00h14m21s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 08:04:12.720000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:00 | 52 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-03 08:04:56.140000 |  |  |  | 210 CA171553 |  | 63 |  | 60 | 00:00:20 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-03 08:16:19.540000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:01 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-03 08:19:08.670000 |  |  |  | 210 CA171553 |  | 52 |  | 50 | 00:00:00 | 9 Beach Road, [NAME], Cape Town, Western Cape
 | 2023-03-03 08:49:49.840000 |  |  |  | 210 CA171553 |  | 58 |  | 50 | 00:00:00 | Beach, Green Point, Cape Town, Western Cape
 | 2023-03-03 08:52:43.160000 |  |  |  | 210 CA171553 |  | 62 |  | 60 | 00:00:01 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-03 09:11:41.060000 |  |  |  | 210 CA171553 |  | 43 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 09:13:49.250000 |  |  |  | 210 CA171553 |  | 48 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 13:39:22.380000 |  |  |  | 210 CA171553 |  | 43 |  | 40 | 00:00:00 | 63 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-03 13:51:38.870000 |  |  |  | 210 CA171553 |  | 53 |  | 50 | 00:00:00 | Beach Road (M6), Sea Point, Cape Town, Western Cape
 | 2023-03-03 14:43:22.280000 |  |  |  | 210 CA171553 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:57:35.220000 |  |  |  | 210 CA171553 |  | 62 |  | 60 | 00:00:00 | 68 New Market Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 09:40:57.310000 |  |  |  | 210 CA171553 |  | 52 |  | 50 | 00:00:00 | Victoria, Camps Bay, Cape Town, Western Cape
 | 2023-03-04 09:47:52.930000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:01 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:48:57.240000 |  |  |  | 210 CA171553 |  | 69 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:51:22.360000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:55:53.200000 |  |  |  | 210 CA171553 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), [NAME], Hout Bay, Western Cape
 | 2023-03-04 10:06:01.150000 |  |  |  | 210 CA171553 |  | 35 |  | 20 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:11:53.910000 |  |  |  | 210 CA171553 |  | 42 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:44:25.550000 |  |  |  | 210 CA171553 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:46:33.180000 |  |  |  | 210 CA171553 |  | 36 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:54:01.410000 |  |  |  | 210 CA171553 |  | 42 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-04 10:56:09.240000 |  |  |  | 210 CA171553 |  | 52 |  | 40 | 00:00:32 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-04 10:58:17.920000 |  |  |  | 210 CA171553 |  | 72 |  | 70 | 00:00:00 | [NAME], Meadowsteads, Noordhoek, Western Cape
 | 2023-03-04 11:08:57.880000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:00 | Main Road (M4), Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-04 11:10:33.170000 |  |  |  | 210 CA171553 |  | 65 |  | 60 | 00:00:32 | Red Hill, Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-04 15:16:11.380000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 18:00:32.140000 |  |  |  | 210 CA171553 |  | 97 |  | 60 | 00:00:00 | [NAME] der [NAME] (M3), Sillary, Cape Town, Western Cape
 | 2023-03-04 18:12:16.100000 |  |  |  | 210 CA171553 |  | 82 |  | 80 | 00:00:00 | Rhodes, Table Mountain, Cape Town, Western Cape
 | 2023-03-04 18:14:24.530000 |  |  |  | 210 CA171553 |  | 84 |  | 80 | 00:00:00 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-04 18:16:00.380000 |  |  |  | 210 CA171553 |  | 65 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 18:26:42.330000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:05 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-04 20:40:33.890000 |  |  |  | 210 CA171553 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 09:26:52.130000 |  |  |  | 210 CA171553 |  | 81 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 09:28:28.600000 |  |  |  | 210 CA171553 |  | 82 |  | 80 | 00:00:32 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-05 09:56:48.670000 |  |  |  | 210 CA171553 |  | 65 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 11:53:44.240000 |  |  |  | 210 CA171553 |  | 85 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:48:03.250000 |  |  |  | 210 CA171553 |  | 64 |  | 60 | 00:00:21 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-05 16:48:35.490000 |  |  |  | 210 CA171553 |  | 65 |  | 60 | 00:00:31 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-05 16:52:19.310000 |  |  |  | 210 CA171553 |  | 66 |  | 60 | 00:01:31 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 16:56:03.700000 |  |  |  | 210 CA171553 |  | 101 |  | 100 | 00:00:00 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 17:00:51.400000 |  |  |  | 210 CA171553 |  | 96 |  | 60 | 00:00:00 | R304, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 17:25:55.540000 |  |  |  | 210 CA171553 |  | 84 |  | 80 | 00:01:04 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-05 17:51:31.890000 |  |  |  | 210 CA171553 |  | 61 |  | 60 | 00:00:00 | Port, Cape Town, Cape Town, Western Cape
 | 2023-03-06 07:57:49.040000 |  |  |  | 210 CA171553 |  | 63 |  | 60 | 00:00:00 | [NAME] (R301), 1.82 km SE of [NAME], Western Cape
 | 2023-03-06 08:05:17.410000 |  |  |  | 210 CA171553 |  | 52 |  | 40 | 00:00:00 | N1, 5.18 km SE of [NAME], Western Cape
 | 2023-03-06 08:09:01.110000 |  |  |  | 210 CA171553 |  | 79 |  | 60 | 00:01:04 | N1, 7.43 km SE of [NAME], Western Cape
 | 2023-03-06 08:16:29.050000 |  |  |  | 210 CA171553 |  | 100 |  | 90 | 00:00:32 | N1, 10.97 km SE of Blouvlei, Western Cape
 | 2023-03-06 08:18:05.580000 |  |  |  | 210 CA171553 |  | 104 |  | 90 | 00:01:04 | N1, 12.7 km SE of Blouvlei, Western Cape
 | 2023-03-06 08:20:45.660000 |  |  |  | 210 CA171553 |  | 91 |  | 90 | 00:00:32 | N1, 11.46 km SW of Rawsonville, Western Cape
 | 2023-03-06 08:22:21.540000 |  |  |  | 210 CA171553 |  | 95 |  | 90 | 00:02:08 | N1, 9.68 km SW of Rawsonville, Western Cape
 | 2023-03-06 09:19:51.790000 |  |  |  | 210 CA171553 |  | 102 |  | 100 | 00:00:32 | N1, 11.94 km SE of Blouvlei, Western Cape
 | 2023-03-06 09:28:23.010000 |  |  |  | 210 CA171553 |  | 84 |  | 60 | 00:00:00 | N1, 9.07 km SE of [NAME], Western Cape
 | 2023-03-06 09:28:55.190000 |  |  |  | 210 CA171553 |  | 83 |  | 60 | 00:00:32 | N1, 8.32 km SE of [NAME], Western Cape
 | 2023-03-06 09:31:03.200000 |  |  |  | 210 CA171553 |  | 66 |  | 60 | 00:00:00 | N1, 5.97 km SE of [NAME], Western Cape
 | 2023-03-06 09:37:27.100000 |  |  |  | 210 CA171553 |  | 101 |  | 100 | 00:00:32 | [NAME], 4.54 km NE of Paarl, Western Cape
 | 2023-03-06 09:39:03.870000 |  |  |  | 210 CA171553 |  | 65 |  | 60 | 00:00:00 | Meaker Street, New Orleans, [NAME], Western Cape
 | 2023-03-06 09:47:03.480000 |  |  |  | 210 CA171553 |  | 62 |  | 60 | 00:00:00 | [NAME], Van Wyks Vlei, Wellington, Western Cape
 | 2023-03-06 09:49:11.620000 |  |  |  | 210 CA171553 |  | 67 |  | 60 | 00:00:00 | Champagne, Hillcrest, Wellington, Western Cape
 | 2023-03-06 13:00:07.030000 |  |  |  | 210 CA171553 |  | 102 |  | 100 | [NAME] | [NAME], Windmeul, Western Cape
 | 2023-03-06 13:09:11.840000 |  |  |  | 210 CA171553 |  | 97 |  | 80 | 00:00:00 | [NAME] (R44), 1.26 km N of Klapmuts, Western Cape
 | 2023-03-06 15:07:19.800000 |  |  |  | 210 CA171553 |  | 81 |  | 80 | 00:00:32 | F.W. de Klerk, Foreshore, Cape Town, Western Cape