Page 1 of 1
bayeselo spreadsheet formula ?
Posted: Sat Mar 29, 2014 4:08 pm
by ChessDrone
Hi,
there is a way to calculate bayeselo from
table of results like this?
Code: Select all
Wins Losses Draws
203 102 695
213 109 678
236 91 673
the ideal, would be a formula for spreadsheet (excel/calc), is there such a thing?
Re: bayeselo spreadsheet formula ?
Posted: Sun Mar 30, 2014 2:55 am
by User923005
The attached files calculate Elo using the USCF formula.
It won't be identical to the value calculated by bayeselo or elostat, but it will answer fairly nearly.
I guess that you can encode the math in a spreadsheet without too much trouble.
Re: bayeselo spreadsheet formula ?
Posted: Sun Mar 30, 2014 2:57 am
by User923005
I guess that you already know it, since you are a pretty sharp fellow, but Elo is a relative number, so that Elo of one pool is not equivalent to the Elo that another pool of contestants have.
Re: bayeselo spreadsheet formula ?
Posted: Sun Mar 30, 2014 2:17 pm
by ChessDrone
Thank you I sincerely appreciate your help
I explain what I wanted to do. Compare progress ELO because I saw a big jump from +37 to +39 in the last moments of the test. And so I wanted to identify the responsible lot of this jump.
If there's a way diverted, for example, the way to generate PGN files for each batch with only the results. I could then directly use the Rémi's tool
Although it is not vital, the question stay open.