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

[Peleus]

We only did what we did because clearly we wanted to stand out from the crowd.

[TAEdarus]

Loving this information!
Would be sexcellent to see it for all the leagues if someones keen in doing it.

[FaDeBadger]

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

[Roz]

the stats clearly shows Hong Kong is the strongest

[cRSenSei]

Korea da worst!! -_-

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

[Nemo]

His visa problems to Korea have been solved ?

[zendex]

Originally Posted by Nemo

His visa problems to Korea have been solved ?

About that, we can try for application again on July this year.

[NDG.Stitch]

Oh dayum, Hong Kong looks mighty fine.

[Frogmite]

Little bit late this week but still counts!

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

Statistics after week 4

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

Quick Comments

	Maynarde:	Nice
	FSBenAD:	This is excellent each week :D
	ZC.EvilSWAT:	Zerg seems very powerful. Creepy. *BadumTss*
	TACeeSerps:

[Maynarde]

^ Zerg imba?

[ZC.EvilSWAT]

Originally Posted by Frogmite

ELO Progression by races


Winrate Progression by races

As we can see, the method to win in any competition is to use Zerg.

[Frogmite]

Please find below the statistics after week#6 of Sharn Kemp premier league. Some games are missing to be played.

Statistics after week 6

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

[Frogmite]

Please find below the statistics after week#7 of Sharn Kemp premier league. Also welcome our two new weekly graphs: Mister Country ELO progress and Miss Country Winrate progress!

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

Quick Comments

	SungInSPR:
	nirvAnA:

[SungInSPR]

Originally Posted by Frogmite

Please find below the statistics after week#7 of Sharn Kemp premier league. Also welcome our two new weekly graphs: Mister Country ELO progress and Miss Country Winrate progress!

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

Finally, i got into top 10

Quick Comments

Nemo:

wp ! :)

[ToRSpartaz]

Cant wait to see in this league :P top players ranking will be soon to be stacked with New Zealand players

[aLtMrFool]

What's that rainbow clan?

[ToRSpartaz]

Originally Posted by aLtMrFool

What's that rainbow clan?

That be Clan Iris yo up and coming NZ Team ^_^

[Strafe]

Dutch ELO #1.

[dippa]

******* zerg :|||||||

[TAEdarus]

Originally Posted by Frogmite

ELO/Winrate by race

Been watching this for weeks... Zerg imba!