Hi!
This is my first post here!
I have developed a ranking system based on the ELO system (used e.g. in the Chess world). It works fine, but I have problems how to input my data and to update it.
What I want is to be able to input all the matches (football, console gaming) and results every now and then; fill in with more and more results after games have being played. I want excel to calculate the NEW RATING of the team after each match. Because the ranking system is based on your CURRENT ranking, it has to update the results in the correct order.
E.g., if I have entered these results in columns and rows:
Doncaster 0-2 Ipswich
Ipswich 0-1 Reading
Let's say Ipswich have a rating of 1200 points before these matches begin. After the Doncaster match it has 1210 points. Now I want excel to calculate the Reading match with THIS NEW RATING. Since Reading has a rating of e.g. 1320, Ipswich will only lose 7 points in this match, hence the new rating of Ipswich is 1203.
Is this understandable? I desperately need help with this, thanks!!
Bookmarks