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: CQ18 CA64820

 |  |  |  | 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
 | CQ18 CA64820 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
 | 85 |  |  |  |  |  |  | 95km/h |  |  |  |  | 00h20m34s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 06:34:10.160000 |  |  |  | CQ18 CA64820 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-03 09:35:23.060000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | Camps Bay, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 13:23:18.360000 |  |  |  | CQ18 CA64820 |  | 79 |  | 60 | 00:00:00 | Cape Town, Cape Town, Western Cape
 | 2023-03-03 13:37:42.530000 |  |  |  | CQ18 CA64820 |  | 92 |  | 60 | 00:00:00 | [NAME], Charlesville, Cape Town, Western Cape
 | 2023-03-03 13:39:50.270000 |  |  |  | CQ18 CA64820 |  | 46 |  | 40 | 00:00:32 | Central, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-03 15:03:21.920000 |  |  |  | CQ18 CA64820 |  | 58 |  | 50 | 00:01:04 | Exit, Cape Town International Airport, Cape Town, Western Cape
 | 2023-03-03 15:05:02.760000 |  |  |  | CQ18 CA64820 |  | 75 |  | 60 | 00:00:12 | Settlers, [NAME], Western Cape
 | 2023-03-03 15:10:17.630000 |  |  |  | CQ18 CA64820 |  | 90 |  | 80 | 00:00:32 | Settlers, Mowbray, Cape Town, Western Cape
 | 2023-03-03 15:16:24.190000 |  |  |  | CQ18 CA64820 |  | 69 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-03 15:22:01.770000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:16 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-03 15:53:11.690000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:18:13.430000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-04 07:21:57.510000 |  |  |  | CQ18 CA64820 |  | 81 |  | 80 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-04 09:18:39.320000 |  |  |  | CQ18 CA64820 |  | 42 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-04 09:35:43.020000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-04 09:43:43.130000 |  |  |  | CQ18 CA64820 |  | 30 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:44:47.180000 |  |  |  | CQ18 CA64820 |  | 39 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:47:27.850000 |  |  |  | CQ18 CA64820 |  | 42 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:55:29.290000 |  |  |  | CQ18 CA64820 |  | 46 |  | 40 | 00:00:32 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:57:05.940000 |  |  |  | CQ18 CA64820 |  | 31 |  | 20 | 00:01:04 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:57:37.270000 |  |  |  | CQ18 CA64820 |  | 31 |  | 20 | 00:01:36 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:03:29.610000 |  |  |  | CQ18 CA64820 |  | 50 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-04 15:03:46.050000 |  |  |  | CQ18 CA64820 |  | 71 |  | 60 | 00:00:00 | Glencairn, Sunnydale, [NAME], Western Cape
 | 2023-03-04 15:27:14.930000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:00 | [NAME] (M42), Tokai Outlying, Cape Town, Western Cape
 | 2023-03-04 15:28:18.260000 |  |  |  | CQ18 CA64820 |  | 74 |  | 60 | [NAME] | Orpen Road (M42), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 15:31:30.440000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | Spaanschemat River Road (M42), [NAME], Cape Town, Western Cape
 | 2023-03-04 15:35:46.230000 |  |  |  | CQ18 CA64820 |  | 67 |  | 60 | 00:00:11 | [NAME] Stel, Bishopscourt, Cape Town, Western Cape
 | 2023-03-04 15:43:14.250000 |  |  |  | CQ18 CA64820 |  | 82 |  | 80 | 00:00:00 | [NAME], Table Mountain, Cape Town, Western Cape
 | 2023-03-04 15:55:55.410000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 08:32:25.330000 |  |  |  | CQ18 CA64820 |  | 41 |  | 40 | 00:00:00 | Victoria, Bantry Bay, Cape Town, Western Cape
 | 2023-03-05 08:33:29.030000 |  |  |  | CQ18 CA64820 |  | 42 |  | 40 | 00:00:00 | 63 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-05 08:34:33.070000 |  |  |  | CQ18 CA64820 |  | 43 |  | 40 | 00:00:32 | 54 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-05 08:45:54.570000 |  |  |  | CQ18 CA64820 |  | 49 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-05 09:07:14.290000 |  |  |  | CQ18 CA64820 |  | 40 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 09:08:18.900000 |  |  |  | CQ18 CA64820 |  | 41 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-05 09:10:58.260000 |  |  |  | CQ18 CA64820 |  | 41 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-05 09:18:06.520000 |  |  |  | CQ18 CA64820 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-05 09:19:10.160000 |  |  |  | CQ18 CA64820 |  | 41 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-05 09:28:14.570000 |  |  |  | CQ18 CA64820 |  | 51 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-05 14:18:40.050000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | [NAME] (M6), Glencairn, [NAME]'s Town, Western Cape
 | 2023-03-05 14:22:24.690000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | Glencairn, Sunnydale, [NAME], Western Cape
 | 2023-03-05 14:24:00.490000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-05 14:58:40.340000 |  |  |  | CQ18 CA64820 |  | 66 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-05 14:59:19.750000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-05 15:40:21.900000 |  |  |  | CQ18 CA64820 |  | 52 |  | 50 | 00:00:00 | Beach, Sea Point, Cape Town, Western Cape
 | 2023-03-05 15:41:25.340000 |  |  |  | CQ18 CA64820 |  | 51 |  | 50 | 00:00:00 | Beach Road (M6), Sea Point, Cape Town, Western Cape
 | 2023-03-06 09:11:00.700000 |  |  |  | CQ18 CA64820 |  | 81 |  | 80 | 00:00:19 | F.W. de Klerk Boulevard (N1), Woodstock, Cape Town, Western Cape
 | 2023-03-06 12:25:52.040000 |  |  |  | CQ18 CA64820 |  | 69 |  | 60 | 00:00:00 | Helshoogte, [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:24:23.930000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:00 | Helshoogte, [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:26:31.610000 |  |  |  | CQ18 CA64820 |  | 68 |  | 60 | 00:00:00 | Main Road (R310), [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:36:07.380000 |  |  |  | CQ18 CA64820 |  | 82 |  | 80 | 00:01:04 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:54:15.720000 |  |  |  | CQ18 CA64820 |  | 82 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:55:19.790000 |  |  |  | CQ18 CA64820 |  | 84 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-06 16:56:23.300000 |  |  |  | CQ18 CA64820 |  | 91 |  | 80 | 00:01:04 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-06 17:40:07.370000 |  |  |  | CQ18 CA64820 |  | 95 |  | 80 | 00:01:04 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-06 17:51:50.680000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | Marine, Woodstock, Cape Town, Western Cape
 | 2023-03-06 17:51:53.340000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | F.W. de Klerk, Woodstock, Cape Town, Western Cape
 | 2023-03-06 17:57:17.530000 |  |  |  | CQ18 CA64820 |  | 71 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 06:48:56.060000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-07 06:58:32.700000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-07 09:22:16.150000 |  |  |  | CQ18 CA64820 |  | 81 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 09:22:56.630000 |  |  |  | CQ18 CA64820 |  | 73 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 11:17:11.140000 |  |  |  | CQ18 CA64820 |  | 86 |  | 80 | 00:02:08 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-07 12:43:55.690000 |  |  |  | CQ18 CA64820 |  | 82 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-07 12:46:03.650000 |  |  |  | CQ18 CA64820 |  | 86 |  | 80 | 00:00:00 | [NAME], [NAME], Stellenbosch, Western Cape
 | 2023-03-07 12:57:05.810000 |  |  |  | CQ18 CA64820 |  | 62 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Stellenbosch, Western Cape
 | 2023-03-07 12:59:55.460000 |  |  |  | CQ18 CA64820 |  | 63 |  | 60 | 00:00:00 | [NAME] (R310), [NAME], Franschhoek, Western Cape
 | 2023-03-07 13:13:47.410000 |  |  |  | CQ18 CA64820 |  | 81 |  | 80 | 00:00:00 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-07 17:45:44.120000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | R45, [NAME], Stellenbosch, Western Cape
 | 2023-03-07 17:48:45.850000 |  |  |  | CQ18 CA64820 |  | 70 |  | 60 | 00:00:03 | [NAME], Stellenbosch NU Outlying, [NAME], Western Cape
 | 2023-03-07 18:24:56.250000 |  |  |  | CQ18 CA64820 |  | 80 |  | 60 | 00:00:00 | F.W. de Klerk, Maitland, Cape Town, Western Cape
 | 2023-03-07 18:28:08.660000 |  |  |  | CQ18 CA64820 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 08:50:40.670000 |  |  |  | CQ18 CA64820 |  | 82 |  | 80 | 00:00:32 | Settlers Way (N2), [NAME], Cape Town, Western Cape
 | 2023-03-08 12:42:56.800000 |  |  |  | CQ18 CA64820 |  | 62 |  | 60 | 00:00:00 | Main, [NAME], Franschhoek, Western Cape
 | 2023-03-08 12:58:24.010000 |  |  |  | CQ18 CA64820 |  | 86 |  | 80 | 00:02:40 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 13:51:02.670000 |  |  |  | CQ18 CA64820 |  | 85 |  | 80 | 00:00:00 | Huguenot Road (R45), [NAME], Franschhoek, Western Cape
 | 2023-03-08 13:53:10.820000 |  |  |  | CQ18 CA64820 |  | 83 |  | 80 | 00:00:32 | Huguenot, [NAME], Franschhoek, Western Cape
 | 2023-03-08 16:11:42.190000 |  |  |  | CQ18 CA64820 |  | 64 |  | 60 | 00:00:00 | [NAME], Stellenbosch NU Outlying, [NAME], Western Cape
 | 2023-03-08 16:42:38.220000 |  |  |  | CQ18 CA64820 |  | 69 |  | 60 | 00:00:00 | Black River, Maitland, Cape Town, Western Cape
 | 2023-03-09 06:27:13.400000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 06:36:21.360000 |  |  |  | CQ18 CA64820 |  | 65 |  | 60 | 00:00:28 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-09 08:40:07.390000 |  |  |  | CQ18 CA64820 |  | 46 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-09 09:06:47.110000 |  |  |  | CQ18 CA64820 |  | 64 |  | 60 | 00:00:00 | [NAME] (M63), [NAME], Hout Bay, Western Cape
 | 2023-03-09 09:15:19.050000 |  |  |  | CQ18 CA64820 |  | 62 |  | 60 | 00:00:00 | Constantia Main Road (M41), Constantia, Cape Town, Western Cape
 | 2023-03-09 09:23:19.610000 |  |  |  | CQ18 CA64820 |  | 84 |  | 80 | 00:00:00 | [NAME] Stel, Kirstenhof, Cape Town, Western Cape