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: 214 CA214230

 |  |  |  | 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
 | 214 CA214230 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
 | 57 |  |  |  |  |  |  | 92km/h |  |  |  |  | 00h10m19s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 13:31:42.780000 |  |  |  | 214 CA214230 |  | 66 |  | 60 | 00:00:00 | Marine, Foreshore, Cape Town, Western Cape
 | 2023-03-03 13:37:02.690000 |  |  |  | 214 CA214230 |  | 66 |  | 60 | 00:00:00 | [NAME] (R27), Metro Industrial Township, Milnerton, Western Cape
 | 2023-03-03 13:43:26.730000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | [NAME] (R27), Milnerton, Milnerton, Western Cape
 | 2023-03-03 13:44:30.440000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:32 | Otto du Plessis Drive (R27), Milnerton, Milnerton, Western Cape
 | 2023-03-03 13:54:38.390000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | [NAME] (M14), Table View, Milnerton, Western Cape
 | 2023-03-03 20:30:20.740000 |  |  |  | 214 CA214230 |  | 62 |  | 60 | 00:00:00 | [NAME] (M14), Table View, Milnerton, Western Cape
 | 2023-03-03 20:33:00.210000 |  |  |  | 214 CA214230 |  | 72 |  | 70 | 00:00:00 | Otto du Plessis Drive (R27), Milnerton, Milnerton, Western Cape
 | 2023-03-03 20:41:00.790000 |  |  |  | 214 CA214230 |  | 62 |  | 60 | 00:00:00 | Marine, Milnerton, Milnerton, Western Cape
 | 2023-03-03 21:17:48.560000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:01:04 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-03 21:22:36.380000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 16:58:49.430000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-04 22:40:08.690000 |  |  |  | 214 CA214230 |  | 64 |  | 60 | 00:00:32 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 22:44:56.570000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 10:19:43.430000 |  |  |  | 214 CA214230 |  | 84 |  | 80 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-05 10:20:47.940000 |  |  |  | 214 CA214230 |  | 84 |  | 80 | 00:00:43 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-05 10:58:39.710000 |  |  |  | 214 CA214230 |  | 83 |  | 80 | 00:00:00 | Suid [NAME], 6.1 km SW of Paarl, Western Cape
 | 2023-03-05 12:52:00.840000 |  |  |  | 214 CA214230 |  | 81 |  | 80 | 00:00:00 | Suid Agter Paarl, 6.13 km SW of Paarl, Western Cape
 | 2023-03-05 16:44:36.100000 |  |  |  | 214 CA214230 |  | 82 |  | 80 | 00:00:32 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-05 17:03:48.750000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 17:47:04.500000 |  |  |  | 214 CA214230 |  | 72 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-05 17:51:52.280000 |  |  |  | 214 CA214230 |  | 75 |  | 60 | 00:01:04 | [NAME] (R27), Metro Industrial Township, Milnerton, Western Cape
 | 2023-03-05 17:55:04.860000 |  |  |  | 214 CA214230 |  | 68 |  | 60 | 00:00:00 | Marine, Milnerton, Milnerton, Western Cape
 | 2023-03-05 17:56:08.810000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | Otto du Plessis Drive (R27), Milnerton, Milnerton, Western Cape
 | 2023-03-05 17:58:48.670000 |  |  |  | 214 CA214230 |  | 73 |  | 70 | 00:00:00 | Otto du Plessis, Milnerton, Milnerton, Western Cape
 | 2023-03-05 17:59:52.200000 |  |  |  | 214 CA214230 |  | 73 |  | 70 | 00:01:04 | Otto du Plessis, Milnerton, Milnerton, Western Cape
 | 2023-03-05 18:02:00.260000 |  |  |  | 214 CA214230 |  | 69 |  | 60 | 00:00:32 | Otto du Plessis Drive (R27), Table View, Milnerton, Western Cape
 | 2023-03-05 18:03:36 |  |  |  | 214 CA214230 |  | 71 |  | 60 | 00:00:00 | Otto du Plessis Drive (R27), [NAME], Milnerton, Western Cape
 | 2023-03-05 18:04:40.700000 |  |  |  | 214 CA214230 |  | 80 |  | 70 | 00:00:00 | Otto du Plessis Drive (R27), Sunningdale, Milnerton, Western Cape
 | 2023-03-05 18:14:48.940000 |  |  |  | 214 CA214230 |  | 68 |  | 60 | 00:00:00 | Otto du Plessis, Melkbosstrand, Melkbosstrand, Western Cape
 | 2023-03-05 21:32:13.350000 |  |  |  | 214 CA214230 |  | 71 |  | 70 | 00:00:00 | Otto du Plessis, Sunningdale, Milnerton, Western Cape
 | 2023-03-05 21:33:17.210000 |  |  |  | 214 CA214230 |  | 75 |  | 70 | 00:00:00 | Otto du Plessis, [NAME], Milnerton, Western Cape
 | 2023-03-05 21:34:21.920000 |  |  |  | 214 CA214230 |  | 71 |  | 70 | 00:00:00 | Otto du Plessis, [NAME], Milnerton, Western Cape
 | 2023-03-05 21:35:57.560000 |  |  |  | 214 CA214230 |  | 73 |  | 60 | 00:00:00 | Otto du Plessis Drive (R27), Milnerton, Milnerton, Western Cape
 | 2023-03-05 21:37:01.610000 |  |  |  | 214 CA214230 |  | 73 |  | 70 | 00:00:00 | Otto du Plessis, Milnerton, Milnerton, Western Cape
 | 2023-03-05 21:40:13.480000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:01:04 | Otto du Plessis, Milnerton, Milnerton, Western Cape
 | 2023-03-05 21:42:21.600000 |  |  |  | 214 CA214230 |  | 67 |  | 60 | 00:00:00 | 38 Union Road, Milnerton, Western Cape
 | 2023-03-05 21:57:49.660000 |  |  |  | 214 CA214230 |  | 74 |  | 60 | 00:00:00 | [NAME] (R27), Metro Industrial Township, Milnerton, Western Cape
 | 2023-03-05 21:59:25.810000 |  |  |  | 214 CA214230 |  | 82 |  | 80 | 00:01:04 | [NAME] (R27), Foreshore, Cape Town, Western Cape
 | 2023-03-05 22:29:16.440000 |  |  |  | 214 CA214230 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 17:02:02.260000 |  |  |  | 214 CA214230 |  | 66 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 17:15:54.340000 |  |  |  | 214 CA214230 |  | 57 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 17:47:21.010000 |  |  |  | 214 CA214230 |  | 92 |  | 60 | 00:00:00 | N1, Boston, Bellville, Western Cape
 | 2023-03-06 18:00:09.930000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 18:36:28.460000 |  |  |  | 214 CA214230 |  | 68 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 18:40:44.760000 |  |  |  | 214 CA214230 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 09:52:01.420000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | 20 Verwood Road, Lakeside, Cape Town, Western Cape
 | 2023-03-07 11:49:07.690000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | Main Road (M4), Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-07 11:56:03.440000 |  |  |  | 214 CA214230 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-07 12:04:03.360000 |  |  |  | 214 CA214230 |  | 65 |  | 60 | 00:00:00 | Silvermine, Silver Mine Village, Noordhoek, Western Cape
 | 2023-03-07 23:21:57.250000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:32 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 16:50:29.710000 |  |  |  | 214 CA214230 |  | 75 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 20:24:54.580000 |  |  |  | 214 CA214230 |  | 67 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 23:16:45.790000 |  |  |  | 214 CA214230 |  | 75 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 23:17:49.380000 |  |  |  | 214 CA214230 |  | 67 |  | 60 | 00:00:00 | 160 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-08 23:21:01.280000 |  |  |  | 214 CA214230 |  | 74 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 08:04:09.460000 |  |  |  | 214 CA214230 |  | 61 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 08:21:45.290000 |  |  |  | 214 CA214230 |  | 55 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape