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: 208 CA757374

 |  |  |  | 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
 | 208 CA757374 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
 | 109 |  |  |  |  |  |  | 87km/h |  |  |  |  | 00h20m53s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 09:49:10.460000 |  |  |  | 208 CA757374 |  | 84 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-03 09:51:18.100000 |  |  |  | 208 CA757374 |  | 84 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-03 09:53:06.660000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:04 | Black River Parkway (M5), Maitland, Cape Town, Western Cape
 | 2023-03-03 09:53:58.710000 |  |  |  | 208 CA757374 |  | 83 |  | 80 | 00:00:32 | Black River, Ndabeni, Cape Town, Western Cape
 | 2023-03-03 09:56:06.570000 |  |  |  | 208 CA757374 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-03 09:56:38.280000 |  |  |  | 208 CA757374 |  | 87 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-03 10:17:13.510000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | N2, Somerset West, [NAME]
 | 2023-03-03 12:44:55.760000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:00 | Settlers, Welcome, Cape Town, Western Cape
 | 2023-03-03 12:51:19.940000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:01:04 | Vanguard, Epping Industrial 1, Cape Town, Western Cape
 | 2023-03-03 12:55:03.140000 |  |  |  | 208 CA757374 |  | 65 |  | 60 | 00:00:00 | [NAME] (M7), Epping Industrial 1, Cape Town, Western Cape
 | 2023-03-03 12:58:15.430000 |  |  |  | 208 CA757374 |  | 72 |  | 60 | 00:00:49 | Vanguard, Wingfield, Cape Town, Western Cape
 | 2023-03-03 13:17:27.290000 |  |  |  | 208 CA757374 |  | 72 |  | 70 | 00:00:35 | Wingfield, Milnerton SP, Milnerton, Western Cape
 | 2023-03-03 16:00:31.760000 |  |  |  | 208 CA757374 |  | 73 |  | 70 | 00:00:00 | Wingfield, Morningstar AH, Milnerton, Western Cape
 | 2023-03-03 16:01:22.240000 |  |  |  | 208 CA757374 |  | 71 |  | 70 | 00:00:32 | [NAME] (N7), Milnerton SP, Milnerton, Western Cape
 | 2023-03-03 16:12:34.770000 |  |  |  | 208 CA757374 |  | 78 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), [NAME], Cape Town, Western Cape
 | 2023-03-03 16:16:50.640000 |  |  |  | 208 CA757374 |  | 82 |  | 80 | 00:01:04 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-03 16:33:20.940000 |  |  |  | 208 CA757374 |  | 66 |  | 60 | 00:00:02 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-03 19:19:29.700000 |  |  |  | 208 CA757374 |  | 53 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-03 21:36:11.510000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape
 | 2023-03-03 21:55:55.700000 |  |  |  | 208 CA757374 |  | 86 |  | 80 | 00:00:32 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-03 22:00:11.090000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:31:35.340000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:11 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 08:47:50.600000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:32 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-04 09:02:46.520000 |  |  |  | 208 CA757374 |  | 43 |  | 40 | 00:00:00 | The [NAME], Clifton, Cape Town, Western Cape
 | 2023-03-04 09:08:37.100000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:13 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-04 09:09:21.180000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:06 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:10:10.680000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:04 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:11:36.830000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:12:15.510000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 11:01:39.080000 |  |  |  | 208 CA757374 |  | 45 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:02:43.250000 |  |  |  | 208 CA757374 |  | 39 |  | 20 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:35:49.720000 |  |  |  | 208 CA757374 |  | 49 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 11:45:57.590000 |  |  |  | 208 CA757374 |  | 49 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-04 11:50:13.620000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-04 11:57:41.610000 |  |  |  | 208 CA757374 |  | 80 |  | 70 | 00:00:00 | Slangkop, Ocean View, Cape Town, Western Cape
 | 2023-03-04 12:04:05.350000 |  |  |  | 208 CA757374 |  | 54 |  | 50 | 00:00:00 | Witsand Road (M65), [NAME], Scarborough, Western Cape
 | 2023-03-04 12:35:33.080000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 14:12:46.650000 |  |  |  | 208 CA757374 |  | 66 |  | 60 | 00:00:08 | Cape Point, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 14:13:50.130000 |  |  |  | 208 CA757374 |  | 74 |  | 60 | 00:00:10 | Cape Point Road, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 14:19:42.920000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:00 | Main, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 14:22:54.120000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:32 | Main, Castle Rock, Western Cape
 | 2023-03-04 14:24:30.290000 |  |  |  | 208 CA757374 |  | 66 |  | 60 | 00:00:25 | Miller's Point Road (M4), Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-04 14:35:10.850000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | Main Road (M4), Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-04 14:36:14 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:32 | Main, Cape Farms, [NAME]'s Town, Western Cape
 | 2023-03-04 16:26:08.770000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | Simonstown, [NAME], [NAME]'s Town, Western Cape
 | 2023-03-04 16:27:44.930000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:01:36 | 110 Main Road, Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-04 18:02:38.760000 |  |  |  | 208 CA757374 |  | 68 |  | 60 | 00:00:00 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-04 18:04:31.880000 |  |  |  | 208 CA757374 |  | 65 |  | 60 | 00:00:01 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-04 18:26:02.110000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:04 | [NAME] Stel, Bishopscourt, Cape Town, Western Cape
 | 2023-03-04 18:35:10.650000 |  |  |  | 208 CA757374 |  | 84 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 18:36:46.160000 |  |  |  | 208 CA757374 |  | 83 |  | 80 | 00:00:00 | Black River Parkway (M5), [NAME], Cape Town, Western Cape
 | 2023-03-04 18:38:22.090000 |  |  |  | 208 CA757374 |  | 66 |  | 60 | 00:00:00 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-04 18:39:26.290000 |  |  |  | 208 CA757374 |  | 81 |  | 80 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-04 19:13:42.350000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | Ratanga, Sanddrift, Milnerton, Western Cape
 | 2023-03-04 20:13:30.360000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:00 | Marine, Metro Industrial Township, Milnerton, Western Cape
 | 2023-03-04 20:16:10.300000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:00 | [NAME] (R27), Foreshore, Cape Town, Western Cape
 | 2023-03-04 20:44:58.430000 |  |  |  | 208 CA757374 |  | 69 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 10:13:01.300000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 10:55:44.150000 |  |  |  | 208 CA757374 |  | 65 |  | 60 | 00:00:23 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-05 14:31:34.530000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-05 14:32:14.830000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:01 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-05 14:33:10.910000 |  |  |  | 208 CA757374 |  | 82 |  | 80 | 00:00:00 | Black River Parkway (M5), Ndabeni, Cape Town, Western Cape
 | 2023-03-05 14:41:10.830000 |  |  |  | 208 CA757374 |  | 86 |  | 80 | 00:00:32 | Settlers Way, Montana, Cape Town, Western Cape
 | 2023-03-05 14:42:18.220000 |  |  |  | 208 CA757374 |  | 58 |  | 40 | 00:01:00 | Ring, Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-05 14:55:02.090000 |  |  |  | 208 CA757374 |  | 32 |  | 20 | 00:00:32 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-05 14:56:38.740000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-05 15:01:58.750000 |  |  |  | 208 CA757374 |  | 86 |  | 80 | 00:00:00 | Settlers Way, Montana, Cape Town, Western Cape
 | 2023-03-05 15:02:08.930000 |  |  |  | 208 CA757374 |  | 77 |  | 60 | 00:00:11 | Settlers Way, [NAME], Western Cape
 | 2023-03-05 15:06:46.720000 |  |  |  | 208 CA757374 |  | 87 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-05 15:22:46.100000 |  |  |  | 208 CA757374 |  | 67 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-06 05:29:06.040000 |  |  |  | 208 CA757374 |  | 68 |  | 60 | 00:00:17 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-06 05:31:46.850000 |  |  |  | 208 CA757374 |  | 52 |  | 50 | 00:00:00 | Beach, Green Point, Cape Town, Western Cape
 | 2023-03-06 06:13:48.510000 |  |  |  | 208 CA757374 |  | 65 |  | 60 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 06:21:48.480000 |  |  |  | 208 CA757374 |  | 72 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 06:23:24.580000 |  |  |  | 208 CA757374 |  | 43 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 06:38:58.110000 |  |  |  | 208 CA757374 |  | 31 |  | 20 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 07:53:37.710000 |  |  |  | 208 CA757374 |  | 66 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:52:50.680000 |  |  |  | 208 CA757374 |  | 65 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 09:21:37.700000 |  |  |  | 208 CA757374 |  | 81 |  | 80 | 00:00:32 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-06 09:23:30.170000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Black River Parkway (M5), Maitland, Cape Town, Western Cape
 | 2023-03-06 09:23:32.420000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:13 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-06 09:26:57.730000 |  |  |  | 208 CA757374 |  | 87 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 09:32:49.650000 |  |  |  | 208 CA757374 |  | 75 |  | 60 | 00:01:04 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 09:35:29.110000 |  |  |  | 208 CA757374 |  | 42 |  | 40 | 00:00:00 | Pick Up, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 09:36:33.730000 |  |  |  | 208 CA757374 |  | 62 |  | 50 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 12:48:15.240000 |  |  |  | 208 CA757374 |  | 80 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:49:09.820000 |  |  |  | 208 CA757374 |  | 67 |  | 60 | 00:00:12 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 12:54:39.170000 |  |  |  | 208 CA757374 |  | 83 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 12:56:47.470000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Settlers, Table Mountain, Cape Town, Western Cape
 | 2023-03-06 12:59:27.940000 |  |  |  | 208 CA757374 |  | 81 |  | 80 | 00:00:00 | [NAME] (N2), Zonnebloem, Cape Town, Western Cape
 | 2023-03-06 13:00:28.640000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 13:01:03.340000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | Cape Town, Cape Town, Western Cape
 | 2023-03-06 16:17:45.940000 |  |  |  | 208 CA757374 |  | 69 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 16:25:13.250000 |  |  |  | 208 CA757374 |  | 54 |  | 50 | 00:00:00 | [NAME], Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 16:25:45 |  |  |  | 208 CA757374 |  | 80 |  | 50 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 16:26:39.850000 |  |  |  | 208 CA757374 |  | 68 |  | 60 | 00:00:10 | Settlers, [NAME], Western Cape
 | 2023-03-06 16:38:01.590000 |  |  |  | 208 CA757374 |  | 82 |  | 80 | 00:00:32 | [NAME], Woodstock, Cape Town, Western Cape
 | 2023-03-06 16:39:42.820000 |  |  |  | 208 CA757374 |  | 62 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 19:57:27.090000 |  |  |  | 208 CA757374 |  | 70 |  | 60 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 19:59:03.740000 |  |  |  | 208 CA757374 |  | 43 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 20:06:31.780000 |  |  |  | 208 CA757374 |  | 40 |  | 20 | 00:01:36 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 20:08:49.270000 |  |  |  | 208 CA757374 |  | 66 |  | 60 | 00:00:00 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 20:13:59.860000 |  |  |  | 208 CA757374 |  | 86 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 20:16:07.250000 |  |  |  | 208 CA757374 |  | 82 |  | 80 | 00:00:32 | Black River Parkway (M5), [NAME], Cape Town, Western Cape
 | 2023-03-06 20:18:47.290000 |  |  |  | 208 CA757374 |  | 81 |  | 80 | 00:00:32 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-06 20:35:51.670000 |  |  |  | 208 CA757374 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 16:38:28.510000 |  |  |  | 208 CA757374 |  | 70 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 16:51:16.790000 |  |  |  | 208 CA757374 |  | 63 |  | 60 | 00:00:06 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-08 23:14:13.850000 |  |  |  | 208 CA757374 |  | 64 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape