Odd WCA stats/ Stats request Thread

cubizh · Sep 18, 2013

CubeRoots said:
i think you made mistake. look at Conn Talbot.

Yes I did. I shouldn't be doing this so late at night. I counted DNF/DNS's as "best" instead of "worse" (as they are stored as -1/-2). I'll fix it. Thank you.

EDIT: Fixed now.

ben1996123 said:
okso, let n be the integer part of someones 3x3 pb

Average or single?

Michael Womack · Sep 18, 2013

Has there ever been anyone who has gotten an AVG something similar to this one 3x3 AVG 12.32, 10.40, 12.32, 9.90, 12.32 where 3 or more of the times are the same.

TheNextFeliks · Sep 18, 2013

Michael Womack said:
Has there ever been anyone who has gotten an AVG something similar to this one 3x3 AVG 12.32, 10.40, 12.32, 9.90, 12.32 where 3 or more of the times are the same.

:fp look up about five posts to cubizh's standard deviation. At least one.

TMOY · Sep 18, 2013

Three identical times don't necessarily happen on the three counting solves. What we can deduce from cubizh's posts is that there can't be 4 or more identical times in the same average, but 3 is still possible.

And what about other events ? I havealready gotten three identical counting times at 2^3 once, for example.

Robert-Y · Sep 18, 2013

The only thing I can think of is Yu Nakajima's 3x3x3 times in the WC11 semi finals: 10.52 11.43 9.69 9.69 9.69

I wonder about his reaction

PM 1729 · Sep 18, 2013

With magic and master magic:

Code:

+----------------------------------------------------------------+---------+--------+--------+--------+--------+--------+
| personName                                                     | eventId | value1 | value2 | value3 | value4 | value5 |
+----------------------------------------------------------------+---------+--------+--------+--------+--------+--------+
| Lacey Burton                                                   | magic   |    222 |    244 |    244 |    287 |    244 |
| Gábor Szabó                                                    | mmagic  |    381 |    380 |    384 |    384 |    384 |
| Erik Clemente                                                  | magic   |    175 |    175 |    208 |    183 |    175 |
| Kei Suga (須賀慶)                                              | magic   |    209 |    155 |    155 |    155 |    296 |
| Marcos Ameijeiras Moreno                                       | magic   |    146 |    146 |    146 |    130 |    234 |
| Eric Limeback                                                  | magic   |    128 |    128 |     -1 |    128 |    155 |
| Joshua Satterfield                                             | magic   |    261 |     -1 |    261 |    261 |    344 |
| Arifumi Fushimi (伏見有史)                                     | magic   |    377 |    152 |    158 |    152 |    152 |
| Weston Mizumoto                                                | magic   |    191 |    171 |    171 |    171 |    156 |
| Lee Chun Hin (李震軒)                                          | magic   |    102 |     96 |    102 |    102 |     -1 |
| Hui Hing Ho (許鑫豪)                                           | magic   |    136 |     -1 |    140 |    136 |    136 |
| Zi-Jie Gong                                                    | 333     |   2134 |   2486 |   2090 |   2090 |   2090 |
| Olivier Polspoel                                               | magic   |    172 |    172 |    172 |    309 |    169 |
| Tse Shun Him (谢顺谦)                                          | magic   |    127 |    121 |    121 |    121 |     -1 |
| Casper Peeze Binkhorst                                         | pyram   |    550 |   1000 |   1000 |    783 |   1000 |
| Filippo Brancaleoni                                            | magic   |     -1 |    102 |    102 |     97 |    102 |
| Ge Song (宋鸽)                                                 | magic   |    105 |    102 |    102 |    102 |     97 |
| Xiao Tan (谭啸)                                                | magic   |     94 |     -1 |     94 |    255 |     94 |
| Yunzhe Jia (贾蕴哲)                                            | mmagic  |    547 |    566 |    566 |    566 |    484 |
| Tan Yi Kai                                                     | magic   |    205 |    205 |    205 |    227 |    184 |
| Renan Mondini Cerpe                                            | 222     |    656 |    656 |    593 |    750 |    656 |
| Yuxuan Wang (王宇轩)                                           | magic   |     80 |     80 |     83 |     81 |     80 |
| Yuxuan Wang (王宇轩)                                           | magic   |     81 |     81 |     81 |     -1 |    131 |
| Robert Larkin                                                  | magic   |    338 |    159 |    147 |    147 |    147 |
| Ernie Pulchny                                                  | mmagic  |    240 |    250 |    278 |    240 |    240 |
| Yang Liu 2 (刘洋)                                              | magic   |    102 |     96 |    102 |    102 |     96 |
| Karim Eltanahy                                                 | magic   |     -1 |    284 |     -1 |    284 |    284 |
| Isaias Andrés Sepúlveda Pérez                                  | mmagic  |    271 |    577 |    369 |    271 |    271 |
| Kim Chow                                                       | magic   |    113 |    113 |    168 |    106 |    113 |
| Jan Dickmann                                                   | magic   |     97 |     90 |     90 |     90 |    113 |
| Filippo Brancaleoni                                            | magic   |    100 |    100 |    100 |    171 |    111 |
| Liwen Fang (方丽雯)                                            | magic   |    205 |    106 |    106 |    302 |    106 |
| Yuxuan Wang (王宇轩)                                           | magic   |     78 |     78 |     78 |     -1 |     93 |
| Nora Christ                                                    | magic   |    165 |    163 |    165 |    165 |    146 |
| Simone Santarsiero                                             | mmagic  |    246 |    246 |    246 |    297 |    484 |
| Baramee Pookcharoen (บารมี พุกเจริญ)                           | magic   |    125 |    127 |    125 |    125 |    125 |
| Patrick Bichler                                                | mmagic  |    677 |    683 |    677 |    588 |    677 |
| Shauly Ramin                                                   | magic   |    136 |    136 |    136 |    130 |    134 |
| Yiming Zhou (周一鸣)                                           | magic   |    113 |    113 |    113 |     -1 |    109 |
| Antoine Simon-Chautemps                                        | magic   |    553 |    169 |    169 |    215 |    169 |
| Xuezhi Xia (夏学智)                                            | magic   |    141 |    157 |    148 |    141 |    141 |
| Daniel Seidler                                                 | magic   |    188 |    333 |    180 |    188 |    188 |
| Bence Barát                                                    | magic   |    118 |     -1 |    118 |    202 |    118 |
| Michael                                                        | 333     |   2506 |   2503 |   2503 |   2505 |   2503 |
| Christian Luis Hinkle                                          | magic   |    146 |    146 |    158 |    146 |    141 |
| Yefeng Hu (胡叶枫)                                             | magic   |    115 |    115 |    275 |    146 |    115 |
| Maxime Colignon                                                | magic   |    233 |    386 |    175 |    175 |    175 |
| Uku Kruusamägi                                                 | magic   |    147 |    258 |    147 |    152 |    147 |
| Yu Nakajima (中島悠)                                           | 333     |   1052 |   1143 |    969 |    969 |    969 |
| François Courtès                                               | 222     |    606 |    606 |    921 |    522 |    606 |
| Ryan Cangelosi                                                 | magic   |    108 |    111 |    105 |    108 |    108 |
| Clément Gallet                                                 | 333     |   1683 |   1643 |   1621 |   1621 |   1621 |
| Vincent Hartanto Utomo                                         | magic   |    158 |    158 |    158 |    172 |   1341 |
| Valentin Doussin                                               | magic   |    166 |    163 |    163 |    163 |    281 |
| Daniel Wu                                                      | 222     |    525 |    350 |    350 |    359 |    350 |
| Victor Li                                                      | magic   |    350 |    165 |    165 |    165 |    161 |
| Ting Sheng Bao Yang                                            | magic   |     94 |    156 |     94 |    125 |     94 |
| Tatsuya Ookubo (大久保達也)                                    | magic   |    153 |    153 |    211 |    153 |    263 |
| Rolando Acuña Mitre                                            | magic   |    134 |    138 |    134 |    138 |    134 |
| Ainesh Sevellaraja                                             | magic   |    131 |    131 |    133 |    131 |    197 |
| Samuel Chiu                                                    | magic   |    106 |    106 |    106 |     -1 |    166 |
| Donglei Li (李冬雷)                                            | magic   |    143 |    146 |    341 |    146 |    146 |
| Ryan Jew                                                       | magic   |    109 |    105 |    109 |    205 |    109 |
| Can Gücüyener                                                  | 222     |    718 |    609 |    496 |    496 |    496 |
| Agnes Maxelino                                                 | magic   |    131 |     -1 |    131 |    131 |    127 |
| Benjamin Skoning                                               | magic   |    138 |    133 |    133 |    138 |    133 |
| Carlos Alberto de Alcântara Jr                                 | 222     |    653 |    513 |    653 |    653 |    593 |
| Guanda Fu (符冠达)                                             | magic   |    109 |    103 |    109 |    202 |    109 |
| Piotr Michał Padlewski                                         | mmagic  |    250 |    240 |    250 |    297 |    250 |
| Kunlin Yu (虞坤霖)                                             | magic   |     96 |     96 |    211 |    102 |     96 |
| Andrey Krasovskiy                                              | magic   |    196 |    196 |    227 |    196 |    193 |
| Ernie Pulchny                                                  | magic   |     97 |     91 |     91 |     91 |     -1 |
| Xinglin Liu (刘星林)                                           | 222     |    622 |    622 |    613 |    622 |    808 |
| Takao Hashimoto (橋本貴夫)                                     | magic   |    177 |    119 |    119 |    119 |    121 |
| Korneliusz Tombarkiewicz                                       | magic   |    105 |     96 |    103 |     96 |     96 |
| Rebaz Alipour                                                  | magic   |    119 |    116 |    119 |    116 |    119 |
| Samuel Chiu                                                    | magic   |    107 |    118 |    106 |    106 |    106 |
| Parsa Saeed Nia (پارسا سعیدنیا)                                | mmagic  |    221 |     -1 |    219 |    219 |    219 |
| Benjamin Skoning                                               | magic   |     -1 |    275 |    141 |    141 |    141 |
| Bartosz Bździel                                                | magic   |    191 |    259 |    219 |    191 |    191 |
| Łukasz Herman                                                  | magic   |    153 |    153 |    144 |    153 |    356 |
| Amir Jahanbakhsh (امیر جهانبخش)                                | magic   |    197 |    249 |    197 |    186 |    197 |
| Chui-Hsien Lin (林垂憲)                                        | magic   |    141 |    494 |    171 |    141 |    141 |
| Jakub Wolniewicz                                               | pyram   |    397 |    484 |    397 |    456 |    397 |
| Kevin Guillaumond                                              | 222     |    366 |    366 |    366 |    269 |    308 |
| Cooper Mestre                                                  | 222     |    618 |    618 |    618 |    396 |    655 |
+----------------------------------------------------------------+---------+--------+--------+--------+--------+--------+

If we don't include these,

Code:

+---------------------------------+-----------------------+---------+--------+--------+--------+--------+--------+
| personName                      | competitionId         | eventId | value1 | value2 | value3 | value4 | value5 |
+---------------------------------+-----------------------+---------+--------+--------+--------+--------+--------+
| Zi-Jie Gong                     | TaiwanSummerOpen2009  | 333     |   2134 |   2486 |   2090 |   2090 |   2090 |
| Casper Peeze Binkhorst          | DutchOpen2009         | pyram   |    550 |   1000 |   1000 |    783 |   1000 |
| Renan Mondini Cerpe             | ColegioCidade2010     | 222     |    656 |    656 |    593 |    750 |    656 |
| Michael                         | IndonesianOpen2011    | 333     |   2506 |   2503 |   2503 |   2505 |   2503 |
| Yu Nakajima (中島悠)            | WC2011                | 333     |   1052 |   1143 |    969 |    969 |    969 |
| François Courtès                | WC2011                | 222     |    606 |    606 |    921 |    522 |    606 |
| Clément Gallet                  | LyonWinterOpen2012    | 333     |   1683 |   1643 |   1621 |   1621 |   1621 |
| Daniel Wu                       | MITSpring2012         | 222     |    525 |    350 |    350 |    359 |    350 |
| Can Gücüyener                   | NEMOAmsterdamOpen2012 | 222     |    718 |    609 |    496 |    496 |    496 |
| Carlos Alberto de Alcântara Jr  | SESCSantos2012        | 222     |    653 |    513 |    653 |    653 |    593 |
| Xinglin Liu (刘星林)            | HangzhouOpen2012      | 222     |    622 |    622 |    613 |    622 |    808 |
| Jakub Wolniewicz                | PolishOpen2013        | pyram   |    397 |    484 |    397 |    456 |    397 |
| Kevin Guillaumond               | France2013            | 222     |    366 |    366 |    366 |    269 |    308 |
| Cooper Mestre                   | SanDiegoSummer2013    | 222     |    618 |    618 |    618 |    396 |    655 |
+---------------------------------+-----------------------+---------+--------+--------+--------+--------+--------+
14 rows in set (0.27 sec)

Stefan · Sep 18, 2013

cubizh said:
Yes, as Mollerz said, I used the whole set instead of removing best and worse.

As we're interested in extreme consistency here, I'd say best and worst should be included.

cubizh said:
...or go with the spreadsheet

I have no idea how you would do it with that. Can you tell?

TMOY said:
What we can deduce from cubizh's posts is that there can't be 4 or more identical times in the same average, but 3 is still possible.

No, we can see from it that there is a 3, as there is one right there (as implied by his "At least one"), indeed answering the question.

PM 1729 · Sep 18, 2013

Searching for any 3 identical (result in previous post) also includes the set of records for which have >3 identical. There is only one record with >=4 identical entries:

Code:

| Baramee Pookcharoen (บารมี พุกเจริญ)                           | magic   |    125 |    127 |    125 |    125 |    125 |

porkynator · Sep 18, 2013

porkynator said:
I would like to see an up-to-date version of the classic "highest PB single/PB average ratio", possibly top100 or so for each event. Is it possible to do it also for FMC and 3BLD?

PranavCubes said:
Thanks! and I even wanted to know who had the least 3x3x3 2H to OH average ( Ratio)?

up up
It's easy stuff for someone who knows SQL

cubizh · Sep 18, 2013

Stefan said:
I have no idea how you would do it with that. Can you tell?

Sure:

[TABLE="class:grid,align:left"]
[TR][TD] Name [/TD][TD] personId [/TD][TD] Country [/TD][TD] Count [/TD][/TR]
[TR][TD] Shelley Chang [/TD][TD] 2004CHAN04 [/TD][TD] USA [/TD][TD] 86 [/TD][/TR]
[TR][TD] Maria Oey [/TD][TD] 2007OEYM01 [/TD][TD] Indonesia [/TD][TD] 76 [/TD][/TR]
[TR][TD] Jaclyn Sawler [/TD][TD] 2006SAWL01 [/TD][TD] USA [/TD][TD] 66 [/TD][/TR]
[TR][TD] Hanneke Rijks [/TD][TD] 2008RIJK01 [/TD][TD] Netherlands [/TD][TD] 55 [/TD][/TR]
[TR][TD] Zoé de Moffarts [/TD][TD] 2010MOFF02 [/TD][TD] Belgium [/TD][TD] 48 [/TD][/TR]
[TR][TD] Mika Muranushi (村主美佳) [/TD][TD] 2006MURA01 [/TD][TD] Japan [/TD][TD] 46 [/TD][/TR]
[TR][TD] Sanae Omyo [/TD][TD] 2008OMYO01 [/TD][TD] Japan [/TD][TD] 44 [/TD][/TR]
[TR][TD] Kirstine Buus Aagaard [/TD][TD] 2006BUUS02 [/TD][TD] Denmark [/TD][TD] 43 [/TD][/TR]
[TR][TD] Laetitia Lemoine [/TD][TD] 2007LEMO01 [/TD][TD] France [/TD][TD] 42 [/TD][/TR]
[TR][TD] Berit Brüster [/TD][TD] 2009BRUS01 [/TD][TD] Germany [/TD][TD] 41 [/TD][/TR]
[TR][TD] Fangyuan Chang (常方圆) [/TD][TD] 2009CHAN04 [/TD][TD] China [/TD][TD] 39 [/TD][/TR]
[TR][TD] Nora Christ [/TD][TD] 2009CHRI03 [/TD][TD] Germany [/TD][TD] 39 [/TD][/TR]
[TR][TD] Laura Ohrndorf [/TD][TD] 2009OHRN01 [/TD][TD] Germany [/TD][TD] 37 [/TD][/TR]
[TR][TD] Rebecca Hughey [/TD][TD] 2007HUGH04 [/TD][TD] USA [/TD][TD] 36 [/TD][/TR]
[TR][TD] Marie Hughey [/TD][TD] 2007HUGH03 [/TD][TD] USA [/TD][TD] 36 [/TD][/TR]
[TR][TD] Sarah Strong [/TD][TD] 2007STRO01 [/TD][TD] Canada [/TD][TD] 34 [/TD][/TR]
[TR][TD] Eileen Xie [/TD][TD] 2005XIEE01 [/TD][TD] USA [/TD][TD] 31 [/TD][/TR]
[TR][TD] Yu Araki (荒木由布) [/TD][TD] 2006ARAK02 [/TD][TD] Japan [/TD][TD] 30 [/TD][/TR]
[TR][TD] Kalina Brzezińska [/TD][TD] 2009BRZE01 [/TD][TD] Poland [/TD][TD] 30 [/TD][/TR]
[TR][TD] Monika Zimmermann [/TD][TD] 2008ZIMM01 [/TD][TD] Germany [/TD][TD] 29 [/TD][/TR]
[TR][TD] Karolina Wiącek [/TD][TD] 2008WIAC01 [/TD][TD] Poland [/TD][TD] 29 [/TD][/TR]
[TR][TD] Chika Namikawa (浪川千華) [/TD][TD] 2009NAMI01 [/TD][TD] Japan [/TD][TD] 29 [/TD][/TR]
[TR][TD] Stephanie Chow [/TD][TD] 2007CHOW01 [/TD][TD] USA [/TD][TD] 25 [/TD][/TR]
[TR][TD] Aili Asikainen [/TD][TD] 2007ASIK01 [/TD][TD] Finland [/TD][TD] 24 [/TD][/TR]
[TR][TD] Charlie Cooper [/TD][TD] 2007COOP01 [/TD][TD] United Kingdom [/TD][TD] 23 [/TD][/TR]
[TR][TD] Connie Chen [/TD][TD] 2007CHEN15 [/TD][TD] USA [/TD][TD] 23 [/TD][/TR]
[TR][TD] Xu Zhao (赵旭) [/TD][TD] 2009ZHAO05 [/TD][TD] China [/TD][TD] 23 [/TD][/TR]
[TR][TD] Ambie Valdés [/TD][TD] 2005VALD01 [/TD][TD] USA [/TD][TD] 22 [/TD][/TR]
[TR][TD] Lacey Burton [/TD][TD] 2005BURT02 [/TD][TD] USA [/TD][TD] 22 [/TD][/TR]
[TR][TD] Klaudia Grabowska [/TD][TD] 2007GRAB01 [/TD][TD] Poland [/TD][TD] 22 [/TD][/TR]
[TR][TD] Kate Sosik [/TD][TD] 2009SOSI01 [/TD][TD] USA [/TD][TD] 22 [/TD][/TR]
[TR][TD] Aina Hashimoto (橋本愛那) [/TD][TD] 2010HASH01 [/TD][TD] Japan [/TD][TD] 22 [/TD][/TR]
[TR][TD] Giana Guelfi [/TD][TD] 2011GUEL01 [/TD][TD] Brazil [/TD][TD] 22 [/TD][/TR]
[TR][TD] Mina Tomita (富田美菜) [/TD][TD] 2006TOMI01 [/TD][TD] Japan [/TD][TD] 21 [/TD][/TR]
[TR][TD] Yui Tomita (富田唯依) [/TD][TD] 2006TOMI04 [/TD][TD] Japan [/TD][TD] 21 [/TD][/TR]
[TR][TD] Jasmine Lee [/TD][TD] 2003LEEJ01 [/TD][TD] Australia [/TD][TD] 19 [/TD][/TR]
[TR][TD] Shufan Wang (王澍凡) [/TD][TD] 2007SHUF01 [/TD][TD] China [/TD][TD] 19 [/TD][/TR]
[TR][TD] Tonia Kwaśniewska [/TD][TD] 2008KWAS01 [/TD][TD] Poland [/TD][TD] 19 [/TD][/TR]
[TR][TD] Patricia Li [/TD][TD] 2009LIPA01 [/TD][TD] USA [/TD][TD] 19 [/TD][/TR]
[TR][TD] Moe Nakano (中野萌絵) [/TD][TD] 2007NAKA02 [/TD][TD] Japan [/TD][TD] 18 [/TD][/TR]
[TR][TD] Magda Gancarz [/TD][TD] 2007GANC01 [/TD][TD] Poland [/TD][TD] 18 [/TD][/TR]
[TR][TD] Emily Wang [/TD][TD] 2009WANG15 [/TD][TD] Canada [/TD][TD] 18 [/TD][/TR]
[TR][TD] Maria Plitina [/TD][TD] 2009PLIT01 [/TD][TD] Russia [/TD][TD] 18 [/TD][/TR]
[TR][TD] Oksana Ruzaeva [/TD][TD] 2010RUZA01 [/TD][TD] Russia [/TD][TD] 18 [/TD][/TR]
[TR][TD] Roxane Balan [/TD][TD] 2010BALA01 [/TD][TD] France [/TD][TD] 18 [/TD][/TR]
[TR][TD] Casey Pernsteiner [/TD][TD] 2005PERN01 [/TD][TD] USA [/TD][TD] 17 [/TD][/TR]
[TR][TD] Nóra Szepes [/TD][TD] 2009SZEP01 [/TD][TD] Hungary [/TD][TD] 17 [/TD][/TR]
[TR][TD] Karina Grandjean Beck [/TD][TD] 2010BECK01 [/TD][TD] Denmark [/TD][TD] 17 [/TD][/TR]
[TR][TD] Andrea Javier [/TD][TD] 2010JAVI01 [/TD][TD] Australia [/TD][TD] 17 [/TD][/TR]
[TR][TD] Courtney Louie [/TD][TD] 2011LOUI01 [/TD][TD] USA [/TD][TD] 17 [/TD][/TR]
[TR][TD] Lina Tissier [/TD][TD] 2009TISS01 [/TD][TD] France [/TD][TD] 16 [/TD][/TR]
[TR][TD] Ayano Maria Yoshida (吉田彩乃) [/TD][TD] 2009YOSH01 [/TD][TD] Japan [/TD][TD] 16 [/TD][/TR]
[TR][TD] Marie Lilleborge [/TD][TD] 2008LILL01 [/TD][TD] Norway [/TD][TD] 15 [/TD][/TR]
[TR][TD] Anja Provoost [/TD][TD] 2008PROV01 [/TD][TD] Netherlands [/TD][TD] 15 [/TD][/TR]
[TR][TD] Shari Kuroyama [/TD][TD] 2008KURO01 [/TD][TD] USA [/TD][TD] 15 [/TD][/TR]
[TR][TD] Jessie Branch [/TD][TD] 2009BRAN01 [/TD][TD] Canada [/TD][TD] 15 [/TD][/TR]
[TR][TD] Camilla Jul Nielsson [/TD][TD] 2010NIEL01 [/TD][TD] Denmark [/TD][TD] 15 [/TD][/TR]
[TR][TD] Aki Kunikoshi (國越晶) [/TD][TD] 2010KUNI01 [/TD][TD] Japan [/TD][TD] 15 [/TD][/TR]
[TR][TD] Giulia Accorsi [/TD][TD] 2011ACCO01 [/TD][TD] Italy [/TD][TD] 15 [/TD][/TR]
[TR][TD] Lauren Hanrahan [/TD][TD] 2005HANR01 [/TD][TD] USA [/TD][TD] 14 [/TD][/TR]
[TR][TD] Madoka Mizumoto (水本円) [/TD][TD] 2009MIZU01 [/TD][TD] Japan [/TD][TD] 14 [/TD][/TR]
[TR][TD] Pauline Bonnaudet [/TD][TD] 2009BONN01 [/TD][TD] France [/TD][TD] 14 [/TD][/TR]
[TR][TD] Jessica Lohe [/TD][TD] 2011LOHE01 [/TD][TD] Germany [/TD][TD] 14 [/TD][/TR]
[TR][TD] Junko Ootsu (大津順子) [/TD][TD] 2005OOTS01 [/TD][TD] Japan [/TD][TD] 13 [/TD][/TR]
[TR][TD] Kaho Idekawa (出川佳歩) [/TD][TD] 2005IDEK01 [/TD][TD] Japan [/TD][TD] 13 [/TD][/TR]
[TR][TD] Eszter Szabó [/TD][TD] 2005SZAB01 [/TD][TD] Hungary [/TD][TD] 13 [/TD][/TR]
[TR][TD] Raiza Mativo [/TD][TD] 2006MATI01 [/TD][TD] Canada [/TD][TD] 13 [/TD][/TR]
[TR][TD] Nikolett Placskó [/TD][TD] 2008PLAC01 [/TD][TD] Hungary [/TD][TD] 13 [/TD][/TR]
[TR][TD] Tabitha King [/TD][TD] 2009KING02 [/TD][TD] USA [/TD][TD] 13 [/TD][/TR]
[TR][TD] Alexandra Daryl Ariawan [/TD][TD] 2010ARIA01 [/TD][TD] Indonesia [/TD][TD] 13 [/TD][/TR]
[TR][TD] Janelle Tin [/TD][TD] 2010TINJ01 [/TD][TD] USA [/TD][TD] 13 [/TD][/TR]
[TR][TD] Amy Tai [/TD][TD] 2010TAIA01 [/TD][TD] USA [/TD][TD] 13 [/TD][/TR]
[TR][TD] Yana Gribacheva [/TD][TD] 2011GRIB01 [/TD][TD] Russia [/TD][TD] 13 [/TD][/TR]
[TR][TD] Sakura Yoshioka (吉岡さくら) [/TD][TD] 2011YOSH03 [/TD][TD] Japan [/TD][TD] 13 [/TD][/TR]
[TR][TD] Rei Idekawa (出川怜) [/TD][TD] 2006IDEK01 [/TD][TD] Japan [/TD][TD] 12 [/TD][/TR]
[TR][TD] Anna Prabucka [/TD][TD] 2010PRAB01 [/TD][TD] Poland [/TD][TD] 12 [/TD][/TR]
[TR][TD] Jael Riggenbach [/TD][TD] 2011RIGG02 [/TD][TD] Peru [/TD][TD] 12 [/TD][/TR]
[TR][TD] Yuliia Opanasenko (Юлія Опанасенко) [/TD][TD] 2011OPAN01 [/TD][TD] Ukraine [/TD][TD] 12 [/TD][/TR]
[TR][TD] Annica Molin [/TD][TD] 2007MOLI01 [/TD][TD] Sweden [/TD][TD] 11 [/TD][/TR]
[TR][TD] Yukiko Makino (牧野由希子) [/TD][TD] 2007MAKI01 [/TD][TD] Japan [/TD][TD] 11 [/TD][/TR]
[TR][TD] Emma Moseley [/TD][TD] 2007MOSE03 [/TD][TD] Canada [/TD][TD] 11 [/TD][/TR]
[TR][TD] Sunniva Fonn [/TD][TD] 2008FONN01 [/TD][TD] Norway [/TD][TD] 11 [/TD][/TR]
[TR][TD] Ximiao Liu (刘曦淼) [/TD][TD] 2008LIUX01 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Mai Ito (伊藤舞) [/TD][TD] 2008ITOM01 [/TD][TD] Japan [/TD][TD] 11 [/TD][/TR]
[TR][TD] Luojin Xu [/TD][TD] 2009XULU01 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Rebecca Ladds [/TD][TD] 2009LADD01 [/TD][TD] Canada [/TD][TD] 11 [/TD][/TR]
[TR][TD] Gabriela Uzcategui Valencia [/TD][TD] 2009VALE02 [/TD][TD] Chile [/TD][TD] 11 [/TD][/TR]
[TR][TD] Yanli Xie (谢燕丽) [/TD][TD] 2009XIEY02 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Xinnan Ye (叶新楠) [/TD][TD] 2009YEXI01 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Aiying Guo (郭蔼盈) [/TD][TD] 2010GUOA01 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Wenting Ni (倪雯婷) [/TD][TD] 2011NIWE01 [/TD][TD] China [/TD][TD] 11 [/TD][/TR]
[TR][TD] Marlène Desmaisons [/TD][TD] 2007DESM01 [/TD][TD] France [/TD][TD] 10 [/TD][/TR]
[TR][TD] Julia Żygowska [/TD][TD] 2008ZYGO01 [/TD][TD] Poland [/TD][TD] 10 [/TD][/TR]
[TR][TD] Men-Shing Lin (林孟欣) [/TD][TD] 2008LINM01 [/TD][TD] Taiwan [/TD][TD] 10 [/TD][/TR]
[TR][TD] Sarah d'Angelo [/TD][TD] 2008DANG02 [/TD][TD] USA [/TD][TD] 10 [/TD][/TR]
[TR][TD] Sesi Cadmus [/TD][TD] 2009CADM01 [/TD][TD] USA [/TD][TD] 10 [/TD][/TR]
[TR][TD] Jie Hu (胡洁) [/TD][TD] 2009HUJI01 [/TD][TD] China [/TD][TD] 10 [/TD][/TR]
[TR][TD] Laura Petitjean [/TD][TD] 2009PETI02 [/TD][TD] France [/TD][TD] 10 [/TD][/TR]
[TR][TD] Juliana Moreno Oliveira [/TD][TD] 2009OLIV03 [/TD][TD] Brazil [/TD][TD] 10 [/TD][/TR]
[TR][TD] Sachi Schuricht [/TD][TD] 2009SCHU03 [/TD][TD] USA [/TD][TD] 10 [/TD][/TR]
[TR][TD] Anna-Sophie König [/TD][TD] 2009KONI02 [/TD][TD] Germany [/TD][TD] 10 [/TD][/TR]
[TR][TD] Azlysha Azmi [/TD][TD] 2009AZMI01 [/TD][TD] Malaysia [/TD][TD] 10 [/TD][/TR]
[TR][TD] Michelle Nataniel Yugie [/TD][TD] 2010YUGI02 [/TD][TD] Indonesia [/TD][TD] 10 [/TD][/TR]
[TR][TD] Gamze Aksahin [/TD][TD] 2010AKSA01 [/TD][TD] Turkey [/TD][TD] 10 [/TD][/TR]
[TR][TD] Adelina Estevao [/TD][TD] 2010ESTE02 [/TD][TD] Australia [/TD][TD] 10 [/TD][/TR]
[TR][TD] Rachel Riggenbach [/TD][TD] 2011RIGG04 [/TD][TD] Peru [/TD][TD] 10 [/TD][/TR]
[TR][TD] Oksana Tyvodar [/TD][TD] 2012TYVO01 [/TD][TD] Ukraine [/TD][TD] 10 [/TD][/TR]
[/TABLE]

[youtubehd]EHaLOg_sMng[/youtubehd]

Stefan · Sep 18, 2013

I loled when the video included you replying here

Was that real-time or sped up? In any case, it was a bit too fast for me to follow everything, but I got a good idea of what you're doing, thanks. I'll stick to SQL, though, looks like less work. Question: If you want to do that statistic again later, do you have to repeat all the work, or did you somehow store it and can just "re-apply" it to the updated data like I can just re-apply the SQL query?

And I gotta start using those table tags... they do look neat.

cubizh · Sep 18, 2013

Stefan said:
I loled when the video included you replying here

Was that real-time or sped up? In any case, it was a bit too fast for me to follow everything, but I got a good idea of what you're doing, thanks. I'll stick to SQL, though, looks like less work. Question: If you want to do that statistic again later, do you have to repeat all the work, or did you somehow store it and can just "re-apply" it to the updated data like I can just re-apply the SQL query?

And I gotta start using those table tags... they do look neat.

I included the reply in the video to show how easy it is to make the table and just dump it here

Have to give credit to Daniel Sheppard for showing me how to make them like this. Thank you!
Some parts of the video were sped up because recording the video made my system too slow to be anywhere accurate to the normal speed.
Most of the things, I do with keyboard shortcuts so it goes pretty fast, specially selections and copy/pasting.
SQL is nice for this statistics purpose too, but it wouldn't be so simple to integrate these fancy tables so easily. I just try my best to avoid it for entertainment purposes.

Sometimes when the steps are very difficult and involve a lot of them I save the way it's done and the formulas to it (like the last real average of 5 stdev) so I don't have to rethink everything, but if it's simple enough usually I don't.

PM 1729 · Sep 18, 2013

Overall PB single/PB average

Code:

+------------+-------------------------------------------------------------+---------+------------+----------+-------------+
| ‘rank’     | personName                                                  | eventId | single/100 | mean/100 | single/mean |
+------------+-------------------------------------------------------------+---------+------------+----------+-------------+
|          1 | Samuel Chiu                                                 | magic   |     1.0600 |   1.0600 |      1.0000 |
|          2 | Antonio Aguilera Manzano                                    | 666     |   247.6300 | 247.8900 |      0.9990 |
|          3 | Vinny Vecchio                                               | 666     |   204.4700 | 204.8300 |      0.9982 |
|          4 | Dexter Estolonio                                            | 666     |   219.2700 | 219.7400 |      0.9979 |
|          5 | Rui Liu (刘睿)                                              | 777     |   461.8400 | 462.9200 |      0.9977 |
|          6 | James Sangil                                                | 666     |   303.1900 | 303.9600 |      0.9975 |
|          7 | Shao-Heng Hung (洪紹恆)                                     | 777     |   357.8000 | 358.7200 |      0.9974 |
|          8 | Vinny Vecchio                                               | 777     |   312.5000 | 313.3500 |      0.9973 |
|          9 | Tonny Pramana                                               | 777     |   412.3800 | 413.6700 |      0.9969 |
|         10 | Thompson Clarke                                             | 777     |   383.3600 | 384.5900 |      0.9968 |
|         11 | John Paul Custodio                                          | 333ft   |   183.5500 | 184.1400 |      0.9968 |
|         12 | Kim Jokinen                                                 | 666     |   235.5900 | 236.5100 |      0.9961 |
|         13 | James Dean Ludlow                                           | mmagic  |     2.5800 |   2.5900 |      0.9961 |
|         14 | Patrick Garcin                                              | 666     |   752.0000 | 755.0000 |      0.9960 |
|         15 | Gábor Róka                                                  | minx    |   131.2100 | 131.7600 |      0.9958 |
|         16 | Carson Penticuff                                            | 555     |   309.9400 | 311.2800 |      0.9957 |
|         17 | Filippo Brancaleoni                                         | 666     |   228.6100 | 229.6200 |      0.9956 |
|         18 | Parsa Saeed Nia (پارسا سعیدنیا)                             | mmagic  |     2.1900 |   2.2000 |      0.9955 |
|         19 | Jie Yu (余杰)                                               | 333oh   |    24.6000 |  24.7300 |      0.9947 |
|         20 | Daniel Adrian López de Andrade                              | 666     |   339.9900 | 341.9300 |      0.9943 |
|         21 | Matthew Millard                                             | 666     |   309.0600 | 310.8500 |      0.9942 |
|         22 | Muhammad Bintang Assyidik                                   | 444     |    80.1900 |  80.6600 |      0.9942 |
|         23 | Bálint Bodor                                                | 777     |   293.6300 | 295.3600 |      0.9941 |
|         24 | Chen Kee Yen                                                | 777     |   326.1600 | 328.1000 |      0.9941 |
|         25 | Joel Spang                                                  | 666     |   442.7700 | 445.3900 |      0.9941 |
|         26 | Valentin Doussin                                            | magic   |     1.6300 |   1.6400 |      0.9939 |
|         27 | Ian Bourn                                                   | minx    |   105.0800 | 105.7400 |      0.9938 |
|         28 | Alexey Polyashov                                            | magic   |     1.5900 |   1.6000 |      0.9938 |
|         29 | Janis Hermanis                                              | 777     |   954.0000 | 960.0000 |      0.9938 |
|         30 | John Mauro Suárez Cerda                                     | magic   |     1.5500 |   1.5600 |      0.9936 |
|         31 | Gastón Verón                                                | 333     |    41.8600 |  42.1300 |      0.9936 |
|         32 | Robbie Stevenson                                            | 777     |   354.6700 | 356.9700 |      0.9936 |
|         33 | Benjamin English                                            | 333     |    44.2500 |  44.5500 |      0.9933 |
|         34 | Wilhelm Kilders                                             | 777     |   338.3800 | 340.8300 |      0.9928 |
|         35 | Chengcheng Qiao (乔成成)                                    | 777     |   569.2700 | 573.3900 |      0.9928 |
|         36 | Marek Wójtowicz                                             | 666     |   220.5200 | 222.1400 |      0.9927 |
|         37 | Flavian Glonț                                               | 666     |   196.5600 | 198.0000 |      0.9927 |
|         38 | Bo Wang (王波)                                              | 777     |   382.7200 | 385.5400 |      0.9927 |
|         39 | Guillaume Erbibou                                           | 666     |   331.0900 | 333.5600 |      0.9926 |
|         40 | Andreas Pohl                                                | 666     |   254.1100 | 256.0600 |      0.9924 |
|         41 | Arvin Tang                                                  | 555     |   116.5800 | 117.4700 |      0.9924 |
|         42 | Wilson José Duarte Espitia                                  | 666     |   355.7400 | 358.4700 |      0.9924 |
|         43 | Greg Shishman                                               | 444     |   148.6600 | 149.8100 |      0.9923 |
|         44 | Matt Rudnicki                                               | clock   |    11.4100 |  11.5000 |      0.9922 |
|         45 | Jemco Casquejo                                              | 777     |   372.9300 | 376.0000 |      0.9918 |
|         46 | DuWayne Sanders                                             | 333oh   |   204.0900 | 205.8500 |      0.9915 |
|         47 | Colin Whelan                                                | 555     |   120.9300 | 121.9900 |      0.9913 |
|         48 | Linus Engberg                                               | minx    |   119.3600 | 120.4100 |      0.9913 |
|         49 | Marcin Zalewski                                             | 777     |   326.1800 | 329.0500 |      0.9913 |
|         50 | Guomin Zhang (张国敏)                                       | minx    |   266.8300 | 269.1900 |      0.9912 |
|         51 | Michael Röhrer                                              | 777     |   214.7200 | 216.6400 |      0.9911 |
|         52 | Zihang Lin (林子杭)                                         | 333     |    13.2800 |  13.4000 |      0.9910 |
|         53 | Oleksandr Poltavets (Олександр Полтавець)                   | 333oh   |    69.3600 |  69.9900 |      0.9910 |
|         54 | Massimiliano Iovane                                         | 777     |   361.8300 | 365.2400 |      0.9907 |
|         55 | Choi Go-Ho (최고호)                                         | 777     |   336.6100 | 339.7800 |      0.9907 |
|         56 | Fang Qin (秦方)                                             | 777     |   380.5500 | 384.1700 |      0.9906 |
|         57 | Michael McCarty                                             | 666     |   245.5000 | 247.8600 |      0.9905 |
|         58 | Lee Poon Kit (李本杰)                                       | 777     |   233.0200 | 235.2700 |      0.9904 |
|         59 | Ivan Jeličić                                                | 777     |   383.6900 | 387.4100 |      0.9904 |
|         60 | Frank Morris                                                | 666     |   220.1100 | 222.2400 |      0.9904 |
|         61 | Keaton Ellis                                                | 777     |   289.8300 | 292.6500 |      0.9904 |
|         62 | Shenchuan Mao (毛神川)                                      | 777     |   223.4700 | 225.6600 |      0.9903 |
|         63 | Matthew Rush                                                | 333     |    26.4600 |  26.7200 |      0.9903 |
|         64 | David Woner                                                 | 666     |   197.6300 | 199.6200 |      0.9900 |
|         65 | Cameron Almasi                                              | 666     |   238.4400 | 240.8900 |      0.9898 |
|         66 | Tomoaki Okayama (岡山友昭)                                  | 666     |   264.2500 | 266.9600 |      0.9898 |
|         67 | Eric Fernandes Monteiro                                     | 777     |   253.8600 | 256.5200 |      0.9896 |
|         68 | Kenta Ohno (大野健太)                                       | 666     |   259.2500 | 262.0400 |      0.9894 |
|         69 | Cyril Barigand                                              | 777     |   311.6100 | 314.9500 |      0.9894 |
|         70 | Vladislav Shavelskiy                                        | 777     |   247.1600 | 249.8400 |      0.9893 |
|         71 | Zhaoli Zheng (郑召利)                                       | 777     |   507.4600 | 513.0100 |      0.9892 |
|         72 | Hampus Hansson                                              | 777     |   639.0000 | 646.0000 |      0.9892 |
|         73 | Jonah Crosby                                                | 777     |   329.4600 | 333.0800 |      0.9891 |
|         74 | Jakub Wojtaszewski                                          | 666     |   229.7800 | 232.3200 |      0.9891 |
|         75 | Takayuki Ida (井田貴之)                                     | 777     |   525.7200 | 531.6200 |      0.9889 |
|         76 | Maciej Durański                                             | minx    |   163.2200 | 165.0600 |      0.9889 |
|         77 | André Victor Mescollotto                                    | minx    |   194.1500 | 196.3400 |      0.9888 |
|         78 | Reynaldo Mape Jr.                                           | minx    |   100.8600 | 102.0000 |      0.9888 |
|         79 | Rodrigo Septién Rodríguez                                   | minx    |   159.6600 | 161.4700 |      0.9888 |
|         80 | Morten Arborg                                               | 666     |   184.3600 | 186.4700 |      0.9887 |
|         81 | Yuan Liu (刘源)                                             | 333     |    50.9100 |  51.5000 |      0.9885 |
|         82 | Wei Zhang (张炜)                                            | 777     |   477.5000 | 483.0500 |      0.9885 |
|         83 | Gaël Dusser                                                 | 666     |   329.7100 | 333.5500 |      0.9885 |
|         84 | Joshua Molina                                               | 333     |    23.0300 |  23.3000 |      0.9884 |
|         85 | Zoé de Moffarts                                             | 777     |   437.6300 | 442.7500 |      0.9884 |
|         86 | Alberto Muñoz Prieto                                        | 333     |    33.8100 |  34.2100 |      0.9883 |
|         87 | YiLin Li (李宜霖)                                           | 333     |    40.5500 |  41.0300 |      0.9883 |
|         88 | Vishal Madipadga                                            | 777     |   318.9400 | 322.7500 |      0.9882 |
|         89 | Tran Minh Tuyen                                             | minx    |   107.1900 | 108.4800 |      0.9881 |
|         90 | Colin Whelan                                                | 777     |   343.9100 | 348.0900 |      0.9880 |
|         91 | Zhaoyun Zhang (张肇筠)                                      | magic   |     1.6300 |   1.6500 |      0.9879 |
|         92 | Yin Jia Qiu                                                 | 555     |   518.3000 | 524.6500 |      0.9879 |
|         93 | Manuel Nobis                                                | 666     |   215.5000 | 218.1600 |      0.9878 |
|         94 | Erik Akkersdijk                                             | 666     |   145.6300 | 147.4500 |      0.9877 |
|         95 | Chien-Yi Lin (林建億)                                       | 777     |   441.5000 | 446.9900 |      0.9877 |
|         96 | Colin Blackadar                                             | 333     |    44.4400 |  45.0000 |      0.9876 |
|         97 | Álvaro García Navarro                                       | minx    |   188.8000 | 191.1900 |      0.9875 |
|         98 | Fathur Rahman                                               | pyram   |    12.6900 |  12.8500 |      0.9875 |
|         99 | Tobias Douqué                                               | 333     |    25.7700 |  26.1000 |      0.9874 |
|        100 | Walker Welch                                                | 666     |   184.1600 | 186.5100 |      0.9874 |
+------------+-------------------------------------------------------------+---------+------------+----------+-------------+
100 rows in set (1.38 sec)

For 3x3:

Code:

+------------+-----------------------------------------------------+------------+----------+-------------+
| ‘rank’     | personName                                          | single/100 | mean/100 | single/mean |
+------------+-----------------------------------------------------+------------+----------+-------------+
|          1 | Gastón Verón                                        |    41.8600 |  42.1300 |      0.9936 |
|          2 | Benjamin English                                    |    44.2500 |  44.5500 |      0.9933 |
|          3 | Zihang Lin (林子杭)                                 |    13.2800 |  13.4000 |      0.9910 |
|          4 | Matthew Rush                                        |    26.4600 |  26.7200 |      0.9903 |
|          5 | Yuan Liu (刘源)                                     |    50.9100 |  51.5000 |      0.9885 |
|          6 | Joshua Molina                                       |    23.0300 |  23.3000 |      0.9884 |
|          7 | YiLin Li (李宜霖)                                   |    40.5500 |  41.0300 |      0.9883 |
|          8 | Alberto Muñoz Prieto                                |    33.8100 |  34.2100 |      0.9883 |
|          9 | Colin Blackadar                                     |    44.4400 |  45.0000 |      0.9876 |
|         10 | Tobias Douqué                                       |    25.7700 |  26.1000 |      0.9874 |
|         11 | Lam Tsz Hei                                         |    20.0700 |  20.3500 |      0.9862 |
|         12 | Caspian Gustavsson                                  |    19.0900 |  19.3600 |      0.9861 |
|         13 | Klara Fogoros                                       |    79.1500 |  80.3300 |      0.9853 |
|         14 | Tuan Phong Tran                                     |    16.0300 |  16.2700 |      0.9852 |
|         15 | Atsushi Syouji (東海林淳)                           |    35.7700 |  36.3200 |      0.9849 |
|         16 | Yueh Lu (呂約)                                      |    44.0700 |  44.7700 |      0.9844 |
|         17 | Wei Sun (孙伟)                                      |    28.4000 |  28.8600 |      0.9841 |
|         18 | Jenifer Nativel                                     |    53.2200 |  54.1100 |      0.9836 |
|         19 | Mikael Silvola                                      |    20.8700 |  21.2300 |      0.9830 |
|         20 | Nathan Grammel                                      |    35.1900 |  35.8100 |      0.9827 |
|         21 | Dawid Luniewski                                     |    41.5500 |  42.2900 |      0.9825 |
|         22 | Yan Chen (陈岩)                                     |    20.1100 |  20.4700 |      0.9824 |
|         23 | Cian Mattern                                        |    56.4600 |  57.4800 |      0.9823 |
|         24 | Yang Jiang (姜扬)                                   |    39.5200 |  40.2500 |      0.9819 |
|         25 | Ming-Kai Kang                                       |    47.0800 |  47.9500 |      0.9819 |
|         26 | Jiashi Shen                                         |    57.5300 |  58.5900 |      0.9819 |
|         27 | Natthasit Kiatthaweeanand                           |    22.4300 |  22.8500 |      0.9816 |
|         28 | Tina Yao                                            |    21.8600 |  22.2700 |      0.9816 |
|         29 | Zephaniah Ko                                        |    29.4700 |  30.0400 |      0.9810 |
|         30 | Zhichu Chen (陈之初)                                |    64.8300 |  66.1300 |      0.9803 |
|         31 | Tianxiang Ma (马天翔)                               |    32.3400 |  32.9900 |      0.9803 |
|         32 | Phan Lê Thanh Hoàng                                 |    20.4500 |  20.8700 |      0.9799 |
|         33 | Hengsheng Dai (戴恒盛)                              |    18.0600 |  18.4300 |      0.9799 |
|         34 | Sebastian Harasim                                   |    37.1900 |  37.9600 |      0.9797 |
|         35 | Toshinobu Hirayama (平山寿信)                       |    24.9300 |  25.4500 |      0.9796 |
|         36 | Gregorio Requena Torres                             |    46.6800 |  47.6600 |      0.9794 |
|         37 | Dexin Lu (卢德馨)                                   |    25.5500 |  26.0900 |      0.9793 |
|         38 | Jesua Jovan                                         |    46.4600 |  47.4600 |      0.9789 |
|         39 | Xinhao Gu (顾鑫浩)                                  |    21.7800 |  22.2500 |      0.9789 |
|         40 | Weiye Guo (郭维烨)                                  |    19.3600 |  19.7800 |      0.9788 |
|         41 | Asger Christiansen                                  |    28.6600 |  29.2800 |      0.9788 |
|         42 | Ádám Brett                                          |    37.8800 |  38.7100 |      0.9786 |
|         43 | Gretchen Chomas                                     |    62.0500 |  63.4100 |      0.9786 |
|         44 | Emmanuel de Jesús Marín Liera                       |    21.2800 |  21.7600 |      0.9779 |
|         45 | Nikola Liubinkovic                                  |    42.9500 |  43.9400 |      0.9775 |
|         46 | Aris Dwi Cahyono                                    |    69.0900 |  70.6900 |      0.9774 |
|         47 | Diya Li                                             |    65.8000 |  67.3300 |      0.9773 |
|         48 | James Shi                                           |    26.5300 |  27.1500 |      0.9772 |
|         49 | Jared Cruz                                          |    31.3800 |  32.1200 |      0.9770 |
|         50 | Renjie Zhang (张人杰)                               |    16.9000 |  17.3000 |      0.9769 |
|         51 | Kevin Barr                                          |    31.9000 |  32.6600 |      0.9767 |
|         52 | Zhixing Wang (王之星)                               |    38.9000 |  39.8300 |      0.9767 |
|         53 | Lee Ka Hou                                          |    24.5000 |  25.0900 |      0.9765 |
|         54 | Andres Francisco Garzon Sepulveda                   |    27.0500 |  27.7000 |      0.9765 |
|         55 | Jacob Posner                                        |    37.3000 |  38.2100 |      0.9762 |
|         56 | Iqbal Yusuf Fadillah                                |    37.5300 |  38.4500 |      0.9761 |
|         57 | Oliver Hammond                                      |    24.1100 |  24.7000 |      0.9761 |
|         58 | Fabian Wrzosek                                      |    32.0600 |  32.8500 |      0.9760 |
|         59 | Tahere Askari Zade (طاهره عسکری زاده)               |    30.5200 |  31.2700 |      0.9760 |
|         60 | Daniel Choy                                         |    71.7300 |  73.5000 |      0.9759 |
|         61 | Sijia He (贺思嘉)                                   |    12.9300 |  13.2500 |      0.9758 |
|         62 | Quentin Paniz                                       |    83.1900 |  85.2500 |      0.9758 |
|         63 | Michael Chen                                        |    34.1600 |  35.0100 |      0.9757 |
|         64 | Aaron Kelner                                        |    82.6100 |  84.6900 |      0.9754 |
|         65 | Taro Inagaki (稲垣太郎)                             |    15.2500 |  15.6400 |      0.9751 |
|         66 | Alexey Emelyanov                                    |    18.8300 |  19.3100 |      0.9751 |
|         67 | Charles Chang                                       |    48.9900 |  50.2400 |      0.9751 |
|         68 | Fabian Krank                                        |    31.0800 |  31.8900 |      0.9746 |
|         69 | Phillip Kampmann                                    |    39.1300 |  40.1500 |      0.9746 |
|         70 | Keisuke Yamamoto (山本圭介)                         |    51.2600 |  52.6100 |      0.9743 |
|         71 | Michał Potocki                                      |    41.3000 |  42.3900 |      0.9743 |
|         72 | Miguel Ángel Chacón Martínez                        |    24.4700 |  25.1200 |      0.9741 |
|         73 | Hang Zhang (张航)                                   |    23.3100 |  23.9300 |      0.9741 |
|         74 | Quan Xia (夏全)                                     |    28.0800 |  28.8300 |      0.9740 |
|         75 | Robert Schenk                                       |    27.7100 |  28.4500 |      0.9740 |
|         76 | Jingwei Xiao (肖敬伟)                               |    26.6100 |  27.3200 |      0.9740 |
|         77 | Vittavat Ninvibool                                  |    24.8400 |  25.5100 |      0.9737 |
|         78 | Matthew Kopelowitz                                  |    58.9000 |  60.4900 |      0.9737 |
|         79 | Henry Riverstone                                    |    40.1300 |  41.2200 |      0.9736 |
|         80 | Philip Chang                                        |    11.8100 |  12.1300 |      0.9736 |
|         81 | Zbigniew Dziuba                                     |    43.8600 |  45.0500 |      0.9736 |
|         82 | John Ismael Ugelstad                                |   103.6300 | 106.4500 |      0.9735 |
|         83 | Guowei Liang (梁国威)                               |    33.8000 |  34.7200 |      0.9735 |
|         84 | Evgeny Blinov                                       |    18.9400 |  19.4600 |      0.9733 |
|         85 | Hung Ka Shing (孔嘉城)                              |    26.8600 |  27.6000 |      0.9732 |
|         86 | Shashwat Chandra                                    |    91.6600 |  94.1900 |      0.9731 |
|         87 | Pulkit Aggarwal                                     |    39.0700 |  40.1500 |      0.9731 |
|         88 | Zexian Liu (刘泽贤)                                 |    37.3800 |  38.4200 |      0.9729 |
|         89 | Johnson Vun                                         |    19.8600 |  20.4200 |      0.9726 |
|         90 | Mirek Goljan                                        |    21.9000 |  22.5200 |      0.9725 |
|         91 | Brendan Belo                                        |    70.5500 |  72.5500 |      0.9724 |
|         92 | Andrés Alonso Gutiérrez Salinas                     |    48.9300 |  50.3300 |      0.9722 |
|         93 | Rubenesh Kumar                                      |    72.5200 |  74.6000 |      0.9721 |
|         94 | Jordan Harrison                                     |    27.4000 |  28.1900 |      0.9720 |
|         95 | Jason Bauer                                         |    20.1200 |  20.7000 |      0.9720 |
|         96 | Scott Garrabrant                                    |    41.7300 |  42.9300 |      0.9720 |
|         97 | Wanfeng Yuan (袁万峰)                               |    42.2100 |  43.4300 |      0.9719 |
|         98 | Doo Hyun Kwon (권두현)                              |    31.7500 |  32.6700 |      0.9718 |
|         99 | Viktor Söderberg                                    |    28.1800 |  29.0000 |      0.9717 |
|        100 | Jo Jeong-Ho                                         |    43.9400 |  45.2300 |      0.9715 |
+------------+-----------------------------------------------------+------------+----------+-------------+
100 rows in set (1.37 sec)

This is overall PB single/overall PB average, (not necessarily in the same round).

3x3 average/3x3 oh average

Code:

+--------------------------------------------------------------------------------------+-------------+----------------+--------+
| name                                                                                 | 3x3 average | 3x3 oh average | ratio  |
+--------------------------------------------------------------------------------------+-------------+----------------+--------+
| Chenxi Shan (单晨曦)                                                                 |     31.1700 |        30.8800 | 1.0094 |
| Tomohiro Tanno (丹野智博)                                                            |     13.2200 |        14.4700 | 0.9136 |
| Rongwei Chen (陈榕伟)                                                                |     24.6300 |        27.0300 | 0.9112 |
| Yevhen Riabokon (Євген Рябоконь)                                                     |     49.4800 |        55.4000 | 0.8931 |
| Peiyan Li (利沛焰)                                                                   |     16.4300 |        18.4400 | 0.8910 |
| Ming Chen 2 (陈明)                                                                   |     17.6000 |        19.7600 | 0.8907 |
| Leyner Jamauca                                                                       |     23.3100 |        26.3900 | 0.8833 |
| Sittinon Sukhaya (สิทธินนท์ สุขายะ)                                                  |     13.3600 |        15.2600 | 0.8755 |
| Xuan Gong (龚轩)                                                                     |     17.3200 |        19.8900 | 0.8708 |
| Wen-chung Tien (田文中)                                                              |     14.5000 |        16.7600 | 0.8652 |
| Chun Lin (林春)                                                                      |     18.7900 |        22.0000 | 0.8541 |
| Zegeng Zheng (郑泽耿)                                                                |     23.2800 |        27.3000 | 0.8527 |
| Ramble Tandar                                                                        |     12.5000 |        14.7700 | 0.8463 |
| Chan Yui Yin                                                                         |     25.7300 |        30.4600 | 0.8447 |
| Brian Pamandanan                                                                     |     29.5400 |        35.0600 | 0.8426 |
| Phil Yu                                                                              |     11.2700 |        13.4600 | 0.8373 |
| Tomasz Seweryn                                                                       |     17.2200 |        20.7900 | 0.8283 |
| Krzysztof Żerucha                                                                    |     12.5300 |        15.1700 | 0.8260 |
| Nicola Boccabella                                                                    |     26.5400 |        32.4300 | 0.8184 |
| Siyang Li                                                                            |     39.6300 |        48.7500 | 0.8129 |
| Timo Schönfelder                                                                     |     21.3600 |        26.2800 | 0.8128 |
| Thanaphat Sophaladawon                                                               |     17.7500 |        21.8700 | 0.8116 |
| Đoàn Thanh Duy                                                                       |     16.5700 |        20.5200 | 0.8075 |
| Brian Loftus                                                                         |     15.6000 |        19.3300 | 0.8070 |
| Karol Celmer                                                                         |     21.1000 |        26.3200 | 0.8017 |
| Austin Thielemier                                                                    |     15.3400 |        19.1400 | 0.8015 |
| Aakash Josh                                                                          |     17.4200 |        21.7400 | 0.8013 |
| Jinlong Li (李金龙)                                                                  |     21.1500 |        26.4500 | 0.7996 |
| Tao Yu (余涛)                                                                        |     17.2300 |        21.5600 | 0.7992 |
| Zeming Mei (梅泽铭)                                                                  |     27.2500 |        34.4000 | 0.7922 |
| Simon Kalhofer                                                                       |     13.0200 |        16.5900 | 0.7848 |
| Ze Li (李泽)                                                                         |     14.6300 |        18.6500 | 0.7845 |
| Maciek Jagiełło                                                                      |     16.2000 |        20.6600 | 0.7841 |
| Guoyang Zhou (周国阳)                                                                |     21.0600 |        27.0700 | 0.7780 |
| Yaozong Liang (梁耀宗)                                                               |     21.1600 |        27.2200 | 0.7774 |
| Peter Hung                                                                           |     15.0900 |        19.4100 | 0.7774 |
| Zhili Zhang (张志立)                                                                 |     24.6300 |        31.8500 | 0.7733 |
| Shih-Ru Chen (陳世儒)                                                                |     14.7900 |        19.1700 | 0.7715 |
| Pu Su (苏普)                                                                         |     23.1200 |        30.0600 | 0.7691 |
| Simon Blanchard                                                                      |     18.4400 |        23.9900 | 0.7687 |
| Márk Dániel                                                                          |     23.8300 |        31.0100 | 0.7685 |
| Hersh Shrivastava                                                                    |     11.7800 |        15.3400 | 0.7679 |
| Paweł Demjankowski                                                                   |     21.5600 |        28.1400 | 0.7662 |
| Andrii Chernichko (Андрій Черничко)                                                  |     12.8100 |        16.7200 | 0.7661 |
| Jordan Pappas                                                                        |     23.8200 |        31.1100 | 0.7657 |
| Michael Angelo Zafra                                                                 |     16.9800 |        22.1900 | 0.7652 |
| Jiexing Zhang (张杰星)                                                               |     21.7700 |        28.5700 | 0.7620 |
| Blake Bowers                                                                         |     17.0100 |        22.3400 | 0.7614 |
| Leung Yu Ching (梁宇正)                                                              |     21.9400 |        28.8300 | 0.7610 |
| Yang Qi (祁洋)                                                                       |     18.8100 |        24.7500 | 0.7600 |
| Jiahao Bei (贝佳豪)                                                                  |     19.6900 |        25.9100 | 0.7599 |
| Tinnapop Suparjak (ติณณภพ สุภาจักร์)                                                 |     19.7800 |        26.0900 | 0.7581 |
| Tim McMahon                                                                          |     19.4600 |        25.6900 | 0.7575 |
| Yen-Ting Li (李彥霆)                                                                 |     14.6900 |        19.4300 | 0.7560 |
| Antoine Cantin                                                                       |     10.0000 |        13.2300 | 0.7559 |
| Robert Armstrong                                                                     |     42.8300 |        56.7400 | 0.7548 |
| Yiming Liu 2 (刘一鸣)                                                                |     33.2100 |        44.0100 | 0.7546 |
| Frieder Klein                                                                        |     16.5400 |        21.9300 | 0.7542 |
| Yu-Chen Wang (王于宸)                                                                |     13.4300 |        17.8100 | 0.7541 |
| Aadithya Murthy                                                                      |     37.8900 |        50.4500 | 0.7510 |
| Lijie Jin (金利杰)                                                                   |     14.7600 |        19.6600 | 0.7508 |
| Alexander Eryomin                                                                    |     11.5800 |        15.4500 | 0.7495 |
| Lam Chin                                                                             |     22.6200 |        30.2000 | 0.7490 |
| Zhiwei Lin (林智玮)                                                                  |     13.2600 |        17.7100 | 0.7487 |
| Anukun Supcharoenkun (อนุกูล ทรัพย์เจริญกุล)                                         |     13.7000 |        18.3000 | 0.7486 |
| Toby O'Connor                                                                        |     24.3400 |        32.5200 | 0.7485 |
| Matt DiPalma                                                                         |     16.2000 |        21.6600 | 0.7479 |
| Alexey Emelyanov                                                                     |     19.3100 |        25.8500 | 0.7470 |
| Kevin Voor                                                                           |     23.8000 |        31.8700 | 0.7468 |
| Ryosuke Mondo (門戸良介)                                                             |     19.3100 |        25.8800 | 0.7461 |
| Shakil Ahmad                                                                         |     17.2900 |        23.2100 | 0.7449 |
| Andrés Alonso Gutiérrez Salinas                                                      |     50.3300 |        67.6500 | 0.7440 |
| Grzegorz Dzikiewicz                                                                  |     13.7200 |        18.4800 | 0.7424 |
| Leung Ka Ho                                                                          |     14.1500 |        19.0700 | 0.7420 |
| Evan John Paul Santos                                                                |     16.2000 |        21.8500 | 0.7414 |
| Kaitlyn Kim                                                                          |     29.3500 |        39.6800 | 0.7397 |
| Reynaldo Mape Jr.                                                                    |     16.4000 |        22.1900 | 0.7391 |
| Velidi Venkata Jagan Mohana Murali Krishna                                           |     15.4300 |        20.8900 | 0.7386 |
| Fikri Agung Purnomo                                                                  |     18.4800 |        25.0500 | 0.7377 |
| Kevin Jeffry Nalvarte Yantas                                                         |     14.2600 |        19.3400 | 0.7373 |
| Noah Arthurs                                                                         |     16.1000 |        21.8400 | 0.7372 |
| Bobby Yusuf                                                                          |     24.5800 |        33.3900 | 0.7361 |
| Fengyao Zhi (支烽耀)                                                                 |     21.7000 |        29.5100 | 0.7353 |
| Denis Tsukanov                                                                       |     17.4700 |        23.7800 | 0.7347 |
| Mantas Sidabras                                                                      |     15.9500 |        21.7700 | 0.7327 |
| Arut Klaewkasetkorn (อรุษ แกล้วเกษตรกรณ์)                                            |     12.0700 |        16.4900 | 0.7320 |
| Michał Korbacz                                                                       |     19.5900 |        26.7700 | 0.7318 |
| Reza Jadidi (رضا جدیدی)                                                              |     35.1000 |        47.9700 | 0.7317 |
| Zhanshuo Xu (徐展铄)                                                                 |     17.8800 |        24.4600 | 0.7310 |
| Dmitry Malushkin                                                                     |     24.0300 |        32.9000 | 0.7304 |
| Hanhan Liu (刘含菡)                                                                  |     19.5900 |        26.8500 | 0.7296 |
| Chao Wang (王超)                                                                     |     19.5000 |        26.7300 | 0.7295 |
| Junjie Huang (黄俊杰)                                                                |     13.6100 |        18.6600 | 0.7294 |
| Jie Ren 2 (任杰)                                                                     |     19.7800 |        27.1600 | 0.7283 |
| Lee Chun Hin (李震軒)                                                                |     15.3500 |        21.0800 | 0.7282 |
| Zichao Ye (叶子超)                                                                   |     21.3100 |        29.2700 | 0.7280 |
| Shuto Ueno (上野柊斗)                                                                |     11.6700 |        16.0400 | 0.7276 |
| Shubham Kumar                                                                        |     13.6300 |        18.7400 | 0.7273 |
| Ryan Jew                                                                             |     13.5300 |        18.6100 | 0.7270 |
| Ákos Rudas                                                                           |     24.1200 |        33.1800 | 0.7269 |
+--------------------------------------------------------------------------------------+-------------+----------------+--------+

Stefan · Sep 18, 2013

cubizh said:
SQL is nice for this statistics purpose too, but it wouldn't be so simple to integrate these fancy tables so easily.

Not with SQL alone, but with a little bit of let's say Python...

Code:

[noparse]import glob, os.path, mysql.connector
cnx = mysql.connector.connect(user='wcar', password='x', host='localhost', database='wcar')
cursor = cnx.cursor()
for infile in glob.glob('*.in'):
    name = os.path.splitext(infile)[0]
    print(name, '...')
    outfile = open(name + '.out', 'w', encoding='utf8')
    query = open(infile).read().strip()
    cursor.execute(query)
    print('[SPOILER="' + name + '"][TABLE="class:grid,align:left"]', file=outfile)
    print('[TR][TD][B]' + '[/B][/TD][TD][B]'.join(n for n in cursor.column_names) + '[/B][/TD][/TR]', file=outfile)
    for row in cursor:
        tr = '[TR]'
        for value in row:
            td = '[TD]' if type(value) is str else '[TD="align:right"]'
            tr += td + str(value) + '[/TD]'
        print(tr + '[/TR]', file=outfile)
    print('[/TABLE][SPOILER="SQL code"]' + query + '[/SPOILER][/SPOILER]', file=outfile)
    outfile.close()
cursor.close()
cnx.close()
[/noparse]

Then I just write the query (in file "Top female cuber by number of competitions.in") and the Python script does all the rest to produce this:

[TABLE="class:grid,align:left"]
[TR][TD]Competitions[/TD][TD]Name[/TD][/TR]
[TR][TD="align:right"]86[/TD][TD]Shelley Chang[/TD][/TR]
[TR][TD="align:right"]76[/TD][TD]Maria Oey[/TD][/TR]
[TR][TD="align:right"]66[/TD][TD]Jaclyn Sawler[/TD][/TR]
[TR][TD="align:right"]55[/TD][TD]Hanneke Rijks[/TD][/TR]
[TR][TD="align:right"]48[/TD][TD]Zoé de Moffarts[/TD][/TR]
[TR][TD="align:right"]45[/TD][TD]Mika Muranushi (村主美佳)[/TD][/TR]
[TR][TD="align:right"]43[/TD][TD]Sanae Koseki (古関佐苗)[/TD][/TR]
[TR][TD="align:right"]42[/TD][TD]Kirstine Buus Aagaard[/TD][/TR]
[TR][TD="align:right"]42[/TD][TD]Laetitia Lemoine[/TD][/TR]
[TR][TD="align:right"]41[/TD][TD]Berit Brüster[/TD][/TR]
[/TABLE]

SELECT count(distinct competitionId) Competitions, personName Name
FROM Results, Persons
WHERE gender='f' AND personId=Persons.id
GROUP BY personId
ORDER BY 1 desc
LIMIT 10

I have a few more things I want to add, but it's good enough for now...

cubizh · Sep 18, 2013

Stefan said:
I have a few more things I want to add, but it's good enough for now...

Consider adding width control for wide tables within TABLE="width:<px>,..."

TheDubDubJr · Sep 21, 2013

I would like to see the longest streaks for getting a PB at each competition for each event single and average.

cubizh · Sep 22, 2013

TheDubDubJr said:
I would like to see the longest streaks for getting a PB at each competition for each event single and average.

That's a lot of work to do, so for now I'm going to show the top 100 of number of solves that takes to improve on a 3x3 PB single.
If you find a mistake please let me know.

[TABLE="class:grid,align:left"]
[TR][TD] Name [/TD][TD] Last Competition of Old PB [/TD][TD] PB Time [/TD][TD] # of Solves Without Improve [/TD][TD] Ongoing [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] 1AVG2013 [/TD][TD] 7.08 [/TD][TD] 1096 [/TD][TD] X [/TD][/TR]
[TR][TD] Lars Vandenbergh [/TD][TD] N8W8Summer2013 [/TD][TD] 10.16 [/TD][TD] 845 [/TD][TD] X [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] NEMOAmsterdamOpen2012 [/TD][TD] 9.55 [/TD][TD] 705 [/TD][TD] [/TD][/TR]
[TR][TD] Bob Burton [/TD][TD] WC2013 [/TD][TD] 13.15 [/TD][TD] 636 [/TD][TD] X [/TD][/TR]
[TR][TD] Ton Dennenbroek [/TD][TD] HEMMariCubikOpen2013 [/TD][TD] 13.28 [/TD][TD] 619 [/TD][TD] [/TD][/TR]
[TR][TD] Clément Gallet [/TD][TD] ChampagneOpen2013 [/TD][TD] 11.13 [/TD][TD] 592 [/TD][TD] X [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] WC2013 [/TD][TD] 6.94 [/TD][TD] 584 [/TD][TD] X [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] ChojniceOpen2013 [/TD][TD] 7.91 [/TD][TD] 572 [/TD][TD] X [/TD][/TR]
[TR][TD] Shelley Chang [/TD][TD] BayAreaSummer2013 [/TD][TD] 10.77 [/TD][TD] 470 [/TD][TD] X [/TD][/TR]
[TR][TD] Joey Gouly [/TD][TD] Euro2012 [/TD][TD] 9.15 [/TD][TD] 402 [/TD][TD] [/TD][/TR]
[TR][TD] Philippe Virouleau [/TD][TD] WC2013 [/TD][TD] 10.19 [/TD][TD] 399 [/TD][TD] X [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] NEMOAmsterdamOpen2012 [/TD][TD] 10.46 [/TD][TD] 365 [/TD][TD] [/TD][/TR]
[TR][TD] Adam Zamora [/TD][TD] USNationals2011 [/TD][TD] 13.55 [/TD][TD] 337 [/TD][TD] [/TD][/TR]
[TR][TD] Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) [/TD][TD] France2013 [/TD][TD] 7.40 [/TD][TD] 331 [/TD][TD] X [/TD][/TR]
[TR][TD] François Courtès [/TD][TD] ChampagneOpen2013 [/TD][TD] 15.18 [/TD][TD] 315 [/TD][TD] X [/TD][/TR]
[TR][TD] Devin Corr-Robinett [/TD][TD] BerkeleySummer2013 [/TD][TD] 9.47 [/TD][TD] 308 [/TD][TD] X [/TD][/TR]
[TR][TD] Rama Temmink [/TD][TD] SpolsOpen2011 [/TD][TD] 10.11 [/TD][TD] 298 [/TD][TD] [/TD][/TR]
[TR][TD] Lorenzo Vigani Poli [/TD][TD] MilanBlindDay2013 [/TD][TD] 9.19 [/TD][TD] 297 [/TD][TD] X [/TD][/TR]
[TR][TD] Joël van Noort [/TD][TD] AachenOpen2011 [/TD][TD] 10.78 [/TD][TD] 295 [/TD][TD] [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] ErfurtOpen2013 [/TD][TD] 10.09 [/TD][TD] 294 [/TD][TD] [/TD][/TR]
[TR][TD] Leyan Lo [/TD][TD] RenoWinter2010 [/TD][TD] 10.63 [/TD][TD] 293 [/TD][TD] [/TD][/TR]
[TR][TD] Hideki Niina (新名秀樹) [/TD][TD] EastOsaka2013 [/TD][TD] 10.77 [/TD][TD] 289 [/TD][TD] X [/TD][/TR]
[TR][TD] Maximilian Neitzel [/TD][TD] WC2013 [/TD][TD] 8.22 [/TD][TD] 286 [/TD][TD] X [/TD][/TR]
[TR][TD] Nobuaki Suga (菅信昭) [/TD][TD] CubeCampKanazawa2013 [/TD][TD] 8.72 [/TD][TD] 285 [/TD][TD] X [/TD][/TR]
[TR][TD] Anders Larsson [/TD][TD] SwedishChampionship2013 [/TD][TD] 30.06 [/TD][TD] 279 [/TD][TD] X [/TD][/TR]
[TR][TD] Filippo Brancaleoni [/TD][TD] CubeCampKanazawa2011 [/TD][TD] 9.28 [/TD][TD] 279 [/TD][TD] [/TD][/TR]
[TR][TD] Benjamin Sintes [/TD][TD] ChampagneOpen2013 [/TD][TD] 9.72 [/TD][TD] 270 [/TD][TD] X [/TD][/TR]
[TR][TD] Dan Dzoan [/TD][TD] USNationals2009 [/TD][TD] 10.08 [/TD][TD] 268 [/TD][TD] [/TD][/TR]
[TR][TD] Geert Bicler [/TD][TD] N8W8Summer2013 [/TD][TD] 13.30 [/TD][TD] 265 [/TD][TD] X [/TD][/TR]
[TR][TD] Jim Mertens [/TD][TD] Indiana2013 [/TD][TD] 11.43 [/TD][TD] 258 [/TD][TD] X [/TD][/TR]
[TR][TD] Yohei Oka (岡要平) [/TD][TD] KansaiOpen2012 [/TD][TD] 9.68 [/TD][TD] 258 [/TD][TD] [/TD][/TR]
[TR][TD] Syuhei Omura (大村周平) [/TD][TD] KawasakiAutumn2013 [/TD][TD] 8.09 [/TD][TD] 256 [/TD][TD] X [/TD][/TR]
[TR][TD] Weifeng Cheng (程维锋) [/TD][TD] GuangzhouCCSA2013 [/TD][TD] 9.71 [/TD][TD] 251 [/TD][TD] X [/TD][/TR]
[TR][TD] Michał Robaczyk [/TD][TD] CubeFactory2011 [/TD][TD] 9.38 [/TD][TD] 245 [/TD][TD] X [/TD][/TR]
[TR][TD] Chia-Wei Lu (呂家維) [/TD][TD] BayAreaSummer2013 [/TD][TD] 8.25 [/TD][TD] 245 [/TD][TD] X [/TD][/TR]
[TR][TD] Dave Campbell [/TD][TD] TorontoSpring2010 [/TD][TD] 13.02 [/TD][TD] 244 [/TD][TD] [/TD][/TR]
[TR][TD] Tyson Mao (毛台勝) [/TD][TD] WC2013 [/TD][TD] 12.75 [/TD][TD] 243 [/TD][TD] X [/TD][/TR]
[TR][TD] Adrian Lehmann [/TD][TD] SHOpen2013 [/TD][TD] 9.46 [/TD][TD] 242 [/TD][TD] [/TD][/TR]
[TR][TD] Arnaud van Galen [/TD][TD] BrusselsSummerOpen2009 [/TD][TD] 16.91 [/TD][TD] 239 [/TD][TD] [/TD][/TR]
[TR][TD] Adam Polkowski [/TD][TD] LodzOpen2011 [/TD][TD] 9.25 [/TD][TD] 237 [/TD][TD] [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] Altbier2011 [/TD][TD] 12.28 [/TD][TD] 236 [/TD][TD] [/TD][/TR]
[TR][TD] Lucas Garron [/TD][TD] BerkeleySummer2013 [/TD][TD] 8.05 [/TD][TD] 234 [/TD][TD] X [/TD][/TR]
[TR][TD] Michał Halczuk [/TD][TD] ChojniceOpen2013 [/TD][TD] 8.22 [/TD][TD] 234 [/TD][TD] X [/TD][/TR]
[TR][TD] Grzegorz Łuczyna [/TD][TD] PolishNationals2013 [/TD][TD] 10.00 [/TD][TD] 233 [/TD][TD] X [/TD][/TR]
[TR][TD] Jeremy Fleischman [/TD][TD] StanfordWinter2012 [/TD][TD] 9.63 [/TD][TD] 230 [/TD][TD] [/TD][/TR]
[TR][TD] Shotaro Makisumi (牧角章太郎) [/TD][TD] WC2013 [/TD][TD] 8.50 [/TD][TD] 229 [/TD][TD] X [/TD][/TR]
[TR][TD] Filippo Brancaleoni [/TD][TD] Oslo2013 [/TD][TD] 8.65 [/TD][TD] 229 [/TD][TD] X [/TD][/TR]
[TR][TD] Björn Korbanka [/TD][TD] SHOpen2013 [/TD][TD] 7.68 [/TD][TD] 229 [/TD][TD] X [/TD][/TR]
[TR][TD] Jan Bentlage [/TD][TD] SHOpen2013 [/TD][TD] 10.56 [/TD][TD] 227 [/TD][TD] X [/TD][/TR]
[TR][TD] Thibaut Jacquinot [/TD][TD] WC2011 [/TD][TD] 9.86 [/TD][TD] 226 [/TD][TD] X [/TD][/TR]
[TR][TD] Sinpei Araki (荒木慎平) [/TD][TD] HiroshimaOpen2012 [/TD][TD] 8.94 [/TD][TD] 221 [/TD][TD] [/TD][/TR]
[TR][TD] Yohei Oka (岡要平) [/TD][TD] EastOsaka2013 [/TD][TD] 7.84 [/TD][TD] 216 [/TD][TD] X [/TD][/TR]
[TR][TD] Harris Chan [/TD][TD] WC2013 [/TD][TD] 7.33 [/TD][TD] 216 [/TD][TD] X [/TD][/TR]
[TR][TD] Zoé de Moffarts [/TD][TD] N8W8Summer2013 [/TD][TD] 12.41 [/TD][TD] 215 [/TD][TD] X [/TD][/TR]
[TR][TD] Fubo Wang (王富博) [/TD][TD] BeijingSummer2012 [/TD][TD] 10.22 [/TD][TD] 214 [/TD][TD] [/TD][/TR]
[TR][TD] Alejandro Aguado Barahona [/TD][TD] SpanishChampionship2011 [/TD][TD] 9.47 [/TD][TD] 213 [/TD][TD] X [/TD][/TR]
[TR][TD] Gaël Dusser [/TD][TD] FlipOpen2013 [/TD][TD] 12.46 [/TD][TD] 212 [/TD][TD] X [/TD][/TR]
[TR][TD] Kevin Guillaumond [/TD][TD] BussieresOpen2013 [/TD][TD] 11.96 [/TD][TD] 212 [/TD][TD] X [/TD][/TR]
[TR][TD] Steven Turner [/TD][TD] SanDiegoSummer2013 [/TD][TD] 11.83 [/TD][TD] 210 [/TD][TD] [/TD][/TR]
[TR][TD] Kian Barry [/TD][TD] MITSpring2013 [/TD][TD] 11.13 [/TD][TD] 209 [/TD][TD] [/TD][/TR]
[TR][TD] Nora Christ [/TD][TD] AmstelveenOpen2012 [/TD][TD] 11.28 [/TD][TD] 208 [/TD][TD] [/TD][/TR]
[TR][TD] Henrik Buus Aagaard [/TD][TD] SkarupChristmas2010 [/TD][TD] 11.65 [/TD][TD] 207 [/TD][TD] [/TD][/TR]
[TR][TD] Chester Lian [/TD][TD] Dayton2012 [/TD][TD] 9.58 [/TD][TD] 207 [/TD][TD] [/TD][/TR]
[TR][TD] Edouard Chambon [/TD][TD] SydneyAutumn2012 [/TD][TD] 8.66 [/TD][TD] 206 [/TD][TD] X [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] Brown2012 [/TD][TD] 10.53 [/TD][TD] 205 [/TD][TD] [/TD][/TR]
[TR][TD] Bence Barát [/TD][TD] AustrianBigCube2013 [/TD][TD] 7.53 [/TD][TD] 205 [/TD][TD] X [/TD][/TR]
[TR][TD] Moritz Karl [/TD][TD] FranconiaOpen2013 [/TD][TD] 8.13 [/TD][TD] 205 [/TD][TD] X [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] KyushuOpen2012 [/TD][TD] 8.09 [/TD][TD] 204 [/TD][TD] [/TD][/TR]
[TR][TD] Jeremy Fleischman [/TD][TD] MITFall2010 [/TD][TD] 10.72 [/TD][TD] 200 [/TD][TD] [/TD][/TR]
[TR][TD] Pierre Lemerle [/TD][TD] WC2013 [/TD][TD] 11.53 [/TD][TD] 200 [/TD][TD] [/TD][/TR]
[TR][TD] Arnaud van Galen [/TD][TD] ChonburiOpen2011 [/TD][TD] 16.33 [/TD][TD] 198 [/TD][TD] [/TD][/TR]
[TR][TD] Francisco Javier Lemes Sáez [/TD][TD] France2013 [/TD][TD] 10.09 [/TD][TD] 198 [/TD][TD] [/TD][/TR]
[TR][TD] Zoé de Moffarts [/TD][TD] LaMontagneOpen2012 [/TD][TD] 15.18 [/TD][TD] 197 [/TD][TD] [/TD][/TR]
[TR][TD] Robert Yau [/TD][TD] BerkeleySummer2013 [/TD][TD] 7.28 [/TD][TD] 196 [/TD][TD] [/TD][/TR]
[TR][TD] Rodrigo Septién Rodríguez [/TD][TD] SpanishChampionship2011 [/TD][TD] 10.52 [/TD][TD] 195 [/TD][TD] X [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] WashingtonDCOpen2010 [/TD][TD] 8.91 [/TD][TD] 194 [/TD][TD] [/TD][/TR]
[TR][TD] Jan Smarschevski [/TD][TD] BWOpen2013 [/TD][TD] 8.61 [/TD][TD] 194 [/TD][TD] [/TD][/TR]
[TR][TD] Vincent Sheu [/TD][TD] BerkeleySummer2013 [/TD][TD] 8.55 [/TD][TD] 193 [/TD][TD] X [/TD][/TR]
[TR][TD] Sinpei Araki (荒木慎平) [/TD][TD] EastOsaka2013 [/TD][TD] 8.88 [/TD][TD] 190 [/TD][TD] X [/TD][/TR]
[TR][TD] Patricia Li [/TD][TD] MITFall2012 [/TD][TD] 9.69 [/TD][TD] 190 [/TD][TD] [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] WC2013 [/TD][TD] 8.71 [/TD][TD] 187 [/TD][TD] X [/TD][/TR]
[TR][TD] Alexander Olleta del Molino [/TD][TD] VilladeCatral2013 [/TD][TD] 10.21 [/TD][TD] 187 [/TD][TD] X [/TD][/TR]
[TR][TD] Laura Ohrndorf [/TD][TD] SHOpen2013 [/TD][TD] 13.25 [/TD][TD] 187 [/TD][TD] X [/TD][/TR]
[TR][TD] Kåre Krig [/TD][TD] SwedishCubedays2011 [/TD][TD] 14.58 [/TD][TD] 185 [/TD][TD] [/TD][/TR]
[TR][TD] Milán Baticz [/TD][TD] BIHOpen2012 [/TD][TD] 7.58 [/TD][TD] 184 [/TD][TD] [/TD][/TR]
[TR][TD] Stefan Pochmann [/TD][TD] WC2013 [/TD][TD] 9.56 [/TD][TD] 182 [/TD][TD] X [/TD][/TR]
[TR][TD] Kentaro Nishi (西賢太郎) [/TD][TD] TachikawaFest2013 [/TD][TD] 9.58 [/TD][TD] 181 [/TD][TD] X [/TD][/TR]
[TR][TD] István Kocza [/TD][TD] WC2011 [/TD][TD] 17.80 [/TD][TD] 180 [/TD][TD] [/TD][/TR]
[TR][TD] Renan Mondini Cerpe [/TD][TD] Brasileiro2013 [/TD][TD] 9.65 [/TD][TD] 180 [/TD][TD] X [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] JapanContest2012 [/TD][TD] 7.72 [/TD][TD] 180 [/TD][TD] [/TD][/TR]
[TR][TD] Timo Ludwig [/TD][TD] FranconiaOpen2013 [/TD][TD] 9.06 [/TD][TD] 179 [/TD][TD] X [/TD][/TR]
[TR][TD] Arnaud van Galen [/TD][TD] Euro2012 [/TD][TD] 14.08 [/TD][TD] 178 [/TD][TD] [/TD][/TR]
[TR][TD] Mats Valk [/TD][TD] DutchOpen2012 [/TD][TD] 6.41 [/TD][TD] 178 [/TD][TD] [/TD][/TR]
[TR][TD] Wataru Hashimura (端村航) [/TD][TD] KansaiStarFestival2013 [/TD][TD] 7.83 [/TD][TD] 178 [/TD][TD] [/TD][/TR]
[TR][TD] Clément Gallet [/TD][TD] SwissOpen2009 [/TD][TD] 13.96 [/TD][TD] 177 [/TD][TD] [/TD][/TR]
[TR][TD] Milán Baticz [/TD][TD] Euro2010 [/TD][TD] 8.86 [/TD][TD] 174 [/TD][TD] [/TD][/TR]
[TR][TD] Phillip Espinoza [/TD][TD] SanDiegoOpen2010 [/TD][TD] 9.73 [/TD][TD] 173 [/TD][TD] [/TD][/TR]
[TR][TD] Stefano Bevacqua [/TD][TD] MilanWinterOpen2013 [/TD][TD] 8.90 [/TD][TD] 173 [/TD][TD] X [/TD][/TR]
[TR][TD] Ton Dennenbroek [/TD][TD] GermanOpen2008 [/TD][TD] 13.68 [/TD][TD] 172 [/TD][TD] [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] WashingtonDCSpring2010 [/TD][TD] 11.77 [/TD][TD] 171 [/TD][TD] [/TD][/TR]
[/TABLE]

Hippolyte!!! · Sep 22, 2013

Hi!
Could you please do the same for 333 avg?
Thanks!

Flyt · Sep 22, 2013

I don't know how easy/hard it is to do, but I'm interested to know who and in which event has most solves in the intervals [single PB, 1.01*single PB], [single PB, 1.05*single PB] and [single PB, 1.1*single PB].
For exemple, at 5x5, my PB is 1:40.09=100.09 seconds. And I've 6 solves in [100.09, 101.09], 17 in [100.09, 105.09], and 32 in [100.09, 110.09]. (out of 79 solves...). (exclude magic, of course...)

Moreover, I've another request. I wonder who has most events in which, each time he beast a PB, he also beats a NR (please include 1st competition in which he participates, and single AND avg)(I've 5, with 4x4,mega,sq-1,clock and 7x7, but I guess there's much better, Feliks has 12, if I counted right).

I hope everything's clear enough. Thanks

cubizh · Sep 22, 2013

Hippolyte!!! said:
Hi!
Could you please do the same for 333 avg?
Thanks!

Yes. I see you in there

(Times are *100)

[TABLE="class:grid,align:left"]
[TR][TD] Name [/TD][TD] Last Competition of Old PB [/TD][TD] PB Time [/TD][TD] # of Averages Without Improve [/TD][TD] Ongoing [/TD][/TR]
[TR][TD] Lars Vandenbergh [/TD][TD] AachenOpen2011 [/TD][TD] 1451 [/TD][TD] 157 [/TD][TD] [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] 1AVG2013 [/TD][TD] 931 [/TD][TD] 103 [/TD][TD] X [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] SHOpen2013 [/TD][TD] 1345 [/TD][TD] 92 [/TD][TD] X [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] WC2013 [/TD][TD] 827 [/TD][TD] 76 [/TD][TD] X [/TD][/TR]
[TR][TD] Clément Gallet [/TD][TD] ChampagneOpen2013 [/TD][TD] 1488 [/TD][TD] 74 [/TD][TD] X [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] WC2013 [/TD][TD] 1262 [/TD][TD] 71 [/TD][TD] X [/TD][/TR]
[TR][TD] Bob Burton [/TD][TD] HarvardSpring2012 [/TD][TD] 1692 [/TD][TD] 66 [/TD][TD] [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] RybnikOpen2013 [/TD][TD] 987 [/TD][TD] 66 [/TD][TD] [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] KansaiOpen2013 [/TD][TD] 891 [/TD][TD] 63 [/TD][TD] [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] WC2013 [/TD][TD] 1184 [/TD][TD] 61 [/TD][TD] X [/TD][/TR]
[TR][TD] Michael Röhrer [/TD][TD] AustrianBigCube2013 [/TD][TD] 1260 [/TD][TD] 61 [/TD][TD] X [/TD][/TR]
[TR][TD] Dave Campbell [/TD][TD] WC2013 [/TD][TD] 1389 [/TD][TD] 60 [/TD][TD] X [/TD][/TR]
[TR][TD] Nobuaki Suga (菅信昭) [/TD][TD] KantoWinter2012 [/TD][TD] 1165 [/TD][TD] 60 [/TD][TD] [/TD][/TR]
[TR][TD] Clément Gallet [/TD][TD] MontpellierOpen2011 [/TD][TD] 1559 [/TD][TD] 53 [/TD][TD] [/TD][/TR]
[TR][TD] Jim Mertens [/TD][TD] Indiana2013 [/TD][TD] 1398 [/TD][TD] 52 [/TD][TD] X [/TD][/TR]
[TR][TD] Lorenzo Vigani Poli [/TD][TD] TriesteOpen2013 [/TD][TD] 1174 [/TD][TD] 49 [/TD][TD] [/TD][/TR]
[TR][TD] Zoé de Moffarts [/TD][TD] N8W8Summer2013 [/TD][TD] 1696 [/TD][TD] 49 [/TD][TD] X [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] BelgianOpen2011 [/TD][TD] 1351 [/TD][TD] 48 [/TD][TD] [/TD][/TR]
[TR][TD] Rafael Werneck Cinoto [/TD][TD] SESCAraraquara2013 [/TD][TD] 1725 [/TD][TD] 48 [/TD][TD] X [/TD][/TR]
[TR][TD] Grzegorz Łuczyna [/TD][TD] PolishNationals2013 [/TD][TD] 1386 [/TD][TD] 47 [/TD][TD] X [/TD][/TR]
[TR][TD] Kåre Krig [/TD][TD] SwedishChampionship2013 [/TD][TD] 1768 [/TD][TD] 46 [/TD][TD] X [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] Altbier2011 [/TD][TD] 1492 [/TD][TD] 46 [/TD][TD] [/TD][/TR]
[TR][TD] Kalina Brzezińska [/TD][TD] ChojniceOpen2013 [/TD][TD] 1123 [/TD][TD] 46 [/TD][TD] X [/TD][/TR]
[TR][TD] Niklas Spies [/TD][TD] HasseltOpen2012 [/TD][TD] 1243 [/TD][TD] 46 [/TD][TD] [/TD][/TR]
[TR][TD] Sinpei Araki (荒木慎平) [/TD][TD] EastOsaka2013 [/TD][TD] 1125 [/TD][TD] 45 [/TD][TD] X [/TD][/TR]
[TR][TD] François Courtès [/TD][TD] HEMMariCubikOpen2013 [/TD][TD] 1944 [/TD][TD] 45 [/TD][TD] [/TD][/TR]
[TR][TD] Lars Vandenbergh [/TD][TD] N8W8Summer2013 [/TD][TD] 1404 [/TD][TD] 44 [/TD][TD] X [/TD][/TR]
[TR][TD] Renan Mondini Cerpe [/TD][TD] Brasileiro2013 [/TD][TD] 1303 [/TD][TD] 44 [/TD][TD] [/TD][/TR]
[TR][TD] Joey Gouly [/TD][TD] GuildfordOpen2013 [/TD][TD] 1117 [/TD][TD] 44 [/TD][TD] [/TD][/TR]
[TR][TD] Laura Ohrndorf [/TD][TD] SHOpen2013 [/TD][TD] 1753 [/TD][TD] 44 [/TD][TD] X [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] Euro2008 [/TD][TD] 1413 [/TD][TD] 43 [/TD][TD] [/TD][/TR]
[TR][TD] Edouard Chambon [/TD][TD] France2010 [/TD][TD] 1148 [/TD][TD] 43 [/TD][TD] [/TD][/TR]
[TR][TD] Shelley Chang [/TD][TD] CalDay2012 [/TD][TD] 1520 [/TD][TD] 42 [/TD][TD] [/TD][/TR]
[TR][TD] Lucas Garron [/TD][TD] BerkeleyWinter2012 [/TD][TD] 1210 [/TD][TD] 42 [/TD][TD] [/TD][/TR]
[TR][TD] Syuhei Omura (大村周平) [/TD][TD] KawasakiAutumn2013 [/TD][TD] 963 [/TD][TD] 41 [/TD][TD] X [/TD][/TR]
[TR][TD] Breandan Vallance [/TD][TD] EdinburghOpen2013 [/TD][TD] 881 [/TD][TD] 41 [/TD][TD] [/TD][/TR]
[TR][TD] Bence Barát [/TD][TD] AustrianBigCube2013 [/TD][TD] 1028 [/TD][TD] 41 [/TD][TD] X [/TD][/TR]
[TR][TD] Hippolyte Moreau [/TD][TD] ChampagneOpen2013 [/TD][TD] 1145 [/TD][TD] 41 [/TD][TD] X [/TD][/TR]
[TR][TD] István Kocza [/TD][TD] VargardaOpen2012 [/TD][TD] 2130 [/TD][TD] 40 [/TD][TD] [/TD][/TR]
[TR][TD] Sébastien Auroux [/TD][TD] UKOpen2011 [/TD][TD] 1371 [/TD][TD] 40 [/TD][TD] [/TD][/TR]
[TR][TD] Javier Tirado Ortiz [/TD][TD] VilladeCatral2013 [/TD][TD] 1758 [/TD][TD] 40 [/TD][TD] X [/TD][/TR]
[TR][TD] Ton Dennenbroek [/TD][TD] BeneluxOpen2010 [/TD][TD] 1780 [/TD][TD] 39 [/TD][TD] [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] HarvardSpring2011 [/TD][TD] 1249 [/TD][TD] 39 [/TD][TD] [/TD][/TR]
[TR][TD] Yohei Oka (岡要平) [/TD][TD] EastOsaka2013 [/TD][TD] 1030 [/TD][TD] 39 [/TD][TD] X [/TD][/TR]
[TR][TD] Kian Barry [/TD][TD] CaptainsCove2012 [/TD][TD] 1326 [/TD][TD] 39 [/TD][TD] [/TD][/TR]
[TR][TD] Phil Yu [/TD][TD] RiverHillSummer2012 [/TD][TD] 1195 [/TD][TD] 39 [/TD][TD] [/TD][/TR]
[TR][TD] Tyson Mao (毛台勝) [/TD][TD] WC2013 [/TD][TD] 1560 [/TD][TD] 38 [/TD][TD] X [/TD][/TR]
[TR][TD] Steven Turner [/TD][TD] NiseiWeek2013 [/TD][TD] 1356 [/TD][TD] 38 [/TD][TD] [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] EastGermanOpen2010 [/TD][TD] 1007 [/TD][TD] 37 [/TD][TD] [/TD][/TR]
[TR][TD] Dan Dzoan [/TD][TD] WC2013 [/TD][TD] 1113 [/TD][TD] 37 [/TD][TD] X [/TD][/TR]
[TR][TD] Emile Compion [/TD][TD] CanadianOpen2013 [/TD][TD] 1552 [/TD][TD] 37 [/TD][TD] X [/TD][/TR]
[TR][TD] Chia-Wei Lu (呂家維) [/TD][TD] BayAreaSummer2013 [/TD][TD] 1014 [/TD][TD] 37 [/TD][TD] X [/TD][/TR]
[TR][TD] Robert Yau [/TD][TD] WC2013 [/TD][TD] 932 [/TD][TD] 37 [/TD][TD] [/TD][/TR]
[TR][TD] Ron van Bruchem [/TD][TD] DutchOpen2009 [/TD][TD] 1385 [/TD][TD] 36 [/TD][TD] [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] HarvardSpring2012 [/TD][TD] 1232 [/TD][TD] 36 [/TD][TD] [/TD][/TR]
[TR][TD] Stefan Huber [/TD][TD] AustrianOpen2013 [/TD][TD] 979 [/TD][TD] 36 [/TD][TD] [/TD][/TR]
[TR][TD] Moritz Karl [/TD][TD] FranconiaOpen2013 [/TD][TD] 1095 [/TD][TD] 36 [/TD][TD] X [/TD][/TR]
[TR][TD] Bob Burton [/TD][TD] UtahOpen2009 [/TD][TD] 1786 [/TD][TD] 35 [/TD][TD] [/TD][/TR]
[TR][TD] Joël van Noort [/TD][TD] PoznanOpen2010 [/TD][TD] 1276 [/TD][TD] 35 [/TD][TD] [/TD][/TR]
[TR][TD] Adam Zamora [/TD][TD] WC2013 [/TD][TD] 1630 [/TD][TD] 35 [/TD][TD] X [/TD][/TR]
[TR][TD] Patrick Jameson [/TD][TD] Monmouth2013 [/TD][TD] 1179 [/TD][TD] 35 [/TD][TD] X [/TD][/TR]
[TR][TD] Sarah Strong [/TD][TD] CanadianOpen2013 [/TD][TD] 1234 [/TD][TD] 35 [/TD][TD] [/TD][/TR]
[TR][TD] Edward Lin [/TD][TD] BayAreaSummer2013 [/TD][TD] 937 [/TD][TD] 35 [/TD][TD] X [/TD][/TR]
[TR][TD] Hideki Niina (新名秀樹) [/TD][TD] HiroshimaOpen2012 [/TD][TD] 1466 [/TD][TD] 35 [/TD][TD] [/TD][/TR]
[TR][TD] Anton Rostovikov [/TD][TD] MoscowSummer2013 [/TD][TD] 1226 [/TD][TD] 35 [/TD][TD] [/TD][/TR]
[TR][TD] Bryan Logan [/TD][TD] WinonaOpen2013 [/TD][TD] 2193 [/TD][TD] 34 [/TD][TD] X [/TD][/TR]
[TR][TD] Andrew Ricci [/TD][TD] YaleSpring2013 [/TD][TD] 915 [/TD][TD] 34 [/TD][TD] [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] BelgianOpen2010 [/TD][TD] 1049 [/TD][TD] 33 [/TD][TD] [/TD][/TR]
[TR][TD] Michał Robaczyk [/TD][TD] SilesiaOpen2009 [/TD][TD] 1325 [/TD][TD] 33 [/TD][TD] [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] BridgewaterOpen2011 [/TD][TD] 891 [/TD][TD] 33 [/TD][TD] [/TD][/TR]
[TR][TD] Adam Polkowski [/TD][TD] ChojniceOpen2013 [/TD][TD] 1059 [/TD][TD] 33 [/TD][TD] X [/TD][/TR]
[TR][TD] Fabrizio Cirnigliaro [/TD][TD] MilanBlindDay2013 [/TD][TD] 2446 [/TD][TD] 33 [/TD][TD] X [/TD][/TR]
[TR][TD] Philippe Virouleau [/TD][TD] BreizhOpen2012 [/TD][TD] 1333 [/TD][TD] 33 [/TD][TD] [/TD][/TR]
[TR][TD] Björn Korbanka [/TD][TD] AustrianBigCube2013 [/TD][TD] 1015 [/TD][TD] 33 [/TD][TD] [/TD][/TR]
[TR][TD] Ton Dennenbroek [/TD][TD] SpolsOpen2011 [/TD][TD] 1737 [/TD][TD] 32 [/TD][TD] [/TD][/TR]
[TR][TD] Jeremy Fleischman [/TD][TD] BerkeleyWinter2013 [/TD][TD] 1117 [/TD][TD] 32 [/TD][TD] [/TD][/TR]
[TR][TD] Thibaut Jacquinot [/TD][TD] France2011 [/TD][TD] 1257 [/TD][TD] 32 [/TD][TD] [/TD][/TR]
[TR][TD] Rama Temmink [/TD][TD] DutchNationals2011 [/TD][TD] 1168 [/TD][TD] 32 [/TD][TD] [/TD][/TR]
[TR][TD] Kian Barry [/TD][TD] WC2013 [/TD][TD] 1319 [/TD][TD] 32 [/TD][TD] X [/TD][/TR]
[TR][TD] Filippo Brancaleoni [/TD][TD] Oslo2013 [/TD][TD] 1185 [/TD][TD] 32 [/TD][TD] X [/TD][/TR]
[TR][TD] Dongdong Qu (曲冬冬) [/TD][TD] BeijingSummer2013 [/TD][TD] 1170 [/TD][TD] 32 [/TD][TD] X [/TD][/TR]
[TR][TD] Sebastián Pino Castillo [/TD][TD] Cuberos2011 [/TD][TD] 1819 [/TD][TD] 32 [/TD][TD] X [/TD][/TR]
[TR][TD] Donglei Li (李冬雷) [/TD][TD] ChongqingOpen2013 [/TD][TD] 1566 [/TD][TD] 32 [/TD][TD] [/TD][/TR]
[TR][TD] Michał Pleskowicz [/TD][TD] WC2013 [/TD][TD] 865 [/TD][TD] 32 [/TD][TD] X [/TD][/TR]
[TR][TD] Ton Dennenbroek [/TD][TD] DutchOpen2012 [/TD][TD] 1692 [/TD][TD] 31 [/TD][TD] [/TD][/TR]
[TR][TD] Carlos Angosto Hernández [/TD][TD] VilladeCatral2013 [/TD][TD] 1955 [/TD][TD] 31 [/TD][TD] X [/TD][/TR]
[TR][TD] Arnaud van Galen [/TD][TD] BUAAOpen2010 [/TD][TD] 1996 [/TD][TD] 31 [/TD][TD] [/TD][/TR]
[TR][TD] John Tamanas [/TD][TD] BridgewaterOpen2011 [/TD][TD] 1050 [/TD][TD] 31 [/TD][TD] [/TD][/TR]
[TR][TD] Ernie Pulchny [/TD][TD] WC2013 [/TD][TD] 1437 [/TD][TD] 31 [/TD][TD] [/TD][/TR]
[TR][TD] Milán Baticz [/TD][TD] SerbianOpen2013 [/TD][TD] 948 [/TD][TD] 30 [/TD][TD] [/TD][/TR]
[TR][TD] Jason Baum [/TD][TD] CMUSpring2012 [/TD][TD] 1197 [/TD][TD] 30 [/TD][TD] X [/TD][/TR]
[TR][TD] Łukasz Ciałoń [/TD][TD] PoznanOpen2011 [/TD][TD] 1670 [/TD][TD] 30 [/TD][TD] X [/TD][/TR]
[TR][TD] Henrik Buus Aagaard [/TD][TD] SwedishChampionship2012 [/TD][TD] 1228 [/TD][TD] 30 [/TD][TD] [/TD][/TR]
[TR][TD] Chris Dzoan [/TD][TD] SafeHaven2009 [/TD][TD] 1393 [/TD][TD] 30 [/TD][TD] [/TD][/TR]
[TR][TD] Yuhei Takagi (高木佑平) [/TD][TD] LakeBiwa2013 [/TD][TD] 1121 [/TD][TD] 30 [/TD][TD] [/TD][/TR]
[TR][TD] Yinghao Wang (王鹰豪) [/TD][TD] SMU2013 [/TD][TD] 1070 [/TD][TD] 30 [/TD][TD] [/TD][/TR]
[TR][TD] Sinpei Araki (荒木慎平) [/TD][TD] KantoOpen2012 [/TD][TD] 1127 [/TD][TD] 29 [/TD][TD] [/TD][/TR]
[TR][TD] Syuhei Omura (大村周平) [/TD][TD] MatsudoSpring2012 [/TD][TD] 1012 [/TD][TD] 29 [/TD][TD] [/TD][/TR]
[TR][TD] Takuya Furukawa (古河拓也) [/TD][TD] KansaiStarFestival2013 [/TD][TD] 1224 [/TD][TD] 29 [/TD][TD] X [/TD][/TR]
[TR][TD] Xiaobo Jin (金晓波) [/TD][TD] ShanghaiSummer2013 [/TD][TD] 1073 [/TD][TD] 29 [/TD][TD] [/TD][/TR]
[TR][TD] Yu Sajima (佐島優) [/TD][TD] JapanOpen2013 [/TD][TD] 902 [/TD][TD] 29 [/TD][TD] [/TD][/TR]
[TR][TD] Riadi Arsandi [/TD][TD] JakartaSpeedcubing2013 [/TD][TD] 1296 [/TD][TD] 29 [/TD][TD] X [/TD][/TR]
[TR][TD] Dene Beardsley [/TD][TD] WaikatoSummerOpen2011 [/TD][TD] 1506 [/TD][TD] 29 [/TD][TD] [/TD][/TR]
[TR][TD] Cornelius Dieckmann [/TD][TD] BerkeleySummer2013 [/TD][TD] 821 [/TD][TD] 29 [/TD][TD] X [/TD][/TR]
[TR][TD] Mike Kotch [/TD][TD] WC2013 [/TD][TD] 1149 [/TD][TD] 29 [/TD][TD] X [/TD][/TR]
[/TABLE]

Odd WCA stats/ Stats request Thread

Veteran

Legend

Veteran

Veteran

Legend

Regular

Legend

Regular

Veteran

Veteran

Legend

Veteran

Regular

Legend

Veteran

Cupcake

Veteran

Regular

Member

Veteran

Similar threads