[Frogmite]

Sharn Kemp SEA Premier League
STATISTICS

Writing a small thread in case you guys love statistics:

[center]

+ [SEACL] +

Teams/players stats

Number of teams: 10
Number of players: 99
Average number of players per team: 9.9
Largest team: 13 players (aLt, ToT, Eve)
Smallest team: 7 players (MiTH, Herocraft, xGKing)
Number of games to be played:225 matchs, so between 450 and 675 games!
Estimated hours of casting: 3hours*2 games a week* 9 weeks = 54 hours of Benji

Countries represented

Races played

Other stats

Highest ranked player of the division: RyooMakSPR
Lowest ranked player of the division: MskiDane ()
Player with the biggest axe:xGKingIaguz
Player with the longest name of the division: xGKingPokerface
Flag bearers: TargA, Strafe,Roz
Most handsome player of the division: mOOnGlade
Biggest points at scrabble with a player name:GviewHaDeZ (36 points)
TEAM ELO RATING/WIN RATE

Statistics after week 7

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


Winrate Progression by country


ELO Progression by country


THIS THREAD WILL BE UPDATED WEEKLY

Quick Comments

	nirvAnA:	soooooo awesome!!! Most handsome = Jabito yo!
	TCPLemminks:	Stats!
	Zealo:	♥ stats
	asdfSchnitzel:	AH HA! NOW WE KNOW WHICH RACE IS OP!
	TAriiChard:
	Strafe:	i love these things. I think it will be great to check stats third or 4th week in
	RicocheT:	So much hard work!!! Deserves Rep!
	AlopexToT:
	x5.Revenant:	Statistics. Love 'em~
	Nemo:	T'es fou de faire ces trucs haha. C'est énorme. :)
	ToRSmotPokingFish:
	simon:	nice stats
	TCPKiaSu:
	lolwut:
	MskiJaBiTo:	Yay. Thanks nirvAnA. At least I won something. :)) <3

[Peleus]

Awesome, thanks for taking the time to do an interesting thread like this.

[nirvAnA]

Originally Posted by Frogmite

Player that you have to explain me why he play on SEA: JuanMarco

HAHAHA yea i was gonna ask who is the mexico player and what team is he from?

[Frogmite]

Originally Posted by nirvAnA

HAHAHA yea i was gonna ask who is the mexico player and what team is he from?

In fact JaFF just PM me, it was a mistake from him when he gave me the roster. The guy is from Philippines. I'll update later.

[iM MaFia]

he doesn't go by major or princess or something i hope!
edit: nvm.. idk how you can get phillipines and mexico mixed up though

[Maynarde]

Jabito more handsome than Glade? What're you smoking nirvAnA :P

[AxSGRiM]

lol! xSixWinDy in the SEACL

[mGGDaedalus]

Awesome job frogmite! Maybe this can be the start of SC2SEA's version of TLPD

[inFeZa]

JuanMarco?
Juan (first name) is windy/major/terran/cuteangel....
ಠ_ಠ

[foxmeep]

Originally Posted by SQLTt.inFeZa

JuanMarco?
Juan (first name) is windy/major/terran/cuteangel....
ಠ_ಠ

Pretty sure Juan is the first name of 95% of Mexico :P

Quick Comments

Frogmite:

i like percentages

[crAzerk]

Man those graphs look pretty sweet ^^

[nirvAnA]

I actually already got in touch with a coder whos interested to do up our own version of TLPD for under $200 lets see how that goes

[Frogmite]

I did some updates to the original post.

I will continue to update every week after the games.

Most of stats/graphs only make sense after one game is played so there will be lots of stuff next week!

[Frogmite]

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

Statistics week 1

ELO/Winrate by country


ELO/Winrate by race



ELO/Winrate by teams


ELO ranking by players


ELO Progression by team

Quick Comments

	Dox:	That is freaking sexy. Nice work!
	Zealo:	awesome! does every league get this?

[Benji]

Cool graphs, can't wait for a few more weeks to pass and we can see some better stats with the increased amount of data

[|Erasmus|]

What formula are you calculating ELOs with. AFAIK the chess system is standard, and it uses K values of 30 for initial games, and still uses 15 rather than 10 for games where the player has an MMR under 2400 (to stop it blowing out at the top end).

Based on nirvana's new ELO being 2010 after 2 wins against a roughly even opponent, you used a K value of 5 and then didn't do it per game, specifically, or somtehing?

Seems like a really weird and non-standard ELO calculation... O_o

[Frogmite]

Originally Posted by |Erasmus|

What formula are you calculating ELOs with. AFAIK the chess system is standard, and it uses K values of 30 for initial games, and still uses 15 rather than 10 for games where the player has an MMR under 2400 (to stop it blowing out at the top end).

Based on nirvana's new ELO being 2010 after 2 wins against a roughly even opponent, you used a K value of 5 and then didn't do it per game, specifically, or somtehing?

Seems like a really weird and non-standard ELO calculation... O_o

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

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

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

[Dox]

Love your work.