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: 203 CA540458

 |  |  |  | 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
 | 203 CA540458 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
 | 87 |  |  |  |  |  |  | 107km/h |  |  |  |  | 00h20m57s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 07:00:06.020000 |  |  |  | 203 CA540458 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-03 07:06:30.640000 |  |  |  | 203 CA540458 |  | 65 |  | 60 | 00:00:32 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-03 08:05:04.840000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:20 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-03 08:10:24.420000 |  |  |  | 203 CA540458 |  | 51 |  | 50 | 00:00:00 | Marine, Three Anchor Bay, Cape Town, Western Cape
 | 2023-03-03 08:11:28.090000 |  |  |  | 203 CA540458 |  | 51 |  | 50 | 00:00:00 | Beach Road (M6), Sea Point, Cape Town, Western Cape
 | 2023-03-03 08:19:28.690000 |  |  |  | 203 CA540458 |  | 41 |  | 40 | 00:00:00 | 66 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-03 08:37:43.380000 |  |  |  | 203 CA540458 |  | 63 |  | 40 | 00:00:15 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-03 08:38:23 |  |  |  | 203 CA540458 |  | 72 |  | 60 | 00:00:50 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:39:15.480000 |  |  |  | 203 CA540458 |  | 63 |  | 60 | 00:00:03 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:39:23.240000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:39:27.300000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:07 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:39:45.180000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:14 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:40:07.550000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:40:09.590000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:11 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:40:52.920000 |  |  |  | 203 CA540458 |  | 65 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:42:40.180000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:44:15.560000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:32 | Victoria, Llandudno, Hout Bay, Western Cape
 | 2023-03-03 08:53:19.100000 |  |  |  | 203 CA540458 |  | 39 |  | 20 | 00:01:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 08:55:27.470000 |  |  |  | 203 CA540458 |  | 42 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:14:39.390000 |  |  |  | 203 CA540458 |  | 43 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:16:15.270000 |  |  |  | 203 CA540458 |  | 56 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:24:47.010000 |  |  |  | 203 CA540458 |  | 48 |  | 40 | 00:00:32 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-03 09:27:59.490000 |  |  |  | 203 CA540458 |  | 72 |  | 70 | 00:00:00 | [NAME], [NAME], Noordhoek, Western Cape
 | 2023-03-03 09:41:19.070000 |  |  |  | 203 CA540458 |  | 54 |  | 50 | 00:00:00 | Witsand, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-03 09:41:51.330000 |  |  |  | 203 CA540458 |  | 52 |  | 50 | 00:00:00 | Witsand, [NAME], Scarborough, Western Cape
 | 2023-03-03 12:30:49.080000 |  |  |  | 203 CA540458 |  | 65 |  | 60 | 00:00:00 | Cape Point, Cape of Good Hope Nature Reserve, Cape Town, Western Cape
 | 2023-03-03 12:41:29.650000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:00 | Main, Froggy Farm, [NAME]'s Town, Western Cape
 | 2023-03-03 12:42:01.430000 |  |  |  | 203 CA540458 |  | 63 |  | 60 | 00:00:00 | Queens, Winford, [NAME]'s Town, Western Cape
 | 2023-03-03 14:57:05.540000 |  |  |  | 203 CA540458 |  | 64 |  | 60 | 00:01:35 | 24 Main Road, [NAME]'s Town, Western Cape
 | 2023-03-03 15:04:32.590000 |  |  |  | 203 CA540458 |  | 66 |  | 60 | 00:00:32 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-03 15:06:40.660000 |  |  |  | 203 CA540458 |  | 67 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-03 15:25:20.390000 |  |  |  | 203 CA540458 |  | 104 |  | 100 | 00:01:04 | [NAME] Stel, Pollsmoor, Cape Town, Western Cape
 | 2023-03-03 15:26:56.390000 |  |  |  | 203 CA540458 |  | 107 |  | 100 | 00:00:03 | [NAME] Stel, Fir Grove, Cape Town, Western Cape
 | 2023-03-03 15:28:00.120000 |  |  |  | 203 CA540458 |  | 63 |  | 60 | 00:00:00 | [NAME] der [NAME] (M3), [NAME], Cape Town, Western Cape
 | 2023-03-03 15:31:43.870000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:08 | [NAME] Stel, Bishopscourt, Cape Town, Western Cape
 | 2023-03-03 15:32:48.330000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:00 | Sidmouth, Claremont, Cape Town, Western Cape
 | 2023-03-03 15:38:06.370000 |  |  |  | 203 CA540458 |  | 81 |  | 80 | 00:00:02 | [NAME] (M3), Rondebosch, Cape Town, Western Cape
 | 2023-03-03 15:38:30.300000 |  |  |  | 203 CA540458 |  | 67 |  | 40 | 00:00:01 | [NAME] (M3), Rondebosch, Cape Town, Western Cape
 | 2023-03-03 15:38:51.650000 |  |  |  | 203 CA540458 |  | 84 |  | 80 | 00:00:00 | Rhodes, [NAME], Cape Town, Western Cape
 | 2023-03-04 07:48:54.720000 |  |  |  | 203 CA540458 |  | 68 |  | 60 | 00:00:00 | [NAME] (N2), Cape Town, Cape Town, Western Cape
 | 2023-03-04 10:52:26.400000 |  |  |  | 203 CA540458 |  | 103 |  | 80 | 00:00:00 | N1, North Camp Wingfield, Goodwood, Western Cape
 | 2023-03-04 11:18:25.830000 |  |  |  | 203 CA540458 |  | 100 |  | 60 | 00:00:00 | N1, [NAME], [NAME], Western Cape
 | 2023-03-04 15:01:36.610000 |  |  |  | 203 CA540458 |  | 97 |  | 80 | 00:01:04 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-04 15:15:28.230000 |  |  |  | 203 CA540458 |  | 101 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Western Cape
 | 2023-03-04 15:18:40.480000 |  |  |  | 203 CA540458 |  | 50 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-04 15:31:19.820000 |  |  |  | 203 CA540458 |  | 64 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-04 15:32:41.740000 |  |  |  | 203 CA540458 |  | 64 |  | 60 | 00:00:14 | Settlers Way, [NAME], Western Cape
 | 2023-03-04 15:37:43.120000 |  |  |  | 203 CA540458 |  | 89 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 15:38:15.180000 |  |  |  | 203 CA540458 |  | 84 |  | 80 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-04 15:41:24.110000 |  |  |  | 203 CA540458 |  | 82 |  | 80 | 00:00:00 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-04 15:41:59.070000 |  |  |  | 203 CA540458 |  | 81 |  | 80 | 00:01:04 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-04 15:43:35.660000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:00 | Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-06 06:17:13.820000 |  |  |  | 203 CA540458 |  | 73 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-06 06:22:33.860000 |  |  |  | 203 CA540458 |  | 85 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 06:23:42.070000 |  |  |  | 203 CA540458 |  | 69 |  | 60 | 00:00:00 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-06 06:24:41.850000 |  |  |  | 203 CA540458 |  | 97 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 06:29:29.590000 |  |  |  | 203 CA540458 |  | 83 |  | 80 | 00:00:00 | Settlers Way, Montana, Cape Town, Western Cape
 | 2023-03-06 06:30:33.340000 |  |  |  | 203 CA540458 |  | 73 |  | 60 | 00:00:00 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 06:31:05.780000 |  |  |  | 203 CA540458 |  | 54 |  | 40 | 00:00:00 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 07:29:12.610000 |  |  |  | 203 CA540458 |  | 70 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 08:53:28.840000 |  |  |  | 203 CA540458 |  | 82 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-06 08:57:12.620000 |  |  |  | 203 CA540458 |  | 67 |  | 60 | 00:00:00 | Beach, Maitland, Cape Town, Western Cape
 | 2023-03-06 09:00:56.090000 |  |  |  | 203 CA540458 |  | 83 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 09:02:00.160000 |  |  |  | 203 CA540458 |  | 76 |  | 60 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 09:07:52.690000 |  |  |  | 203 CA540458 |  | 57 |  | 40 | 00:00:32 | Ring, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 09:12:08.820000 |  |  |  | 203 CA540458 |  | 43 |  | 20 | 00:00:00 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 12:17:51.260000 |  |  |  | 203 CA540458 |  | 76 |  | 50 | 00:00:32 | [NAME], Boquinar Industrial Area, Cape Town, Western Cape
 | 2023-03-06 12:18:46.190000 |  |  |  | 203 CA540458 |  | 76 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-06 12:23:43.480000 |  |  |  | 203 CA540458 |  | 88 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 12:24:55.850000 |  |  |  | 203 CA540458 |  | 82 |  | 80 | 00:00:00 | Settlers, Observatory, Cape Town, Western Cape
 | 2023-03-06 12:27:59.570000 |  |  |  | 203 CA540458 |  | 84 |  | 80 | 00:00:32 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-06 12:57:51.720000 |  |  |  | 203 CA540458 |  | 59 |  | 40 | 00:00:00 | Port, Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:02:24.120000 |  |  |  | 203 CA540458 |  | 82 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-06 15:04:52.450000 |  |  |  | 203 CA540458 |  | 61 |  | 60 | 00:00:44 | Black River Parkway (M5), Maitland, Cape Town, Western Cape
 | 2023-03-06 15:14:08.230000 |  |  |  | 203 CA540458 |  | 81 |  | 80 | 00:01:04 | Airport Approach Road, Montana, Cape Town, Western Cape
 | 2023-03-06 15:29:36.830000 |  |  |  | 203 CA540458 |  | 54 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 15:31:06.720000 |  |  |  | 203 CA540458 |  | 72 |  | 60 | 00:00:13 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 15:36:00.790000 |  |  |  | 203 CA540458 |  | 91 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-06 15:39:44.850000 |  |  |  | 203 CA540458 |  | 82 |  | 80 | 00:00:32 | [NAME], Salt River, Cape Town, Western Cape
 | 2023-03-06 19:11:11.830000 |  |  |  | 203 CA540458 |  | 83 |  | 80 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-06 19:24:31.430000 |  |  |  | 203 CA540458 |  | 42 |  | 40 | 00:00:00 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:31:27.310000 |  |  |  | 203 CA540458 |  | 52 |  | 50 | 00:01:36 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-06 19:33:32.240000 |  |  |  | 203 CA540458 |  | 70 |  | 60 | 00:00:10 | Settlers Way, [NAME], Western Cape
 | 2023-03-06 19:38:55.150000 |  |  |  | 203 CA540458 |  | 81 |  | 80 | 00:00:00 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-07 07:28:56.870000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 15:45:14.130000 |  |  |  | 203 CA540458 |  | 62 |  | 60 | 00:00:00 | [NAME], Cape Town, Cape Town, Western Cape
 | 2023-03-07 16:24:50.030000 |  |  |  | 203 CA540458 |  | 69 |  | 60 | 00:00:07 | Strand Street, Foreshore, Cape Town, Western Cape