Odd WCA stats/ Stats request Thread

Bob said:
In this thread, Alan pointed out that a different person won each of the 12 events held at Princeton Fall 2012.

http://www.speedsolving.com/forum/showthread.php?32976-Princeton-Fall-2012&p=787322&viewfull=1#post787322

What is the most events held in which this has happened? How many times has this even happened at all?
Click to expand...

Previously I found [post=744463]these[/post] and PF2012 seems to be the only comp above nine. There seem to be 81 with nobody winning more than one event, out of which 43 had more than one event.
 
I know this is a lot to ask for, but the sum of all average ranks for every person in the database (thought I guess it would be fine to leave out people who only do 3x3 - if that makes it easier). And if somebody does this, can you put rank numbers next to each person's name (their rank based on the sum).

Thanks!
 
BlueDevil said:
I know this is a lot to ask for, but the sum of all average ranks for every person in the database (thought I guess it would be fine to leave out people who only do 3x3 - if that makes it easier). And if somebody does this, can you put rank numbers next to each person's name (their rank based on the sum).

Thanks!
Click to expand...
Evan Liu said:
Updated the sum of single and average ranks documents. The database export currently available is that of August 6th, so it doesn't contain results from Guiyang, Hefei, or Ha Noi (and as with before, does not include the magics). It does contain US Nationals results, of course.
I'm now 32nd for single and 34th for average. :D
http://dl.dropbox.com/u/16017198/Final_Single.txt
http://dl.dropbox.com/u/16017198/Final_Avg.txt
http://dl.dropbox.com/u/16017198/Single_Names.txt
http://dl.dropbox.com/u/16017198/Avg_Names.txt
Click to expand...
I've already done this (and for single ranks too). First two links have WCA IDs, second two have names instead.
It was last updated after Nationals, though. The earliest I would want to update again is next week (i.e. after Euros), but only if I have time to do it.
 
Evan Liu said:
I've already done this (and for single ranks too). First two links have WCA IDs, second two have names instead.
It was last updated after Nationals, though. The earliest I would want to update again is next week (i.e. after Euros), but only if I have time to do it.
Click to expand...

oh, ok. thanks! I look forward to one with updated results
 
Evan Liu said:
I've already done this (and for single ranks too). First two links have WCA IDs, second two have names instead.
It was last updated after Nationals, though. The earliest I would want to update again is next week (i.e. after Euros), but only if I have time to do it.
Click to expand...

I'm sure I've asked this before, but are there any plans to put sum of ranks on to people's WCA ID page?
 
The second BLD scramble of the first round at Euro 2012 had 4 NRs set on it (counting the WR). Is that the most NRs ever set on one scramble?

EDIT: Counting ERs and the WR, there were 107 NRs by my count. That's insane!
 
Last edited:
Noahaha said:
The second BLD scramble of the first round at Euro 2012 had 4 NRs set on it (counting the WR). Is that the most NRs ever set on one scramble?

EDIT: Counting ERs and the WR, there were 107 NRs by my count. That's insane!
Click to expand...

I don't understand.:confused:
Are you talking about two different scrambles, or counting potential NR's that would have beaten the previous NR before the comp, but not during the comp when someone had already beaten it?
 
Noahaha said:
Counting ERs and the WR, there were 107 NRs by my count. That's insane!
Click to expand...

Insane? THIS... IS... EUROPE!!!

Code: 
+------+------------------------+
| RRs  | competitionId          |
+------+------------------------+
|  170 | WC2011                 |
|  166 | Euro2010               |
|  161 | WC2009                 |
|  136 | Euro2006               |
|  126 | WC2007                 |
|  107 | Euro2012               |
|  107 | WC2005                 |
|   85 | BelgianOpen2007        |
|   79 | WC2003                 |
|   77 | Euro2004               |
|   76 | AsianChampionship2010  |
|   76 | HelsinkiOpen2011       |
|   75 | Euro2008               |
|   74 | NorwegianOpen2010      |
|   72 | GermanOpen2006         |
|   72 | GuangdongOpen2008      |
|   71 | FrenchOpen2009         |
|   67 | MPEIOpen2010           |
|   67 | DutchOpen2006          |
|   64 | GermanOpen2007         |
|   62 | UkraineOpen2012        |
|   62 | CzechOpen2009          |
|   59 | GuangdongOpen2007      |
|   55 | PolishOpen2005         |
|   54 | AachenOpen2011         |
|   54 | OleksandriiaOpen2012   |
|   52 | CzechOpen2008          |
|   52 | DutchOpen2005          |
|   50 | BrusselsSummerOpen2009 |
|   50 | GermanOpen2010         |
+------+------------------------+


SELECT sum((regionalSingleRecord<>'') + (regionalAverageRecord<>'')) RRs, competitionId
FROM Results
GROUP BY competitionId
ORDER BY 1 desc
LIMIT 30
 
Stefan said:
Insane? THIS... IS... EUROPE!!!

Code: 
+------+------------------------+
| RRs  | competitionId          |
+------+------------------------+
|  170 | WC2011                 |
|  166 | Euro2010               |
|  161 | WC2009                 |
|  136 | Euro2006               |
|  126 | WC2007                 |
|  107 | Euro2012               |
|  107 | WC2005                 |
|   85 | BelgianOpen2007        |
|   79 | WC2003                 |
|   77 | Euro2004               |
|   76 | AsianChampionship2010  |
|   76 | HelsinkiOpen2011       |
|   75 | Euro2008               |
|   74 | NorwegianOpen2010      |
|   72 | GermanOpen2006         |
|   72 | GuangdongOpen2008      |
|   71 | FrenchOpen2009         |
|   67 | MPEIOpen2010           |
|   67 | DutchOpen2006          |
|   64 | GermanOpen2007         |
|   62 | UkraineOpen2012        |
|   62 | CzechOpen2009          |
|   59 | GuangdongOpen2007      |
|   55 | PolishOpen2005         |
|   54 | AachenOpen2011         |
|   54 | OleksandriiaOpen2012   |
|   52 | CzechOpen2008          |
|   52 | DutchOpen2005          |
|   50 | BrusselsSummerOpen2009 |
|   50 | GermanOpen2010         |
+------+------------------------+


SELECT sum((regionalSingleRecord<>'') + (regionalAverageRecord<>'')) RRs, competitionId
FROM Results
GROUP BY competitionId
ORDER BY 1 desc
LIMIT 30
Click to expand...

Onice.
 
Stefan, could you update the database export? With the European and Asian championship results now up, I'm planning to update my sum of ranks calculations, and perhaps present them in a sortable table format.

MaeLSTRoM said:
I'm sure I've asked this before, but are there any plans to put sum of ranks on to people's WCA ID page?
Click to expand...
I wouldn't be one to answer this question, and my calculations probably don't help since they must be manually updated.
 
In the search function for people, is there a way to get it so that the results that come up have what I search as only the first name or only the last name? And not just names that contain what I search. So if I searched "Li" for a simple example, I wouldn't get results like "Alistair Berg" and just things like "Anran Li" or "Li Haoming".
 
Its amazing to look at those world record graphs and think that a few years ago the 3x3 record average was around 20 seconds.
 
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
188
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
434
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
485
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,047
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,504
Discomantis
Discomantis
Back
Top