Odd WCA stats/ Stats request Thread

[Stefan]

can someone do ratio of 4x4 single to 5x5 single? i think meep will be first

He's not even top 10:

+---------+---------+--------+-----------------------------------------+
| single4 | single5 | ratio  | personName                              |
+---------+---------+--------+-----------------------------------------+
|  549.13 |  193.71 | 2.8348 | Julio Martín Gómez Telésforo            |
|  310.40 |  152.46 | 2.0359 | Christian Paiva                         |
|  186.36 |  109.96 | 1.6948 | Forte Shinko                            |
|  345.25 |  282.15 | 1.2236 | Alexx Ailes                             |
|  140.18 |  139.71 | 1.0034 | Eduardo Lins Motta                      |
|  127.02 |  131.08 | 0.9690 | Ilya Posevkin                           |
|   98.38 |  101.59 | 0.9684 | Sumeet Agarwal                          |
|  424.68 |  452.00 | 0.9396 | Maciej Ligenza                          |
|  148.71 |  162.84 | 0.9132 | Daniel Matheson                         |
|  252.19 |  283.11 | 0.8908 | Pitsanu Mukdaprakorn (????? ??????????) |
|  102.15 |  114.84 | 0.8895 | Alexander Tran                          |
|   46.61 |   52.65 | 0.8853 | Kristopher De Asis                      |
|  230.05 |  260.44 | 0.8833 | Ilya Shevchenko                         |
|  146.30 |  170.72 | 0.8570 | Chris Hemerich                          |
|  144.75 |  168.93 | 0.8569 | Braden Rock                             |
|  324.25 |  381.97 | 0.8489 | Philip Knudsen                          |
|   55.34 |   65.56 | 0.8441 | Yi Seung-Woo (???)                      |
|  203.53 |  241.30 | 0.8435 | Bin Li (??)                             |
|  110.72 |  131.27 | 0.8435 | Lee Jung-Min                            |
|  122.30 |  145.61 | 0.8399 | Barnabé Da Cruz                         |
|  159.06 |  191.18 | 0.8320 | Tomas Macadam                           |
|  195.33 |  235.43 | 0.8297 | Jianshun Zhang (???)                    |
|   99.58 |  120.40 | 0.8271 | Lee Jin-Hyung (???)                     |
|  166.28 |  201.71 | 0.8244 | Nathaniel Rees-Haughton                 |
|   89.38 |  108.81 | 0.8214 | Drew Brads                              |
|  102.25 |  124.91 | 0.8186 | Julien Gaboriaud                        |
|  213.58 |  265.02 | 0.8059 | Ronald Großmann                         |
|  121.78 |  152.83 | 0.7968 | Pablo Cañate Morillo                    |
|   95.27 |  120.31 | 0.7919 | Tr?n Trung Hi?u                         |
|  165.77 |  210.68 | 0.7868 | Kirill Zvonilin                         |
+---------+---------+--------+-----------------------------------------+

SELECT round(s4/100,2) single4, round(s5/100,2) single5, s4/s5 ratio, personName FROM
(SELECT personName, personId, min(best) s4 FROM Results where eventId='444' and best>0 GROUP BY personId) a,
(SELECT personId, min(best) s5 FROM Results where eventId='555' and best>0 GROUP BY personId) b
WHERE a.personId=b.personId
ORDER BY 3 desc
LIMIT 30

 

[Stefan]

Can we get an updated extended version of this. I'd like to see where I am before I drop off.

How do you have 64 competitions? None of your event lists look anywhere near that long. You must be switching between events quite a lot...

+-------+------------------------+
| comps | personName             |
+-------+------------------------+
|    97 | Bob Burton             |
|    97 | Clément Gallet         |
|    96 | Arnaud van Galen       |
|    95 | François Courtès       |
|    87 | Ton Dennenbroek        |
|    86 | Ron van Bruchem        |
|    85 | Erik Akkersdijk        |
|    83 | Lars Vandenbergh       |
|    77 | Shelley Chang          |
|    73 | Tim Reynolds           |
|    71 | Takao Hashimoto (????) |
|    70 | Sébastien Auroux       |
|    69 | Adam Zamora            |
|    66 | Devin Corr-Robinett    |
|    64 | Chris Krueger          |
|    64 | Jeremy Fleischman      |
|    63 | Sinpei Araki (????)    |
|    63 | Jaclyn Sawler          |
|    63 | Maria Oey              |
|    59 | Dave Campbell          |
|    58 | Kian Barry             |
|    57 | István Kocza           |
|    57 | Rowe Hessler           |
|    55 | Tyson Mao (???)        |
|    52 | Anders Larsson         |
|    51 | Dan Cohen              |
|    51 | Tomasz ?o?nowski       |
|    51 | Nobuaki Suga (???)     |
|    50 | Fumiki Koseki (????)   |
|    49 | Dan Dzoan              |
|    49 | Leyan Lo               |
|    49 | Bruce Norskog          |
|    47 | Joey Gouly             |
|    47 | Rama Temmink           |
|    45 | Joël van Noort         |
|    45 | Mats Valk              |
|    44 | Gunnar Krig            |
|    44 | Olivér Perge           |
|    44 | Hanneke Rijks          |
|    43 | Lucas Garron           |
|    43 | Fabian Auroux          |
|    43 | Yohei Oka (???)        |
|    43 | Gaël Dusser            |
|    42 | Justin Jaffray         |
|    42 | Henrik Buus Aagaard    |
|    42 | Milán Baticz           |
|    42 | Bence Barát            |
|    42 | Edouard Chambon        |
|    41 | Berit Brüster          |
|    41 | Jean-Louis Mathieu     |
+-------+------------------------+

SELECT count(distinct competitionId) comps, personName
FROM Results
GROUP BY personId
ORDER BY comps desc
LIMIT 50;

 

[Sebastien]

Another request, who has been to a lot of competitions without competing much?

http://www.worldcubeassociation.org/results/p.php?i=2007HASH01

should be ranked quite high for this, depending on what's the minimum amount of competitions you need to attend for appearing on that list.

 

[Meep]

can someone do ratio of 4x4 single to 5x5 single? i think meep will be first

I think I'd do better with difference between singles as opposed to ratios.

 

[Stefan]

I think I'd do better with difference between singles as opposed to ratios.

A bit, yes.

+---------+---------+---------+------------------------------+
| single4 | single5 | diff    | personName                   |
+---------+---------+---------+------------------------------+
|  549.13 |  193.71 | -355.42 | Julio Martín Gómez Telésforo |
|  310.40 |  152.46 | -157.94 | Christian Paiva              |
|  186.36 |  109.96 |  -76.40 | Forte Shinko                 |
|  345.25 |  282.15 |  -63.10 | Alexx Ailes                  |
|  140.18 |  139.71 |   -0.47 | Eduardo Lins Motta           |
|   98.38 |  101.59 |    3.21 | Sumeet Agarwal               |
|  127.02 |  131.08 |    4.06 | Ilya Posevkin                |
|   46.61 |   52.65 |    6.04 | Kristopher De Asis           |
|   55.34 |   65.56 |   10.22 | Yi Seung-Woo (???)           |
|  102.15 |  114.84 |   12.69 | Alexander Tran               |
|  148.71 |  162.84 |   14.13 | Daniel Matheson              |
|   89.38 |  108.81 |   19.43 | Drew Brads                   |
|  110.72 |  131.27 |   20.55 | Lee Jung-Min                 |
|   99.58 |  120.40 |   20.82 | Lee Jin-Hyung (???)          |
|   46.33 |   67.93 |   21.60 | Yueh-Lin Tsai (???)          |
|   44.33 |   66.06 |   21.73 | Ibrahim Vajgel-Shedid        |
|   35.58 |   57.40 |   21.82 | Kevin Hays                   |
|  102.25 |  124.91 |   22.66 | Julien Gaboriaud             |
|   83.52 |  106.52 |   23.00 | Yichao Wu (???)              |
|   64.77 |   88.02 |   23.25 | Yukiko Makino (?????)        |
|  122.30 |  145.61 |   23.31 | Barnabé Da Cruz              |
|   37.50 |   61.03 |   23.53 | Micha? Halczuk               |
|   67.86 |   91.77 |   23.91 | Jingzheng Wang (???)         |
|   82.58 |  106.52 |   23.94 | Kornél Nagy-Borsy            |
|  144.75 |  168.93 |   24.18 | Braden Rock                  |
|  146.30 |  170.72 |   24.42 | Chris Hemerich               |
|   30.33 |   54.86 |   24.53 | Yu Nakajima (???)            |
|   83.72 |  108.38 |   24.66 | Efraim Westholm              |
|   88.52 |  113.30 |   24.78 | Bradley Vrooman              |
|   95.27 |  120.31 |   25.04 | Tr?n Trung Hi?u              |
+---------+---------+---------+------------------------------+

SELECT round(s4/100,2) single4, round(s5/100,2) single5, round((s5-s4)/100,2) diff, personName FROM
(SELECT personName, personId, min(best) s4 FROM Results where eventId='444' and best>0 GROUP BY personId) a,
(SELECT personId, min(best) s5 FROM Results where eventId='555' and best>0 GROUP BY personId) b
WHERE a.personId=b.personId
ORDER BY 3
LIMIT 30

 

[David Zemdegs]

Hi,
Michal won the last world championships(3x3 - Oct 2011) with an average of 8.65.
Im curious to know, in all the competitions that have been held since then, how many people have beaten that average (rounds or finals).

 

[Kian]

Hi,
Michal won the last world championships(3x3 - Oct 2011) with an average of 8.65.
Im curious to know, in all the competitions that have been held since then, how many people have beaten that average (rounds or finals).

http://worldcubeassociation.org/res...onId=&years=&show=100+Results&average=Average

Just by a hand count I think 14 averages have been faster since then, done by Cornelius, Rowe, Nipat, Feliks, Yumu, and Mats.

No way, I'm still up there. Though I'm going to drop off now post-nationals.

Wow, I was judging from your profile and I could have never guessed you had been to 64 competitions.

 

[Swordsman Kirby]

No idea if this has been done before, but:

http://www.cs.columbia.edu/~ts2578/bld.html

I decided to see where I stood in the BLD world.

 

[Stefan]

No idea if this has been done before, but:

http://www.cs.columbia.edu/~ts2578/bld.html

I decided to see where I stood in the BLD world.

I suddenly have the urge to improve (you go up to sum 730, I have 737).

 

[amostay2004]

I suddenly have the urge to pick up 5BLD

 

[Stefan]

I suddenly have the urge to pick up 5BLD

Isn't he a bit too young for you?

 

[Endgame]

Isn't he a bit too young for you?

I lol'd.

 

[5BLD]

I suddenly have the urge to pick up 5BLD

witty.
s'hertogen, bosh~

 

[Swordsman Kirby]

In my opinion, setting the 5x5 column at Stefan+1 for those who don't have a solve is too lenient.

 

[Coolster01]

Youngest and Fastest Cubers (Age Vs. Speed)

So I was wondering who the youngest and fastest cubers are. Other than wca's age vs speed page, which only compares for at comps, not at home, there is nothing to compare age and speed. Lol maybe I am in one of these? So correct me if I am wrong, but I believe that I might be the youungest cuber to get a:
Sub .55 2x2 Single (.53)
Sub 11.5 3x3 Average of 5 (11.43)
Sub 47 4x4 Single (46.53)
Sub 1:02 4x4 Average (1:01.xx)
Sub 1.01 Magic Average (1.00)
Sub 1 Magic Single (.961)
Sub 1:50 Minutes for 3x3 Blindfolded (1:47.955)
4x4 Blindfolded (Overall youngest)
5x5 Blindfolded (Off by three corners yesterday, will attempt again today.)
And I am 11 years and 20 days old as of this day of this post.
The only 2 that have video proof are the sub 1 magic single (.985, not the .961); the 4BLD single, and the 1:47.955 3x3 Blindfolded. 5x5 Blindfolded will be soon! And I have many averages/singles very close to these that are on camera, so if you are really picky I can upload those to my channel, TheRubiksCard101. Thanks for helping me out, and maybe we'll find the youngest and fastest solvers for every event at one point.

 

[cyoubx]

So I was wondering who the youngest and fastest cubers are. Other than wca's age vs speed page, which only compares for at comps, not at home, there is nothing to compare age and speed. Lol maybe I am in one of these? So correct me if I am wrong, but I believe that I might be the youungest cuber to get a:
Sub .55 2x2 Single (.53)
Sub 11.5 3x3 Average of 5 (11.43)
Sub 47 4x4 Single (46.53)
Sub 1:02 4x4 Average (1:01.xx)
Sub 1.01 Magic Average (1.00)
Sub 1 Magic Single (.961)
Sub 1:50 Minutes for 3x3 Blindfolded (1:47.955)
4x4 Blindfolded (Overall youngest)
5x5 Blindfolded (Off by three corners yesterday, will attempt again today.)
And I am 11 years and 20 days old as of this day of this post.
The only 2 that have video proof are the sub 1 magic single (.985, not the .961); the 4BLD single, and the 1:47.955 3x3 Blindfolded. 5x5 Blindfolded will be soon! And I have many averages/singles very close to these that are on camera, so if you are really picky I can upload those to my channel, TheRubiksCard101. Thanks for helping me out, and maybe we'll find the youngest and fastest solvers for every event at one point.

You're also the youngest cuber to have a sub-11.44 average of 5 on 3x3. I believe.

 

[antoineccantin]

So I was wondering who the youngest and fastest cubers are. Other than wca's age vs speed page, which only compares for at comps, not at home, there is nothing to compare age and speed. Lol maybe I am in one of these? So correct me if I am wrong, but I believe that I might be the youungest cuber to get a:
Sub .55 2x2 Single (.53)
Sub 11.5 3x3 Average of 5 (11.43)
Sub 47 4x4 Single (46.53)
Sub 1:02 4x4 Average (1:01.xx)
Sub 1.01 Magic Average (1.00)
Sub 1 Magic Single (.961)
Sub 1:50 Minutes for 3x3 Blindfolded (1:47.955)
4x4 Blindfolded (Overall youngest)
5x5 Blindfolded (Off by three corners yesterday, will attempt again today.)
And I am 11 years and 20 days old as of this day of this post.
The only 2 that have video proof are the sub 1 magic single (.985, not the .961); the 4BLD single, and the 1:47.955 3x3 Blindfolded. 5x5 Blindfolded will be soon! And I have many averages/singles very close to these that are on camera, so if you are really picky I can upload those to my channel, TheRubiksCard101. Thanks for helping me out, and maybe we'll find the youngest and fastest solvers for every event at one point.

I'm thinking Bernett Orlando?
I know for sure he could do 5BLD at last 5 years ago, not sure how old he is now.

 

[Rubiks560]

So I was wondering who the youngest and fastest cubers are. Other than wca's age vs speed page, which only compares for at comps, not at home, there is nothing to compare age and speed. Lol maybe I am in one of these? So correct me if I am wrong, but I believe that I might be the youungest cuber to get a:
Sub .55 2x2 Single (.53)
Sub 11.5 3x3 Average of 5 (11.43)
Sub 47 4x4 Single (46.53)
Sub 1:02 4x4 Average (1:01.xx)
Sub 1.01 Magic Average (1.00)
Sub 1 Magic Single (.961)
Sub 1:50 Minutes for 3x3 Blindfolded (1:47.955)
4x4 Blindfolded (Overall youngest)
5x5 Blindfolded (Off by three corners yesterday, will attempt again today.)
And I am 11 years and 20 days old as of this day of this post.
The only 2 that have video proof are the sub 1 magic single (.985, not the .961); the 4BLD single, and the 1:47.955 3x3 Blindfolded. 5x5 Blindfolded will be soon! And I have many averages/singles very close to these that are on camera, so if you are really picky I can upload those to my channel, TheRubiksCard101. Thanks for helping me out, and maybe we'll find the youngest and fastest solvers for every event at one point.

I have this feeling you don't really care about how fast anyone else is. You just want to brag about your semi-decent times.

 

[Coolster01]

I have this feeling you don't really care about how fast anyone else is. You just want to brag about your semi-decent times.

Naaah. I was looking for young cubers or some people that knew young cubers because you can't find them with wca usually

I'm thinking Bernett Orlando?
I know for sure he could do 5BLD at last 5 years ago, not sure how old he is now.

That is exactly what I have wondered - when Bernett got his first success. I know he got his first official 4 and 5BLD successes at 11 yrs 6 months.

You're also the youngest cuber to have a sub-11.44 average of 5 on 3x3. I believe.

I don't get it lol. Is that supposed to be a joke or what?

EDIT: I completely forgot about double posting :fp

 

[Sa967St]

Sub .55 2x2 Single (.53)
Sub 11.5 3x3 Average of 5 (11.43)
Sub 47 4x4 Single (46.53)
Sub 1:02 4x4 Average (1:01.xx)
Sub 1.01 Magic Average (1.00)
Sub 1:50 Minutes for 3x3 Blindfolded (1:47.955)

Why so specific? It really does look like you just want (insignificant) things something to brag about. IMO, the only significant part of your post was that you might be the youngest person to solve a 4x4 BLD.