• 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

cmhardw said:
Are these correct?
Click to expand...

Almost. Bernett also has 1/1 in 5BLD and Jasmine is 34/34 in Clock, not 38/38. (Yes, I know you understood the task differently, but you made me check this :)).

Kudos to Jean-Louis and Laetitia for their impressive feats. Must be a French thing.

And ha, I just realized Tim once set the official 24/24 multiblind WR and now he holds this 25/25 multiblind WR.

Using data from WCA_export469_20140909 and Stefan's WCA statistics tools.

[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]Solves[/TD][TD]Who[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD="align:right"]681[/TD][TD]Yu Nakajima (中島悠)[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD="align:right"]365[/TD][TD]Henrik Buus Aagaard[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD="align:right"]582[/TD][TD]Ron van Bruchem[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD="align:right"]360[/TD][TD]Matteo Provasi[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD="align:right"]6[/TD][TD]Kelsey McKenna[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD="align:right"]345[/TD][TD]John Brechon[/TD][/TR]
[TR][TD]3x3 fewest moves[/TD][TD="align:right"]36[/TD][TD]Bob Burton[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD="align:right"]92[/TD][TD]Henrik Buus Aagaard[/TD][/TR]
[TR][TD]Megaminx[/TD][TD="align:right"]503[/TD][TD]François Courtès[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD="align:right"]417[/TD][TD]Bence Barát[/TD][/TR]
[TR][TD]Square-1[/TD][TD="align:right"]177[/TD][TD]Michał Robaczyk[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD="align:right"]34[/TD][TD]Jasmine Lee[/TD][/TR]
[TR][TD]Skewb[/TD][TD="align:right"]105[/TD][TD]Paweł Kowol[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD="align:right"]186[/TD][TD]Erik Akkersdijk[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD="align:right"]198[/TD][TD]Bence Barát[/TD][/TR]
[TR][TD]4x4 blindfolded[/TD][TD="align:right"]3[/TD][TD]Mayur Ukey, Daniel Kottenstette[/TD][/TR]
[TR][TD]5x5 blindfolded[/TD][TD="align:right"]1[/TD][TD]Lucas Wesche, Bernett Orlando[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD="align:right"]25[/TD][TD]Tim Habermaas[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD="align:right"]120[/TD][TD]Jean-Louis Mathieu[/TD][/TR]
[TR][TD]Master Magic[/TD][TD="align:right"]150[/TD][TD]Laetitia Lemoine[/TD][/TR]
[TR][TD]3x3 multi blind old[/TD][TD="align:right"]11[/TD][TD]Rowe Hessler[/TD][/TR]
[/TABLE]

CREATE TABLE DNFless
SELECT
personId,
eventId,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves
FROM Results
GROUP BY personId, eventId
HAVING sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) = 0;

SELECT tmp.eventId Event, max_solves Solves, group_concat(concat(personId,'#',tmp.eventId) separator ', ') Who
FROM DNFless
join (SELECT eventId, max(solves) max_solves FROM DNFless GROUP BY eventId) tmp
on DNFless.eventId=tmp.eventId and solves=max_solves
join Events on Events.id=tmp.eventId
GROUP BY tmp.eventId
ORDER BY rank;

DROP TABLE DNFless;
 
Last edited:
Sebastien said:
Ok, I blame myself for 40% being a very bad guess. However the 37% for the Top100 are surprising me. Thanks. :)
Click to expand...

I should have calculated the graph first and asked you about the Top300 :). Don't know what causes that mountain.

There are a few special cases, btw.
- 38 people have a round avg5 but no rolling avg5 (example). DNSs are "used" in round avg5s but I ignored them for rolling avg5s.
- 80 people have a rolling avg5 but no round avg5 (example).
I used all people with a rolling avg5 and checked how many of them have a best round avg5 equal to their best rolling avg5. One might prefer a different way, but it won't affect the statistic much. Anyway... 15218 people have only one round average (pretty much guaranteeing a match between it and their best rolling avg5, if they have one). And 21016 of the 29590 people with a rolling avg5 have a best round avg5 equal to their best rolling avg5. Now if I subtract 15218 from those two numbers, I get (21016-15218) / (29590-15218) = 40.3%, so in that sense you were close.
 
Last edited:
Code: 
 1. 10.1% (303 posts) Stefan
 2.  5.4% (163 posts) cubizh
 3.  4.0% (121 posts) kinch2002
 4.  2.5% ( 75 posts) qqwref
 5.  2.4% ( 73 posts) Sebastien
     2.4% ( 73 posts) Robert-Y
 7.  2.4% ( 72 posts) Lid
 8.  2.2% ( 66 posts) Carrot
 9.  2.2% ( 65 posts) antoineccantin
     2.2% ( 65 posts) TMOY
11.  2.1% ( 64 posts) Pro94
12.  2.0% ( 59 posts) vcuber13
13.  1.8% ( 55 posts) TheNextFeliks
14.  1.4% ( 42 posts) Evan-Liu
15.  1.4% ( 41 posts) Tim-Reynolds
     1.4% ( 41 posts) Noahaha
17.  1.2% ( 36 posts) theZcuber
     1.2% ( 36 posts) TDM
19.  1.2% ( 35 posts) Bob
20.  1.1% ( 32 posts) MaeLSTRoM
     1.1% ( 32 posts) Tim-Major
22.  1.0% ( 31 posts) ben1996123
     1.0% ( 31 posts) guysensei1
24.  1.0% ( 30 posts) Kian
25.  1.0% ( 29 posts) Mike-Hughey
26.  0.9% ( 27 posts) Michael-Womack
27.  0.8% ( 25 posts) Rune
     0.8% ( 25 posts) Mikel
29.  0.8% ( 23 posts) Hippolyte!!!
30.  0.7% ( 22 posts) ottozing
     0.7% ( 22 posts) kclejeune
     0.7% ( 22 posts) Cubenovice
33.  0.7% ( 21 posts) AvGalen
34.  0.7% ( 20 posts) uberCuber
35.  0.6% ( 18 posts) That70sShowDude
36.  0.6% ( 17 posts) Julian
     0.6% ( 17 posts) TheDubDubJr
     0.6% ( 17 posts) lachose
39.  0.5% ( 16 posts) Antonie-faz-fan
     0.5% ( 16 posts) Riley
41.  0.5% ( 15 posts) Coolster01
42.  0.5% ( 14 posts) mycube
     0.5% ( 14 posts) LucidCuber
     0.5% ( 14 posts) ilikecubing
     0.5% ( 14 posts) Kit-Clement
46.  0.4% ( 13 posts) CyanSandwich
     0.4% ( 13 posts) yoinneroid
48.  0.4% ( 12 posts) Mollerz
     0.4% ( 12 posts) Ollie
     0.4% ( 12 posts) Bhargav777
     0.4% ( 12 posts) porkynator
     0.4% ( 12 posts) ThomasJE
53.  0.4% ( 11 posts) rowehessler
     0.4% ( 11 posts) cmhardw
     0.4% ( 11 posts) RCTACameron
     0.4% ( 11 posts) XTowncuber
     0.4% ( 11 posts) Renslay
58.  0.3% ( 10 posts) Ninja-Storm
     0.3% ( 10 posts) cuber952
     0.3% ( 10 posts) Pedro
     0.3% ( 10 posts) bamilan
     0.3% ( 10 posts) DavidWoner
     0.3% ( 10 posts) MTGjumper
64.  0.3% (  9 posts) irontwig
     0.3% (  9 posts) TheMachanga
     0.3% (  9 posts) Anthony
     0.3% (  9 posts) Bindedsa
     0.3% (  9 posts) Username
     0.3% (  9 posts) Mr-Toad
70.  0.3% (  8 posts) ardi4nto
     0.3% (  8 posts) fazrulz
     0.3% (  8 posts) Bryan
     0.3% (  8 posts) aronpm
     0.3% (  8 posts) Lucas-Garron
     0.3% (  8 posts) timeless
     0.3% (  8 posts) oranjules
     0.3% (  8 posts) 10461394944000
     0.3% (  8 posts) Beny\xf3
     0.3% (  8 posts) Zane_C
     0.3% (  8 posts) Swordsman-Kirby
81.  0.2% (  7 posts) AlexMaass
     0.2% (  7 posts) Sajwo
     0.2% (  7 posts) Cale-S
     0.2% (  7 posts) bobthegiraffemonkey
     0.2% (  7 posts) hcfong
     0.2% (  7 posts) Geert
     0.2% (  7 posts) Nathan-Dwyer
     0.2% (  7 posts) Jakube
     0.2% (  7 posts) CHJ
     0.2% (  7 posts) amostay2004
     0.2% (  7 posts) anders
     0.2% (  7 posts) goodatthis
93.  0.2% (  6 posts) rubiksarlen
     0.2% (  6 posts) AustinReed
     0.2% (  6 posts) ryanj92
     0.2% (  6 posts) PandaCuber
     0.2% (  6 posts) Laura-O
     0.2% (  6 posts) JasonK
     0.2% (  6 posts) cuberkid10
     0.2% (  6 posts) Henrik
     0.2% (  6 posts) JackJ
     0.2% (  6 posts) BlueDevil
 
Last edited:
Let's hope I type everything corrrectly this time ;)

Code: 
333    : 1046 : +Clément Gallet, France (5 DNFs)
444    :  574 : +Bence Barát, Hungary (1)
555    :  582 : +Ron van Bruchem, Netherlands (0)
222    :  475 : +Bence Barát, Hungary (4)
333bf  :   71 :  Tim Habermaas, Germany (11)
333oh  :  620 :  Dave Campbell, Canada (1)
333fm  :   51 : +Sébastien Auroux, Germany (25)
333ft  :   98 : +Rafael Werneck Cinoto, Brazil (3)
minx   :  503 : +François Courtès, France (0)
pyram  :  417 : +Bence Barát, Hungary (0)
sq1    :  313 :  Sébastien Auroux, Germany (9)
clock  :   83 :  Tim Reynolds, USA (10)
skewb  :  111 :  Wojciech Szatanowski, Poland (1)
666    :  189 : +Bence Barát, Hungary (1)
777    :  198 : +Bence Barát, Hungary (0) 
444bf  :    8 : +Chester Lian, Malaysia (23) & István Kocza, Hungary (42)
555bf  :    6 :  Mike Hughey, USA (36)
333mbf :   45 :  István Kocza, Hungary (4)

+=ongoing streak
 
Last edited:
fastest 3x3 solvers who have smallest time difference between their average and single solve (sorted by average for example: 9.5avg 9.2 single 0.3 difference :D)
fastest 3x3 solvers who have biggest time difference between their average and single solve (sorted by average for example: 9.6 avg 6.8 single 2.8 difference :D)
 
giorgi said:
fastest 3x3 solvers who have smallest time difference between their average and single solve (sorted by average for example: 9.5avg 9.2 single 0.3 difference :D)
fastest 3x3 solvers who have biggest time difference between their average and single solve (sorted by average for example: 9.6 avg 6.8 single 2.8 difference :D)
Click to expand...
How can you have rank fastest solver and smallest difference in the same list. You would have to set a limit on of the qualifications.
 
giorgi said:
fastest 3x3 solvers who have smallest time difference between their average and single solve (sorted by average for example: 9.5avg 9.2 single 0.3 difference :D)
fastest 3x3 solvers who have biggest time difference between their average and single solve (sorted by average for example: 9.6 avg 6.8 single 2.8 difference :D)
Click to expand...

I made the list for top100 3x3 average.

Ratio
Code: 
Ratio	Average	Best	Name
1.4606	8.7200	5.9700	Drew Brads
1.4502	9.3100	6.4200	Marcin Zalewski
1.4325	8.8100	6.1500	Andrew Ricci
1.4025	8.9900	6.4100	Louis Cormier
1.3821	  8.5000	  6.1500	  Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)
1.3802	7.6600	5.5500	Mats Valk
1.3767	9.2100	6.6900	Yi-Heng Lee (李宜衡)
1.3547	8.2500	6.0900	Yumu Tabuchi (田渕雄夢)
1.3524	8.9800	6.6400	Jr-Wei Jang (張智瑋)
1.3503	9.0200	6.6800	SeungBeom Cho (조승범)
1.3492	9.3500	6.9300	Milán Baticz
1.3436	9.1900	6.8400	Nguyễn Ngọc Thịnh
1.3338	9.4300	7.0700	Mulun Yin (阴目仑)
1.3273	8.1100	6.1100	Michał Pleskowicz
1.3165	9.3600	7.1100	Daniil Lee
1.3156	8.9200	6.7800	Dario Roa Sánchez
1.3150	9.3100	7.0800	Erik Akkersdijk
1.3099	8.7500	6.6800	Ivan Vynnyk (Іван Винник)
1.3058	9.1800	7.0300	Mitsuki Gunji (郡司光貴)
1.3041	8.9200	6.8400	Arifumi Fushimi (伏見有史)
1.2968	9.0000	6.9400	Przemysław Kaleta
1.2924	8.8400	6.8400	Dmitry Dobrjakov
1.2892	  8.3800	  6.5000  	Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)
1.2871	9.1000	7.0700	Kevin Hays
1.2794	9.4800	7.4100	Austin Moore
1.2784	8.7700	6.8600	Sergey Ryabko
1.2780	8.2300	6.4400	Kevin Costello III
1.2761	8.6900	6.8100	Morten Arborg
1.2731	9.0900	7.1400	Xiaolin Zeng (曾小林)
1.2708	9.4800	7.4600	Weixing Zhang (张炜星)
1.2676	9.1900	7.2500	Edward Lin
1.2642	8.7100	6.8900	Che-Ting Chu (朱哲廷)
1.2617	7.5200	5.9600	Alexander Lau
1.2589	8.8500	7.0300	Leon Schmidtchen
1.2557	8.7900	7.0000	Yu Nakajima (中島悠)
1.2511	8.3200	6.6500	Breandan Vallance
1.2474	9.4300	7.5600	Zhouheng Sun (孙舟横)
1.2457	9.4300	7.5700	Jakub Kipa
1.2453	7.9700	6.4000	Sebastian Weyer
1.2453	8.6300	6.9300	Anthony Searle
1.2453	8.6300	6.9300	Anthony Brooks
1.2449	8.5400	6.8600	Giovanni Contardi
1.2404	8.7200	7.0300	Alexandre Carlier
1.2340	9.4400	7.6500	Moritz Patzelt
1.2338	8.9700	7.2700	Yi-Fan Wu (吳亦凡)
1.2327	9.4300	7.6500	Ravi Fernando
1.2306	8.7000	7.0700	Eric Limeback
1.2292	9.0100	7.3300	Harris Chan
1.2291	8.8000	7.1600	Gabriel Dechichi Barbar
1.2277	8.7900	7.1600	Antoine Cantin
1.2209	9.3400	7.6500	Kailong Li (李开隆)
1.2198	8.4900	6.9600	Vincent Hartanto Utomo
1.2192	8.9000	7.3000	Paolo Moriello
1.2172	9.3600	7.6900	Jinseong Kim (김진성)
1.2167	9.3200	7.6600	Christopher Olson
1.2113	8.3700	6.9100	Sei Sugama (洲鎌星)
1.2108	9.1900	7.5900	Justin Adsuara
1.2086	8.9800	7.4300	Thompson Clarke
1.2077	9.4200	7.8000	Ihor Bilchenko (Ігор Більченко)
1.2052	9.3400	7.7500	Jules Desjardin
1.1995	8.9600	7.4700	Yu Sajima (佐島優)
1.1994	8.0600	6.7200	Collin Burns
1.1986	  8.8700  	7.4000	  Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)
1.1940	9.4800	7.9400	Hunor Bózsing
1.1916	8.2700	6.9400	Rowe Hessler
1.1881	8.2100	6.9100	Robert Yau
1.1880	7.5200	6.3300	Lucas Etter
1.1828	  8.6700	  7.3300	  Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์)
1.1827	8.0900	6.8400	Richard Jay S. Apagar
1.1820	9.3500	7.9100	Harald Stiff
1.1816	8.7200	7.3800	Jayden McNeill
1.1785	9.4400	8.0100	Linus Rieß
1.1777	7.8200	6.6400	Philipp Weyer
1.1776	9.4800	8.0500	John Brechon
1.1770	9.3100	7.9100	Tomasz Żołnowski
1.1761	9.3500	7.9500	Yinghao Wang (王鹰豪)
1.1703	9.0700	7.7500	Kennan LeJeune
1.1613	9.4300	8.1200	Blake Thompson
1.1607	7.7300	6.6600	Bill Wang
1.1603	8.8300	7.6100	Patrick Ponce
1.1562	9.0300	7.8100	James Hamory
1.1555	6.5400	5.6600	Feliks Zemdegs
1.1550	7.6000	6.5800	Cornelius Dieckmann
1.1542	  8.4600  	7.3300  	Piti Pichedpan (ปิติ พิเชษฐพันธ์)
1.1538	9.0000	7.8000	Phillip Espinoza
1.1507	9.2400	8.0300	Antoine Piau
1.1469	8.9800	7.8300	Stefan Huber
1.1465	9.3900	8.1900	Sungho Hong (홍성호)
1.1400	9.0400	7.9300	Massimiliano Iovane
1.1400	9.0400	7.9300	Jacob Hutnyk
1.1373	8.7000	7.6500	Carlos Méndez García-Barroso
1.1354	9.3900	8.2700	Andy Tsao
1.1253	9.1600	8.1400	Dmitry Zvyagintsev
1.1245	9.3000	8.2700	Hendry Cahyadi
1.1227	8.4200	7.5000	Andy Smith
1.1121	8.4300	7.5800	Haowei Fan (樊浩玮)
1.1114	9.4800	8.5300	Howard Wong Jun Yen (黄俊仁)
1.0507	8.5000	8.0900	Martin Kraut
1.0434	  9.3800	  8.9900  	Natthaphat Mahtani (ณัฐภัทร จี มาทานี)
1.0357	8.9900	8.6800	Nikolay Evdokimov



Difference
Code: 
Diff	Average	Best	Name
2.8900	9.3100	6.4200	Marcin Zalewski
2.7500	8.7200	5.9700	Drew Brads
2.6600	8.8100	6.1500	Andrew Ricci
2.5800	8.9900	6.4100	Louis Cormier
2.5200	9.2100	6.6900	Yi-Heng Lee (李宜衡)
2.4200	9.3500	6.9300	Milán Baticz
2.3600	9.4300	7.0700	Mulun Yin (阴目仑)
2.3500	9.1900	6.8400	Nguyễn Ngọc Thịnh
2.3500	  8.5000	  6.1500  	Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)
2.3400	9.0200	6.6800	SeungBeom Cho (조승범)
2.3400	8.9800	6.6400	Jr-Wei Jang (張智瑋)
2.2500	9.3600	7.1100	Daniil Lee
2.2300	9.3100	7.0800	Erik Akkersdijk
2.1600	8.2500	6.0900	Yumu Tabuchi (田渕雄夢)
2.1500	9.1800	7.0300	Mitsuki Gunji (郡司光貴)
2.1400	8.9200	6.7800	Dario Roa Sánchez
2.1100	7.6600	5.5500	Mats Valk
2.0800	8.9200	6.8400	Arifumi Fushimi (伏見有史)
2.0700	9.4800	7.4100	Austin Moore
2.0700	8.7500	6.6800	Ivan Vynnyk (Іван Винник)
2.0600	9.0000	6.9400	Przemysław Kaleta
2.0300	9.1000	7.0700	Kevin Hays
2.0200	9.4800	7.4600	Weixing Zhang (张炜星)
2.0000	8.1100	6.1100	Michał Pleskowicz
2.0000	8.8400	6.8400	Dmitry Dobrjakov
1.9500	9.0900	7.1400	Xiaolin Zeng (曾小林)
1.9400	9.1900	7.2500	Edward Lin
1.9100	8.7700	6.8600	Sergey Ryabko
1.8800	8.6900	6.8100	Morten Arborg
1.8800  	8.3800  	6.5000  	Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)
1.8700	9.4300	7.5600	Zhouheng Sun (孙舟横)
1.8600	9.4300	7.5700	Jakub Kipa
1.8200	8.8500	7.0300	Leon Schmidtchen
1.8200	8.7100	6.8900	Che-Ting Chu (朱哲廷)
1.7900	9.4400	7.6500	Moritz Patzelt
1.7900	8.7900	7.0000	Yu Nakajima (中島悠)
1.7900	8.2300	6.4400	Kevin Costello III
1.7800	9.4300	7.6500	Ravi Fernando
1.7000	8.9700	7.2700	Yi-Fan Wu (吳亦凡)
1.7000	8.6300	6.9300	Anthony Searle
1.7000	8.6300	6.9300	Anthony Brooks
1.6900	8.7200	7.0300	Alexandre Carlier
1.6900	9.3400	7.6500	Kailong Li (李开隆)
1.6800	9.0100	7.3300	Harris Chan
1.6800	8.5400	6.8600	Giovanni Contardi
1.6700	8.3200	6.6500	Breandan Vallance
1.6700	9.3600	7.6900	Jinseong Kim (김진성)
1.6600	9.3200	7.6600	Christopher Olson
1.6400	8.8000	7.1600	Gabriel Dechichi Barbar
1.6300	8.7000	7.0700	Eric Limeback
1.6300	8.7900	7.1600	Antoine Cantin
1.6200	9.4200	7.8000	Ihor Bilchenko (Ігор Більченко)
1.6000	9.1900	7.5900	Justin Adsuara
1.6000	8.9000	7.3000	Paolo Moriello
1.5900	9.3400	7.7500	Jules Desjardin
1.5700	7.9700	6.4000	Sebastian Weyer
1.5600	7.5200	5.9600	Alexander Lau
1.5500	8.9800	7.4300	Thompson Clarke
1.5400	9.4800	7.9400	Hunor Bózsing
1.5300	8.4900	6.9600	Vincent Hartanto Utomo
1.4900	8.9600	7.4700	Yu Sajima (佐島優)
1.4700	  8.8700  	7.4000	Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)
1.4600	8.3700	6.9100	Sei Sugama (洲鎌星)
1.4400	9.3500	7.9100	Harald Stiff
1.4300	9.4800	8.0500	John Brechon
1.4300	9.4400	8.0100	Linus Rieß
1.4000	9.3100	7.9100	Tomasz Żołnowski
1.4000	9.3500	7.9500	Yinghao Wang (王鹰豪)
1.3400	8.7200	7.3800	Jayden McNeill
1.3400	  8.6700  	7.3300  	Thanaporn Sichanugrist (ธนพร สิชฌนุกฤษฎ์)
1.3400	8.0600	6.7200	Collin Burns
1.3300	8.2700	6.9400	Rowe Hessler
1.3200	9.0700	7.7500	Kennan LeJeune
1.3100	9.4300	8.1200	Blake Thompson
1.3000	8.2100	6.9100	Robert Yau
1.2500	8.0900	6.8400	Richard Jay S. Apagar
1.2200	8.8300	7.6100	Patrick Ponce
1.2200	9.0300	7.8100	James Hamory
1.2100	9.2400	8.0300	Antoine Piau
1.2000	9.0000	7.8000	Phillip Espinoza
1.2000	9.3900	8.1900	Sungho Hong (홍성호)
1.1900	7.5200	6.3300	Lucas Etter
1.1800	7.8200	6.6400	Philipp Weyer
1.1500	8.9800	7.8300	Stefan Huber
1.1300	  8.4600	  7.3300	  Piti Pichedpan (ปิติ พิเชษฐพันธ์)
1.1200	9.3900	8.2700	Andy Tsao
1.1100	9.0400	7.9300	Massimiliano Iovane
1.1100	9.0400	7.9300	Jacob Hutnyk
1.0700	7.7300	6.6600	Bill Wang
1.0500	8.7000	7.6500	Carlos Méndez García-Barroso
1.0300	9.3000	8.2700	Hendry Cahyadi
1.0200	7.6000	6.5800	Cornelius Dieckmann
1.0200	9.1600	8.1400	Dmitry Zvyagintsev
0.9500	9.4800	8.5300	Howard Wong Jun Yen (黄俊仁)
0.9200	8.4200	7.5000	Andy Smith
0.8800	6.5400	5.6600	Feliks Zemdegs
0.8500	8.4300	7.5800	Haowei Fan (樊浩玮)
0.4100	8.5000	8.0900	Martin Kraut
0.3900	  9.3800	  8.9900  	Natthaphat Mahtani (ณัฐภัทร จี มาทานี)
0.3100	8.9900	8.6800	Nikolay Evdokimov
 
TheNextFeliks said:
Most solves without dnf in any event?
Click to expand...

Stefan said:
Almost. Bernett also has 1/1 in 5BLD and Jasmin is 34/34 in Clock, not 38/38. (Yes, I know you understood the task differently, but you made me check this :)).
Click to expand...

I did interpret it differently. I was thinking it was longest streak of solves without a DNF, but based on the results I figure that the question is asking for the largest number of solves by a person who has never received a DNF in that event.
 
Another interpretation:

Using data from WCA_export470_20140911 and Stefan's WCA statistics tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Solves[/TD][TD]Events[/TD][/TR]
[TR][TD]Zbigniew Zborowski[/TD][TD="align:right"]316[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Alexis Rodrigo Cazu Mendoza[/TD][TD="align:right"]290[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Krzysztof Rożałowski[/TD][TD="align:right"]255[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Jan-Niklas Krüger[/TD][TD="align:right"]238[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Yui Tomita (富田唯依)[/TD][TD="align:right"]238[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Shuangbin Feng (冯爽彬)[/TD][TD="align:right"]232[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Michał Orylski[/TD][TD="align:right"]205[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Sonia Reinert[/TD][TD="align:right"]180[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Luis Gerardo Martínez Hernández[/TD][TD="align:right"]179[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Skanda Kodunad[/TD][TD="align:right"]165[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Ardnarong Lertsangsuwan (อาจณรงค์ เลิศแสงสุวรรณ)[/TD][TD="align:right"]158[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Florian Daumann[/TD][TD="align:right"]157[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Tam Ming Ki[/TD][TD="align:right"]155[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Daniel Cofreces[/TD][TD="align:right"]154[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Zelin Chen (陈泽霖)[/TD][TD="align:right"]144[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Carsten Matheus[/TD][TD="align:right"]143[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Josh Rotholz[/TD][TD="align:right"]139[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Iuliana Steluța Negură[/TD][TD="align:right"]137[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Jairo Andres Gutierrez[/TD][TD="align:right"]131[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Avinash Bhattarmakki[/TD][TD="align:right"]131[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Soichi Akamatsu (赤松聡一)[/TD][TD="align:right"]130[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Kevin De Silva[/TD][TD="align:right"]126[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Vincent Drouot[/TD][TD="align:right"]126[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Alexander Wong[/TD][TD="align:right"]125[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Ivan Putilov[/TD][TD="align:right"]125[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Jithin Prakash Karimbanakkal[/TD][TD="align:right"]125[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Noah Killian[/TD][TD="align:right"]121[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Jin Yang (杨晋)[/TD][TD="align:right"]120[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Guolang Deng (邓果琅)[/TD][TD="align:right"]117[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Víctor Manuel Zapién Luna[/TD][TD="align:right"]114[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Javier Enrique Espinoza Grijalva[/TD][TD="align:right"]114[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Chloé Ebro[/TD][TD="align:right"]114[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Wagner Victor Paiva Morais[/TD][TD="align:right"]112[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Canxing Zhang (张灿星)[/TD][TD="align:right"]112[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kai Ito (井藤魁)[/TD][TD="align:right"]112[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Giulio Chiminelli[/TD][TD="align:right"]112[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Alex McIntosh[/TD][TD="align:right"]111[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Kuba Winiarski[/TD][TD="align:right"]110[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Mclein Lubiano[/TD][TD="align:right"]108[/TD][TD="align:right"]9[/TD][/TR]
[TR][TD]Joost Franssen[/TD][TD="align:right"]107[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Luis Roberto Franco Esquivel[/TD][TD="align:right"]105[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Xiaoxue Zhou (周晓学)[/TD][TD="align:right"]105[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Arvind Nawal[/TD][TD="align:right"]105[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Stefan Kodrnja[/TD][TD="align:right"]104[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]Thierry Tremblay-Filion[/TD][TD="align:right"]104[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Georgia Fisher[/TD][TD="align:right"]103[/TD][TD="align:right"]8[/TD][/TR]
[TR][TD]Grant Tregay[/TD][TD="align:right"]103[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Zhenzhong Huang (黄振中)[/TD][TD="align:right"]103[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Xiaodong Sun (孙晓东)[/TD][TD="align:right"]102[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Amier Edy Adlan Bin Sanusi[/TD][TD="align:right"]102[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Dylan Clark[/TD][TD="align:right"]101[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Habin Kim (김하빈)[/TD][TD="align:right"]100[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]Muhammad Belva Ababil[/TD][TD="align:right"]100[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Patryk Szczepański[/TD][TD="align:right"]100[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]Zhukun Zhong (钟柱坤)[/TD][TD="align:right"]100[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Lim Teck Fu[/TD][TD="align:right"]100[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]Sarah Willemart[/TD][TD="align:right"]100[/TD][TD="align:right"]4[/TD][/TR]
[/TABLE]

Code: 
SELECT
  personId Cuber,
  sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) Solves,
  count(distinct eventId) Events
FROM Results
GROUP BY personId
HAVING sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) = 0 and Solves >= 100
ORDER BY Solves desc, Events desc;
 
Last edited:
What's the smallest total time difference between two competitors who have competed in at least 10 of the same events?

For example, between Faz and Mats:
333single: |5.66-5.55|=0.11
333average:|6.54-7.66|=1.16
444single:|24.66-26.47|=1.81
444average:|28.47-30.93|=2.46
etc.

What's the smallest value of the above where both competitors have 10 events in common?
 
supercavitation said:
What's the smallest total time difference between two competitors who have competed in at least 10 of the same events?

For example, between Faz and Mats:
333single: |5.66-5.55|=0.11
333average:|6.54-7.66|=1.16
444single:|24.66-26.47|=1.81
444average:|28.47-30.93|=2.46
etc.

What's the smallest value of the above where both competitors have 10 events in common?
Click to expand...
https://www.worldcubeassociation.org/results/p.php?i=2012RUPE01 and i are pretty even in 2-7 pyra and tiny bit sq1 i quess
 
Most solves in one event is Erik with 1376 in 3x3. Sebastien is only one solve behind. Third is Ron with 1291. Tomasz is only one solve behind.

Using data from WCA_export470_20140911 and Stefan's WCA statistics tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Event[/TD][TD]Solves[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1376[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1375[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1291[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1290[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1242[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1227[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1219[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]2x2 Cube[/TD][TD="align:right"]1214[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1195[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1109[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1097[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1077[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]2x2 Cube[/TD][TD="align:right"]1063[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1029[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1010[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]4x4 Cube[/TD][TD="align:right"]972[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]Pyraminx[/TD][TD="align:right"]901[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD]Rubik's Cube[/TD][TD="align:right"]898[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]3x3 one-handed[/TD][TD="align:right"]898[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD]Rubik's Cube[/TD][TD="align:right"]896[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD]Rubik's Cube[/TD][TD="align:right"]888[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]4x4 Cube[/TD][TD="align:right"]878[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]Pyraminx[/TD][TD="align:right"]872[/TD][/TR]
[TR][TD]Devin Corr-Robinett[/TD][TD]Rubik's Cube[/TD][TD="align:right"]856[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD]Rubik's Cube[/TD][TD="align:right"]843[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD]Rubik's Cube[/TD][TD="align:right"]840[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]4x4 Cube[/TD][TD="align:right"]817[/TD][/TR]
[TR][TD]Lorenzo Vigani Poli[/TD][TD]Rubik's Cube[/TD][TD="align:right"]797[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]3x3 one-handed[/TD][TD="align:right"]793[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD]5x5 Cube[/TD][TD="align:right"]792[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD]Rubik's Cube[/TD][TD="align:right"]792[/TD][/TR]
[TR][TD]Jan Bentlage[/TD][TD]Rubik's Cube[/TD][TD="align:right"]787[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]2x2 Cube[/TD][TD="align:right"]779[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD]Rubik's Cube[/TD][TD="align:right"]777[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD]Rubik's Cube[/TD][TD="align:right"]772[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD]4x4 Cube[/TD][TD="align:right"]766[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD]Rubik's Cube[/TD][TD="align:right"]749[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD]3x3 one-handed[/TD][TD="align:right"]742[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]2x2 Cube[/TD][TD="align:right"]738[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD]Rubik's Cube[/TD][TD="align:right"]734[/TD][/TR]
[TR][TD]Nobuaki Suga (菅信昭)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]728[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD]3x3 one-handed[/TD][TD="align:right"]724[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD]5x5 Cube[/TD][TD="align:right"]724[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD]Rubik's Cube[/TD][TD="align:right"]716[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD]Rubik's Cube[/TD][TD="align:right"]714[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD]2x2 Cube[/TD][TD="align:right"]708[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD]4x4 Cube[/TD][TD="align:right"]703[/TD][/TR]
[TR][TD]François Courtès[/TD][TD]3x3 one-handed[/TD][TD="align:right"]702[/TD][/TR]
[/TABLE]

Code: 
SELECT
  personId Cuber,
  eventId Event,
  sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) Solves
FROM Results
GROUP BY personId, eventId
HAVING Solves >= 700
ORDER BY solves desc;
 
Last edited:
How can I check what is the time that appears more times in MY profile?
I found manually that in 2x2 I did two 5.78, but is there any program that can find more? Imagine being François Courtès, you won't check manually.

Thanks
 
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
186
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
431
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
483
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,038
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,500
Discomantis
Discomantis
Back
Top