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: CQ15 CA90348

 |  |  |  | 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
 | CQ15 CA90348 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
 | 97 |  |  |  |  |  |  | 93km/h |  |  |  |  | 00h23m20s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 11:11:35.910000 |  |  |  | CQ15 CA90348 |  | 41 |  | 40 | 00:00:32 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 11:37:36.050000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | [NAME] der [NAME] (M3), Bishopscourt, Cape Town, Western Cape
 | 2023-03-03 11:37:37.640000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | [NAME] der [NAME] (M3), Bishopscourt, Cape Town, Western Cape
 | 2023-03-03 11:37:43.650000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:01 | [NAME] Stel, Bishopscourt, Cape Town, Western Cape
 | 2023-03-03 11:44:39.860000 |  |  |  | CQ15 CA90348 |  | 84 |  | 80 | 00:00:00 | [NAME] Stel, Kirstenhof, Cape Town, Western Cape
 | 2023-03-03 11:59:35.620000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-03 12:02:15.780000 |  |  |  | CQ15 CA90348 |  | 76 |  | 60 | 00:00:00 | Glencairn, Sunnydale, [NAME], Western Cape
 | 2023-03-03 12:05:27.460000 |  |  |  | CQ15 CA90348 |  | 70 |  | 60 | 00:00:00 | [NAME], Glencairn Heights, [NAME]'s Town, Western Cape
 | 2023-03-03 16:55:30.380000 |  |  |  | CQ15 CA90348 |  | 66 |  | 60 | 00:00:00 | [NAME] Scarborough, Scarborough, Western Cape
 | 2023-03-03 16:59:46.360000 |  |  |  | CQ15 CA90348 |  | 57 |  | 50 | 00:00:00 | Witsand, [NAME], Scarborough, Western Cape
 | 2023-03-03 17:19:30.470000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:00 | [NAME] (M65), Sunnydale, [NAME], Western Cape
 | 2023-03-03 17:26:26.340000 |  |  |  | CQ15 CA90348 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-03 17:37:58.070000 |  |  |  | CQ15 CA90348 |  | 36 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 17:39:02.930000 |  |  |  | CQ15 CA90348 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 17:40:06.430000 |  |  |  | CQ15 CA90348 |  | 37 |  | 20 | 00:01:04 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 17:51:53.720000 |  |  |  | CQ15 CA90348 |  | 48 |  | 40 | 00:02:09 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 17:56:10.760000 |  |  |  | CQ15 CA90348 |  | 40 |  | 20 | 00:01:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 18:11:38.410000 |  |  |  | CQ15 CA90348 |  | 64 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 18:12:13.020000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:01 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 18:13:04.030000 |  |  |  | CQ15 CA90348 |  | 59 |  | 40 | 00:00:09 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-03 18:14:49.320000 |  |  |  | CQ15 CA90348 |  | 45 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-03 18:19:37.860000 |  |  |  | CQ15 CA90348 |  | 41 |  | 40 | 00:00:00 | The [NAME], Clifton, Cape Town, Western Cape
 | 2023-03-03 18:54:35.280000 |  |  |  | CQ15 CA90348 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-03 18:57:47.850000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:36:45.160000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:41:01.030000 |  |  |  | CQ15 CA90348 |  | 81 |  | 80 | 00:00:32 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-04 09:23:51.840000 |  |  |  | CQ15 CA90348 |  | 42 |  | 40 | 00:00:00 | The [NAME], Clifton, Cape Town, Western Cape
 | 2023-03-04 09:41:15.210000 |  |  |  | CQ15 CA90348 |  | 54 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:42:07.600000 |  |  |  | CQ15 CA90348 |  | 65 |  | 60 | 00:00:12 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-04 10:59:58.480000 |  |  |  | CQ15 CA90348 |  | 37 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:01:02.060000 |  |  |  | CQ15 CA90348 |  | 32 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:08:30.890000 |  |  |  | CQ15 CA90348 |  | 45 |  | 40 | 00:01:04 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:10:06.460000 |  |  |  | CQ15 CA90348 |  | 46 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:17:02.600000 |  |  |  | CQ15 CA90348 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:19:10.180000 |  |  |  | CQ15 CA90348 |  | 30 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:24:30.460000 |  |  |  | CQ15 CA90348 |  | 46 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-04 11:25:34.420000 |  |  |  | CQ15 CA90348 |  | 46 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-05 08:48:28.560000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 08:51:58.740000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 08:52:44.680000 |  |  |  | CQ15 CA90348 |  | 81 |  | 80 | 00:00:32 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 18:16:47.020000 |  |  |  | CQ15 CA90348 |  | 61 |  | 40 | 00:00:01 | [NAME] (M3), Rondebosch, Cape Town, Western Cape
 | 2023-03-05 18:22:13.040000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-05 18:31:10.340000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 06:49:56.790000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 08:22:04.270000 |  |  |  | CQ15 CA90348 |  | 70 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 12:26:39.600000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:02:40 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-06 12:38:56.100000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-06 12:41:03.240000 |  |  |  | CQ15 CA90348 |  | 66 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-06 12:42:07.080000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:00 | Helshoogte, [NAME], Franschhoek, Western Cape
 | 2023-03-06 14:44:28.050000 |  |  |  | CQ15 CA90348 |  | 93 |  | 80 | 00:01:36 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-06 14:47:08.670000 |  |  |  | CQ15 CA90348 |  | 72 |  | 60 | 00:00:00 | [NAME] (R301), [NAME], Franschhoek, Western Cape
 | 2023-03-06 14:48:12.190000 |  |  |  | CQ15 CA90348 |  | 83 |  | 80 | 00:00:00 | [NAME] (R301), [NAME], Franschhoek, Western Cape
 | 2023-03-06 14:50:20.740000 |  |  |  | CQ15 CA90348 |  | 86 |  | 80 | 00:00:00 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-06 14:54:04.080000 |  |  |  | CQ15 CA90348 |  | 90 |  | 80 | 00:00:00 | [NAME], 10.69 km NE of Kylemore, Western Cape
 | 2023-03-06 14:56:44.930000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:00:00 | [NAME] (R301), 7.96 km SE of [NAME], Western Cape
 | 2023-03-06 15:04:44.100000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:00 | Main, De Zoete Inval, [NAME], Western Cape
 | 2023-03-06 15:06:52.840000 |  |  |  | CQ15 CA90348 |  | 85 |  | 80 | 00:00:32 | Suid [NAME], 6.14 km SW of Paarl, Western Cape
 | 2023-03-06 17:32:14.790000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:02:08 | Suid Agter Paarl, 5.89 km SW of Paarl, Western Cape
 | 2023-03-06 17:54:06.710000 |  |  |  | CQ15 CA90348 |  | 89 |  | 60 | 00:00:00 | Old Oak Road (M31), [NAME], Bellville, Western Cape
 | 2023-03-06 18:33:32.130000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-06 18:38:52.670000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 04:23:45.780000 |  |  |  | CQ15 CA90348 |  | 67 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 04:24:18.740000 |  |  |  | CQ15 CA90348 |  | 65 |  | 60 | 00:00:00 | [NAME] (N2), Zonnebloem, Cape Town, Western Cape
 | 2023-03-07 04:37:06.190000 |  |  |  | CQ15 CA90348 |  | 68 |  | 60 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 04:41:54.340000 |  |  |  | CQ15 CA90348 |  | 56 |  | 50 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 04:42:58.650000 |  |  |  | CQ15 CA90348 |  | 89 |  | 50 | 00:00:32 | Airport Approach Road, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 04:43:41.590000 |  |  |  | CQ15 CA90348 |  | 78 |  | 60 | 00:00:21 | Settlers Way, [NAME], Western Cape
 | 2023-03-07 05:35:48.240000 |  |  |  | CQ15 CA90348 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 05:39:32.830000 |  |  |  | CQ15 CA90348 |  | 91 |  | 80 | 00:00:11 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 05:43:38.690000 |  |  |  | CQ15 CA90348 |  | 66 |  | 60 | 00:00:10 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-07 08:05:54.290000 |  |  |  | CQ15 CA90348 |  | 77 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 08:11:46.820000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 08:18:42.820000 |  |  |  | CQ15 CA90348 |  | 68 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 08:25:27.130000 |  |  |  | CQ15 CA90348 |  | 46 |  | 20 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 10:04:55.240000 |  |  |  | CQ15 CA90348 |  | 63 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 10:06:11.940000 |  |  |  | CQ15 CA90348 |  | 81 |  | 80 | 00:00:13 | Settlers Way, [NAME], Western Cape
 | 2023-03-07 19:28:03.240000 |  |  |  | CQ15 CA90348 |  | 91 |  | 80 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 19:28:42.860000 |  |  |  | CQ15 CA90348 |  | 87 |  | 80 | 00:00:03 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 19:28:58.910000 |  |  |  | CQ15 CA90348 |  | 82 |  | 80 | 00:00:09 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 20:15:08.460000 |  |  |  | CQ15 CA90348 |  | 66 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-07 20:29:00.470000 |  |  |  | CQ15 CA90348 |  | 61 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 20:34:52.180000 |  |  |  | CQ15 CA90348 |  | 62 |  | 50 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 20:36:35.470000 |  |  |  | CQ15 CA90348 |  | 79 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-07 20:45:00.600000 |  |  |  | CQ15 CA90348 |  | 62 |  | 60 | 00:00:00 | Black River Parkway (M5), Ndabeni, Cape Town, Western Cape
 | 2023-03-08 08:52:41.500000 |  |  |  | CQ15 CA90348 |  | 44 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 08:53:45.310000 |  |  |  | CQ15 CA90348 |  | 57 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 08:55:53.150000 |  |  |  | CQ15 CA90348 |  | 64 |  | 60 | 00:00:02 | Settlers, [NAME], Western Cape
 | 2023-03-08 09:50:52.480000 |  |  |  | CQ15 CA90348 |  | 66 |  | 60 | 00:00:00 | Settlers, [NAME], Cape Town, Western Cape
 | 2023-03-08 12:05:14.100000 |  |  |  | CQ15 CA90348 |  | 44 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 12:07:22.360000 |  |  |  | CQ15 CA90348 |  | 45 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 12:13:26.760000 |  |  |  | CQ15 CA90348 |  | 42 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 12:14:30.740000 |  |  |  | CQ15 CA90348 |  | 51 |  | 50 | 00:02:15 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 15:50:21.510000 |  |  |  | CQ15 CA90348 |  | 63 |  | 60 | 00:00:05 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-09 08:33:50.380000 |  |  |  | CQ15 CA90348 |  | 67 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 08:55:07.800000 |  |  |  | CQ15 CA90348 |  | 34 |  | 20 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 09:16:05.380000 |  |  |  | CQ15 CA90348 |  | 60 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 09:17:40.220000 |  |  |  | CQ15 CA90348 |  | 65 |  | 60 | 00:00:01 | Settlers Way (N2), [NAME], Western Cape