The new ELO-based ranking system

@MrRoboto

would you also like to share a local copy of the new file with formulae? I am interested in getting it to my sandbox :)

@MrRoboto I deleted the post for you

It’s a firm point that the system I maintained was vulnerable to human error, and I relied on players to catch the occasional error that I would make.

I’m not arguing against a new and improved system, as I made very clear. I don’t have time to answer point by point, nor is there any need. I don’t think you understand all of the nuances and benefits of what we’ve been relying on, but it doesn’t matter.

@MrRoboto said in Proposal for a new, ELO-based, ranking system:

But once you try to autmate it, you will need formulas. In fact that’s exactly what I did with the old PPG-system and Google Sheet immediately alerted me, that there are circular references. I had to enable iterative calculations and limit the loops to 50 calculations, since there are, in fact, infinite loops.
This is done with File -> Settings -> Calculations.
Without that, the spreadsheet would give only errors.
You can check out my automated version here:
https://docs.google.com/spreadsheets/d/1_agqROzXQHWdmmiCJXGs3oFARJ29euk6MHPXoQ-0wlI/

I already showed it to you multiple times, but I can try it one more time, this time a bit more detailed.

The cell with the Tier ranking (A) looks at the PPG-cell (B)
The PPG-Cell (B) is just total points © divided by number of games.
Total points looks at all the individual points a result has awarded. Let’s say there are 10 results for a specific player, so total points looks at 10 different cells, we can call them R1-R10. Now you just added these points manually and it’s almost impossible to determine which summand refers to which specific result. But even manually all of these 10 summands depend on the tier of the opponent.
So R1-10 look at the cells with the tier of the different opponents, let’s call them O1-O10.
O1-10 looks at PPG (B1-B10).
PPG (B1-B10) look at total points of these players (TP1 - TP10).
But in these cells TP1-TP10 are obviously summands that include the result against the original player so all of these look at cell A.
And there is already the loop.

As you said at the beginning, “once you try to automate it”. So we are each talking about a different thing. I merely asserted that there are no circular references to the (manual) system. You are saying there are circular references if you try to automate it. There is no impasse.

I have been doing the system that shows average points per game while at the same time reflecting the current tier situation of all players. You’re saying the computer can’t do that. Score a rare win for humanity.

I want the system automated and I want the ELO spreadsheet to be “it”, starting 1/1/24, so discussions about the different features of both systems is purely academic, OTHER THAN to demonstrate what features we would be losing if we don’t take a look at them and decide whether we can live without them or whether we should work together to find a way to duplicate, replicate, preserve features we don’t want to lose.

So it seems that on the table right now is playoffs. Pretty sure vast majority want optional annual playoffs for each major version played.
The fact is, with lifetime ELO, some players start the year out ahead of others, and the ELO at the end of the year is largely reflective of most recent games, but not entirely. This is not necessarily a problem. It’s just one of the issues that needs to be discussed since we have a significant system change.

@MrRoboto

thx! I meant a copy of the ELO file that is enabling some (local) experimentation

@gamerman01

The fact is, with lifetime ELO, some players start the year out ahead of others, and the ELO at the end of the year is largely reflective of most recent games, but not entirely. This is not necessarily a problem. It’s just one of the issues that needs to be discussed since we have a significant system change.

One idea: make a separate sheet for the Yearly rankings that takes the player’s Lifetime Ranking at the start of the year as their starting ELO, then only include the games from the year. Not sure how to calibrate the K value for that, maybe have all at the middle number for 10+ games played (90). Can be discussed.

That way, Lifetime players with high ELO are still recognized for their skill but someone that makes a lot of progress in a new year can move up more rapidly even if they played a lot of games previously. And someone that loses a lot of games that year would move down more rapidly.

However to @MrRoboto 's point, the K value is already large with the K at 70 giving a 35-point swing for even ELO matchups, and upsets quite a bit more than that, it seems like just using the Lifetime rating should suffice for making brackets. 🤔🤔

@mr_stucifer said in Proposal for a new, ELO-based, ranking system:

middle number for 10+ games played (90)

Correction, 7-9 games I think is K of 90, somewhere around 90-110 would be a significant acceleration of change compared to 70.

OK, so there is a “slider bar” on sensitivity that can easily be adjusted.
Reading MrRoboto’s recent post a second time, I see the sensitivity to the past 6+ games can be set to essentially make the current ELO rating (at 12/31/XX) reflect the results of the past 12 months, and the objective is met.

So then would we just want another set of results/rankings that has a lower sensitivity, like for a life-ELO number? If the same sensitivity, K factor, is used and the last, say, 6-10 results are what mostly determine the current ELO rating, then older results are nearly irrelevant?

Just trying to understand

@gamerman01 They aren’t irrelevant, but they do factor in less over time generally speaking. They are important because it tries to calibrate you to your appropriate rating quickly, then from there it is more of a maintenance process unless there is relative improvement.

At the extremes of the ELO Rating, even current games are worth little unless there is an upset. If a 1900 plays 1100 and wins they will not go up very many points, as it is expected. But if the 1900 loses the 1100 will receive a huge boost and the 1900 will fall quite significantly. This does reduce the incentive for the highest-ranked players to play the lowest-ranked players, but that was already the case.

I am not sure how, but think it would be awesome if we could implement a possible Bid allowance into drastically different ELO games. Say a 500+ rating difference could get double the usual bid but have the game be worth half the points. This might promote playing between the extremes in skill levels, if useful.

@MrRoboto Hmm, I like the idea of having the bid tied to the average, does bidding in your experience generally start slightly above average? 2% per IPC seems like it might be a little high, at least for OOB with such a high average bid, going from 40 -> 60 bid might not need to be worth 40% more points.

But in PtV going from 6 to 26 seems like it should be worth 40%. I am not very fluent in BM so I will not hypothesize. Perhaps some sort of relative scale is needed on this aspect as well.

@MrRoboto

I am sorry indeed for bothering you with this request, but it is not giving this option to me. @mr_stucifer, does it work for you now?

@MrRoboto it is now 6 for BM and 3 I believe for oob and PTV. Gamerman could confirm the numbers.

@MrRoboto

imo, bids should keep these two functions:

• determining sides by
• balancing between Allies and Axis (according to players’ individual preferences)

Balancing between different skills I see already covered by usual ELO system. Additional handicaps can hardly easily be ruled without distortion, so can be left to sportsmanship and fun’s cause without reflection in ELO?

Considering the incentive issue we already got that

• top players are already “forced” to encounter weaker players as part of the play-offs

• players with many games have to pick at least three different opponents in order to be eligible for more matches. Maybe this setting is appropriate to be modified for more alternation?