Page 5 of 6 FirstFirst ... 3 4 5 6 LastLast
Results 41 to 50 of 59

Thread: WCA Statistics Website

  1. #41
    Member Kian's Avatar
    Join Date
    May 2008
    Location
    East Brunswick, NJ
    WCA Profile
    2007BARR01
    YouTube
    xkiesterx
    Posts
    2,419

    Default

    Quote Originally Posted by Mike Hughey View Post
    Thanks. That revealed an interesting result: Congratulations to Kian Berry, who appears to have the most medals (28) without a single gold! Nick Pappas is close behind with 27. (And my daughter Rebecca is probably in the top 10, with 14!)
    Yes, I figured I had that wonderful distinction. It's a running joke in the northeast. Thanks to Rowe and Dan for making sure I never win anything.

    EDIT: Not sure if this is updated as of last weekend but if not I extended this lead by coming in 3rd at OH behind, guess who, Rowe and Dan.
    Last edited by Kian; 01-25-2012 at 01:42 PM.

  2. #42
    Super-Duper Moderator Lucas Garron's Avatar
    Join Date
    Jul 2007
    Location
    Where the rolling foothills rise
    WCA Profile
    2006GARR01
    YouTube
    LucasGarron
    Posts
    3,054

    Default

    I have six 13.36s and four 13.38s, making me the only person in first place for each of those results.

    But... no 13.37s.
    garron.us | cubing.net | twisty.js | ACube.js | Mark 2 | Regs | Show people your algs: alg.cubing.net

  3. #43
    Member Mr.Toad's Avatar
    Join Date
    Jul 2009
    Posts
    82

    Default

    Quote Originally Posted by Anthony View Post
    Also, my stats are divided by Brooks and Searle. I don't really care all that much, but it would be nice if this was fixed. I also seem to be showing up under the last name Searle instead of Brooks in most of the statistics.
    Quote Originally Posted by macky View Post
    I'll try to figure this out.
    I just saw this, to solve it you just need to remove the bit in red from the query:

    Code:
    group by personId, personName

  4. #44
    Premium Member
    Join Date
    Apr 2006
    Location
    Stanford, CA
    WCA Profile
    2003MAKI01
    Posts
    392

    Default

    Quote Originally Posted by Mr.Toad View Post
    I just saw this, to solve it you just need to remove the bit in red from the query:

    Code:
    group by personId, personName
    Yes, I should remove that either way, but that shows him as "Anthony Searle" because that's the first name encountered with his WCA id. Either I find a way to have MySQL go through the data from the latest row, or I need to use subid=1 somewhere (maybe subquery, maybe in the php).
    Last edited by macky; 01-25-2012 at 03:52 PM.
    Tell me your cubing stories: Story Time with Uncle Tyson. Seriously, not enough people know about my advanced F2L section.

  5. #45
    Member qqwref's Avatar
    Join Date
    Dec 2007
    Location
    a <script> tag near you
    WCA Profile
    2006GOTT01
    YouTube
    qqwref2
    Posts
    6,880

    Default

    Can you make a page for the bottom of the "best worst result" list? (That is, worst result.)
    Computer cube PB averages of 12: [Clock: 5.72] [Pyraminx: 3.33] [Megaminx: 49.52]
    [2x2: 2.66] [3x3: 8.45] [4x4: 29.06] [5x5: 52.69] [6x6: 1:34.78] [7x7: 2:20.34]

  6. #46
    Premium Member Carson's Avatar
    Join Date
    Jan 2008
    Location
    Somerset, Kentucky, United States
    WCA Profile
    2008PENT01
    YouTube
    carsonpenticuff
    Posts
    1,284

    Default

    An interesting thought:

    It would be neat to have a list of the average time required to win each event each year that a competition has taken place. I'm not sure if I am explaining this well... the average winning time of each occurrence of a specific event during the course of a year.

  7. #47
    Premium Member
    Join Date
    Jun 2006
    Location
    Boston, MA
    WCA Profile
    2005REYN01
    YouTube
    timbreynolds
    Posts
    936

    Default

    Quote Originally Posted by Carson View Post
    An interesting thought:

    It would be neat to have a list of the average time required to win each event each year that a competition has taken place. I'm not sure if I am explaining this well... the average winning time of each occurrence of a specific event during the course of a year.
    Code:
    	2011		2010		2009		2008		2007		2006		2005		2004
    333	11.299		11.900 		13.118		13.224		14.178		15.659		17.934		19.396
    444	52.164		54.928		58.553		1:04.550	1:11.277	1:16.532	1:30.212	1:31.624
    555	1:36.436	1:36.298	1:41.308	1:54.779	2:09.807	2:28.572	3:02.212	2:54.018
    222	3.818		4.147		5.114		5.163		6.288		7.404		8.881		10.870
    333bf	1:52.778	1:50.932	1:54.976	1:58.020	2:27.421	3:19.773	5:42.239	10:59.078
    333oh	20.304		22.107		24.140		25.470		27.079		32.113		44.459		43.515
    333fm	32.7		33.1		34.0		34.1		35.5		31.3		35.0		31.0
    333ft	1:30.620	1:24.716	1:35.776	1:37.772	1:18.426	2:56.020
    minx	1:26.599	1:29.640	1:40.590	1:51.690	1:50.584	2:06.223
    pyram	6.709		7.318		8.422		8.906		10.923		11.911		14.193
    sq1	24.774		25.596		25.850		30.769		33.249		43.849		48.855		33.210
    clock	12.458		12.540		12.051		14.443		12.748		14.089		14.100		11.767
    666	3:07.895	3:15.692	3:30.542
    777	4:51.563	4:51.234	5:18.497
    magic	1.346		1.371		1.434		1.486		1.554		1.814		2.399		2.000
    mmagic	3.476		3.460		4.009		3.600		3.470		3.873		4.003
    444bf	9:31.138	12:50.516	14:09.820	13:55.358	25:36.573	10:08.450	n/a		19:14.000
    555bf	20:18.784	21:48.800	24:49.000	28:29.500	40:48.000	38:02.667	n/a		2:34:36.000
    There might be some mistakes, I converted the times by hand.

  8. #48
    Premium Member Carrot's Avatar
    Join Date
    Feb 2009
    WCA Profile
    2008ANDE02
    YouTube
    Minxer2011
    Posts
    1,686

    Default

    http://stats.cubing.net/single_avera..._same_time.php

    I might be wrong, but if person A sets NR with time x, and then person B (same nationality as person A) sets a time of x, shouldn't this show up then?

    (Henrik did 3.05 pyra single NR, some months later I had a 3.05 pyra single NR too )

  9. #49
    Premium Member Carson's Avatar
    Join Date
    Jan 2008
    Location
    Somerset, Kentucky, United States
    WCA Profile
    2008PENT01
    YouTube
    carsonpenticuff
    Posts
    1,284

    Default

    What about a ranking of rolling means of 100 during competitions for 3x3x3, not including DNF's and not throwing out best or worst times? This would be based on the persons "current" rolling mean instead of their best rolling mean.


    Edit: Also, what about a ranking of those people with the most lines of text on their WCA profile. I'm this could be done using the database without actually polling the site, but I would guess it would be a little more complex.
    Last edited by Carson; 02-23-2012 at 11:13 PM.

  10. #50
    Member Kian's Avatar
    Join Date
    May 2008
    Location
    East Brunswick, NJ
    WCA Profile
    2007BARR01
    YouTube
    xkiesterx
    Posts
    2,419

    Default

    Clicking on links on this site hasn't worked for me in a few weeks. Just thought it was worth reporting because the site is awesome.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •