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: 218 CA822970

 |  |  |  | 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
 | 218 CA822970 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
 | 38 |  |  |  |  |  |  | 105km/h |  |  |  |  | 00h11m40s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-05 18:50:30.660000 |  |  |  | 218 CA822970 |  | 96 |  | 90 | 00:00:06 | N1, 8.91 km SW of Rawsonville, Western Cape
 | 2023-03-05 18:52:38.040000 |  |  |  | 218 CA822970 |  | 87 |  | 80 | 00:00:00 | N1, 6.08 km SW of Rawsonville, Western Cape
 | 2023-03-05 19:04:22.470000 |  |  |  | 218 CA822970 |  | 81 |  | 80 | 00:00:32 | N1, 4.01 km NW of Worcester, Western Cape
 | 2023-03-05 19:11:50.700000 |  |  |  | 218 CA822970 |  | 61 |  | 60 | 00:00:32 | Robertson, Worcester SP, Worcester, Western Cape
 | 2023-03-05 19:16:38.600000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:00 | R60, 6.15 km SE of Worcester, Western Cape
 | 2023-03-05 19:27:18.460000 |  |  |  | 218 CA822970 |  | 91 |  | 60 | 00:00:00 | R60, 22.1 km NW of Robertson, Western Cape
 | 2023-03-05 19:39:29.360000 |  |  |  | 218 CA822970 |  | 63 |  | 60 | [NAME] | R60, 6.84 km W of Robertson, Western Cape
 | 2023-03-05 19:43:18.250000 |  |  |  | 218 CA822970 |  | 79 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), 2.11 km W of Robertson, Western Cape
 | 2023-03-05 22:13:55.840000 |  |  |  | 218 CA822970 |  | 61 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), [NAME], [NAME], Western Cape
 | 2023-03-05 22:28:03.390000 |  |  |  | 218 CA822970 |  | 71 |  | 60 | 00:00:16 | R62, 3.04 km NE of Ashton, Western Cape
 | 2023-03-05 22:30:31.820000 |  |  |  | 218 CA822970 |  | 67 |  | 60 | 00:00:01 | R62, 2.57 km SW of Montagu, Western Cape
 | 2023-03-05 22:31:20.500000 |  |  |  | 218 CA822970 |  | 65 |  | 60 | [NAME] | R62, 2.03 km SW of Montagu, Western Cape
 | 2023-03-05 22:34:54.650000 |  |  |  | 218 CA822970 |  | 62 |  | 60 | 00:00:11 | 67 Lang Street, Montagu SP, Montagu, Western Cape
 | 2023-03-05 23:32:56.450000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:27 | R62, 7.17 km NE of Barrydale, Western Cape
 | 2023-03-05 23:36:35.010000 |  |  |  | 218 CA822970 |  | 101 |  | 100 | 00:00:00 | R62, 12.19 km NE of Barrydale, Western Cape
 | 2023-03-05 23:39:15.240000 |  |  |  | 218 CA822970 |  | 101 |  | 100 | 00:00:00 | R62, 16.13 km NE of Barrydale, Western Cape
 | 2023-03-06 00:01:39.670000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:00 | R62, 20.86 km SW of Ladismith, Western Cape
 | 2023-03-06 00:02:43.560000 |  |  |  | 218 CA822970 |  | 105 |  | 100 | 00:00:32 | R62, 19.27 km SW of Ladismith, Western Cape
 | 2023-03-06 01:03:00.840000 |  |  |  | 218 CA822970 |  | 73 |  | 60 | 00:00:00 | Voortrekker Street (R62), Calitzdorp, Calitzdorp, Western Cape
 | 2023-03-06 01:37:40.390000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:00 | R328, 6.6 km SW of Oudtshoorn, Western Cape
 | 2023-03-06 08:49:22.360000 |  |  |  | 218 CA822970 |  | 78 |  | 70 | 00:02:40 | R328, 8.71 km SW of Oudtshoorn, Western Cape
 | 2023-03-06 08:53:57.480000 |  |  |  | 218 CA822970 |  | 80 |  | 70 | 00:03:25 | R328, 8.71 km SW of Oudtshoorn, Western Cape
 | 2023-03-06 09:24:34.350000 |  |  |  | 218 CA822970 |  | 61 |  | 60 | 00:00:00 | Voortrekker Street (R62), Calitzdorp, Calitzdorp, Western Cape
 | 2023-03-06 09:25:38.370000 |  |  |  | 218 CA822970 |  | 67 |  | 60 | 00:00:00 | R62, Bergsig, Calitzdorp, Western Cape
 | 2023-03-06 09:46:58.760000 |  |  |  | 218 CA822970 |  | 101 |  | 100 | 00:00:00 | R62, 4.03 km NE of Zoar, Western Cape
 | 2023-03-06 11:16:01.780000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:32 | R62, 21.15 km NE of Barrydale, Western Cape
 | 2023-03-06 11:18:41.670000 |  |  |  | 218 CA822970 |  | 102 |  | 100 | 00:00:00 | R62, 17.11 km NE of Barrydale, Western Cape
 | 2023-03-06 12:13:20.660000 |  |  |  | 218 CA822970 |  | 95 |  | 60 | 00:00:00 | 8.18 km SW of Barrydale, Western Cape
 | 2023-03-06 12:49:36.660000 |  |  |  | 218 CA822970 |  | 64 |  | 60 | 00:00:00 | 67 Lang Street, Montagu SP, Montagu, Western Cape
 | 2023-03-06 12:53:01.580000 |  |  |  | 218 CA822970 |  | 64 |  | 60 | 00:00:19 | R62, 1.99 km SW of Montagu, Western Cape
 | 2023-03-06 12:57:36.700000 |  |  |  | 218 CA822970 |  | 61 |  | 60 | 00:00:00 | R62, 3.04 km NE of Ashton, Western Cape
 | 2023-03-06 13:20:00.650000 |  |  |  | 218 CA822970 |  | 80 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), 2.11 km W of Robertson, Western Cape
 | 2023-03-06 13:22:40.420000 |  |  |  | 218 CA822970 |  | 88 |  | 60 | 00:00:32 | R60, 5.75 km W of Robertson, Western Cape
 | 2023-03-06 13:34:24.150000 |  |  |  | 218 CA822970 |  | 85 |  | 60 | 00:00:32 | R60, 21.43 km NW of Robertson, Western Cape
 | 2023-03-06 15:18:41.300000 |  |  |  | 218 CA822970 |  | 91 |  | 80 | 00:00:00 | N1, 6.08 km SW of Rawsonville, Western Cape
 | 2023-03-06 15:27:13.840000 |  |  |  | 218 CA822970 |  | 90 |  | 80 | 00:00:00 | N1, 11.65 km SE of Blouvlei, Western Cape
 | 2023-03-06 17:54:01.930000 |  |  |  | 218 CA822970 |  | 96 |  | 60 | 00:00:00 | Sable, Wingfield, Cape Town, Western Cape
 | 2023-03-06 17:56:09.730000 |  |  |  | 218 CA822970 |  | 84 |  | 80 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape