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: 211 CA177249

 |  |  |  | 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
 | 211 CA177249 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
 | 27 |  |  |  |  |  |  | 105km/h |  |  |  |  | 00h09m03s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-05 08:43:34.910000 |  |  |  | 211 CA177249 |  | 62 |  | 60 | 00:00:00 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-05 08:47:11.060000 |  |  |  | 211 CA177249 |  | 82 |  | 80 | 00:00:07 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-05 08:52:06.830000 |  |  |  | 211 CA177249 |  | 84 |  | 80 | 00:00:00 | 7 Toledo Street, Montevideo, Cape Town, Western Cape
 | 2023-03-05 08:53:10.740000 |  |  |  | 211 CA177249 |  | 77 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-05 08:59:34.410000 |  |  |  | 211 CA177249 |  | 35 |  | 20 | 00:01:36 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 09:02:05.830000 |  |  |  | 211 CA177249 |  | 66 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Western Cape
 | 2023-03-05 09:06:30.530000 |  |  |  | 211 CA177249 |  | 82 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-05 09:11:09.170000 |  |  |  | 211 CA177249 |  | 62 |  | 60 | 00:00:09 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 07:09:36.180000 |  |  |  | 211 CA177249 |  | 62 |  | 60 | 00:00:00 | 127 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-06 07:14:56.830000 |  |  |  | 211 CA177249 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-06 07:58:08.630000 |  |  |  | 211 CA177249 |  | 65 |  | 60 | 00:00:00 | [NAME], 1.68 km SE of [NAME], Western Cape
 | 2023-03-06 08:09:20.100000 |  |  |  | 211 CA177249 |  | 81 |  | 60 | 00:00:00 | N1, 7.6 km SE of [NAME], Western Cape
 | 2023-03-06 08:16:48.080000 |  |  |  | 211 CA177249 |  | 96 |  | 90 | 00:02:55 | N1, 11.2 km SE of Blouvlei, Western Cape
 | 2023-03-06 08:20:32.030000 |  |  |  | 211 CA177249 |  | 95 |  | 90 | 00:00:00 | N1, 11.75 km SW of Rawsonville, Western Cape
 | 2023-03-06 08:22:08.430000 |  |  |  | 211 CA177249 |  | 96 |  | 90 | 00:01:36 | N1, 10.02 km SW of Rawsonville, Western Cape
 | 2023-03-06 08:24:48.140000 |  |  |  | 211 CA177249 |  | 93 |  | 80 | 00:00:00 | N1, 6.22 km SW of Rawsonville, Western Cape
 | 2023-03-06 09:19:47.630000 |  |  |  | 211 CA177249 |  | 105 |  | 100 | 00:00:00 | N1, 12.03 km SE of Blouvlei, Western Cape
 | 2023-03-06 09:20:22.940000 |  |  |  | 211 CA177249 |  | 92 |  | 80 | 00:00:00 | N1, 11.61 km SE of Blouvlei, Western Cape
 | 2023-03-06 09:38:30.940000 |  |  |  | 211 CA177249 |  | 80 |  | 60 | 00:00:32 | [NAME], 3.8 km NE of Paarl, Western Cape
 | 2023-03-06 09:47:02.040000 |  |  |  | 211 CA177249 |  | 62 |  | 60 | 00:00:00 | [NAME], 2.85 km SW of Wellington, Western Cape
 | 2023-03-06 09:50:46.900000 |  |  |  | 211 CA177249 |  | 75 |  | 60 | 00:00:00 | Champagne, Wellington, Wellington, Western Cape
 | 2023-03-06 12:20:00.420000 |  |  |  | 211 CA177249 |  | 61 |  | 60 | 00:00:00 | Stokery, Wellington, Wellington, Western Cape
 | 2023-03-06 13:10:40.700000 |  |  |  | 211 CA177249 |  | 81 |  | 80 | 00:01:04 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-06 13:12:48.370000 |  |  |  | 211 CA177249 |  | 81 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-06 13:13:52.560000 |  |  |  | 211 CA177249 |  | 83 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 14:22:59.480000 |  |  |  | 211 CA177249 |  | 68 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 14:30:15.630000 |  |  |  | 211 CA177249 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape