Check the thumbnail for points/ratings.

Moderator: Defcon moderators


Schubdüse wrote:Could anybody send me the thread/post in which is explained how the ratings are generated?
Thx
Ace Rimmer wrote:...
Now remember, real life skill can not really ever be measured mathematically. All that can be done is adjust a players rating to a more accurate rating with each new game (data point) figured in. Thus, the more games you play, the more accurate the rating. So, when comparing rus|Mike's 1581 to Nightwatch's 1580 you must remember that. rus|Mike is at 1581 with 21 games, while Nightwatch is at 1580 with 47 games (twice the # of games). What does that mean, think of projecting rus|Mike to 47 games and you get:Code: Select all
Player Rating W-L-D
rus|Mike 1681 45-2-0
Nightwatch 1580 35-12-0
1681 derived by taking number of rating points (81) and dividing by number of games played (21). Then multiplying that (3.857142) times 26 future games (= 100.285 + 1581) =1681...

Code: Select all
=IF(AND(A2>0,EXACT(B2,F2)),AVERAGE(IF(G2=1,VLOOKUP(F2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=F2),--($C1:C$2=G2-1),$D1:D$2))+25*(1-(1/(1+10^((IF(O2=1,VLOOKUP(N2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=N2),--($C1:C$2=O2-1),$D1:D$2))-IF(G2=1,VLOOKUP(F2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=F2),--($C1:C$2=G2-1),$D1:D$2)))/400)))),IF(G2=1,VLOOKUP(F2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=F2),--($C1:C$2=G2-1),$D1:D$2))+25*(1-(1/(1+10^((IF(S2=1,VLOOKUP(R2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=R2),--($C1:C$2=S2-1),$D1:D$2))-IF(G2=1,VLOOKUP(F2,'Raw Data'!AM:AO,3,FALSE),SUMPRODUCT(--($B1:B$2=F2),--($C1:C$2=G2-1),$D1:D$2)))/400))))),"")









Users browsing this forum: Google [Bot] and 0 guests