Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating ELO Rating (UDF Query)
I'm putting together a UDF that returns an ELO rating for chess players, however I can't seem to get the probablity of winning section working. How would I write the formula (http://upload.wikimedia.org/math/b/2...06d0cb4ef0.png) as a UDF? If Ra = 1613 and Rb = 1609, the answer returned from the UDF should = 0.506 (example taken from http://en.wikipedia.org/wiki/ELO_rating_system). It might be something I am doing wrong with bracket positioning but I'm sure it's not. Ea = 1 / (1 + (10 * ((Rb - Ra) / 400))) This doen't return 0.506 like the example taken from http://en.wikipedia.org/wiki/ELO_rating_system. Can anyone see where I'm going wrong? Or is there a ELO UDF already out there? Thanks in advance. -- d.i.barr ------------------------------------------------------------------------ d.i.barr's Profile: http://www.excelforum.com/member.php...o&userid=15521 View this thread: http://www.excelforum.com/showthread...hreadid=518685 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating ELO Rating (UDF Query)
Function ELO(Ra As Double, Rb As Double) As Double
ELO = 1 / (1 + 10 ^ ((Rb - Ra) / 400)) End Function -- Kind regards, Niek Otten "d.i.barr" wrote in message ... I'm putting together a UDF that returns an ELO rating for chess players, however I can't seem to get the probablity of winning section working. How would I write the formula (http://upload.wikimedia.org/math/b/2...06d0cb4ef0.png) as a UDF? If Ra = 1613 and Rb = 1609, the answer returned from the UDF should = 0.506 (example taken from http://en.wikipedia.org/wiki/ELO_rating_system). It might be something I am doing wrong with bracket positioning but I'm sure it's not. Ea = 1 / (1 + (10 * ((Rb - Ra) / 400))) This doen't return 0.506 like the example taken from http://en.wikipedia.org/wiki/ELO_rating_system. Can anyone see where I'm going wrong? Or is there a ELO UDF already out there? Thanks in advance. -- d.i.barr ------------------------------------------------------------------------ d.i.barr's Profile: http://www.excelforum.com/member.php...o&userid=15521 View this thread: http://www.excelforum.com/showthread...hreadid=518685 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating ELO Rating (UDF Query)
Thanks for your help Niek -- d.i.bar ----------------------------------------------------------------------- d.i.barr's Profile: http://www.excelforum.com/member.php...fo&userid=1552 View this thread: http://www.excelforum.com/showthread.php?threadid=51868 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resolved my query regarding total sum calculating | Excel Discussion (Misc queries) | |||
Compute a rating of a mtd average compared to a rating scale | Excel Discussion (Misc queries) | |||
Calculating a date within the OLE DB query | Excel Programming | |||
Rating 1 to 10 | Excel Discussion (Misc queries) | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |