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: 206 CA826907

 |  |  |  | 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
 | 206 CA826907 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
 | 51 |  |  |  |  |  |  | 107km/h |  |  |  |  | 00h21m48s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-07 03:27:29.220000 |  |  |  | 206 CA826907 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 03:31:13.160000 |  |  |  | 206 CA826907 |  | 86 |  | 80 | 00:00:32 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-07 05:03:05.870000 |  |  |  | 206 CA826907 |  | 81 |  | 80 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 05:04:09.680000 |  |  |  | 206 CA826907 |  | 86 |  | 80 | 00:01:36 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 05:07:53.610000 |  |  |  | 206 CA826907 |  | 87 |  | 80 | 00:01:36 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 05:30:17.870000 |  |  |  | 206 CA826907 |  | 86 |  | 70 | 00:00:00 | N2, Somerset West, [NAME]
 | 2023-03-07 05:31:05.800000 |  |  |  | 206 CA826907 |  | 71 |  | 70 | 00:00:00 | N2, Somerset West, [NAME]
 | 2023-03-07 05:32:57.530000 |  |  |  | 206 CA826907 |  | 75 |  | 70 | 00:00:34 | N2, [NAME], Strand, Western Cape
 | 2023-03-07 05:38:17.700000 |  |  |  | 206 CA826907 |  | 88 |  | 80 | 00:00:32 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 05:40:57.610000 |  |  |  | 206 CA826907 |  | 63 |  | 60 | 00:00:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 05:46:57.470000 |  |  |  | 206 CA826907 |  | 79 |  | 60 | 00:00:05 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 05:52:41.900000 |  |  |  | 206 CA826907 |  | 103 |  | 100 | 00:00:00 | N2, Grabouw, Grabouw, Western Cape
 | 2023-03-07 05:54:16.180000 |  |  |  | 206 CA826907 |  | 82 |  | 80 | 00:00:00 | N2, 2.31 km SE of Grabouw, Western Cape
 | 2023-03-07 05:58:32.660000 |  |  |  | 206 CA826907 |  | 90 |  | 80 | 00:00:33 | N2, 7.95 km SE of Grabouw, Western Cape
 | 2023-03-07 06:01:13.040000 |  |  |  | 206 CA826907 |  | 83 |  | 80 | 00:00:32 | N2, 7.73 km NW of Botrivier, Western Cape
 | 2023-03-07 06:21:29.650000 |  |  |  | 206 CA826907 |  | 84 |  | 80 | 00:00:00 | R43, Hawston, Western Cape
 | 2023-03-07 06:28:56.860000 |  |  |  | 206 CA826907 |  | 66 |  | 60 | 00:00:32 | Main, Mount Pleasant, Hermanus, Western Cape
 | 2023-03-07 06:39:04.660000 |  |  |  | 206 CA826907 |  | 61 |  | 60 | 00:00:32 | 269 7th Street, Mosselrivier, [NAME], Western Cape
 | 2023-03-07 06:43:20.010000 |  |  |  | 206 CA826907 |  | 101 |  | 100 | 00:00:00 | R43, 10.01 km NW of Stanford, Western Cape
 | 2023-03-07 06:45:28.560000 |  |  |  | 206 CA826907 |  | 99 |  | 60 | 00:00:00 | R43, 6.66 km NW of Stanford, Western Cape
 | 2023-03-07 06:46:32.890000 |  |  |  | 206 CA826907 |  | 105 |  | 100 | 00:00:32 | R43, 4.92 km NW of Stanford, Western Cape
 | 2023-03-07 06:48:40.730000 |  |  |  | 206 CA826907 |  | 104 |  | 100 | 00:00:00 | R43, 1.98 km NW of Stanford, Western Cape
 | 2023-03-07 06:59:20.150000 |  |  |  | 206 CA826907 |  | 103 |  | 100 | 00:00:32 | R43, 6.13 km NE of [NAME], Western Cape
 | 2023-03-07 07:04:40.070000 |  |  |  | 206 CA826907 |  | 75 |  | 60 | 00:00:00 | R43, Gansbaai, [NAME], Western Cape
 | 2023-03-07 07:09:28.670000 |  |  |  | 206 CA826907 |  | 82 |  | 80 | 00:00:00 | [NAME], Blompark, Gansbaai, Western Cape
 | 2023-03-07 11:32:29.670000 |  |  |  | 206 CA826907 |  | 64 |  | 60 | 00:00:00 | [NAME], Birkenhead, [NAME], Western Cape
 | 2023-03-07 12:05:01.610000 |  |  |  | 206 CA826907 |  | 83 |  | 80 | 00:00:00 | R43, Stanford, Western Cape
 | 2023-03-07 12:07:09.920000 |  |  |  | 206 CA826907 |  | 105 |  | 100 | 00:00:32 | R43, 2.7 km NW of Stanford, Western Cape
 | 2023-03-07 12:08:33.110000 |  |  |  | 206 CA826907 |  | 105 |  | 100 | 00:02:20 | R43, 4.97 km NW of Stanford, Western Cape
 | 2023-03-07 12:11:25.860000 |  |  |  | 206 CA826907 |  | 103 |  | 100 | 00:01:36 | R43, 9.63 km NW of Stanford, Western Cape
 | 2023-03-07 12:13:33.430000 |  |  |  | 206 CA826907 |  | 103 |  | 100 | 00:00:20 | R43, 7.86 km NE of Hermanus, Western Cape
 | 2023-03-07 12:14:54.690000 |  |  |  | 206 CA826907 |  | 85 |  | 60 | 00:00:15 | R43, 5.92 km NE of Hermanus, Western Cape
 | 2023-03-07 12:26:53.580000 |  |  |  | 206 CA826907 |  | 67 |  | 60 | 00:00:00 | Main, Mount Pleasant, Hermanus, Western Cape
 | 2023-03-07 12:35:25.010000 |  |  |  | 206 CA826907 |  | 96 |  | 90 | 00:01:04 | R43, 0.88 km S of Hawston, Western Cape
 | 2023-03-07 12:53:23.510000 |  |  |  | 206 CA826907 |  | 81 |  | 80 | 00:03:22 | N2, 4.06 km NW of Botrivier, Western Cape
 | 2023-03-07 12:57:49.040000 |  |  |  | 206 CA826907 |  | 82 |  | 80 | 00:00:00 | N2, 8.71 km SE of Grabouw, Western Cape
 | 2023-03-07 12:59:25.610000 |  |  |  | 206 CA826907 |  | 71 |  | 60 | 00:00:00 | N2, 6.95 km SE of Grabouw, Western Cape
 | 2023-03-07 13:09:29.710000 |  |  |  | 206 CA826907 |  | 107 |  | 100 | 00:00:04 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:10:05.380000 |  |  |  | 206 CA826907 |  | 89 |  | 80 | 00:00:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:11:41.700000 |  |  |  | 206 CA826907 |  | 65 |  | 60 | [NAME] | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:13:17.460000 |  |  |  | 206 CA826907 |  | 63 |  | 60 | 00:01:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:14:33.270000 |  |  |  | 206 CA826907 |  | 75 |  | 60 | 00:00:02 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:15:25.700000 |  |  |  | 206 CA826907 |  | 87 |  | 60 | 00:00:00 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:17:01.320000 |  |  |  | 206 CA826907 |  | 85 |  | 80 | 00:01:36 | N2, Somerset West Outlying, [NAME], Western Cape
 | 2023-03-07 13:21:49.110000 |  |  |  | 206 CA826907 |  | 87 |  | 70 | 00:00:00 | N2, Die Bos, Strand, Western Cape
 | 2023-03-07 13:48:28.610000 |  |  |  | 206 CA826907 |  | 93 |  | 80 | 00:00:03 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 13:49:33.630000 |  |  |  | 206 CA826907 |  | 85 |  | 80 | 00:00:32 | Kromboom Parkway (M5), [NAME], Cape Town, Western Cape
 | 2023-03-07 13:51:58.940000 |  |  |  | 206 CA826907 |  | 82 |  | 80 | 00:00:15 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-07 13:53:17.570000 |  |  |  | 206 CA826907 |  | 81 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-07 13:54:32.050000 |  |  |  | 206 CA826907 |  | 81 |  | 80 | 00:00:21 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 18:28:21.350000 |  |  |  | 206 CA826907 |  | 68 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape