Elo rating database for up to 500 participants

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!

Hello quentinw9281 and Welcome to Excel Forum.

You are asking a question in a thread that has been dormant for 3+ years. Old threads are often only monitored by the original participant(s). New threads not only open you up to all possible participants, they typically get faster response. If you feel this thread is particularly relevant to your need, provide a link to this thread in your new thread.

Let us know if you have any questions.