ahmed_aly's blog

By ahmed_aly, 14 years ago, In English
Hi everyone,

I've just finished the first Codeforces tools website, currently it contains only one feature called all users table.
This table is similar to Codeforces rating table, but with this additional columns:
- Number of Tried Problems
- Number of Solved Problems
- Solved Problems Percentage
- Number of Successful Hacks
- Number of Unsuccessful Hacks
- Contribution Rank
- Contribution

Also you can sort the table according to any column by clicking on the column header, it may take couple of seconds to sort the table as it's very big, also it may take few seconds to load the table.
There are some important notes in the home page, make sure to check it.

Keep checking this main post to see the new added features.

I'll add the following features:
- Add filtering for the all users table.
- Adding profile page for each user, which contains links for all problems he solved.
- Adding some statistics for each user, for example the languages he used to solved the problem, his average number of solved problems per contest, how many times he solved a problem for each level, and more information.
- The ability to compare to users, by merging their graphs together, or counting how many number solved by one of them while the other one failed to solve it.

If you have any suggestion or a feature you wish, feel free to ask for it in this post, and I'll do my best to make all requested features (if I can).

Hope you will find it useful.

Thanks!
  • Vote: I like it
  • +112
  • Vote: I do not like it

14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Some facts from the all users table:
1- A_A_Lunyov failed in only one problem out of 70 submitted problems.
2- Egor submitted 190 problems.
3- Egor solved 163 problems.
4- Egor is second in the rating and contribution.
  • 14 years ago, # ^ |
      Vote: I like it +2 Vote: I do not like it
    awesome....
  • 14 years ago, # ^ |
    Rev. 2   Vote: I like it +5 Vote: I do not like it
    I think that there is no interest in it without sorting.
    Also very important stats are: min rating, max rating, worst/best contest(i.e. when lost/get most points), worst/best position and all of that stats could be easily retrieved from profile.
    • 14 years ago, # ^ |
        Vote: I like it 0 Vote: I do not like it
      What do you mean by without sorting? You can sort the table by clicking on the header of any column.
      And I'll add your requested stats, thanks for your suggestion.
      • 14 years ago, # ^ |
        Rev. 2   Vote: I like it 0 Vote: I do not like it
        Sorry, that's stupid WebKit, doing O(n2) selection algorithm to sort tables.
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    Hacks stat would be very interesting
    • 14 years ago, # ^ |
        Vote: I like it +3 Vote: I do not like it
      It's added now. But I'm wondering, is your number of successful hacks correct?
      As there is a very big margin between you and the second maximum number of successful hacks.
      • 14 years ago, # ^ |
          Vote: I like it +8 Vote: I do not like it
        The contest without 5 successfull hacks is wasted for me :)
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    Probably you count also submits from upsolving and unrated for participant events. It's not right. I have just checked that I have solved all the problems that I have submitted on rated for me events (even for old ACM format contests where it's not critical). And I haven't any fail on contests under the new system.

    This only problem is the problem C from the contest with ID 39. Also I have failed on problem G that time. But I have solved it later in upsolving. Am I right that if someone will solve all unsolved by him problems in upsolving then he will have 100% in your table?
    • 14 years ago, # ^ |
        Vote: I like it 0 Vote: I do not like it
      Actually the only failed problem is problem C in Codeforces Testing Round #1.
      I think the notes written in the home page will answer all your questions.

      Here are the notes:
      1 - The only ignored contests are the 3 team contests.
      2 - Each contestant is considered official even if he is out of competition.
      3 - Normal contest and Div 2 contest are considered the same.
      4 - The tried and solved problem counts are for the submissions happened during any online contest, even it's unrated.
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
Really  Good :D
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
(Number of solved problems) / (Number of contests)
Egor: 163 / 23 = 7.08 ?
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Really liked it.
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
great job, man!it's rlly interesting to look through such statistic) thank u:)
14 years ago, # |
Rev. 2   Vote: I like it +8 Vote: I do not like it
Grate job!

First request is to split tables into several pages. Or make header visible always because it is difficult to keep in mind so many column names.
Thank you.
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Because of js and my slow PC, I can't sort a table. :(

But it's great, thank you!

Also, maybe it'll be good to make a checkbox, that toggle on/off unrated contest.
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it

Some interesting stats (at least, interesting for me), like at TopCoder:

highest point total in a round; most matches in top3, in top10, in top50; most successful challenges in a single match.

14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
I think it will be good if you add filtering by country
  • 14 years ago, # ^ |
      Vote: I like it +3 Vote: I do not like it
    I had few problems in doing this:
    1- It's optional for the user to write his country. (It should be mandatory)
    2- The user will write the country in text box, then we can see two different countries "USA" and "United States of America", and maybe more than two. (It should be drop down list)
    3- In each profile below the username, there is this string "FirstName LastName, Country, City". And any of these could be missing, so it may be "Country, City" or "FirstName LastName, Country". So I can't easily detect what is the country. (The country should be a constant field below the rating and contribution)
    • 14 years ago, # ^ |
        Vote: I like it 0 Vote: I do not like it
      Yes, here is some trouble.
    • 14 years ago, # ^ |
        Vote: I like it 0 Vote: I do not like it
      Ask Mike to help you then.
      And here's my request: "Please Mike help Ahmed in doing such tools as many people need it and will be satisfied". :-)
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Can you add your TopCoder filtering tools to the big list? Also, Can you add friends filtering and you detect them when I am logged into Codeforces?
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Really great
»
7 years ago, # |
  Vote: I like it 0 Vote: I do not like it

Is it possible to opensource this tool please ?