I keep a spreadsheet that uses the elo equation for chess where I work that updates players ratings when I enter the two players names and who won or lost (1 for win, 0 for loss). My issue is that it takes a lot of manual work whenever I run out of space or when new players enter the system.
My question is, is there a more efficient way to do this? I tried using an arrayformula for the elo equation part of it but that won't work since it is circular, and I don't know enough about JavaScript to try and write a custom script to do the work. Any help appreciated.

Here is an example of the spreadsheet, can't post the original since it has last names but it has over 500 games in it:
<https://docs.google.com/spreadsheets/d/1aKln4OkukbZyieISrpM7SaQRNZGhPeMKSqrXQAx-BJc/edit#gid=858758425>