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: TC3 CAA447389

 |  |  |  | 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
 | TC3 CAA447389 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
 | 44 |  |  |  |  |  |  | 107km/h |  |  |  |  | 00h16m33s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-06 10:57:23.050000 |  |  |  | TC3 CAA447389 |  | 81 |  | 80 | 00:00:02 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-06 11:00:50.310000 |  |  |  | TC3 CAA447389 |  | 103 |  | 100 | 00:00:00 | N1, North Camp Wingfield, Goodwood, Western Cape
 | 2023-03-06 11:30:18.940000 |  |  |  | TC3 CAA447389 |  | 65 |  | 60 | 00:00:00 | [NAME] (R101), Amstelhof, [NAME], Western Cape
 | 2023-03-06 11:35:30.020000 |  |  |  | TC3 CAA447389 |  | 104 |  | 100 | 00:00:00 | [NAME] (R101), 7.72 km SE of [NAME], Western Cape
 | 2023-03-06 11:48:50.690000 |  |  |  | TC3 CAA447389 |  | 88 |  | 80 | 00:00:00 | R101, 11.37 km SE of Blouvlei, Western Cape
 | 2023-03-06 11:49:22.710000 |  |  |  | TC3 CAA447389 |  | 89 |  | 80 | 00:05:52 | N1, 11.53 km SE of Blouvlei, Western Cape
 | 2023-03-06 11:56:50.800000 |  |  |  | TC3 CAA447389 |  | 103 |  | 80 | 00:00:00 | N1, 6.22 km SW of Rawsonville, Western Cape
 | 2023-03-06 12:17:17.860000 |  |  |  | TC3 CAA447389 |  | 92 |  | 80 | 00:01:04 | N1, 4.77 km NW of Worcester, Western Cape
 | 2023-03-06 12:26:21.220000 |  |  |  | TC3 CAA447389 |  | 61 |  | 60 | 00:00:00 | 4 Hoog Street, Worcester SP, Worcester, Western Cape
 | 2023-03-06 12:26:53.270000 |  |  |  | TC3 CAA447389 |  | 62 |  | 60 | 00:00:32 | Robertson, Worcester SP, Worcester, Western Cape
 | 2023-03-06 12:41:49.770000 |  |  |  | TC3 CAA447389 |  | 77 |  | 60 | 00:00:17 | R60, 22.21 km SE of Worcester, Western Cape
 | 2023-03-06 12:51:25.260000 |  |  |  | TC3 CAA447389 |  | 107 |  | 60 | 00:00:32 | R60, 6.81 km W of Robertson, Western Cape
 | 2023-03-06 12:54:05.360000 |  |  |  | TC3 CAA447389 |  | 83 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), 2.16 km W of Robertson, Western Cape
 | 2023-03-06 12:58:53.430000 |  |  |  | TC3 CAA447389 |  | 74 |  | 60 | 00:00:00 | Voortrekker, [NAME], [NAME], Western Cape
 | 2023-03-06 13:20:45.110000 |  |  |  | TC3 CAA447389 |  | 64 |  | 60 | 00:00:00 | Voortrekker, [NAME], [NAME], Western Cape
 | 2023-03-06 13:24:27.170000 |  |  |  | TC3 CAA447389 |  | 69 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), 0.87 km W of Robertson, Western Cape
 | 2023-03-06 13:24:29.290000 |  |  |  | TC3 CAA447389 |  | 77 |  | 60 | 00:00:04 | Voortrekker Avenue (R60), 0.91 km W of Robertson, Western Cape
 | 2023-03-06 13:25:20.750000 |  |  |  | TC3 CAA447389 |  | 107 |  | 60 | 00:00:00 | Voortrekker Avenue (R60), 2.16 km W of Robertson, Western Cape
 | 2023-03-06 13:27:41.770000 |  |  |  | TC3 CAA447389 |  | 73 |  | 60 | 00:00:47 | R60, 5.95 km W of Robertson, Western Cape
 | 2023-03-06 13:37:49.450000 |  |  |  | TC3 CAA447389 |  | 106 |  | 60 | 00:00:00 | R60, 21.73 km NW of Robertson, Western Cape
 | 2023-03-06 14:43:45.450000 |  |  |  | TC3 CAA447389 |  | 107 |  | 100 | 00:00:00 | N1, 8.69 km SW of Rawsonville, Western Cape
 | 2023-03-06 14:48:43.160000 |  |  |  | TC3 CAA447389 |  | 101 |  | 100 | 00:00:00 | N1, 12.7 km SE of Blouvlei, Western Cape
 | 2023-03-06 14:49:47.020000 |  |  |  | TC3 CAA447389 |  | 98 |  | 80 | 00:00:00 | N1, 11.65 km SE of Blouvlei, Western Cape
 | 2023-03-06 14:50:48.340000 |  |  |  | TC3 CAA447389 |  | 74 |  | 70 | 00:00:03 | N1, 11.12 km SE of Blouvlei, Western Cape
 | 2023-03-06 14:56:11.560000 |  |  |  | TC3 CAA447389 |  | 92 |  | 60 | 00:01:04 | N1, 9.04 km SE of [NAME], Western Cape
 | 2023-03-06 14:56:43.030000 |  |  |  | TC3 CAA447389 |  | 93 |  | 60 | 00:01:04 | N1, 8.21 km SE of [NAME], Western Cape
 | 2023-03-06 15:36:43.040000 |  |  |  | TC3 CAA447389 |  | 107 |  | 60 | 00:00:00 | [NAME] (M14), [NAME], Parow, Western Cape
 | 2023-03-06 15:43:07.920000 |  |  |  | TC3 CAA447389 |  | 101 |  | 100 | 00:00:12 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-07 10:23:39.100000 |  |  |  | TC3 CAA447389 |  | 81 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 10:30:35.850000 |  |  |  | TC3 CAA447389 |  | 81 |  | 60 | 00:00:15 | Settlers Way (N2), Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 12:25:26.180000 |  |  |  | TC3 CAA447389 |  | 44 |  | 20 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 12:27:40.060000 |  |  |  | TC3 CAA447389 |  | 73 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-07 12:36:06.060000 |  |  |  | TC3 CAA447389 |  | 67 |  | 60 | 00:00:00 | Settlers, Table Mountain, Cape Town, Western Cape
 | 2023-03-07 15:11:54.110000 |  |  |  | TC3 CAA447389 |  | 66 |  | 60 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-07 15:18:18.770000 |  |  |  | TC3 CAA447389 |  | 80 |  | 60 | 00:00:00 | [NAME], Charlesville, Cape Town, Western Cape
 | 2023-03-07 15:19:54.590000 |  |  |  | TC3 CAA447389 |  | 69 |  | 60 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-07 15:26:14.210000 |  |  |  | TC3 CAA447389 |  | 51 |  | 20 | 00:00:04 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 16:24:00.030000 |  |  |  | TC3 CAA447389 |  | 47 |  | 40 | 00:00:32 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 17:07:32.560000 |  |  |  | TC3 CAA447389 |  | 45 |  | 20 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-07 17:09:46.690000 |  |  |  | TC3 CAA447389 |  | 79 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-07 17:15:00.730000 |  |  |  | TC3 CAA447389 |  | 92 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 17:19:48.030000 |  |  |  | TC3 CAA447389 |  | 81 |  | 80 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-07 17:21:17.530000 |  |  |  | TC3 CAA447389 |  | 67 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 17:21:19.100000 |  |  |  | TC3 CAA447389 |  | 68 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape