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: 202 CS61VJGP

 |  |  |  | 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
 | 202 CS61VJGP 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
 | 54 |  |  |  |  |  |  | 97km/h |  |  |  |  | 00h26m20s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 09:03:40.390000 |  |  |  | 202 CS61VJGP |  | 68 |  | 60 | 00:00:24 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-03 10:30:10.930000 |  |  |  | 202 CS61VJGP |  | 71 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-03 13:25:21.550000 |  |  |  | 202 CS61VJGP |  | 82 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-03 16:35:53.410000 |  |  |  | 202 CS61VJGP |  | 63 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-03 17:13:45.170000 |  |  |  | 202 CS61VJGP |  | 70 |  | 60 | 00:01:36 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-03 17:24:57.250000 |  |  |  | 202 CS61VJGP |  | 61 |  | 60 | 00:00:00 | 84 New Market Street, Foreshore, Cape Town, Western Cape
 | 2023-03-03 18:19:53.370000 |  |  |  | 202 CS61VJGP |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:14:13.170000 |  |  |  | 202 CS61VJGP |  | 85 |  | 80 | 00:00:32 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-04 08:35:14.710000 |  |  |  | 202 CS61VJGP |  | 77 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Cape Town, Cape Town, Western Cape
 | 2023-03-04 08:40:02.910000 |  |  |  | 202 CS61VJGP |  | 82 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:41:38.770000 |  |  |  | 202 CS61VJGP |  | 82 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 08:48:02.630000 |  |  |  | 202 CS61VJGP |  | 67 |  | 60 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 09:04:34.140000 |  |  |  | 202 CS61VJGP |  | 52 |  | 50 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 09:06:15.240000 |  |  |  | 202 CS61VJGP |  | 72 |  | 60 | 00:00:14 | Settlers, [NAME], Western Cape
 | 2023-03-04 09:16:11.760000 |  |  |  | 202 CS61VJGP |  | 61 |  | 60 | 00:00:00 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-04 09:16:22.540000 |  |  |  | 202 CS61VJGP |  | 67 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-04 09:16:50.130000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-04 23:08:06.580000 |  |  |  | 202 CS61VJGP |  | 64 |  | 60 | 00:00:32 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 06:34:59.130000 |  |  |  | 202 CS61VJGP |  | 69 |  | 60 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 06:37:07.530000 |  |  |  | 202 CS61VJGP |  | 68 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 06:57:23.630000 |  |  |  | 202 CS61VJGP |  | 64 |  | 60 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-06 07:10:11.380000 |  |  |  | 202 CS61VJGP |  | 68 |  | 60 | 00:03:43 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 08:55:22.540000 |  |  |  | 202 CS61VJGP |  | 63 |  | 60 | [NAME] | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 09:00:10.450000 |  |  |  | 202 CS61VJGP |  | 83 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-06 13:05:11.630000 |  |  |  | 202 CS61VJGP |  | 83 |  | 80 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-06 16:45:36.250000 |  |  |  | 202 CS61VJGP |  | 82 |  | 60 | 00:01:36 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 16:48:48.710000 |  |  |  | 202 CS61VJGP |  | 65 |  | 60 | 00:00:32 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 17:04:48.030000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | Strand, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 17:11:12.430000 |  |  |  | 202 CS61VJGP |  | 82 |  | 60 | 00:02:08 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-06 17:18:40.180000 |  |  |  | 202 CS61VJGP |  | 84 |  | 80 | 00:01:04 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-06 17:37:20.180000 |  |  |  | 202 CS61VJGP |  | 97 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Western Cape
 | 2023-03-06 17:46:56.310000 |  |  |  | 202 CS61VJGP |  | 62 |  | 60 | 00:00:32 | Liesbeek, Observatory, Cape Town, Western Cape
 | 2023-03-08 09:06:17.240000 |  |  |  | 202 CS61VJGP |  | 82 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:07:53.050000 |  |  |  | 202 CS61VJGP |  | 84 |  | 80 | 00:01:06 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-08 09:51:05.060000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | [NAME] (R301), 7.87 km SE of [NAME], Western Cape
 | 2023-03-08 09:52:09.650000 |  |  |  | 202 CS61VJGP |  | 87 |  | 80 | 00:02:08 | [NAME], 9.32 km SE of [NAME], Western Cape
 | 2023-03-08 09:56:25.010000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | [NAME], [NAME], Franschhoek, Western Cape
 | 2023-03-08 10:01:13.310000 |  |  |  | 202 CS61VJGP |  | 86 |  | 80 | 00:01:36 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 10:03:53.490000 |  |  |  | 202 CS61VJGP |  | 90 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 11:27:08.060000 |  |  |  | 202 CS61VJGP |  | 88 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:20:55.730000 |  |  |  | 202 CS61VJGP |  | 61 |  | 60 | 00:00:00 | [NAME], Devonvallei, Stellenbosch, Western Cape
 | 2023-03-08 16:30:31.230000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 16:31:35.480000 |  |  |  | 202 CS61VJGP |  | 86 |  | 80 | 00:00:32 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 16:51:51.940000 |  |  |  | 202 CS61VJGP |  | 82 |  | 80 | 00:00:03 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 16:56:39.850000 |  |  |  | 202 CS61VJGP |  | 83 |  | 80 | 00:01:04 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-08 16:58:08.590000 |  |  |  | 202 CS61VJGP |  | 69 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 16:58:13.640000 |  |  |  | 202 CS61VJGP |  | 67 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 19:41:51.200000 |  |  |  | 202 CS61VJGP |  | 68 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 19:51:27.870000 |  |  |  | 202 CS61VJGP |  | 53 |  | 40 | 00:00:32 | Ring, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 19:54:07.470000 |  |  |  | 202 CS61VJGP |  | 41 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-08 21:03:34.330000 |  |  |  | 202 CS61VJGP |  | 82 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-08 21:04:38.720000 |  |  |  | 202 CS61VJGP |  | 66 |  | 60 | 00:00:02 | Settlers, [NAME], Western Cape
 | 2023-03-08 21:09:26.490000 |  |  |  | 202 CS61VJGP |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 21:11:02.020000 |  |  |  | 202 CS61VJGP |  | 79 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape