Odd WCA stats/ Stats request Thread

Lucas Garron · May 1, 2011

Stefan said:
223,865

That's just the regular 3x3x3 event, though. Do you also need one-handed etc?

Code:

select sum((value1>0) + (value2>0) + (value3>0) + (value4>0) + (value5>0)) from results, competitions c where c.id=competitionId and eventId='333' and year*10000+month*100+day between 20030823 and 20110130

Are all positive values actual solve times, i.e. does

Code:

select sum(value1*(value1>0) + value2*(value2>0) + value3*(value3>0) + value4*(value4>0) + value5*(value5>0))/100/60/60/24
from results, competitions c
where c.id=competitionId
and eventId='333'
and year*10000+month*100+day between 20030823 and 20110130

mean there have been a total of 78 days of official solves?

timeless · May 1, 2011

Lucas Garron said:
Are all positive values actual solve times, i.e. does

Code:

select sum(value1*(value1>0) + value2*(value2>0) + value3*(value3>0) + value4*(value4>0) + value5*(value5>0))/100/60/60/24 from results, competitions c where c.id=competitionId and eventId='333' and year*10000+month*100+day between 20030823 and 20110130

mean there have been a total of 78 days of official solves?

u mean the dnf/dns solves shouldnt be counted?

Stefan · May 1, 2011

Lucas Garron said:
Are all positive values actual solve times, i.e. does [...] mean there have been a total of 78 days of official solves?

Not quite. It's the final times as seen on the results pages, i.e., including penalty times. We have no data about the penalties. But it does mean successful solves, yes. In general, zero means no attempt was scheduled (e.g. value4 and value5 for a best-of-3 round), negative values mean failures (dnf or dns) and positive values mean success.

timeless said:
u mean the dnf/dns solves shouldnt be counted?

Not surprised someone starting a sentence with "u" thinks that dnf should count towards solve time, and dns should count towards any time.

qqwref · May 1, 2011

Stefan said:
Not surprised someone starting a sentence with "u" thinks that dnf should count towards solve time, and dns should count towards any time.

I'm not an expert in the intricacies of SQL, but wouldn't your query count neither DNF nor DNS? I think a DNF ought to count as a solve (although a DNS oughtn't).

timeless · May 1, 2011

Stefan said:
Not quite. It's the final times as seen on the results pages, i.e., including penalty times. We have no data about the penalties. But it does mean successful solves, yes. In general, zero means no attempt was scheduled (e.g. value4 and value5 for a best-of-3 round), negative values mean failures (dnf or dns) and positive values mean success.

Not surprised someone starting a sentence with "u" thinks that dnf should count towards solve time, and dns should count towards any time.

i said shouldnt

Stefan · May 1, 2011

Total solve days for each event (except fewest moves and multiblind, sorry):

86.34 Rubiks Cube
72.81 4x4 Cube
68.92 5x5 Cube
38.69 Rubiks Cube: One-handed
22.19 Megaminx
19.10 7x7 Cube
16.15 Rubiks Cube: Blindfolded
13.28 6x6 Cube
12.58 2x2 Cube
10.14 Square-1
7.16 Pyraminx
2.97 4x4 Cube: Blindfolded
2.83 Rubiks Cube: With feet
2.76 Rubiks Clock
1.92 5x5 Cube: Blindfolded (I'm responsible for 5.6% of that with a single solve

)
1.46 Rubiks Magic
1.24 Master Magic

(this is more now because it's all-time, not just until Sarah's January 30 limit)

Code:

select round(sum(value1*(value1>0) + value2*(value2>0) + value3*(value3>0) + value4*(value4>0) + value5*(value5>0))/60/60/24)/100, events.name
from results, events
where events.id=eventId
group by eventId
order by 1 desc

Stefan · May 1, 2011

qqwref said:
I think a DNF ought to count as a solve (although a DNS oughtn't).

DNF is an "attempt", but no "solve" (at least usually). Ok, you could say it's "solve time" in the sense of time spent *trying* to solve. But the other reason to not count it is that we just don't have the data

timeless said:
i said shouldnt

You didn't say it but asked it, suggesting surprise/disbelief/disagreement.

But mainly I just wanted to complain about your disrespectful writing.

Carrot · May 1, 2011

another one, who has the highest 4x4x4:megaminx ratio? (I want a list for both single and average)

MaeLSTRoM · May 1, 2011

Wouldn't a high ratio mean really slow on one and fast on the other? Are you sure that's what you want?

Carrot · May 1, 2011

MaeLSTRoM said:
Wouldn't a high ratio mean really slow on one and fast on the other? Are you sure that's what you want?

yes, I want to see who is slow at 4x4x4 but fast at megaminx =D

kinch2002 · May 1, 2011

On the WCA stats page there is the top 10 sum of average and single ranks list. If someone could make a full list (or top 100 if that's too much) of those stats rather than just the top 10 I'd love to see it

Also, another thing that might be interesting: A similar list (sum of averages/single) but for countries i.e. take the top ranked place in every event for each country and sum them - I guess USA, Hungary, Netherlands and Australia would be right up there.

caseyd · May 1, 2011

~Phoenix Death~ said:
There's only 4 Calvins, and I'm one of them.

Im one of 2 Caseys

Stefan · May 1, 2011

Odder said:
another one, who has the highest 4x4x4:megaminx ratio? (I want a list for both single and average)

Single (top until under 1/1, and bottom 10):

Code:

444/mi     444    minx  who
-----------------------------------------------
1.4718  162.86  110.65  Irène Mallordy
1.4376  129.69   90.21  Luigi Lunardon
1.4193   84.96   59.86  Karina Grandjean Beck
1.3759  189.45  137.69  Yann Leenhardt
1.2902  311.09  241.11  Solène Krebs
1.2752  106.68   83.66  Jek Villacampa
1.2510   78.56   62.80  Koo Chun Ki (顧俊祺)
1.2312   75.18   61.06  Bingliang Li (李炳良)
1.2253   65.47   53.43  David Gugl
1.1994   81.09   67.61  Aidan Wolter
1.1601  281.08  242.28  Yiting Yu (余益婷)
1.1012  104.50   94.90  Daniel Hayes
1.0963   99.86   91.09  Tonia Kwasniewska
1.0941   68.72   62.81  Jonathan Cookmeyer
1.0897  102.16   93.75  Yu Da-Hyun
1.0866  181.00  166.58  Patrick Tran
1.0751   96.96   90.19  Ronan Felipe Jorge
1.0692   93.91   87.83  Russell Angelo Fernandez
1.0623   60.91   57.34  Oscar Roth Andersen
1.0602   99.22   93.59  Kevin Westermann
1.0494  126.47  120.52  Andy Collentro
1.0348   64.53   62.36  Giuliano Cayetano
1.0198   83.50   81.88  Michal Matczak
1.0112   48.06   47.53  Bálint Bodor
1.0063   91.40   90.83  Piyachat Jamsai
0.9996   77.55   77.58  Andrew Sopchak
...
0.1782   53.59  300.72  The Quyen Pham
0.1779   48.59  273.13  Nicholas Ho
0.1709   49.44  289.21  Thom Barlow
0.1658   69.84  421.30  Ignacio Soto Bustos
0.1647   78.41  476.19  Rahul Kadukar
0.1645   44.21  268.71  Hsuan Chang (張璿)
0.1608   91.27  567.66  Neil Xia
0.1513   48.68  321.84  Kian Barry
0.1236   57.66  466.32  Rama Temmink
0.0979   55.38  565.46  Chris Hardwick

Never thought I'd see Chris take last place somewhere (of 1056 people in this case).

Average:

Code:

444/mi     444    minx  who
-----------------------------------------------
1.5561  146.66   94.25  Russell Angelo Fernandez
1.5016  142.04   94.59  Ronan Felipe Jorge
1.3700  118.97   86.84  Jek Villacampa
1.3578   96.57   71.12  Koo Chun Ki (顧俊祺)
1.3350   90.18   67.55  Karina Grandjean Beck
1.1933   86.29   72.31  Aidan Wolter
1.1891   79.53   66.88  Bingliang Li (李炳良)
1.1888   72.65   61.11  David Gugl
1.1870  122.83  103.48  Daniel Hayes
1.1564  225.44  194.95  Rinaldo Pitzer Junior
1.1109   67.21   60.50  Oscar Roth Andersen
1.0865  119.24  109.75  Shuohong Wang (王硕鸿)
1.0864   77.23   71.09  Matic Omulec
1.0830  112.18  103.58  Yu Da-Hyun
1.0805  112.67  104.28  Kevin Westermann
1.0740   95.32   88.75  Ramón Dersch
1.0684   98.19   91.90  Laetitia Lemoine
1.0647   71.24   66.91  Giuliano Cayetano
1.0496   54.00   51.45  Bálint Bodor
1.0456  112.62  107.71  Choi Do-Hee
1.0197   86.98   85.30  Andrew Sopchak
1.0184  108.76  106.79  Piyachat Jamsai
1.0178   78.89   77.51  Jeremi Niedziela
1.0093  338.75  335.63  Jialin Liu (刘佳琳)
1.0016   60.88   60.78  Mariano DImperio
0.9979   79.89   80.06  Marshal Nathan
...
0.2205   80.72  366.02  Donglei Li (李冬雷)
0.2194   58.85  268.20  Jimmy Coll
0.2194   74.56  339.87  Adam Wills
0.2174   60.56  278.52  Tobias Daneels
0.2152   73.05  339.45  Stephanie Chow
0.2054   64.65  314.70  Daniel Lundwall
0.2022   77.12  381.39  Ton Dennenbroek
0.2002   64.31  321.21  The Quyen Pham
0.1944   58.09  298.81  Antoine Piau
0.1796   52.25  290.98  Pierre Lemerle

Code:

select s4.best/sm.best, s4.best/100, sm.best/100, persons.name
from
(select personId, best from rankssingle where eventId='444') s4,
(select personId, best from rankssingle where eventId='minx') sm,
persons
where s4.personId=sm.personId and persons.id=s4.personId
order by 1 desc;

select s4.best/sm.best, s4.best/100, sm.best/100, persons.name
from
(select personId, best from ranksaverage where eventId='444') s4,
(select personId, best from ranksaverage where eventId='minx') sm,
persons
where s4.personId=sm.personId and persons.id=s4.personId
order by 1 desc;

MrIndianTeen · May 1, 2011

caseyd said:
Im one of 2 Caseys

Well I'm the ONLY Aaroh (H is not a typo)

Carrot · May 1, 2011

thanks a lot =)

vcuber13 · May 1, 2011

id like to know whos slow at 3x3 but fast at sq1, andrew will likely be first

Stefan · May 1, 2011

kinch2002 said:
On the WCA stats page there is the top 10 sum of average and single ranks list. If someone could make a full list (or top 100 if that's too much) of those stats rather than just the top 10 I'd love to see it

But that would make Feliks visible.
(that's right, I'm mocking him for not being a top 10 all-rounder

)

I've been thinking about linking to a longer version of each of those stats, might do that and make this one show the top 100.

kinch2002 said:
Also, another thing that might be interesting: A similar list (sum of averages/single) but for countries i.e. take the top ranked place in every event for each country and sum them - I guess USA, Hungary, Netherlands and Australia would be right up there.

Interesting idea...

Stefan · May 1, 2011

vcuber13 said:
id like to know whos slow at 3x3 but fast at sq1, andrew will likely be first

If you mean Andrew Nelson... no, he's single place 7 and average place 8. Guess again?

vcuber13 · May 1, 2011

but hes like 18 3x3 and 16 sq1 is he not? idk anyone else faster st sq1 (forte used to be but not anymore)
binglinang li?
likely poitr

Stefan · May 1, 2011

333/sq1 single:

Code:

333/sq1    333    sq1   who
-----------------------------------------------
1.9940   63.33  31.76   Mike Godfrey 
1.6724   22.46  13.43   Ruzhen Ye (叶儒臻) 
1.6257   19.59  12.05   Jianwei Zhu (朱剑伟) 
1.4800   25.19  17.02   Qirun Zhong 
1.4046   22.15  15.77   Kazuhito Iimura 
1.3854   22.25  16.06   Jiashun Liu (刘佳顺) 
1.3220   14.41  10.90   Andrew Nelson 
1.3121   16.90  12.88   Gabriel Bucsan 
1.3080   43.40  33.18   Justin Eimers 
1.2618   12.53   9.93   Piotr Michal Padlewski 
1.2194   14.56  11.94   Martin Zahradník 
1.2029   19.21  15.97   Jörg Seidler 
1.1964   14.68  12.27   Ming Zheng (郑鸣) 
1.1669   37.96  32.53   Jiaming Li (李嘉明) 
1.1652   19.33  16.59   Libing Wang (王梨兵) 
1.1561   15.63  13.52   Alexandra Daryl Ariawan 
1.1283   25.41  22.52   Thomas Woodroffe 
1.1256   12.55  11.15   Dene Beardsley 
1.1156    9.65   8.65   Bingliang Li (李炳良) 
1.1097   34.80  31.36   Lei Shi (时雷) 
1.0447   22.22  21.27   Gabriela Gierasimiuk 
1.0369   16.30  15.72   Choi Ha-Ram 
1.0263   14.46  14.09   Neil Wu 
1.0249   14.43  14.08   Park Sang-Min 
1.0224   22.78  22.28   Mikolaj Stepczak 
1.0154   22.45  22.11   Xuan Pei (裴旋) 
1.0104   18.52  18.33   Stefan Lidström 
0.9939   14.66  14.75   François Courtès 
...

0.0687   10.86  158.05   Erik Johnson 
0.0669    7.75  115.81   Giovanni Contardi 
0.0600   10.61  176.70   James Benedict Cañares 
0.0519   13.84  266.58   Angelo Mauricio Adasme Alfaro 
0.0497    9.28  186.71   Piotr Frankowski 
0.0420   13.28  316.34   Ton Dennenbroek 
0.0352   13.88  394.81   Florian Kreyßig 
0.0351   18.90  538.52   Benjamin Jose Enriquez 
0.0351    8.81  250.80   Mitsuki Gunji 
0.0270   10.30  381.01   Chia-Wei Lu

333/sq1 average:

Code:

333/sq1    333    sq1   who
-----------------------------------------------
1.6229   23.71   14.61   Jianwei Zhu (朱剑伟) 
1.5614   25.95   16.62   Kazuhito Iimura 
1.4927   29.54   19.79   Jiashun Liu (刘佳顺) 
1.4487   23.99   16.56   Ruzhen Ye (叶儒臻) 
1.2189   26.84   22.02   Qirun Zhong 
1.1600   24.58   21.19   Libing Wang (王梨兵) 
1.1557   28.58   24.73   Xuan Pei (裴旋) 
1.1448   18.26   15.95   Andrew Nelson 
1.1389   15.25   13.39   Piotr Michal Padlewski 
1.1322   25.10   22.17   Gabriela Gierasimiuk 
1.0753   46.96   43.67   Justin Eimers 
1.0731   68.53   63.86   Stephen Lane 
1.0676   19.43   18.20   Gabriel Bucsan 
1.0504   16.87   16.06   Ming Zheng (郑鸣) 
1.0448   23.79   22.77   Jörg Seidler 
1.0404   25.49   24.50   Xinnan Ye (叶新楠) 
1.0398   22.23   21.38   François Courtès 
1.0319   29.12   28.22   Thomas Woodroffe 
1.0195   16.73   16.41   Tomas Kristiansson 
1.0062   40.84   40.59   Jiaming Li (李嘉明) 
0.9822   12.15   12.37   Bingliang Li (李炳良) 
...
0.0895   21.98  245.70   Daniel Lo 
0.0877   14.35  163.69   Chris Hardwick 
0.0862   21.24  246.52   Rodrigo Ybarra de Oliveira Ribeiro 
0.0711   13.04  183.31   Chi-Fan Li (李啟帆) 
0.0704   12.58  178.72   Erik Johnson 
0.0670   10.21  152.36   Phillip Espinoza 
0.0658   22.56  342.65   Mitko Prodanov 
0.0587   13.48  229.53   Luchen Zhang (张录辰) 
0.0486   18.09  372.00   Nikhil Mande 
0.0352   14.05  398.81   Daniel Lundwall

Odd WCA stats/ Stats request Thread

Premium Member

Veteran

Legend

Legend

Veteran

Legend

Legend

Veteran

Veteran

Veteran

Premium Member

Regular

Legend

Veteran

Veteran

Veteran

Legend

Legend

Veteran

Legend

Similar threads