bayeselo spreadsheet formula ?

[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?

[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.

[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.

[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.