[FaDeBadger]

If Frogmite sends me the spreadsheet that it looks like this was formulated in I'll do it for Tier 3.

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

[Roz]

the stats clearly shows Hong Kong is the strongest

[cRSenSei]

Korea da worst!! -_-

[Dox]

Originally Posted by |Erasmus|

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

That reminds me, I never got around to releasing my parser!

Quick Comments

|Erasmus|:

I was thinking of talking to you about that... :)

[nirvAnA]

Originally Posted by |Erasmus|

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

SEAPD is coming really soon, stay tuned guys

We received some nice donations this month, am gonna whatever balance we have left to help offset the cost of the coding, which is quite a sum. The hardest part for that was finding the ELO formula, which is very tricky and a pain in the butt to calcalute (dont think its possible in excel) so yea erasmus is right on the money, chess uses k=30 now a days instead of k=25 and I managed to find the vb formula for it and i passed it to the coder so all seems good now ^_^

Yea there will be a simple (optional) download link next to each result, so you can download the replay of every game that is recorded in the database (if theres the replay for it). This means you first have to upload the replay on the sc2sea site / dox's replay parser / any other replay site as per normal then just link it. Or maybe erasmus/dox can help whip up a simple uploading option and attach it to the SEAPD system.



Loving the work so far froggy, can't wait to see the stats at the end of the season.

Quick Comments

	Mayo:
	breadfan:	Looking forward to it getting up and running

[Frogmite]

I updated the ELO rating with the formula you gave me Erasmus.

I just think it will be a mess for team leaders and for me to detail a 2-1 score into a 1-0/1-1/2-1 or any different combination.

So what i used is:

New ELO=ELO initial+(number of sets won-number of set loss)*K*(1-(1/(1+10^((ELO opponent-ELO initial)/400)))

With K=30.
It's not 100% true ELO rating but i think it'll be fine for SEACL matters
I updated the OP with the updated ELO ratings

[AvPoker]

nirvana at top of ELO ranking by players.
Clearly biased.

Quick Comments

nirvAnA:

haha thank god it wasnt me who made it or ill never hear the end of it!

[|Erasmus|]

Originally Posted by Frogmite

Biggest points at scrabble with a player name:GviewHaDeZ (36 points)

xgkingjazbas - 43 points.

Quick Comments

Maynarde:

Neeeeeeerd

[Frogmite]

Originally Posted by |Erasmus|

xgkingjazbas - 43 points.

I thought nobody would read that stat
Shame on me but i didn't check all the players score.

[|Erasmus|]

Originally Posted by Frogmite

I thought nobody would read that stat
Shame on me but i didn't check all the players score.

I just saw it and immediately assumed someone on xGKing would have more... especially with Jazbas and Iaguz having a Z in their name (I only checked those two, though).

[Frogmite]

There are two games missing for this week but i still release the statististics for week 2:

Statistics after week 2

ELO/Winrate by country


ELO/Winrate by race


ELO/Winrate by teams


ELO ranking by players


ELO Progression by team


ELO Progression by races


Winrate Progression by races


Winrate Progression by team

Quick Comments

	mGMUSE:
	nirvAnA:
	TACeeSerps:

[Strafe]

I have to spread some reputation around before giving it to you again, but that's damn nice work. Fun to read.

[FaDeBadger]

nirvAnA clearly brought out boss mode for this league.

[VB_WhiplashJC]

Any chance you could sort the tables?

Edit: Looks like some are some are already.

[Frogmite]

Originally Posted by VB_WhiplashJC

Any chance you could sort the tables?

Edit: Looks like some are some aren't.

I sorted the tables, i have some issues with the calculation formulas and the ratings as i put them on the same raws as datas used for other tables.

I sorted them by ELO rating:

Quick Comments

	nirvAnA:	haha that zerg winrate sums up SEA!
	VB_WhiplashJC:

[Frogmite]

Booooom!

Please find below the statistics after week#3 of Sharn Kemp premier league:

Statistics after week 3

ELO ranking by players - TOP 10

+ [Show all the players] +

ELO/Winrate by country


ELO/Winrate by race


ELO/Winrate by teams


ELO Progression by team


ELO Progression by races


Winrate Progression by races


Winrate Progression by team

[nirvAnA]

After EnDerr's 2-0 win over iaguz his current 8-0 record is extremely scary. Note that they were ALL ace matches that he played.

[mGMUSE]

Originally Posted by nirvAnA

After EnDerr's 2-0 win over iaguz his current 8-0 record is extremely scary. Note that they were ALL ace matches that he played.

need to send this guy to GSL

[zendex]

Originally Posted by mGMUSE

need to send this guy to GSL

Personally, I don't think he's ready.

You can root for him this Sunday in IPL and NASL qualifiers.
Hopefully all the SEA players make a good showing in those two (Pig, Mafia, Jazbas are some of the names I came across while scanning the registered players list of both)