Rubiks560
Nub
Can someone confirm if nationals 2015 was the worlds closest 3x3 podium?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Can someone confirm if nationals 2015 was the worlds closest 3x3 podium?
[NOPARSE]SELECT competitionId 'Competition',
min(average) 'Min[T]',
max(average) 'Max[T]',
max(average) / min(average) Ratio,
count(*) People
FROM Results
WHERE eventId='333' and roundId in ('f', 'c') AND pos<=3 AND average>0
GROUP BY competitionId
ORDER BY 4
LIMIT 10[/NOPARSE]
[NOPARSE]SELECT competitionId 'Competition',
min(average) 'Min[T]',
max(average) 'Max[T]',
max(average) - min(average) 'Diff[T]',
count(*) People
FROM Results
WHERE eventId='333' and roundId in ('f', 'c') AND pos<=3 AND average>0
GROUP BY competitionId
ORDER BY 4
LIMIT 10[/NOPARSE]
Using data from WCA_export073_20150818 and Stefan's WCA Data Tools.
[TABLE="class:grid,align:left"]
[TR][TD]Competition[/TD][TD]Min[/TD][TD]Max[/TD][TD]Ratio[/TD][TD]People[/TD][/TR]
[TR][TD]Bandung Open 2011[/TD][TD="align:right"]14.10[/TD][TD="align:right"]14.12[/TD][TD="align:right"]1.0014[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]FNSM 2015[/TD][TD="align:right"]13.01[/TD][TD="align:right"]13.05[/TD][TD="align:right"]1.0031[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Jogjakarta Open 2013[/TD][TD="align:right"]10.15[/TD][TD="align:right"]10.20[/TD][TD="align:right"]1.0049[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Slovenian Open 2014[/TD][TD="align:right"]11.07[/TD][TD="align:right"]11.13[/TD][TD="align:right"]1.0054[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Berkeley Spring 2013[/TD][TD="align:right"]11.01[/TD][TD="align:right"]11.07[/TD][TD="align:right"]1.0054[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Kansai Open 2012[/TD][TD="align:right"]11.19[/TD][TD="align:right"]11.26[/TD][TD="align:right"]1.0063[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]US Nationals 2015[/TD][TD="align:right"]8.33[/TD][TD="align:right"]8.39[/TD][TD="align:right"]1.0072[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Zhejiang 2013[/TD][TD="align:right"]10.94[/TD][TD="align:right"]11.02[/TD][TD="align:right"]1.0073[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Kharkiv Open 2014[/TD][TD="align:right"]10.78[/TD][TD="align:right"]10.87[/TD][TD="align:right"]1.0083[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Cyber Open 2011[/TD][TD="align:right"]11.72[/TD][TD="align:right"]11.82[/TD][TD="align:right"]1.0085[/TD][TD="align:right"]3[/TD][/TR]
[/TABLE]
Code:[NOPARSE]SELECT competitionId 'Competition', min(average) 'Min[T]', max(average) 'Max[T]', max(average) / min(average) Ratio, count(*) People FROM Results WHERE eventId='333' and roundId in ('f', 'c') AND pos<=3 AND average>0 GROUP BY competitionId ORDER BY 4 LIMIT 10[/NOPARSE]Using data from WCA_export073_20150818 and Stefan's WCA Data Tools.
[TABLE="class:grid,align:left"]
[TR][TD]Competition[/TD][TD]Min[/TD][TD]Max[/TD][TD]Diff[/TD][TD]People[/TD][/TR]
[TR][TD]Bandung Open 2011[/TD][TD="align:right"]14.10[/TD][TD="align:right"]14.12[/TD][TD="align:right"]0.02[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]FNSM 2015[/TD][TD="align:right"]13.01[/TD][TD="align:right"]13.05[/TD][TD="align:right"]0.04[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Jogjakarta Open 2013[/TD][TD="align:right"]10.15[/TD][TD="align:right"]10.20[/TD][TD="align:right"]0.05[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]US Nationals 2015[/TD][TD="align:right"]8.33[/TD][TD="align:right"]8.39[/TD][TD="align:right"]0.06[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Slovenian Open 2014[/TD][TD="align:right"]11.07[/TD][TD="align:right"]11.13[/TD][TD="align:right"]0.06[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Berkeley Spring 2013[/TD][TD="align:right"]11.01[/TD][TD="align:right"]11.07[/TD][TD="align:right"]0.06[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Kansai Open 2012[/TD][TD="align:right"]11.19[/TD][TD="align:right"]11.26[/TD][TD="align:right"]0.07[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Zhejiang 2013[/TD][TD="align:right"]10.94[/TD][TD="align:right"]11.02[/TD][TD="align:right"]0.08[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]Kharkiv Open 2014[/TD][TD="align:right"]10.78[/TD][TD="align:right"]10.87[/TD][TD="align:right"]0.09[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]CanadianCUBING 50 2014[/TD][TD="align:right"]9.43[/TD][TD="align:right"]9.52[/TD][TD="align:right"]0.09[/TD][TD="align:right"]3[/TD][/TR]
[/TABLE]
Code:[NOPARSE]SELECT competitionId 'Competition', min(average) 'Min[T]', max(average) 'Max[T]', max(average) - min(average) 'Diff[T]', count(*) People FROM Results WHERE eventId='333' and roundId in ('f', 'c') AND pos<=3 AND average>0 GROUP BY competitionId ORDER BY 4 LIMIT 10[/NOPARSE]
Is there any person with a 3BLD single faster then their 3x3 single/avarege? Or, more generally, who has the lowest 3BLD single/3x3 single ratio? Also for 4x4 and 5x5.
Today at ABHC 2015, I got a 31 move solution with CFOP. This was my first competition fmc attempt. Is this a record? Also, this was my first ever attempt. Is that UWR?
Today at ABHC 2015, I got a 31 move solution with CFOP. This was my first competition fmc attempt. Is this a record? Also, this was my first ever attempt. Is that UWR?
[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Event[/TD][TD]Time[/TD][/TR]
[TR][TD]Cale Schoon, USA[/TD][TD]333fm[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]Joon Cha, Korea[/TD][TD]333fm[/TD][TD="align:right"]25[/TD][/TR]
[TR][TD]Matthew Bahner, USA[/TD][TD]333fm[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Ali Salavati (علی صلواتی), Iran[/TD][TD]333fm[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Fang Qin (秦方), China[/TD][TD]333fm[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]David Woner, USA[/TD][TD]333fm[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]Michael Young, USA[/TD][TD]333fm[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]Claudio Müller, Switzerland[/TD][TD]333fm[/TD][TD="align:right"]27[/TD][/TR]
[TR][TD]Olivier Stietel, France[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Juan Camilo Vargas, Colombia[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Johan Sokrates Wind, Norway[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Matěj Grohmann, Czech Republic[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Sebastiano Tronto, Italy[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Evgeny Akivis, Russia[/TD][TD]333fm[/TD][TD="align:right"]28[/TD][/TR]
[TR][TD]Mirek Goljan, Czech Republic[/TD][TD]333fm[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Hiroki Iwashita (岩下大輝), Japan[/TD][TD]333fm[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Hongfei Tian (田洪飞), China[/TD][TD]333fm[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Peter Hung, USA[/TD][TD]333fm[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]ChoongMyoung Lee (이충명), Korea[/TD][TD]333fm[/TD][TD="align:right"]30[/TD][/TR]
[TR][TD]Justin Jaffray, Canada[/TD][TD]333fm[/TD][TD="align:right"]30[/TD][/TR]
[/TABLE]
You're far from the top, Kian Barry got 39 podiums without a win (14+25).most podiums without ever being first? I feel like I could be pretty much on the top for that ranking![]()
Here you go:Could you do this but with DNFs included? I know that Matthew Bahner got two DNFs to start at Nationals, before he got his 26.
I think there should really be a place on the WCA showing "current leaders" or something like that, which is a ranking of the average official average for each person from the last year.