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: 212 CA213635

 |  |  |  | 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
 | 212 CA213635 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
 | 45 |  |  |  |  |  |  | 95km/h |  |  |  |  | 00h07m59s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 13:13:27.460000 |  |  |  | 212 CA213635 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-03 15:02:47.390000 |  |  |  | 212 CA213635 |  | 58 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-03 15:04:23.740000 |  |  |  | 212 CA213635 |  | 63 |  | 60 | 00:00:07 | Settlers, [NAME], Western Cape
 | 2023-03-06 06:16:10.740000 |  |  |  | 212 CA213635 |  | 68 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 06:20:58.120000 |  |  |  | 212 CA213635 |  | 77 |  | 60 | 00:00:00 | [NAME], Charlesville, Cape Town, Western Cape
 | 2023-03-06 06:22:34.910000 |  |  |  | 212 CA213635 |  | 72 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:20:57.300000 |  |  |  | 212 CA213635 |  | 62 |  | 60 | 00:00:00 | Vanguard, Epping Industrial 1, Cape Town, Western Cape
 | 2023-03-06 08:50:41.620000 |  |  |  | 212 CA213635 |  | 68 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 08:51:03.130000 |  |  |  | 212 CA213635 |  | 68 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 09:28:41.430000 |  |  |  | 212 CA213635 |  | 83 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 09:35:05.750000 |  |  |  | 212 CA213635 |  | 63 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 09:38:49.780000 |  |  |  | 212 CA213635 |  | 43 |  | 20 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 12:38:49.700000 |  |  |  | 212 CA213635 |  | 95 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:39:38.550000 |  |  |  | 212 CA213635 |  | 67 |  | 60 | 00:00:11 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 12:44:09.240000 |  |  |  | 212 CA213635 |  | 90 |  | 80 | 00:01:04 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 12:47:51.680000 |  |  |  | 212 CA213635 |  | 82 |  | 80 | [NAME] | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-06 12:50:08.540000 |  |  |  | 212 CA213635 |  | 65 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 12:50:30.740000 |  |  |  | 212 CA213635 |  | 69 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 12:50:33.160000 |  |  |  | 212 CA213635 |  | 71 |  | 70 | 00:00:01 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 13:29:29.940000 |  |  |  | 212 CA213635 |  | 62 |  | 60 | 00:00:00 | Shortmarket Street, Cape Town, Cape Town, Western Cape
 | 2023-03-06 13:35:53.240000 |  |  |  | 212 CA213635 |  | 72 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 13:57:13.060000 |  |  |  | 212 CA213635 |  | 88 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:43:07.450000 |  |  |  | 212 CA213635 |  | 81 |  | 80 | 00:00:00 | Settlers, Montana, Cape Town, Western Cape
 | 2023-03-06 15:44:11.480000 |  |  |  | 212 CA213635 |  | 70 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 15:52:11.350000 |  |  |  | 212 CA213635 |  | 37 |  | 20 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 15:54:19.450000 |  |  |  | 212 CA213635 |  | 73 |  | 60 | 00:00:13 | Settlers, [NAME], Western Cape
 | 2023-03-06 15:59:39.820000 |  |  |  | 212 CA213635 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 16:03:23.810000 |  |  |  | 212 CA213635 |  | 85 |  | 80 | 00:01:04 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 16:05:06.870000 |  |  |  | 212 CA213635 |  | 75 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-06 16:05:09.900000 |  |  |  | 212 CA213635 |  | 75 |  | 70 | 00:00:01 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:18:27.240000 |  |  |  | 212 CA213635 |  | 72 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 19:25:55.170000 |  |  |  | 212 CA213635 |  | 58 |  | 50 | 00:01:36 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:27:52.200000 |  |  |  | 212 CA213635 |  | 77 |  | 60 | 00:00:11 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 19:37:39.400000 |  |  |  | 212 CA213635 |  | 67 |  | 60 | 00:00:00 | 15 Malta Road, Observatory, City Bowl, Cape Town, Western Cape
 | 2023-03-06 19:39:47.290000 |  |  |  | 212 CA213635 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 15:43:20.150000 |  |  |  | 212 CA213635 |  | 47 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-09 05:18:39.470000 |  |  |  | 212 CA213635 |  | 63 |  | 60 | 00:00:00 | 10 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-09 07:47:07.910000 |  |  |  | 212 CA213635 |  | 85 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-09 07:49:15.040000 |  |  |  | 212 CA213635 |  | 84 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-09 07:55:39.140000 |  |  |  | 212 CA213635 |  | 76 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-09 07:56:11.590000 |  |  |  | 212 CA213635 |  | 60 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 07:56:13.890000 |  |  |  | 212 CA213635 |  | 62 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:12:11.860000 |  |  |  | 212 CA213635 |  | 54 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-09 08:14:01.030000 |  |  |  | 212 CA213635 |  | 71 |  | 60 | 00:00:11 | Settlers Way, [NAME], Western Cape
 | 2023-03-09 08:57:31.330000 |  |  |  | 212 CA213635 |  | 61 |  | 60 | 00:00:00 | 42 Malta Road, Observatory, City Bowl, Cape Town, Western Cape