Excel ELO Rating Calculator

Modérateur: diplojak

Excel ELO Rating Calculator

Message par lega1985 » 06 Jan 2017 3:01

I made Elo rating calculator in excel.
Feel free to test it here:

http://26games.net/dixit/elo.xlsx

Problem is that I don't know parameters for K & X.
K=30 is the best fit
X is in range from 400 to 600
I can never perfect fit to actual results.

So what formula do you use is mystery to me and I think your calculation is little buggy.
Please prove me that isn't :shots:
lega1985
 
Message(s) : 2
Inscription : 10 Déc 2016 20:22

Re: Excel ELO Rating Calculator

Message par frederic.moulis » 06 Jan 2017 8:59

Calculation cannot be buggy : it is what has been decided here. You like or not, but that do not make it buggy. Hop : proof done :P
Many topics here talk about ELO calculation (because many people do not use search function and asks for the same question) so you should find your answer quickly ;)
Avatar de l’utilisateur
frederic.moulis
Premium
Premium
 
Message(s) : 2817
Inscription : 15 Déc 2012 14:57
Localisation : Tours

Re: Excel ELO Rating Calculator

Message par lega1985 » 06 Jan 2017 13:53

As a mathematician I can't approve your proof :D
You're right. If you do something on purpose then it is not buggy :D
But then It is buggy to call something ELO rating if it is not. Arpad Elo would be mad.
Also, in few games I saw that sum of all ELO changes is not = 0 (necessary condition for Arpad)

http://www.boiteajeux.net/jeux/dix/partie.php?id=28522
1. lega1985 [ELO +41] (1466 --> 1507)
1. leGica [ELO +17] (1638 --> 1655)
3. zlatovrana [ELO -22] (1620 --> 1598)
4. Franfrin [ELO -41] (1500 --> 1459)
(There wasn't replacements in game)
Maybe something went wrong in order of calculation...

So I am able to do a pretty complex calculator but do not know how to type "ELO" into a search engine :)
I've noticed that a lot of people ask the same question but there is no response.
Only answer that has already been posted before.

Really nice, and please I am asking you to give me a link to the post where it is explained
or you explain me
or verify that the formula is secret :D
lega1985
 
Message(s) : 2
Inscription : 10 Déc 2016 20:22

Re: Excel ELO Rating Calculator

Message par castironmaiden » 17 Fév 2017 8:15

Hi!
I love your formula, but it is only for 4 players tournaments.
Do you have something similar for 5 players and 6 players games?
castironmaiden
 
Message(s) : 2
Inscription : 21 Déc 2015 21:30


Retour vers Dixit

Qui est en ligne ?

Utilisateur(s) parcourant ce forum : Aucun utilisateur inscrit et 1 invité

cron