World Championships 2011 Bangkok

Can someone construct a medal table? (I don't want to do it manually). I'd be interested in seeing it :)

metal-table-legs-chrome.jpg


har har

I am so sorry
 

Dan Brown's tutorial is, in my opinion, a very effective method of introducing a non-cuber to cubing. The video is entertaining, the method is scalable to a speedsolve method, and it even explains the concept of the order of an algorithm (if only lightly).

So yes, I absolutely recommend Dan Brown's video for non-cubers who would like to learn how to solve for the very first time.
 
Dan Brown's tutorial is, in my opinion, a very effective method of introducing a non-cuber to cubing. The video is entertaining, the method is scalable to a speedsolve method, and it even explains the concept of the order of an algorithm (if only lightly).

So yes, I absolutely recommend Dan Brown's video for non-cubers who would like to learn how to solve for the very first time.
I understand. He does lead beginners down some wrong paths, though.
 
Can someone construct a medal table? (I don't want to do it manually). I'd be interested in seeing it :)

Did it manually (with some help from excel for sorting), so it's not too fancy.

By medal color:

Gold
Australia: 5
Hungary: 4
USA: 2
Denmark: 1
France: 1
Germany: 1
Indonesia: 1
Japan: 1
Poland: 1
Sweden: 1
United Kingdom: 1

Silver

USA: 5
Japan: 2
Australia: 1
China: 1
Denmark: 1
Germany: 1
Hungary: 1
Indonesia: 1
Italy: 1
Netherlands: 1
Poland: 1
Spain: 1
Thailand: 1
United Kingdom: 1

Bronze
Hungary: 4
Japan: 4
Australia: 3
Indonesia: 2
United Kingdom: 2
Denmark: 1
Netherlands: 1
Sweden: 1
Thailand: 1

By Country:

Australia: 5 gold ; 1 silver; 3 bronze

China: 1 silver

Denmark: 1 gold; 1 silver; 1 bronze

France: 1 gold

Germany: 1 gold; 1 silver

Hungary: 4 gold; 1 silver; 4 bronze

Indonesia: 1 gold; 1 silver; 2 bronze

Japan: 1 gold; 2 silver; 4 bronze

Netherlands: 1 silver; 1 bronze

Poland: 1 gold; 1 silver

Spain: 1 silver

Sweden: 1 gold; 1 bronze

Thailand: 1 silver; 1 bronze

United Kingdom: 1 gold; 1 silver; 2 bronze

USA: 2 gold; 5 silver
 
Thanks Chris :)

Here's the medal table in a more traditional format of sorted by golds, then silvers etc...
I made one small edit: Hungary have a bronze changed to silver because FM had a =2nd place.

2lu9h1d.jpg
 
Last edited:
SELECT countryId, sum( if( pos =1, 1, 0 ) ) gold, sum( if( pos =2, 1, 0 ) ) silver, sum( if( pos =3, 1, 0 ) ) bronze
FROM Results
WHERE competitionId = 'WC2011'
AND best >0 and (roundId='f' or roundId='c')
GROUP BY countryId
ORDER BY gold, silver, bronze

gives:
countryId gold silver bronze
Australia 5 1 3
Hungary 4 2 3
USA 2 5 0
Japan 1 2 4
Indonesia 1 1 2
United Kingdom 1 1 2
Denmark 1 1 1
Poland 1 1 0
Germany 1 1 0
Sweden 1 0 1
France 1 0 0
Thailand 0 1 1
Netherlands 0 1 1
Italy 0 1 0
China 0 1 0
Spain 0 1 0
 
It's a little bit odd that China having so many cubers these days did not fare better in the WC. And how about scoring total points for each nation? Like Gold=6 pts, silver=5pts etc. (6th place=1pt) Just like they do in the olympics and so on. Would be interesting to see :)

Per
 
It's a little bit odd that China having so many cubers these days did not fare better in the WC. And how about scoring total points for each nation? Like Gold=6 pts, silver=5pts etc. (6th place=1pt) Just like they do in the olympics and so on. Would be interesting to see :)

Per

The People's Republic doesn't allow its citizens to travel very freely.
 
Then let next WC be held in Shanghai :) Australia would also be a nice place. Not that i have any plans of going :-o

Per
 
SELECT countryId, sum( if( pos =1, 6, if( pos =2, 5, if (pos=3,4, if( pos =4, 3, if( pos =5, 2, if( pos =6, 1, 0 ) ) ) ) ) ) ) total
FROM Results
WHERE competitionId = 'WC2011'
AND best >0
AND (
roundId = 'f'
OR roundId = 'c'
)
GROUP BY countryId
ORDER BY total DESC

Hungary 65
Japan 53
Australia 51
USA 41
Indonesia 29
Thailand 24
Denmark 20
United Kingdom 19
Netherlands 15
Poland 14
Germany 14
Sweden 13
France 9
Italy 9
Korea 7
China 5
Spain 5
Taiwan 3
Slovenia 3
Austria 2
Romania 0
Belgium 0
Philippines 0
Switzerland 0
Canada 0
Malaysia 0
Ukraine 0
Vietnam 0
Russia 0
New Zealand 0
 
Last edited:
So...I was bored. I also wanted to find out how various nations did at the World Championships. I decided to find out the hard way...by getting the results myself. It has been done like the WCA statistics where they add up all the single and average rankings of a person, however, with this, it is the highest average ranking of a country.




Next to the nations are the amount of competitors from that nation and red means that that country did not have anyone competing in that event, so I gave them last place +1 (even in BLD events where the person who came last had DNF's, they still qualified for the event, so the nation that did not qualify should go behind them).

Enjoy!

I did this a while ago. Maybe it would be useful now that people are talking about medal tables...because this goes further than that...
 
Then let next WC be held in Shanghai :) Australia would also be a nice place. Not that i have any plans of going :-o

Per

Yea there would be huge visa problems with China, so I would really not recommend having the competition there.

Australia, we could certainly manage it, but it would be very expensive and would require people to travel very far. Every major city in Australia is amongst the most expensive cities in the world.
 
Yea there would be huge visa problems with China, so I would really not recommend having the competition there.

Australia, we could certainly manage it, but it would be very expensive and would require people to travel very far. Every major city in Australia is amongst the most expensive cities in the world.

I know this isn't the most *educated* post ever, but... maybe it would be worth having it in Australia. Even with travel fares and costs.
 
Back
Top