I don’t know the term in English but you can include “Zahlenformat (?) in die bedingte Formatierung” so that in cells (of the column with players’ names) that are colored white they also display something like “less than three games so far” behind the name
@pacifiersboard said in Proposal for a new, ELO-based, ranking system:
I don’t know the term in English but you can include “Zahlenformat (?) in die bedingte Formatierung” so that in cells (of the column with players’ names) that are colored white they also display something like “less than three games so far” behind the name
Are you sure? Maybe Excel can do that, but I don’t see that option in Google Sheets…
How do you like it this way?
That way everyone can see the lifetime-ranking and also the playoff-spot
I still can’t access the spreadsheet directly and use things like the search and filter function, or put new data in directly. I can just see it as another page in chrome (so no google sheets interface either) and nothing tells me that I don’t have permission or that it is read only. I’ve tried going into google sheets and then loading the page but can’t find it.
Two questions. If others are able to access it, how? If others aren’t, is there something that @MrRoboto needs to do to open up access.
I usually use office, not google for documents and spreadsheets, so might just not be familiar enough.
@MrRoboto that does work! Thanks!
@MrRoboto said in Proposal for a new, ELO-based, ranking system:
How do you like it this way?
That way everyone can see the lifetime-ranking and also the playoff-spot
Yes, perfect, tier colors across and also formulaed rankings for 6+ games. I said ready, set, go because I had confidence you would make the solution quickly! 💯
@MrRoboto
Why are the ELO ranking levels different for the different versions? Is that intentional based on some mathematical spread?
I was playing around with the exact numbers and apparently didn’t settle on the same number across different versions.
Tiers have no actual meaning and are just a visual cue.
And they add motivation, I think.
I will discuss final numbers with gamerman later, probably after entering more of the historical results.
Huge thanks btw to @mr_stucifer and @farmboy who provided all of the data before 2023.
As of right now, we have everything from 01-01-2019 until now!
@MrRoboto Mr. Roboto, this is excellent work! It’s actually quite perfect timing, I created my own spreadsheet a few days ago for Revised players on TripleA. The one thing I can’t seem to wrap my head around is setting an ELO and then updating it without creating a circular reference. If you could help this I would be eternally grateful! My spreadsheet is here: https://bit.ly/revisedstats
Thanks!
The dwarves are digging deep, all the way to 9/30/17 so far…
Watch as the life-time ELO rankings take shape…
Or wait until all is entered and edit checks done
I just saw that your post was queued for approval, and approved it
@gamerman01 Thank you
From the first page:
“A win by the current #1 against the current last place will award only meager 4 points for the winner and -2 for the loser.
However, the last player would receive a whopping 136 for a win and #1 would suffer -87 for that loss!”
Maybe this has been adressed before and. I am just curious why this is fair.
In chess, the winner and the loser gain/lose the same number of points whereas here the winner always gain more than the loser lose. Why is it this way? This means that everyones rating will increase over time given the number of players are constant? How is this fair to new players?
I am sure I am missing something!
I say everyones rating will increase. I mean “everyone” or most player.
The loser’s ELO drops more than the winner’s gains if the winner’s ELO is higher than the loser’s
I think you can access the “results” tab
Type in a player’s name in the yellow box and I think you’ll be able to see
It’ll be more efficient if @MrRoboto answers the rest
We have 4489 games finished now.
The Average rating is 1486,77
The Median rating is 1459.
So as you can see, everyones rating hasn’t increased and a brand new player with 0-0 is even better than average ;-)
Something is wrong if the average player is worse than the new player since this has been incorrect from personal experience.
I looked through the data to see the apparent ELO of new players and they have been averaging around 1360 meaning they beat people ranked above this number the same frequency as they lost to people ranked below this number in their first game. I excluded the first few years of data as everyone was fresh in the League. Not the most rigorous mathematical calculation and I am sure you could be more accurate in the numbers.
Unfortunately this is a bit of a recursive calculation if you wanted to do this properly; adding in new people at ELO=1360 will lower the ELO of the entire community meaning you have to again adjust the ELO of newbies. In the end you probably will get around 1330 as the best estimate of a fresh person joining the League, but I would be interested if you could do a more thorough evaluation.
You are correct of course.
I meant someone who joins the league is 1500, before finishing a game and therefore on paper better than average.
But most people seem to start with losses. I could get the correct data for that (and might find out that I am wrong with that hypothesis) but frankly am too lazy so a rough estimate is looking at people who currently have exactly very few games finished.
Out of 37 players who have completed a single game, only 8 have won that single game while 29 have lost it.
Out of 16 players who have completed exactly two games, NONE has won both and only 6 of them went 1-1 while 10 have 0-2.
Out of 20 players who have completed exactly three games, two have won all 3, 6 players have won 2 out of 3, 4 went 1-2 and 8 out of 15 went 0-3
So we have 71 players with 1-3 completed games and only 14 out of 71 have a rating of 1500 or higher.
I suppose it’s safe to say that new players tend to be worse than average - which shouldn’t be surprising.
Do you want to adjust the starting value of ELO down a bit in your spreadsheet so there isn’t incentive to pick on noobs to increase ranking? Somewhere in the mid-1300s would be more appropriate?
I doubt there are many stellar players who are joining the League and will dominate veterans during their initial matches. Gameplay in this forum is so much higher than the casual gamer who thinks OOB is actually balanced sans bid.
