acohen527
Regular
Inspired by Noah's Fantasy Cubing 2014 I just had the idea of making a more simple and possibly more fair ranking, which also doesn't provide so much advantage by competing very often:
For each round you compete in you get +1 for everyone you beat or tie and -1 for everyone you get beaten by.
As the resulting ranking hasn't to do much with Noah's ranking I don't think that I'll spoil anything by posting it here.
Top 100 (2013):
Position personId personName personCountryId Comps score 1. 2007VALK01 Mats Valk Netherlands 8 16739 2. 2011ZALE02 Marcin Zalewski Poland 13 15359 3. 2008BARA01 Bence Barát Hungary 11 15143 4. 2009ZEMD01 Feliks Zemdegs Australia 5 14836 5. 2007HESS01 Rowe Hessler USA 14 13107 6. 2010CORM02 Louis Cormier Canada 8 12268 7. 2009PLES01 Michał Pleskowicz Poland 6 11838 8. 2010BREC01 John Brechon USA 12 11743 9. 2010CANT02 Antoine Cantin Canada 7 11588 10. 2012COST01 Kevin Costello III USA 13 11513 11. 2006HALC01 Michał Halczuk Poland 9 11121 12. 2008LINE02 Edward Lin USA 10 10964 13. 2009YAUR01 Robert Yau United Kingdom 8 10959 14. 2009BOZS01 Hunor Bózsing Hungary 11 10284 15. 2010KIPA01 Jakub Kipa Poland 6 9774 16. 2009DIEC01 Cornelius Dieckmann Germany 5 9713 17. 2010APAG01 Richard Jay S. Apagar Philippines 9 9582 18. 2012WOLN01 Jakub Wolniewicz Poland 11 9428 19. 2008WEST02 Simon Westlund Sweden 4 9267 20. 2012CHOS01 SeungBeom Cho (조승범) Korea 3 9235 21. 2007COHE01 Dan Cohen USA 7 9187 22. 2009ZHAN53 Weixing Zhang (张炜星) China 5 9156 23. 2009JUNY01 Howard Wong Jun Yen (黄俊仁) Malaysia 4 9148 24. 2010BENT01 Jan Bentlage Germany 17 9095 25. 2011SZAT01 Wojciech Szatanowski Poland 12 8963 26. 2007VALL01 Breandan Vallance United Kingdom 8 8839 27. 2012KALE01 Przemysław Kaleta Poland 9 8657 28. 2012MCNE01 Jayden McNeill Australia 6 8331 29. 2010WEYE02 Sebastian Weyer Germany 4 7889 30. 2010BRAD01 Drew Brads USA 4 7603 31. 2008AURO01 Sébastien Auroux Germany 21 7363 32. 2009OLSO01 Christopher Olson USA 7 7324 33. 2008CLAR01 Thompson Clarke Canada 6 7105 34. 2005AKKE01 Erik Akkersdijk Netherlands 10 6952 35. 2008JONG03 Jong-Ho Jeong (정종호) Korea 2 6869 36. 2005ZOLN01 Tomasz Żołnowski Poland 15 6860 37. 2008SAJI01 Yu Sajima (佐島優) Japan 9 6701 38. 2010MALL01 Justin Mallari USA 5 6616 39. 2011ETTE01 Lucas Etter USA 6 6581 40. 2011KUDA01 Nurym Kudaibergen Kazakhstan 4 6403 41. 2011NARA02 Bhargav Narasimhan India 9 6280 42. 2009LIUE01 Evan Liu USA 8 6213 43. 2009HAMO01 James Hamory USA 10 6113 44. 2010WANG07 Yinghao Wang (王鹰豪) China 9 6086 45. 2009SHEP01 Daniel Sheppard United Kingdom 10 5971 46. 2009HAYS01 Kevin Hays USA 2 5908 47. 2009KORB01 Björn Korbanka Germany 12 5880 48. 2007JAKU01 Marcin Jakubowski Poland 13 5830 49. 2011FYDR01 Mateusz Fydrych Poland 10 5788 50. 2010RICC02 Andrew Ricci USA 8 5492 51. 2007SUNT01 Timothy Sun USA 9 5472 52. 2011KNOT01 Wojciech Knott Poland 7 5446 53. 2009MORI05 Paolo Moriello Italy 9 5340 54. 2010BURN01 Collin Burns USA 6 5295 55. 2010TANE01 Gaurav Taneja India 9 5258 56. 2011REED01 Austin Reed USA 3 5253 57. 2008JAFF01 Justin Jaffray Canada 6 5135 58. 2007LIME01 Eric Limeback Canada 6 5008 59. 2010SCHM01 Leon Schmidtchen Germany 7 4947 60. 2009BARB01 Gabriel Dechichi Barbar Brazil 6 4875 61. 2008SEAR01 Anthony Brooks USA 8 4854 62. 2011ZVYA01 Dmitry Zvyagintsev Russia 7 4809 63. 2008ANDE02 Oscar Roth Andersen Denmark 9 4740 64. 2010WEYE01 Philipp Weyer Germany 4 4733 65. 2012SZEW01 Patryk Szewczyk Poland 8 4697 66. 2009SMIT03 Andy Smith USA 2 4603 67. 2010VYNN01 Ivan Vynnyk (Іван Винник) Ukraine 7 4591 68. 2008KARL02 Moritz Karl Germany 6 4561 69. 2013WOJT02 Jakub Wojtaszewski Poland 7 4498 70. 2011CHAN13 Swaminathan Chandrasekaran India 10 4460 71. 2011BILC01 Ihor Bilchenko (Ігор Більченко) Ukraine 8 4458 72. 2011SHAH01 Dharmesh Shahu India 5 4429 73. 2009RYAB01 Sergey Ryabko Russia 10 4371 74. 2011STAN02 Nick Stanton USA 5 4364 75. 2005KOZK01 Piotr Kózka Poland 5 4310 76. 2007WOOR01 Riley Woo USA 9 4301 77. 2011SOBR01 Alrimar Dias Rocha Sobrinho Brazil 6 4235 78. 2009BRZE01 Kalina Brzezińska Poland 13 4139 79. 2008MAND01 Nikhil Mande India 7 4137 80. 2011LIMA01 Allyson Dias de Lima Brazil 9 4110 81. 2009SMAR01 Jan Smarschevski Germany 6 4044 82. 2010GARC02 Carlos Méndez García-Barroso Spain 6 4022 83. 2011SOAR01 Israel Machado Soares Brazil 6 3990 84. 2012RUPE01 Akash Rupela India 6 3925 85. 2008LIKA01 Kailong Li (李开隆) China 4 3880 86. 2011FATE01 Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی) Iran 4 3846 87. 2011KIRU01 Kesava Kirupa India 4 3842 88. 2012KRIS04 Velidi Venkata Jagan Mohana Murali Krishna India 8 3722 89. 2011SELZ01 Dan Selzer USA 17 3654 90. 2010LANE02 Mitchell Lane USA 7 3634 91. 2010LEED02 Daniil Lee Russia 5 3555 92. 2011KOWA01 Marcin Kowalczyk Poland 13 3533 93. 2011VERS03 Georgy Vershinin Russia 6 3508 94. 2011MATA01 Jorge Castillo Matas Spain 6 3489 95. 2008MORE02 Hippolyte Moreau France 12 3446 96. 2010DAVI06 Julian David Canada 6 3439 97. 2010YUPH01 Phil Yu USA 6 3403 98. 2011STAC01 Marcin Stachura Poland 9 3379 99. 2011KUMA01 Akula Pavan Kumar India 8 3225 100. 2008ZERU01 Krzysztof Żerucha Poland 4 3223
Code:SELECT personId, personName, Results.personCountryId, COUNT(distinct Results.competitionId) AS Comps, SUM(peopleRound-(2*pos)+1) AS score FROM Results INNER JOIN (SELECT competitionId, eventId, COUNT(distinct personId) AS peopleRound FROM Results GROUP BY competitionId, eventId, roundId) tmp1 ON Results.competitionId=tmp1.competitionId AND Results.eventId=tmp1.eventId WHERE Results.competitionId IN (SELECT id FROM Competitions WHERE year="2013") GROUP BY personId ORDER BY score DESC LIMIT 100
Top 100 (all-time):
Position personId personName personCountryId Comps score 1. 2005AKKE01 Erik Akkersdijk Netherlands 100 64398 2. 2007VALK01 Mats Valk Netherlands 58 51916 3. 2007HESS01 Rowe Hessler USA 77 51255 4. 2008BARA01 Bence Barát Hungary 55 44615 5. 2009DIEC01 Cornelius Dieckmann Germany 30 36652 6. 2005BATI01 Milán Baticz Hungary 46 36452 7. 2007COHE01 Dan Cohen USA 59 36252 8. 2007VALL01 Breandan Vallance United Kingdom 47 35748 9. 2009PLES01 Michał Pleskowicz Poland 30 28993 10. 2009ZEMD01 Feliks Zemdegs Australia 21 25981 11. 2008WEST02 Simon Westlund Sweden 26 25899 12. 2008JAFF01 Justin Jaffray Canada 49 24839 13. 2010BREC01 John Brechon USA 39 23825 14. 2008LINE02 Edward Lin USA 46 23687 15. 2006HALC01 Michał Halczuk Poland 38 23276 16. 2005ZOLN01 Tomasz Żołnowski Poland 69 23142 17. 2007NAKA03 Yu Nakajima (中島悠) Japan 56 21912 18. 2011ZALE02 Marcin Zalewski Poland 27 21903 19. 2007SUNT01 Timothy Sun USA 39 21850 20. 2008AURO01 Sébastien Auroux Germany 102 21371 21. 2006TABU02 Yumu Tabuchi (田渕雄夢) Japan 32 21236 22. 2010CORM02 Louis Cormier Canada 20 20909 23. 2009YAUR01 Robert Yau United Kingdom 22 20740 24. 2005KOZK01 Piotr Kózka Poland 39 19959 25. 2009KORB01 Björn Korbanka Germany 41 19811 26. 2008CLAR01 Thompson Clarke Canada 29 19580 27. 2009HAYS01 Kevin Hays USA 18 17676 28. 2010WEYE02 Sebastian Weyer Germany 22 17350 29. 2008SAJI01 Yu Sajima (佐島優) Japan 42 17238 30. 2009MORI05 Paolo Moriello Italy 41 16966 31. 2008SMIT04 Maarten Smit Netherlands 28 16578 32. 2008HANK01 Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) Thailand 40 16540 33. 2008SEAR01 Anthony Searle Belize 37 16420 34. 2007OMUR01 Syuhei Omura (大村周平) Japan 45 16399 35. 2008VARG01 Dániel Varga Hungary 46 16206 36. 2007CHAN07 Harris Chan Canada 28 15908 37. 2007LIME01 Eric Limeback Canada 31 15769 38. 2008KARL02 Moritz Karl Germany 29 15702 39. 2009OLSO01 Christopher Olson USA 28 15542 40. 2009ZHAN53 Weixing Zhang (张炜星) China 25 15318 41. 2009JUNY01 Howard Wong Jun Yen (黄俊仁) Malaysia 21 15183 42. 2010KIPA01 Jakub Kipa Poland 14 15156 43. 2012COST01 Kevin Costello III USA 26 14655 44. 2009RYAB01 Sergey Ryabko Russia 27 14367 45. 2010APAG01 Richard Jay S. Apagar Philippines 23 14228 46. 2010CANT02 Antoine Cantin Canada 15 14058 47. 2010WEYE01 Philipp Weyer Germany 23 14019 48. 2010SCHM01 Leon Schmidtchen Germany 23 13930 49. 2005REYN01 Tim Reynolds USA 90 13750 50. 2009SMAR01 Jan Smarschevski Germany 25 13672 51. 2007ESPI01 Phillip Espinoza USA 38 13631 52. 2008LIKA01 Kailong Li (李开隆) China 25 13605 53. 2004CHAM01 Edouard Chambon France 43 13436 54. 2008JONG03 Jong-Ho Jeong (정종호) Korea 14 13183 55. 2006TSAO01 Andy Tsao USA 26 13007 56. 2009CHAR03 Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์) Thailand 22 12945 57. 2005FLEI01 Jeremy Fleischman USA 73 12835 58. 2010RICC02 Andrew Ricci USA 32 12609 59. 2009BARB01 Gabriel Dechichi Barbar Brazil 19 12450 60. 2009CONT01 Giovanni Contardi Italy 20 12320 61. 2010MALL01 Justin Mallari USA 24 12192 62. 2012KALE01 Przemysław Kaleta Poland 16 12139 63. 2009PICH01 Piti Pichedpan (ปิติ พิเชษฐพันธ์) Thailand 25 12027 64. 2004KRIG01 Gunnar Krig Sweden 51 11932 65. 2010VYNN01 Ivan Vynnyk (Іван Винник) Ukraine 18 11827 66. 2007GAMB01 Jai Gambhir Canada 24 11730 67. 2010WANG07 Yinghao Wang (王鹰豪) China 29 11665 68. 2007ADSU01 Justin Adsuara USA 35 11568 69. 2010GARC02 Carlos Méndez García-Barroso Spain 17 11550 70. 2009BOZS01 Hunor Bózsing Hungary 24 11472 71. 2004LOLE01 Leyan Lo USA 49 11218 72. 2006BUUS01 Henrik Buus Aagaard Denmark 54 11112 73. 2007HUBE01 Stefan Huber Austria 25 11083 74. 2007POLK01 Adam Polkowski Poland 39 10943 75. 2009SMIT03 Andy Smith USA 15 10830 76. 2006DZOA03 Dan Dzoan USA 51 10713 77. 2006GUNJ01 Mitsuki Gunji (郡司光貴) Japan 32 10390 78. 2010BENT01 Jan Bentlage Germany 55 10329 79. 2009SPRI01 Alexander Springhorn Germany 30 10180 80. 2009KORB02 Lasse Korbanka Germany 27 10175 81. 2008LINH01 Hao-Zheng Lin (林浩正) Taiwan 21 10066 82. 2008MIZU01 Weston Mizumoto USA 31 10050 83. 2009SHEP01 Daniel Sheppard United Kingdom 31 10012 84. 2007GOUL01 Joey Gouly United Kingdom 61 9843 85. 2007BODO01 Bertalan Bodor Hungary 27 9840 86. 2007GUIM01 Pedro Santos Guimarães Brazil 21 9833 87. 2012CHOS01 SeungBeom Cho Korea 5 9773 88. 2009POOK01 Baramee Pookcharoen (บารมี พุกเจริญ) Thailand 19 9713 89. 2006TEMM01 Rama Temmink Netherlands 49 9683 90. 2012MCNE01 Jayden McNeill Australia 12 9621 91. 2008ANDE02 Oscar Roth Andersen Denmark 44 9519 92. 2010YUPH01 Phil Yu USA 34 9473 93. 2007AGUA01 Alejandro Aguado Barahona Spain 29 9439 94. 2006OKAY01 Yohei Oka (岡要平) Japan 55 9275 95. 2009WANG15 Emily Wang Canada 18 8951 96. 2010EVDO01 Nikolay Evdokimov Russia 15 8855 97. 2006GARR01 Lucas Garron Germany 50 8829 98. 2007FUBO01 Fubo Wang (王富博) China 26 8788 99. 2009LIUE01 Evan Liu USA 30 8753 100. 2009HAMO01 James Hamory USA 24 8693
Code:SELECT personId, personName, Results.personCountryId, COUNT(distinct Results.competitionId) AS Comps, SUM(peopleRound-(2*pos)+1) AS score FROM Results INNER JOIN (SELECT competitionId, eventId, COUNT(distinct personId) AS peopleRound FROM Results GROUP BY competitionId, eventId, roundId) tmp1 ON Results.competitionId=tmp1.competitionId AND Results.eventId=tmp1.eventId GROUP BY personId ORDER BY score DESC LIMIT 100
Wow, I picked my team 2 days ago and my top 15 is incredibly to similar to that top 15... I got 12/15 right, and the 3 I got wrong are up and coming...
Edit: realized the rankings were done differently... Oh well hopefully the results will be similar to Noah's competition.
Last edited: