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: 213 CA202396

 |  |  |  | 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
 | 213 CA202396 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
 | 63 |  |  |  |  |  |  | 105km/h |  |  |  |  | 00h16m17s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-06 05:59:30.470000 |  |  |  | 213 CA202396 |  | 65 |  | 60 | 00:00:32 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-06 06:01:38.030000 |  |  |  | 213 CA202396 |  | 85 |  | 80 | 00:00:08 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 06:07:30.130000 |  |  |  | 213 CA202396 |  | 69 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 07:37:37.560000 |  |  |  | 213 CA202396 |  | 83 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:40:24.550000 |  |  |  | 213 CA202396 |  | 89 |  | 80 | 00:00:41 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 08:41:54.280000 |  |  |  | 213 CA202396 |  | 62 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 08:42:20.330000 |  |  |  | 213 CA202396 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 09:01:53.300000 |  |  |  | 213 CA202396 |  | 75 |  | 60 | 00:00:00 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-06 09:04:01.030000 |  |  |  | 213 CA202396 |  | 81 |  | 80 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 09:06:25.660000 |  |  |  | 213 CA202396 |  | 82 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 09:07:13.160000 |  |  |  | 213 CA202396 |  | 87 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 09:08:17.690000 |  |  |  | 213 CA202396 |  | 88 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 09:13:37.440000 |  |  |  | 213 CA202396 |  | 90 |  | 80 | 00:00:00 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-06 09:14:41.860000 |  |  |  | 213 CA202396 |  | 52 |  | 40 | 00:00:32 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 09:17:29.560000 |  |  |  | 213 CA202396 |  | 44 |  | 40 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 09:18:25.040000 |  |  |  | 213 CA202396 |  | 34 |  | 20 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 12:21:53.170000 |  |  |  | 213 CA202396 |  | 42 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 12:38:25.260000 |  |  |  | 213 CA202396 |  | 81 |  | 50 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:43:13.310000 |  |  |  | 213 CA202396 |  | 105 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 12:44:49.730000 |  |  |  | 213 CA202396 |  | 85 |  | 80 | 00:01:04 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 12:48:01.040000 |  |  |  | 213 CA202396 |  | 81 |  | 80 | 00:01:47 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 12:50:12.530000 |  |  |  | 213 CA202396 |  | 66 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:21:22.120000 |  |  |  | 213 CA202396 |  | 64 |  | 60 | 00:00:00 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-06 15:31:57.870000 |  |  |  | 213 CA202396 |  | 90 |  | 80 | 00:00:32 | [NAME], Montana, Cape Town, Western Cape
 | 2023-03-06 15:40:29.330000 |  |  |  | 213 CA202396 |  | 51 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 15:41:33.170000 |  |  |  | 213 CA202396 |  | 91 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 15:42:16.060000 |  |  |  | 213 CA202396 |  | 75 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 15:46:53.110000 |  |  |  | 213 CA202396 |  | 84 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 15:48:29.430000 |  |  |  | 213 CA202396 |  | 90 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 15:50:05.310000 |  |  |  | 213 CA202396 |  | 81 |  | 80 | 00:00:04 | [NAME] (N2), Salt River, Cape Town, Western Cape
 | 2023-03-06 15:51:09.120000 |  |  |  | 213 CA202396 |  | 90 |  | 80 | 00:00:00 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 15:51:41.300000 |  |  |  | 213 CA202396 |  | 92 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-06 15:52:16.690000 |  |  |  | 213 CA202396 |  | 68 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:52:32.750000 |  |  |  | 213 CA202396 |  | 71 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:52:37.800000 |  |  |  | 213 CA202396 |  | 67 |  | 60 | 00:00:01 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:52:45.070000 |  |  |  | 213 CA202396 |  | 83 |  | 60 | 00:00:01 | Cape Town, Cape Town, Western Cape
 | 2023-03-06 19:27:17.500000 |  |  |  | 213 CA202396 |  | 65 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:28:28.030000 |  |  |  | 213 CA202396 |  | 81 |  | 80 | 00:00:32 | High, Zonnebloem, Cape Town, Western Cape
 | 2023-03-06 19:31:40.010000 |  |  |  | 213 CA202396 |  | 70 |  | 60 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 19:39:40.350000 |  |  |  | 213 CA202396 |  | 66 |  | 60 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 19:47:40.540000 |  |  |  | 213 CA202396 |  | 60 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:49:20.690000 |  |  |  | 213 CA202396 |  | 77 |  | 60 | 00:00:11 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 19:53:32.560000 |  |  |  | 213 CA202396 |  | 94 |  | 80 | 00:01:01 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:54:40.520000 |  |  |  | 213 CA202396 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:56:12.690000 |  |  |  | 213 CA202396 |  | 65 |  | 60 | 00:00:00 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:57:48.010000 |  |  |  | 213 CA202396 |  | 63 |  | 60 | 00:00:32 | [NAME] (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 20:00:28.220000 |  |  |  | 213 CA202396 |  | 69 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 18:55:32.240000 |  |  |  | 213 CA202396 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 18:59:48.170000 |  |  |  | 213 CA202396 |  | 61 |  | 60 | 00:00:00 | 8 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 16:34:15.490000 |  |  |  | 213 CA202396 |  | 62 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 22:57:43.610000 |  |  |  | 213 CA202396 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 05:41:02.190000 |  |  |  | 213 CA202396 |  | 63 |  | 60 | 00:00:01 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-09 05:41:05.090000 |  |  |  | 213 CA202396 |  | 68 |  | 60 | 00:01:55 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-09 05:44:04.120000 |  |  |  | 213 CA202396 |  | 86 |  | 80 | 00:00:00 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-09 05:46:12.870000 |  |  |  | 213 CA202396 |  | 64 |  | 60 | 00:00:00 | 57 Buitengracht Street, Cape Town, Western Cape
 | 2023-03-09 07:59:37.260000 |  |  |  | 213 CA202396 |  | 84 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 08:00:09.880000 |  |  |  | 213 CA202396 |  | 95 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 08:06:33.700000 |  |  |  | 213 CA202396 |  | 64 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 08:07:05.240000 |  |  |  | 213 CA202396 |  | 47 |  | 40 | 00:00:32 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:11:53.290000 |  |  |  | 213 CA202396 |  | 55 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:12:35.240000 |  |  |  | 213 CA202396 |  | 73 |  | 50 | 00:00:54 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 08:13:46.540000 |  |  |  | 213 CA202396 |  | 71 |  | 60 | 00:00:15 | Settlers Way, [NAME], Western Cape
 | 2023-03-09 08:49:24.900000 |  |  |  | 213 CA202396 |  | 62 |  | 60 | 00:00:02 | Malta Road (M57), [NAME], Cape Town, Western Cape