Top 15 3x3 finals so far this year

[4EverCuber]

So I was a bit bored, and curious as to what the fastest times were for the winner in the final round of a competition this year. I compiled a small list of the top 15 results taken from scouring the WCA site. I put them in order starting with the fastest average:

Felix Zemdegs – Best/Average: 7.31/7.87 – Melbourne Summer Open 2011
Felix Zemdegs – Best/Average: 6.24/8.07 – Kubaroo Open 2011
Mats Valk – Best/Average: 8.02/9.09 – German Open 2011
Piti Pichedpan – Best/Average: 7.68/9.28 – Thailand Open 2011
Michal Pleskowicz – Best/Average: 9.00/9.35 – Bialystok Open 2011
Rowe Hessler – Best/Average: 9.06/9.46 – Park Ridge Open 2011
Rowe Hessler – Best/Average: 9.08/9.46 – Brown Cubing Day 2011
Mulun Yin – Best/Average: 8.91/9.47 – Xi'an Spring 2011
Cornelius Dieckmann – Best/Average: 7.52/9.49 – Aachen Open 2011
Kanneti Sae Han – Best/Average: 8.58/9.63 – Montpellier Open 2011
Dan Cohen – Best/Average: 7.59/9.69 – Captain's Cove competition 2011
Michal Pleskowicz – Best/Average: 8.03/9.83 – 3Mola Open 2011
Sebastian Weyer – Best/Average: 9.30/9.84 – GHS Ingenhovenpark Open 2011
Cornelius Dieckmann – Best/Average: 8.71/9.86 – Hamburg Open 2011
Giovanni Contardi – Best/Average: 7.75/10.02 – Italian Rubik's Cube Championship 2011

I've yet to go to a tournament, let alone compete, so I can't imagine the pressure a cuber must be under. I'm wondering what the fastest time/average will be at the worlds? Any thoughts? Sub or sup 10?

 

[ZalEw]

It wouldn't be better, if you had written best solve in every round of every competiton in this year instead of best from best average ?

 

[4EverCuber]

It wouldn't be better, if you had written best solve in every round of every competiton in this year instead of best from best average ?

I guess I was trying to emphasize the averages in the final rounds because isn't that what counts when it comes to winning the tournament?

 

[Mr.Toad]

Top 100

Top 100:

+--------------------------------+---------+------+---------------------------+
| person                         | average | best | competitionId             |
+--------------------------------+---------+------+---------------------------+
| Feliks Zemdegs                 |     787 |  731 | MelbourneSummer2011       |
| Feliks Zemdegs                 |     807 |  624 | KubarooOpen2011           |
| Mats Valk                      |     909 |  802 | GermanOpen2011            |
| Piti Pichedpan                 |     928 |  768 | ThailandOpen2011          |
| Michal Pleskowicz              |     935 |  900 | BialystokOpen2011         |
| Rowe Hessler                   |     946 |  906 | ParkRidgeOpen2011         |
| Rowe Hessler                   |     946 |  908 | Brown2011                 |
| Mulun Yin (Úÿ┤þø«õ╗æ)          |     947 |  891 | XianSpring2011            |
| Cornelius Dieckmann            |     949 |  752 | AachenOpen2011            |
| Kanneti Sae Han                |     963 |  858 | MontpellierOpen2011       |
| Dan Cohen                      |     969 |  759 | CaptainsCove2011          |
| Michal Pleskowicz              |     983 |  803 | 3MolaOpen2011             |
| Sebastian Weyer                |     984 |  930 | GHSIngenhovenparkOpen2011 |
| Cornelius Dieckmann            |     986 |  871 | HamburgOpen2011           |
| Sebastian Weyer                |     991 |  852 | GermanOpen2011            |
| Giovanni Contardi              |    1002 |  775 | ItalianChampionship2011   |
| Ravi Fernando                  |    1006 |  886 | StanfordSpring2011        |
| Kanneti Sae Han                |    1009 |  888 | France2011                |
| Erik Akkersdijk                |    1011 |  903 | HamburgOpen2011           |
| Kailong Li (µØÄÕ╝ÇÚÜå)         |    1019 |  933 | ShenzhenUniversity2011    |
| Haowei Fan (µ¿èµÁ®þÄ«)         |    1020 |  961 | XianSummer2011            |
| Dan Cohen                      |    1022 |  908 | ParkRidgeOpen2011         |
| Stefan Huber                   |    1025 |  966 | MilanCubeOpen2011         |
| Hao-Zheng Lin (µ×ùµÁ®µ¡ú)      |    1026 |  938 | CubikBoxCup2011           |
| Sebastian Weyer                |    1027 |  855 | HamburgOpen2011           |
| Ravi Fernando                  |    1028 |  869 | VidarOpen2011             |
| Cornelius Dieckmann            |    1030 |  981 | GermanOpen2011            |
| Yu Sajima (õ¢ÉÕ│ Õä¬)         |    1031 |  869 | MatsudoSpring2011         |
| Kanneti Sae Han                |    1031 |  921 | BreizhOpen2011            |
| Jr-Wei Jang (Õ╝ÁµÖ║þæï)        |    1032 |  981 | CubikBoxCup2011           |
| Joar Mellstr├Âm                |    1034 |  977 | NorwegianOpen2011         |
| Giovanni Contardi              |    1036 |  853 | RomaOpen2011              |
| Sergey Ryabko                  |    1036 |  950 | KyivOpen2011              |
| Mulun Yin (Úÿ┤þø«õ╗æ)          |    1039 |  927 | FloatingClouds2011        |
| Piti Pichedpan                 |    1040 |  877 | TCAChampionship2011       |
| Peerawich Hiranpaphakorn       |    1040 |  969 | TCAChampionship2011       |
| Yumu Tabuchi (þö░µ©òÚøäÕñó)    |    1041 |  841 | Osaka2011                 |
| Paolo Moriello                 |    1046 |  903 | RomaOpen2011              |
| Erik Akkersdijk                |    1046 |  918 | DanishOpen2011            |
| Anson Lin                      |    1046 |  950 | AucklandAutumn2011        |
| Harris Chan                    |    1047 |  977 | CUBEcentric2011           |
| Yi-Heng Lee (µØÄÕ«£Þíí)        |    1050 |  934 | TaiwanWinterOpen2011      |
| Kanneti Sae Han                |    1052 |  994 | NeptuneOpen2011           |
| Andy Tsao                      |    1053 |  852 | HarvardSpring2011         |
| Giovanni Contardi              |    1054 |  897 | MantuaSpring2011          |
| Morten Arborg                  |    1055 |  888 | HelsinkiOpen2011          |
| Nipat Charoenpholphant         |    1056 |  933 | TCAChampionship2011       |
| Paolo Moriello                 |    1059 |  943 | BigCubingItalyOpen2011    |
| Sebastian Weyer                |    1062 |  997 | AlaniaOpen2011            |
| Philipp Weyer                  |    1064 |  943 | HamburgOpen2011           |
| Morten Arborg                  |    1064 |  944 | DanishOpen2011            |
| Mats Valk                      |    1065 |  869 | NemoAmsterdamOpen2011     |
| Sergey Ryabko                  |    1065 |  963 | BialystokOpen2011         |
| Dan Cohen                      |    1068 |  925 | MallOfAmerica2011         |
| Baramee Pookcharoen            |    1068 |  947 | ThailandOpen2011          |
| Milán Baticz                  |    1070 |  930 | HelsinkiOpen2011          |
| Asia Konvittayayotin           |    1070 |  963 | TCAChampionship2011       |
| Sei Sugama (µ┤▓ÚÄî µÿƒ)        |    1071 |  969 | KansaiNewYear2011         |
| Breandan Vallance              |    1074 |  952 | AachenOpen2011            |
| Sebastian Weyer                |    1075 |  903 | AachenOpen2011            |
| Mats Valk                      |    1077 |  966 | AachenOpen2011            |
| Austin Moore                   |    1080 |  818 | DixonOpen2011             |
| Kanneti Sae Han                |    1082 |  980 | FrenchOpen2011            |
| John Tamanas                   |    1082 | 1052 | CaptainsCove2011          |
| Mitchell Stern                 |    1084 |  953 | WashingtonDCWinter2011    |
| Carlos M├®ndez Garc├¡a-Barroso |    1087 | 1031 | CastellonOpen2011         |
| Rowe Hessler                   |    1089 |  978 | SJCWinter2011             |
| Weixing Zhang (Õ╝áþ飵ÿƒ)      |    1091 |  988 | ShenzhenUniversity2011    |
| Daiki Matsumoto (µØ¥µ£¼ÕñºÞ╝Ø) |    1091 | 1003 | Osaka2011                 |
| Philipp Weyer                  |    1092 | 1031 | AlaniaOpen2011            |
| Michal Pleskowicz              |    1093 |  905 | LodzOpen2011              |
| Teo Kai Xiang                  |    1095 |  883 | NUS2011                   |
| Suchakree Ladavarn             |    1096 |  952 | ThailandOpen2011          |
| Dan Cohen                      |    1097 |  918 | MITSpring2011             |
| Harris Chan                    |    1098 |  990 | TorontoWinter2011         |
| Ville Seppänen                |    1099 |  930 | KirkkonummiOpen2011       |
| Bj├Ârn Korbanka                |    1101 | 1056 | Altbier2011               |
| Jan Smarschevski               |    1102 | 1002 | AlaniaOpen2011            |
| Hao-Zheng Lin (µ×ùµÁ®µ¡ú)      |    1102 | 1033 | TaiwanSpringOpen2011      |
| Paolo Moriello                 |    1103 |  969 | MantuaSpring2011          |
| Haowei Fan (µ¿èµÁ®þÄ«)         |    1106 |  911 | XianSpring2011            |
| Breandan Vallance              |    1107 |  900 | MantuaSpring2011          |
| Eric Limeback                  |    1107 | 1061 | TorontoWinter2011         |
| Erik Akkersdijk                |    1108 |  900 | AachenOpen2011            |
| Edward Lin                     |    1108 | 1021 | StanfordWinter2011        |
| Tomasz Zolnowski               |    1112 |  916 | 3MolaOpen2011             |
| Edward Lin                     |    1112 |  975 | StanfordSpring2011        |
| Breandan Vallance              |    1113 |  903 | DanishOpen2011            |
| Ravi Fernando                  |    1113 | 1041 | StanfordWinter2011        |
| Amos Tay Swee Hui              |    1115 | 1015 | Petrosains2011            |
| Zhouheng Sun (Õ¡ÖÞꃵ¿¬)       |    1116 |  940 | ChangzhouSpring2011       |
| Emily Wang                     |    1122 |  952 | TorontoWinter2011         |
| Yu Sajima (õ¢ÉÕ│ Õä¬)         |    1122 | 1027 | Osaka2011                 |
| Adam Polkowski                 |    1122 | 1083 | LodzOpen2011              |
| Chio Wai Cheng (ÞÂÖÕüëþ¿ï)     |    1124 |  988 | OneToEight2011            |
| Arifumi Fushimi (õ╝ÅުﵣëÕÅ▓) |    1126 |  916 | MatsudoSpring2011         |
| Tomasz Zolnowski               |    1128 |  890 | BialystokOpen2011         |
| Anthony Brooks                 |    1129 |  969 | SJCWinter2011             |
| Tomasz Zolnowski               |    1129 |  972 | LodzOpen2011              |
| Asia Konvittayayotin           |    1130 |  844 | ThailandOpen2011          |
+--------------------------------+---------+------+---------------------------+

	select personName person, average, best, competitionId
	  from results, competitions
	 where competitionId = id
	   and year = 2011
	   and average > 0
	   and eventId = '333'
	   and roundId = 'f'
	 order by average, best
	 limit 100;

 

[irontwig]

I think podium sum is a better indication of the quality of the final.

 

[vcuber13]

you cant spell

 

[Stefan]

Toad, there's the possibility of combined finals (roundId='c'). Though for 3x3x3 it only ever happened once, in 2009, so your results are still correct.

How often events had combined finals:

+----------------------------+----------------+
| event                      | combinedFinals |
+----------------------------+----------------+
| Rubik's Cube               |              1 |
| 5x5 Cube: Blindfolded      |              1 |
| Rubik's Cube: Fewest moves |              1 |
| Master Magic               |              1 |
| 4x4 Cube: Blindfolded      |              2 |
| Rubik's Cube: With feet    |             21 |
| 2x2 Cube                   |             22 |
| Pyraminx                   |             29 |
| Rubik's Clock              |             32 |
| Rubik's Cube: Blindfolded  |             62 |
| 6x6 Cube                   |             93 |
| 7x7 Cube                   |            102 |
| Square-1                   |            106 |
| Rubik's Cube: One-handed   |            124 |
| Megaminx                   |            152 |
| 4x4 Cube                   |            295 |
| 5x5 Cube                   |            300 |
+----------------------------+----------------+

SELECT   event.name event, count(distinct competitionId) combinedFinals
FROM     Results, Events event
WHERE    roundId='c' AND event.id=eventId
GROUP BY eventId
ORDER BY combinedFinals;

 

[collinbxyz]

lolRowe

same average in both comps...

 

[Mr.Toad]

Oh, I didn't thought about that, I just made the assumption since I'd never heard about a combined final for 3x3.

By the way, in the table "rounds" of the DB, what is the field "rank" for? Has there ever been a ranking by points or is this something to implement?

Percentage of combined finals:

+---------------------+----------+--------+-------+
| event               | combined | finals | %     |
+---------------------+----------+--------+-------+
| 7x7 Cube            |      102 |    162 | 62.96 |
| 6x6 Cube            |       93 |    163 | 57.06 |
| 5x5 Cube            |      300 |    559 | 53.67 |
| Megaminx            |      152 |    320 | 47.50 |
| 4x4 Cube            |      295 |    666 | 44.29 |
| Square-1            |      106 |    394 | 26.90 |
| 3x3 one-handed      |      124 |    670 | 18.51 |
| 3x3 with feet       |       21 |    124 | 16.94 |
| Rubik's Clock       |       32 |    257 | 12.45 |
| 3x3 blindfolded     |       62 |    650 | 9.54  |
| Pyraminx            |       29 |    424 | 6.84  |
| 2x2 Cube            |       22 |    624 | 3.53  |
| 4x4 blindfolded     |        2 |    194 | 1.03  |
| 5x5 blindfolded     |        1 |    111 | 0.90  |
| 3x3 fewest moves    |        1 |    208 | 0.48  |
| Master Magic        |        1 |    396 | 0.25  |
| Rubik's Cube        |        1 |    747 | 0.13  |
| Rubik's Magic       |        0 |    535 | 0.00  |
| 3x3 multi blind     |        0 |    199 | 0.00  |
| 3x3 multi blind old |        0 |     60 | 0.00  |
+---------------------+----------+--------+-------+


select e.cellName event, if(c is not null, c, 0) combined, finals, format((if(c is not null, c, 0)/finals)*100,2) '%'
  from events e,
		(
		select eventId, count(distinct competitionId) finals
		  from results
		 group by eventId
		) r1 left join
		(
		 select eventId, count(distinct competitionId) c
		  from results
		 where roundId = 'c'
		 group by eventId
		) r2
		on r1.eventId = r2.eventId
 where r1.eventId = e.id
 order by combined/finals desc, finals desc;

 

[Stefan]

Rank is just our internal ordering for display, so the system knows to show first round before final, or 5x5x5 before 2x2x2 (events have ranks as well).

 

[uberCuber]

Who the hell is Felix Zemdegs?

And why is Feliks not on the list when he is the WR holder?

 

[4EverCuber]

Who the hell is Felix Zemdegs?

And why is Feliks not on the list when he is the WR holder?

Oh my gosh....just realized that I spelled his name wrong. *sigh* I feel so bad. I usually don't make mistakes like this. Sorry Feliks.