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: 221 CA645053

 |  |  |  | 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
 | 221 CA645053 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
 | 50 |  |  |  |  |  |  | 103km/h |  |  |  |  | 00h18m41s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 13:59:29.260000 |  |  |  | 221 CA645053 |  | 61 |  | 60 | 00:00:00 | N2, Riversdale, Riversdale, Western Cape
 | 2023-03-03 14:00:33.150000 |  |  |  | 221 CA645053 |  | 65 |  | 60 | 00:00:00 | N2, Riversdale, Riversdale, Western Cape
 | 2023-03-03 14:52:49.430000 |  |  |  | 221 CA645053 |  | 90 |  | 80 | 00:00:32 | N2, 2.59 km SE of [NAME], Western Cape
 | 2023-03-03 14:53:53.800000 |  |  |  | 221 CA645053 |  | 88 |  | 80 | 00:00:32 | N2, [NAME], [NAME], Western Cape
 | 2023-03-03 14:56:36.840000 |  |  |  | 221 CA645053 |  | 67 |  | 60 | 00:00:00 | [NAME] (R60), [NAME], [NAME], Western Cape
 | 2023-03-03 15:36:01.600000 |  |  |  | 221 CA645053 |  | 61 |  | 60 | 00:00:00 | R60, 4.42 km SW of Ashton, Western Cape
 | 2023-03-03 15:36:33.590000 |  |  |  | 221 CA645053 |  | 62 |  | 60 | 00:01:36 | R60, 4.6 km SW of Ashton, Western Cape
 | 2023-03-03 17:42:11.580000 |  |  |  | 221 CA645053 |  | 101 |  | 100 | 00:00:00 | R317, 7.11 km SE of [NAME], Western Cape
 | 2023-03-03 17:53:23.210000 |  |  |  | 221 CA645053 |  | 91 |  | 60 | 00:00:32 | R60, 5.89 km W of Robertson, Western Cape
 | 2023-03-03 18:05:07.600000 |  |  |  | 221 CA645053 |  | 96 |  | 60 | 00:00:32 | R60, 21.53 km NW of Robertson, Western Cape
 | 2023-03-03 18:26:59.590000 |  |  |  | 221 CA645053 |  | 91 |  | 60 | 00:00:32 | N1, Hospital Park, Worcester, Western Cape
 | 2023-03-03 18:40:19.390000 |  |  |  | 221 CA645053 |  | 91 |  | 80 | 00:00:04 | N1, 5.87 km SW of Rawsonville, Western Cape
 | 2023-03-03 18:47:15.560000 |  |  |  | 221 CA645053 |  | 101 |  | 100 | 00:01:04 | N1, 12.7 km SE of Blouvlei, Western Cape
 | 2023-03-03 19:01:07.400000 |  |  |  | 221 CA645053 |  | 80 |  | 60 | 00:00:00 | N1, 5.01 km SE of [NAME], Western Cape
 | 2023-03-03 19:18:43.860000 |  |  |  | 221 CA645053 |  | 87 |  | 80 | 00:00:00 | [NAME] (R44), [NAME], Stellenbosch, Western Cape
 | 2023-03-03 19:19:18.430000 |  |  |  | 221 CA645053 |  | 81 |  | 80 | 00:01:33 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-03 20:05:07.750000 |  |  |  | 221 CA645053 |  | 83 |  | 80 | 00:01:04 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-03 20:25:22.180000 |  |  |  | 221 CA645053 |  | 91 |  | 80 | 00:00:05 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-03 20:26:27.140000 |  |  |  | 221 CA645053 |  | 87 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-03 20:38:43.900000 |  |  |  | 221 CA645053 |  | 87 |  | 80 | 00:00:32 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-03 20:52:03.020000 |  |  |  | 221 CA645053 |  | 99 |  | 80 | 00:00:17 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-04 07:54:13.380000 |  |  |  | 221 CA645053 |  | 87 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:14:29.870000 |  |  |  | 221 CA645053 |  | 90 |  | 80 | 00:01:04 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-04 19:16:20.720000 |  |  |  | 221 CA645053 |  | 83 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-04 19:55:48.530000 |  |  |  | 221 CA645053 |  | 86 |  | 80 | 00:01:36 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-04 20:15:31.020000 |  |  |  | 221 CA645053 |  | 85 |  | 80 | 00:01:37 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-05 08:05:18.510000 |  |  |  | 221 CA645053 |  | 68 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-05 12:07:30.430000 |  |  |  | 221 CA645053 |  | 82 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-05 12:18:42.190000 |  |  |  | 221 CA645053 |  | 100 |  | 60 | 00:00:00 | N1, [NAME], [NAME], Western Cape
 | 2023-03-05 12:27:46.370000 |  |  |  | 221 CA645053 |  | 91 |  | 60 | 00:00:00 | N1, Belvedere, Parow, Western Cape
 | 2023-03-05 12:35:14.440000 |  |  |  | 221 CA645053 |  | 95 |  | 80 | 00:01:36 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-05 22:19:31.920000 |  |  |  | 221 CA645053 |  | 81 |  | 80 | 00:00:21 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 22:23:36.840000 |  |  |  | 221 CA645053 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 20:01:47.700000 |  |  |  | 221 CA645053 |  | 79 |  | 60 | 00:00:00 | Rhodes, Table Mountain, Cape Town, Western Cape
 | 2023-03-07 20:10:51.280000 |  |  |  | 221 CA645053 |  | 63 |  | 60 | 00:00:00 | [NAME] Stel, Lanstead, Cape Town, Western Cape
 | 2023-03-07 20:15:07.190000 |  |  |  | 221 CA645053 |  | 64 |  | 60 | 00:00:00 | [NAME] Stel, Kirstenhof, Cape Town, Western Cape
 | 2023-03-07 20:19:23.270000 |  |  |  | 221 CA645053 |  | 61 |  | 60 | 00:00:00 | [NAME], Westlake, Cape Town, Western Cape
 | 2023-03-07 23:25:01.370000 |  |  |  | 221 CA645053 |  | 103 |  | 100 | 00:00:32 | [NAME] der [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-07 23:25:52.670000 |  |  |  | 221 CA645053 |  | 101 |  | 100 | 00:00:00 | [NAME] Stel, Dennendal, Cape Town, Western Cape
 | 2023-03-07 23:31:38.900000 |  |  |  | 221 CA645053 |  | 74 |  | 60 | 00:00:00 | 42 [NAME], Bishopscourt, Cape Town, Western Cape
 | 2023-03-07 23:34:37.030000 |  |  |  | 221 CA645053 |  | 85 |  | 80 | 00:00:32 | Union, Table Mountain, Cape Town, Western Cape
 | 2023-03-07 23:37:33.150000 |  |  |  | 221 CA645053 |  | 83 |  | 80 | 00:00:00 | [NAME] (N2/M3), Table Mountain, Cape Town, Western Cape
 | 2023-03-07 23:38:38.360000 |  |  |  | 221 CA645053 |  | 91 |  | 80 | 00:00:47 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-07 23:39:57.230000 |  |  |  | 221 CA645053 |  | 85 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-07 23:40:28.270000 |  |  |  | 221 CA645053 |  | 71 |  | 60 | 00:00:01 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-07 23:41:33.600000 |  |  |  | 221 CA645053 |  | 86 |  | 80 | 00:00:04 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 23:51:09.330000 |  |  |  | 221 CA645053 |  | 68 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 00:04:29.830000 |  |  |  | 221 CA645053 |  | 63 |  | 60 | 00:00:32 | 94 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-08 00:07:09.920000 |  |  |  | 221 CA645053 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 15:19:46.390000 |  |  |  | 221 CA645053 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape