I would like to discuss the issue partially mentioned in Elo Ranking thread.
shg kindly shared 683234 - Elo Ranking.xls model which works very nice.
Currently I'm trying to tune the model to World Football Elo Ratings formula, but I'm stuck, unfortunatelly can't find 'nTeams' cell. Sorry, I'm not very experianced in Excel, I'm still learning.
The ratings wich I want to apply are based on the following formula:
Rn = Ro + KG(W − We)
or
P = KG(W − We)
Where:
Rn = The new team rating
Ro = The old team rating
K = Weight index regarding the tournament of the match
G = A number from the index of goal differences
W = The result of the match
We = The expected result
P = Points Change
Can somebody help me with updating the file?
I would like to use the table for individual player ranking in our internal lunch-time office championship in fussbal (kicker, table football). Of cource it's just for fun. Thanks.
Bookmarks