Queen is Having a Good Olympics

// August 5th, 2012 // News

The Queen of Great Britain and Northern Ireland has plenty of other titles, and is Head of State for 16 countries in all – Antigua and Barbuda, Australia, Bahamas, Barbados, Belize, Canada, Grenada, Jamaica, New Zealand, Papua New Guinea, St Kitts & Nevis, St Lucia, St Vincent & Grenadines, Soloman Islands and Tuvalu alongside the UK.

I threw together a little spreadsheet to show how her countries when bundled together compare to the two outright medal leaders, China and the US:

At the time of writing, she was ahead by 14 medals overall, but remained back at #3 in the Gold rankings (same as the UK on its own, though New Zealand is also putting in a credible performance and sporting minnows like Canada, Jamaica and Australia are doing their bit for the Crown).

For anyone curious, this is dynamically updated from raw data published by the Guardian using the Google Docs ImportRange command, which can include live updating chunks of any Google spreadsheet into another.

Share and Enjoy

  • Digg
  • TwitThis
  • LinkedIn
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Ping.fm
  • Slashdot
  • email
  • Print
  • PDF

2 Responses to “Queen is Having a Good Olympics”

  1. Jeremy says:

    Tom, can you please add Cambridge and Oxford to the table? Rules are (obviously) that Cantabs. or Oxford graduates winning medals add one for their respective teams, and PhDs don’t count :-) . I think currently Cambridge are about 24th in the table, just above Denmark. And one point above Oxford too, naturally. Heheheh.

  2. Tom Godber says:

    If only I had the time!

Leave a Reply