Odd WCA stats/ Stats request Thread

[Stefan]

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

About 38.

Could you make the list again ... I'd appreciate that

When I'm in the mood again

(A reason I didn't mention is that the multi formats are slightly annoying to work with, and I didn't really want to)

 

[DavidWoner]

Time for me to be petty and whiny and self-serving here.

http://www.worldcubeassociation.org/results/statistics.php#15

My WR was on Friday, Rowe's was Saturday. I should have one more day than him

Are all of the results from multi-day competitions based from the first day?

 

[Stefan]

Are all of the results from multi-day competitions based from the first day?

They are, sorry. The database doesn't know when a solve was done. I added a note that at least explains this.

 

[DavidWoner]

They are, sorry. The database doesn't know when a solve was done. I added a note that at least explains this.

Ah, that's cool. I can't really imagine a way to solve the issue without altering data entry procedures.

I also noticed that Mate's record is about to hit 1000 days. It would be cool to see a list of the longest-held WRs, not just the oldest current records. Obviously Minh's record is first, but Mate's is second isn't it?

 

[Robert-Y]

Does the top ten longest standing world records ever change much, if it was measured in number of competitions passed?...

 

[Stefan]

I also noticed that Mate's record is about to hit 1000 days. It would be cool to see a list of the longest-held WRs, not just the oldest current records. Obviously Minh's record is first, but Mate's is second isn't it?

I think it's like this:

1) Minh Thai      3x3x3 single    7749 days
2) (guess)        (guess)         1316 days
3) Tim Habermaas  old multiblind  1143 days
4) Máté Horváth   MMagic average   990 days

 

[Pedro]

I think it's like this:

1) Minh Thai      3x3x3 single    7749 days
2) (guess)        (guess)         1316 days
3) Tim Habermaas  old multiblind  1143 days
4) Máté Horváth   MMagic average   990 days

Stefan Pochmann...megaminx, maybe?

 

[clement]

Mirek Goljan, 333fm

 

[Stefan]

Stefan Pochmann...megaminx, maybe?

No way, they never stood long (max 356 days) as I kept breaking them myself and then Erik took over. Might be interesting to look at persons rather than records, i.e., how long someone had the WR (not resetting when they broke it themselves).

And Mirek fewest moves is of course correct.

 

[qqwref]

As far as old multi, I think time should effectively end when the event was removed. So Tim would hold it from the time of setting until the time the event died, not until now.

I agree, it would definitely be interesting to see a list of the top 10 or so if you count records by the same person together

 

[AustinReed]

2) (guess) (guess) 1316 days

Kuti for BLD?

 

[RyanReese09]

And Mirek fewest moves is of course correct.

Kuti for BLD?

CLOSE!

 

[5BLD]

Just got into feet cubing, and I was wondering... Is there anyone who is faster with their feet than with their hands?

 

[qqwref]

There was a guy at a California comp several years ago who didn't have hands. Does that count?

 

[5BLD]

I guess so. Although he can't exactly be classified as being 'faster at feet than hands' since he can't do hands.

 

[Stefan]

Was it this guy?
http://www.worldcubeassociation.org/results/p.php?i=2005ARNO01

 

[vcuber13]

http://www.worldcubeassociation.org/results/p.php?i=2005ARNO01
ninja'd

 

[Stefan]

Hands vs feet, single:

hnd/ft   hand    feet  who
------------------------------------------------------
 0.53   31.46   59.22 [url=http://www.worldcubeassociation.org/results/p.php?i=2007KOLL01]Mats Kollbrink[/url]
 0.40   14.69   36.94 [url=http://www.worldcubeassociation.org/results/p.php?i=2007JEEH01]Chang Jee-Hoon[/url]
 0.37   15.83   42.78 [url=http://www.worldcubeassociation.org/results/p.php?i=2007CINO01]Rafael Werneck Cinoto[/url]
 0.37   16.90   46.06 [url=http://www.worldcubeassociation.org/results/p.php?i=2008JUNG01]Lee Jung-Hyun[/url]
 0.31   28.61   92.18 [url=http://www.worldcubeassociation.org/results/p.php?i=2008EUNG01]Lee Eung-Chang[/url]
 0.28   13.53   48.28 [url=http://www.worldcubeassociation.org/results/p.php?i=2008MIHA01]Zalán Mihály[/url]
 0.28   28.34  102.26 [url=http://www.worldcubeassociation.org/results/p.php?i=2004WOLF01]Oliver Wolff[/url]
 0.27   13.09   49.27 [url=http://www.worldcubeassociation.org/results/p.php?i=2009BOON04]Tong Boonrod[/url]
 0.26   39.08  151.28 [url=http://www.worldcubeassociation.org/results/p.php?i=2007BRAU01]Erica Sumoyama Braune[/url]
 0.26   11.31   44.08 [url=http://www.worldcubeassociation.org/results/p.php?i=2008TAKA01]Yuhei Takagi (高木佑平)[/url]

SELECT a.record/b.record ratio, a.record/100 ar, b.record/100 br, a.personId, a.personName
FROM
(SELECT personId, personName, min(best) record FROM Results WHERE eventi='333' AND best>0 GROUP BY personId) a,
(SELECT personId,             min(best) record FROM Results WHERE eventi='333ft' AND best>0 GROUP BY personId) b
where a.personId = b.personId
order by ratio desc
limit 10;

Average:

hnd/ft   hand    feet  who
------------------------------------------------------
 0.54   37.18   68.26 [url=http://www.worldcubeassociation.org/results/p.php?i=2007KOLL01]Mats Kollbrink[/url]
 0.37   19.00   51.00 [url=http://www.worldcubeassociation.org/results/p.php?i=2007CINO01]Rafael Werneck Cinoto[/url]
 0.37   20.25   55.38 [url=http://www.worldcubeassociation.org/results/p.php?i=2008JUNG01]Lee Jung-Hyun[/url]
 0.31   16.08   52.25 [url=http://www.worldcubeassociation.org/results/p.php?i=2007JEEH01]Chang Jee-Hoon[/url]
 0.29   50.37  170.81 [url=http://www.worldcubeassociation.org/results/p.php?i=2007BRAU01]Erica Sumoyama Braune[/url]
 0.28   14.89   54.01 [url=http://www.worldcubeassociation.org/results/p.php?i=2009POZS01]Péter Pozsgai[/url]
 0.27   10.90   39.98 [url=http://www.worldcubeassociation.org/results/p.php?i=2005VANH01]Anssi Vanhala[/url]
 0.27   14.40   54.08 [url=http://www.worldcubeassociation.org/results/p.php?i=2008MIHA01]Zalán Mihály[/url]
 0.26   12.97   49.60 [url=http://www.worldcubeassociation.org/results/p.php?i=2008YUNS02]Nam Yun-Su[/url]
 0.26   14.50   55.53 [url=http://www.worldcubeassociation.org/results/p.php?i=2009LLAN01]Marvin Llaneta[/url]

 

[5BLD]

Thanks, stefan.
So the answer is nobody.

 

[Stefan]

Two-handed vs one-handed, single:

th/oh    th      oh   who
------------------------------------------------------
 1.38   81.33   59.12 [url=http://www.worldcubeassociation.org/results/p.php?i=2011CARU01]Martín Carusso[/url]
 1.18   31.02   26.33 [url=http://www.worldcubeassociation.org/results/p.php?i=2010OKAM02]Scott Okamura[/url]
 1.07   29.46   27.43 [url=http://www.worldcubeassociation.org/results/p.php?i=2010YUDA01]Ahmad Leo Yudanto[/url]
 1.07  307.36  287.05 [url=http://www.worldcubeassociation.org/results/p.php?i=2010HAOZ01]Zhiqiang Hao (郝志强)[/url]
 1.01   21.21   20.90 [url=http://www.worldcubeassociation.org/results/p.php?i=2009LINX01]Xu Lin (林徐)[/url]
 1.01   14.16   14.06 [url=http://www.worldcubeassociation.org/results/p.php?i=2009SUKH01]Sittinon Sukhaya[/url]
 0.93   17.93   19.22 [url=http://www.worldcubeassociation.org/results/p.php?i=2010LIUH01]Hanhan Liu (刘含菡)[/url]
 0.90   25.13   27.97 [url=http://www.worldcubeassociation.org/results/p.php?i=2008MEIZ01]Zeming Mei (梅泽铭)[/url]
 0.89   11.03   12.43 [url=http://www.worldcubeassociation.org/results/p.php?i=2008VARG01]Dániel Varga[/url]
 0.87   17.50   20.19 [url=http://www.worldcubeassociation.org/results/p.php?i=2009PUTR05]Hadrian Josna Putra[/url]

SELECT a.record/b.record ratio, a.record/100 ar, b.record/100 br, a.personId, a.personName
FROM
(SELECT personId, personName, min(best) record FROM Results WHERE eventId='333' AND best>0 GROUP BY personId) a,
(SELECT personId,             min(best) record FROM Results WHERE eventId='333oh' AND best>0 GROUP BY personId) b
where a.personId = b.personId
order by ratio desc
limit 10;

Average:

th/oh    th      oh   who
------------------------------------------------------
 1.11   32.50   29.21 [url=http://www.worldcubeassociation.org/results/p.php?i=2010OKAM02]Scott Okamura[/url]
 1.09   25.42   23.32 [url=http://www.worldcubeassociation.org/results/p.php?i=2009LINX01]Xu Lin (林徐)[/url]
 1.01   17.12   17.01 [url=http://www.worldcubeassociation.org/results/p.php?i=2009SUKH01]Sittinon Sukhaya[/url]
 0.95   87.99   92.42 [url=http://www.worldcubeassociation.org/results/p.php?i=2011CARU01]Martín Carusso[/url]
 0.93   31.13   33.39 [url=http://www.worldcubeassociation.org/results/p.php?i=2010YUDA01]Ahmad Leo Yudanto[/url]
 0.91   24.63   27.03 [url=http://www.worldcubeassociation.org/results/p.php?i=2010CHEN53]Rongwei Chen (陈榕伟)[/url]
 0.84   25.73   30.46 [url=http://www.worldcubeassociation.org/results/p.php?i=2009YINC03]Chan Yui Yin[/url]
 0.84   29.54   35.06 [url=http://www.worldcubeassociation.org/results/p.php?i=2009PAMA01]Brian Pamandanan[/url]
 0.84   16.00   19.00 [url=http://www.worldcubeassociation.org/results/p.php?i=2009TAND01]Ramble Tandar[/url]
 0.83   21.17   25.50 [url=http://www.worldcubeassociation.org/results/p.php?i=2010KLAE01]Arut Klaewkasetkorn[/url]