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: 231 CAA95873

 |  |  |  | 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
 | 231 CAA95873 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
 | 42 |  |  |  |  |  |  | 101km/h |  |  |  |  | 00h16m00s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 07:14:18.300000 |  |  |  | 231 CAA95873 |  | 68 |  | 60 | 00:00:32 | [NAME] (R27), Metro Industrial Township, Milnerton, Western Cape
 | 2023-03-03 08:07:15.820000 |  |  |  | 231 CAA95873 |  | 69 |  | 60 | 00:00:00 | Marine, Woodstock, Cape Town, Western Cape
 | 2023-03-03 08:09:55.280000 |  |  |  | 231 CAA95873 |  | 69 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-03 08:28:35.640000 |  |  |  | 231 CAA95873 |  | 88 |  | 60 | 00:00:00 | N1, [NAME], [NAME], Western Cape
 | 2023-03-03 08:54:11.320000 |  |  |  | 231 CAA95873 |  | 80 |  | 60 | 00:00:32 | N1, 7.6 km SE of [NAME], Western Cape
 | 2023-03-03 09:02:11.680000 |  |  |  | 231 CAA95873 |  | 96 |  | 90 | 00:00:32 | N1, 11.93 km SE of Blouvlei, Western Cape
 | 2023-03-03 09:03:47.390000 |  |  |  | 231 CAA95873 |  | 92 |  | 90 | 00:00:32 | N1, 13.86 km SE of Blouvlei, Western Cape
 | 2023-03-03 09:05:55.230000 |  |  |  | 231 CAA95873 |  | 91 |  | 90 | 00:00:32 | N1, 11.09 km SW of Rawsonville, Western Cape
 | 2023-03-03 09:07:31.380000 |  |  |  | 231 CAA95873 |  | 93 |  | 90 | 00:00:00 | N1, 9.17 km SW of Rawsonville, Western Cape
 | 2023-03-03 09:09:39.710000 |  |  |  | 231 CAA95873 |  | 83 |  | 80 | 00:00:00 | N1, 6.56 km SW of Rawsonville, Western Cape
 | 2023-03-03 10:25:24.750000 |  |  |  | 231 CAA95873 |  | 80 |  | 70 | 00:00:00 | R60, 15.02 km SE of Worcester, Western Cape
 | 2023-03-03 10:26:28.030000 |  |  |  | 231 CAA95873 |  | 79 |  | 70 | 00:00:00 | R60, 16.45 km SE of Worcester, Western Cape
 | 2023-03-03 10:27:32.670000 |  |  |  | 231 CAA95873 |  | 77 |  | 70 | 00:01:04 | R60, 16.65 km SE of Worcester, Western Cape
 | 2023-03-03 12:24:51.660000 |  |  |  | 231 CAA95873 |  | 82 |  | 70 | 00:01:04 | R60, 16.65 km SE of Worcester, Western Cape
 | 2023-03-03 12:26:59.860000 |  |  |  | 231 CAA95873 |  | 74 |  | 70 | 00:00:32 | R60, 16.65 km SE of Worcester, Western Cape
 | 2023-03-03 12:29:07.630000 |  |  |  | 231 CAA95873 |  | 73 |  | 70 | 00:00:00 | R60, 14.66 km SE of Worcester, Western Cape
 | 2023-03-03 12:57:23.270000 |  |  |  | 231 CAA95873 |  | 81 |  | 80 | 00:00:32 | N1, 12.07 km SW of De Doorns, Western Cape
 | 2023-03-03 13:08:35.250000 |  |  |  | 231 CAA95873 |  | 88 |  | 80 | 00:03:44 | N1, 2.06 km NE of De Doorns, Western Cape
 | 2023-03-04 11:02:28.690000 |  |  |  | 231 CAA95873 |  | 86 |  | 60 | 00:00:00 | N1, 11.45 km NE of De Doorns, Western Cape
 | 2023-03-04 11:06:12.410000 |  |  |  | 231 CAA95873 |  | 95 |  | 80 | 00:00:00 | N1, 6.39 km NE of De Doorns, Western Cape
 | 2023-03-04 11:07:48.640000 |  |  |  | 231 CAA95873 |  | 86 |  | 80 | 00:01:04 | N1, 4.04 km NE of De Doorns, Western Cape
 | 2023-03-04 11:11:32.520000 |  |  |  | 231 CAA95873 |  | 82 |  | 80 | 00:00:00 | N1, De Doorns East, De Doorns, Western Cape
 | 2023-03-04 11:15:48.690000 |  |  |  | 231 CAA95873 |  | 101 |  | 100 | 00:00:00 | N1, 6.93 km SW of De Doorns, Western Cape
 | 2023-03-04 11:17:56.350000 |  |  |  | 231 CAA95873 |  | 101 |  | 80 | 00:00:32 | N1, 10.29 km SW of De Doorns, Western Cape
 | 2023-03-04 11:29:40.480000 |  |  |  | 231 CAA95873 |  | 86 |  | 80 | 00:00:00 | N1, Meirings Park, Worcester, Western Cape
 | 2023-03-04 11:32:20.390000 |  |  |  | 231 CAA95873 |  | 62 |  | 60 | 00:00:00 | [NAME], Roux Park, Worcester, Western Cape
 | 2023-03-04 12:39:02.020000 |  |  |  | 231 CAA95873 |  | 93 |  | 60 | 00:02:08 | N1, 9.01 km SE of [NAME], Western Cape
 | 2023-03-04 12:42:46.660000 |  |  |  | 231 CAA95873 |  | 61 |  | 60 | 00:00:00 | N1, 5.26 km SE of [NAME], Western Cape
 | 2023-03-04 13:23:18.930000 |  |  |  | 231 CAA95873 |  | 67 |  | 60 | 00:00:32 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-04 13:39:50.810000 |  |  |  | 231 CAA95873 |  | 62 |  | 60 | 00:00:00 | [NAME] Stel, Wynberg, Cape Town, Western Cape
 | 2023-03-04 14:02:14.440000 |  |  |  | 231 CAA95873 |  | 62 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-04 14:08:06.870000 |  |  |  | 231 CAA95873 |  | 61 |  | 60 | 00:00:00 | [NAME], Glencairn Heights, [NAME]'s Town, Western Cape
 | 2023-03-04 14:10:14.430000 |  |  |  | 231 CAA95873 |  | 66 |  | 60 | 00:00:00 | 114 Main Road, Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-04 16:50:28.750000 |  |  |  | 231 CAA95873 |  | 65 |  | 60 | 00:00:32 | Main, Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-04 16:52:04.280000 |  |  |  | 231 CAA95873 |  | 62 |  | 60 | 00:00:00 | Main Road (M4), Marine Oil Refinery, [NAME]'s Town, Western Cape
 | 2023-03-04 16:57:24.930000 |  |  |  | 231 CAA95873 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-04 16:59:32.530000 |  |  |  | 231 CAA95873 |  | 64 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-04 18:07:48.740000 |  |  |  | 231 CAA95873 |  | 86 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 18:13:40.250000 |  |  |  | 231 CAA95873 |  | 82 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 18:15:16.220000 |  |  |  | 231 CAA95873 |  | 82 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-04 18:18:28.560000 |  |  |  | 231 CAA95873 |  | 81 |  | 80 | 00:00:32 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-04 18:48:20.470000 |  |  |  | 231 CAA95873 |  | 86 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape