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: 230 CAA95881

 |  |  |  | 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
 | 230 CAA95881 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
 | 26 |  |  |  |  |  |  | 83km/h |  |  |  |  | 00h03m45s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 08:31:27.140000 |  |  |  | 230 CAA95881 |  | 80 |  | 60 | 00:00:00 | N1, Plattekloof, Parow, Western Cape
 | 2023-03-03 09:33:51.300000 |  |  |  | 230 CAA95881 |  | 64 |  | 60 | 00:00:00 | 35th, Eureka, Elsies River, Western Cape
 | 2023-03-03 09:39:11.110000 |  |  |  | 230 CAA95881 |  | 58 |  | 40 | 00:00:00 | [NAME], Cape Town, Western Cape
 | 2023-03-03 09:40:15.750000 |  |  |  | 230 CAA95881 |  | 43 |  | 40 | 00:00:32 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-03 09:51:27.830000 |  |  |  | 230 CAA95881 |  | 55 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-03 09:52:53.610000 |  |  |  | 230 CAA95881 |  | 76 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-07 19:17:20.480000 |  |  |  | 230 CAA95881 |  | 61 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-07 22:15:46.110000 |  |  |  | 230 CAA95881 |  | 61 |  | 60 | 00:00:02 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-07 22:16:04.580000 |  |  |  | 230 CAA95881 |  | 61 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-07 23:10:15.930000 |  |  |  | 230 CAA95881 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 12:17:42.030000 |  |  |  | 230 CAA95881 |  | 62 |  | 60 | 00:00:10 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 15:16:15.790000 |  |  |  | 230 CAA95881 |  | 42 |  | 40 | 00:00:01 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-08 15:17:51.720000 |  |  |  | 230 CAA95881 |  | 50 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-08 16:53:12.620000 |  |  |  | 230 CAA95881 |  | 76 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-09 05:00:02.650000 |  |  |  | 230 CAA95881 |  | 61 |  | 60 | 00:00:00 | 141 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-09 05:06:26.900000 |  |  |  | 230 CAA95881 |  | 72 |  | 60 | 00:00:00 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-09 05:07:30.330000 |  |  |  | 230 CAA95881 |  | 65 |  | 60 | 00:00:32 | 9 Buitengracht Street, Cape Town, Western Cape
 | 2023-03-09 07:44:27.530000 |  |  |  | 230 CAA95881 |  | 77 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 07:50:19 |  |  |  | 230 CAA95881 |  | 83 |  | 80 | 00:00:00 | Settlers, Welcome, Cape Town, Western Cape
 | 2023-03-09 07:54:35.350000 |  |  |  | 230 CAA95881 |  | 46 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:09:31.180000 |  |  |  | 230 CAA95881 |  | 55 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:11:07.290000 |  |  |  | 230 CAA95881 |  | 78 |  | 60 | 00:00:00 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-09 08:11:31.560000 |  |  |  | 230 CAA95881 |  | 68 |  | 60 | 00:00:08 | Settlers Way, [NAME], Western Cape
 | 2023-03-09 08:12:43.770000 |  |  |  | 230 CAA95881 |  | 79 |  | 60 | 00:00:00 | Settlers Way (N2), Heideveld, Cape Town, Western Cape
 | 2023-03-09 08:48:11.890000 |  |  |  | 230 CAA95881 |  | 61 |  | 60 | 00:00:00 | Malta, Observatory, Cape Town, Western Cape
 | 2023-03-09 08:54:51.870000 |  |  |  | 230 CAA95881 |  | 70 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape