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: 207 CA540898

 |  |  |  | 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
 | 207 CA540898 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
 | 31 |  |  |  |  |  |  | 72km/h |  |  |  |  | 00h05m48s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-06 13:13:12.680000 |  |  |  | 207 CA540898 |  | 68 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 09:35:28.670000 |  |  |  | 207 CA540898 |  | 44 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-07 15:45:02.780000 |  |  |  | 207 CA540898 |  | 61 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 16:24:40.320000 |  |  |  | 207 CA540898 |  | 63 |  | 60 | 00:00:23 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 07:56:00.260000 |  |  |  | 207 CA540898 |  | 71 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 09:29:20.630000 |  |  |  | 207 CA540898 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:30:24.700000 |  |  |  | 207 CA540898 |  | 35 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:33:36.720000 |  |  |  | 207 CA540898 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:34:40.830000 |  |  |  | 207 CA540898 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 09:57:36.850000 |  |  |  | 207 CA540898 |  | 37 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 10:00:16.240000 |  |  |  | 207 CA540898 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 10:01:20.430000 |  |  |  | 207 CA540898 |  | 32 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-08 10:08:16.450000 |  |  |  | 207 CA540898 |  | 72 |  | 70 | 00:00:00 | [NAME], [NAME], Noordhoek, Western Cape
 | 2023-03-08 13:19:24.660000 |  |  |  | 207 CA540898 |  | 61 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-08 13:23:40.290000 |  |  |  | 207 CA540898 |  | 62 |  | 60 | 00:00:00 | Cape Point, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-08 16:35:32.630000 |  |  |  | 207 CA540898 |  | 61 |  | 60 | 00:00:00 | Main Road (M4), Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-09 09:32:12.760000 |  |  |  | 207 CA540898 |  | 52 |  | 50 | 00:00:00 | 63 Beach Road, [NAME], Cape Town, Western Cape
 | 2023-03-09 09:45:32.500000 |  |  |  | 207 CA540898 |  | 41 |  | 40 | 00:00:32 | 68 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-09 09:51:24.550000 |  |  |  | 207 CA540898 |  | 43 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 09:52:28.600000 |  |  |  | 207 CA540898 |  | 61 |  | 60 | 00:00:05 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 09:52:33.480000 |  |  |  | 207 CA540898 |  | 63 |  | 60 | 00:00:27 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 09:55:08.450000 |  |  |  | 207 CA540898 |  | 62 |  | 60 | 00:00:05 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-09 09:59:24.590000 |  |  |  | 207 CA540898 |  | 66 |  | 60 | 00:01:04 | [NAME] (M6), [NAME], Hout Bay, Western Cape
 | 2023-03-09 10:07:24.590000 |  |  |  | 207 CA540898 |  | 32 |  | 20 | 00:01:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 10:09:00.470000 |  |  |  | 207 CA540898 |  | 44 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-09 10:10:36.400000 |  |  |  | 207 CA540898 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 10:28:44.610000 |  |  |  | 207 CA540898 |  | 44 |  | 40 | 00:01:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-09 10:37:48.290000 |  |  |  | 207 CA540898 |  | 42 |  | 40 | 00:00:32 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-09 10:39:56.010000 |  |  |  | 207 CA540898 |  | 72 |  | 70 | 00:00:00 | [NAME], Meadowsteads, Noordhoek, Western Cape
 | 2023-03-09 10:41:00.550000 |  |  |  | 207 CA540898 |  | 71 |  | 70 | 00:00:32 | [NAME], [NAME], Noordhoek, Western Cape
 | 2023-03-09 10:43:40.500000 |  |  |  | 207 CA540898 |  | 69 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape