• Log InLog In
• Register

Proleague Statistics Spreadsheet

Post a Reply

vx70GTOJudgexv United States3161 Posts December 07 2011 13:37 GMT #1 I've been wicked bored lately, so I've been working on a Google Docs spreadsheet with all sorts of (basic) statistics from Proleague. I'm not a math whiz or a statistics kid (never took a stats class) so this is mostly win/lose stuff and winning percentages more than anything, but it's a lot in one place, and I figured I'd share with everyone since all alone I can only do so much with it. LINK I update it pretty much every morning after the matches when I get home from work (7-8 AM EST). The only time it'll take a bit longer to update is CJ matches, because I like to watch the games unspoiled. Everyone else I usually just re-watch after updating this. If you have a request I'll see what I can do, I have some other ideas for when I have enough time to fool around with it.

chaosTheory_14cc Canada1270 Posts December 07 2011 14:02 GMT #2 Don't have time to take a close look at it right now, but seems like a good idea. Good job.

Holgerius Sweden16951 Posts December 07 2011 14:35 GMT #3 Looks quite comprehensive, nice nice.

REDBLUEGREEN Germany1903 Posts December 07 2011 14:36 GMT #4 I gathered recommended games data in one season of GSL to see who where the fun players to follow. Now I started to do the same thing for this PL season. I took all the 'yes' votes percentages and divided them by the number of games So far this is pretty useless though

xccam Great Britain1150 Posts December 08 2011 13:09 GMT #5 REDBLUEGREEN. That is a chart i would be very interested in seeing and kept updated! is your forumla correct? you have neog soulkey as 68 when it should be 83. (69+97)/2 is not 68...

Crisium United States1618 Posts December 08 2011 23:05 GMT #6 Nice stuff man. I absolutely love statistics like this. I caught a map stat error, and this is prior to CJ vs Khan, there have been 7 ZvZ. Your missing another one on Outlier. Besides that I guess you just need to completely update CJ vs Khan, since you have Effort vs Jangbi counted for the map stats, but not the rest of the matches. On the player stats, you also gave Effort his 3rd win, but not JangBi his first loss, which is odd since those stats should have been imputed simultaneously. I'm sure you'll get it all good, but I recommend you do all of a match at once and not break it up otherwise you may forget. I like to do statistics as well and that's just something that works well for me. Keep it up!

vx70GTOJudgexv United States3161 Posts December 09 2011 13:12 GMT #7 Yeah I kinda goofed yesterday, fell asleep midway through Set 2 of CJ and KHAN and never got around to updating it yet (woke up just in time for work last night). This will be fixed up soon.

miercat 394 Posts January 07 2012 21:45 GMT #8 Thanks. Will you be doing R2 of 2011 proleague?

sviatoslavrichter United States164 Posts January 07 2012 22:17 GMT #9 Hey if you remake this with a pivot table, it will come out much better. PM for excel techniques

FlaShFTW United States10149 Posts January 07 2012 22:20 GMT #10 Not bad. I like it. Will be keeping up-to-date with this. You should make graphs though...

Epocalypse Canada319 Posts January 08 2012 00:46 GMT #11 too cluttered. you need to learn the art of spreadsheets asap

fabiano Brazil4644 Posts January 08 2012 00:56 GMT #12 I bet this is the kind of thing the coaches have on those papers they take to the matches. And fucking Flash, he's a beast. The other team players must pray everyday to not get sent out on Electric Circuit because thats Flash's Garden And Outlier is Hydra's Garden...

Please log in or register to reply.