Out-geeked!

Ok, so as cool as I thought my Olympic Medal scoring system is, I was out-geeked by my buddy the spreadsheet guru.

So my original idea weights medals to make it worth winning Gold.
His system goes a step further (several steps actually).

First, he takes the original, mildly useful original TV sports system which just adds medals equally and then calculates each country's medal count as a percentage of total medals. Cool. Now the useless system becomes more useful.
He then applied the same idea to my weighted system. Giving a percentage of weighted medal points of total medal points for the games. Now that's cool.

Finally he adds a hybrid score which averages my weighted system scores with the unweighted scores. Whew.

Anyway, I like his idea. Though in my opinion, if you want to talk bragging rights for your country, then I like column L of his spreadsheet. This is the percent of total weighted points. Basically his idea and mine combined, ignoring the original TV sports unweighted scores.

Below is a pic of his Excel spreadsheet that I (of course) imported into OpenOffice and prettied up a bit for web use.

Now, as long as we are taking this scoring thing too far, how about we also weight the scores relative to population of each country? After all, how hard is it to find 30 medal winners from a pool of 300 million as opposed to a pool of say 5 million?
(note: I noticed this 300 million pool didn't stop the US from importing a Canadian Ringer with a special act of congress for their ice dancing medal ;')

Don't forget you can click on any of these pics for the full size, readable original.


The Scooter method applied to the old and Tachyon systems. Note I prefer column L over F or N.