[|Erasmus|]

Originally Posted by Frogmite

Yeah it's not standard calculation as i couldn't find the formula of ELO calculation.

So i did mine:

=IF(D3>E3,ROUNDDOWN(H3+(VLOOKUP(H3-I3,DATA!P:Q,2))*(((D3-E3)/4)),0),ROUNDDOWN(I3-(VLOOKUP(H3-I3,DATA!P:Q,2))*(1/(2+D3)),0))

D3=ELO of player
E3=ELO of opponent
H3=Number of game won (0,1 or 2)
I3=Number of game won by opponent (0,1 or 2)


I then did a table with the coefficient changing according to the difference of ELO between the players:

+ [show the table] +

ELO DIFF Points given
-200 35
-199 35
-198 35
-197 35
-196 35
-195 35
-194 35
-193 35
-192 35
-191 35
-190 35
-189 35
-188 35
-187 35
-186 35
-185 35
-184 35
-183 35
-182 35
-181 35
-180 35
-179 35
-178 35
-177 35
-176 35
-175 35
-174 35
-173 35
-172 35
-171 35
-170 35
-169 35
-168 35
-167 35
-166 35
-165 35
-164 35
-163 35
-162 35
-161 35
-160 35
-159 35
-158 35
-157 35
-156 35
-155 35
-154 35
-153 35
-152 35
-151 35
-150 35
-149 35
-148 35
-147 35
-146 35
-145 35
-144 35
-143 35
-142 35
-141 35
-140 35
-139 35
-138 35
-137 35
-136 35
-135 35
-134 35
-133 35
-132 35
-131 35
-130 35
-129 35
-128 35
-127 35
-126 35
-125 35
-124 35
-123 35
-122 35
-121 35
-120 35
-119 35
-118 35
-117 35
-116 35
-115 35
-114 35
-113 35
-112 35
-111 35
-110 35
-109 35
-108 35
-107 35
-106 35
-105 35
-104 35
-103 35
-102 35
-101 35
-100 35
-99 35
-98 35
-97 35
-96 35
-95 35
-94 35
-93 35
-92 35
-91 35
-90 35
-89 35
-88 35
-87 35
-86 35
-85 35
-84 35
-83 35
-82 35
-81 35
-80 35
-79 35
-78 35
-77 35
-76 35
-75 35
-74 34
-73 34
-72 34
-71 34
-70 34
-69 33
-68 33
-67 33
-66 33
-65 33
-64 32
-63 32
-62 32
-61 32
-60 32
-59 31
-58 31
-57 31
-56 31
-55 31
-54 30
-53 30
-52 30
-51 30
-50 30
-49 29
-48 29
-47 29
-46 29
-45 29
-44 28
-43 28
-42 28
-41 28
-40 28
-39 27
-38 27
-37 27
-36 27
-35 27
-34 26
-33 26
-32 26
-31 26
-30 26
-29 25
-28 25
-27 25
-26 25
-25 25
-24 24
-23 24
-22 24
-21 24
-20 24
-19 23
-18 23
-17 23
-16 23
-15 23
-14 22
-13 22
-12 22
-11 22
-10 22
-9 21
-8 21
-7 21
-6 21
-5 21
-4 20
-3 20
-2 20
-1 20
0 20
1 20
2 20
3 20
4 20
5 19
6 19
7 19
8 19
9 19
10 18
11 18
12 18
13 18
14 18
15 17
16 17
17 17
18 17
19 17
20 16
21 16
22 16
23 16
24 16
25 15
26 15
27 15
28 15
29 15
30 14
31 14
32 14
33 14
34 14
35 13
36 13
37 13
38 13
39 13
40 12
41 12
42 12
43 12
44 12
45 11
46 11
47 11
48 11
49 11
50 10
51 10
52 10
53 10
54 10
55 9
56 9
57 9
58 9
59 9
60 8
61 8
62 8
63 8
64 8
65 7
66 7
67 7
68 7
69 7
70 6
71 6
72 6
73 6
74 6
75 5
76 5
77 5
78 5
79 5
80 5
81 5
82 5
83 5
84 5
85 5
86 5
87 5
88 5
89 5
90 5
91 5
92 5
93 5
94 5
95 5
96 5
97 5
98 5
99 5
100 5
101 5
102 5
103 5
104 5
105 5
106 5
107 5
108 5
109 5
110 5
111 5
112 5
113 5
114 5
115 5
116 5
117 5
118 5
119 5
120 5
121 5
122 5
123 5
124 5
125 5
126 5
127 5
128 5
129 5
130 5
131 5
132 5
133 5
134 5
135 5
136 5
137 5
138 5
139 5
140 5
141 5
142 5
143 5
144 5
145 5
146 5
147 5
148 5
149 5
150 5
151 5
152 5
153 5
154 5
155 5
156 5
157 5
158 5
159 5
160 5
161 5
162 5
163 5
164 5
165 5
166 5
167 5
168 5
169 5
170 5
171 5
172 5
173 5
174 5
175 5
176 5
177 5
178 5
179 5
180 5
181 5
182 5
183 5
184 5
185 5
186 5
187 5
188 5
189 5
190 5
191 5
192 5
193 5
194 5
195 5
196 5
197 5
198 5
199 5
200 5

So yeah it's not really ELO rating but i didn't know how to call it. Maybe FROG rating? Or FRUST rating?

If someone have the formula i am interested

Formula for ELO is:

R' = R + K(1 - (1 / (1 + 10^(Ro - R))))

where R is the previous rating, and Ro is what im using for the opponents rating.

K is a constant. The Internation chess federation uses K = 30 (when a player has < 30 games played). Then it uses K = 15 (For rating < 2400) or K = 10.

So for example, Nirvana vs. Light would be:

After game 1 (for nirvana) 2000 + 30 (1 - 1(1 + 10^(2000-2000))) = 2030.
And for Light would be 1970.

So After game 2 (for nirvana) 2030 + 30(1 - 1(1+10^(1970 - 2030))) = 2042.435
And for Light (1970 + 30 (1 - 1(1 + 10 ^ (2030 - 1970))) = 1957.565

I was actually intrigued by Nirvana's comment at some point in the past where he talked about an sc2sea thing like a TLPD. I'd really love to find some time now to write a system where we can upload tournament replays and parse them to find the winner/loser and update an ELO ranking table of tournament games...