World Championships 2011 Bangkok

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

metal-table-legs-chrome.jpg


har har

I am so sorry
 
Julian said:
? :(
Click to expand...

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.
 
cmhardw said:
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.
Click to expand...
I understand. He does lead beginners down some wrong paths, though.
 
kinch2002 said:
Can someone construct a medal table? (I don't want to do it manually). I'd be interested in seeing it :)
Click to expand...

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
Click to expand...

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
 
mrCage said:
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
Click to expand...

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
Click to expand...
 
Last edited:
EeeeeWarne said:
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!
Click to expand...

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...
 
mrCage said:
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
Click to expand...

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.
 
Dene said:
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.
Click to expand...

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.
 
You must log in or register to reply here.

Similar threads

D-Faze
[Video] World Rubik's Cube Championship 2011
2 3 4
Replies
68
Views
12,678
D-Faze
D-Faze
W
[Official] [Podium winners 3x3] World Championship 2011
2 3
Replies
58
Views
14,256
Brest
B
Carrot
World Championships 2011 - Predictions!
5 6 7
Replies
138
Views
23,979
Carrot
Carrot
R
World Rubik's Cube Championship 2011 on October 14-16, 2011 in Bangkok, Thailand
3 4 5
Replies
88
Views
17,075
Zane_C
Z
B
Speedcubing World Championships 2011 Date and Location
9 10 11
Replies
215
Views
38,705
Dene
Dene
Back
Top