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: 70IK CA299905

 |  |  |  | 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
 | 70IK CA299905 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
 | 63 |  |  |  |  |  |  | 100km/h |  |  |  |  | 00h13m55s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 17:27:55.210000 |  |  |  | 70IK CA299905 |  | 42 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 22:19:37.790000 |  |  |  | 70IK CA299905 |  | 66 |  | 60 | 00:00:23 | [NAME], [NAME], Cape Town, Western Cape
 | 2023-03-04 06:53:00.140000 |  |  |  | 70IK CA299905 |  | 64 |  | 60 | 00:00:01 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:24:52.870000 |  |  |  | 70IK CA299905 |  | 100 |  | 60 | 00:00:00 | R45, 4.48 km SE of Klapmuts, Western Cape
 | 2023-03-04 07:27:30.630000 |  |  |  | 70IK CA299905 |  | 76 |  | 60 | 00:00:02 | R45, 8.42 km SE of Klapmuts, Western Cape
 | 2023-03-04 07:40:52.690000 |  |  |  | 70IK CA299905 |  | 92 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 07:43:00.030000 |  |  |  | 70IK CA299905 |  | 81 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-04 08:06:50.480000 |  |  |  | 70IK CA299905 |  | 90 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-04 08:07:54.330000 |  |  |  | 70IK CA299905 |  | 87 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 08:08:58.730000 |  |  |  | 70IK CA299905 |  | 98 |  | 80 | 00:00:32 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-04 08:30:08.590000 |  |  |  | 70IK CA299905 |  | 61 |  | 60 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-04 08:46:18.310000 |  |  |  | 70IK CA299905 |  | 81 |  | 80 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-04 09:03:22.190000 |  |  |  | 70IK CA299905 |  | 70 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 09:14:34.440000 |  |  |  | 70IK CA299905 |  | 38 |  | 20 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 09:56:56.730000 |  |  |  | 70IK CA299905 |  | 43 |  | 40 | 00:00:32 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 10:50:48.830000 |  |  |  | 70IK CA299905 |  | 57 |  | 50 | 00:01:36 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 10:52:39.610000 |  |  |  | 70IK CA299905 |  | 75 |  | 60 | 00:00:13 | Settlers, [NAME], Western Cape
 | 2023-03-04 10:58:48.630000 |  |  |  | 70IK CA299905 |  | 84 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-04 11:00:53.860000 |  |  |  | 70IK CA299905 |  | 84 |  | 80 | 00:00:05 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-04 11:02:32.590000 |  |  |  | 70IK CA299905 |  | 81 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-04 11:40:04.480000 |  |  |  | 70IK CA299905 |  | 67 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 11:41:04.530000 |  |  |  | 70IK CA299905 |  | 68 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 13:25:07.760000 |  |  |  | 70IK CA299905 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 13:31:31.500000 |  |  |  | 70IK CA299905 |  | 70 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 14:03:55.400000 |  |  |  | 70IK CA299905 |  | 76 |  | 60 | 00:00:17 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-06 14:40:53.490000 |  |  |  | 70IK CA299905 |  | 61 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 13:10:30.160000 |  |  |  | 70IK CA299905 |  | 73 |  | 60 | 00:00:01 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 13:33:03.690000 |  |  |  | 70IK CA299905 |  | 91 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-07 15:04:09.210000 |  |  |  | 70IK CA299905 |  | 61 |  | 60 | 00:00:12 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-07 15:07:53.140000 |  |  |  | 70IK CA299905 |  | 77 |  | 60 | 00:00:00 | Cape Town, Cape Town, Western Cape
 | 2023-03-07 17:50:28.530000 |  |  |  | 70IK CA299905 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 17:52:04.340000 |  |  |  | 70IK CA299905 |  | 81 |  | 80 | 00:00:00 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-07 18:10:10.710000 |  |  |  | 70IK CA299905 |  | 62 |  | 60 | 00:00:14 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-07 18:20:20.360000 |  |  |  | 70IK CA299905 |  | 67 |  | 60 | 00:00:32 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-07 18:24:36.020000 |  |  |  | 70IK CA299905 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-08 07:26:41.610000 |  |  |  | 70IK CA299905 |  | 68 |  | 60 | 00:00:07 | Cannon, Maitland, Cape Town, Western Cape
 | 2023-03-08 07:28:37.510000 |  |  |  | 70IK CA299905 |  | 64 |  | 60 | 00:00:00 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-08 07:28:59.130000 |  |  |  | 70IK CA299905 |  | 87 |  | 80 | 00:00:00 | Black River Parkway (M5), Maitland Garden Village, Cape Town, Western Cape
 | 2023-03-08 07:31:04 |  |  |  | 70IK CA299905 |  | 89 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 07:36:24.070000 |  |  |  | 70IK CA299905 |  | 89 |  | 80 | 00:01:04 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-08 08:11:58.150000 |  |  |  | 70IK CA299905 |  | 56 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 09:01:43.160000 |  |  |  | 70IK CA299905 |  | 71 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 09:02:50.230000 |  |  |  | 70IK CA299905 |  | 75 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-08 09:20:52.740000 |  |  |  | 70IK CA299905 |  | 61 |  | 60 | 00:00:00 | Settlers, [NAME], Cape Town, Western Cape
 | 2023-03-08 09:35:19.210000 |  |  |  | 70IK CA299905 |  | 84 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-08 09:36:08.490000 |  |  |  | 70IK CA299905 |  | 70 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:36:30.900000 |  |  |  | 70IK CA299905 |  | 63 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:49:17.760000 |  |  |  | 70IK CA299905 |  | 67 |  | 60 | 00:00:58 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:52:10.130000 |  |  |  | 70IK CA299905 |  | 66 |  | 60 | 00:00:00 | 53 [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-08 10:59:33.300000 |  |  |  | 70IK CA299905 |  | 71 |  | 60 | 00:00:00 | 113 Voortrekker Road, Salt River, Cape Town, Western Cape
 | 2023-03-08 11:04:21.070000 |  |  |  | 70IK CA299905 |  | 78 |  | 60 | 00:00:00 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-08 11:06:29.260000 |  |  |  | 70IK CA299905 |  | 85 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 11:13:25.260000 |  |  |  | 70IK CA299905 |  | 67 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 11:15:01.560000 |  |  |  | 70IK CA299905 |  | 84 |  | 70 | 00:00:00 | Borcherds [NAME] (M22), Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 12:57:45.900000 |  |  |  | 70IK CA299905 |  | 52 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 12:59:11.590000 |  |  |  | 70IK CA299905 |  | 73 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-08 13:04:09.730000 |  |  |  | 70IK CA299905 |  | 85 |  | 80 | 00:01:36 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 13:07:53.110000 |  |  |  | 70IK CA299905 |  | 83 |  | 80 | 00:01:04 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-08 13:09:52.790000 |  |  |  | 70IK CA299905 |  | 71 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 13:09:55.730000 |  |  |  | 70IK CA299905 |  | 72 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 13:10:15.460000 |  |  |  | 70IK CA299905 |  | 70 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 13:25:16.350000 |  |  |  | 70IK CA299905 |  | 66 |  | 60 | [NAME] | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 13:43:11.910000 |  |  |  | 70IK CA299905 |  | 90 |  | 60 | 00:00:13 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape