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: 217 CA387126

 |  |  |  | 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
 | 217 CA387126 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
 | 43 |  |  |  |  |  |  | 92km/h |  |  |  |  | 00h03m50s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 20:52:18.830000 |  |  |  | 217 CA387126 |  | 61 |  | 60 | 00:00:00 | Malta, Woodstock, Cape Town, Western Cape
 | 2023-03-03 23:09:09.680000 |  |  |  | 217 CA387126 |  | 63 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-03 23:10:20.250000 |  |  |  | 217 CA387126 |  | 69 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-03 23:15:01.880000 |  |  |  | 217 CA387126 |  | 82 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-03 23:15:33.410000 |  |  |  | 217 CA387126 |  | 81 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-03 23:18:45.590000 |  |  |  | 217 CA387126 |  | 81 |  | 80 | 00:00:00 | [NAME] (M3), Rondebosch, Cape Town, Western Cape
 | 2023-03-03 23:19:49.660000 |  |  |  | 217 CA387126 |  | 82 |  | 80 | 00:00:00 | Rhodes, [NAME], Cape Town, Western Cape
 | 2023-03-03 23:44:21.300000 |  |  |  | 217 CA387126 |  | 64 |  | 60 | 00:00:00 | Main, Salt River, Cape Town, Western Cape
 | 2023-03-03 23:49:03.110000 |  |  |  | 217 CA387126 |  | 73 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 09:50:14.410000 |  |  |  | 217 CA387126 |  | 81 |  | 80 | 00:00:00 | [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-04 09:55:02.880000 |  |  |  | 217 CA387126 |  | 64 |  | 60 | 00:00:00 | Jutland, Gardens, Cape Town, Western Cape
 | 2023-03-04 13:22:20.740000 |  |  |  | 217 CA387126 |  | 53 |  | 50 | 00:00:00 | 90 High Level Road, Green Point, Cape Town, Western Cape
 | 2023-03-04 19:57:41.310000 |  |  |  | 217 CA387126 |  | 61 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 22:37:40.390000 |  |  |  | 217 CA387126 |  | 73 |  | 60 | 00:00:00 | Rhodes, Table Mountain, Cape Town, Western Cape
 | 2023-03-05 19:42:24.460000 |  |  |  | 217 CA387126 |  | 82 |  | 80 | 00:00:00 | Union, Table Mountain, Cape Town, Western Cape
 | 2023-03-06 00:37:45.460000 |  |  |  | 217 CA387126 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 11:46:25.560000 |  |  |  | 217 CA387126 |  | 80 |  | 60 | 00:00:00 | Century City, Century City, Milnerton, Western Cape
 | 2023-03-06 14:03:12.750000 |  |  |  | 217 CA387126 |  | 64 |  | 60 | 00:00:11 | F.W. de Klerk, [NAME], Cape Town, Western Cape
 | 2023-03-06 14:07:14.880000 |  |  |  | 217 CA387126 |  | 92 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-06 14:09:06.860000 |  |  |  | 217 CA387126 |  | 82 |  | 80 | 00:00:00 | Black River Parkway (M5), Maitland Garden Village, Cape Town, Western Cape
 | 2023-03-06 14:16:34.580000 |  |  |  | 217 CA387126 |  | 66 |  | 60 | 00:00:00 | Union, Newlands, Cape Town, Western Cape
 | 2023-03-07 11:21:35.460000 |  |  |  | 217 CA387126 |  | 88 |  | 60 | 00:00:00 | [NAME], [NAME], Goodwood, Western Cape
 | 2023-03-07 12:06:01.270000 |  |  |  | 217 CA387126 |  | 61 |  | 60 | 00:00:00 | Arboretum, 3.56 km SE of [NAME], Western Cape
 | 2023-03-07 15:22:11.120000 |  |  |  | 217 CA387126 |  | 86 |  | 80 | 00:01:04 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:23:47.300000 |  |  |  | 217 CA387126 |  | 85 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:25:23.290000 |  |  |  | 217 CA387126 |  | 88 |  | 60 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:28:35.690000 |  |  |  | 217 CA387126 |  | 84 |  | 60 | 00:00:00 | R45, [NAME], Franschhoek, Western Cape
 | 2023-03-07 15:40:19.450000 |  |  |  | 217 CA387126 |  | 61 |  | 60 | 00:00:00 | [NAME] (R44), [NAME], Stellenbosch, Western Cape
 | 2023-03-07 16:19:57.170000 |  |  |  | 217 CA387126 |  | 63 |  | 60 | 00:00:00 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-07 19:22:07.620000 |  |  |  | 217 CA387126 |  | 75 |  | 60 | 00:00:00 | [NAME] (N2), Zonnebloem, Cape Town, Western Cape
 | 2023-03-07 19:22:51.670000 |  |  |  | 217 CA387126 |  | 65 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 19:22:57.760000 |  |  |  | 217 CA387126 |  | 63 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-07 21:45:38.210000 |  |  |  | 217 CA387126 |  | 74 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 22:00:08.880000 |  |  |  | 217 CA387126 |  | 47 |  | 40 | [NAME] | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 22:11:46.500000 |  |  |  | 217 CA387126 |  | 52 |  | 20 | 00:00:01 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 22:12:00.060000 |  |  |  | 217 CA387126 |  | 54 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 22:12:21.750000 |  |  |  | 217 CA387126 |  | 56 |  | 50 | 00:00:06 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 22:13:47.730000 |  |  |  | 217 CA387126 |  | 77 |  | 60 | 00:00:10 | Settlers, [NAME], Western Cape
 | 2023-03-07 22:13:58.500000 |  |  |  | 217 CA387126 |  | 78 |  | 60 | 00:00:01 | Settlers, [NAME], Western Cape
 | 2023-03-07 22:20:50.670000 |  |  |  | 217 CA387126 |  | 61 |  | 60 | 00:00:13 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-07 22:21:50.230000 |  |  |  | 217 CA387126 |  | 68 |  | 60 | 00:00:04 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-07 22:22:08.150000 |  |  |  | 217 CA387126 |  | 63 |  | 60 | [NAME] | Malta Road (M57), [NAME], Cape Town, Western Cape
 | 2023-03-07 22:25:06.540000 |  |  |  | 217 CA387126 |  | 72 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape