Michael Womack
Legend
- Joined
- Sep 4, 2011
- Messages
- 4,365
- Location
- Louisville, Kentucky, United States
- WCA ID
- 2010WOMA01
- YouTube
- Visit Channel
Thanks
Odd WCA stats/ Stats request Thread
- Thread starter anders
- Start date
Thanks
Stefan
Legend
More fewest moves, number of sub30s/sub31s:
Code:
mysql> select count(*) successes, round(avg(moves),2) average,name FROM (
-> SELECT personId, value1 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value2 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value3 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value4 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value5 moves FROM Results WHERE eventId='333fm') tmp,
-> Persons
-> WHERE moves between 1 and 29 and Persons.id=personId and subId=1
-> GROUP BY personId
-> ORDER BY successes desc, average, name;
+-----------+---------+-------------------------------------+
| successes | average | name |
+-----------+---------+-------------------------------------+
| 18 | 27.78 | Sébastien Auroux |
| 7 | 26.86 | Erik Akkersdijk |
| 7 | 27.43 | Clément Gallet |
| 6 | 28.50 | Milán Baticz |
| 5 | 27.20 | Teemu Tiinanen |
| 5 | 27.80 | Daniel Sheppard |
| 4 | 27.75 | Grzegorz ?uczyna |
| 4 | 28.00 | Tomoaki Okayama (????) |
| 3 | 27.33 | Tim Reynolds |
| 3 | 27.67 | Mats Valk |
| 3 | 28.00 | Arnaud van Galen |
| 3 | 28.00 | Jan Bentlage |
| 3 | 28.67 | Kanneti Sae Han (????????? ???????) |
| 2 | 26.00 | Guus Razoux Schultz |
| 2 | 27.00 | David Woner |
| 2 | 27.50 | Guillain Potron |
| 2 | 28.00 | Henrik Buus Aagaard |
| 2 | 28.00 | Simon Westlund |
| 2 | 28.50 | Loïc Petit |
| 2 | 28.50 | Mirek Goljan |
| 1 | 22.00 | István Kocza |
| 1 | 22.00 | Jimmy Coll |
| 1 | 25.00 | Baiqiang Dong (???) |
| 1 | 25.00 | Ron van Bruchem |
| 1 | 26.00 | Olivér Perge |
| 1 | 27.00 | Claudio Müller |
| 1 | 27.00 | Fang Qin (??) |
| 1 | 27.00 | Michael Young |
| 1 | 27.00 | Mikhail Rostovikov |
| 1 | 27.00 | Stephen Adhisaputra |
| 1 | 27.00 | Steven Xu |
| 1 | 28.00 | Antoine Perdereau |
| 1 | 28.00 | Anton Rostovikov |
| 1 | 28.00 | Evgeny Akivis |
| 1 | 28.00 | Jack Moseley |
| 1 | 28.00 | Javier Cabezuelo Sánchez |
| 1 | 28.00 | Mario Laurent |
| 1 | 28.00 | Micha? Pleskowicz |
| 1 | 28.00 | Nicolas Fruy |
| 1 | 28.00 | Olivier Stietel |
| 1 | 28.00 | Philippe Virouleau |
| 1 | 28.00 | Shuang Chen (??) |
| 1 | 28.00 | Zbigniew Zborowski |
| 1 | 29.00 | Alexander Olleta del Molino |
| 1 | 29.00 | Andres Flügel |
| 1 | 29.00 | Anthony Hsu |
| 1 | 29.00 | Auguste Olivry |
| 1 | 29.00 | Dániel Varga |
| 1 | 29.00 | Dennis Loose |
| 1 | 29.00 | Hongfei Tian (???) |
| 1 | 29.00 | Johannes Laire |
| 1 | 29.00 | Juan Juli Andika Chandra |
| 1 | 29.00 | Lorenzo Vigani Poli |
| 1 | 29.00 | Sam Boyles |
| 1 | 29.00 | Tobias Christlieb |
| 1 | 29.00 | Vidar Klungre |
| 1 | 29.00 | Yumu Tabuchi (????) |
| 1 | 29.00 | Yunqi Ouyang (????) |
+-----------+---------+-------------------------------------+
58 rows in set (0.25 sec)
Code:
mysql> select count(*) successes, round(avg(moves),2) average,name FROM (
-> SELECT personId, value1 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value2 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value3 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value4 moves FROM Results WHERE eventId='333fm' union all
-> SELECT personId, value5 moves FROM Results WHERE eventId='333fm') tmp,
-> Persons
-> WHERE moves between 1 and 30 and Persons.id=personId and subId=1
-> GROUP BY personId
-> ORDER BY successes desc, average, name;
+-----------+---------+-----------------------------------------------+
| successes | average | name |
+-----------+---------+-----------------------------------------------+
| 27 | 28.52 | Sébastien Auroux |
| 10 | 27.80 | Erik Akkersdijk |
| 9 | 28.00 | Clément Gallet |
| 7 | 28.71 | Milán Baticz |
| 5 | 27.20 | Teemu Tiinanen |
| 5 | 27.80 | Daniel Sheppard |
| 5 | 28.40 | Guus Razoux Schultz |
| 4 | 27.75 | Grzegorz ?uczyna |
| 4 | 28.00 | Tim Reynolds |
| 4 | 28.00 | Tomoaki Okayama (????) |
| 4 | 28.25 | Mats Valk |
| 3 | 28.00 | Arnaud van Galen |
| 3 | 28.00 | Jan Bentlage |
| 3 | 28.67 | Kanneti Sae Han (????????? ???????) |
| 3 | 29.00 | Loïc Petit |
| 3 | 29.33 | Shuang Chen (??) |
| 2 | 27.00 | David Woner |
| 2 | 27.50 | Guillain Potron |
| 2 | 28.00 | Henrik Buus Aagaard |
| 2 | 28.00 | Olivér Perge |
| 2 | 28.00 | Simon Westlund |
| 2 | 28.50 | Mirek Goljan |
| 2 | 29.00 | Antoine Perdereau |
| 2 | 29.00 | Jack Moseley |
| 2 | 29.00 | Mario Laurent |
| 2 | 29.00 | Philippe Virouleau |
| 2 | 29.50 | Johannes Laire |
| 2 | 29.50 | Yunqi Ouyang (????) |
| 2 | 30.00 | Bence Barát |
| 2 | 30.00 | Jacco Krijnen |
| 2 | 30.00 | Maarten Smit |
| 1 | 22.00 | István Kocza |
| 1 | 22.00 | Jimmy Coll |
| 1 | 25.00 | Baiqiang Dong (???) |
| 1 | 25.00 | Ron van Bruchem |
| 1 | 27.00 | Claudio Müller |
| 1 | 27.00 | Fang Qin (??) |
| 1 | 27.00 | Michael Young |
| 1 | 27.00 | Mikhail Rostovikov |
| 1 | 27.00 | Stephen Adhisaputra |
| 1 | 27.00 | Steven Xu |
| 1 | 28.00 | Anton Rostovikov |
| 1 | 28.00 | Evgeny Akivis |
| 1 | 28.00 | Javier Cabezuelo Sánchez |
| 1 | 28.00 | Micha? Pleskowicz |
| 1 | 28.00 | Nicolas Fruy |
| 1 | 28.00 | Olivier Stietel |
| 1 | 28.00 | Zbigniew Zborowski |
| 1 | 29.00 | Alexander Olleta del Molino |
| 1 | 29.00 | Andres Flügel |
| 1 | 29.00 | Anthony Hsu |
| 1 | 29.00 | Auguste Olivry |
| 1 | 29.00 | Dániel Varga |
| 1 | 29.00 | Dennis Loose |
| 1 | 29.00 | Hongfei Tian (???) |
| 1 | 29.00 | Juan Juli Andika Chandra |
| 1 | 29.00 | Lorenzo Vigani Poli |
| 1 | 29.00 | Sam Boyles |
| 1 | 29.00 | Tobias Christlieb |
| 1 | 29.00 | Vidar Klungre |
| 1 | 29.00 | Yumu Tabuchi (????) |
| 1 | 30.00 | Balázs Bernát |
| 1 | 30.00 | Carlos Alberto de Alcântara Jr |
| 1 | 30.00 | Chester Lian |
| 1 | 30.00 | Chonlathep Kitsinthopchai (????? ???????????) |
| 1 | 30.00 | Chris Hardwick |
| 1 | 30.00 | Dmitry Karyakin |
| 1 | 30.00 | Dmitry Krivoshey |
| 1 | 30.00 | Erik Jernqvist |
| 1 | 30.00 | Frédéric Meinnel |
| 1 | 30.00 | Gunnar Krig |
| 1 | 30.00 | Guus de Wit |
| 1 | 30.00 | Jens Diewald |
| 1 | 30.00 | Justin Jaffray |
| 1 | 30.00 | Ralph Eikelenberg |
| 1 | 30.00 | Reinier Schippers |
| 1 | 30.00 | Timothy Sun |
| 1 | 30.00 | Wilson Alvis |
| 1 | 30.00 | Yucheng Lu (???) |
| 1 | 30.00 | ?ukasz Cia?o? |
+-----------+---------+-----------------------------------------------+
80 rows in set (0.26 sec)
vcuber13
Veteran
Stefan
Legend
Much nicer, thank you. What program did you use for that?
vcuber13
Veteran
Mathematica 8
Code:
number = {2, 0, 3, 4, 11, 24, 33, 46, 55, 71, 92, 112, 107, 130, 166, 174, 146, 175, 154, 154, 157, 137, 143, 143, 129, 112, 110, 121,
81, 77, 82, 53, 49, 57, 39, 33, 19, 22, 28, 11, 11, 13, 13, 7, 9, 6, 4, 6, 5, 4, 1, 3, 0, 2, 2, 2}
ints = Table[i, {i, 22, 77}]
SetOptions[BarChart, BaseStyle -> {FontSize -> 20, Bold}]
BarChart[number, ChartStyle -> 60, LabelingFunction -> Above, ChartLabels -> ints, BarSpacing -> 1/5, ImageSize -> {2000}]Tim Reynolds
Premium Member
Yeah, John and I fail at failing.
Michał Halczuk, Erik Johnson, Darren Kwong, and Luchen Zhang are tied at 8. Kare Krig, Rowan Kinneavy, and Michael Young have 7. Karthik Putraya, Howard Wong Jun Yen, Dhanayush Raninga, Philippe Virouleau, and Filippo Brancaleoni have 6. No clear leaders right now.
Most distinct events won:
Bence Barat: 18 (everything but 4x4 BLD)
Timothy Sun: 17 (everything but 6x6 and 5x5 BLD)
Erik Akkersdijk: 17 (everything but 4x4 BLD and 5x5 BLD)
Simon Westlund: 16 (3x3 BLD, 3x3 OH, 4x4 BLD)
Feliks Zemdegs: 16 (Magic, Master Magic, Feet)
Milan Baticz: 16 (4x4 BLD, 5x5 BLD, Feet)
Henrik Buus Aagard: 15 (4x4, Pyraminx, 7x7, 5x5 BLD)
Dan Cohen: 15 (Feet, 4x4 BLD, 5x5 BLD, Multi BLD)
Bernett Orlando: 15 (Clock, 6x6, Magic, Master Magic)
uberCuber
Legend
^ After this happened in the OAQT, now I'm curious, are there people with official 2x2 results that are absurdly good compared to their 3x3 results?
Stefan
Legend
Top 50 by ratio between 3x3 average record and 2x2 average record:
Code:
mysql> SELECT round(a3/100,2) avg3, round(a2/100,2) avg2, round(a3/a2,2) ratio, personName name FROM
-> (SELECT personId, personName, min(average) a2 FROM Results WHERE eventId='222' and average between 1 and 999 GROUP BY personId) t2,
-> (SELECT personId, min(average) a3 FROM Results WHERE eventId='333' and average>0 GROUP BY personId) t3
-> WHERE t2.personId = t3.personId
-> ORDER BY a3/a2 desc
-> LIMIT 50;
+-------+------+-------+---------------------------------+
| avg3 | avg2 | ratio | name |
+-------+------+-------+---------------------------------+
| 78.49 | 7.59 | 10.34 | Piet Wetenkamp |
| 48.29 | 6.75 | 7.15 | Jelome Empedrad |
| 43.40 | 6.10 | 7.11 | Nathan Seeto |
| 54.87 | 7.88 | 6.96 | David Bockman |
| 42.36 | 6.10 | 6.94 | Luis Garcés Méndez |
| 55.65 | 8.31 | 6.70 | Ammar Haider |
| 26.87 | 4.05 | 6.63 | Sebastian Deimel |
| 40.23 | 6.22 | 6.47 | Tomasz Bartkowiak |
| 31.15 | 4.83 | 6.45 | Ties de Wit |
| 17.16 | 2.81 | 6.11 | Yui Tomita (????) |
| 31.49 | 5.19 | 6.07 | Kim Jae-Min |
| 44.87 | 7.43 | 6.04 | Cameron Drysdale |
| 59.72 | 9.91 | 6.03 | Sietse Vos |
| 43.20 | 7.27 | 5.94 | Lei Shi (??) |
| 54.59 | 9.26 | 5.90 | Fabian Erkemeij |
| 19.37 | 3.30 | 5.87 | Mina Tomita (????) |
| 31.17 | 5.33 | 5.85 | Chenxi Shan (???) |
| 50.33 | 8.61 | 5.85 | Andrés Alonso Gutiérrez Salinas |
| 55.76 | 9.54 | 5.84 | Kh?i Trí ?? |
| 37.47 | 6.43 | 5.83 | Zetis Nguyen |
| 24.69 | 4.25 | 5.81 | Kim Yong-Hun |
| 36.13 | 6.23 | 5.80 | Magda Gancarz |
| 19.23 | 3.33 | 5.77 | Junya Tomita (????) |
| 31.31 | 5.57 | 5.62 | Jure Vidmar |
| 16.59 | 2.96 | 5.60 | Kevin Guillaumond |
| 52.79 | 9.69 | 5.45 | Vighar Choirul Iqbal |
| 16.87 | 3.10 | 5.44 | Alexey Oblaukhov |
| 35.56 | 6.55 | 5.43 | Scott Leslie |
| 43.09 | 8.03 | 5.37 | Marek Gancarz |
| 12.00 | 2.25 | 5.33 | Cameron Stollery |
| 44.12 | 8.28 | 5.33 | Luis Arturo Peña Nemer |
| 46.25 | 8.74 | 5.29 | Jack DeLano |
| 44.09 | 8.36 | 5.27 | Daniel Schnoll |
| 37.56 | 7.13 | 5.27 | Kwak Hyoung-Jin |
| 29.57 | 5.62 | 5.26 | Filippo Di Biase |
| 41.49 | 7.93 | 5.23 | Brandon Turner |
| 26.23 | 5.04 | 5.20 | Kevin Gonzalez |
| 44.82 | 8.74 | 5.13 | Michael Womack |
| 31.16 | 6.09 | 5.12 | Darren Carpenter |
| 37.39 | 7.32 | 5.11 | Tam Jia Tern |
| 16.70 | 3.28 | 5.09 | ?ukasz Cia?o? |
| 27.73 | 5.45 | 5.09 | Sam Schultz |
| 31.35 | 6.20 | 5.06 | Corentin Levy |
| 16.83 | 3.33 | 5.05 | Will Ballard |
| 41.96 | 8.32 | 5.04 | Håvard Terland |
| 39.35 | 7.81 | 5.04 | Oleg Andreyev |
| 45.69 | 9.08 | 5.03 | Julián González Acevedo |
| 24.99 | 4.97 | 5.03 | Denzel Gutierrez |
| 13.38 | 2.67 | 5.01 | Zhou Yichen (???) |
| 32.22 | 6.44 | 5.00 | Justin Grant |
+-------+------+-------+---------------------------------+TMOY
Veteran
Well, at least for once Michael is right, Ties de Wit actually averages sup-30 on 3^3 and sub-5 on 2^3. He seems to be the only one, though (although Kim Jae-Min and Chenxi Shan are pretty close).
Robert-Y
Legend
What about the densest rounds sorted by average distance in percentage?
Thanks for all these stats so far, Stefan, they're quite interesting
Thanks for all these stats so far, Stefan, they're quite interesting
Michael Womack
Legend
- Joined
- Sep 4, 2011
- Messages
- 4,365
- Location
- Louisville, Kentucky, United States
- WCA ID
- 2010WOMA01
- YouTube
- Visit Channel
Thank you Phochmann for proving it for me
Sebastien
Premium Member
I'm sure it was a pleasure for him Whomack.
Stefan
Legend
I thought about that but didn't see an easy enough way to do that. For average absolute difference I can use the simple formula (worst-best)/(persons-1), ignoring all times between best and worst because they don't affect the average absolute difference (worthy of a proof if you have a minute). For average relative difference, that doesn't work, as the middle ones do matter (worthy of a proof if you have another minute). And I'm also not sure how to properly average it and whether this is really what I want.
So, well, let's pretend the middle ones are "evenly spaced" so that all pairs of adjacent ones are the same factor x apart, then
worst = best * x^(persons-1) and thus x = (persons-1)th root of worst/best
See below for results.
Or maybe someone with better math knowledge has a better definition of densest in relative terms? Large gaps would make the round look much less dense, but they would go unnoticed with this definition of mine. I'd like something that rewards both for small factors and for similar factors.
Code:
select competitionId, eventId, roundId, best, worst, round(power(worst/best,1/(persons-1)),4) avgFactor, persons from
(select competitionId, eventId, roundId, min(if(average>0,round(average/100,2),999999999)) best, max(if(average>0,round(average/100,2),999999999)) worst, count(*) persons
from Results
where roundId in ('f','c')
group by competitionId, eventId, roundId) helper
where persons>1 and worst<999999999
order by power(worst/best,1/(persons-1)), persons desc
limit 100;
+----------------------------+---------+---------+--------+--------+-----------+---------+
| competitionId | eventId | roundId | best | worst | avgFactor | persons |
+----------------------------+---------+---------+--------+--------+-----------+---------+
| CubeCanadaDay2011 | mmagic | f | 6.92 | 7.01 | 1.0130 | 2 |
| OGU2006 | sq1 | f | 46.45 | 47.14 | 1.0149 | 2 |
| IVBogota2012 | 444 | f | 54.97 | 57.76 | 1.0166 | 4 |
| WC2009 | 333 | f | 10.74 | 13.81 | 1.0169 | 16 |
| Euro2010 | 333 | f | 10.31 | 12.68 | 1.0174 | 13 |
| AachenSummer2012 | 333 | f | 9.68 | 18.78 | 1.0176 | 39 |
| HungarianOpen2009 | 555 | f | 91.49 | 119.00 | 1.0177 | 16 |
| TaipeiOpen2011 | 444 | f | 44.28 | 89.79 | 1.0178 | 41 |
| Euro2010 | 555 | f | 77.60 | 99.54 | 1.0179 | 15 |
| Euro2006 | 333 | f | 14.97 | 19.55 | 1.0180 | 16 |
| SuzhouOpen2011 | 333 | f | 11.97 | 14.59 | 1.0182 | 12 |
| MunichOpen2011 | 444 | f | 49.10 | 60.26 | 1.0188 | 12 |
| WC2007 | 333 | f | 12.46 | 16.51 | 1.0189 | 16 |
| BeijingSummer2011 | 333 | f | 12.60 | 15.80 | 1.0190 | 13 |
| HungarianOpen2009 | 444 | f | 51.57 | 68.99 | 1.0196 | 16 |
| Vastervik2008 | mmagic | f | 5.10 | 5.20 | 1.0196 | 2 |
| WC2003 | 333 | f | 20.00 | 22.92 | 1.0197 | 8 |
| WC2005 | 333 | f | 15.10 | 18.71 | 1.0197 | 12 |
| WC2009 | 555 | f | 78.20 | 104.80 | 1.0197 | 16 |
| Euro2010 | 333oh | f | 18.39 | 24.17 | 1.0197 | 15 |
| TaiwanSummerOpen2009 | 333 | f | 13.30 | 16.49 | 1.0197 | 12 |
| GuangdongOpen2009 | 333 | f | 11.83 | 20.57 | 1.0200 | 29 |
| RizalOpen2009 | 444 | f | 69.49 | 83.27 | 1.0203 | 10 |
| KansaiOpen2012 | 333 | f | 11.19 | 13.98 | 1.0204 | 12 |
| ThailandOpen2009 | 333 | f | 12.72 | 18.72 | 1.0205 | 20 |
| PhilippinesOpen2008 | 333 | f | 14.94 | 21.99 | 1.0206 | 20 |
| WC2009 | 444 | f | 45.18 | 61.48 | 1.0207 | 16 |
| SlovenianOpen2012 | 444 | f | 51.21 | 61.73 | 1.0210 | 10 |
| TaiwanSpring2010 | 333 | f | 12.45 | 15.65 | 1.0210 | 12 |
| HungarianOpen2010 | 333 | f | 12.39 | 15.58 | 1.0210 | 12 |
| Malang2011 | 222 | f | 6.35 | 16.29 | 1.0212 | 46 |
| USNationals2010 | 444 | f | 43.76 | 59.94 | 1.0212 | 16 |
| TaiwanSpringOpen2011 | 333 | f | 11.02 | 15.16 | 1.0215 | 16 |
| TaiwanSummerOpen2008 | 333 | f | 15.02 | 18.98 | 1.0215 | 12 |
| ThailandOpen2010 | 333 | f | 12.54 | 15.85 | 1.0215 | 12 |
| MunichOpen2010 | 444 | f | 48.82 | 67.84 | 1.0222 | 16 |
| StanfordWinter2010 | 333 | f | 12.69 | 16.20 | 1.0224 | 12 |
| GuangzhouBigCubes2010 | 555 | f | 84.76 | 92.64 | 1.0225 | 5 |
| HongKongCubeDay2010 | 444 | f | 55.60 | 66.42 | 1.0225 | 9 |
| WC2007 | 555 | f | 105.07 | 147.29 | 1.0228 | 16 |
| MNWOpen2011 | 333 | f | 11.79 | 15.11 | 1.0228 | 12 |
| Euro2008 | 333 | f | 11.71 | 16.48 | 1.0230 | 16 |
| WC2011 | 444 | f | 35.22 | 49.58 | 1.0231 | 16 |
| PolishOpen2009 | 333 | f | 11.81 | 15.20 | 1.0232 | 12 |
| GuangdongOpen2008 | 333 | f | 12.74 | 18.40 | 1.0232 | 17 |
| FinnishOpen2009 | mmagic | f | 5.56 | 5.69 | 1.0234 | 2 |
| USNationals2009 | 444 | f | 52.84 | 74.75 | 1.0234 | 16 |
| SingaporeOpen2009 | 333 | f | 12.96 | 15.96 | 1.0234 | 10 |
| EastGermanOpen2010 | 444 | f | 51.94 | 73.50 | 1.0234 | 16 |
| NewZealandChamps2009 | sq1 | f | 28.17 | 28.83 | 1.0234 | 2 |
| TorontoSpring2011 | 333 | f | 12.47 | 15.36 | 1.0234 | 10 |
| Euro2008 | 333oh | f | 21.79 | 30.85 | 1.0234 | 16 |
| TianjinOpen2011 | 333 | f | 13.56 | 15.95 | 1.0235 | 8 |
| ShenzhenSummerOpen2009 | 333 | f | 12.03 | 17.06 | 1.0236 | 16 |
| CubingKoreaJanuary2012 | 333 | f | 11.49 | 14.86 | 1.0237 | 12 |
| HumanRightsDay2011 | 444 | f | 44.30 | 66.15 | 1.0239 | 18 |
| USNationals2011 | 333 | f | 9.91 | 14.12 | 1.0239 | 16 |
| UKDWOpen2011 | 333 | f | 11.52 | 19.89 | 1.0240 | 24 |
| CubikBoxCup2011 | 333 | f | 10.26 | 14.65 | 1.0240 | 16 |
| IndonesianOpen2011 | 333 | f | 11.58 | 17.34 | 1.0240 | 18 |
| Shandong2010 | 333 | f | 15.64 | 24.62 | 1.0242 | 20 |
| Cheonan2008 | 333 | f | 13.63 | 17.74 | 1.0242 | 12 |
| AustrianOpen2011 | 333 | f | 10.83 | 14.10 | 1.0243 | 12 |
| BerkeleySummer2011 | 333 | f | 10.96 | 17.72 | 1.0243 | 21 |
| TaiwanSummer2010 | 333 | f | 10.71 | 16.14 | 1.0244 | 18 |
| MunichOpen2011 | 333 | f | 10.72 | 13.98 | 1.0244 | 12 |
| Netherlands2006 | 444 | f | 74.32 | 79.93 | 1.0246 | 4 |
| CaltechWinter2007 | 333 | f | 14.82 | 19.36 | 1.0246 | 12 |
| ShantouOpen2010 | 333oh | f | 24.95 | 37.74 | 1.0246 | 18 |
| Kuikuiltik2012 | 444 | f | 51.13 | 109.35 | 1.0248 | 32 |
| MatsudoOpen2010 | 444 | f | 48.05 | 54.34 | 1.0249 | 6 |
| SilesiaOpen2012 | 333 | f | 10.57 | 13.89 | 1.0251 | 12 |
| VCubeSpiel2011 | 333 | f | 10.58 | 24.63 | 1.0252 | 35 |
| USNationals2010 | 333 | f | 10.93 | 15.87 | 1.0252 | 16 |
| USNationals2009 | 333oh | f | 20.37 | 29.58 | 1.0252 | 16 |
| HaNoiOpen2011 | 333 | f | 12.81 | 16.85 | 1.0252 | 12 |
| SanFranciscoOpen2009 | 333 | f | 13.41 | 19.50 | 1.0253 | 16 |
| Borneo2010 | 333oh | f | 24.46 | 49.31 | 1.0254 | 29 |
| NorwegianOpen2009 | 555 | f | 132.07 | 142.42 | 1.0255 | 4 |
| CyberOpen2011 | 333 | f | 11.72 | 15.47 | 1.0256 | 12 |
| IndonesianChampionship2010 | pyram | f | 7.81 | 37.41 | 1.0256 | 63 |
| Seoul2008 | 333 | f | 13.63 | 18.00 | 1.0256 | 12 |
| JapanOpen2011 | 444 | f | 44.64 | 59.13 | 1.0259 | 12 |
| KoreanChampionship2011 | 333 | f | 11.13 | 16.34 | 1.0259 | 16 |
| GermanOpen2007 | 333 | f | 13.62 | 20.01 | 1.0260 | 16 |
| ChinaTourismDay2012 | 222 | f | 5.20 | 9.15 | 1.0260 | 23 |
| USNationals2010 | 333oh | f | 18.53 | 27.29 | 1.0261 | 16 |
| MunichOpen2010 | 555 | f | 92.72 | 136.68 | 1.0262 | 16 |
| TaiwanWinterOpen2010 | 333 | f | 12.42 | 16.51 | 1.0262 | 12 |
| GalantaOpen2009 | 333 | f | 15.20 | 20.22 | 1.0263 | 12 |
| PolishOpen2008 | 333 | f | 12.89 | 17.15 | 1.0263 | 12 |
| BWOpen2012 | 555 | f | 85.49 | 113.85 | 1.0264 | 12 |
| SpanishChampionship2011 | 333 | f | 11.73 | 15.63 | 1.0264 | 12 |
| HungarianOpen2008 | 333 | f | 13.20 | 19.56 | 1.0266 | 16 |
| Germany2009 | 444 | f | 59.53 | 71.54 | 1.0266 | 8 |
| USOpen2008 | 444 | f | 57.95 | 77.44 | 1.0267 | 12 |
| JRCAKansaiSpring2010 | 333 | f | 12.21 | 13.93 | 1.0267 | 6 |
| IndonesianOpen2011 | 555 | f | 92.81 | 124.06 | 1.0267 | 12 |
| CubingKoreaNewYears2012 | 333 | f | 10.79 | 22.05 | 1.0268 | 28 |
| WC2011 | 555 | f | 59.94 | 89.18 | 1.0268 | 16 |
+----------------------------+---------+---------+--------+--------+-----------+---------+
100 rows in set (0.69 sec)That AachenSummer2012 round with 39 persons stands out a bit and indeed looks rather dense:
http://www.worldcubeassociation.org/results/c.php?i=AachenSummer2012&allResults=1#333_f
Btw, note that I only consider rounds where the worst average was still successful (not a DNF). I might thus be missing rounds with one or more DNF average that are otherwise very dense.
Last edited:
cuber952
Veteran
What is the record for breaking a competition PB in consecutive competitions?
kinch2002
Premium Member
I've requested this before, but I don't think anyone managed to do it:
Sum of single/average ranks but for countries rather than individuals. So for each event you would take the NR holder and look at their world rank in that event, and then sum the ranks.
I'm still failing to set up the database on my computer, otherwise I'd give it a go myself
Sum of single/average ranks but for countries rather than individuals. So for each event you would take the NR holder and look at their world rank in that event, and then sum the ranks.
I'm still failing to set up the database on my computer, otherwise I'd give it a go myself
kinch2002
Premium Member
Me again. Fastest official multibld result for each number of cubes please (all solved attempts only ofc)
qqwref
Legend
- Joined
- Dec 18, 2007
- Messages
- 7,834
- Location
- a <script> tag near you
- WCA ID
- 2006GOTT01
- YouTube
- Visit Channel
Here's my attempt at this...
Code:
personName solved time
Alexander Yu 2 2:38
Ville Seppänen 3 7:00
Tim Habermaas 4 16:10
Daniel Sheppard 5 8:16
Fakhri Raihaan 6 31:00
Kai Jiptner 7 24:40
Kai Jiptner 8 25:33
Walter Pereira Rodrigues de Souza 9 54:21
Kai Jiptner 10 42:06
Wicaksono Adi 11 55:10
Rafał Guzewicz 11 55:10
Tim Habermaas 12 39:15
Fabrizio Cirnigliaro 13 56:59
Kai Jiptner 14 50:33
Tong Jiang 15 52:01
Muhammad Iril Khairul Anam 16 56:54
Chester Lian 17 53:09
Marcell Endrey 19 53:48
antoineccantin
Legend
- Joined
- Nov 8, 2010
- Messages
- 5,471
- Location
- near Ottawa, Canada
- WCA ID
- 2010CANT02
- YouTube
- Visit Channel
I can immediately see that this is not correct, Dan Sheppard has a 3/3 in 3:57.
qqwref
Legend
- Joined
- Dec 18, 2007
- Messages
- 7,834
- Location
- a <script> tag near you
- WCA ID
- 2006GOTT01
- YouTube
- Visit Channel
Hmm, that's pretty recent - maybe it wasn't in the version of the database I got earlier today?
antoineccantin
Legend
- Joined
- Nov 8, 2010
- Messages
- 5,471
- Location
- near Ottawa, Canada
- WCA ID
- 2010CANT02
- YouTube
- Visit Channel
That's very probable.
Similar threads
- Deleted member 36445
- General Speedcubing Discussion
