Proleague Statistics Spreadsheet

vx70GTOJudgexv

United States3161 Posts

December 07 2011 13:37 GMT

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

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

Looks quite comprehensive, nice nice.

REDBLUEGREEN

Germany1904 Posts

December 07 2011 14:36 GMT

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

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

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

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

Thanks. Will you be doing R2 of 2011 proleague?

sviatoslavrichter

United States164 Posts

January 07 2012 22:17 GMT

Hey if you remake this with a pivot table, it will come out much better. PM for excel techniques

FlaShFTW

United States10474 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 or register to reply.

Proleague Statistics Spreadsheet

Completed

Ongoing

Upcoming