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: 220 CA645115

 |  |  |  | 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
 | 220 CA645115 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
 | 56 |  |  |  |  |  |  | 96km/h |  |  |  |  | [NAME]
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 07:16:43.480000 |  |  |  | 220 CA645115 |  | 61 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-03 08:41:45.520000 |  |  |  | 220 CA645115 |  | 52 |  | 50 | 00:00:00 | Beach Road (M6), Sea Point, Cape Town, Western Cape
 | 2023-03-03 11:37:26.770000 |  |  |  | 220 CA645115 |  | 41 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-03 12:53:44.310000 |  |  |  | 220 CA645115 |  | 43 |  | 40 | 00:00:00 | Table Mountain, Table Mountain, Cape Town, Western Cape
 | 2023-03-04 08:48:41.820000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-04 09:48:58.160000 |  |  |  | 220 CA645115 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:49:30.700000 |  |  |  | 220 CA645115 |  | 33 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 09:53:46.540000 |  |  |  | 220 CA645115 |  | 41 |  | 40 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-04 10:06:34.190000 |  |  |  | 220 CA645115 |  | 48 |  | 40 | 00:00:32 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-04 15:21:24.190000 |  |  |  | 220 CA645115 |  | 73 |  | 60 | 00:00:00 | Main Road (M4), Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-04 15:23:00.030000 |  |  |  | 220 CA645115 |  | 67 |  | 60 | 00:00:00 | 104 Main Road, Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-04 15:24:36.470000 |  |  |  | 220 CA645115 |  | 67 |  | 60 | 00:00:00 | [NAME] (M6), Glencairn, [NAME]'s Town, Western Cape
 | 2023-03-04 16:00:20.740000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | Rhodes, Kirstenbosch National Botanical Gardens, Cape Town, Western Cape
 | 2023-03-04 18:46:44.780000 |  |  |  | 220 CA645115 |  | 65 |  | 60 | 00:00:00 | 8 Strand Street, Foreshore, Cape Town, Western Cape
 | 2023-03-04 19:02:12.750000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | 96 New Market Street, Foreshore, City Bowl, Cape Town, Western Cape
 | 2023-03-04 19:05:56.760000 |  |  |  | 220 CA645115 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-05 17:00:39.280000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-05 21:22:52.570000 |  |  |  | 220 CA645115 |  | 81 |  | 80 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-05 21:23:56.620000 |  |  |  | 220 CA645115 |  | 84 |  | 80 | 00:00:00 | F.W. de Klerk Boulevard (N1), Foreshore, Cape Town, Western Cape
 | 2023-03-07 20:07:48.500000 |  |  |  | 220 CA645115 |  | 66 |  | 60 | 00:00:00 | [NAME] Stel, Sillary, Cape Town, Western Cape
 | 2023-03-07 22:39:22.130000 |  |  |  | 220 CA645115 |  | 81 |  | 80 | 00:00:32 | [NAME], Zonnebloem, Cape Town, Western Cape
 | 2023-03-07 22:40:30.840000 |  |  |  | 220 CA645115 |  | 72 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-07 22:56:26.770000 |  |  |  | 220 CA645115 |  | 83 |  | 80 | 00:01:04 | F.W. de Klerk, Cape Town, Cape Town, Western Cape
 | 2023-03-07 23:01:14.680000 |  |  |  | 220 CA645115 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 07:30:43.060000 |  |  |  | 220 CA645115 |  | 65 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-08 09:01:45.780000 |  |  |  | 220 CA645115 |  | 62 |  | 60 | 00:00:00 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-08 09:19:21.080000 |  |  |  | 220 CA645115 |  | 43 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-08 09:20:57.340000 |  |  |  | 220 CA645115 |  | 41 |  | 40 | 00:00:00 | 40 [NAME], Bakoven, Cape Town, Western Cape
 | 2023-03-08 09:25:38.510000 |  |  |  | 220 CA645115 |  | 61 |  | 60 | 00:00:00 | [NAME] (M6), Oudekraal, Cape Town, Western Cape
 | 2023-03-08 09:29:40.490000 |  |  |  | 220 CA645115 |  | 61 |  | 60 | 00:01:25 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-08 11:18:07.170000 |  |  |  | 220 CA645115 |  | 36 |  | 20 | 00:01:04 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 11:21:51.200000 |  |  |  | 220 CA645115 |  | 41 |  | 40 | [NAME] | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-08 11:32:31.600000 |  |  |  | 220 CA645115 |  | 48 |  | 40 | 00:00:00 | Chapman's Peak Drive (M6), [NAME], Noordhoek, Western Cape
 | 2023-03-08 11:34:39.570000 |  |  |  | 220 CA645115 |  | 76 |  | 70 | 00:00:32 | [NAME] (M6), Meadowsteads, Noordhoek, Western Cape
 | 2023-03-08 11:37:19.030000 |  |  |  | 220 CA645115 |  | 68 |  | 60 | 00:00:00 | [NAME] (M64), Sunnydale, [NAME], Western Cape
 | 2023-03-08 11:41:35.210000 |  |  |  | 220 CA645115 |  | 91 |  | 90 | 00:01:04 | Glencairn, [NAME]'s Town SP, [NAME]'s Town, Western Cape
 | 2023-03-08 11:44:47.800000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | Main Road (M4), Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-08 11:55:27.900000 |  |  |  | 220 CA645115 |  | 65 |  | 60 | 00:00:00 | Miller's Point, Rocklands [NAME], [NAME]'s Town, Western Cape
 | 2023-03-08 14:40:05.230000 |  |  |  | 220 CA645115 |  | 68 |  | 60 | 00:00:00 | Main Road (M4), Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-08 14:41:41.480000 |  |  |  | 220 CA645115 |  | 65 |  | 60 | 00:00:00 | 114 Main Road, Cairnside, [NAME]'s Town, Western Cape
 | 2023-03-08 14:43:17.060000 |  |  |  | 220 CA645115 |  | 77 |  | 60 | 00:00:00 | [NAME] (M6), Glencairn, [NAME]'s Town, Western Cape
 | 2023-03-08 15:07:17.620000 |  |  |  | 220 CA645115 |  | 85 |  | 60 | 00:00:00 | [NAME] Stel, [NAME], Cape Town, Western Cape
 | 2023-03-08 15:08:53.920000 |  |  |  | 220 CA645115 |  | 96 |  | 60 | 00:00:00 | [NAME], Alphen, Cape Town, Western Cape
 | 2023-03-08 15:10:29.200000 |  |  |  | 220 CA645115 |  | 61 |  | 60 | 00:00:00 | [NAME] Stel, Wynberg, Cape Town, Western Cape
 | 2023-03-08 15:10:54.260000 |  |  |  | 220 CA645115 |  | 62 |  | 60 | 00:00:07 | [NAME] Stel, Bishopscourt, Cape Town, Western Cape
 | 2023-03-08 15:23:17.310000 |  |  |  | 220 CA645115 |  | 83 |  | 80 | 00:01:04 | [NAME] (N2), Woodstock, Cape Town, Western Cape
 | 2023-03-08 15:25:29.310000 |  |  |  | 220 CA645115 |  | 67 |  | 60 | 00:00:00 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-08 15:25:35.430000 |  |  |  | 220 CA645115 |  | 64 |  | 60 | 00:00:00 | F.W. de Klerk, Foreshore, Cape Town, Western Cape
 | 2023-03-08 16:18:13.750000 |  |  |  | 220 CA645115 |  | 62 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 10:56:39.550000 |  |  |  | 220 CA645115 |  | 62 |  | 60 | 00:00:00 | F.W. de Klerk Boulevard (N1), Maitland, Cape Town, Western Cape
 | 2023-03-09 11:14:15.050000 |  |  |  | 220 CA645115 |  | 89 |  | 60 | 00:00:00 | N1, Windsor Park, [NAME], Western Cape
 | 2023-03-09 11:45:43.300000 |  |  |  | 220 CA645115 |  | 81 |  | 60 | 00:01:04 | N1, 7.54 km SE of [NAME], Western Cape
 | 2023-03-09 11:53:43.060000 |  |  |  | 220 CA645115 |  | 93 |  | 90 | 00:00:00 | N1, 11.23 km SE of Blouvlei, Western Cape
 | 2023-03-09 11:56:23.690000 |  |  |  | 220 CA645115 |  | 92 |  | 90 | 00:00:00 | N1, 13.69 km SW of Rawsonville, Western Cape
 | 2023-03-09 12:02:15.270000 |  |  |  | 220 CA645115 |  | 82 |  | 80 | 00:00:00 | N1, 6.39 km SW of Rawsonville, Western Cape
 | 2023-03-09 12:32:12.370000 |  |  |  | 220 CA645115 |  | 83 |  | 80 | 00:00:00 | N1, Meirings Park, Worcester, Western Cape