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: CQ20 CA360367

 |  |  |  | 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
 | CQ20 CA360367 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
 | 63 |  |  |  |  |  |  | 102km/h |  |  |  |  | 00h15m41s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 11:13:46.170000 |  |  |  | CQ20 CA360367 |  | 51 |  | 40 | 00:00:03 | Bhunga, Kewtown, Cape Town, Western Cape
 | 2023-03-03 11:19:45.140000 |  |  |  | CQ20 CA360367 |  | 81 |  | 80 | 00:00:00 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-04 10:09:17.700000 |  |  |  | CQ20 CA360367 |  | 81 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 13:07:44.230000 |  |  |  | CQ20 CA360367 |  | 68 |  | 60 | 00:00:00 | Helshoogte, Uniepark, Stellenbosch, Western Cape
 | 2023-03-04 16:21:42.740000 |  |  |  | CQ20 CA360367 |  | 82 |  | 80 | 00:00:00 | Strand, [NAME], Stellenbosch, Western Cape
 | 2023-03-04 16:25:58.190000 |  |  |  | CQ20 CA360367 |  | 63 |  | 60 | 00:00:00 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-04 18:09:53.310000 |  |  |  | CQ20 CA360367 |  | 89 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 18:10:47.210000 |  |  |  | CQ20 CA360367 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 18:11:16.700000 |  |  |  | CQ20 CA360367 |  | 83 |  | 80 | 00:00:13 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 18:16:23.140000 |  |  |  | CQ20 CA360367 |  | 71 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-05 06:52:49.460000 |  |  |  | CQ20 CA360367 |  | 62 |  | 60 | 00:00:07 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-05 06:53:46.240000 |  |  |  | CQ20 CA360367 |  | 81 |  | 80 | 00:01:36 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-05 08:37:55.550000 |  |  |  | CQ20 CA360367 |  | 67 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-05 08:43:47.710000 |  |  |  | CQ20 CA360367 |  | 82 |  | 80 | 00:00:11 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-05 12:17:39.510000 |  |  |  | CQ20 CA360367 |  | 73 |  | 60 | [NAME] | [NAME] (R310), [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:03:57.760000 |  |  |  | CQ20 CA360367 |  | 62 |  | 60 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:05:01.410000 |  |  |  | CQ20 CA360367 |  | 83 |  | 80 | 00:01:04 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:07:09.600000 |  |  |  | CQ20 CA360367 |  | 87 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:10:30.540000 |  |  |  | CQ20 CA360367 |  | 71 |  | 60 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-05 16:19:57.690000 |  |  |  | CQ20 CA360367 |  | 101 |  | 100 | 00:00:00 | R45, 5.1 km SE of Klapmuts, Western Cape
 | 2023-03-05 16:21:01.130000 |  |  |  | CQ20 CA360367 |  | 102 |  | 100 | 00:00:00 | R45, 3.42 km E of Klapmuts, Western Cape
 | 2023-03-05 16:21:57.620000 |  |  |  | CQ20 CA360367 |  | 102 |  | 100 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 16:22:37.260000 |  |  |  | CQ20 CA360367 |  | 88 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 16:41:17.100000 |  |  |  | CQ20 CA360367 |  | 80 |  | 60 | 00:00:00 | N1, Boston, Bellville, Western Cape
 | 2023-03-05 16:50:21.710000 |  |  |  | CQ20 CA360367 |  | 83 |  | 80 | 00:01:36 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-05 16:57:48.080000 |  |  |  | CQ20 CA360367 |  | 69 |  | 60 | 00:00:33 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-05 16:59:25.670000 |  |  |  | CQ20 CA360367 |  | 68 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-05 17:15:22.380000 |  |  |  | CQ20 CA360367 |  | 56 |  | 50 | 00:00:03 | Beach, Sea Point, Cape Town, Western Cape
 | 2023-03-05 17:27:05.430000 |  |  |  | CQ20 CA360367 |  | 63 |  | 60 | 00:00:08 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-05 17:40:12.490000 |  |  |  | CQ20 CA360367 |  | 89 |  | 80 | 00:00:22 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-05 17:45:00.330000 |  |  |  | CQ20 CA360367 |  | 88 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 10:27:04.590000 |  |  |  | CQ20 CA360367 |  | 41 |  | 40 | 00:00:00 | 10 Victoria Road, Bakoven, Cape Town, Western Cape
 | 2023-03-06 10:28:08.080000 |  |  |  | CQ20 CA360367 |  | 46 |  | 40 | 00:00:09 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-06 10:29:07.260000 |  |  |  | CQ20 CA360367 |  | 65 |  | 60 | 00:00:48 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 10:31:41.770000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | [NAME] | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-06 10:32:56.450000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-06 10:58:44.870000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | 00:00:07 | [NAME], [NAME], Hout Bay, Western Cape
 | 2023-03-06 11:15:16.040000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | 00:00:00 | Orpen, Cape Farms, Cape Town, Western Cape
 | 2023-03-06 11:45:08.560000 |  |  |  | CQ20 CA360367 |  | 72 |  | 70 | 00:00:19 | Slangkop, Ocean View, Cape Town, Western Cape
 | 2023-03-06 14:40:37.620000 |  |  |  | CQ20 CA360367 |  | 55 |  | 40 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-06 17:16:04.640000 |  |  |  | CQ20 CA360367 |  | 66 |  | 60 | 00:00:00 | 8 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 17:27:48.850000 |  |  |  | CQ20 CA360367 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 09:33:45.270000 |  |  |  | CQ20 CA360367 |  | 76 |  | 60 | 00:00:10 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-07 10:18:49.580000 |  |  |  | CQ20 CA360367 |  | 73 |  | 60 | 00:00:00 | R45, [NAME], Franschhoek, Western Cape
 | 2023-03-07 21:36:11.440000 |  |  |  | CQ20 CA360367 |  | 83 |  | 80 | [NAME] | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 21:53:47.430000 |  |  |  | CQ20 CA360367 |  | 78 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-07 22:20:59.790000 |  |  |  | CQ20 CA360367 |  | 91 |  | 60 | 00:01:36 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-07 22:38:29.830000 |  |  |  | CQ20 CA360367 |  | 89 |  | 80 | 00:00:15 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-07 22:41:50.650000 |  |  |  | CQ20 CA360367 |  | 70 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 08:40:15.040000 |  |  |  | CQ20 CA360367 |  | 64 |  | 60 | 00:00:17 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-08 09:20:01.750000 |  |  |  | CQ20 CA360367 |  | 72 |  | 60 | 00:00:00 | Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:54:37.240000 |  |  |  | CQ20 CA360367 |  | 62 |  | 60 | 00:00:00 | Polkadraai Road (M12), [NAME], Stellenbosch, Western Cape
 | 2023-03-08 12:48:32.540000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | 00:00:00 | [NAME] (R310), Idas Valley, Stellenbosch, Western Cape
 | 2023-03-08 13:19:54.010000 |  |  |  | CQ20 CA360367 |  | 68 |  | 60 | 00:00:00 | Helshoogte, [NAME], Franschhoek, Western Cape
 | 2023-03-08 13:22:52.040000 |  |  |  | CQ20 CA360367 |  | 62 |  | 60 | 00:00:00 | Main, [NAME], Franschhoek, Western Cape
 | 2023-03-08 13:30:34.370000 |  |  |  | CQ20 CA360367 |  | 71 |  | 60 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:31:38.900000 |  |  |  | CQ20 CA360367 |  | 68 |  | 60 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:33:10.310000 |  |  |  | CQ20 CA360367 |  | 71 |  | 60 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:33:46.210000 |  |  |  | CQ20 CA360367 |  | 86 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-09 07:53:34.580000 |  |  |  | CQ20 CA360367 |  | 61 |  | 60 | 00:00:00 | 50 Foundry Road, Salt River, Cape Town, Western Cape
 | 2023-03-09 08:11:42.570000 |  |  |  | CQ20 CA360367 |  | 48 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-09 10:03:52.340000 |  |  |  | CQ20 CA360367 |  | 70 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-09 10:04:24.350000 |  |  |  | CQ20 CA360367 |  | 82 |  | 80 | 00:00:02 | F.W. de Klerk, Maitland, Cape Town, Western Cape