VGC Data Spreadsheet

~~ZachDro~~ · Feb 11th, 2012, 7:08:23 PM

Started this spreadsheet a while back and kept updating it but never really publicized it. It's got the usage stats and the movement in them, and a type chart of all the mons that have been used over 1% of the time on any given week on the Skarmbliss server. Dr. Fidget has been adding a ton of info to it over the last two days and it's looking better than ever!

Feel free to check it out, reference it, etc, it's there for your benefit. I plan on adding a few more things (such as all fully evolved mons, common attack types, best BSTs, etc), if you really want something on there though post it here.

Also if you have any other ideas let me know, I want to add as much as I can to the sheet!

USAGE STAT PAGE- CLICK HERE!

Also, djbeardo made this awesome graph from the usage stats, feel free to view it!

CHECK OUT THE GRAPH- CLICK HERE!

(Note that you need the link to access the spreadsheet on Google Docs)

Drifblim · Feb 11th, 2012, 7:21:49 PM

Neat! if it isn't already possible and I cannot find it, a list from each individual week of the top 50 would be helpful.

~~ZachDro~~ · Feb 11th, 2012, 7:25:38 PM

Quote:

Originally Posted by Fat Drifblim

Neat! if it isn't already possible and I cannot find it, a list from each individual week of the top 50 would be helpful.

I'll post that on another tab, good idea. There hasn't been an update since mid-January so I can't really keep it consistent, but I'll use what's out there.

Dr Fidget · Feb 11th, 2012, 10:55:43 PM

Yay, stat porn! Added a bunch of stats and charts. Including pie charts to show how centralized this year is compared to 2011 and 2010.

KiwiDawg7 · Feb 12th, 2012, 11:06:19 AM

This is all amazing.
Thanks for the work guys!

kinderlew · Feb 12th, 2012, 12:07:14 PM

where the hell is your life going zachdro...

djbeardo · Feb 12th, 2012, 9:31:24 PM

ZachDro - awesome work man! I do love me some data.

I plugged it into a web data visualization service and came up with this:

http://public.tableausoftware.com/vi...heet1?:embed=y

You can change the sliders/check the boxes to isolate individual pokemon. You can also select with your mouse. Double click on an area to zoom in (and hit the home button in the top left to go back to the original view).

The far right item is a % change which shows the absolute change from December 11 to January 15. I thought it was kinda fun to see which ones got more/less popular over time.

HagridTwin · Feb 12th, 2012, 10:41:09 PM

This is crazy good.

Dr Fidget · Feb 12th, 2012, 10:49:41 PM

I'm in the middle of adding a bunch of lesser used Pokemon, hopefully should have everything important by tomorrow.

~~ZachDro~~ · Feb 13th, 2012, 1:35:22 AM

Awesome DJ, thanks for doing that! I'll link it in the OP.

Thank Fidget for his work, he's doing most of the heavy lifting.

I'll get that top 50 list up tomorrow Drifblim. Got too much stuff to do tonight, dat college.

(Also Fidget, I need to figure out how to let you edit the base document, send me your username again on GoogleDocs)

Feb 11th, 2012, 7:08:23 PM	#1
~~ZachDro~~ Banned deucer. Join Date: Apr 2011 Posts: 176 Delete my Smogon account please	VGC Data Spreadsheet Started this spreadsheet a while back and kept updating it but never really publicized it. It's got the usage stats and the movement in them, and a type chart of all the mons that have been used over 1% of the time on any given week on the Skarmbliss server. Dr. Fidget has been adding a ton of info to it over the last two days and it's looking better than ever! Feel free to check it out, reference it, etc, it's there for your benefit. I plan on adding a few more things (such as all fully evolved mons, common attack types, best BSTs, etc), if you really want something on there though post it here. Also if you have any other ideas let me know, I want to add as much as I can to the sheet! USAGE STAT PAGE- CLICK HERE! Also, djbeardo made this awesome graph from the usage stats, feel free to view it! CHECK OUT THE GRAPH- CLICK HERE! (Note that you need the link to access the spreadsheet on Google Docs) Last edited by ZachDro; Feb 13th, 2012 at 1:51:24 AM.

Feb 11th, 2012, 10:55:43 PM	#4
Dr Fidget Join Date: Jun 2010 Posts: 65 Michigan	Yay, stat porn! Added a bunch of stats and charts. Including pie charts to show how centralized this year is compared to 2011 and 2010. Last edited by Dr Fidget; Feb 12th, 2012 at 1:30:20 PM.

Feb 12th, 2012, 11:06:19 AM	#5
KiwiDawg7 Join Date: Sep 2011 Posts: 121 Atlanta, GA	This is all amazing. Thanks for the work guys! __________________ VGC11 Regionals - Atlanta, GA: 3rd Place VGC 11 Nationals - Indianapolis, IN: 9th Place (4th Seed Swiss) VGC12 Regionals - Athens, GA: 10th Place VGC13 Winter Regionals - Lake Buena Vista, FL: 2nd Place VGC 13 Spring Regionals - Athens, GA: 3rd Place

Feb 12th, 2012, 12:07:14 PM	#6
kinderlew Join Date: Sep 2011 Posts: 43 Chicago	where the hell is your life going zachdro... __________________ Kindergang heavy hustle ride or die

Feb 12th, 2012, 9:31:24 PM	#7
djbeardo Join Date: May 2009 Posts: 28 San Diego	ZachDro - awesome work man! I do love me some data. I plugged it into a web data visualization service and came up with this: http://public.tableausoftware.com/vi...heet1?:embed=y You can change the sliders/check the boxes to isolate individual pokemon. You can also select with your mouse. Double click on an area to zoom in (and hit the home button in the top left to go back to the original view). The far right item is a % change which shows the absolute change from December 11 to January 15. I thought it was kinda fun to see which ones got more/less popular over time. __________________ White FC: 3009-8312-1265 Seattle VGC 2010 Top 16 San Diego VGC 2011 LCQ Participant Pleasanton VGC 2012 84 of 178

Feb 11th, 2012, 7:21:49 PM	#2
Drifblim Join Date: Nov 2011 Posts: 549 Brooklyn	Neat! if it isn't already possible and I cannot find it, a list from each individual week of the top 50 would be helpful.

Feb 12th, 2012, 10:41:09 PM	#8
HagridTwin Join Date: Jan 2009 Posts: 71	This is crazy good.

Feb 12th, 2012, 10:49:41 PM	#9
Dr Fidget Join Date: Jun 2010 Posts: 65 Michigan	I'm in the middle of adding a bunch of lesser used Pokemon, hopefully should have everything important by tomorrow.

Feb 13th, 2012, 1:35:22 AM	#10
~~ZachDro~~ Banned deucer. Join Date: Apr 2011 Posts: 176 Delete my Smogon account please	Awesome DJ, thanks for doing that! I'll link it in the OP. Thank Fidget for his work, he's doing most of the heavy lifting. I'll get that top 50 list up tomorrow Drifblim. Got too much stuff to do tonight, dat college. (Also Fidget, I need to figure out how to let you edit the base document, send me your username again on GoogleDocs) Last edited by ZachDro; Feb 13th, 2012 at 1:51:43 AM.