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.