Announcement

Collapse

Forum Rules

  • No flaming or derogatory remarks, directly or through insinuation.
  • No discussion, sharing or referencing illegal software such as hacks, keygen, cracks and pirated software.
  • No offensive contents, including but not limited to, racism, gore or pornography.
  • No excessive spam/meme, i.e. copious one liners in a short period of time, typing with all caps or posting meme responses (text/image).
  • No trolling, including but not limited to, flame incitation, user provocation or false information distribution.
  • No link spamming or signature advertisements for content not specific to Dota 2.
  • No Dota 2 key requests, sell, trade etc.
  • You may not create multiple accounts for any purpose, including ban evasion, unless expressly permitted by a moderator.

  • Please search before posting. One thread per issue. Do not create another thread if there is an existing one already.
  • Before posting anything, make sure you check out all sticky threads (e.g., this). Do not create new threads about closed ones.
  • It is extremely important that you post in correct forum section.

  • Balance discussion only in Misc.
  • All art related (such as hero model) feedbacks go to Art Feedback Forum.
  • All matchmaking feedback should go here: Matchmaking Feedback
  • All report/low priority issues should go here: Commend/Report/Ban Feedback
  • No specific workshop item feedback. These should go to workshop page of that item.
  • When posting in non-bugs section (such as this), use [Bugs], [Discussion] or [Suggestion] prefix in your thread name.



In case you object some action by a moderator, please contact him directly through PM and explain your concerns politely. If you are still unable to resolve the issue, contact an administrator. Do not drag these issues in public.



All rules are meant to augment common sense, please use them when not conflicted with aforementioned policies.
See more
See less

I made an "excel" sheet regarding RMM and I need your help!

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    I made an "excel" sheet regarding RMM and I need your help!

    It is written in docs google because I don't have excel. Docs google is free and you don't need to install anything .

    Well here is the table with some values: https://docs.google.com/spreadsheet/...tWUVTekE#gid=0
    Only columns that need to be manually filled is MMR Party, MMR Solo and sometimes Abandonment column.

    (Sorry you don't have edit permission. However feel free to copy or give me your e-mail via PM and I make a copy of it and give you edit permission.)

    If there is any question ask ahead.

    -------------

    What functionality is it lacking?

    What would you change?

    Also I need more data from people with lots of games played in ranked (Solo or Party doesn't matter).
    From players:
    a) who improved their MMR by a lot
    b) who have been plateauing for a while
    c) whose MMR have declined
    d) whose MMR have fluctuated a lot (large winning streaks, large losing streaks)

    Either you give me the screenshots of all your games (view game history lists 15 or so games with MMR) and I put it in manually or you give me your e-mail address and I give you edit permission. I will make a table for each player.
    (I treat any match that has less than 22 MMR gain/loss as an abandonment game. (Am I safe to assume this? From personal experience and observing other people's MMR gain/loss I came to that conclusion. While we are at it what was your lowest MMR gain/loss without any abandonment by someone?))

    I need players with a lot of games to draw any conclusion.
    Ofc I don't know your personal skill and whether you are really good or bad and if you are improving so I can't make any immediate conclusions.

    If I don't get a large amount of feedback because people are shy sharing their MMR I am also fine with MMR gain/loss. I will modify the table a little and make you start at 1000 MMR.
    (However I like to avoid this if it is possible.)

    Anyone who is interested please reply in this thread with the following form:
    Spoiler: 

    How many games have you played in MMR Party and MMR Solo?
    - MMR Party: ~50 games
    - MMR Solo: ~120 games

    How would you describe your MMR graph?
    - It is steadily/slowly rising/falling. OR:
    - It is stable/fluctating a lot.

    Optional (if you are confident in giving me your MMRs):
    What was your MMR after calibration phase and what is it now?
    - MMR Party: 4185 (after calibration) -> 4263 (now)
    - MMR Solo: 4296 -> 4307

    Anything you like to add?
    -


    Anyone else:
    Looking for feedback on my table.
    James "2GD" Harding's career as a Dota 2 host on Valve events
    * 25.02.16 - † 26.02.16
    Spoiler: 


    Tags: None
  • #2
    When do you want this by? I wouldn't mind giving you data but I haven't been playing much (or at all) during the holidays, so it might be another week or two until I can add 2 pages of game or so.

    Comment

    • #3
      I have a friend who got 5 points for a fully played game with no abandons so no, it's not always an abandon under 22, we've gotten 19, 15, 41, it could be anything.

      Comment

      • #4
        Why so much text with so little meaning?..

        You're only as strong as your weakest link.
        -Thomas Reid

        Comment

        • #5
          Originally posted by urbangoose View Post
          When do you want this by? I wouldn't mind giving you data but I haven't been playing much (or at all) during the holidays, so it might be another week or two until I can add 2 pages of game or so.
          I don't have a deadline. Anytime is fine.

          Originally posted by Renita View Post
          I have a friend who got 5 points for a fully played game with no abandons so no, it's not always an abandon under 22, we've gotten 19, 15, 41, it could be anything.
          How much MMR does your friend have? All my games and my friends' games are between 20 and 30 MMR gain/loss. Also can you provide me a screenshot of 41?
          Originally posted by soprof View Post
          Why so much text with so little meaning?..

          Spoiler: 
          Wow that's pretty neat but how am I supposed to make such graph if I don't have the data?
          James "2GD" Harding's career as a Dota 2 host on Valve events
          * 25.02.16 - † 26.02.16
          Spoiler: 


          Comment

          • #6
            Originally posted by GermanViet View Post
            Wow that's pretty neat but how am I supposed to make such graph if I don't have the data?
            Such graph, so spiky, wow, much data, wow.
            sigpic

            Comment

            • #7
              What are we supposed to do here again? What is this for?

              Comment

              • #8
                Originally posted by Jarnoloh View Post
                What are we supposed to do here again? What is this for?
                He is trying to accumulate data to get a better idea of how the MMR system or RMM works, where the discrepancies lie and what may cause them, and just a basic data driven process of understanding.

                Btw, did you want MMR and uncertainty for Calibration matches? I haven't played mine yet but was going to eventually and I can just get those as well (unless they removed that).

                Edit: Sheit, they removed it a while ago while I wasn't paying attention... Well, damn.
                Last edited by rockonrob; 01-02-2014, 10:21 AM.

                Comment

                • #9
                  They have removed that I believe.
                  Maybe I just scrap the idea. I don't seem to get much feedback.
                  James "2GD" Harding's career as a Dota 2 host on Valve events
                  * 25.02.16 - † 26.02.16
                  Spoiler: 


                  Comment

                  • #10
                    Originally posted by GermanViet View Post
                    They have removed that I believe.
                    Maybe I just scrap the idea. I don't seem to get much feedback.
                    Well thruthfully this will not be an overnight process and if you have not already posted on reddit, you should do so. In the end you will get a few dedicated players who might continually give you data, but that might make it a bit skewed
                    Also, something that came up in another thread, when you play and on what server you play on might influence your MMR, which is pretty interesting

                    Comment

                    • #11
                      I made a reddit thread again.

                      True. I should give it more time.
                      James "2GD" Harding's career as a Dota 2 host on Valve events
                      * 25.02.16 - † 26.02.16
                      Spoiler: 


                      Comment

                      • #12
                        Wow that's pretty neat but how am I supposed to make such graph if I don't have the data?
                        Ty!

                        Open match history and get the data? =D
                        You're only as strong as your weakest link.
                        -Thomas Reid

                        Comment

                        • #13
                          Yea but I haven't played as much as you guys

                          So this thread's purpose is to find people who have played lots of ranked games and are willing to share their data.
                          Either I give them edit permission or they give me screenshots of their games played.

                          Also so far I noticed that MMR gain/loss is always between 23-28 (at least in my games) given there are no abandonments. Can you confirm that?
                          Even short games (with no abandoners) seem to give at least 23 MMR.
                          James "2GD" Harding's career as a Dota 2 host on Valve events
                          * 25.02.16 - † 26.02.16
                          Spoiler: 


                          Comment

                          • #14
                            Originally posted by GermanViet View Post
                            Yea but I haven't played as much as you guys

                            So this thread's purpose is to find people who have played lots of ranked games and are willing to share their data.
                            Either I give them edit permission or they give me screenshots of their games played.

                            Also so far I noticed that MMR gain/loss is always between 23-28 (at least in my games) given there are no abandonments. Can you confirm that?
                            Even short games (with no abandoners) seem to give at least 23 MMR.
                            If you're soloing, most of your games should be +/- 25 because even if there are stacks on your team, you should be somewhere in the middle.

                            Comment

                            • #15
                              Oh right. I've been soloing and the people I stacked up with have MMR in my range.

                              This makes more sense why I havent seen 41 MMR being shifted (Renita mentioned it and he talked in plural so he was in a party).
                              James "2GD" Harding's career as a Dota 2 host on Valve events
                              * 25.02.16 - † 26.02.16
                              Spoiler: 


                              Comment

                              Previous template Next
                              Working...
                              X