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: 222 CA427624

 |  |  |  | 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
 | 222 CA427624 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
 | 24 |  |  |  |  |  |  | 81km/h |  |  |  |  | 00h05m47s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-03 08:00:48.370000 |  |  |  | 222 CA427624 |  | 41 |  | 40 | 00:00:36 | 63 Victoria Road, Clifton, Cape Town, Western Cape
 | 2023-03-03 08:05:18.220000 |  |  |  | 222 CA427624 |  | 43 |  | 40 | 00:00:00 | 109 Victoria Road, Bakoven, Cape Town, Western Cape
 | 2023-03-03 08:07:30.450000 |  |  |  | 222 CA427624 |  | 42 |  | 40 | 00:00:00 | [NAME] (M6), [NAME], Western Cape
 | 2023-03-03 08:08:28.570000 |  |  |  | 222 CA427624 |  | 66 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:10:00.860000 |  |  |  | 222 CA427624 |  | 61 |  | 60 | 00:00:16 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:10:24.310000 |  |  |  | 222 CA427624 |  | 61 |  | 60 | 00:00:17 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:10:56.490000 |  |  |  | 222 CA427624 |  | 63 |  | 60 | 00:00:00 | Victoria, Oudekraal, Cape Town, Western Cape
 | 2023-03-03 08:14:40.240000 |  |  |  | 222 CA427624 |  | 65 |  | 60 | 00:00:00 | Victoria, Hout Bay, Hout Bay, Western Cape
 | 2023-03-03 08:54:40.270000 |  |  |  | 222 CA427624 |  | 32 |  | 20 | 00:00:00 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 08:55:13.750000 |  |  |  | 222 CA427624 |  | 30 |  | 20 | 00:00:22 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 08:55:44.610000 |  |  |  | 222 CA427624 |  | 40 |  | 20 | 00:00:13 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 08:58:41.020000 |  |  |  | 222 CA427624 |  | 41 |  | 40 | 00:00:47 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:21:52.440000 |  |  |  | 222 CA427624 |  | 42 |  | 40 | 00:00:40 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:22:56.750000 |  |  |  | 222 CA427624 |  | 41 |  | 40 | 00:00:32 | Chapman's Peak, Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:26:55.580000 |  |  |  | 222 CA427624 |  | 32 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:27:27.080000 |  |  |  | 222 CA427624 |  | 35 |  | 20 | 00:00:00 | Chapman's Peak Drive (M6), Cape Farms, Cape Town, Western Cape
 | 2023-03-03 09:31:29.120000 |  |  |  | 222 CA427624 |  | 43 |  | 40 | 00:00:00 | Chapman's Peak, [NAME], Noordhoek, Western Cape
 | 2023-03-03 09:45:26.190000 |  |  |  | 222 CA427624 |  | 74 |  | 70 | 00:00:27 | Slangkop, Ocean View, Cape Town, Western Cape
 | 2023-03-03 09:50:09.140000 |  |  |  | 222 CA427624 |  | 54 |  | 50 | 00:00:32 | Witsand Road (M65), [NAME], Scarborough, Western Cape
 | 2023-03-03 14:52:57.790000 |  |  |  | 222 CA427624 |  | 81 |  | 60 | 00:00:29 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-03 14:53:43.140000 |  |  |  | 222 CA427624 |  | 62 |  | 60 | 00:00:00 | [NAME] (M65), Sunnydale, [NAME], Western Cape
 | 2023-03-03 18:42:00.560000 |  |  |  | 222 CA427624 |  | 61 |  | 60 | 00:00:14 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-03 18:54:38.300000 |  |  |  | 222 CA427624 |  | 72 |  | 60 | 00:00:16 | Helen Suzman Boulevard (M6), Cape Town, Cape Town, Western Cape
 | 2023-03-03 20:56:18.390000 |  |  |  | 222 CA427624 |  | 61 |  | 60 | 00:00:06 | Helen Suzman Boulevard (M6), Green Point, Cape Town, Western Cape