Stefan
Legend
You three totally fail. Check the "info" for what that statistic means.
-
Welcome to SpeedSolving.com — the world’s largest puzzle community!
You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.
Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.
Registration is free, fast, and easy — create your account today.
Already a member? Log in here to hide this message and start participating.
Odd WCA stats/ Stats request Thread
- Thread starter anders
- Start date
MaeLSTRoM
Veteran
Oh lol.
Found it out, rather surprisingly it's Greece.
Found it out, rather surprisingly it's Greece.
Faz
Former Clock NR Holder
- Joined
- Apr 24, 2008
- Messages
- 4,250
- Location
- Melbourne, Australia
- WCA
- 2009ZEMD01
- YouTube
- Visit Channel
:fp (at myself)
Last edited:
Stefan
Legend
You're lucky it actually is one country, not several. Imagine there were let's say four competitions hosting 3x3x3 but not 2x2x2, and three hosting 2x2x2 but not 3x3x3. Then you'd also have a difference of 1, but it'd be caused by several countries.
Greece is the country that hosted 3x3x3 but not 2x2x2. The only Greek competition so far:
http://www.worldcubeassociation.org/results/c.php?i=AthensOpen2010
Last edited:
Faz
Former Clock NR Holder
- Joined
- Apr 24, 2008
- Messages
- 4,250
- Location
- Melbourne, Australia
- WCA
- 2009ZEMD01
- YouTube
- Visit Channel
Stefan, could you possibly do a list of some other "Best X podiums"?
4x4, 5x5, OH, BLD and any others you're interested in doing.
4x4, 5x5, OH, BLD and any others you're interested in doing.
Stefan
Legend
There are btw 18 countries with 3x3x3 competitors but no 2x2x2 competitors:
Algeria
Azerbaijan
Bolivia
Bulgaria
Cote d'Ivoire
Cuba
Dominican Republic
El Salvador
Lithuania
Mauritius
Mongolia
Morocco
Puerto Rico
Saudi Arabia
Sri Lanka
Tunisia
United Arab Emirates
Yugoslavia
There are none with 2x2x2 competitors but no 3x3x3 competitors.
Algeria
Azerbaijan
Bolivia
Bulgaria
Cote d'Ivoire
Cuba
Dominican Republic
El Salvador
Lithuania
Mauritius
Mongolia
Morocco
Puerto Rico
Saudi Arabia
Sri Lanka
Tunisia
United Arab Emirates
Yugoslavia
There are none with 2x2x2 competitors but no 3x3x3 competitors.
Henrik
Veteran
I would like to see for each event, maybe even top-3 podiums for each event. (surprised that I would like to see Feet podium?)
ardi4nto
Regular
- Joined
- Mar 18, 2009
- Messages
- 191
- Location
- Bandung, West Java, Indonesia
- WCA
- 2009SATR01
- YouTube
- Visit Channel
Nostra
Member
Hi,
As specified in the WCA regulation, if 2 competitors (or more) got the same average during a competition, they are ranked thanks to their best time. I would like to know who had been in this situation the most and who "lost" the most often.
I'm not sure to be very clear, but I've been in this situation at least 3 time, and I lost each times.
During the Lyon Winter Open 2007, I finished 3rd in 3x3x3 with the same average than Lars, but a worst best and there was prizes only for the first two.
During the WC2009 I finished 65th in 3x3x3 with the same average than the 64th but a worst best and I couldn't reach the second round.
During the Montpellier Open 2011, I finished 5th in MMagic with the same average than the 4th but again a worst best.
I guess you can understand what I mean with these examples. Are there people more unlucky than me?
And also what was the equality that involved the most persons, 3? 4?
As specified in the WCA regulation, if 2 competitors (or more) got the same average during a competition, they are ranked thanks to their best time. I would like to know who had been in this situation the most and who "lost" the most often.
I'm not sure to be very clear, but I've been in this situation at least 3 time, and I lost each times.
During the Lyon Winter Open 2007, I finished 3rd in 3x3x3 with the same average than Lars, but a worst best and there was prizes only for the first two.
During the WC2009 I finished 65th in 3x3x3 with the same average than the 64th but a worst best and I couldn't reach the second round.
During the Montpellier Open 2011, I finished 5th in MMagic with the same average than the 4th but again a worst best.
I guess you can understand what I mean with these examples. Are there people more unlucky than me?
And also what was the equality that involved the most persons, 3? 4?
Stefan
Legend
The most persons in an average tie is three, and that happened 27 times. Example 17.07 here:
http://worldcubeassociation.org/results/c.php?i=BerkeleySummer2009&allResults=1#333
Might do your other question later, it's a bit harder.
http://worldcubeassociation.org/results/c.php?i=BerkeleySummer2009&allResults=1#333
Code:
'BerkeleySummer2009', '333', '1', 1707, 3
'30thAnniversaryMegaHouse2010', 'magic', '1', 151, 3
'Euro2010', '222', 'd', 595, 3
'AachenOpen2011', '222', '1', 606, 3
'CaptainsCove2010', 'magic', 'f', 192, 3
'HarbinOpen2009', 'magic', 'f', 180, 3
'HongKongOpen2009', '333', '1', 1707, 3
'Euro2008', '333', '1', 1821, 3
'USNationals2010', 'magic', '1', 150, 3
'JapanOpen2010', '333', '1', 1828, 3
'GermanOpen2011', '333', '1', 1111, 3
'HungarianOpen2009', 'magic', 'f', 118, 3
'USNationals2010', '222', '1', 640, 3
'SingaporeOpen2009', 'magic', 'f', 284, 3
'WC2009', 'magic', 'f', 201, 3
'Euro2010', 'mmagic', '1', 324, 3
'MalaysianOpen2009', '333', '1', 2035, 3
'TianjinOpen2010', 'magic', 'f', 283, 3
'DutchOpen2008', 'magic', 'f', 250, 3
'IndianaSummerOpen2009', 'magic', 'f', 284, 3
'WC2009', '333oh', '1', 2259, 3
'Shandong2010', 'magic', 'f', 259, 3
'WC2009', 'magic', 'f', 250, 3
'StanfordFall2009', '333', '2', 1691, 3
'IowaOpen2010', 'magic', 'f', 190, 3
'WC2009', 'magic', 'f', 259, 3
'NanjingSpring2011', 'magic', 'f', 151, 3
SELECT competitionId, eventId, roundId, average, count(*) x
FROM Results
WHERE average > 0
GROUP BY competitionId, eventId, roundId, average
ORDER BY x desc;Might do your other question later, it's a bit harder.
Stefan
Legend
All with four or more lost average ties (e.g. Arnaud lost 12 out of 22 average ties):
Code:
12/22 Arnaud van Galen AsianChampionship2010 / 333 / 1 / 19.79
BeneluxOpen2009 / mmagic / f / 4.93
BrusselsSummerOpen2009 / magic / f / 1.63
BUAAOpen2010 / 333 / 1 / 23.75
DanishOpen2009 / 222 / f / 7.55
Euro2008 / magic / f / 2.69
GermanOpen2009 / magic / f / 1.83
LyonOpen2007 / 333 / 1 / 29.10
MelbourneCubeDay2010 / 222 / 1 / 7.16
PolishOpen2009 / 222 / d / 6.58
USNationals2009 / magic / 1 / 2.20
USOpen2008 / magic / f / 2.68
8/13 Bob Burton MITFall2009 / 333 / 1 / 19.56
MotorCityOpen2009 / 333 / 2 / 17.21
ParkRidgeOpen2011 / magic / f / 2.14
USNationals2009 / magic / 1 / 1.54
USOpen2008 / mmagic / f / 3.87
VirginiaOpen2008 / 222 / 1 / 9.86
WC2009 / 333 / 1 / 18.44
WC2009 / mmagic / f / 4.47
7/11 Dániel Varga DutchOpen2010 / mmagic / f / 3.44
Euro2010 / 333 / 3 / 14.05
Euro2010 / pyram / d / 6.48
GermanOpen2011 / 555 / d / 107.17
HungarianOpen2009 / magic / f / 1.18
HungarianOpen2010 / 333oh / f / 24.83
PabianiceOpen2010 / 222 / 3 / 5.76
7/12 Tobias Christlieb CologneOpen2010 / 444 / d / 66.65
CologneOpen2010 / mmagic / f / 5.32
Germany2010 / 333oh / d / 25.77
MunichOpen2010 / 222 / f / 6.92
WC2009 / 333 / 1 / 17.10
WC2009 / magic / f / 1.46
WC2009 / mmagic / f / 5.61
7/13 Sébastien Auroux BelgianOpen2010 / 333 / 2 / 18.35
BeneluxOpen2010 / 333 / 2 / 17.37
CologneOpen2010 / sq1 / c / 40.85
DutchOpen2008 / magic / f / 2.50
DutchOpen2010 / 222 / f / 5.75
DutchOpen2010 / 333 / 2 / 15.78
LemgoOpen2010 / 222 / 1 / 6.59
6/7 Jaclyn Sawler CaptainsCove2010 / magic / f / 2.02
ConnecticutSummer2009 / magic / f / 2.25
MITFall2009 / mmagic / f / 4.98
USNationals2010 / magic / 1 / 2.22
VirginiaOpen2010 / mmagic / f / 4.40
WestchesterFall2008 / magic / f / 2.18
6/7 Kamil Zielinski BialystokOpen2011 / 222 / 2 / 5.65
BialystokOpen2011 / magic / 1 / 2.06
Euro2010 / 222 / d / 4.58
MilanCubeOpen2011 / 333oh / d / 27.04
PoznanOpen2009 / clock / d / 11.36
WC2009 / 222 / 1 / 4.44
5/7 Nora Christ AachenOpen2010 / 333 / 1 / 20.45
BeneluxOpen2010 / 222 / f / 6.59
CologneOpen2010 / 555 / d / 137.58
Germany2010 / 222 / d / 8.88
WC2009 / magic / f / 2.88
5/7 Robin Blöhm AachenOpen2010 / 333 / 2 / 16.24
BelgianOpen2010 / 333 / 1 / 15.13
CologneOpen2010 / pyram / f / 12.84
Germany2009 / pyram / c / 12.36
Germany2010 / 333 / 2 / 14.45
5/7 Charlie Cooper BelgianOpen2010 / 333 / 1 / 21.14
BelgianOpen2010 / mmagic / f / 4.48
BeneluxOpen2010 / 222 / f / 7.57
Euro2010 / mmagic / 1 / 5.12
Germany2008 / 333 / 1 / 25.53
5/11 Clément Gallet LyonSinterklaasOpen2010 / 222 / 1 / 9.13
MontpellierOpen2011 / 222 / f / 6.89
MurciaOpen2008 / magic / f / 1.92
VesoulOpen2011 / 222 / 1 / 6.38
WC2009 / magic / f / 2.59
4/4 Kyle Barry LibertyScience2010 / 333 / 2 / 14.50
OhioOpen2010 / 333 / 1 / 16.56
USNationals2010 / 222 / 1 / 6.08
WashingtonDCSpring2010 / 222 / f / 4.91
4/4 Dave Campbell CUBEcentric2011 / 333 / 2 / 17.34
TorontoFall2010 / 333 / 2 / 15.92
TorontoSpring2010 / 333oh / f / 27.81
TorontoSummer2010 / 333 / 1 / 13.89
4/4 Thomas Watiotienne LyonWinterOpen2007 / 333 / f / 16.55
MontpellierOpen2011 / mmagic / f / 4.59
ToulouseOpen2010 / magic / f / 1.62
WC2009 / 333 / 1 / 15.22
4/5 Jeremy Fleischman ArizonaOpen2011 / 333 / f / 12.51
CaltechFall2008 / 333 / 2 / 15.91
StanfordFall2009 / 333 / f / 13.91
USNationals2010 / 333 / 2 / 15.11
4/5 Rafal Studnicki Euro2010 / magic / 1 / 1.66
Euro2010 / mmagic / 1 / 4.47
PolishOpen2007 / magic / f / 1.78
WC2009 / magic / f / 1.63
4/5 Leandro Baltazar AachenOpen2011 / 222 / 1 / 7.54
AachenOpen2011 / 333 / 2 / 16.16
WC2009 / 333 / 1 / 22.26
WC2009 / magic / f / 2.37
4/5 Barnabás Turi CzechOpen2010 / magic / 1 / 1.58
Euro2010 / 222 / d / 5.95
Euro2010 / 333 / 1 / 17.47
Euro2010 / magic / f / 1.75
4/5 Marie Hughey IndianaWinterOpen2008 / mmagic / f / 6.86
TorontoSummer2010 / magic / f / 2.58
UIUCSpring2011 / magic / f / 2.92
USNationals2010 / magic / 1 / 2.28
4/5 John Tamanas CanadianCubingClassic2009 / 222 / f / 5.18
CaptainsCove2010 / 333 / 2 / 12.51
MITFall2009 / pyram / f / 12.13
USNationals2010 / 333 / 3 / 12.31
4/5 Adam Zamora DutchOpen2009 / 222 / f / 8.21
USNationals2009 / magic / 1 / 1.83
VirginiaOpen2010 / magic / f / 1.75
WC2007 / 333 / 1 / 24.29
4/5 Florian Weingarten AachenOpen2009 / 222 / f / 11.39
AachenOpen2011 / 333 / 2 / 19.96
DutchMasters2008 / 333 / 2 / 19.42
WC2009 / 333 / 1 / 20.36
4/5 Cameron Almasi BerkeleySummer2009 / 333 / 1 / 17.07
StanfordFall2009 / 333 / 2 / 16.91
StanfordWinter2010 / 333oh / 1 / 30.85
USNationals2009 / 222 / 1 / 8.05
4/5 Devin Corr-Robinett BerkeleyFall2010 / 333 / 1 / 13.67
CaltechSpring2007 / 333 / 1 / 24.10
CaltechWinter2010 / magic / f / 3.05
MarymountOpen2010 / 333 / 1 / 15.48
4/5 Thapapol Dantrakul AsianChampionship2010 / 333oh / 1 / 32.10
TCAChampionship2011 / 333 / 2 / 12.15
ThailandOpen2010 / 333 / f / 13.68
ThailandOpen2011 / 222 / f / 4.86
4/6 Piti Pichedpan BangkokOpen2010 / 333 / 1 / 12.02
MalaysianOpen2009 / 222 / f / 5.02
SingaporeOpen2009 / 333 / d / 13.85
ThailandOpen2009 / 222 / 1 / 7.50
4/6 François Courtès CzechOpen2009 / pyram / f / 14.58
DinsOpen2011 / 222 / 1 / 5.75
GaleriesLafayetteOpen2010 / 222 / f / 6.17
LyonSummerOpen2010 / 222 / 1 / 7.08
4/6 Loïc Petit France2011 / 222 / c / 4.76
MontpellierOpen2010 / magic / f / 3.20
NeptuneOpen2011 / 222 / f / 5.15
NeptuneOpen2011 / pyram / f / 13.90
4/6 Lukasz Cialon Euro2010 / 222 / d / 3.41
GrudziadzOpen2010 / magic / 1 / 2.76
WC2009 / 333 / 1 / 19.88
WC2009 / magic / f / 2.50
4/6 Balázs Bernát HungarianOpen2009 / magic / f / 2.34
HungarianOpen2010 / 333 / 2 / 13.94
WC2009 / 333oh / 1 / 22.59
WC2009 / 555 / 1 / 98.49
4/6 Jens Diewald BelgianOpen2010 / 333 / f / 15.64
GermanOpen2009 / magic / f / 2.05
GermanOpen2011 / 222 / 1 / 5.36
NemoAmsterdamOpen2011 / 333 / 2 / 13.35
Last edited:
Nostra
Member
Thanks!
EDIT : I lost the 4 times I get involved in a tie!
EDIT : I lost the 4 times I get involved in a tie!
Last edited:
Stefan
Legend
Indeed. Same as Kyle and Dave (look again, I just added the number of average ties people were involved in).
ilikecubing
Veteran
Top 100 in the world if we combine 3x3 speed and 3x3 blindfolded?
clement
Regular
How long did Stefan spend time doing statistics for other people ?
AvGalen
Premium Member
Who is willing to bet that there won't be 2x2x2 next time in a Greece competition?
V2
Mr.Toad
Regular
- Joined
- Jul 26, 2009
- Messages
- 82
Code:
+-----------------------------------+-------+--------+-------+
| personName | sum | avg3x3 | blind |
+-----------------------------------+-------+--------+-------+
| Gabriel Alejandro Orozco Casillas | 4660 | 1570 | 3090 |
| Ville Seppänen | 5052 | 1099 | 3953 |
| Zane Carney | 5385 | 1317 | 4068 |
| Preeda Hongpimolmas | 5535 | 1251 | 4284 |
| Alexander Yu | 5572 | 1226 | 4346 |
| Yuhui Xu (Þ«©Õ«çÞ¥ë) | 5612 | 1981 | 3631 |
| Muhammad Iril Khairul Anam | 5750 | 1682 | 4068 |
| Tse-Kan Lin (µ×ùÕô▓õ¥â) | 5926 | 1304 | 4622 |
| Rowe Hessler | 6118 | 891 | 5227 |
| Aron Puddy-Mathew | 6311 | 1464 | 4847 |
| Yumu Tabuchi (þö░µ©òÚøäÕñó) | 6419 | 903 | 5516 |
| Kai Jiptner | 6662 | 1306 | 5356 |
| Chester Lian | 6762 | 1226 | 5536 |
| Tomás Mansilla | 6793 | 1703 | 5090 |
| Cornelius Dieckmann | 6806 | 941 | 5865 |
| Timothy Sun | 6887 | 1157 | 5730 |
| Zhi Qiao (õ╣öµÖ║) | 6931 | 1516 | 5415 |
| Milán Baticz | 6942 | 1070 | 5872 |
| Chi-Lun Hong (µ┤¬ÕòƒÕǽ) | 6978 | 1287 | 5691 |
| Rafal Guzewicz | 7100 | 1678 | 5422 |
| Jia-Hong Lu (ÚÖ©ÕÿëÕ«Å) | 7225 | 1272 | 5953 |
| Tomasz Korzeniewski | 7260 | 1463 | 5797 |
| Feliks Zemdegs | 7306 | 787 | 6519 |
| Amos Tay Swee Hui | 7358 | 1115 | 6243 |
| Eric Limeback | 7399 | 1053 | 6346 |
| Xitian Luo (þ¢ùõ╣áµÀ╗) | 7472 | 1675 | 5797 |
| Arvid Skarrie | 7530 | 1809 | 5721 |
| Pedro Santos Guimarães | 7553 | 1178 | 6375 |
| Leyan Lo | 7574 | 1191 | 6383 |
| Marcell Endrey | 7598 | 1440 | 6158 |
| Matteo Colombo | 7605 | 1700 | 5905 |
| Maarten Smit | 7635 | 1126 | 6509 |
| Danyang Chen (ÚÖêõ©╣Úÿ│) | 7694 | 1626 | 6068 |
| Guillain Potron | 7723 | 1180 | 6543 |
| Joey Gouly | 7786 | 1221 | 6565 |
| Tomoki Kubo (õ╣àõ┐ØÕÅﵿ╣) | 7792 | 1556 | 6236 |
| Lucas Benito Rolando | 7793 | 1527 | 6266 |
| Yuxin Wang (þÄïÕ«çµ¼ú) | 7884 | 2687 | 5197 |
| Konrad Stawski | 7898 | 1382 | 6516 |
| Dan Cohen | 8000 | 969 | 7031 |
| Lucas Garron | 8182 | 1210 | 6972 |
| Wu Chun Chung (ÕÉ│õ┐èÞü░) | 8201 | 1515 | 6686 |
| Jokey Chen (ÚÖêþÑûþÑ║) | 8279 | 1327 | 6952 |
| Marco Levrero | 8359 | 1366 | 6993 |
| Jean Pons | 8374 | 1199 | 7175 |
| Bertalan Bodor | 8462 | 1231 | 7231 |
| Bill Wang | 8488 | 1391 | 7097 |
| Yu Nakajima (õ©¡Õ│ µéá) | 8561 | 1071 | 7490 |
| Simon Westlund | 8647 | 1056 | 7591 |
| Maximilian Neitzel | 8762 | 1115 | 7647 |
| Andy Tsao | 8786 | 1053 | 7733 |
| Baramee Pookcharoen | 8814 | 1068 | 7746 |
| Ivo Bakker | 8951 | 1410 | 7541 |
| Michal Robaczyk | 8978 | 1173 | 7805 |
| Shelley Chang | 9013 | 1520 | 7493 |
| Reynaldo Mape Jr. | 9150 | 1885 | 7265 |
| Weston Mizumoto | 9216 | 1180 | 8036 |
| Simon Bourigault | 9293 | 2003 | 7290 |
| Daniel Sheppard | 9315 | 1335 | 7980 |
| Balázs Bernát | 9322 | 1261 | 8061 |
| Luchen Zhang (Õ╝áÕ¢òÞ¥░) | 9325 | 1348 | 7977 |
| Chris Krueger | 9562 | 2002 | 7560 |
| Tim Habermaas | 9584 | 1641 | 7943 |
| Yunqi Ouyang (µ¼ºÚÿ│ÚƒÁÕÑç) | 9604 | 1396 | 8208 |
| Takahiro Tomisawa (Õ»îµ▓óÚÜåÕ║â) | 9670 | 1464 | 8206 |
| Dennis Strehlau | 9788 | 1885 | 7903 |
| Chris Hardwick | 9810 | 1435 | 8375 |
| Tyson Mao (µ»øÕÅ░ÕïØ) | 9816 | 1560 | 8256 |
| Victor Cullot | 9856 | 1918 | 7938 |
| Ryosuke Mondo (Úûǵê©Þë»õ╗ï) | 9892 | 1931 | 7961 |
| Willian Fidêncio | 9915 | 1512 | 8403 |
| Anton Rostovikov | 9928 | 1226 | 8702 |
| Harris Chan | 9943 | 1012 | 8931 |
| Hao Cheng (þ¿ïµÁ®) | 9954 | 2395 | 7559 |
| Sinpei Araki (ÞìƵ£¿µàÄÕ╣│) | 10039 | 1164 | 8875 |
| Derrick Eide | 10098 | 1132 | 8966 |
| Ivan Smirnov | 10122 | 1626 | 8496 |
| Wicaksono Adi | 10126 | 1945 | 8181 |
| Jason Baum | 10131 | 1197 | 8934 |
| Yan Xuan (Õ«úþéÄ) | 10142 | 1506 | 8636 |
| Norbert H├®jja | 10216 | 1273 | 8943 |
| Phil Thomas | 10308 | 1367 | 8941 |
| Yodi Adhari | 10322 | 1689 | 8633 |
| Baiqiang Dong (ÞæúþÖ¥Õ╝║) | 10382 | 1471 | 8911 |
| Dedi Hariyadi | 10400 | 1695 | 8705 |
| Sheng-Yung Guo | 10405 | 1567 | 8838 |
| Alex Cook | 10419 | 1533 | 8886 |
| P├®ter Trombit├ís | 10424 | 1336 | 9088 |
| Takuma Akutsu (Úÿ┐õ╣àµ┤Ñ µïôþ£ƒ) | 10492 | 1221 | 9271 |
| Oliv├®r Perge | 10496 | 1296 | 9200 |
| Piotr Tomczyk | 10614 | 1123 | 9491 |
| Muhammad Rehan | 10632 | 1579 | 9053 |
| Bastien Bonnet | 10639 | 1596 | 9043 |
| Aldo Feandri | 10732 | 2038 | 8694 |
| Erik Akkersdijk | 10734 | 931 | 9803 |
| Jason Thong | 10746 | 1371 | 9375 |
| François Courtès | 10797 | 2179 | 8618 |
| Jaka Wahyu Hidayat | 10851 | 1324 | 9527 |
| Alberto Bosia | 10864 | 1558 | 9306 |
| Joris M├╝hlsteff | 10883 | 1468 | 9415 |
+-----------------------------------+-------+--------+-------+
select a.personName, (avg3x3+blind) sum, avg3x3, blind from
(
select personId, personName, min(average) avg3x3
from results
where eventId = '333' and average>0
group by personId
) a,
(
select personId, personName, min(best) blind
from results
where eventId = '333bf' and best>0
group by personId
) b
where a.personId = b.personId
group by a.personId
order by sum
limit 100;
Last edited:
iEnjoyCubing
Veteran
Nice. That's impressive.
ilikecubing
Veteran
Interesting list, thanks
Similar threads
- Deleted member 36445
- General Speedcubing Discussion
