Odd WCA stats/ Stats request Thread

[ben1996123]

I had a 1:08.23 average and then my next average was 13.06, http://www.worldcubeassociation.org/results/p.php?i=2009SMIT03. I was wondering how that stacked up to others as a ratio from one round to another (if that makes sense).

Lol at your 2x2 (25.15 to 1.43)

EDIT: What about worst as well? Your clock average goes from 41.46 to 1:32.99

 

[Carrot]

I got a new request for Stefan:

Dan Cohen told me that I sucked at sq-1 recently because I got a one minute solve, and that it is not normal to solve a megaminx faster than a sq-1.. So who has the biggest sq1/megaminx ratio? (and how many does even have a ratio above 1? Luckily I have a ratio under 1, YAY!! )

 

[Stefan]

Dan Cohen told me that I sucked at sq-1 recently because I got a one minute solve, and that it is not normal to solve a megaminx faster than a sq-1.. So who has the biggest sq1/megaminx ratio? (and how many does even have a ratio above 1? Luckily I have a ratio under 1, YAY!! )

Not sure this is what you meant, but here's your sq1 record / minx record:

sq1/mi     sq1    minx  id          name
--------------------------------------------------------
3.4431  381.01  110.66  2007LUCH01  Chia-Wei Lu
3.3267  538.52  161.88  2007ENRI01  Benjamin Jose Enriquez
2.7991  394.81  141.05  2010KREY01  Florian Kreyßig
1.8881  113.02   59.86  2010BECK01  Karina Grandjean Beck
1.4158  115.81   81.80  2009CONT01  Giovanni Contardi
1.3782  189.77  137.69  2007LEEN01  Yann Leenhardt
1.3638  176.70  129.56  2007CANA01  James Benedict Cañares
1.2995  266.58  205.14  2009ALFA02  Angelo Mauricio Adasme Alfaro
1.2377  103.55   83.66  2008VILL01  Jek Villacampa
1.1719  190.73  162.75  2007ROGO01  Dennis Rogon
1.1558  104.11   90.08  2010MCDO01  Louis McDonald
1.1375  198.02  174.08  2007RIBE01  Rodrigo Ybarra de Oliveira Ribeiro
1.0976  260.02  236.90  2010PERE06  María Fernanda Segovia Pérez
1.0830  100.03   92.36  2007LAFE01  Caio José Lafetá
1.0501   71.52   68.11  2008HANK01  Kanneti Sae Han
1.0297  142.80  138.68  2009BOSI01  Alberto Bosia
1.0213   92.13   90.21  2009LUNA01  Luigi Lunardon
0.9846  107.72  109.41  2008PALO01  Michael Palone
0.9712  316.34  325.72  2003DENN01  Ton Dennenbroek
0.9452  181.11  191.61  2008BARA02  Bálint Barát
0.9355  272.84  291.66  2008LIUJ01  Jialin Liu (刘佳琳)
0.9235   75.69   81.96  2003POCH01  Stefan Pochmann
0.9230  109.34  118.46  2010PAUL02  Cesare Paulin
0.9188   57.71   62.81  2010COOK01  Jonathan Cookmeyer
0.9137   43.43   47.53  2008BODO01  Bálint Bodor
0.8866  121.31  136.83  2009SANT03  Robert Allen Santayana
0.8656   64.27   74.25  2009CHAN15  Juan Juli Andika Chandra
0.8380  143.72  171.50  2009DENG01  Bowen Deng (邓博文)
0.8327   70.68   84.88  2009CORR02  Lorenzo Corradin
0.8194   81.91   99.96  2009KIEL01  Tomasz Kielbasa
0.8056  107.30  133.19  2008KINN01  Rowan Kinneavy
0.7983  165.97  207.91  2006LECK01  Mimmi Leckius
0.7954   85.65  107.68  2008DZIK01  Grzegorz Dzikiewicz
0.7913   51.96   65.66  2009EWER01  Leonard Ewerbeck
0.7860   90.56  115.21  2010LETA01  Bonifác Péter Létai
0.7765   46.22   59.52  2009CAYE01  Giuliano Cayetano
0.7747   73.52   94.90  2005HAYE01  Daniel Hayes
0.7740  142.47  184.08  2010DALL01  Quentin Dallison
0.7127   72.65  101.93  2009CASA02  Myles Casanas
0.7067   64.44   91.19  2009ASBR01  Oskar Åsbrink
0.7053   60.43   85.68  2007LEMO01  Laetitia Lemoine
0.7051   43.44   61.61  2008LOMB01  Pasquale Lombardozzi
0.7011   69.06   98.50  2006PAWL01  Kamil Pawlak
0.6963   72.65  104.33  2009RODA01  Geoffrey Roda
0.6942   46.66   67.21  2009CHAI01  Tanai Chaikraveephan
0.6898  116.55  168.97  2010VALO01  Clément Valot
0.6874  114.51  166.59  2006WLOS01  Pawel Wloszek
0.6859   96.75  141.05  2010MARQ03  José Pablo Márquez
0.6768   77.38  114.34  2009TURI01  Barnabás Turi
0.6721   69.90  104.00  2009YINC05  Chengzhi Yin (殷程智)
0.6653  158.05  237.56  2007JOHN02  Erik Johnson
0.6439   59.03   91.68  2007SUGA01  Nobuaki Suga (菅 信昭)
0.6381   66.96  104.93  2008LEUN02  So Chi Leung
0.6315   59.58   94.34  2008LICU01  Chris Licuanan
0.6235   64.18  102.94  2009CHRI03  Nora Christ
0.6229   56.66   90.96  2010KEHR01  Leonhard Kehrberger
0.6220  101.36  162.97  2010GAUT01  Yoann Gauthier
0.6194   63.88  103.13  2010DEVI01  Cristo Devinco
0.6162  117.34  190.43  2008GELA01  András Gelányi
0.6127  283.58  462.84  2007PROV01  Frank Provoost
0.6087   34.90   57.34  2008ANDE02  Oscar Roth Andersen

SELECT sq1.best/minx.best ratio, sq1.best/100, minx.best/100, sq1.personId, sq1.personName
FROM
(SELECT personId, personName, min(best) best FROM Results WHERE eventId='sq1' AND best>0 GROUP BY personId) sq1,
(SELECT personId, min(best) best FROM Results WHERE eventId='minx' AND best>0 GROUP BY personId) minx
where sq1.personId = minx.personId
order by ratio desc;

 

[Carrot]

Not sure this is what you meant, but here's your sq1 record / minx record:

That was exactly what I meant, thank you, and can you also please make one for average? (still sq1/minx)

EDIT: ohhh, I see that you included me in the list, you don't need to do that, just end the list when the ratio gets below 1

 

[Stefan]

can you also please make one for average?

Mmh, I don't wanna.

Ok, fine. But I point out that the other two are significantly worse than me.

sq1/mi     sq1    minx  id          name
--------------------------------------------------------
2.0416  137.91   67.55  2010BECK01  Karina Grandjean Beck
1.5821  137.39   86.84  2008VILL01  Jek Villacampa
1.2702  106.43   83.79  2003POCH01  Stefan Pochmann
1.2673  398.81  314.70  2007LUND01  Daniel Lundwall
1.2391   85.50   69.00  2008LOMB01  Pasquale Lombardozzi
1.1731  246.52  210.15  2007RIBE01  Rodrigo Ybarra de Oliveira Ribeiro
1.1647  125.69  107.92  2007SUGA01  Nobuaki Suga (菅 信昭)
1.1568   90.28   78.04  2008HANK01  Kanneti Sae Han
1.0876  112.65  103.58  2009LUNA01  Luigi Lunardon
1.0794  224.26  207.77  2003RUET01  Jake Rueth
1.0771  111.46  103.48  2005HAYE01  Daniel Hayes
1.0486  205.61  196.08  2006KRUE01  Chris Krueger
1.0373  108.08  104.19  2007LAFE01  Caio José Lafetá
0.9705  119.50  123.13  2009OLSO01  Christopher Olson
0.9617   49.48   51.45  2008BODO01  Bálint Bodor
0.9284   85.32   91.90  2007LEMO01  Laetitia Lemoine
0.9227  102.99  111.62  2010DEVI01  Cristo Devinco
0.8998   59.98   66.66  2009CAYE01  Giuliano Cayetano
0.8617   61.87   71.80  2009EWER01  Leonard Ewerbeck
0.8610  165.87  192.65  2009DENG01  Bowen Deng (邓博文)
0.8603   96.30  111.94  2009RODA01  Geoffrey Roda
0.8314  169.92  204.37  2010VALO01  Clément Valot
0.8145   72.59   89.12  2009CHAN15  Juan Juli Andika Chandra
0.7866   83.87  106.63  2008LICU01  Chris Licuanan
0.7600  152.31  200.40  2008ROST01  Salim Rostam
0.7449   87.33  117.24  2009CHRI03  Nora Christ
0.7402   95.95  129.62  2010HARN03  Patrick Harnisch
0.7347   93.65  127.46  2008BORR01  Daniel Borrajo Gutiérrez
0.7335  118.48  161.52  2010LIQI01  Qinghua Li (李清华)
0.7282   74.06  101.70  2009ASBR01  Oskar Åsbrink
0.7233  100.25  138.61  2009MYSH01  Mihail Myshkin
0.7227   56.37   78.00  2009CHAI01  Tanai Chaikraveephan
0.7207   85.61  118.78  2009CASA02  Myles Casanas
0.7128  135.68  190.34  2008GNOI01  Jan Gnoinski
0.6997  133.84  191.29  2009MAKA01  Ivan Makachev
0.6978   76.78  110.03  2006PAWL01  Kamil Pawlak
0.6975   42.20   60.50  2008ANDE02  Oscar Roth Andersen

SELECT sq1.best/minx.best ratio, sq1.best/100, minx.best/100, sq1.personId, sq1.personName
FROM
(SELECT personId, personName, min(average) best FROM Results WHERE eventId='sq1' AND average>0 GROUP BY personId) sq1,
(SELECT personId, min(average) best FROM Results WHERE eventId='minx' AND average>0 GROUP BY personId) minx
where sq1.personId = minx.personId
order by ratio desc;

EDIT: ohhh, I see that you included me in the list, you don't need to do that, just end the list when the ratio gets below 1

No, you gotta suffer.

 

[Stefan]

Alright, this time I stopped when the ratio got below 1:

mag/py  magic  pyram  id          name
--------------------------------------------------------
2.0919  12.97   6.20  2011KALD01  Kevin Kaldera
1.9614  20.83  10.62  2008NEME01  János Nemes
1.5078  14.55   9.65  2010MOFF02  Zoé de Moffarts
1.1051   9.25   8.37  2009SEIM02  Vegard Seim Karstang
1.0573  10.71  10.13  2009JAMS01  Piyachat Jamsai
1.0009  11.35  11.34  2010MARI02  István Márián
0.8163   2.80   3.43  2008ANDE02  Oscar Roth Andersen

SELECT magic.best/pyram.best ratio, magic.best/100, pyram.best/100, magic.personId, magic.personName
FROM
(SELECT personId, personName, min(average) best FROM Results WHERE eventId='magic' AND average>0 GROUP BY personId) magic,
(SELECT personId, min(average) best FROM Results WHERE eventId='pyram' AND average>0 GROUP BY personId) pyram
where magic.personId = pyram.personId
order by ratio desc;

 

[Stefan]

One more: clock vs pyraminx average

cloc/py  clock  pyram  id          name
--------------------------------------------------------
12.4227  42.61   3.43  2008ANDE02  Oscar Roth Andersen
 7.4127  64.12   8.65  2009OCAM01  Janilo Ocampo
 6.1848  60.24   9.74  2007HESS01  Rowe Hessler
 6.0212  73.94  12.28  2009LIJI03  Jiajun Li (李嘉俊)
 5.8844  84.50  14.36  2010PATZ01  Moritz Patzelt
 5.8814  36.70   6.24  2009BOGA01  Victor Bogatov
 5.8038  24.26   4.18  2008BERE01  Brúnó Bereczki
 5.7375  36.72   6.40  2008LINT01  Tse-Kan Lin (林哲侃)
 5.7213  49.89   8.72  2009YANG06  Rui Yang (杨睿)
 5.6888  28.33   4.98  2009BALT02  Leandro Baltazar

That's what you get for being so good at something

 

[Carrot]

One more: clock vs pyraminx average

cloc/py  clock  pyram  id          name
--------------------------------------------------------
12.4227  42.61   3.43  2008ANDE02  Oscar Roth Andersen
 7.4127  64.12   8.65  2009OCAM01  Janilo Ocampo
 6.1848  60.24   9.74  2007HESS01  Rowe Hessler

That's what you get for being so good at something

Wouw, I didn't realize how much I suck at clock before now O.O

 

[anders]

There has now been 200 competitions in the USA:
http://www.worldcubeassociation.org/results/statistics.php#17

 

[Maniac]

Stefan. can you find the fastest magic solver who doesn't have a ofiicial master magic attempt. or the slowest?

 

[Zane_C]

I don't know how difficult this will be; I'm wondering who has spent the most time doing official solves.

 

[Stefan]

Stefan. can you find the fastest magic solver who doesn't have a ofiicial master magic attempt. or the slowest?

I don't see the point of the slowest.

Best magicers without mastermagic:

0.80  2010VILL02  Luis Mario Villela Chávez
0.86  2010ZHAN17  Hao Zhang (张昊)
0.90  2009KASA01  Akihiko Kasamatsu (笠松暁輝)
0.90  2010JRRE01  Restituto Cortan Jr.
0.93  2008HUXI01  Xiaobo Hu (胡晓波)
0.94  2009WHIT01  Ben Whitmore
0.96  2007AKUT01  Takuma Akutsu (阿久津 拓真)
0.96  2010VUVA01  Van Tien Trung Vu
0.97  2008SAJI01  Yu Sajima (佐島 優)
0.97  2008CHEN13  Jokey Chen (陈祖祺)
0.97  2010SUTT01  Christian Suttner

SELECT a/100, personId, personName
FROM
(SELECT personId, personName,
       min(if(eventId='magic' and best>0, best, 99999999)) a,
       min(if(eventId='mmagic' and best>0, best, 99999999)) b
 FROM Results
 GROUP BY personId) helper
WHERE a<99999999 AND b=99999999
ORDER BY a;

Best mastermagicers without magic (I find this odder):

2.52  2011WUCH01  Chonghao Wu (武崇皓)
2.63  2010FUXI01  Xianglei Fu (傅相磊)
2.88  2009HAMO01  James Hamory
2.91  2006DZOA03  Dan Dzoan
3.05  2011WANG19  Bin Wang (王斌)
3.08  2009DEZS01  Tibor Dezse
3.34  2010HANC01  Chi Han (韩驰)
3.43  2009SRIK01  Sarawut Srikonvit
3.44  2010ZHAO16  Xiaozhe Zhao (赵笑哲)
3.53  2010MALL01  Justin Mallari

 

[Stefan]

I don't know how difficult this will be; I'm wondering who has spent the most time doing official solves.

Can't do it exactly because FMC times are unknown, penalties are unknown, some multiblind times are unknown, and for multiblind it's not known how much time went into solving and how much into attempting.

But here are the top 10 for sum of solve time as stored, excluding FMC and multiblind:

Hours  Who
----------------------
61.48  Clément Gallet
60.76  François Courtès
56.77  Arnaud van Galen
52.91  Sébastien Auroux
50.51  Erik Akkersdijk
47.15  Ron van Bruchem
44.72  Lars Vandenbergh
41.18  István Kocza
37.25  Bob Burton
32.42  Bence Barát


SELECT   (sum( if(value1>0,value1,0) ) +
          sum( if(value2>0,value2,0) ) +
          sum( if(value3>0,value3,0) ) +
          sum( if(value4>0,value4,0) ) +
          sum( if(value5>0,value5,0) ))/100/60/60 hours,
         personName
FROM     Results, Events
WHERE    Events.id = eventId
  AND    format = 'time'
GROUP BY personId
ORDER BY hours DESC;

 

[Carrot]

Mmh, I don't wanna.

Ok, fine. But I point out that the other two are significantly worse than me.

sq1/mi     sq1    minx  id          name
--------------------------------------------------------
2.0416  137.91   67.55  2010BECK01  Karina Grandjean Beck
1.5821  137.39   86.84  2008VILL01  Jek Villacampa
1.2702  106.43   83.79  2003POCH01  Stefan Pochmann

Ohh I had to read that like 20 times before I realized that you were number 3.

And WOHOO!!! number 1 was exactly as I had expected, thank you

 

[qqwref]

Best mastermagicers without magic (I find this odder):

2.91  2006DZOA03  Dan Dzoan

LOLOLOLOLOL

(I think I can kinda explain this one: in the California speedcubing community, there's a big stigma against Magic because it's the same thing every time, and dumb and easy and fast etc. But I guess Dan finds MM more interesting, as he's competed in it many times.)


More interesting than "fastest" IMO: who's competed in X most times without ever competing in Y? I guess this could be computed for 6x6/7x7, 4x4/5x5, 2x2/3x3, magic/MM, 4BLD/5BLD (each of these in both orders).

 

[vcuber13]

More interesting than "fastest" IMO: who's competed in X most times without ever competing in Y? I guess this could be computed for 6x6/7x7, 4x4/5x5, 2x2/3x3, magic/MM, 4BLD/5BLD (each of these in both orders).

i was wondering something similar to this yesterday, but what id like to see more is who has the best/worst 5x5:7x7, im pretty good at 5x5 (1:38 official single) but pretty bad at 7x7 (7 min single)

 

[Sebastien]

Can't do it exactly because FMC times are unknown, penalties are unknown, some multiblind times are unknown, and for multiblind it's not known how much time went into solving and how much into attempting.

Can you specify what you mean? I can't really get it.

 

[Pro94]

Can you specify what you mean? I can't really get it.

For example if someone got a DNF into multi BLD, time doesn't appear in WCA

 

[Stefan]

Can you specify what you mean? I can't really get it.

- some multiblind times are unknown

See the question mark times here: https://worldcubeassociation.org/results/c.php?i=GalantaOpen2009&allResults=1#333mbo

- for multiblind it's not known how much time went into solving and how much into attempting.

That was the last point because it was the least significant, what I meant was that we have the artificial rule about what counts as solved and what doesn't (5/9 is solved, 4/9 isn't), so I don't feel comfortable saying the whole time or none of the time is "solving" time, and if you *solved* 5 of 9 cubes, we don't know how much time went into those 5 cubes (that's what I meant with the time that went into solving (with time that went into attempting I meant the time for the remaining 4 cubes that weren't solved, though I shouldn't have called it that because the 5 solved ones were also attempted)).

 

[Sebastien]

hm, this is the first time I see such missing times. Can you say how many of those are there in total?

About the second point: I think the best way to consider MBF attempts is to see the whole attempt as one solve. 5/9 in 40:00 is one solve with a duration of 40 minutes. 4/9 is equivalent to DNF, so no solve. 9/9 in 40:00 is another solve with a duration of 40 minutes - a better one though.

Could you make the list again following this philosophy, which means including MBF?

And maybe a third one including MBF and all FMC-solves counting as 60 minutes?

I'd appreciate that