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: 228 CAA54098

 |  |  |  | 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
 | 228 CAA54098 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
 | 48 |  |  |  |  |  |  | 102km/h |  |  |  |  | 00h20m22s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-07 08:55:41.640000 |  |  |  | 228 CAA54098 |  | 41 |  | 40 | 00:00:00 | 109 Victoria Road, Bakoven, Cape Town, Western Cape
 | 2023-03-07 08:58:21.380000 |  |  |  | 228 CAA54098 |  | 55 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-07 08:59:25.390000 |  |  |  | 228 CAA54098 |  | 62 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-07 09:01:33.390000 |  |  |  | 228 CAA54098 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-07 09:06:21.190000 |  |  |  | 228 CAA54098 |  | 61 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-07 09:24:43.100000 |  |  |  | 228 CAA54098 |  | 43 |  | 20 | 00:00:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-07 09:25:48.920000 |  |  |  | 228 CAA54098 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-07 09:27:03.750000 |  |  |  | 228 CAA54098 |  | 44 |  | 40 | 00:00:46 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-07 09:41:53.340000 |  |  |  | 228 CAA54098 |  | 30 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-07 09:43:49.920000 |  |  |  | 228 CAA54098 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-07 09:47:50.420000 |  |  |  | 228 CAA54098 |  | 41 |  | 40 | 00:00:07 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-07 09:48:43.940000 |  |  |  | 228 CAA54098 |  | 62 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-07 09:50:05.720000 |  |  |  | 228 CAA54098 |  | 74 |  | 70 | 00:00:32 | [NAME], Meadowsteads, Noordhoek, Western Cape
 | 2023-03-07 10:00:45.350000 |  |  |  | 228 CAA54098 |  | 75 |  | 70 | 00:00:25 | Slangkop Road (M65), Ocean View, Cape Town, Western Cape
 | 2023-03-07 14:40:51.260000 |  |  |  | 228 CAA54098 |  | 61 |  | 60 | 00:00:00 | Main Road (M4), Marine Oil Refinery, [NAME]'s Town, Western Cape
 | 2023-03-07 14:46:43.450000 |  |  |  | 228 CAA54098 |  | 65 |  | 60 | 00:00:05 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-08 07:08:11.920000 |  |  |  | 228 CAA54098 |  | 65 |  | 60 | 00:00:00 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-08 07:10:46.190000 |  |  |  | 228 CAA54098 |  | 81 |  | 80 | 00:00:05 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 07:36:27.830000 |  |  |  | 228 CAA54098 |  | 87 |  | 60 | 00:02:08 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 08:33:34.530000 |  |  |  | 228 CAA54098 |  | 61 |  | 60 | [NAME] | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 17:31:15.550000 |  |  |  | 228 CAA54098 |  | 86 |  | 80 | 00:00:00 | [NAME] (R310), Eersterivier-Suid, [NAME], Western Cape
 | 2023-03-08 17:34:27.400000 |  |  |  | 228 CAA54098 |  | 84 |  | 80 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-08 17:35:56.890000 |  |  |  | 228 CAA54098 |  | 84 |  | 60 | 00:03:23 | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 17:56:19.040000 |  |  |  | 228 CAA54098 |  | 66 |  | 60 | [NAME] | Annandale, [NAME], Stellenbosch, Western Cape
 | 2023-03-08 18:01:39.810000 |  |  |  | 228 CAA54098 |  | 97 |  | 80 | 00:01:36 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-08 18:22:50.590000 |  |  |  | 228 CAA54098 |  | 86 |  | 80 | 00:00:20 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-08 18:24:03.630000 |  |  |  | 228 CAA54098 |  | 85 |  | 80 | 00:00:32 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-09 09:16:29.700000 |  |  |  | 228 CAA54098 |  | 81 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Cape Town, Cape Town, Western Cape
 | 2023-03-09 09:22:21.770000 |  |  |  | 228 CAA54098 |  | 85 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 09:22:53.580000 |  |  |  | 228 CAA54098 |  | 83 |  | 80 | 00:00:35 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-09 09:45:49.320000 |  |  |  | 228 CAA54098 |  | 83 |  | 70 | 00:00:00 | N2, Somerset West, [NAME]
 | 2023-03-09 09:50:05.780000 |  |  |  | 228 CAA54098 |  | 78 |  | 70 | 00:00:00 | N2, Die Bos, Strand, Western Cape
 | 2023-03-09 09:54:21.530000 |  |  |  | 228 CAA54098 |  | 84 |  | 80 | 00:00:32 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-09 09:55:57.200000 |  |  |  | 228 CAA54098 |  | 81 |  | 80 | 00:00:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-09 09:59:09.070000 |  |  |  | 228 CAA54098 |  | 64 |  | 60 | 00:00:00 | Sir [NAME]'s Pass Road, [NAME], Strand, Western Cape
 | 2023-03-09 10:00:45.490000 |  |  |  | 228 CAA54098 |  | 64 |  | 60 | 00:00:00 | 24 Sir [NAME]'s Pass Road, Winslow, [NAME]'s Bay, Western Cape
 | 2023-03-09 10:02:53.790000 |  |  |  | 228 CAA54098 |  | 62 |  | 60 | 00:00:00 | Faure Marine, [NAME]'s Bay, Gordon's Bay, Western Cape
 | 2023-03-09 10:04:29.430000 |  |  |  | 228 CAA54098 |  | 61 |  | 60 | 00:00:00 | Faure Marine, [NAME]'s Bay, Gordon's Bay, Western Cape
 | 2023-03-09 10:06:37.080000 |  |  |  | 228 CAA54098 |  | 65 |  | 60 | 00:00:00 | Faure Marine Drive (R44), [NAME]'s Bay, Gordon's Bay, Western Cape
 | 2023-03-09 10:08:13.520000 |  |  |  | 228 CAA54098 |  | 64 |  | 60 | 00:00:00 | Faure Marine Drive (R44), [NAME]'s Bay, Gordon's Bay, Western Cape
 | 2023-03-09 10:08:45.340000 |  |  |  | 228 CAA54098 |  | 62 |  | 60 | 00:00:00 | Faure Marine Drive (R44), [NAME]'s Bay, Gordon's Bay, Western Cape
 | 2023-03-09 10:17:17.110000 |  |  |  | 228 CAA54098 |  | 74 |  | 60 | 00:00:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-09 10:22:59.210000 |  |  |  | 228 CAA54098 |  | 68 |  | 60 | [NAME] | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-09 10:29:19.750000 |  |  |  | 228 CAA54098 |  | 102 |  | 100 | 00:00:00 | N2, Grabouw, Grabouw, Western Cape
 | 2023-03-09 11:10:27.760000 |  |  |  | 228 CAA54098 |  | 81 |  | 80 | 00:00:30 | N2, 8.2 km SE of Grabouw, Western Cape
 | 2023-03-09 11:13:20.190000 |  |  |  | 228 CAA54098 |  | 87 |  | 80 | 00:00:32 | N2, 7.61 km NW of Botrivier, Western Cape
 | 2023-03-09 11:14:56.030000 |  |  |  | 228 CAA54098 |  | 95 |  | 80 | 00:01:04 | N2, 5.45 km NW of Botrivier, Western Cape
 | 2023-03-09 11:16:41.220000 |  |  |  | 228 CAA54098 |  | 82 |  | 80 | 00:00:00 | N2, 3.09 km NW of Botrivier, Western Cape