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: 224 CAA54100

 |  |  |  | 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
 | 224 CAA54100 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
 | 64 |  |  |  |  |  |  | 109km/h |  |  |  |  | 00h36m47s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 09:21:10.360000 |  |  |  | 224 CAA54100 |  | 64 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-03 09:51:50.420000 |  |  |  | 224 CAA54100 |  | 44 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-03 10:12:22.540000 |  |  |  | 224 CAA54100 |  | 73 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-03 10:13:58.470000 |  |  |  | 224 CAA54100 |  | 67 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Western Cape
 | 2023-03-04 08:09:47.350000 |  |  |  | 224 CAA54100 |  | 68 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-04 08:43:38.340000 |  |  |  | 224 CAA54100 |  | 50 |  | 40 | 00:00:00 | N1, 5.05 km SE of [NAME], Western Cape
 | 2023-03-04 08:50:02.600000 |  |  |  | 224 CAA54100 |  | 68 |  | 60 | 00:00:32 | N1, 7.6 km SE of [NAME], Western Cape
 | 2023-03-04 08:51:06.610000 |  |  |  | 224 CAA54100 |  | 71 |  | 60 | 00:00:00 | N1, 8.81 km SE of [NAME], Western Cape
 | 2023-03-04 08:57:58.850000 |  |  |  | 224 CAA54100 |  | 101 |  | 90 | 00:01:08 | N1, 11.38 km SE of Blouvlei, Western Cape
 | 2023-03-04 08:59:38.850000 |  |  |  | 224 CAA54100 |  | 102 |  | 90 | 00:01:36 | N1, 13.42 km SE of Blouvlei, Western Cape
 | 2023-03-04 09:01:28.540000 |  |  |  | 224 CAA54100 |  | 93 |  | 90 | 00:01:54 | N1, 11.71 km SW of Rawsonville, Western Cape
 | 2023-03-04 09:03:54.110000 |  |  |  | 224 CAA54100 |  | 102 |  | 90 | 00:00:32 | N1, 8.6 km SW of Rawsonville, Western Cape
 | 2023-03-04 09:16:42.450000 |  |  |  | 224 CAA54100 |  | 96 |  | 80 | 00:00:00 | N1, 4.82 km NW of Worcester, Western Cape
 | 2023-03-04 09:18:50.080000 |  |  |  | 224 CAA54100 |  | 63 |  | 60 | 00:00:00 | N1, [NAME], Worcester, Western Cape
 | 2023-03-04 10:13:38.890000 |  |  |  | 224 CAA54100 |  | 95 |  | 60 | 00:00:32 | R60, 22.05 km SE of Worcester, Western Cape
 | 2023-03-04 11:06:01.860000 |  |  |  | 224 CAA54100 |  | 74 |  | 60 | 00:00:46 | R60, 6.88 km W of Robertson, Western Cape
 | 2023-03-04 11:14:15.480000 |  |  |  | 224 CAA54100 |  | 77 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), [NAME], [NAME], Western Cape
 | 2023-03-04 11:28:39.900000 |  |  |  | 224 CAA54100 |  | 75 |  | 60 | 00:00:25 | R62, 3.04 km NE of Ashton, Western Cape
 | 2023-03-04 11:31:51.690000 |  |  |  | 224 CAA54100 |  | 71 |  | 60 | 00:00:21 | R62, 2.02 km SW of Montagu, Western Cape
 | 2023-03-04 11:35:35.420000 |  |  |  | 224 CAA54100 |  | 65 |  | 60 | 00:00:12 | 67 Lang Street, Montagu SP, Montagu, Western Cape
 | 2023-03-04 12:15:19.010000 |  |  |  | 224 CAA54100 |  | 89 |  | 80 | 00:00:00 | R62, Barrydale, Western Cape
 | 2023-03-04 13:36:16.510000 |  |  |  | 224 CAA54100 |  | 102 |  | 100 | 00:00:00 | R62, 7.35 km NE of Barrydale, Western Cape
 | 2023-03-04 13:42:40.440000 |  |  |  | 224 CAA54100 |  | 102 |  | 100 | 00:00:00 | R62, 16.97 km NE of Barrydale, Western Cape
 | 2023-03-04 13:44:16.490000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:32 | R62, 19.31 km NE of Barrydale, Western Cape
 | 2023-03-04 13:45:20.200000 |  |  |  | 224 CAA54100 |  | 102 |  | 100 | 00:00:00 | R62, 21.04 km NE of Barrydale, Western Cape
 | 2023-03-04 13:47:28.090000 |  |  |  | 224 CAA54100 |  | 102 |  | 100 | 00:00:00 | R62, 24.26 km NE of Barrydale, Western Cape
 | 2023-03-04 15:29:12.740000 |  |  |  | 224 CAA54100 |  | 102 |  | 100 | 00:00:00 | R328, 3.62 km SW of Oudtshoorn, Western Cape
 | 2023-03-04 18:09:25.930000 |  |  |  | 224 CAA54100 |  | 71 |  | 60 | 00:00:00 | Knysna Road (N9), 2.79 km NE of Thembalethu, Western Cape
 | 2023-03-04 18:12:37.920000 |  |  |  | 224 CAA54100 |  | 62 |  | 60 | 00:00:10 | N2, [NAME], George, Western Cape
 | 2023-03-04 18:14:39.070000 |  |  |  | 224 CAA54100 |  | 61 |  | 60 | 00:00:07 | N2, 2.96 km NW of Wilderness, Western Cape
 | 2023-03-04 18:15:49.230000 |  |  |  | 224 CAA54100 |  | 61 |  | 60 | 00:00:00 | N2, 2.31 km NW of Wilderness, Western Cape
 | 2023-03-04 18:16:21.440000 |  |  |  | 224 CAA54100 |  | 67 |  | 60 | 00:00:01 | N2, 2.07 km NW of Wilderness, Western Cape
 | 2023-03-04 18:17:57.110000 |  |  |  | 224 CAA54100 |  | 62 |  | 60 | 00:01:04 | N2, 1.06 km W of Wilderness, Western Cape
 | 2023-03-04 18:23:49.250000 |  |  |  | 224 CAA54100 |  | 84 |  | 80 | 00:01:04 | N2, Wilderness East, Wilderness, Western Cape
 | 2023-03-04 18:26:47.370000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:00 | N2, 2.54 km SW of Rondevlei, Western Cape
 | 2023-03-04 18:30:13.360000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:00 | N2, 4.68 km SE of Rondevlei, Western Cape
 | 2023-03-04 18:31:17.180000 |  |  |  | 224 CAA54100 |  | 109 |  | 100 | 00:00:00 | N2, 4.35 km NW of Sedgefield, Western Cape
 | 2023-03-04 18:33:25.850000 |  |  |  | 224 CAA54100 |  | 84 |  | 60 | 00:02:40 | N2, Sedgefield, Sedgefield, Western Cape
 | 2023-03-04 18:38:13.590000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:32 | N2, 5.44 km SE of Sedgefield, Western Cape
 | 2023-03-04 18:42:29.220000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:32 | N2, 11.51 km W of Knysna, Western Cape
 | 2023-03-04 18:46:45.460000 |  |  |  | 224 CAA54100 |  | 74 |  | 60 | 00:00:00 | N2, 7.07 km W of Knysna, Western Cape
 | 2023-03-04 18:51:26.080000 |  |  |  | 224 CAA54100 |  | 67 |  | 60 | 00:00:09 | Main, Eastford, Knysna, Western Cape
 | 2023-03-06 08:34:00.020000 |  |  |  | 224 CAA54100 |  | 72 |  | 70 | 00:00:00 | Main Road (N2), [NAME], Western Cape
 | 2023-03-06 08:35:52.450000 |  |  |  | 224 CAA54100 |  | 76 |  | 70 | 00:00:16 | N2, 4.85 km N of Noetzie, Western Cape
 | 2023-03-06 08:44:08.780000 |  |  |  | 224 CAA54100 |  | 85 |  | 80 | 00:00:00 | N2, 8.77 km NW of Kranshoek, Western Cape
 | 2023-03-06 08:45:44.760000 |  |  |  | 224 CAA54100 |  | 61 |  | 60 | 00:00:32 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 08:46:48.420000 |  |  |  | 224 CAA54100 |  | 61 |  | 60 | 00:00:00 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 08:47:20.370000 |  |  |  | 224 CAA54100 |  | 68 |  | 60 | 00:00:46 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 08:48:25.070000 |  |  |  | 224 CAA54100 |  | 61 |  | 60 | [NAME] | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 08:50:00.670000 |  |  |  | 224 CAA54100 |  | 69 |  | 60 | 00:06:56 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 09:00:40.870000 |  |  |  | 224 CAA54100 |  | 43 |  | 40 | 00:00:02 | Odland, Beacon Island, Plettenberg Bay, Western Cape
 | 2023-03-06 11:39:50.620000 |  |  |  | 224 CAA54100 |  | 51 |  | 40 | [NAME] | Odland, Beacon Island, Plettenberg Bay, Western Cape
 | 2023-03-06 11:49:58.270000 |  |  |  | 224 CAA54100 |  | 101 |  | 100 | 00:00:32 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 11:50:47.820000 |  |  |  | 224 CAA54100 |  | 82 |  | 80 | 00:01:05 | N2, Plettenberg Bay Outlying, [NAME]
 | 2023-03-06 11:55:22.760000 |  |  |  | 224 CAA54100 |  | 83 |  | 80 | 00:01:00 | N2, 2.67 km NW of Keurboomstrand, Western Cape
 | 2023-03-06 11:56:54.690000 |  |  |  | 224 CAA54100 |  | 81 |  | 80 | 00:00:00 | N2, 3.68 km SW of The Crags, Western Cape
 | 2023-03-06 11:59:34.310000 |  |  |  | 224 CAA54100 |  | 81 |  | 80 | 00:00:04 | N2, The Crags, Western Cape
 | 2023-03-06 12:01:42.370000 |  |  |  | 224 CAA54100 |  | 85 |  | 80 | 00:00:00 | N2, 2.15 km NE of The Crags, Western Cape
 | 2023-03-06 12:09:42.940000 |  |  |  | 224 CAA54100 |  | 89 |  | 40 | 00:00:32 | N2, 7.06 km NE of Natures Valley, Western Cape
 | 2023-03-06 12:11:18.290000 |  |  |  | 224 CAA54100 |  | 68 |  | 60 | 00:09:04 | N2, 7.14 km NE of Natures Valley, Western Cape
 | 2023-03-06 14:24:13.450000 |  |  |  | 224 CAA54100 |  | 51 |  | 40 | 00:00:00 | Kamassi, Stormsrivier, Eastern Cape
 | 2023-03-06 15:48:37.480000 |  |  |  | 224 CAA54100 |  | 102 |  | 60 | 00:00:00 | N2, 14.98 km SE of Stormsrivier, Eastern Cape
 | 2023-03-06 16:20:38.700000 |  |  |  | 224 CAA54100 |  | 102 |  | 60 | 00:00:00 | N2, 15.99 km W of Humansdorp, Eastern Cape
 | 2023-03-06 16:56:22.010000 |  |  |  | 224 CAA54100 |  | 95 |  | 60 | 00:00:00 | N2, 1.55 km W of Thornhill, Eastern Cape