Hi guys,
i have hope that one of you came across this before: I'm looking for a software or Excel sheet where I can easily track the ELO rating of several players for our league night. If I can just enter the wins as 1:0 that would already help. But if I could enter the results as normal match results (200 : 145 for example) and get different rating changes based on how clear the win was, that would be awesome. I would be glad if someone could point me in the right direction.
Thanks!

I've got a league google sheets workbook that's...rather complicated, but includes a sheet that does ELO. I'll see if I can easily rip it out on its own real quick.

Real quick...how many people does this need to support? My current one can do up to 40 and it's trivially easy to do more than that, but you do have to make a couple of changes and the thing will break if you don't adjust for higher player counts.

40 will definitely be enough. I don't think that I will need more than 20.

I looked at a site/program called Rankade a while back when my group experimented with an ELO system. It looked pretty good, though we decided against it before getting a chance to try it.

Was gonna say, I could probably help you out with an Excel one but I'm not sure if there's a good website for it.

Tabletop TO does series scoring but that's if you have a bunch of mini tournaments, not just random pickup league games

I have some python code I did for a league that does Elo ranking

• Modified Elo math to allow for non-binary win-loss values (moV based)
  • You can adjust the relative weight of win-loss vs MoV
• I also made it so that order within a week doesn't matter
  • Thought it was silly to have order matter when to reporting isnt necessarily inorder
  • It calculates a bunch of random orders for a week and gives the average results
• Automated google sheets based input/output
  • Also HTML template for league website with these sheets embedded, but its very basic

Here is the site if you want to see it in action

You don't need to know python per se but you would prob have to do some debugging, so more of an investment than a spreadsheet. Let me know if you're interested, I'd need to clean up the code/path references a bit for it to be user friendly

...random note that I sort of wish the official app would support this, as it's trivial enough to do given the stated objectives of the thing, and could be AMAZING for the game community if it allowed for casual pairings with handicaps (IE., higher-ranked player flying their preferred 200pt squad, with lower-ranked player...based on some formula derived from the ELO ranking...given XX number of points more to work with, or maybe just starting with XX points scored as the match starts - the goal, as with the concept of handicaps in sporting events, being to give players of an otherwise-notable difference in skill/experience an opportunity to play against each other with an equal challenge).

On 9/16/2019 at 8:56 PM, prauxim said:

I have some python code I did for a league that does Elo ranking

• Modified Elo math to allow for non-binary win-loss values (moV based)
  • You can adjust the relative weight of win-loss vs MoV
• I also made it so that order within a week doesn't matter
  • Thought it was silly to have order matter when to reporting isnt necessarily inorder
  • It calculates a bunch of random orders for a week and gives the average results
• Automated google sheets based input/output
  • Also HTML template for league website with these sheets embedded, but its very basic

That's actually pretty exactly what I envisioned. If it's not too much work, I'd love to get the debugged version. I can't do any coding and I'm not familiar with python at all. But I'm usually pretty pretty good at understanding the logic behind the programming and at adapting. So I hope I will get by.