ABCDEFGHIJKLMNOPQR
1
Hi all,
2
I make no guarantees with this sheet, I knocked up a very quick and dirty macro to pull the data from the results site at about 15:37 today.
3
About 19,000 riders had finished by that point. I might rerun it on Monday (or someone who is a proper professional might do a better job than me anyway!)
4
Regards
5
andrewjdavis.home@gmail.com (Kingston Wheelers)
17264761.371.386.3
Avg Speed (cumulative)
6
NumberNameClubDistanceEST MILE 17EST MILE 26
EST MILE 47
EST MILE 75EST MILE 85FINISH
Double Count?
PositionFinal
7
5135» Wilson, Ray (GBR)London Dynamo86 Milesz00:36:41z00:59:49z01:53:41z02:25:41z02:49:17z03:23:231127.8126.0824.8125.2525.2725.46
8
5771» Ross, Andy (GBR)Dorking CC86 Milesz00:36:49z00:59:54z01:53:43z02:25:40z02:49:20z03:23:271227.7026.0424.8025.2525.2625.45
9
5368» Westlake, Mark (GBR)86 Milesz00:36:54z01:00:01z01:54:08z02:25:49z02:49:23z03:23:331327.6425.9924.7125.2225.2625.44
10
19046» Siebrits, Konrad (GBR)Sorby Hinds CC86 Milesz00:36:40z01:00:01z01:53:46z02:25:46z02:49:37z03:23:341427.8225.9924.7925.2325.2225.44
11
3142» Bradley, James (GBR)Twickenham CC86 Milesz00:36:50z01:00:01z01:54:04z02:25:44z02:49:25z03:23:351527.6925.9924.7225.2425.2525.43
12
2948» Zechmann, Gunther (GBR)London Phoenix86 Milesz00:36:53z01:00:02z01:53:39z02:25:49z02:49:26z03:23:351627.6525.9924.8125.2225.2525.43
13
16699» Hammond, Matthew (GBR)Dulwich Paragon86 Milesz00:36:53z01:00:04z01:54:20z02:25:58z02:49:33z03:23:391727.6525.9724.6625.2025.2325.43
14
21733» Hickerton, Joe (GBR)86 Milesz00:36:58z01:00:05z01:54:06z02:25:57z02:49:37z03:23:411827.5925.9624.7225.2025.2225.42
15
18729» Copeland, Tom (GBR)Nuun Sigma Sport Lond...86 Milesz00:36:55z01:00:07z01:53:59z02:25:57z02:49:33z03:23:421927.6325.9524.7425.2025.2325.42
16
18727» Wilson, Jimmy (GBR)Nuun Sigmasport86 Milesz00:36:57z01:00:08z01:54:11z02:25:59z02:49:49z03:23:4211027.6025.9424.7025.1925.1925.42
17
18730» Muir, Ross (GBR)nuun-sigmasport-londo...86 Milesz00:36:56z01:00:08z01:54:01z02:25:58z02:49:39z03:23:4311127.6225.9424.7325.2025.2225.42
18
18728» McLean, Craig (GBR)Nuun Sigma Sport86 Milesz00:36:56z01:00:08z01:54:09z02:26:00z02:49:36z03:23:4411227.6225.9424.7025.1925.2225.42
19
21804» Diesel, Bruce (RSA)86 Milesz00:36:56z01:00:04z01:53:55z02:25:51z02:49:36z03:23:4811327.6225.9724.7525.2225.2225.41
20
1278» Patterson, Bill (GBR)Clapham Chasers86 Milesz00:36:41z00:59:47z01:53:49z02:25:40z02:49:26z03:24:1411427.8126.0924.7825.2525.2525.35
21
21467» Galloway, Steve (GBR)86 Milesz00:36:43z00:59:47z01:53:47z02:25:36z02:49:21z03:24:1511527.7826.0924.7825.2625.2625.35
22
7009» Raistrick, Luke (GBR)Sorby Hinds CC86 Milesz00:36:40z00:59:54z01:54:04z02:25:45z02:49:33z03:24:1911627.8226.0424.7225.2325.2325.34
23
6855» Brocklebank, Dan (GBR)London Dynamo86 Milesz00:36:53z00:59:59z01:54:02z02:25:58z02:49:41z03:24:2911727.6526.0124.7325.2025.2125.32
24
41057» Slavonia, Mark (GBR)86 Milesz00:37:00z01:00:13z01:54:23z02:26:06z02:49:51z03:24:3711827.5725.9124.6525.1725.1925.31
25
34887» Clay, Jonny (GBR)86 Milesz00:38:24z01:01:33z01:55:43z02:27:16z02:51:01z03:25:0911926.5625.3524.3724.9825.0225.24
26
13558» Dick, Christopher (GBR)London Phoenix86 Milesz00:38:38z01:01:46z01:55:35z02:27:33z02:51:13z03:25:2012026.4025.2624.4024.9324.9925.22
27
34601» Brown, Andrew (GBR)Dulwich Paragon86 Milesz00:38:37z01:01:46z01:55:50z02:27:39z02:51:13z03:25:2112126.4125.2624.3524.9124.9925.22
28
34691» Knapp, Ben (GBR)Dulwich Paragon86 Milesz00:38:35z01:01:45z01:55:38z02:27:36z02:51:12z03:25:2112226.4425.2624.3924.9224.9925.22
29
26288» Franklin, Matthew (GBR)Dymag T1D86 Milesz00:38:44z01:01:47z01:55:49z02:27:35z02:51:20z03:25:2212326.3325.2524.3524.9224.9725.21
30
27199» Black, Thomas (GBR)86 Milesz00:38:37z01:01:46z01:55:49z02:27:40z02:51:22z03:25:2412426.4125.2624.3524.9124.9625.21
31
26272» Merryweather, Paul (GBR)86 Milesz00:38:38z01:01:47z01:55:48z02:27:39z02:51:21z03:25:2412526.4025.2524.3524.9124.9725.21
32
34611» Maidment, Roger (GBR)East London Velo86 Milesz00:38:37z01:01:49z01:56:00z02:27:42z02:51:20z03:25:2512626.4125.2424.3124.9024.9725.21
33
34699» Crombie, Wayne (GBR)East London Velo86 Milesz00:38:37z01:01:49z01:55:39z02:27:37z02:51:16z03:25:2612726.4125.2424.3824.9224.9825.21
34
17798» Scott, Will (GBR)Bonito Squadra Corse86 Milesz00:38:43z01:01:51z01:55:39z02:27:35z02:51:16z03:25:2712826.3525.2224.3824.9224.9825.20
35
34758» Browne, James (GBR)VC Norwich86 Milesz00:38:54z01:01:56z01:55:50z02:27:49z02:51:25z03:25:3012926.2225.1924.3524.8824.9625.20
36
28614» Bexley, Dylan (GBR)Dorking CC86 Milesz00:38:47z01:01:57z01:55:46z02:27:42z02:51:23z03:25:3313026.3025.1824.3624.9024.9625.19
37
34741» Gasson, Nick (GBR)34 Nomads86 Milesz00:38:54z01:01:58z01:55:51z02:27:55z02:51:29z03:25:3313126.2225.1724.3424.8724.9525.19
38
34763» Ketteringham, Greg (GBR)Harrogate Nova CC86 Milesz00:38:51z01:01:59z01:55:53z02:27:53z02:51:33z03:25:3313226.2525.1724.3324.8724.9425.19
39
34770» Longhi, Dario (GBR)86 Milesz00:38:47z01:01:57z01:55:47z02:27:45z02:51:24z03:25:3313326.3025.1824.3624.8924.9625.19
40
34624» Unwin, Richard (GBR)VC Meudon86 Milesz00:38:57z01:01:59z01:55:51z02:27:54z02:51:31z03:25:3413426.1925.1724.3424.8724.9425.19
41
34794» Mcquillan, Daniel (GBR)ycc86 Milesz00:38:49z01:01:59z01:56:19z02:27:52z02:51:29z03:25:3513526.2825.1724.2424.8724.9525.19
42
27768» Rigg, Andrew (GBR)Lafuga.cc86 Milesz00:38:50z01:02:01z01:55:56z02:27:51z02:51:28z03:25:3613626.2725.1524.3224.8824.9525.18
43
34685» Ainsworth, Keith (GBR)Sheffrec CC86 Milesz00:38:53z01:02:00z01:55:51z02:27:46z02:51:34z03:25:3713726.2325.1624.3424.8924.9325.18
44
34698» Bouchard-Hall, Derek (GBR)86 Milesz00:38:56z01:02:01z01:55:50z02:27:53z02:51:29z03:25:3713826.2025.1524.3524.8724.9525.18
45
34670» Morton, Gavin (GBR)VC Meudon86 Milesz00:38:49z01:02:01z01:55:49z02:27:53z02:51:30z03:25:3713926.2825.1524.3524.8724.9425.18
46
29360» Hall, Sam (GBR)AVC86 Milesz00:38:52z01:02:01z01:55:54z02:27:53z02:51:35z03:25:3814026.2425.1524.3324.8724.9325.18
47
34728» Whitehorn, Richard (GBR)Glade CC86 Milesz00:38:50z01:02:01z01:55:55z02:27:50z02:51:31z03:25:3814126.2725.1524.3324.8824.9425.18
48
35391» Cox, Paul (GBR)Team Pedal Power86 Milesz00:38:52z01:01:44z01:55:44z02:27:52z02:51:29z03:25:3914226.2425.2724.3724.8724.9525.18
49
30321» Atkinson, Adam (GBR)34 Nomads86 Milesz00:38:54z01:01:37z01:55:47z02:27:55z02:51:33z03:25:4014326.2225.3224.3624.8724.9425.18
50
34737» Harrison, James (GBR)86 Milesz00:39:03z01:02:06z01:56:00z02:27:57z02:51:36z03:25:4114426.1225.1224.3124.8624.9325.17
51
34751» worden, Mike (GBR)Harrogate Nova CC86 Milesz00:38:49z01:01:55z01:55:52z02:27:44z02:51:28z03:25:4114526.2825.2024.3424.9024.9525.17
52
34659» Langford, Stephen (GBR)86 Milesz00:38:58z01:02:05z01:56:00z02:27:57z02:51:34z03:25:4214626.1825.1324.3124.8624.9325.17
53
34664» Bohm, Benno (RSA)PPA86 Milesz00:38:54z01:02:05z01:56:14z02:27:56z02:51:32z03:25:4314726.2225.1324.2624.8624.9425.17
54
34775» peace, Andrew (GBR)jedicyclesport86 Milesz00:39:00z01:02:11z01:55:59z02:27:57z02:51:42z03:25:4414826.1525.0924.3124.8624.9225.17
55
17749» Calder, Craig (GBR)Bigfoot CC86 Milesz00:38:58z01:02:09z01:56:05z02:27:59z02:51:34z03:25:4714926.1825.1024.2924.8524.9325.16
56
15110» Round-Turner, Paul (GBR)Army Cycling Union86 Milesz00:38:40z01:01:46z01:55:50z02:27:34z02:51:20z03:26:0715026.3825.2624.3524.9224.9725.12
57
18079» Whitwell, Keith (GBR)Dulwich Paragon86 Milesz00:38:48z01:01:51z01:55:56z02:27:44z02:51:18z03:26:1315126.2925.2224.3224.9024.9725.11
58
18142» Galvin, Graham (GBR)East London Velo86 Milesz00:38:37z01:01:49z01:55:54z02:27:44z02:51:27z03:26:1615226.4125.2424.3324.9024.9525.10
59
34782» Charlles, Lee (GBR)86 Milesz00:39:02z01:02:06z01:56:29z02:27:54z02:51:37z03:26:2215326.1325.1224.2124.8724.9325.09
60
34778» Zappala, Christopher (GBR)Look Mum No Hands RT86 Milesz00:39:07z01:02:09z01:56:14z02:27:54z02:51:35z03:26:2815426.0825.1024.2624.8724.9325.08
61
34692» Lewis, Jon (GBR)Charlotteville CC86 Milesz00:39:04z01:02:10z01:56:23z02:28:03z02:51:46z03:26:3315526.1125.0924.2324.8424.9125.07
62
19258» McCarthy, James (GBR)Twickemham CC86 Milesz00:36:48z01:00:00z01:54:06z02:25:51z02:49:48z03:26:3515627.7226.0024.7225.2225.1925.06
63
35418» Towns, Neil (GBR)Team WIggle86 Milesz00:39:02z01:02:08z01:56:22z02:27:54z02:51:41z03:26:4115726.1325.1124.2324.8724.9225.05
64
5870» Courtiade, Daniel (GBR)86 Milesz00:36:49z00:59:53z01:54:00z02:25:46z02:49:25z03:26:4915827.7026.0524.7425.2325.2525.04
65
4389» Humphris, Ian (GBR)86 Milesz00:36:59z01:00:04z01:54:03z02:25:53z02:49:39z03:26:5015927.5825.9724.7325.2125.2225.03
66
6589» Smith, Kai (GBR)86 Milesz00:37:03z01:00:05z01:54:18z02:25:52z02:49:36z03:26:5116027.5325.9624.6725.2125.2225.03
67
6358» Heath, Matthew (GBR)East London Velo86 Milesz00:36:50z00:59:59z01:54:20z02:25:54z02:49:36z03:26:5416127.6926.0124.6625.2125.2225.03
68
18997» Simmonds, Daniel (GBR)86 Milesz00:36:55z01:00:06z01:54:24z02:25:59z02:49:45z03:26:5716227.6325.9624.6525.1925.2025.02
69
18451» judson, Cameron (GBR)Kingston Wheelers86 Milesz00:37:09z01:00:27z01:54:53z02:27:40z02:51:55z03:27:1916327.4625.8124.5524.9124.8824.98
70
28993» Davis, Andrew (GBR)Kingston Wheelers86 Milesz00:37:10z01:00:27z01:55:01z02:27:45z02:51:57z03:27:2216427.4425.8124.5224.8924.8824.97
71
17965» Smith, Grant (GBR)86 Milesz00:37:12z01:00:29z01:55:04z02:27:49z02:52:08z03:27:2216527.4225.7924.5124.8824.8524.97
72
18452» Wright, Pat (GBR)Kingston Wheelers86 Milesz00:37:06z01:00:22z01:54:57z02:27:48z02:51:53z03:27:2216627.4925.8424.5324.8824.8924.97
73
17961» Samuel, Ian (GBR)crest cycling club86 Milesz00:37:13z01:00:28z01:55:11z02:27:45z02:52:02z03:27:2416727.4125.8024.4824.8924.8724.97
74
26560» Hickson, Craig (GBR)mid devon cc86 Milesz00:37:22z01:00:37z01:55:04z02:27:52z02:52:07z03:27:2816827.3025.7424.5124.8724.8624.96
75
9472» Strong, Daniel (GBR)Tavistock Wheelers CC86 Milesz00:37:22z01:00:40z01:55:04z02:28:02z02:52:18z03:27:3116927.3025.7124.5124.8524.8324.95
76
10690» Smith, Mark (GBR)Crawley Wheelers86 Milesz00:37:22z01:00:38z01:55:10z02:27:52z02:52:13z03:27:3217027.3025.7324.4924.8724.8424.95
77
18523» Sibbe, Riko (GBR)London Dynamo86 Milesz00:37:25z01:00:40z01:55:06z02:27:54z02:52:09z03:27:3317127.2625.7124.5024.8724.8524.95
78
18528» Littlechild, Harry (GBR)london dynamo86 Milesz00:37:24z01:00:39z01:55:08z02:27:58z02:52:17z03:27:3417227.2725.7224.4924.8624.8324.95
79
17724» COURSE, DAVID (GBR)Bedfordshire Road Cyc...86 Milesz00:37:25z01:00:42z01:55:13z02:28:01z02:52:19z03:27:3517327.2625.7024.4824.8524.8324.94
80
18522» Francis, Jamie (GBR)London Dynamo86 Milesz00:37:27z01:00:42z01:55:08z02:28:01z02:52:21z03:27:3617427.2425.7024.4924.8524.8224.94
81
9569» Potts, Jonathan (GBR)London Dynamo86 Milesz00:37:14z01:00:31z01:55:00z02:27:51z02:52:08z03:27:4417527.3925.7824.5224.8824.8524.93
82
17881» Hopwood, Ben (GBR)Charlotteville CC86 Milesz00:39:09z01:02:13z01:56:12z02:28:00z02:51:48z03:27:5917626.0525.0724.2724.8524.9024.90
83
21810» Fisher, Bernard (GBR)86 Milesz01:10:25z00:00:00z00:00:00z00:00:00z00:00:00z03:28:0717714.49#DIV/0!#DIV/0!#DIV/0!#DIV/0!24.88
84
18450» Moore, Paul (GBR)Kingston Wheelers CC86 Milesz00:37:08z01:00:26z01:55:02z02:27:42z02:52:10z03:28:3017827.4725.8124.5124.9024.8524.83
85
3686» Griffiths, Mark (GBR)Kingston Wheelers86 Milesz00:36:49z01:00:00z01:54:14z02:25:52z02:49:35z03:28:3117927.7026.0024.6925.2125.2324.83
86
5837» Leitch, Mark (GBR)86 Milesz00:36:53z01:00:04z01:54:06z02:25:54z02:49:42z03:28:3218027.6525.9724.7225.2125.2124.83
87
18672» Brougham, Jeremy (GBR)Mono Velo86 Milesz00:36:53z01:00:09z01:54:18z02:26:04z02:49:55z03:28:3518127.6525.9424.6725.1825.1824.82
88
35069» Peel, Richard (GBR)Clapham Chasers86 Milesz00:38:34z01:01:41z01:55:43z02:27:33z02:51:21z03:28:3718226.4525.2924.3724.9324.9724.82
89
27251» Whitehead, Ben (GBR)Hackney GT86 Milesz00:37:19z01:00:37z01:55:07z02:27:53z02:52:08z03:28:4318327.3325.7424.5024.8724.8524.81
90
27684» Moss, Alex (GBR)Dulwich Paragon86 Milesz00:37:23z01:00:43z01:55:08z02:28:02z02:52:25z03:28:4518427.2825.6924.4924.8524.8124.80
91
18525» Bastin, Alexander (GBR)London Dynamo86 Milesz00:37:24z01:00:39z01:55:16z02:27:58z02:52:14z03:28:4718527.2725.7224.4724.8624.8424.80
92
26682» Lehan, Paul (GBR)Harrogate Nova cc86 Milesz00:38:57z01:02:01z01:56:09z02:27:55z02:51:42z03:28:5518626.1925.1524.2824.8724.9224.79
93
9058» Holt, Ian (GBR)La Fuga.CC86 Milesz00:38:54z01:02:03z01:56:05z02:27:52z02:51:38z03:29:0018726.2225.1424.2924.8724.9324.78
94
27765» Worthington, Dave (GBR)Dulwich Paragon86 Milesz00:00:00z00:00:00z01:56:06z02:27:55z02:51:37z03:29:05188#DIV/0!#DIV/0!24.2924.8724.9324.77
95
5629» Murray, Graeme (GBR)86 Milesz00:37:45z01:01:34z01:57:42z02:30:29z02:54:54z03:30:0218927.0225.3423.9624.4424.4624.65
96
16840» Leach, Ben (GBR)Vedett Racing Team86 Milesz00:37:45z01:01:32z01:57:37z02:30:27z02:54:43z03:30:0319027.0225.3523.9824.4524.4924.65
97
35620» Phelps, James (GBR)86 Milesz00:37:49z01:01:37z01:57:47z02:30:35z02:54:55z03:30:0919126.9725.3223.9424.4324.4624.64
98
6595» Lewis, Adam (GBR)86 Milesz00:37:52z01:01:40z01:57:53z02:30:40z02:55:00z03:30:1119226.9425.3023.9224.4124.4524.64
99
5426» Perks, Jeremy (GBR)86 Milesz00:37:48z01:01:32z01:57:48z02:30:26z02:54:52z03:30:1319326.9825.3523.9424.4524.4624.63
100
22721» Weston, Mark (GBR)86 Milesz00:39:31z01:03:28z01:58:03z02:30:42z02:54:57z03:30:2219425.8124.5823.8924.4124.4524.61