+ Reply to Thread
Results 1 to 4 of 4

World Football Elo Ratings model

  1. #1
    Registered User
    Join Date
    02-22-2012
    Location
    Kiev
    MS-Off Ver
    Excel 2003
    Posts
    4

    World Football Elo Ratings model

    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.

  2. #2
    Registered User
    Join Date
    02-22-2012
    Location
    Kiev
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: World Football Elo Ratings model

    The porblem is solved, if anyone is interested in such model - please let me know.

  3. #3
    Registered User
    Join Date
    04-25-2012
    Location
    Nis
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: World Football Elo Ratings model

    Quote Originally Posted by zartem View Post
    The porblem is solved, if anyone is interested in such model - please let me know.
    Thanks zartem, I am very interested in such a model.

    Please, post it if u can.

  4. #4
    Registered User
    Join Date
    02-22-2012
    Location
    Kiev
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: World Football Elo Ratings model

    PlavoSlon,
    I'm trying to attach the model, but my proxy-server is not allowing to do it. Please, check if the file was attched properly.
    symplif.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts