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: CC5 BW33BJGP

 |  |  |  | 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
 | CC5 BW33BJGP 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 |  |  |  |  |  |  | 101km/h |  |  |  |  | 00h07m49s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-04 07:39:46.710000 |  |  |  | CC5 BW33BJGP |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 10:16:52.920000 |  |  |  | CC5 BW33BJGP |  | 51 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-06 11:21:12.720000 |  |  |  | CC5 BW33BJGP |  | 56 |  | 40 | 00:00:32 | Ring, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 11:29:31 |  |  |  | CC5 BW33BJGP |  | 62 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 11:31:10.090000 |  |  |  | CC5 BW33BJGP |  | 63 |  | 60 | 00:00:03 | Settlers, [NAME], Western Cape
 | 2023-03-06 12:01:32.690000 |  |  |  | CC5 BW33BJGP |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 06:26:16.210000 |  |  |  | CC5 BW33BJGP |  | 99 |  | 60 | 00:00:00 | N1, Windsor Park, [NAME], Western Cape
 | 2023-03-08 06:40:39.490000 |  |  |  | CC5 BW33BJGP |  | 76 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 06:45:59.860000 |  |  |  | CC5 BW33BJGP |  | 72 |  | 60 | 00:00:00 | R45, 8.24 km SE of Klapmuts, Western Cape
 | 2023-03-08 06:55:35.770000 |  |  |  | CC5 BW33BJGP |  | 84 |  | 80 | 00:02:08 | Huguenot, Wemmershoek Forest Reserve, Franschhoek, Western Cape
 | 2023-03-08 07:43:23.060000 |  |  |  | CC5 BW33BJGP |  | 90 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 07:45:31.120000 |  |  |  | CC5 BW33BJGP |  | 92 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 08:31:23.080000 |  |  |  | CC5 BW33BJGP |  | 101 |  | 60 | 00:00:00 | Settlers, [NAME], Western Cape
 | 2023-03-08 08:34:03.530000 |  |  |  | CC5 BW33BJGP |  | 74 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 08:43:49.380000 |  |  |  | CC5 BW33BJGP |  | 37 |  | 20 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 13:02:05.610000 |  |  |  | CC5 BW33BJGP |  | 60 |  | 50 | 00:01:38 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 13:09:27.130000 |  |  |  | CC5 BW33BJGP |  | 85 |  | 80 | 00:00:38 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 13:12:13.220000 |  |  |  | CC5 BW33BJGP |  | 83 |  | 80 | 00:00:32 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-08 13:13:49.260000 |  |  |  | CC5 BW33BJGP |  | 85 |  | 80 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 13:19:41.650000 |  |  |  | CC5 BW33BJGP |  | 62 |  | 60 | 00:00:32 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-08 16:27:55.410000 |  |  |  | CC5 BW33BJGP |  | 75 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 16:42:39.530000 |  |  |  | CC5 BW33BJGP |  | 61 |  | 60 | 00:00:00 | Borcherds [NAME] (M22), Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 16:43:11.520000 |  |  |  | CC5 BW33BJGP |  | 68 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 16:44:20.270000 |  |  |  | CC5 BW33BJGP |  | 75 |  | 60 | 00:00:10 | Settlers Way, [NAME], Western Cape
 | 2023-03-08 16:49:03.110000 |  |  |  | CC5 BW33BJGP |  | 90 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 17:15:54.090000 |  |  |  | CC5 BW33BJGP |  | 61 |  | 60 | 00:00:00 | 67 Durham Avenue, Salt River, Cape Town, Western Cape