Sunday, June 19, 2011

Running: actual versus target



This is a chart showing how my actual mileage for the year has been progressing against a target of 2 miles per day. I started off aiming for 1000k for the year (1.7 miles per day), but I'm comfortable beating that so I've upgraded my goal.

I've been using dailymile to track my running and cycling.  To generate the chart I wrote a perl script to extract my data for this year, find the Running entries, and output a table of dates with cumulative mileages.

I'm currently manually copying the output in to a google docs spreadsheet. It'd be nice to automate the update of the spreadsheet too but I'll leave that for another day...

Friday, June 10, 2011

Cycling to Work 2011

Cycling to Work 2011 Chart

I've converted my local spreadsheet to Google Docs. The advantages are that I can:
  • "live" publish the latest version, by which I mean that when I update the data the image above is automatically updated
  • update it from any computer with web access, without installing any software
  • share the spreadsheet for others to copy or suggest improvements
  • do this for free

How am I doing so far?  Of 101 trips to the office, I cycled 83 of them - 82.2%

Of the 17 drives to work:
  • 1 was to try out (alright, show off) my new car
  • 4 were giving a lift to Jenny and her Italian exchange student friend
  • 1 was to take Jenny and her Italian exchange luggage to school
  • 1 was to take a tent and kit to work for Mark Halliday's stag weekend
  • 1 was to get in time to present at some education I helped create
  • 7 were due to inclement weather. On most of these I also gave Isobel a lift to school which is on the way to work.
Projecting out my current rate I'm looking at about 183 for the year.  Last year I totalled 130ish but I didn't start until the clocks changed.

I'm hoping that I can achieve more vacation than drives to work.  Bring it on!

Monday, March 28, 2011

The Rules

There is a great set of Rules from the "Keepers of the Cog": we maintain the sacred text wherein lie the simple truths of cycling etiquette known as The Rules.

There are some rules that my friends find particularly apt:

Rule 5: Harden The Fuck Up.

Since so many other rules refer to this one, we have to begin here. If someone just needs to "man the fuck up" then we tell that person to see Rule 5.

Rule 7: Tan lines should be cultivated and kept razor sharp.  Under no circumstances should one be rolling up their sleeves or shorts in an effort to somehow diminish one’s tan lines.  Sleeveless jerseys are under no circumstances to be employed.

Rich Harran is a good example of someone who is both very brown and very white.

Rule 9: If you are out riding in bad weather, it means you are a badass. Period.

John likes to think this one applies to him. Which compared to most of the rest of us, it does.

Rule 12: The minimum number of bikes one should own is three. The correct number is n+1, where n is the number of bikes currently owned. This equation may also be re-written as s-1, where s is the number of bikes owned that would result in separation from your partner.

Rule 16: Championship and race leader jerseys must only be worn if you’ve won the championship or led the race.

Rule 34: Mountain bike shoes and pedals have their place. On a mountain bike.


John has SPD pedals but his bike isn't technically a road bike.  But it also definitely isn't a mountain bike. Half fail.

Rule 42: A bike ride/race shall never be preceeded with a swim and/or followed by a run.

A rule written for Andy who is easily confused. Like when he put petrol in his diesel on the same day as doing the Blenheim triathlon.

Rule 55: If you are riding down a mountain, you must first have ridden up the mountain. It is forbidden to employ powered transportation simply for the cheap thrill of descending. The only exception to this is if you are doing intervals on Alpe d’Huez or the Plan de Corones and you park your car up top before doing 20 repeats of the climb.





Rule 56: When wearing a cycling kit and enjoying a pre or post ride coffee, it is only appropriate to drink espresso or macchiato. If the word soy/skim latte is heard to be used by a member wearing cycling apparel, then that person must be ceremonially beaten with Co2 canisters or mini pumps by others within the community.

Yeah, this one is mostly for me. Latte goodness is bad.  Also guilty: Mark Halliday (and not just once)

Rule 62: You shall not ride with earphones. Cycling is about getting outside and into the elements and you don’t need to be listening to Queen or Slayer in order to experience that. Immerse yourself in the rhythm and pain, not in whatever 80′s hair band you call “music”. See Rule 5 and ride your bike.

John used to fall fowl of this one but has since corrected his ways.




Rule 64: Cornering confidence generally increases with time and experience. This pattern continues until it falls sharply and suddenly.

This rule is totally owned by Andy Perry.  Sometimes he even has to abort the ride because of it.

Rule 75: Race numbers are for races. Remove it from your frame before the next training ride because no matter how cool you think it looks, it does not look cool. Unless you are in a race. In which case it looks cool.

Ed gave me grief when I forgot to take the timing chip off my helmet from the Wiggle New Forest sportive.

So 2 for Russell, 2 for Andy, 2 for John.  What about Alan and Ed?  Maybe they can have Rule 5 all to themselves?

Or perhaps we could invent some new rules:

Rule 86: Though shalt not get the train home (Alan)

Rule 87: Only teenage girls phone their mum for a lift home (Ed)

Have I missed anything?

Saturday, March 12, 2011

First fettle

Fettling is a British slang phrase which means "the art of repairing or tuning a bicycle". Until today the extent of my bike maintenance has been fixing punctures and changing tyres. I've never changed a chain before and when Rich's snapped on our Wales weekend ride last year I decided that I wanted to be able to change/fix my own chain.


Dirty Cassette and chain

Last Autumn the local bike shop (LBS) advised that I would need a new chain and cassette as mine were overly worn. I decided to defer replacing the parts and keep using the bike over the winter as I didn't want shiny new stuff exposed to grime, salt etc.  The LBS quoted about £35 for a Shimano 105 5600 cassette, £30 for a KMC X10 chain and £20 or so for fitting, and I'd be without my bike for a number of days.

I'm riding the Wiggle No Excuses sportive next weekend with Andy so I had to get this sorted out this weekend.

My bike previously had a KMC X10 chain and an Ultegra 6600 12-27 cassette. A month ago I looked in to the options and settled on a super-light KMC X10-SL chain (silver, not gold) for £32 and a Shimano 105 5700 cassette from Ribble for £31.  The chain is an upgrade, the cassette is one step down in the Shimano range but it is a newer version so it should be similar to what I'm used to.

To allow me to shorten the new chain to the correct length I bought a Topeak universal chain tool from the LBS. I got a 10% discount meaning that I paid £8.09 which is within 10p of the best price from Google Shopping.

I struggled for a while trying to remove the old chain via the special missing link and then gave up and used the new chain tool instead.

I laid the old and new chains alongside each other to work out that I needed to remove 7 links from the new chain. A missing link was included to easily join the ends.

There's a good video showing how to remove and fit a new cassette. It also mentioned that there might be an extra spacer needed which was lucky as I found I did indeed already have an extra spacer on my bike. Without the hint I would probably have removed all of the old parts and fitted only the new. Instead, I made sure I only removed bits that I was replacing - keeping the existing spacer.



A quick spin 'round the block suggests that everything's back where it's supposed to be. I didn't need to adjust anything with the gears.



I also got some quality SwissStop brake pads from Jim and Anna for Christmas. They are secured with a 2mm allen key which took me a while to find. Changing them was no trouble: remove the securing bolt, slide the pad out, slide in the new one, screw in the bolt, adjust the brake cable to accommodate the wider pads. For the first pad I used the new bolt supplied with the SwissStop pads but the head got damaged as I tightened it up so I reused the Shimano supplied bolt for the other 3 which were no bother.

Roll on next weekend.

Sunday, March 06, 2011

First Asda price guarantee analysis

This is the first stage in my quest to extract more value from the ASDA Price Guarantee...

I'll say up front that I think ASDA are overall cheaper for my shopping and that I appreciate what they're doing with this guarantee.

The ASDA Price Guarantee says "We'll guarantee your comparable grocery shopping is 10% cheaper at ASDA or we'll give you the difference".

They currently compare against Tesco, Morrisons, Sainsburys and Waitrose.  If ASDA are not 10% cheaper then they issue you a voucher for the difference which can be used against a future ASDA purchase.

It is important to note that it is the total value of the trolley/order that is compared, not each individual item.

This means that whenever Asda is cheaper, the "saving" is effectively offset against when it is not cheapest.

An example may help illustrate the point.  Consider an order with 2 items: Bread and Milk (you actually must have 8 different items in an order to qualify, but only one of them needs to have a comparable product at another store)

Bread... ASDA: £0.70, Tesco: £1.00

Milk.... ASDA: £1.10, Tesco: £1.00

The total cost of the Tesco order is £2.00 and Asda is £1.80. ASDA are 10% cheaper so no refund voucher is due.

But if the order could have been split in to 2 orders, the Bread order would have no refund but the Milk order would have resulted in a 20p voucher.

My shopping trolleys have so far resulted in either no refund or refunds of relatively small amounts like £1.50 on a £100 shop - certainly worth having but not 10%.

Looking at the comparison tables it is clear that if you could avoid mixing the good value items in with the poor value items then more savings could be made.

On our most recent shop we got 2 trolleys: one for what looked like good value items, one that looked like normal prices.  We did not do any formal research on prices before we started.  If we could have perfect knowledge of the prices then this would all be really easy, but in the Real World that info isn't very quick to obtain.

Update: I think this is new... mySupermarket now have a Quick Shop search which lets you see the prices for a single item. I successfully used it from my iPhone the other day when looking at lasagne sauce. They had Dolmio reduced from £1.66 to £1.00, or an own brand for £0.96   A quick search showed that Tesco were offering it on BOGOF at £1.76  So I bought 2 for £2.00 and the price guarantee shows that I could have got 2 for £1.76, so my voucher includes the 24p I overspent and an additional 10% of £1.76 = 18p. So I got 2 Dolmio sauces for £1.58 which is a good price.

2 Trolleys, 2 Vouchers

"bargains" trolley: 27p voucher from £43.55 - 0.62%
Normal trolley: £1.70 voucher on £75.09 - 2.26%


So far I've only been analysing the "bargains" trolley. The website shows you some info on the basket totals at each store and you can access another page per competing store table showing a table of the compared products.

"Bargain" Basket Totals

Tesco, 27 items, 19 unique, £22.99, £25.25, £2.26 cheaper
Sainsburys, 22 items, 16 unique, £17.34, £23.23, £5.89 cheaper
Morrisons, 19 items, 13 unique, £15.62 v £20.13, £4.51 cheaper
Waitrose, 8 items, 6 unique, £10.70, £13.42, £2.72 cheaper

ASDA were more than 10% cheaper for all but Tesco, where they were 9% cheaper. So the voucher covers the other 1%.

Cornish Icecream

But a quick look in the ASDA versus Tesco table shows that some items were much cheaper at Tesco. The very first line is:

1 x ASDA Easy Scoop Cornish Vanilla Ice Cream (2L)    £2.20    £0.99

I though £2.20 was a fairly good price for Cornish icecream but clearly it went in the wrong trolley.

Given that this trolley only resulted in a 27p vouchers, if I had put this item in the other trolley then this trolley would have resulted in no voucher but the other trolley's voucher would have increased by £2.20 - £0.99 = £1.21 i.e., overall I'd have been 94p better off.

Script

I've written a perl script that reads in 4 files in to which I have copied and pasted the comparison tables.

The script is still under development, but here's what it's found so far.

ASDA: (22 compared) cheapest = 16   most expensive = 7
Tesco (19 compared): cheapest = 4   most expensive = 5
Morrisons (13 compared): cheapest = 2   most expensive = 3
Sainsburys (16 compared): cheapest = 0   most expensive = 5
Waitrose (6 compared): cheapest = 0   most expensive = 2

So ASDA is by far most often the cheapest but it is also most often the most expensive.

Getting the items in the correct trolley could make quite a difference.

Other Notes

There are some "errors" in the tables, presumably caused by the mySupermarket website having an older record of the prices than what I actually paid.  For example, we got 8 medium Easter Eggs and they cost £1 each (no linked offers or anything like that). But on the website it says:

3 x Cadbury Creme Egg Medium (178g)    £4.00    £3.00

so this has wrongly resulted in £1.00 being contributed to my voucher.

Also, it was quite nice to have 2 trolleys as they were each lighter and weren't threatening to spill the contents out. It was much easier to repack the trolleys at the end when the items were bagged up.

What's next?

Analyse the "normal" trolley receipt
Work out what the voucher would have been if we'd used only one trolley
Work out various optimal trolley configurations for the shopping
Look in to sourcing the prices before going shopping

v1 script output

Kellogg's Corn Flakes (500g)
asda: 1.00
tesco: 1.98  -- most expensive --
morrisons: 1.98
sainsburys: 1.98
waitrose: 1.98

Cadbury Creme Egg Medium (178g) (3 of)
asda: 4.00
tesco: 3.00  ++ cheapest ++
waitrose: 5.00  -- most expensive --

ASDA Smartprice Sparkling Water (2L) (3 of)
asda: 0.48
tesco: 0.48
morrisons: 0.48
sainsburys: 0.48

Kellogg's Multi-Grain Start (375g)
asda: 1.00
tesco: 2.39  -- most expensive --
sainsburys: 2.39

ASDA Orange Crush Zero (2L)
asda: 0.72
tesco: 0.54  ++ cheapest ++
sainsburys: 0.64

Nestle Caramac Ice Cream Bars (4x50ml)
asda: 1.00
tesco: 1.00
sainsburys: 1.00

Batchelors Super Noodles Chinese Chow Mein Flavour... (5 of)
asda: 2.00
tesco: 2.00
morrisons: 3.45  -- most expensive --
sainsburys: 3.00

ASDA Easy Scoop Cornish Vanilla Ice Cream (2L)
asda: 2.20
tesco: 0.99  ++ cheapest ++
morrisons: 2.20
sainsburys: 1.20
waitrose: 1.30

Mars Skittles Rainbow Pack (4x45g)
asda: 1.00
tesco: 1.40  -- most expensive --
morrisons: 1.00

Kellogg's Honey Loops (375g)
asda: 1.00
tesco: 2.35  -- most expensive --
morrisons: 2.35
sainsburys: 2.35
waitrose: 1.80

Silver Spoon Treat Toffee Sauce (325g)
asda: 0.96
tesco: 0.75
morrisons: 0.49  ++ cheapest ++
sainsburys: 1.00  -- most expensive --

ASDA British Double Cream (600ml)
asda: 1.50
tesco: 1.50
morrisons: 1.84
sainsburys: 1.84
waitrose: 1.85  -- most expensive --

ASDA Smartprice Coco Rice (375g)
asda: 0.65
tesco: 0.65

Dr. Oetker Glimmer Hundreds & Thousands (86g)
asda: 1.00
morrisons: 1.29  -- most expensive --

Silver Spoon Dark Chocolate Chips (100g)
asda: 0.50
tesco: 0.50
sainsburys: 0.74  -- most expensive --

Dr. Oetker Giant Stars (13g)
asda: 1.00
morrisons: 1.29
sainsburys: 1.39  -- most expensive --

ASDA Rich Roast Coffee Granules (200g)
asda: 1.48
tesco: 1.48
morrisons: 1.48
sainsburys: 1.49  -- most expensive --

Nestle Rolo Milk Chocolate Egg with a Rolo Tube (1...
asda: 1.00
tesco: 1.00

Askeys Crackin Chocolate Topping (225g)
asda: 1.00
tesco: 0.75  ++ cheapest ++
sainsburys: 1.00

Silver Spoon White Chocolate Chips (100g)
asda: 0.50
tesco: 0.50
sainsburys: 0.74  -- most expensive --

Dr. Oetker Chocolate Hearts (45g)
asda: 1.00
morrisons: 1.29  -- most expensive --

Kellogg's Variety Pack (8x25g)
asda: 1.00
tesco: 1.99  -- most expensive --
morrisons: 0.99  ++ cheapest ++
sainsburys: 1.99
waitrose: 1.49

Sunday, February 13, 2011

Sportives 2011

This week's Cycling Weekly has a full list of cycling sportives.  The number of them, and the number of participants has grown massively over the last few years.

2008: 72 events, 14841 entrants
2009: 144 events, 29118 entrants
2010: 221 events, 47750 entrants
2011: 243 events

The following are the ones I am considering. See the doodle link to share which ones you fancy (or could be persuaded to do if lots of us are doing it - no commitment)

Sunday March 20, Wiggle No Excuses Sportive, 75-80 miles. (Entered, hotel booked)

Sunday April 13
a) Evans Ride It, Woking, GU24 8AZ, 60/90 miles, £11
b) Meon Valley Riser, Fareham, PO17 5BL, 50/88 miles, £21/23

Sunday May 1st, Isle of Wight Randonnee, free + £13 ferry from Soton, 65 miles on the island (99% likely to do this, with lots of others)

Sunday May 8th
a) Hampshire Hilly Hundred, Sparsholt/Winchester, 100 miles, £25
b) Wiggle Jurassic Beast, Bovington Tank museum, BH20 6JG, 101 miles, £25

Sunday May 22, Wiggle Bournemouth, Christchurch, BH23 6BL, 100 miles, £25

Sunday June 5, Wiggle Sussex Surrey Scramble, RH20 1DL, 91 miles, £25

Sunday June 12, Wiggle Magnificat, Newbury, RG14 7NZ, 127 miles, £27

Sunday June 19, Great Western Sportive, Swindon, SN3 1TA, 170km

Saturday June 25, Wiggle The Long One, Chichester, PO18 0EU, 129 miles, £25

Sunday July 3, Test Valley Tour, Romsey, 150km (did this last year, quite good)

Sunday July 10, Wiggle Mega Meon, Waterlooville, PO7 8AA, 95 miles, £25

Sunday July 24, Wiggle Wight Ferry, Brockenhurst, SO42 7ZE, 100 miles, £37

Sunday August 21, New Forest Rattler, Ringwood, BH24 3NF, 79 miles, £21

Sunday August 28, Blenheim Palace, OX20 1PP, 100 miles, £29

Sunday September 11,
a) Wessex 50/100, SP1 1JH, 100 miles, £19
b) Southern Sportive, Petersfield, GU31 4AS, 155km, £26

Sunday September 18, Southdowns challenge, Fareham, PO17 6EU, 80 miles, £23

Sunday October 2, Wiggle New Forest 100, Brockenhurst, 102 miles, £25. (did this last year, excellent)

Sunday October 23, Wiggle South Downs 100, Chichester, PO19 1SB, 102 miles, £25

Sunday November 6, Wiggle Devils Punch Bowl, Liphook, 75 miles, £25

Sunday, January 30, 2011

2,3,4,5

This year I'm tracking how often I commute by driving versus cycling.  After an exciting competitive start it's become a bit one-sided thanks to some adequate weather.


In the cold winter months I typically choose the shortest, hilliest route.  It's 4.6 miles and takes me 16-19 minutes. In the summer, when it's daylight, dry and I'm fitter, I can do it in under 14 minutes.

Whilst it can be pretty cold on some days it's still far more enjoyable than driving.

In case you hadn't guessed 2,3,4,5 refers to the number of days cycled each week for the first 4 weeks this year.

Thursday, December 02, 2010

Running fitness, as measured by heart rate



Having had a couple of months with no running (but lots of cycle commuting) due to injury, I've started to get back running.

On Monday I went for a 5.6 mile run with Andy Perry and it felt like hard work.  My average heart rate was 169 bpm.

I looked back through my previous runs which I store in SportTracks to see how that compares.

1) Similar heart rate

21 July, 5.1 miles @ 7:16 min/mile with heart rate 172 bpm
11 Aug 2010, 6.36 miles @ 7:31min/mile with heart rate 168 bpm

2) Similar pace

5 Aug 2010: 5.1 miles @ 7:54 min/mile with heart rate 160 bpm
17 Aug 2009, 6.26 miles @ 7:59 min/mile with heart rate 148 bpm

These results show they I'm less running-fit now than in the summer, and much less than I was last year.

Compared to 17 Aug 2009, I'm having to work at 21 bpm more to go a touch slower over a shorter distance.  Grrr!

It's not all bad though:

* I did a fairly good parkrun this year though - I came 20th out of 159, and I'm still top of the Hursley Park Runners team.

* Until August when I got injured I had been (very slightly) over-achieving my yearly goal of averaging over 2 miles/day

* Andy and I did the Farley Mount loop in August: 10.35 hilly miles at 8:24 min/mile pace and it was very comfortable

* I enjoyed putting together a view of all the routes I've covered running from Hursley (and we've since run a couple more roads too)

Thursday, September 02, 2010

Andy crashed his bike, again.

Nice 25 mile cycle ride this lunchtime, although it wasn't so good for Andy Perry who crashed on some loose gravel near Ampfield.

He also crashed immediately after restarting when he was in too big a gear, didn't engage his cleats quickly enough and fell off sideways.

He still managed the rest of the ride, averaging 16.1mph, but he has some sore body parts now.

Andy's injuries 3

Andy's injuries 2

Andy's injuries 1

Wednesday, September 01, 2010

Selling my iPhone

Having aquired an iPhone 4 (yes, it's awesome and no, it hasn't dropped any calls), I wanted to sell my iPhone 3G 16GB.   It was in pretty good condition, having been covered by an InvisibleShield most of the time.

Starting with the MoneySavingExpert article I looked at the various options listed at MobileValuer to see what I could get.

Based on the terms and conditions and the feedback I read Envirofone seemed the best bet.  I chose £158 cash instead of Argos vouchers.  Today, Envirofone is listed as offering the second highest amount of the 10 options. I don't think they were that high when I made my decision.

2010/08/05, ordered
2010/08/08, received an email saying that I had qualified for Collect+. This saved me the postage fee.
2010/08/09, sent using Collect+ at a local petrol station
2010/08/12, received email saying "We have now tested the mobile phone you sent to Envirofone and are delighted to let you know that it has passed successfully, meeting all our terms and conditions."
2010/07/17, full quoted payment received via BACS transfer

Friday, August 13, 2010

Andy's cycle commute



On Wednesday evening I cycled with Andy Perry to his place near Fleet.

We took the southerly route, which is longer and more hilly, and saved a little treat for the end when we tackled the steep hill to Ewshot and sped down the other side at 42mph.

After an evening watching the England-Hungary match with beers, chips, pizza and cornish ice-cream we had an early night and got up at 6:00, had a quick breakfast and set off at 6:29.

For the return leg we took a shorter (37.5 versus 42.5 miles) much flatter route - about half the amount of climbing.  We averaged 16.1mph over 2:18 moving time (2:30 elapsed).

We made it in to work at 8:59 but strangely Andy didn't fancy doing a 10k run at lunchtime.

Wednesday, July 14, 2010

iPhone 4 versus Samsung Galaxy S photos

Statistically irrelevant no doubt, but even so, here are some photos taken within 30 seconds of each other of approximately the same scenes.

Round 1 - inside, quite close up


Top is Samsung, bottom is iPhone 4.  I know which I think is better.  The original images are available to examine by clicking on the images below.



Round 2 - Outside


We examined these photos "blind" (ie, we didn't know which image was taken by which phone).  We mis-identfied which image was which. Overall, they're pretty similar but the windscreen of the silver car, 3rd back on the left, is better in the Samsung photo. 









Sunday, June 20, 2010

Cycling to Wales


Last weekend we cycled to the Brecon Beacons and back. "We", is Mark Halliday, Ian Vanstone, Rich Harran and I. Over 3 days we cycled over 300 miles and climbed over 3250 metres.


Day One


(route) We set off from work at 12:20 on Friday, the early light rain having thankfully cleared away. Mile one was downhill and flat but then we had our first mini-climb of 80 metres up to Farley Mount. This is one of the hardest hills near work but it would pale in to insignificance by the end of Saturday.

We followed the Garmin Edge 705 Sat Navs directions to Stockbridge, taking a route I hadn't done before. We set our top speed of the day of 39mph down the B3049 in to town.

Between us we had 3 Garmin Edge's. I think this is because they're so hard to follow that you need significant redundancy. And like the Space Shuttle's control system, when one system disagrees with the other two, you can follow the directions of the two that agree.

By 1:40 we were skirting Andover heading generally north. This began the longest, ever-steepening climb of the day, from 119m to 277m in 5.1 miles. Not very tough but 25 minutes of uphill. Followed by a lovely 102m descent in just 1.1 miles. And straight in to another 76m climb. And a 95m descent. Quite good fun really.

Then we zig-zagged around loosely following a river west for about 21 miles. Rich picked up a puncture which took about 20 minutes to repair - our only mechanical issue for the day. Between Alton Barnes and Stanton St Bernard we saw a chalk horse on a hill. The landscape around this area is striking. Rich commented that it was lunar: wide plains and distant bumpy hills. Really pretty.

At Bishops Cannings we turned north and climbed a short(ish) steep(ish) hill (58m in 1.3 miles) and gently swung west to cross the M4 north of Chippenham.

We cycled through a beautiful village made of stone called Grittleton. Check it out on StreetView, although I remember the place being far prettier than the linked imagery suggests.

We reached Luckington, our destination, at 6:30. We were very generously being put up for the night by Kirsty, a friend of Mark and Ian.  After a quick shower we went to the local pub, the Old Royal Ship.  The World Cup started today and France were playing Uruguay.  There was a big screen in the pub but we sat outside in the evening sunshine. Turns out we missed a poor 0-0 draw anyway.  After a lovely meal and a few beers with Kirsty and John (her man) we headed back for a relatively early night.

Day Two


(route) This is the one I'd been fearing. But it started well with a top quality cooked breakfast (thanks Kirsty).  We were rolling before 8:30.

The first task was to get to the M48 bridge to Wales (the M4 bridge doesn't cater for bicycles). The first hour of the day was mostly flat and we averaged 16.5mph. For one 2 mile section we averaged 22mph (although we did drop 53 metres).

Ian had been looking forward to crossing the bridge and I can see why. You're quite high up and the views are fantastic. Looking down in to the water you can see swirling currents moving in all directions.

Once in Wales the sun came out and we headed north past Chepstow and turned west and up a hill on the main road. First gear was employed but it was fine. My bike has a "double" not a "compact" crankset. This means that my easiest gear is significantly harder to turn than a compact - which the other 3 cyclists had. My easiest gear is 39x27.

At the top of the hill we came off the main road and descended a tiny single track road. Then we were introduced to our first real hill. For the next 0.65 miles, the road *averaged* 11%. Blissford Hill in the New Forest is 25% but that was nothing to this. We ascended 112 metres in 1040 metres. Sitting down for this climb was not an option. It felt like I had to stamp on one pedal while lifting up on the other just to turn the wheels. Our speed dropped to about 3mph. There was a lot of heavy breathing. At one point everyone but Rich dismounted because it was crazy steep (28% according to GPS) and the road was covered in small pine cones that made it slippery. At the top we caught our breath, admired the view back down over the estuary and scoffed chocolate. This was the first time I've had to dismount due to gradient. But it wouldn't be the last...

Coming down the hill on the other side was quite hard work as the road was small and twisty so we had to use the brakes all the way down. 234m elevation down to 46m and apart from lovely views, no benefit. Grr.

Ian started to make noises about his gears not feeling right but we headed down in to Usk for a bite to eat before he took a proper look. I emerged from the One Stop with a tonne of sarnies and wraps to hear Ian say that his chain was bust. It hadn't snapped (wait for tomorrow) but one of the links had split and looked very weak. Mark had brought spare chain pins so Ian took out a couple of links from his chain and got it all fixed. A quick lunch ended up taking 50 minutes but at least it was sunny and the rest of us enjoyed a leisurely lunch.

Shortly after 12:00 (38 miles) we saddled up again and followed the river to Abergavenny. En route Rich picked up another puncture which was fixed without any drama. We went through the middle of the town. It looks like a nice place, nestling among some big hills. Worth visiting some time.

We took the flat Brecon Road out of town for 7 miles, which concluded an easy 20 mile flat section. We turned right on the A479 which had recently been resurfaced and was lovely and smooth. With the strong sun and recent tarmac I feared it might be soft and sticky but it was perfect. We climbed up the A479 for the next 7.4 miles, gaining 240 metres. Long, but not too bad.

From the top we loved the descent to Talgarth on the new road surface. 189 vertical metres dropped over 3.2 miles in 8 minutes at an average of 24mph. Sweet!

Along a country lane Rich and I saw a large predatory bird take off and fly just over our heads with a decent sized black bird gripped in its claws. Nature in action!

The big climb of the day was just around the corner. We approached it by coming up a steep hill, then the road kinked steeply upwards, looking quite a lot like a vertical wall of concrete. You can't see the gradient very well on StreetView, but if you look at the fence posts on this image you can kind of see it. The GPS trace suggests the peak gradient was around 35%. I had to dismount, again. For the first uber-steep hill of the day I had walked up it in my cleated cycling shoes which isn't very easy because the cleats exacerbate the angle at your ankle, but this one was so long I took off my shoes and walked sock-footed until the gradient eased off to something more sensible like 15%.

For 5.6 miles we rode up a narrow road taking in some amazing scenery.  We climbed from 385 metres up to a peak of 530 metres.  Whilst tough, this part of the ride was what we came for and it didn't disappoint.

For the next 12 miles and 40 minutes (!) we dropped down the valley from 530m to 113m. And then ground up another 110 metre climb, what looked, from the graph, like the last real ascent of the day...

But wasn't. Just after we crossed the A40 the road went straight up a ridge, gaining 80 metres and peaking at  21% gradient. This one was tough but was conquered.

All we had left was the road to our destination which the others had done before and said it was a bit steep. We'd had a nice 106 mile warm up and only faced another 75 metre, 0.5 mile climb. With a gradient tightening to 20% for the last 200 metres. I gave it a big push, resolved to make it, but had to dismount just 40 yards from the end as I wasn't getting enough oxygen and my lungs were about to fall out.

We finally reached Ian's Aunt and Uncle's place at about 6 o'clock, having cycled 107 miles in 9:33 and climbed 1475 metres.

After a quick bath we sat outside on a picnic table for tea (thanks Joy) with awesome views over the valley. What an amazing place to live. We heard lots of interesting stories about the trouble the heavy snow caused earlier in the year. Pudding was excellent too - home grown rhubarb made in to a delicious fool. Truly scrumptious.

Then we watched the England game with a couple of beers and some smoky bacon crisps (of which they had a surfeit) before giving up and (again) having a relatively early night.

Day Three


(route) Everyone slept like kings although I did head to the loo in the middle of the night and forgot that there was a couple of steps out of the bedroom to the landing and took a tumble. I received a whack on the knee which could have been disastrous but wasn't. It felt a little bruised and tender the next morning but it didn't affect my cycling.

We were up for breakfast for about 8 o'clock. After lots of cereal and toast we were ready and set off at 8:50. It was a bit awkward getting started as our route continued up the steep hill we finished on last night but we managed it without incident.

We took a fairly main route back to the M48 bridge. The best bit was heading out of Devauden down a billiard table smooth road averaging 28mph on a 3 mile section that dropped 160 metres. Top speed was a touch over 40mph.

Over the bridge, over the M4, heading for Bath. I was hoping to avoid the worst of the hills:- I recently went to Bath and parked in the Park 'n' Ride at Lansdown near the race course and the hills round there were big! It turns out Mark had routed us that way as there isn't much choice if you're avoiding main roads. We climbed from 103m to 285m on a hot day having cycled nearly 200 miles over the previous 2 days. It was quite tough but we just took it slowly and ground it out. Some nice views though.

We turned left off the main road before the PnR and took some narrow lanes to the east edge of Bath, heading through Bathford and near Bathampton (imaginative names they have in these parts).

Mark had been warning us about a steep climb for a while and it arrived on Warleigh Lane outside Claverton.  It's about a 75 metre ascent over 1/3 of a mile. Mark walked part of it because he still has achilles and knee issues from his London-Edinburgh-London ride last year, and Ian walked part of it as he dare not stand on the pedals given the state of his chain. Rich and I both made it to the top without stopping which was satisfying given the 3 hills I'd walked yesterday.

Then we rolled down the hill in to Bradford-on-Avon. I hadn't heard of the place but it looks really cute. We were looking for lunch and we got directions to the local Sainsburys. We passed a bicycle shop and then literally 50 metres later Rich's chain appeared to explode. We later found out that the front dérailleur had slipped down the seat post and got caught in the chain, ripping it off. Rich found one half his chain but not the other half which had disappeared. I'm amazed at the luck of having a bike shop 50 metres away and that we wanted to stop for lunch anyway. Rich bought a new chain whilst the rest of us went to get food from Sainsburys.

We had lunch by the canal as Rich fixed his bike. Mark and Ian managed to mistake 2-litre bottles of water for 1-litre bottles so we had twice as much as we needed. A couple of bottles were gifted to a random passer-by.

We still weren't half way home so we got going once Rich had fixed his bike and had some food. We'd conquered all the nasty hills but we still had 60 miles to go. We went through Warminster and then followed the river for 22 miles to Salisbury. Somewhere in this segment we spotted another white horse. I haven't managed to find it on StreetView yet though.

As we got in to Salisbury there was a point where the road narrowed to a single lane. A BMW driver (what else?) saw 4 cyclists about to enter the single lane section and gunned it. We had to stop in a hurry and he flew past. He either didn't see or didn't care about the stop sign after the narrow bit as it emerged on to the main road, but on another day this could have ended in a nasty car crash. Idiot.

It's odd to think of Salisbury as "nearly home" but it felt like it. Less than 25 miles and I'd be home (although Ian and Rich had slightly further, and Mark 5 miles less than me). There's a bit of a hill out of Salisbury in to Aldebury, parallel to the A36, but tiddlers like this no longer bothered me.

Then it was over the A36 to the lovely flat terrain of the Deans, Lockerly, Kimbridge and home.

112 miles for the final day, 9:38 hours, 1050 metres of climbing.  (The elevation graph above is from Mark's GPS and doesn't show the full distance).


Summary Statistics

81.6 miles, 107.3 miles, 111.7 miles = 300.6 miles (plus a 5 mile commute to work for me).
750m, 1475m, 1050m = 3250 metres of climbing.  Highest point at 530m in the Brecon Beacons.
6:10, 9:34, 9:38 = 25:22 (including stops)
2 punctures, 1 new chain, 1 chain repaired.

Everyone was pretty tired by the end. I was developing saddle sores on the third day but otherwise was in remarkably good shape. I chose not to cycle to work on Monday and on Tuesday I do the school run. I cycled Wed, Thurs and Friday though. Rich cycled every day the following week.

Over the 3 days, as well as big meals, I had:
  • 5 KitKat Chunky
  • 4 Snickers
  • 2 bags of Haribo Super Mix
  • 2 bottle of Lucozade
  • 2 Alpen-like bars

Mark had planned the route using BikeRouteToaster.com which is a great tool. It can reroute by dragging like google maps does, it shows elevation, it has lots of import/export options, and it can show maps from and route over OpenStreetMap. Superb.

Rich and I took rucksacks but Mark and Ian packed everything in to their jersey pockets and various saddle bags. I used sun cream but still ended up with sharply defined lines on my upper arms between pinky-brown and white.

Rich's pattern of one mechanical failure per day also continued on into Monday when his gear cable snapped on the way in to work.

Overall: a lot of fun, met some people, ate tonnes, saw many pretty views and villages, was defeated by and conquered some big hills, did back-to-back long days. Thoroughly enjoyed.

Thursday, June 10, 2010

Cycling weekend, before we go


Heading off tomorrow, Mark Halliday, Rich Harran, Ian Vanstone and I are cycling to Wales to tackle some hills, returning on Sunday.  The elevation profile above is for the second day.

This will be my first set of back-to-back long rides whereas the others have done Lands End to John O'Groats before.

Day 1 leaves work at midday and heads off to somewhere north of Bath.  It has the most short sharp ups and downs and covers 82 miles.  Forecast seems to be rain in morning and clearing later.  We should arrive at 7:00 where we can clean up and have a pub lunch.

Day 2 is hilliest and 105 miles long. Basically getting to the bottom of the valleys in 35 miles, then heading gradually up them, climbing up and out of the end, along, then back up into the top of the next one (miles 72 to 77 climb 400m)  before heading south and down it (miles 78 to 90 look sweet!).   Heading off at 8ish, or earlier if possible, we should  arrive at Ian's aunts by 5 to socialise before watching England v USA at 19:30.

Day 3 is longest and goes near Bath, which is pretty hilly.  It has a great run back along the river valley, the last 40 miles being on the whole downhill.  We plan to leave at 9:00, getting back for 6:30 or so.

I'm a bit nervous but massively looking forward to it.

Wednesday, June 09, 2010

iPhone usage analysis

I'm going to be replacing my iPhone 3G with an iPhone 4 shortly.  I got my current phone on an 18 month £30 contract - the cheapest available at launch.  I calculated that a PAYG option would have been cheaper for me but O2 didn't launch it until a few months had elapsed.

Given my usage pattern over the last 2 years, would I still better off with PAYG?

If O2 make it easy to see historic usage graphs then I couldn't find it.  After some laborious copying in to a spreadsheet I ended up with:

Talk minutes: average 23, min 9, max 51
Texts: average 40, min 22, max 78
Data in MB: average 165, min 107, max 292

This usage pattern was achieved whilst on a contract: for the first 18 months it included 75 minutes and 125 texts, and currently includes 600 minutes and 1200 texts (£20/month).  I used the phone fairly frivolously because I was always well within my allowance.


What about data?  O2 used to be "unlimited" but now has a 500MB limit, after which they reduce the speed.  This is according to the O2 rep responding to comments in the O2 blog where they announced the 500MB cap.

"If you go over your data limit and don't buy a Bolt On then your data speed will gradually slow down. You won't be charged further.


So it looks like a 500MB "limit" is fine for me.  I've only exceeded 200MB twice in two years.

iPhone revisions seem to be an annual occurrence so an 18 month contract seems odd.  Choosing 12 or 24 months is probably wiser, depending on whether you really need to have the latest handset or if you can survive the second year with a superceded model.

I currently get my broadband with O2 and I get a £5/month discount for also having a mobile with them.  The rest of the family are on Vodafone so if I switched mobile providers I'd lose the discount.  I've been content with O2's coverage although I think Vodafone would be better.  So unless Vodafone have a significantly cheaper option for the iPhone I'll be sticking with O2.

I've used over 90% of the storage on my 16GB 3G.  The current selling prices for the 16GB and 32GB 3GS are £237 and £282 respectively.  So whilst there is a £100 premium for the bigger version you should recover about £45 of that if you sell it after 2 years.  Given photos at 2.5 times the resolution of my 3G, and HD video recording, it seems prudent to make sure I've got sufficient storage so I'm only looking at the 32GB version. 

The low use and cost options that look like candidates are:

1) £30/month for 18 months.  £323 for 16GB version.   100 mins, unlimited texts

Over 2 years: £323 + £30*18 + £10*6 = £923

2) £25/month for 24 months. £249 for 16GB  version. 100 mins, unlimited texts

Over 2 years: £323 + £25*24  = £923

3) PAYG.  £599 from Apple (O2 aren't doing PAYG until they stop being able to fill their orders with contract customers).


O2 PAYG: When you top up with £10, you get 500MB and 300 texts to use within the next month.  So if you spend less than £10 on calls each month they you will be carrying over some credit each month.  Calls cost 25p a min for the first 3 minutes a day then 5p a minute for the rest of the day.

I used an average of 23 minutes when I was on contract - I'll use a bit less than that on PAYG, say 20 minutes.

20 mins * 25p/min = £5.00 on calling costs.

So each month I top up I'll end up with an extra £5 of credit.  At some point I will stop topping up and will instead spend PAYG credit on the Web Bolt On which costs £7.50 for a month of data plus texts at 10p and minutes at 25p/min.  Once my balance drops too close to zero I'll revert to £10 top ups again.

So the pattern may look something like this:


Month 1: £10 topup, data and 300 texts included, £5 spent on calls, balance £5
Month 2: £10 topup, data and 300 texts included, £5 spent on calls, balance £10
Month 3: £10 topup, data and 300 texts included, £5 spent on calls, balance £15
Month 4: £10 topup, data and 300 texts included, £5 spent on calls, balance £20
Month 5: no topup, spend £7.50 on Web Bolt On, £3 on 30 texts, £5 on calls, balance £2.



So 5 months costs £38.  24 months is about £190.

Total cost for 2 years of iPhone 4 32GB = £599 + £190 = £789.  Or £1.08 per day.

And if you can sell your iPhone after 2 years for £200, it's only £589 for 2 years = 80p per day.  Which is cheaper than a small coffee or bottle of coke.

Just for interest, if you used your iPhone like an iPad and could live with no phone calls nor texts (you will actually have 300 texts/month for 3 in 7 months):


Month 1: fund £10, balance £10
Month 2: buy Web Bolt On for £7.50, balance £2.50

you end up spending about £110 for 24 months (ending up with some credit).

My iPhone 4 is now ordered.  O2 have sent me a micro SIM and scheduled a switch over date to PAYG.  Can't wait.