Sunday 17 June 2012

Update 17-June-2012

I went out for a ride this morning expecting sunny weather but was disappointed. It was a case for the first hour or so for "Rule 9". I went off towards Rose Hill, then Alvechurch, Tardebigge, Astwood Bank and then Redditch to have another go at some of the segments there. I was feeling OK and (for me) pressing on OK. I felt reasonably strong at Rose Hill (actually the Fiery Hill/Twatling Rd Climb) and also up Scarfield Hill and carried on up to Astwood Bank.

At Astwood Bank instead of going straight on I turned left and headed to Redditch. I have ridden this way before about 18 months ago (actually on 2 Jan 2011). I knew that I'd get near the Icknield Street turn but if I carried on I'd get to the "Paper Mill Rip" segment and from there I was hoping to find the way onto the road that would take me along to Easemore Road and into Redditch town centre to have a go at the Unicorn Hill and Prospect Hill segments again. In addition on Easemore Road there are 2 segments - 1 up and 1 down so plenty of options there.

I almost got round to the Paper Mill Rip section without error - just a couple of mistakes. I also spotted the way up to Easemore Road from Paper Mill Road (well hidden and getting a bit agricultural) so was able to approach from the right place. Easemore Road was a bit of a drag after the miles already under my belt and I knew it wasn't a great time. I rode down Unicorn Hill to where I felt the longer segment started (BUOTC Unicorn Hill) and returned and rode the segment (2 for the price of 1!). I felt reasonably strong and knew the time would be better than previously. I stopped for a quick bit of food before descending Prospect Hill, rode down to the Volvo Garage (the start), U-turned and within ~15 seconds had almost blown. The rest of the ascent was a painful slog back to the top. I pushed for the Easemore Road descent but knew that basically from then on it would be a gentle ride back home. I rode back over a few more segments but there was almost nothing left in my legs. The only positive was I managed to drive the average speed up from 16.7mph in Redditch up to 16.9mph by the time I got home.

Over the whole route I managed to get 16 Achievements (some new of course) but some others were outright improvements.

Rides stats:

Distance =59.9 miles,
Average speed = 16.9mph, 
Maximum speed = 36.2mph, 
Height gain = 2924ft.

I have used my Excel tool to extract the segment data for this ride and present in this table (with a little bit of additional work). There is some more work to do to get the position in the segment rankings, this is the next job to do. I can read all a riders Ride Data (the rides they have ridden) with the overall stats (average speed etc) and the details of each of the segments ridden during that ride and the times etc. for the segment.

Segment ID
Effort Moving Time (s)
Effort Distance (mile)
Effort Average Speed (mph)
Effort Name
Climb Category
Average Grade (%)
Elevation Difference (meters)
824883
371
1.24
12.1
Scarfield Hill, Alvechurch
Cat 4
4.16
82.6
876084
552
2.35
15.3
Icknield St Climb
No Catorised
1.52
68.6
882563
83
0.23
9.9
Prospect Hill
No Catorised
5.25
20
891731
407
2.45
21.7
B4101 Hockey Heath
No Catorised
-0.56
26.4
891753
337
1.78
19.0
Poolhead Lane
No Catorised
-0.32
19.8
937392
164
0.52
11.3
Astwood Lane Climb into Astwood Bank
No Catorised
5.34
44.4
982643
82
0.32
14.2
Vicarage Hill Cheswick Green
No Catorised
2.02
10.6
1007821
79
0.47
21.4
Dyers Drag
No Catorised
-1.11
8.609
1068596
190
0.67
12.7
Easmore Rd Climb
No Catorised
3.73
40.6
1069174
502
1.85
13.3
Fiery Hill / Twatling Rd Climb
Cat 4
3.67
108.935
1080918
43
0.20
16.7
BUOTC Unicorn Hill
No Catorised
3.37
14
1265825
81
0.64
28.3
Easmore Downhill
No Catorised
-3.50
36.4
1328072
182
1.08
21.3
Paper Mill Rip
No Catorised
-1.34
23.4
1328098
63
0.29
16.8
Ravens Bank Rise
No Catorised
1.54
7.4
1403219
289
1.12
13.9
Brookhouse Road Climb
No Catorised
3.59
64.878
1409586
102
0.57
20.3
Clayfields
No Catorised
-2.08
23.2999
1417426
117
0.76
23.3
fiery hill descent
No Catorised
-3.64
44.8
1456696
292
1.48
18.3
Sheltwood Decent
No Catorised
-1.19
38.4
1458872
116
0.56
17.5
Croft Lane
No Catorised
0.47
5.586
1458941
22
0.10
16.7
Unicorn Hill
No Catorised
5.90
9.8
1472706
106
0.39
13.4
Cruise Hill Climb
No Catorised
2.73
17.827
1483394
189
1.14
21.7
Umberslade Road to Cut Throat Lane
No Catorised
-0.52
23.287
1516358
46
0.39
30.7
Rough Hill Drive Decent
No Catorised
-5.61
35.2
1516367
394
2.38
21.8
Island Challenge
No Catorised
-2.41
72.8









The other thing that is really easy now is to generate a graphic showing e.g. performance vs. date. He is my improvement over Scarfield Hill in Alvechurch:




Certainly an improvement this year!

And the roads were wet and dirty:

See where my overshoes were!
Also when I got home (and later in the day I got two of the "Uh Oh.." you've lost your KOM emails from Strava. The first was Hampton Hill (Solihull) taken by Steve Large by 3 secs and the second was Dyers Drag taken by another 7 secs by Dave Brown, so I am now 8 secs behind on this segment (although still 2nd overall). Steve is quick and does pretty long rides whereas Dave is nothing by a segment whore!

Here are these emails:


Friday 15 June 2012

Strava Analysis - Next Steps

I posted earlier that it was hard to review all of the data that is uploaded into Strava. I posted a graph that I had generated of my performance over time over one particular segment (Lowsonford to Lapworth) and how much work it took.

I did a bit of Googling and have found some Strava APIs that allow access to data programmatically. I have been using these to write an Excel application to load ride data into Excel. Its very much a work in progress but seems to be going well. It uses wget.exe to actually get the data and then parses the downloaded file into Excel.

So far it has downloaded all my rides (~240), pulled out the high level ride stats like average speed, ride time, height gain, and then pulled out all the segments in those rides. The next step is to pull the segment leader board out. However already I have generated a graph in Excel of my average speed since 1 Jan 2011 to see how it varies through the year. It shows a dip in the winter but a gradual increase so I am improving. More information will follow later.


Update 15 June 2012

Circumstances beyond my control (weather and work commitments) meant that there was no opportunity to commute to work this week so I took the opportunity of good weather in the evening on Wednesday for a short run. I did a run that is pretty flat and just under 16 miles as I didn't want to be out for too long. It was a bit of a struggle to get going as it was not that long after dinner but I was pretty pleased with the outcome when I got home. To keep it short I made a number of improvements on some of the Strava segments close to home:

Watery Eyes Warm Up - 3rd  - 1:04 (previous best 1:05)
Box Trees Rd, Four Ashes Road - 2nd - 4:46 (previous best 4:47)
Widney Manor Uphill - 3rd - 0:21 (previous best 0:22)
St Alphege Hill - 3rd - 0:21  (previous best 0:24) 
Overall Stats - 15.7miles, average speed - 18.5mph

Although some of these are quite small time improvements, for these segments 1 second can make a number of places up. I was very pleased with this ride

I then took the opportunity on Friday evening to have another quick ride. Because the weather had been so wet I decided to take the Giant as it has mudguards fitted, and wear my overshoes as well. I rode the same route again, and was hoping that the strong wind would help on some segments.

The results were:
Box Trees Short Leg Blast - 6th - 1:08 (previous best 1:09)
Box Trees Rd, Four Ashes Road - KOM - 4:39 (previous best 4:46)
Widney Manor Uphill - 2nd - 0:19 (previous best 0:21)
St Alphege Hill - 3rd - 0:21  (previous best 0:21, equalled Wednesday's time)
Overall Stats - 15.6miles, average speed - 18.0mph
Again I was pleased with the ride - there was a level of wind assistance for some segments but when it was a head wind I really lost out - hence the 0.5mph drop in average speed. I also do believe that the Focus is worth 0.5-1 mph over the Giant depending on conditions and distance.

It was good to get out and get the miles and good to get some improved segment times in and a KOM as well. In fact for the KOM there were road works about 1/2 way along the road so I almost had to stop. I didn't and jumped the red light, so I know I had a about 2 seconds more that I could have go.

Monday 11 June 2012

Update 11 June 2011

Pedal for Parkinsons Stratford On Avon, 10 June 2012

As I mentioned earlier I was riding the Pedal for Parkinsons in Stratford On Avon on Sunday. I rode it last year and "won" so there was a bit of self induced pressure to replicate the achievement this year. Also this year one of my sons had agreed to ride it as well, although he was doing the shorter (20 mile) route whilst I was doing the 60 mile route again.

As 60 miles is not really a challenge I had chosen to ride down again. Noel rang up and said what was I doing and was I up for a ride on the day. I explained that I was prior booked but there was nothing to stop him joining us on the line. However the problem would be that as we had a car full we could not give him a lift home. In the event I called in on the way down at 7.20am and we rode down together to the Gospel Oak Lane, Snitterfield  turn just before Stratford. Noel rode like a demon and my average (from home to Stratford Racecourse was a creditable 18.1mph - Thanks Noel!

People were already signing on so I waited for the family to arrive, and then my son & I signed on. I met Tim Beattie there (from work) who lives locally and had brought his son down to ride the 5 mile family route. There was a short safety briefing and some photos and then we all started en-masse. I say en-masse but the event is pretty small and low-key, there only being about 50-60 riders maximum. The riders also tend to be not the normal "sportive" MAMIL types, with a lot of first time and family leisure riders. Of the 60 people or so the majority also do the 20 mile option.

My son and I were at the back at the start so we were caught in a bit of a gaggle of less experienced riders. I was also unsure about how well my son would manage as he cycles, but not a lot. We started to pull through the riders and steadily made progress up the field over the first few miles. I was tracking my son's speed and riding slightly behind and out to shield him from what little traffic there was. However we were still flying along at around 18-20mph and by Long Marston, where the route split, were either near or at the front. I was more worried that we were going too fast, especially for me to maintain pace for the whole 60 miles.

My son turned off onto the short route and despite my concerns about long term pace over the whole ride I put some more pace down to catch people who I knew were in front. I was trying pretty hard and reeling in a few people in every few miles - I felt pretty good and seemed to be one of the fitter and stronger riders and wanted to create a gap as early as possible - if I were to win again.

We came up to a turn after about 12 miles or so and there was a small check point on the turn, so I called my number and carried on. There were 4-5 already riders there getting a drink, so I knew I had gained some places but had no idea if they were the leaders. Immediately after this checkpoint a pretty big hill loomed. I dropped to the small ring and dug in - pretty soon I was in bottom gear (34-28) and really working hard. A quick glance at my Garmin showed a fairly scary 182bpm Heart Rate and the gradient at about 12%, so I eased up a little and plodded on. The gradient started to ease a bit but I kept pushing guessing that this hill must be a Strava segment and the end was probably at the very top rather than a false summit I could see ahead. Getting home later showed this to be Camden Hill:

I got a stunning 3rd place in this segment. I was right to press on because this segment is all the way to the top whilst another segment (Campden/Nebsworth Hill) is shorter and only covers the steepest part. I got a 3rd here because I pushed all the way, but on the shorter part of the climb was only 12th quickest as the quick people slowed after a faster climb over the steeper part.

I had looked behind part way up and saw the people at the checkpoint climbing some distance behind me but felt I could probably pull away from them. I pressed on feeling fairly good but - disaster - then got held up at a level crossing at Chipping Camden. I waited for over 5 minutes and the following group caught me, putting all my efforts back to zero. When the gates finally opened I had to push hard again to try to rebuild the gap that I had worked hard for just 10 minutes ago. The only advantage of the level crossing was it gave me an enforced rest.

There was a rdie through Chipping Camden and a few miles later an exciting descent of Dovers Hill - I'm glad it wasn't an ascent. I have climbed Saintbury Hill a couple of times on other sportives and Dovers Hill looks much tougher.

I kept pushing and got to the 2nd stop. Again it was still hard to tell if where I was in the field as the 2nd stop was a joint long/short route checkpoint and there were a number of other people there. I filled my water bottle and continued having stopped for just a few minutes. I knew the roads reasonably well by this point as have ridden them many times before. This years route was similar to previous years but had been changed in several places. It was a long drag and I kept pushing although in some places was starting to feel the miles in my legs (I'd already done 19miles to get down to the start). Once I crossed the A46 in a northerly direction I knew that the route was less hilly and more of a slog up towards Spernal, so on I continued. I got to the 3rd checkpoint and I think I caught the person out a bit and a quick verbal check confirmed my lead position. From here it was a continued drive to make sure I did not get caught - although I could not see anyone behind its hard to keep looking back and obviously its easier for a chaser to see someone and catch than the leader to keep eyes in the back of your head.
 
As we approached Aston Cantlow we were surprisingly directed up to Aston Cantlow rather than continue straight on and back over the A46 to Binton. Whilst the short climb was unwelcome, crossing the A46 at Binton is challenging at the best of times so this was a good improvement to the route safety. There was then a meander back into the west of Stratford, and suddenly we were back at the racecourse. It turned out the route was 55.8 miles rather than 60.

I was again the first back (hurray!) so my efforts were worth it. What was even better was my son was first back for the short route by a good 5 minutes as well, so a family double. We had some pictures taken, a chat with some of the staff, and then a cup of coffee and packed up. The 2nd place rider came in about 10 minutes behind, so I convinced myself that I had about a 15 minute winning margin if had not got caught by the crossing.

My parents had come up to watch (as both I and my son were riding) so my mum saw us both "win" although my dad was not having one of his better days and was asleep in the car when we both got back.

We then went to a pub in Binton for a very nice lunch and then went home.

The weather was excellent - warm, sunny with just a slight breeze - I got a good top up for my cyclist tan. If the weather had been like the day before (very windy) or the day after (very wet) it would have been a very unpleasant ride.

For the ride statistics it was 55.8 miles duration. Ride time was 3:12:48, average speed was 17.4mph, maximum was 35.7mph. I was very pleased with the average as it was all solo with no drafting at any point.

The route was good, very well sign posted for both the cyclist to follow the route and plenty of warnings for other road users.

The Parkinson's Society even pulled their finger out this year and got an updated web page up the next day here.

And here's a photo of me and my son:


My mum took some photos so a selection of the most flattering are on the Pictures tab of the blog.

There was a goody bag - not a great deal of use I must say but the conversation piece was this:


 No one was exactly sure what it is. Any way as I don't like coconut in any form (and nor does anyone else in the family) it will remain a mystery.