bayeselo spreadsheet formula ?

General discussion about computer chess...
Post Reply
ChessDrone
Posts: 78
Joined: Mon Jan 28, 2013 10:56 am

bayeselo spreadsheet formula ?

Post by ChessDrone » Sat Mar 29, 2014 4:08 pm

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
Posts: 616
Joined: Thu May 19, 2011 1:35 am

Re: bayeselo spreadsheet formula ?

Post by User923005 » Sun Mar 30, 2014 2:55 am

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.
Attachments
USCF.H
(521 Bytes) Downloaded 271 times
USCF.C
(5.86 KiB) Downloaded 291 times

User923005
Posts: 616
Joined: Thu May 19, 2011 1:35 am

Re: bayeselo spreadsheet formula ?

Post by User923005 » Sun Mar 30, 2014 2:57 am

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
Posts: 78
Joined: Mon Jan 28, 2013 10:56 am

Re: bayeselo spreadsheet formula ?

Post by ChessDrone » Sun Mar 30, 2014 2:17 pm

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.

Post Reply