Spreadsheet: 144793d1331138577-count-within-an-if-statement-example-speeding
Sheet: Masternaught

Date | Vehicle | Vehicle Group | Driver Name | Speed Over Limit | Location | Road Speed Limit | Percentage | Time
2012-01-04 00:00:00 | DU52LFF | [NAME] | DU52LFF | 39 | A695, [NAME], NE44 6 | 30 | 29.16666666666669 | 11:44:21
2012-01-05 00:00:00 | DU52LFF | [NAME] | DU52LFF | 57 | A1, Swalwell, Newcastle, NE16 3 | 50 | 13.75 | 08:58:34
2012-01-05 00:00:00 | DU52LFF | [NAME] | DU52LFF | 56 | A1, Swalwell, Newcastle, NE16 3 | 50 | 12.5 | 08:58:37
2012-01-03 00:00:00 | DU52LFF | [NAME] | DU52LFF | 45 | A69, West Denton, Newcastle, NE5 2 | 40 | 12.5 | 09:33:05
2012-01-04 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Corbridge, NE45 5 | 30 | 12.5 | 12:21:42
2012-01-05 00:00:00 | DU52LFF | [NAME] | DU52LFF | 55 | A1, Swalwell, Newcastle, NE16 3 | 50 | 10.00000000000001 | 08:58:42
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 45 | A695, [NAME], NE44 6 | 30 | 50 | 14:19:57
2012-01-09 00:00:00 | DU52LFF | [NAME] | DU52LFF | 56 | A69, West Denton, Newcastle, NE5 5 | 40 | 40.625 | 10:06:06
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 39 | A695, [NAME], NE44 6 | 30 | 29.16666666666669 | 10:07:28
2012-01-12 00:00:00 | DU52LFF | [NAME] | DU52LFF | 51 | A69, West Denton, Newcastle, NE5 5 | 40 | 28.125 | 13:08:50
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 38 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 27.08333333333333 | 14:09:22
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 38 | Walker Rd (A186), Newcastle, NE6 1 | 30 | 27.08333333333333 | 11:50:15
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 37 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 25 | 09:57:38
2012-01-12 00:00:00 | DU52LFF | [NAME] | DU52LFF | 37 | [NAME] (A6076), Stanley, DH9 0 | 30 | 22.91666666666667 | 10:56:59
2012-01-12 00:00:00 | DU52LFF | [NAME] | DU52LFF | 36 | A695, Oakwood, Hexham, NE46 4 | 30 | 20.83333333333333 | 13:25:29
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 36 | B6529, Corbridge, NE45 5 | 30 | 20.83333333333333 | 07:56:06
2012-01-12 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | A695, [NAME], NE44 6 | 30 | 18.75 | 10:03:48
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | [NAME], Elswick, Newcastle, NE4 7 | 30 | 18.75 | 11:04:32
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | A695, Corbridge, NE45 5 | 30 | 16.66666666666667 | 09:34:48
2012-01-09 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | B6530, Corbridge, NE45 5 | 30 | 16.66666666666667 | 12:59:03
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 46 | A69, West Denton, Newcastle, NE5 2 | 40 | 15.625 | 10:46:17
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Corbridge, NE45 5 | 30 | 14.58333333333333 | 10:09:44
2012-01-09 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Low Prudhoe, Prudhoe, NE42 6 | 30 | 14.58333333333333 | 10:58:13
2012-01-13 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | B6531, Hexham, NE46 3 | 30 | 14.58333333333333 | 13:50:29
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | [NAME], Elswick, Newcastle, NE4 7 | 30 | 14.58333333333333 | 10:55:21
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | A695, Oakwood, Hexham, NE46 4 | 30 | 10.41666666666667 | 09:57:07
2012-01-11 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | A695, [NAME], NE43 7 | 30 | 10.41666666666667 | 14:14:46
2012-01-16 00:00:00 | DU52LFF | [NAME] | DU52LFF | 41 | Scotswood Rd (A695), Elswick, Newcastle, NE4 7 | 30 | 37.5 | 14:28:38
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 39 | [NAME] (A6076), Stanley, DH9 0 | 30 | 31.25 | 11:18:17
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 37 | A695, [NAME], NE44 6 | 30 | 25 | 14:10:35
2012-01-18 00:00:00 | DU52LFF | [NAME] | DU52LFF | 36 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 20.83333333333333 | 11:26:42
2012-01-18 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | [NAME], Elswick, Newcastle, NE4 7 | 30 | 16.66666666666667 | 11:01:49
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Hexham, NE46 1 | 30 | 14.58333333333333 | 12:35:43
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | [NAME] (A6076), Stanley, DH9 0 | 30 | 14.58333333333333 | 11:18:09
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | [NAME] (A692), The Grove, [NAME], DH8 8 | 30 | 14.58333333333333 | 15:23:04
2012-01-18 00:00:00 | DU52LFF | [NAME] | DU52LFF | 45 | A69, West Denton, Newcastle, NE5 5 | 40 | 12.5 | 10:08:38
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Corbridge, NE45 5 | 30 | 12.5 | 12:19:55
2012-01-18 00:00:00 | DU52LFF | [NAME] | DU52LFF | 44 | Corchester Lane, Corbridge, NE45 5 | 40 | 10.9375 | 09:47:28
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | A695, [NAME], NE44 6 | 30 | 10.41666666666667 | 10:03:13
2012-01-17 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | [NAME] (A692), The Grove, [NAME], DH8 8 | 30 | 10.41666666666667 | 14:29:44
2012-01-16 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | [NAME], North Shields, NE29 8 | 30 | 10.41666666666667 | 13:53:14
2012-01-23 00:00:00 | DU52LFF | [NAME] | DU52LFF | 40 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 33.33333333333331 | 11:51:53
2012-01-26 00:00:00 | DU52LFF | [NAME] | DU52LFF | 39 | A695, [NAME], NE44 6 | 30 | 31.25 | 12:57:04
2012-01-27 00:00:00 | DU52LFF | [NAME] | DU52LFF | 38 | A695, [NAME], NE44 6 | 30 | 27.08333333333333 | 09:24:11
2012-01-26 00:00:00 | DU52LFF | [NAME] | DU52LFF | 37 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 25 | 12:44:58
2012-01-27 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | A695, [NAME], NE43 7 | 30 | 18.75 | 09:29:45
2012-01-25 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 18.75 | 16:10:36
2012-01-24 00:00:00 | DU52LFF | [NAME] | DU52LFF | 35 | A695, Corbridge, NE45 5 | 30 | 16.66666666666667 | 12:40:47
2012-01-27 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | A695, Corbridge, NE45 5 | 30 | 14.58333333333333 | 09:22:11
2012-01-27 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | B6529, Corbridge, NE45 5 | 30 | 14.58333333333333 | 11:14:32
2012-01-23 00:00:00 | DU52LFF | [NAME] | DU52LFF | 34 | [NAME], Elswick, Newcastle, NE4 7 | 30 | 14.58333333333333 | 11:33:11
2012-01-27 00:00:00 | DU52LFF | [NAME] | DU52LFF | 45 | Corchester Lane, Corbridge, NE45 5 | 40 | 14.0625 | 11:12:40
2012-01-26 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | B6529, Corbridge, NE45 5 | 30 | 10.41666666666667 | 11:07:16
2012-01-24 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | [NAME] (A183), Sunderland, SR4 8 | 30 | 10.41666666666667 | 10:59:00
2012-01-31 00:00:00 | DU52LFF | [NAME] | DU52LFF | 33 | Princess Way (A695), Low Prudhoe, Prudhoe, NE42 6 | 30 | 10.41666666666667 | 10:31:46