Odd WCA stats/ Stats request Thread

[Stefan]

You must be bulimic.

 

[vcuber13]

some canadian rankings
https://docs.google.com/spreadsheet/ccc?key=0Ak-T4fS-gRDLdDduT2hVcTBhNUcxY2E3cmRXeU1Ga0E

 

[antoineccantin]

some canadian rankings
https://docs.google.com/spreadsheet/ccc?key=0Ak-T4fS-gRDLdDduT2hVcTBhNUcxY2E3cmRXeU1Ga0E

Greg is still almost top 20 O.o

You should update that after WOF

 

[vcuber13]

he is top 20, the first row is headings

i plan to

 

[Ilkyoo Choi]

Do you really need more instructions than that? If you run an SQL database, just import the SQL. If not, you should find the TSV easy to use (especially easier than parsing our html pages) in your own program or in OpenOffice.org, Excel, etc.

I used Java cuz Stefan didn't reply to my email and I'm afraid to spam him

 

[Mike Hughey]

http://worldcubeassociation.org/results/statistics.php#most_competitions

Congrats Clément!

Wow, yes - congratulations!

And Arnaud was really breathing down his neck on that one, huh? Since Zonhoven, Arnaud: 13, Clément: 11. I bet Arnaud is not happy about it - it looks like he was trying hard to be first.

 

[Sebastien]

Wow, yes - congratulations!

And Arnaud was really breathing down his neck on that one, huh? Since Zonhoven, Arnaud: 13, Clément: 11. I bet Arnaud is not happy about it - it looks like he was trying hard to be first.

Not so hard eventually

He will reach a 100 as well then in 2 weeks.

What bothers me for now is, that I am Top 10 now for the 2nd time already but I have never appeared in that list on the statistics page

 

[Stefan]

I used Java cuz Stefan didn't reply to my email and I'm afraid to spam him

Oops, sorry, I either missed that one or didn't have enough time at the time and then forgot it

You asked for a query to do the sum of ranks, my short answer is that we don't just do it with a query but with some extra PHP code (though that has to do with our output and I don't know how necessary it is and how easy/hard it would be to do with just a query).

 

[Ilkyoo Choi]

Oops, sorry, I either missed that one or didn't have enough time at the time and then forgot it

You asked for a query to do the sum of ranks, my short answer is that we don't just do it with a query but with some extra PHP code (though that has to do with our output and I don't know how necessary it is and how easy/hard it would be to do with just a query).

No worries. Since I couldn't get an SQL query to work, I just downloaded the database as a TSV, parsed it using a Java program, and programmed it in a language I'm confortable with

 

[Swordsman Kirby]

No worries. Since I couldn't get an SQL query to work, I just downloaded the database as a TSV, parsed it using a Java program, and programmed it in a language I'm confortable with

so.... java?

 

[Ilkyoo Choi]

so.... java?

For one of my programs, yes.

 

[antoineccantin]

Funny competition:
http://worldcubeassociation.org/results/c.php?allResults=All+Results&competitionId=TibetOpen2012

 

[ben1996123]

Funny competition:
http://worldcubeassociation.org/results/c.php?allResults=All+Results&competitionId=TibetOpen2012

what the ****

 

[Michael Womack]

Funny competition:
http://worldcubeassociation.org/results/c.php?allResults=All+Results&competitionId=TibetOpen2012

WTF only 3x3 and magic WOW

 

[kinch2002]

Domination at the bottom of the magic world rankings

 

[Kian]

In a few months it will be as if the competition consisted of 15 official solves.

 

[ben1996123]

In a few months it will be as if the competition consisted of 15 official solves.

Only 14 solves, the winner of 3x3 DNFd a solve.

 

[Stefan]

In a few months it will be as if the competition consisted of 15 official solves.

http://www.worldcubeassociation.org/results/c.php?i=AmagasakiOpen2009
Note the last event.

 

[uberCuber]

http://www.worldcubeassociation.org/results/c.php?i=AmagasakiOpen2009
Note the last event.

woah, megaminx used to be a mo3 event? Never knew that

 

[Swordsman Kirby]

woah, megaminx used to be a mo3 event? Never knew that

4x4 used to be a mo3 event.