KongShou
Member
What were the official wr for magic and master magic? And who set them? before the event was canceled?
What were the official wr for magic and master magic? And who set them? before the event was canceled?
From earlier in the thread:I would like to see a list of closest finishes ever arranged in order for all the events in the world.Both for between 1st and 2nd place,and between 2nd and 3rd place.
I'm curious to see the slowest 3x3x3 solvers with a BLD success.
wca = read.csv("wca export.csv")
blind = wca[wca$eventId == "333bf",]
blindsmall = blind[,c(5, 7)] #name and best time, BLD
successes = blindsmall[blindsmall$best != -1,] #eliminate DNF averages
success = as.character(unique(successes$person)) #create a unique list of names
loopnum = length(success) #number used in for loop later
speed = wca[wca$eventId == "333",6:7] #name and average, speed
speed = speed[speed$average > 0,] #eliminate DNF/empty values
vec = 0 #placeholder variable
for (i in 1:loopnum) {
res = speed[speed$person == success[i],] #table of 3x3x3 averages for blindsolver i
vec[i] = min(res$average) #takes the best 3x3x3 average
}
output = data.frame(name=success, time=vec) #arranges the two vectors of names and best 3x3x3 averages together
output2 = output[is.finite(output$time),] #Inf was result for blindsolvers with no 3x3x3 average
output3 = output2[order(-output2$time),] #order from highest to lowest
name time
1 Walter Antonio Monti 8974
2 Hritik Shukla 8595
3 Hideaki Tomoyori (å‹å¯„英哲) 5841
4 Phil Hamory 5636
5 Javier Santos 5631
6 Hualei Gao (高åŽç£Š) 5425
7 Eszter Szabó 5351
8 Tharun Suresh 4945
9 Oleksii Bessonov (ОлекÑій БеÑÑонов) 4595
10 Julián González Acevedo 4569
11 Mark Polinkovsky (Марк ПолинковÑкий) 4544
12 Amish Thakkar 4502
13 Érik Amorim 4496
14 Abhijitharam Tadepalli 4474
15 Julia Connelly 4435
16 Oky Markianto 4349
17 Aygul Tlyavsina 4219
18 Alvin Raditya 4218
19 Gaston Muñoz 4196
20 Jin Zhang (ç«*瑾) 4167
21 LaÃ*s Azevedo Martins da Silva 4084
22 Tertuliano Carneiro de Souza Neto 4083
23 Zacharie Cortes 4077
24 Xin Lu (鹿鑫) 4070
25 Frédéric Giguet 4066
26 Varun Karandikar 3949
27 Mukunth Suresh 3938
28 Yann Leenhardt 3937
29 Douwe Wermer 3934
30 Bruce Norskog 3908
31 Martin Maréchal 3860
32 Khoirudin Ubaidillah 3851
33 Ahmad Muhajir 3796
34 Antoine Tonnoir 3781
35 Yang Hu (胡扬) 3688
36 Robert D. Johnson 3686
37 Zulfikar Karim 3627
38 Gilles Cayol 3601
39 Yijing Liang (æ¢è¯‘é™) 3599
40 Nicolas Renault 3578
41 John Louis 3577
42 Chuanliang Ma (马ä¼*æ¢) 3564
43 Marcus Forsell Stahre 3547
44 Ivan Enrico 3543
45 Mats Bergsten 3513
46 Matthieu Fresquet 3484
47 Krzysztof Opalski 3400
48 Jennifer Tang 3391
49 Mats Kollbrink 3372
50 Ryan Gossiaux 3339
51 Rafał Bartuzi 3339
52 Joshua Lambert 3333
53 Suyash Ojha 3292
54 Dan Wang 3269
55 Matthew Wallisa 3265
56 David Bergling 3256
57 Frédéric Mignon 3246
58 Katja Renner 3226
59 Tsai-Hsuan Chen (陳采è±) 3217
60 Bill McGaugh 3203
61 Xi He (何熙) 3203
62 Bagus Galang Pratama 3179
63 Olve Maudal 3172
64 Julio Machaca Perez 3170
65 Wojciech Jurga 3156
66 Katsuto Takeuchi (æ*¦å†…å…‹æ–—) 3149
67 Ahmad Leo Yudanto 3113
68 Vladimir Kostin 3109
69 Alex Comeau 3097
70 Johannes Neumann 3094
71 Thomas Bossmann 3094
72 Vikram Mada 3093
73 Ralph Eikelenberg 3090
74 Vivek Chandru 3085
75 Andre Vincentius Angga 3084
76 Shantanu Walke 3083
77 Adrian Roșu 3048
78 Apriadin 3043
79 Raviraj Gohil 3038
80 Takeshi Akuzawa (阿久沢剛å²) 3006
81 Pierre Bienaimé 2995
82 Siska Lestari Afdan 2992
83 Pablo Cristian Duarte de Sousa 2963
84 Kathi Sundeep 2939
85 Ben Beer 2931
86 Brendan Manning 2929
87 Karthik Kumar 2884
88 Tyler Hakomori 2879
89 Kai Molzberger 2867
90 Satriyo Nurdiyono 2861
91 Thomas Kohn 2856
92 Caleb Shapiro 2842
93 Ivan Calvet 2822
94 Charlie Pugh 2820
95 Donato Marro 2810
96 Alan Jiang 2808
97 Brandon Whitchurch 2806
98 Budi Setiawan Paramata 2772
99 Diego de Pereda Sebastián 2753
100 Jaime Solsona 2747
Decided to take this into my own hands. I'm not experienced with SQL so I used R instead.
And here's the top 100. Names with special characters didn't translate well.
Rank | Name | Attempts |
1 | István Kocza | 76 |
2 | François Courtès | 70 |
3 | Mike Hughey | 49 |
4 | Zhizhe Liang (梁稚喆) | 32 |
5 | Chester Lian | 29 |
6 | Marcell Endrey | 28 |
7 | Chris Hardwick | 27 |
8 | Kai Jiptner | 26 |
9 | Baiqiang Dong (董百强) | 25 |
10 | Marcin Zalewski | 25 |
Rank | Name | Successes |
1 | István Kocza | 37 |
2 | Mike Hughey | 18 |
3 | Chris Hardwick | 13 |
4 | Chester Lian | 12 |
5 | Zhizhe Liang (梁稚喆) | 8 |
5 | Marcell Endrey | 8 |
5 | Fabrizio Cirnigliaro | 8 |
8 | Aldo Feandri | 7 |
8 | Dmitry Karyakin | 7 |
10 | Tim Habermaas | 6 |
10 | Tomoaki Okayama (岡山友昭) | 6 |
10 | Muhammad Iril Khairul Anam | 6 |
Rank | Name | Attempts | Solves |
1 | Matthew Sheerin | 2 | 2 |
2 | Bernett Orlando | 1 | 1 |
3 | Taku Yanai (矢内拓) | 1 | 1 |
Rank | Name | Attempts | Solves |
1 | Baiqiang Dong (董百强) | 25 | 0 |
2 | Dan Cohen | 12 | 0 |
3 | Cendy Cahyo Rahmat | 11 | 0 |
4 | Shelley Chang | 10 | 0 |
5 | Shaden Smith | 9 | 0 |
5 | Frank Severinsen | 9 | 0 |
5 | Aron Puddy-Mathew | 9 | 0 |
8 | Hong Zhang (张宏) | 8 | 0 |
8 | Noah Arthurs | 8 | 0 |
8 | Callum Hales-Jepp | 8 | 0 |
Rank | Country | Attempts | Solves | Success Rate |
1 | Malaysia | 43 | 17 | 39.5% |
2 | Hungary | 147 | 48 | 32.7% |
3 | India | 8 | 2 | 25.0% |
3 | Japan | 72 | 18 | 25.0% |
3 | Mexico | 4 | 1 | 25.0% |
6 | Finland | 13 | 3 | 23.1% |
7 | Russia | 59 | 13 | 22.0% |
8 | Italy | 51 | 10 | 19.6% |
9 | USA | 225 | 42 | 18.7% |
10 | Sweden | 66 | 12 | 18.2% |
Year | Attempts | Successes | Success Rate |
2004 | 3 | 1 | 33.3% |
2005 | 3 | 0 | 0.00% |
2006 | 6 | 4 | 67.7% |
2007 | 23 | 6 | 26.1% |
2008 | 52 | 12 | 23.1% |
2009 | 80 | 16 | 20.0% |
2010 | 270 | 38 | 14.1% |
2011 | 412 | 76 | 18.4% |
2012 | 387 | 63 | 16.3% |
2013 | 247 | 45 | 18.2% |
Lol 2005 was a fail.
Gael Dusser (along with some other people) used to "troll" FMC events by trying to put as many moves as possible into their solutions. They would add things like (R U R' U')x6 just to increase move counts. This is why the WCA imposed an 80-move limit.http://www.worldcubeassociation.org/results/p.php?i=2007DUSS01
This person is sub-15 for 3x3, but his fewest moves attempt... over 500?
All of his regular 3x3 solves were also done blindfold-style.http://www.worldcubeassociation.org/results/p.php?i=2008ZHUA01
His BLD is faster than his 3x3.