• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.

Odd WCA stats/ Stats request Thread

Stefan's stats are talking about "winning ties" and "losing ties". How about ties that don't get broken?

There have been 11 of them. I'm the only person to have 2 ties not get broken (this is only counting results where both people got non-DNF averages). So my record for ties is 3 wins, 0 losses, 2 ties.

Code: 
competitionId 		eventId roundId best 	average person1 		person2
CornellSpring2008 	333 	1 	1566 	1733 	Jim Mertens 		Tim Reynolds
USOpen2008 		222 	f 	581 	734 	Dan Cohen 		Jason Baum
IliganOpen2008 		222 	f 	825 	1357 	Xyrr Baldonado 		Silver Bob Tubio
BeijingSummerOpen2009 	magic 	f 	202 	312 	Tiesheng Li (李铁生) 	Xiaoling Yang (杨晓玲)
ShenzhenSummerOpen2009 	magic 	1 	118 	251 	Chan Chun Hang (陳浚鏗) 	Shixin Chen (陈诗新)
WC2009 			magic 	f 	166 	201 	Olivier Polspoel 	Frank Provoost
3MolaOpen2010 		333 	d 	1283 	1431 	Michal Robaczyk 	Piotr Frankowski
USNationals2010 	magic 	1 	134 	150 	Tim Reynolds 		Rowe Hessler
USNationals2010 	magic 	1 	166 	191 	Bob Burton 		John Rhodes
JakartaCeriaOpen2010 	333 	1 	1430 	1619 	Muhammad Rifqi Agrizal 	Rifqi Aulia Zaki
Borneo2010 		333oh 	f 	2743 	3339 	Ahmad Leo Yudanto 	Aldino Mangawing

USNationals2010 had two unbroken ties in the first round of magic. There was a third person (Kegham) with a 1.50 average, but a 1.38 best. Also, in the finals, I made the podium over Mitchell Stern by winning a tie.

Speaking of 3-way ties, there have been 27 of them. 3 of them were in the magic finals at WC2009. I don't really feel like posting the whole list. If anyone wants to see it I can though.
 
Tim Reynolds said:
Stefan's stats are talking about "winning ties" and "losing ties".
Click to expand...

Not quite, only about losing ties and overall ties (I was too lazy to distinguish between winning and full ties).

Tim Reynolds said:
Speaking of 3-way ties, there have been 27 of them. 3 of them were in the magic finals at WC2009. I don't really feel like posting the whole list. If anyone wants to see it I can though.
Click to expand...

Not nearly as nice as yours, but I posted a list here:
http://www.speedsolving.com/forum/showthread.php?26121-Odd-WCA-stats&p=589044&viewfull=1#post589044
 
Tim Major said:
Stefan, how did you go about finding the losing ties. Me and Chris Wilkinson both had 14.50 averages, his single was better, but I was ranked higher because the WCA spreadsheet goes to 3 decimals. http://www.worldcubeassociation.org...Results&competitionId=MelbourneSummer2011#333
Click to expand...

That's a mistake:

wca regulations said:
9f1) All timed results under 10 minutes, and corresponding averages/means are measured in hundredths of a second, with averages/means rounded to the nearest hundredth of a second (x.004 becomes x.00, x.005 becomes x.01)
Click to expand...

The WCA spreadsheet should probably be updated to round to 2 decimals. In any case, thanks to Stefan we'll be fixing all the mistakes like that soon. Apparently there's quite a few...
 
There are three relevant values in the database: average, best and position. The position values contain mistakes, but I only used average and best for this.
 
Stefan and Tim, I think you didn't count ties when the format is "Best of x".
For example, at Montpellier Open 2011, the first place for FMC was tied at 28 because the two competitors DNF'd their second attempt. I think there must also have been ties in blind.
 
@uguste said:
Stefan and Tim, I think you didn't count ties when the format is "Best of x".
Click to expand...

Right, we only considered successful averages, sorry I didn't point that out (Tim did). But the original request was about that specific rule, average ties being broken by different bests. And DNF averages are rather boring and easy to match, that's why I only considered successful ones.
 
amostay2004 said:
Can I see the top 50 ranking for the fastest 3x3 BLD mean of 3 in comp? (Yeah I just wanna be high on at least ONE list =p)
Click to expand...
I can't do any coding like Stefan, I just looked at the people who I know have had good means.

Haiyan: 31.81, 30.94, 36.30 = 33.02
Alejandro: 48.68, 41.96, 45.09 = 45.24
Preeda: 50.88, 46.19, 42.84 = 46.64
Spef: 54.27, 46.94, 48.44 = 49.88
 
amostay2004 said:
Can I see the top 50 ranking for the fastest 3x3 BLD mean of 3 in comp? (Yeah I just wanna be high on at least ONE list =p)
Click to expand...

There are only 159 overall:
Code: 
  33.02  Haiyan Zhuang                         31.81    30.94    36.30
  45.24  Gabriel Alejandro Orozco Casillas     48.68    41.96    45.09
  46.64  Preeda Hongpimolmas                   50.88    46.19    42.84
  49.35  Yuhui Xu                              52.63    44.88    50.55
  49.88  Ville Seppänen                        54.27    46.94    48.44
  50.29  Amos Swee Hui Tay                     43.00    56.91    50.97
  56.67  Tomás Mansilla                        50.90  1:05.34    53.77
1:02.54  Chester Lian                        1:09.88    55.36  1:02.38
1:04.97  Yuxin Wang                          1:09.30  1:03.02  1:02.59
1:06.05  Alexander Yu                        1:12.08  1:00.62  1:05.46
1:06.93  Tomoki Kubo                         1:10.19  1:02.36  1:08.25
1:10.40  Kai Jiptner                         1:33.80  1:03.83    53.56
1:12.46  Muhammad Iril Khairul Anam          1:04.38  1:31.47  1:01.52
1:17.04  Bill Wang                           1:10.97  1:13.81  1:26.33
1:18.39  Rafal Guzewicz                      1:25.88  1:16.96  1:12.34
1:21.08  Danyang Chen                        1:23.94  1:06.75  1:32.55
1:23.60  Wu Chun Chung                       1:40.97  1:22.97  1:06.86
1:26.19  Tomasz Korzeniewski                 1:54.13  1:12.83  1:11.61
1:28.39  Luchen Zhang                        1:23.44  1:23.66  1:38.06
1:29.59  Chris Hardwick                      1:37.28  1:25.15  1:26.33
1:30.12  Mike Hughey                         1:15.36  1:19.68  1:55.31
1:30.66  Shelley Chang                       1:25.58  1:31.34  1:35.05
1:33.47  Baramee Pookcharoen                 1:51.27  1:23.58  1:25.56
1:33.65  Timothy Sun                         1:31.91  1:16.50  1:52.53
1:34.26  Reynaldo Mape Jr.                   1:19.72  1:50.93  1:32.13
1:35.74  Leyan Lo                            1:27.69  1:47.77  1:31.75
1:36.55  Lucas Garron                        1:41.61  1:29.81  1:38.22
1:38.43  Simon Bourigault                    1:48.44  1:35.41  1:31.44
1:39.92  Wicaksono Adi                       2:05.59  1:32.36  1:21.81
1:41.25  Ángel de Jaén Gotarredona           1:31.21  1:46.58  1:45.96
1:41.78  Tim Habermaas                       1:41.61  1:42.84  1:40.88
1:44.19  Daniel Sheppard                     1:26.27  1:26.33  2:19.97
1:45.18  Javier Vega Aramburu                1:37.59  1:51.93  1:46.03
1:48.65  Yuhei Takagi                        1:40.77  1:54.72  1:50.47
1:49.49  Andy Tsao                           1:38.56  1:34.97  2:14.93
1:51.59  Yunqi Ouyang                        1:59.50  1:48.96  1:46.30
1:53.24  Michal Robaczyk                     1:54.55  1:18.05  2:27.13
1:53.82  François Courtès                    2:07.52  1:33.93  2:00.00
1:55.07  Alexander Olleta del Molino         1:58.77  1:56.44  1:50.00
1:55.99  Tyson Mao                           1:41.47  1:41.56  2:24.94
1:56.22  Gunnar Krig                         1:50.13  2:05.58  1:52.94
1:56.64  Bence Barát                         2:01.25  2:10.02  1:38.66
1:57.61  Apichai Boonnuam                    1:43.72  2:14.06  1:55.06
1:58.91  Bastien Bonnet                      2:10.06  1:58.22  1:48.44
1:59.60  Fabrizio Cirnigliaro                1:58.36  2:00.41  2:00.02
2:00.97  Rowe Hessler                        2:34.66  1:54.82  1:33.43
2:01.78  Andrew Le                           2:10.44  1:55.03  1:59.86
2:03.96  Péter Trombitás                     1:56.18  2:28.30  1:47.41
2:04.45  Sébastien Auroux                    2:13.77  1:51.97  2:07.61
2:06.76  Dan Dzoan                           2:05.93  2:01.66  2:12.70
2:07.46  Marcell Endrey                      1:28.00  2:30.63  2:23.75
2:08.66  Victor Cullot                       2:17.30  1:57.03  2:11.65
2:08.74  Erik Akkersdijk                     1:51.05  2:22.44  2:12.73
2:12.50  Hong Zhang                          2:09.97  1:53.22  2:34.30
2:12.58  Dániel Varga                        2:03.77  2:37.41  1:56.55
2:13.28  Micael Boulet                       2:07.61  2:17.90  2:14.33
2:15.91  István Kocza                        2:29.59  2:06.75  2:11.40
2:17.85  Anthony McKnight                    1:56.56  2:44.53  2:12.46
2:20.45  Arvid Skarrie                       2:25.40  2:47.28  1:48.68
2:22.20  Riadi Arsandi                       2:09.15  1:58.40  2:59.06
2:23.20  Dennis Strehlau                     2:07.52  1:53.09  3:09.00
2:23.28  Jules Desjardin                     2:45.09  2:29.83  1:54.91
2:24.34  Henrik Buus Aagaard                 2:04.84  2:43.58  2:24.61
2:24.94  Weston Mizumoto                     1:59.69  2:24.61  2:50.52
2:28.59  Rui Yang                            2:34.18  1:58.93  2:52.65
2:28.85  Peng Cao                            2:53.86  2:38.77  1:53.93
2:29.45  Hui Hing Ho                         2:30.15  2:30.33  2:27.86
2:30.16  Xuan Pei                            2:26.18  2:21.44  2:42.86
2:31.04  Yuji Suse                           2:28.63  3:03.91  2:00.59
2:32.27  Peter Battaglino                    2:36.38  2:45.11  2:15.31
2:33.68  Clément Gallet                      2:27.02  2:11.16  3:02.86
2:35.70  Shotaro Makisumi                    2:34.05  2:40.16  2:32.88
2:35.74  Lee Chun Hin                        2:31.21  1:57.06  3:18.96
2:37.95  Nick Young                          2:38.72  2:23.46  2:51.66
2:39.74  Manuel López Sheriff                3:11.33  2:39.61  2:08.27
2:41.71  Daniel Lo                           2:43.91  2:51.70  2:29.52
2:42.37  Justin Adsuara                      2:10.40  2:07.47  3:49.25
2:42.91  Tim Reynolds                        3:11.00  2:43.18  2:14.56
2:43.03  Fubo Wang                           2:26.78  2:58.11  2:44.21
2:43.98  Yan Xuan                            3:05.08  3:12.53  1:54.34
2:46.83  Michael Young                       2:24.96  3:23.34  2:32.19
2:46.87  David Woner                         2:17.72  3:11.22  2:51.68
2:47.45  Karthik Puthraya                    3:48.68  2:14.14  2:19.52
2:49.04  Jan Bentlage                        2:57.30  3:02.41  2:27.41
2:51.15  Chan Chun Hang                      2:49.59  3:10.93  2:32.94
2:51.55  Shaden Smith                        2:43.94  2:55.90  2:54.81
2:52.07  Muhammad Rehan                      3:21.58  2:17.93  2:56.71
2:53.05  Craig Bouchard                      2:29.87  3:05.35  3:03.93
2:53.89  Bernett Orlando                     2:56.97  3:02.05  2:42.65
2:54.27  Anton Rostovikov                    3:23.69  2:35.30  2:43.81
2:56.02  Jonathan Papa                       2:47.56  2:15.27  3:45.22
2:57.70  Ade Agus                            3:05.61  2:38.22  3:09.27
3:00.12  Gerardo Villa López                 3:37.47  2:42.36  2:40.52
3:01.34  Rizky Aditya Ramadhan               2:53.52  2:54.96  3:15.55
3:01.60  Aulia Ismail Adhiim                 3:31.30  3:01.25  2:32.25
3:03.16  Park Byung-Hwa                      3:23.16  2:55.00  2:51.31
3:04.35  Immawan Mujahid Maruddani           2:51.21  3:14.78  3:07.06
3:05.62  Ivan Smirnov                        3:27.52  2:37.80  3:11.53
3:12.53  Michael                             3:20.44  3:42.66  2:34.50
3:20.37  Péter Róka                          3:43.80  2:03.15  4:14.16
3:22.52  Brendan Blackwell                   3:14.69  3:33.40  3:19.46
3:24.24  Michael Avelino Britto              3:49.44  3:17.19  3:06.09
3:27.13  Michelle Nataniel Yugie             3:29.61  3:35.56  3:16.22
3:30.60  Takuma Shirahase                    2:56.11  3:07.11  4:28.59
3:31.65  Adam Rotal Yuliandaru               2:39.71  4:34.08  3:21.15
3:32.69  Anthony Hsu                         3:07.53  4:26.22  3:04.31
3:34.68  Tomoaki Okayama                     3:34.44  2:50.97  4:18.63
3:35.61  Eric Limeback                       4:28.41  3:33.34  2:45.09
3:36.28  Kim Seung-Hoon                      3:58.50  3:37.00  3:13.33
3:37.46  Piotr Frankowski                    3:52.28  2:53.02  4:07.09
3:37.73  Stefan Pochmann                     3:01.58  3:24.05  4:27.56
3:39.69  Brian Kim                           3:09.61  3:47.46  4:02.00
3:40.16  Dwi Aji Kurniawan                   3:34.27  3:57.91  3:28.31
3:40.59  Bill Li                             3:50.65  3:37.59  3:33.53
3:42.19  Julianne Hormann                    4:11.71  3:32.55  3:22.31
3:49.13  Adam Zamora                         3:03.83  5:03.09  3:20.47
3:50.12  Gabriel Bucsan                      3:55.41  3:45.56  3:49.40
3:52.34  Ian Winokur                         3:45.84  3:34.94  4:16.25
3:56.63  Radityo Yunus Utomo Wicaksono       3:40.65  4:24.65  3:44.58
4:00.21  Javier Espinosa García              4:32.46  3:48.34  3:39.84
4:02.21  Loïc Petit                          4:44.34  3:38.19  3:44.09
4:02.46  Agung Fathony                       4:42.78  4:01.40  3:23.21
4:02.80  Nicola Giordani                     4:11.21  4:29.50  3:27.68
4:09.58  Mateusz Burnicki                    4:01.69  4:16.43  4:10.63
4:10.86  Alejandro Aguado Barahona           4:11.28  3:51.21  4:30.08
4:11.15  Paolo Girotti                       3:48.77  3:58.59  4:46.08
4:12.56  Shenjia Zhang                       4:23.30  4:48.46  3:25.93
4:14.18  Witold Kozak                        4:19.94  4:26.50  3:56.09
4:14.35  Bob Burton                          4:02.78  4:23.75  4:16.53
4:14.51  Guanyang Yu                         4:16.15  3:59.34  4:28.03
4:14.58  Fernando Daniel Hernández Sánchez   4:26.52  4:47.63  3:29.58
4:27.57  Jared Phelps                        4:16.02  4:19.30  4:47.40
4:30.28  Isaac Wappes                        3:35.06  3:46.88  6:08.90
4:34.54  Guanghua Wang                       4:25.06  4:42.78  4:35.77
4:38.80  Niklas Bitén                        5:02.15  5:13.38  3:40.88
4:40.63  Arief Widodo                        4:53.30  5:05.94  4:02.65
4:43.62  Arnaud van Galen                    4:00.56  5:24.40  4:45.91
4:51.86  Prashant Swarnkar                   6:00.68  4:21.84  4:13.06
4:54.61  Yosua Adriadi                       4:31.22  4:27.93  5:44.68
4:55.00  Eivind Fonn                         4:51.63  5:04.69  4:48.69
5:03.31  Alan Chang                          5:02.34  5:32.08  4:35.52
5:06.69  Thom Barlow                         5:53.88  5:24.00  4:02.18
5:12.46  Álvaro González Lasseube            5:34.56  3:54.41  6:08.40
5:13.67  Steven Turner                       5:02.03  4:12.11  6:26.86
5:16.54  Vincent Le                          4:32.72  6:09.70  5:07.20
5:21.33  Mario Laurent                       3:55.05  6:06.09  6:02.84
5:25.37  Cristobal Villa Rojas               4:58.86  6:14.61  5:02.65
5:41.44  Tomasz Zolnowski                    5:04.00  4:11.80  7:48.52
5:48.53  Chao Liu 2                          6:53.09  4:50.41  5:42.08
5:58.10  Mickaël Kourganoff                  6:22.21  6:06.09  5:26.00
6:05.21  Brillian Prajudistisia              4:46.50  5:03.68  8:25.44
6:08.06  Emile Compion                       7:55.68  5:50.80  4:37.69
6:17.04  Fumiki Koseki                       7:34.47  6:39.66  4:37.00
6:34.71  I-Fan Wu                            7:47.86  7:48.36  4:07.91
6:54.43  Harry Richman                       4:44.55  9:01.43  6:57.30
7:03.62  Peter Greenwood                     7:00.63  5:58.33  8:11.90
7:13.18  Bruce Norskog                       7:40.38  7:03.59  6:55.56
7:18.28  Max Novicov                         7:21.65  7:32.86  7:00.33
9:04.95  Dhanayush Raninga                   9:07.86  8:25.08  9:41.90
 
Stefan said:
There are only 159 overall:
Code: 
  33.02  Haiyan Zhuang                         31.81    30.94    36.30
  45.24  Gabriel Alejandro Orozco Casillas     48.68    41.96    45.09
  46.64  Preeda Hongpimolmas                   50.88    46.19    42.84
  49.35  Yuhui Xu                              52.63    44.88    50.55
  49.88  Ville Seppänen                        54.27    46.94    48.44
  50.29  Amos Swee Hui Tay                     43.00    56.91    50.97
  56.67  Tomás Mansilla                        50.90  1:05.34    53.77
1:02.54  Chester Lian                        1:09.88    55.36  1:02.38
1:04.97  Yuxin Wang                          1:09.30  1:03.02  1:02.59
1:06.05  Alexander Yu                        1:12.08  1:00.62  1:05.46
1:06.93  Tomoki Kubo                         1:10.19  1:02.36  1:08.25
1:10.40  Kai Jiptner                         1:33.80  1:03.83    53.56
1:12.46  Muhammad Iril Khairul Anam          1:04.38  1:31.47  1:01.52
1:17.04  Bill Wang                           1:10.97  1:13.81  1:26.33
1:18.39  Rafal Guzewicz                      1:25.88  1:16.96  1:12.34
1:21.08  Danyang Chen                        1:23.94  1:06.75  1:32.55
1:23.60  Wu Chun Chung                       1:40.97  1:22.97  1:06.86
1:26.19  Tomasz Korzeniewski                 1:54.13  1:12.83  1:11.61
1:28.39  Luchen Zhang                        1:23.44  1:23.66  1:38.06
1:29.59  Chris Hardwick                      1:37.28  1:25.15  1:26.33
1:30.12  Mike Hughey                         1:15.36  1:19.68  1:55.31
1:30.66  Shelley Chang                       1:25.58  1:31.34  1:35.05
1:33.47  Baramee Pookcharoen                 1:51.27  1:23.58  1:25.56
1:33.65  Timothy Sun                         1:31.91  1:16.50  1:52.53
1:34.26  Reynaldo Mape Jr.                   1:19.72  1:50.93  1:32.13
1:35.74  Leyan Lo                            1:27.69  1:47.77  1:31.75
1:36.55  Lucas Garron                        1:41.61  1:29.81  1:38.22
1:38.43  Simon Bourigault                    1:48.44  1:35.41  1:31.44
1:39.92  Wicaksono Adi                       2:05.59  1:32.36  1:21.81
1:41.25  Ángel de Jaén Gotarredona           1:31.21  1:46.58  1:45.96
1:41.78  Tim Habermaas                       1:41.61  1:42.84  1:40.88
1:44.19  Daniel Sheppard                     1:26.27  1:26.33  2:19.97
1:45.18  Javier Vega Aramburu                1:37.59  1:51.93  1:46.03
1:48.65  Yuhei Takagi                        1:40.77  1:54.72  1:50.47
1:49.49  Andy Tsao                           1:38.56  1:34.97  2:14.93
1:51.59  Yunqi Ouyang                        1:59.50  1:48.96  1:46.30
1:53.24  Michal Robaczyk                     1:54.55  1:18.05  2:27.13
1:53.82  François Courtès                    2:07.52  1:33.93  2:00.00
1:55.07  Alexander Olleta del Molino         1:58.77  1:56.44  1:50.00
1:55.99  Tyson Mao                           1:41.47  1:41.56  2:24.94
1:56.22  Gunnar Krig                         1:50.13  2:05.58  1:52.94
1:56.64  Bence Barát                         2:01.25  2:10.02  1:38.66
1:57.61  Apichai Boonnuam                    1:43.72  2:14.06  1:55.06
1:58.91  Bastien Bonnet                      2:10.06  1:58.22  1:48.44
1:59.60  Fabrizio Cirnigliaro                1:58.36  2:00.41  2:00.02
2:00.97  Rowe Hessler                        2:34.66  1:54.82  1:33.43
2:01.78  Andrew Le                           2:10.44  1:55.03  1:59.86
2:03.96  Péter Trombitás                     1:56.18  2:28.30  1:47.41
2:04.45  Sébastien Auroux                    2:13.77  1:51.97  2:07.61
2:06.76  Dan Dzoan                           2:05.93  2:01.66  2:12.70
2:07.46  Marcell Endrey                      1:28.00  2:30.63  2:23.75
2:08.66  Victor Cullot                       2:17.30  1:57.03  2:11.65
2:08.74  Erik Akkersdijk                     1:51.05  2:22.44  2:12.73
2:12.50  Hong Zhang                          2:09.97  1:53.22  2:34.30
2:12.58  Dániel Varga                        2:03.77  2:37.41  1:56.55
2:13.28  Micael Boulet                       2:07.61  2:17.90  2:14.33
2:15.91  István Kocza                        2:29.59  2:06.75  2:11.40
2:17.85  Anthony McKnight                    1:56.56  2:44.53  2:12.46
2:20.45  Arvid Skarrie                       2:25.40  2:47.28  1:48.68
2:22.20  Riadi Arsandi                       2:09.15  1:58.40  2:59.06
2:23.20  Dennis Strehlau                     2:07.52  1:53.09  3:09.00
2:23.28  Jules Desjardin                     2:45.09  2:29.83  1:54.91
2:24.34  Henrik Buus Aagaard                 2:04.84  2:43.58  2:24.61
2:24.94  Weston Mizumoto                     1:59.69  2:24.61  2:50.52
2:28.59  Rui Yang                            2:34.18  1:58.93  2:52.65
2:28.85  Peng Cao                            2:53.86  2:38.77  1:53.93
2:29.45  Hui Hing Ho                         2:30.15  2:30.33  2:27.86
2:30.16  Xuan Pei                            2:26.18  2:21.44  2:42.86
2:31.04  Yuji Suse                           2:28.63  3:03.91  2:00.59
2:32.27  Peter Battaglino                    2:36.38  2:45.11  2:15.31
2:33.68  Clément Gallet                      2:27.02  2:11.16  3:02.86
2:35.70  Shotaro Makisumi                    2:34.05  2:40.16  2:32.88
2:35.74  Lee Chun Hin                        2:31.21  1:57.06  3:18.96
2:37.95  Nick Young                          2:38.72  2:23.46  2:51.66
2:39.74  Manuel López Sheriff                3:11.33  2:39.61  2:08.27
2:41.71  Daniel Lo                           2:43.91  2:51.70  2:29.52
2:42.37  Justin Adsuara                      2:10.40  2:07.47  3:49.25
2:42.91  Tim Reynolds                        3:11.00  2:43.18  2:14.56
2:43.03  Fubo Wang                           2:26.78  2:58.11  2:44.21
2:43.98  Yan Xuan                            3:05.08  3:12.53  1:54.34
2:46.83  Michael Young                       2:24.96  3:23.34  2:32.19
2:46.87  David Woner                         2:17.72  3:11.22  2:51.68
2:47.45  Karthik Puthraya                    3:48.68  2:14.14  2:19.52
2:49.04  Jan Bentlage                        2:57.30  3:02.41  2:27.41
2:51.15  Chan Chun Hang                      2:49.59  3:10.93  2:32.94
2:51.55  Shaden Smith                        2:43.94  2:55.90  2:54.81
2:52.07  Muhammad Rehan                      3:21.58  2:17.93  2:56.71
2:53.05  Craig Bouchard                      2:29.87  3:05.35  3:03.93
2:53.89  Bernett Orlando                     2:56.97  3:02.05  2:42.65
2:54.27  Anton Rostovikov                    3:23.69  2:35.30  2:43.81
2:56.02  Jonathan Papa                       2:47.56  2:15.27  3:45.22
2:57.70  Ade Agus                            3:05.61  2:38.22  3:09.27
3:00.12  Gerardo Villa López                 3:37.47  2:42.36  2:40.52
3:01.34  Rizky Aditya Ramadhan               2:53.52  2:54.96  3:15.55
3:01.60  Aulia Ismail Adhiim                 3:31.30  3:01.25  2:32.25
3:03.16  Park Byung-Hwa                      3:23.16  2:55.00  2:51.31
3:04.35  Immawan Mujahid Maruddani           2:51.21  3:14.78  3:07.06
3:05.62  Ivan Smirnov                        3:27.52  2:37.80  3:11.53
3:12.53  Michael                             3:20.44  3:42.66  2:34.50
3:20.37  Péter Róka                          3:43.80  2:03.15  4:14.16
3:22.52  Brendan Blackwell                   3:14.69  3:33.40  3:19.46
3:24.24  Michael Avelino Britto              3:49.44  3:17.19  3:06.09
3:27.13  Michelle Nataniel Yugie             3:29.61  3:35.56  3:16.22
3:30.60  Takuma Shirahase                    2:56.11  3:07.11  4:28.59
3:31.65  Adam Rotal Yuliandaru               2:39.71  4:34.08  3:21.15
3:32.69  Anthony Hsu                         3:07.53  4:26.22  3:04.31
3:34.68  Tomoaki Okayama                     3:34.44  2:50.97  4:18.63
3:35.61  Eric Limeback                       4:28.41  3:33.34  2:45.09
3:36.28  Kim Seung-Hoon                      3:58.50  3:37.00  3:13.33
3:37.46  Piotr Frankowski                    3:52.28  2:53.02  4:07.09
3:37.73  Stefan Pochmann                     3:01.58  3:24.05  4:27.56
3:39.69  Brian Kim                           3:09.61  3:47.46  4:02.00
3:40.16  Dwi Aji Kurniawan                   3:34.27  3:57.91  3:28.31
3:40.59  Bill Li                             3:50.65  3:37.59  3:33.53
3:42.19  Julianne Hormann                    4:11.71  3:32.55  3:22.31
3:49.13  Adam Zamora                         3:03.83  5:03.09  3:20.47
3:50.12  Gabriel Bucsan                      3:55.41  3:45.56  3:49.40
3:52.34  Ian Winokur                         3:45.84  3:34.94  4:16.25
3:56.63  Radityo Yunus Utomo Wicaksono       3:40.65  4:24.65  3:44.58
4:00.21  Javier Espinosa García              4:32.46  3:48.34  3:39.84
4:02.21  Loïc Petit                          4:44.34  3:38.19  3:44.09
4:02.46  Agung Fathony                       4:42.78  4:01.40  3:23.21
4:02.80  Nicola Giordani                     4:11.21  4:29.50  3:27.68
4:09.58  Mateusz Burnicki                    4:01.69  4:16.43  4:10.63
4:10.86  Alejandro Aguado Barahona           4:11.28  3:51.21  4:30.08
4:11.15  Paolo Girotti                       3:48.77  3:58.59  4:46.08
4:12.56  Shenjia Zhang                       4:23.30  4:48.46  3:25.93
4:14.18  Witold Kozak                        4:19.94  4:26.50  3:56.09
4:14.35  Bob Burton                          4:02.78  4:23.75  4:16.53
4:14.51  Guanyang Yu                         4:16.15  3:59.34  4:28.03
4:14.58  Fernando Daniel Hernández Sánchez   4:26.52  4:47.63  3:29.58
4:27.57  Jared Phelps                        4:16.02  4:19.30  4:47.40
4:30.28  Isaac Wappes                        3:35.06  3:46.88  6:08.90
4:34.54  Guanghua Wang                       4:25.06  4:42.78  4:35.77
4:38.80  Niklas Bitén                        5:02.15  5:13.38  3:40.88
4:40.63  Arief Widodo                        4:53.30  5:05.94  4:02.65
4:43.62  Arnaud van Galen                    4:00.56  5:24.40  4:45.91
4:51.86  Prashant Swarnkar                   6:00.68  4:21.84  4:13.06
4:54.61  Yosua Adriadi                       4:31.22  4:27.93  5:44.68
4:55.00  Eivind Fonn                         4:51.63  5:04.69  4:48.69
5:03.31  Alan Chang                          5:02.34  5:32.08  4:35.52
5:06.69  Thom Barlow                         5:53.88  5:24.00  4:02.18
5:12.46  Álvaro González Lasseube            5:34.56  3:54.41  6:08.40
5:13.67  Steven Turner                       5:02.03  4:12.11  6:26.86
5:16.54  Vincent Le                          4:32.72  6:09.70  5:07.20
5:21.33  Mario Laurent                       3:55.05  6:06.09  6:02.84
5:25.37  Cristobal Villa Rojas               4:58.86  6:14.61  5:02.65
5:41.44  Tomasz Zolnowski                    5:04.00  4:11.80  7:48.52
5:48.53  Chao Liu 2                          6:53.09  4:50.41  5:42.08
5:58.10  Mickaël Kourganoff                  6:22.21  6:06.09  5:26.00
6:05.21  Brillian Prajudistisia              4:46.50  5:03.68  8:25.44
6:08.06  Emile Compion                       7:55.68  5:50.80  4:37.69
6:17.04  Fumiki Koseki                       7:34.47  6:39.66  4:37.00
6:34.71  I-Fan Wu                            7:47.86  7:48.36  4:07.91
6:54.43  Harry Richman                       4:44.55  9:01.43  6:57.30
7:03.62  Peter Greenwood                     7:00.63  5:58.33  8:11.90
7:13.18  Bruce Norskog                       7:40.38  7:03.59  6:55.56
7:18.28  Max Novicov                         7:21.65  7:32.86  7:00.33
9:04.95  Dhanayush Raninga                   9:07.86  8:25.08  9:41.90
Click to expand...

Argh..could've sub-Ville if I didn't +2 my last solve :P
 
Shouldn't have surprised me, but Mathematica actually makes a rather nice interface for MySQL. I'm sure Mathematica can make some nice plots showing relationships in the data, but I haven't tried this yet. I'd be curious to see what someone really familiar with Mathematica can get it to do (any ideas, Lucas?).
competition_sizes.png

Code: 
data = SQLExecute[conn, "
    SELECT c.year, c.month, c.day, COUNT(personId) FROM (SELECT \
DISTINCT competitionId, personId FROM Results) as r LEFT JOIN (SELECT \
id, year, month, day, countryId FROM Competitions) as c ON \
r.competitionId=c.id GROUP BY competitionId 
   "];
USAdata = SQLExecute[conn, "
    SELECT c.year, c.month, c.day, COUNT(personId) FROM (SELECT \
DISTINCT competitionId, personId FROM Results) as r LEFT JOIN (SELECT \
id, year, month, day, countryId FROM Competitions) as c ON \
r.competitionId=c.id  WHERE c.countryId='USA' GROUP BY competitionId 
   "];

TickFn[min_, max_] := 
  Table[{x, DateString[x, {"Month", "/", "Year"}]}, {x, min, 
    max, (max - min)/8}];
NTickFn[min_, max_] := 
  Table[{x, Round[-x]}, {x, min, max, (max - min)/8}];
Export["compsizes.png", GraphicsGrid[{{
    DateListPlot[
     Map[{{#[[1]], #[[2]], #[[3]]}, #[[4]]} &, {data, USAdata}, {2}], 
     PlotRange -> {{{2003, 5, 1}, {2011, 8, 1}}, All}, Axes -> True, 
     Frame -> False, AxesLabel -> {"Date", "# Competitors"}, 
     PlotStyle -> {{PointSize[0.004], Blue}, {PointSize[0.007], Red}},
      ImageSize -> 600],
    Show[
     Histogram[{data[[1 ;;, 4]], USAdata[[1 ;;, 4]]}, 
      AxesLabel -> {"# Competitions (in Bin)", "# Persons"}, 
      ImageSize -> 600, BarOrigin -> Left, ChartStyle -> {Blue, Red}]
     ]
    }, {
    Histogram[{Flatten[
       Table[ConstantArray[AbsoluteTime[data[[i]][[1 ;; 3]]], 
         data[[i]][[4]]], {i, Length[data]}]], 
      Flatten[Table[
        ConstantArray[AbsoluteTime[USAdata[[i]][[1 ;; 3]]], 
         USAdata[[i]][[4]]], {i, Length[USAdata]}]]}, {.7*10^7}, 
     BarOrigin -> Top, Axes -> True, 
     AxesOrigin -> AbsoluteTime[{2011, 8, 1}], 
     ChartStyle -> {Blue, Red}, ImageSize -> 600, 
     PlotRange -> {{AbsoluteTime[{2003, 5, 1}], 
        AbsoluteTime[{2011, 8, 1}]}, All}, 
     AxesLabel -> {"Date", "# Competitors (in Bin)"}, 
     Ticks -> {TickFn, NTickFn}],
    Graphics[{{Red, 
       Style[Text["USA Data", {0, .1}], FontSize -> 20]}, {Blue, 
       Style[Text["World Data", {0, -.1}], FontSize -> 20]}}]
    }}]]
 
Last edited:
You must log in or register to reply here.

Similar threads

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