Greetings,
I'm trying to put together a spreadsheet that will calculate player Elo ratings for a competitive individual sport over time. I've been searching and reading through the forums for some time, and saw quite a few threads of folks looking to do something similar -- unfortunately, they were all relatively simple with only a handful of competitors, whereas I'd like to expand the capabilities to handle up to ~500 participants and ~20,000 results (games played).
Ideally, I'd like to be able to graph the Elo ratings over time, so as to compare player performance over time, as this sport has over a decade of results recorded. Eventually, if we're able to get things working, I'd like to share it via a Google Sheet with fellow fans of the sport
I've put together a quick mock-up, and would very much appreciate some help from the wonderful expert users here. This is just what I'm imagining, do feel free to revise the formatting, etc.
Hopefully, conceptually, it's quite straight forward... Unfortunately, I'm just not familiar with the database functions like LOOKUP to implement it. As seen below (and attached), I have the dates and winner/loser of each match ready to go as inputs. I've left some in-process working space for calculated parameters in the middle, and then, on the far right, I'd like to be able to output the Elo rating for each player over time. I'm using the standard Elo formula, and have provided the formulas in the attachment.
72PncXC.png
If anything is unclear or needs clarification, do let me know. Thank you!
Bookmarks