Cambridge Town Bumps 2013

This time last year I rowed in the town bumps for the first time with Xpress Boat Club as a novice 'oarsman'.  It was exciting and nerve-racking in equal measure, generally exhausting, but above all a lot of fun.  I also created my own interactive version of the bumps charts using Tableau, which you can read all about here.

This years bumps has now finished and so it's time to publish this years chart. Not many changes from last year's attempt, but I have added a Summary sheet to record blades, spoons, headships etc.  I'll also try and get the bump location info from the main CRA bumps website.  In the meantime, here it is:

Learn About Tableau

If you see any errors please let me know.

I'm also thinking about building an historical bumps interactive tracking the rise and fall of crews and clubs over the years.  Unfortunately most of the historical bumps charts on the CRA site are static images and manually coping in years of results would drive me bonkers, so if anyone knows where I might be able to find or get access to the data in a machine readable format (csv, json, html, xml, etc etc...) then let me know.

ATP Tour

Wimbledon has just finished and the latest ATP rankings were released on Monday. I'm a big fan of interactive bumps charts and so thought I'd take a look at how the ATP Tour top 100 ranks and points have changed over the years.  Here's a snapshot of the final result (still not convinced by the colours) and clicking on it will take you to the full interactive:

I scraped the data from the ATP Tour website with a python script and created an excel sheet formatted like this:

I didn't use the 'Week Change' or 'Tourn Played' columns in the end, but I did use the player names on their own to create bespoke filters for the chart.  Clicking on a player in either of the names lists will highlight their history in the rank and points charts.  Here's Andy Murray's rise to the top:

Clicking on a line in either of the charts will also highlight the selected player.

Go and explore.  :o)