Commuting in the rain?

Culture

Commuting in the rain?

by Andy Cotgreave

Flags

Three years ago I had a debate with someone about why they didn’t cycle to work in Oxford. “Because it’s too wet,” was their main excuse. Being a keen cyclist, I knew that it didn’t really rain that much, and even on days it rained, it was rarely at the time one commutes to work. The other person didn’t believe me: I needed evidence. I setup a Google spreadsheet and a form, and have been recording whether it rains when I commute to work every since. I now have 3 years of data, and as of today, 20 May 2011, I am in the midst of the longest ever dry spell: 82 consecutive commutes without rain. It has not rained on a commute since 28 February 2011. Below are two displays. The first shows the dry spells:

The second viz shows the summary. Headline figure: 9% of commutes are wet. That’s good odds in my book:

Many thanks to Richard Leeke of Equinox who worked out how to do the calculated fields that work out the running sum of consecutive dry commutes.

More About the Author

Andy Cotgreave

Croydon Cyclone 2011 This weekend saw the Croydon Cyclone disc golf tournament. It was the biggest UK tour event for a long time, and the Croydon club ...
Panel Charts in Tableau Over on the forum, Jeremy asked about making trellis charts. For more info on trellis/panel charts, John Peltier has a great article ...

See more from this author →

Subscribe to our newsletter