# Odd WCA stats/ Stats request Thread

#### yoinneroid

##### Member
yay 15th for singles and 7th for average in Dan's stats
and yay again for being part in 3 best pyra podiums (Kediri Open 2013, Jakarta Speedcubing 2013, Singapore Open 2013) despite pyra not being my main event XD. Notice how Riadi is part of that those competitions too

#### ThomasJE

 CompetitionID Best Solve Mean of 3 Podium Averages KediriOpen2013 2.50 3.83 CubeFactory2013 2.54 3.83 WC2013 2.61 3.89 Euro2012 2.47 4.09 JakartaSpeedcubing2013 2.86 4.11 ChojniceOpen2013 3.31 4.46 Brasileiro2013 2.81 4.46 SingaporeOpen2013 3.43 4.50 PolishOpen2013 3.87 4.53 SwierklanyOpen2011 3.51 4.54
You didn't need to calculate the mean; you only needed the totals.

Are the totals different for Kediri Open 2013 and Cube Factory 2013?

#### yoinneroid

##### Member
You didn't need to calculate the mean; you only needed the totals.

Are the totals different for Kediri Open 2013 and Cube Factory 2013?
Drew requested mean, so he did it like that.
and, they are the same

#### cubizh

##### Super Moderator
Staff member
You didn't need to calculate the mean; you only needed the totals.

Are the totals different for Kediri Open 2013 and Cube Factory 2013?
It's the same thing, only divided by three. I used the best solve of all three podiums as tie breaker.

#### TheNextFeliks

##### Member
What is the best 3x3 Mean of 5? Is it Faz's WR?

#### kcl

##### Member
What is the best 3x3 Mean of 5? Is it Faz's WR?
I'm pretty positive it's the 7.49, because to my knowledge it's the only average to ever have all sub 8 times.

#### TheDubDubJr

##### Cupcake
What is the best 3x3 Mean of 5? Is it Faz's WR?
 Position Person CompetitionID Solve 1 Solve 2 Solve 3 Solve 4 Solve 5 Mean of 5 1 Feliks Zemdegs AustralianNationals2013 7.59 7.71 7.68 7.21 6.18 7.27 2 Feliks Zemdegs MelbourneWinterOpen2011 7.03 8.11 8.36 5.66 7.78 7.39 3 Mats Valk DutchOpen2012 8.18 6.27 7.50 7.72 7.77 7.49 4 Alexander Lau CambridgeOpen2013 7.97 8.27 7.86 6.34 7.22 7.53 5 Feliks Zemdegs MelbourneCubeDay2012 9.15 8.11 7.02 6.11 7.80 7.64 6 Feliks Zemdegs MelbourneCubeDay2012 7.81 7.03 7.86 6.31 9.97 7.80 7 Alexander Lau GuildfordOpen2013 7.83 8.28 7.39 6.57 8.92 7.80 8 Feliks Zemdegs WC2011 7.81 8.13 8.46 7.21 7.41 7.80 9 Feliks Zemdegs AustralianNationals2013 6.56 8.97 7.77 7.83 8.05 7.84 10 Feliks Zemdegs MelbourneSummer2011 8.56 7.31 8.22 7.31 8.09 7.90 11 Feliks Zemdegs CupcakeCubing2013 6.22 10.08 9.38 7.03 6.91 7.92 12 Feliks Zemdegs SheppartonWinter2013 8.11 7.80 7.63 7.96 8.15 7.93 13 Alexander Lau CuthbertsOpen2013 7.69 6.58 8.22 8.66 8.76 7.98 14 Mats Valk EindhovenSpring2013 8.34 7.44 8.69 6.84 8.88 8.04 15 Mats Valk EindhovenSpring2013 7.77 7.69 9.61 8.09 7.19 8.07 16 Alexander Lau CambridgeOpen2013 7.75 8.56 5.96 7.91 10.19 8.07 17 Feliks Zemdegs KubarooOpen2011 7.56 9.21 6.65 7.84 9.28 8.11 18 Alexander Lau CuthbertsOpen2013 6.98 6.83 9.04 8.39 9.41 8.13 19 Feliks Zemdegs AustralianNationals2012 7.56 6.78 7.16 11.44 7.86 8.16 20 Alexander Lau CambridgeOpen2013 7.91 8.53 8.97 9.02 6.47 8.18 21 Feliks Zemdegs WC2013 8.39 7.95 8.21 7.36 9.12 8.21 22 Cornelius Dieckmann MagicCubeDays2012 8.36 8.66 6.90 8.52 8.61 8.21 23 Feliks Zemdegs KubarooOpen2011 6.24 7.66 8.81 7.75 10.68 8.23 24 Feliks Zemdegs WC2011 8.61 7.86 7.66 9.71 7.47 8.26 25 Feliks Zemdegs AustralianNationals2011 8.34 7.65 6.65 9.46 9.25 8.27 26 Feliks Zemdegs WC2013 7.84 9.52 8.72 9.43 5.88 8.28 27 Mats Valk NEMOAmsterdamOpen2012 9.33 7.25 8.21 7.53 9.19 8.30 28 Feliks Zemdegs AustralianNationals2011 8.28 7.30 8.08 9.71 8.44 8.36 29 Cornelius Dieckmann BerlinOpen2012 8.13 8.38 10.36 8.11 6.84 8.36 30 Mats Valk WC2013 8.30 7.00 9.63 7.41 9.52 8.37 31 Feliks Zemdegs MelbourneWinterOpen2011 6.88 9.91 6.18 9.61 9.31 8.38 32 Feliks Zemdegs AustralianNationals2012 9.05 8.69 9.53 7.11 7.55 8.39 33 Yumu Tabuchi KawasakiOpen2012 7.83 8.96 8.97 8.46 7.81 8.41 34 Alexander Lau GuildfordOpen2013 7.13 9.67 7.65 10.31 7.44 8.44 35 Feliks Zemdegs MelbourneSummer2011 6.65 11.38 7.68 7.55 8.96 8.44 36 Mats Valk 1AVG2013 7.78 9.90 7.34 7.84 9.36 8.44 37 Cornelius Dieckmann GermanNationals2011 9.53 8.91 8.77 7.15 7.88 8.45 38 Feliks Zemdegs SheppartonWinter2013 6.97 8.75 7.30 10.72 8.61 8.47 39 Cornelius Dieckmann HessenOpen2012 8.52 8.05 8.46 8.05 9.27 8.47 40 Vincent Hartanto Utomo JakartaSpeedcubing2013 8.47 7.08 8.71 9.83 8.28 8.47 41 Mats Valk ZonhovenOpen2013 9.75 8.30 8.41 5.55 10.41 8.48 42 Mats Valk N8W8Summer2012 9.02 9.84 6.93 8.56 8.16 8.50 43 Michal Pleskowicz WC2011 8.94 7.68 8.41 8.72 8.83 8.52 44 Feliks Zemdegs MelbourneCubeDay2010 11.78 7.40 7.63 8.69 7.09 8.52 45 Asia Konvittayayotin ThailandChampionship2013 8.47 7.57 8.39 9.55 8.65 8.53 46 Mats Valk AmstelveenOpen2012 8.80 7.47 8.27 9.58 8.63 8.55 47 Mats Valk WC2013 8.81 9.52 7.61 7.31 9.76 8.60 48 Feliks Zemdegs MelbourneSummer2012 10.16 9.81 7.88 8.63 6.53 8.60 49 Feliks Zemdegs MelbourneCubeDay2011 7.81 6.55 8.71 11.63 8.41 8.62 50 Yu Nakajima KansaiOpen2013 9.18 7.43 8.15 9.40 9.03 8.64 51 Mats Valk ZonhovenOpen2012 6.44 9.65 8.83 9.75 8.66 8.67 52 Alexander Lau Leicester2013 6.85 7.73 9.72 10.80 8.25 8.67 53 Feliks Zemdegs AustralianNationals2011 8.58 7.90 10.44 8.68 7.77 8.67 54 Mats Valk EindhovenOpen2012 9.02 7.91 7.05 8.30 11.13 8.68 55 Thanaporn Sichanugrist AsianChampionship2012 10.09 7.33 8.26 8.84 8.92 8.69 56 Breandan Vallance EdinburghOpen2013 7.59 8.56 10.91 8.46 7.94 8.69 57 Morten Arborg Oslo2013 9.53 9.02 8.83 7.71 8.38 8.69 58 Giovanni Contardi RomaOpen2011 8.08 9.03 8.52 10.22 7.63 8.70 59 Sebastian Weyer VelbertOpen2013 8.52 8.22 10.47 8.69 7.59 8.70 60 Michal Pleskowicz Euro2012 8.59 9.09 8.22 8.91 8.71 8.70 61 Rowe Hessler BridgewaterOpen2011 7.36 11.36 8.43 8.55 7.83 8.71 62 Feliks Zemdegs WC2011 7.80 8.49 7.44 8.94 10.93 8.72 63 Piti Pichedpan ChonburiOpen2011 8.15 8.71 8.50 10.08 8.16 8.72 64 Richard Jay S. Apagar BerkeleySummer2013 8.02 10.00 8.55 8.53 8.69 8.76 65 Nipat Charoenpholphant Thailand2012 8.63 7.36 6.88 9.15 11.78 8.76 66 Alexander Lau EdinburghOpen2013 7.83 9.48 10.12 8.34 8.06 8.77 67 Sebastian Weyer WC2013 7.88 9.39 7.62 9.72 9.30 8.78 68 Giovanni Contardi ItalianChampionship2012 9.00 7.47 9.77 9.08 8.61 8.79 69 Michal Pleskowicz KociewieOpen2011 8.96 9.33 7.88 9.44 8.36 8.79 70 Sergey Ryabko KharkivCubeDay2013 9.28 9.19 8.58 6.88 10.06 8.80 71 Robert Yau BerkeleySummer2013 8.80 7.81 8.00 11.56 7.83 8.80 72 Feliks Zemdegs MelbourneCubeDay2012 8.72 8.47 10.27 9.40 7.21 8.81 73 Alexander Lau CuthbertsOpen2013 8.59 7.69 8.18 12.15 7.51 8.82 74 Michal Pleskowicz Euro2012 8.19 8.52 9.16 9.72 8.55 8.83 75 Anthony Brooks Hillsdale2013 8.13 9.16 8.03 8.61 10.22 8.83 76 Morten Arborg Norway2013 7.28 8.80 8.78 9.34 9.96 8.83 77 Cornelius Dieckmann HessenOpen2012 7.94 8.61 10.40 7.97 9.27 8.84 78 Mats Valk NEMOAmsterdamOpen2012 7.78 7.43 11.13 8.68 9.19 8.84 79 Breandan Vallance CanadianOpen2011 9.69 8.93 8.90 8.11 8.61 8.85 80 Piti Pichedpan Bangkok2012 9.27 8.80 7.43 9.38 9.43 8.86 81 Yumu Tabuchi RabbitAndTurtle2012 7.77 8.71 12.03 7.55 8.27 8.87 82 Cornelius Dieckmann BerkeleySummer2013 8.15 8.41 10.03 8.56 9.22 8.87 83 Haowei Fan GuangzhouCCSA2013 9.05 11.52 7.58 8.63 7.61 8.88 84 Rowe Hessler LibertyScience2012 8.69 8.81 7.63 8.36 10.91 8.88 85 Mats Valk WC2013 7.58 9.11 10.37 8.14 9.22 8.88 86 Feliks Zemdegs MelbourneWinterOpen2011 7.63 7.68 11.30 9.36 8.46 8.89 87 Nipat Charoenpholphant ShanghaiPortOpen2011 10.05 8.56 9.16 9.84 6.84 8.89 88 Mats Valk AmstelveenOpen2012 8.81 9.68 8.84 7.86 9.27 8.89 89 Michal Pleskowicz PolishNationals2012 8.84 8.03 9.03 9.02 9.61 8.91 90 Carlos Méndez GarcÍa*Barroso MIROpen2013 8.08 8.78 8.72 8.61 10.36 8.91 91 Feliks Zemdegs MelbourneCubeDay2010 10.36 8.43 8.80 7.03 9.97 8.92 92 Alexander Lau Leicester2013 6.91 9.34 7.38 11.88 9.09 8.92 93 Cornelius Dieckmann BerlinOpen2013 8.33 7.78 8.68 11.71 8.15 8.93 94 Nipat Charoenpholphant Thailand2012 7.80 9.15 11.68 8.27 7.75 8.93 95 Nipat Charoenpholphant HuaHinOpen2011 10.43 6.78 11.09 9.03 7.34 8.93 96 Paolo Moriello MilanWinterOpen2013 9.96 9.15 7.47 7.58 10.52 8.94 97 Cornelius Dieckmann GermanOpen2012 10.53 9.13 8.11 7.93 9.00 8.94 98 Kanneti Sae Han GaleriesLafayetteOpen2011 8.75 8.72 9.13 9.63 8.56 8.96 99 Cornelius Dieckmann MagicCubeDays2012 7.93 10.86 9.93 7.88 8.21 8.96 100 Mats Valk Euro2012 6.55 8.50 8.00 10.34 11.43 8.96

#### MatejMuzatko

##### Member
I have excel question.. I am making some stats for myself and have problems with encoding... All names with ěščřžýáíé show like some weird characters instead of it... how to deal with that?

#### kinch2002

I have excel question.. I am making some stats for myself and have problems with encoding... All names with ěščřžýáíé show like some weird characters instead of it... how to deal with that?
When you import the data, set it to Unicode (UTF-8)
I wrote a macro to replace the weird characters with real ones again, but then Cubizh advised me of the better solution above

#### cubizh

##### Super Moderator
Staff member
When you import the data, set it to Unicode (UTF-8)
Just some complementary information.
You can set it right in the first dialog box that appears when you open the .tsv file in Excel 2010, as follows (ignore the text, just see the location):

#### kinch2002

Yes this is what I meant. Bad explanation I guess

#### MatejMuzatko

##### Member
Just some complementary information.
You can set it right in the first dialog box that appears when you open the .tsv file in Excel 2010, as follows (ignore the text, just see the location):
Thank you!

#### cubizh

##### Super Moderator
Staff member
Here is a study made of the number of competitors per year by country. Each competitor is counted only once per year.

 Country 1982 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 USA 1 46 87 220 266 477 758 1006 1050 1115 1292 1341 China 0 0 1 1 1 107 320 919 1152 1125 1117 1253 India 0 0 0 1 3 2 92 178 240 412 403 859 Japan 1 3 1 83 169 134 178 161 209 205 282 199 Germany 1 1 7 18 28 40 64 179 322 334 343 220 Poland 1 2 4 36 63 75 138 152 162 194 250 474 Indonesia 0 0 0 0 1 1 1 76 425 583 251 147 Canada 1 17 0 7 8 73 122 164 241 247 246 309 France 1 2 33 33 48 60 135 155 134 223 314 224 Brazil 0 0 0 0 0 29 16 114 129 205 373 428 Spain 0 0 20 21 22 64 134 221 197 160 128 171 Taiwan 0 0 0 2 42 36 102 214 183 179 164 150 Philippines 0 0 0 0 0 26 213 122 75 93 99 132 Hungary 1 0 1 33 15 66 128 171 108 103 105 24 Korea 0 0 0 2 51 111 195 47 81 78 101 77 Italy 1 0 1 0 8 14 27 118 115 137 130 108 Russia 0 0 0 0 0 0 2 50 91 155 204 152 Sweden 1 4 15 32 35 40 59 120 78 87 78 92 Malaysia 0 0 0 0 0 1 1 151 171 111 107 45 Thailand 0 0 0 0 0 0 1 172 156 138 70 38 Netherlands 1 6 19 27 40 38 62 62 48 62 96 63 United Kingdom 1 2 5 3 9 25 41 66 60 77 98 105 Mexico 0 0 1 1 0 3 30 16 49 129 156 96 Iran 0 0 0 0 0 1 1 1 2 151 184 86 Chile 0 0 0 0 0 0 0 64 92 119 75 53 Vietnam 0 0 0 0 0 0 0 3 123 100 93 75 Ukraine 0 0 0 0 0 0 0 4 2 63 162 145 Colombia 0 0 0 0 0 0 1 1 4 63 161 123 Australia 0 1 1 2 2 4 3 5 57 86 97 76 Norway 0 0 2 3 2 1 17 31 57 51 86 70 Hong Kong 0 0 1 5 1 4 83 73 45 11 49 16 Peru 1 0 0 0 0 0 0 2 1 62 89 123 Denmark 0 1 0 0 2 3 18 30 69 59 43 42 Romania 0 0 0 0 1 1 1 4 47 32 78 70 Belgium 1 1 2 7 13 12 12 20 15 34 47 43 Finland 1 0 0 2 2 16 19 26 28 34 34 37 Austria 1 0 0 1 0 3 3 7 31 36 41 45 Singapore 0 0 0 0 0 0 0 67 26 20 21 34 Israel 0 1 1 1 1 1 1 2 71 76 1 3 New Zealand 0 0 0 0 0 0 0 27 55 26 21 3 Argentina 0 0 0 0 0 0 1 3 3 32 28 32 Slovenia 0 0 0 0 0 0 0 2 21 8 22 28 Mongolia 0 0 0 0 0 0 0 0 1 0 8 70 Serbia 1 0 0 0 0 1 2 3 3 0 20 47 Belarus 0 0 0 0 0 0 0 4 5 0 9 55 Switzerland 0 1 0 0 2 2 5 8 11 12 13 9 Czech Republic 1 1 1 4 8 9 4 6 2 5 6 9 Estonia 0 0 0 0 0 0 1 12 8 12 10 13 Turkey 0 0 0 0 0 0 1 2 4 5 5 38 Croatia 0 0 0 0 0 0 0 1 5 26 12 10 Portugal 1 0 0 0 1 1 11 16 1 3 1 3 Latvia 0 0 0 0 0 0 0 0 0 8 14 11 Slovakia 0 0 0 1 0 1 3 11 1 1 8 7 Venezuela 0 0 0 0 0 0 0 0 0 0 0 31 Greece 0 0 0 0 0 2 1 3 14 1 3 3 Ireland 0 0 0 0 0 1 0 3 3 3 8 7 Macau 0 0 0 0 0 1 3 10 1 3 3 2 Iceland 0 0 0 0 0 0 0 1 1 2 17 0 Lithuania 0 0 0 0 0 1 0 0 0 2 5 13 South Africa 0 0 0 0 0 3 1 1 2 3 2 2 Bulgaria 1 0 0 0 0 0 0 0 1 0 6 5 Jordan 0 0 0 0 0 0 0 1 0 0 7 1 Luxembourg 0 0 0 0 0 0 0 2 1 1 0 4 Aruba 0 1 0 0 0 0 0 0 0 2 3 1 Moldova 0 0 0 0 0 0 0 0 1 1 3 2 Nigeria 0 0 0 0 0 0 1 0 0 0 3 3 United Arab Emirates 0 0 0 0 0 0 0 5 0 0 0 2 Kazakhstan 0 0 0 0 0 0 0 1 0 1 2 2 Sri Lanka 0 0 0 0 0 1 1 0 0 0 1 3 El Salvador 0 0 0 0 0 1 3 0 1 0 0 0 Morocco 0 0 0 0 0 0 1 0 0 1 0 2 Puerto Rico 0 0 1 1 0 2 0 0 0 0 0 0 Bosnia and Herzegovina 0 0 0 0 0 0 0 0 0 0 1 2 Egypt 0 0 0 0 0 0 0 1 1 1 0 0 Georgia 0 0 0 0 0 0 0 0 0 0 0 3 Tunisia 0 0 0 0 0 0 0 1 0 0 1 1 Afghanistan 0 0 0 0 0 0 0 0 0 1 1 0 Armenia 0 0 0 0 0 0 0 0 0 0 1 1 Bangladesh 0 0 0 0 0 0 0 0 0 2 0 0 Belize 0 0 0 0 0 0 1 1 0 0 0 0 Cyprus 0 0 0 0 0 0 0 0 0 0 0 2 Dominican Republic 0 0 1 1 0 0 0 0 0 0 0 0 Lebanon 0 0 0 0 0 1 0 0 0 0 0 1 Macedonia 0 0 0 0 0 0 0 1 1 0 0 0 Mauritius 0 0 0 0 0 0 0 0 1 1 0 0 Pakistan 0 0 0 0 0 0 0 0 0 1 0 1 Albania 0 0 0 0 0 0 0 0 0 0 0 1 Algeria 0 0 0 0 0 0 0 0 0 1 0 0 Azerbaijan 0 0 0 0 0 1 0 0 0 0 0 0 Bolivia 0 0 0 0 0 0 0 1 0 0 0 0 Costa Rica 0 0 0 0 0 0 0 0 0 1 0 0 Cote d_Ivoire 0 0 0 0 0 1 0 0 0 0 0 0 Cuba 0 0 0 0 0 1 0 0 0 0 0 0 Saudi Arabia 0 0 0 0 0 0 0 1 0 0 0 0 Trinidad and Tobago 0 0 0 0 0 0 0 0 0 0 1 0

Ignoring 1982 because only one competitor per country participated.
These charts show the top 10 countries and all others are combined in one, except 2003 where there's not enough data.

#### Kit Clement

Discounting the WC1982 competition for obvious reasons.
I was amazed that I didn't make this list... turns out that I tied the two at the very bottom at 1253 and must have been cut off. 9-19-2009 to 2-23-2013.

#### cubizh

##### Super Moderator
Staff member
I was amazed that I didn't make this list... turns out that I tied the two at the very bottom at 1253 and must have been cut off. 9-19-2009 to 2-23-2013.
You missed that list by one day.
I counted the last day of the competition to the first day of the next, so 9-20-2009 (Canadian Open 2009) to 2-23-2013.
Same number of days as Mauro Caffarato Grandes (07-11-2009 -- 12-14-2012).