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: 219 CA804356

 |  |  |  | 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
 | 219 CA804356 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 |  |  |  |  |  |  | 103km/h |  |  |  |  | 00h09m19s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 11:37:46.900000 |  |  |  | 219 CA804356 |  | 84 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-03 11:39:22.710000 |  |  |  | 219 CA804356 |  | 76 |  | 60 | 00:00:06 | F.W. de Klerk Boulevard (N1), Kensington, Cape Town, Western Cape
 | 2023-03-03 11:40:26.120000 |  |  |  | 219 CA804356 |  | 70 |  | 60 | 00:00:00 | Sable, Century City, Milnerton, Western Cape
 | 2023-03-03 11:42:02.640000 |  |  |  | 219 CA804356 |  | 65 |  | 60 | 00:00:00 | Ratanga Road, Sanddrift, Milnerton, Western Cape
 | 2023-03-03 11:44:42.800000 |  |  |  | 219 CA804356 |  | 69 |  | 60 | 00:00:00 | Bosmansdam Road (M8), Sanddrift, Milnerton, Western Cape
 | 2023-03-03 12:39:45.750000 |  |  |  | 219 CA804356 |  | 72 |  | 60 | 00:00:08 | Bosmansdam Road (M8), Century City, Milnerton, Western Cape
 | 2023-03-03 12:53:05.330000 |  |  |  | 219 CA804356 |  | 103 |  | 100 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-06 10:36:58.850000 |  |  |  | 219 CA804356 |  | 66 |  | 60 | 00:00:19 | Malta Road (M57), [NAME], Cape Town, Western Cape
 | 2023-03-06 10:39:38.530000 |  |  |  | 219 CA804356 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 10:46:23.860000 |  |  |  | 219 CA804356 |  | 79 |  | 60 | 00:00:00 | [NAME], Charlesville, Cape Town, Western Cape
 | 2023-03-06 10:47:38.300000 |  |  |  | 219 CA804356 |  | 80 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:54:42.390000 |  |  |  | 219 CA804356 |  | 58 |  | 50 | 00:00:56 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:55:57.460000 |  |  |  | 219 CA804356 |  | 67 |  | 60 | 00:00:13 | Settlers, [NAME], Western Cape
 | 2023-03-06 13:01:00.850000 |  |  |  | 219 CA804356 |  | 82 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 13:02:02.560000 |  |  |  | 219 CA804356 |  | 85 |  | 80 | 00:00:41 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 14:31:50.280000 |  |  |  | 219 CA804356 |  | 81 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 14:32:54.690000 |  |  |  | 219 CA804356 |  | 90 |  | 80 | 00:00:12 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 14:38:14.220000 |  |  |  | 219 CA804356 |  | 81 |  | 80 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 14:38:46.190000 |  |  |  | 219 CA804356 |  | 87 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 14:39:50.490000 |  |  |  | 219 CA804356 |  | 48 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 14:45:42.370000 |  |  |  | 219 CA804356 |  | 44 |  | 40 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 14:46:14.710000 |  |  |  | 219 CA804356 |  | 38 |  | 20 | [NAME] | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 14:46:32.420000 |  |  |  | 219 CA804356 |  | 58 |  | 50 | 00:01:18 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 14:48:10.140000 |  |  |  | 219 CA804356 |  | 82 |  | 80 | 00:00:17 | Settlers, [NAME], Western Cape
 | 2023-03-06 14:52:38.420000 |  |  |  | 219 CA804356 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 14:53:01.130000 |  |  |  | 219 CA804356 |  | 86 |  | 80 | 00:00:09 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 14:53:40.420000 |  |  |  | 219 CA804356 |  | 84 |  | 80 | 00:00:02 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 14:54:14.880000 |  |  |  | 219 CA804356 |  | 85 |  | 80 | 00:00:32 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 15:12:22.230000 |  |  |  | 219 CA804356 |  | 63 |  | 60 | 00:00:09 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:12:43.100000 |  |  |  | 219 CA804356 |  | 61 |  | 60 | 00:00:11 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:46:49.620000 |  |  |  | 219 CA804356 |  | 79 |  | 60 | 00:00:00 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 19:49:11.580000 |  |  |  | 219 CA804356 |  | 88 |  | 80 | [NAME] | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 19:50:23.500000 |  |  |  | 219 CA804356 |  | 70 |  | 60 | [NAME] | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 20:08:09.770000 |  |  |  | 219 CA804356 |  | 53 |  | 50 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 20:14:02.680000 |  |  |  | 219 CA804356 |  | 87 |  | 80 | 00:00:38 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 20:17:14.520000 |  |  |  | 219 CA804356 |  | 91 |  | 80 | 00:00:12 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-06 20:17:58.560000 |  |  |  | 219 CA804356 |  | 61 |  | 60 | 00:00:00 | Black River Parkway (M5), Maitland, Cape Town, Western Cape
 | 2023-03-06 20:18:11.300000 |  |  |  | 219 CA804356 |  | 65 |  | 60 | 00:00:07 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-06 20:37:30.140000 |  |  |  | 219 CA804356 |  | 73 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 07:14:46.300000 |  |  |  | 219 CA804356 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 07:19:34.370000 |  |  |  | 219 CA804356 |  | 63 |  | 60 | 00:00:00 | 10 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-07 12:23:59.400000 |  |  |  | 219 CA804356 |  | 62 |  | 60 | 00:00:06 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-07 12:40:33.490000 |  |  |  | 219 CA804356 |  | 78 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-07 12:48:05.820000 |  |  |  | 219 CA804356 |  | 67 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape