Odd WCA stats/ Stats request Thread

Discussion in 'General Speedcubing Discussion' started by anders, Dec 15, 2010.

Welcome to the Speedsolving.com. You are currently viewing our boards as a guest which gives you limited access to join discussions and access our other features. By joining our free community of over 30,000 people, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us and we'll help you get started. We look forward to seeing you on the forums!

Already a member? Login to stop seeing this message.
  1. ilikecubing

    ilikecubing Member

    826
    0
    Oct 28, 2010
    WCA:
    2011KULS01
    YouTube:
    musicfreak9312
    Stood 2nd in my previous comp,so not in this list anymore :D

    Request for list of top 10 ppl with biggest difference between their 4x4 single and average
     
    Last edited: Apr 14, 2012
  2. Flyt

    Flyt Member

    And shortest, please =)
     
  3. Bob

    Bob Premium Member

    1,426
    0
    Apr 23, 2006
    Kearny, NJ, USA
    WCA:
    2003BURT01
    Whoa...why does your WCAID not follow convention?
     
  4. Can someone find me the cubers that has a 2x2/3x3 solve of 5 mins -10 mins.
     
  5. Last two.
    Last 13.
     
  6. ilikecubing

    ilikecubing Member

    826
    0
    Oct 28, 2010
    WCA:
    2011KULS01
    YouTube:
    musicfreak9312
    Its because I had a name change
     
  7. Pro94

    Pro94 Member

    309
    2
    Jul 2, 2010
    Legnano, Italy
    WCA:
    2009PROV01
    YouTube:
    Pro12894
    We had 4 WRs this weekend in 3 different competitions, all in Europe (5 if we consider 3x3 Best Podium).
    Has this already happened?
     
  8. blakedacuber

    blakedacuber Premium Member

    952
    0
    Nov 6, 2009
    Ireland
    WCA:
    2010BOWE01
    YouTube:
    wellboi12345
    Most national records brOken by a single person at 1 competition in the last 3 years?
     
  9. Youngest 4x4 and 5x5 BLD solver?

    I was wondering if i am the world's youngest 4x4 BLDer which i will do at nationals. I am reaaally close for 4x4 and am sure to get it next weekend, considering it's pretty easy for me. For 5x5 BLD, i just need an inner edges parity algorithm. Im the 8th youngest for normal BLD (yes, done at Hillsdale Winter 2012). Please answer. Thanks!
    Edit: Sorry I'm new to speedsolving so I obviously multi posted way too much :p
     
    Last edited: Apr 17, 2012
  10. ben1996123

    ben1996123 Banned

    4,972
    2
    May 17, 2009
    Ponyville
    WCA:
    2009WHIT01
    YouTube:
    ben1996123
    It depends how old you are.
     
  11. RNewms27

    RNewms27 Member

    417
    0
    Jul 31, 2011
    New Jersey, USA
    YouTube:
    Rnewms0
    He is somewhere between 10 and 11.
     
  12. drewsopchak

    drewsopchak Member

    876
    0
    Apr 22, 2010
    Central Upstate New York
    WCA:
    2010SOPC01
    YouTube:
    sebucwerd
    Your constitution must be admirable to be big cube blding at your age.
     
  13. Oh whoops, i am 10 years 8 months and 8 days old as of April 17

    Oh by the way check out my video on my youtube channel of mu BLD solve. I cant get the link because I'm on an iPad

    This is probably the only thing I'll ever accomplish in life that isnt fun but i had to push myself LOL. Eventually big cubes BLD will be fun
     
    Last edited by a moderator: Apr 17, 2012
  14. ardi4nto

    ardi4nto Member

    Hi Ayush,

    Here it is,
    Code:
    +----------+----------+------------+----------------------------+------------+-----------------+
    | pbAvg    | pbSgl    | difference | personName                 | personId   | personCountryId |
    +----------+----------+------------+----------------------------+------------+-----------------+
    | 422.4800 | 195.6100 |   226.8700 | Kenn-Eerik Kannike         | 2009KANN01 | Estonia         |
    | 412.4900 | 206.6500 |   205.8400 | Aman Agrawal               | 2012AGRA01 | India           |
    | 322.2900 | 133.3800 |   188.9100 | Marine Asalia              | 2009ASAL01 | India           |
    | 468.9800 | 292.3400 |   176.6400 | Saarthi Bhatia             | 2009BHAT02 | India           |
    | 375.8900 | 203.7200 |   172.1700 | Indrek J├Áe                | 2009JOEI01 | Estonia         |
    | 335.5800 | 175.5700 |   160.0100 | Dariusz Peta               | 2005PETA01 | Poland          |
    | 332.6100 | 173.7200 |   158.8900 | Eduardo González Parra    | 2011PARR03 | Mexico          |
    | 337.4900 | 180.3800 |   157.1100 | Krzysztof Boryczko         | 2005BORY01 | Poland          |
    | 317.9600 | 161.3000 |   156.6600 | Rebecca Hughey             | 2007HUGH04 | USA             |
    | 369.9200 | 219.0800 |   150.8400 | Patrick Garcin             | 2008GARC05 | France          |
    +----------+----------+------------+----------------------------+------------+-----------------+
    Based on Stefan's code few pages before.
    Code:
    SELECT pbAvg, pbSgl, pbAvg-pbSgl difference, personName, personId, personCountryId
    FROM (SELECT min(if(average>0,average/100.00,1111111111)) AS pbAvg, min(if(best>0,best/100.00,1111111111)) AS pbSgl, personName, personId, personCountryId
    FROM results
    WHERE eventId = '444'
    GROUP BY personId) helper
    WHERE pbAvg<1111111111 AND pbSgl<1111111111
    ORDER BY difference DESC
    LIMIT 10
    
    For the smallest difference:
    Code:
    +---------+---------+------------+-------------------------------------------------+------------+-----------------+
    | pbAvg   | pbSgl   | difference | personName                                      | personId   | personCountryId |
    +---------+---------+------------+-------------------------------------------------+------------+-----------------+
    | 80.6600 | 80.1900 |     0.4700 | Muhammad Bintang Assyidik                       | 2010ASSY01 | Indonesia       |
    | 57.4400 | 56.7200 |     0.7200 | Erwan Kohler                                    | 2010KOHL02 | Switzerland     |
    | 66.0700 | 64.7700 |     1.3000 | Yukiko Makino (þëºÚçÄþö▒Õ©îÕ¡É)                 | 2007MAKI01 | Japan           |
    | 74.8800 | 73.5600 |     1.3200 | Mateusz Burnicki                                | 2006BURN01 | Poland          |
    | 75.6500 | 74.2800 |     1.3700 | Zijing Jin (ÚçæÕ¡ÉÚØû)                          | 2011JINZ01 | China           |
    | 70.9700 | 69.5600 |     1.4100 | Sakai Taisyu (ÕØéõ║òÕñºÕæ¿)                     | 2012TAIS01 | Japan           |
    | 82.0000 | 80.5600 |     1.4400 | Bo-Zhou Xiao                                    | 2009XIAO01 | Taiwan          |
    | 59.6600 | 58.1600 |     1.5000 | Dakota Allen Harris                             | 2008HARR03 | USA             |
    | 58.7200 | 57.1500 |     1.5700 | Julian David                                    | 2010DAVI06 | Canada          |
    | 51.6800 | 50.0200 |     1.6600 | Marcin Zalewski                                 | 2011ZALE02 | Poland          |
    +---------+---------+------------+-------------------------------------------------+------------+-----------------+
     
  15. Henrik

    Henrik Member

    494
    2
    Aug 15, 2007
    Fyn, Denmark
    WCA:
    2006BUUS01
    YouTube:
    henrikthedane
    I think you are right up there with your 14

    I found one of my own where I did 10 NRs (It keeps getting harder to break :p)
     
  16. ben1996123

    ben1996123 Banned

    4,972
    2
    May 17, 2009
    Ponyville
    WCA:
    2009WHIT01
    YouTube:
    ben1996123
    Longest standing NRs?
     
  17. aronpm

    aronpm Member

    2,010
    2
    Sep 9, 2009
  18. Pro94

    Pro94 Member

    309
    2
    Jul 2, 2010
    Legnano, Italy
    WCA:
    2009PROV01
    YouTube:
    Pro12894
    It depends: Feliks has 17 NRs in one comp (counting CRs and WR, because they are also NRs). If you count only NRs I agree with Henrik.
     
  19. SimonWestlund

    SimonWestlund Member

    961
    0
    Feb 18, 2009
    Sweden
    WCA:
    2008WEST02
    YouTube:
    SimonGH3
    I broke 16 at the Helsinki Open 2011 :D
     

Share This Page