US Twink Armory Spreadsheets

Bigbullox

OG
Bigbullox Twinkinfo Spreadsheetsâ„¢ is proud to present a spreadsheet of freshest level 19 armory dataz for :



us.gif
Ruin

eu.gif
Blackout



sorted by CRITTERS KILLED For anti-epeen lols and because the best measure of epic twinking is how many Deeprun Rat's you're killed :)



Ruin US and Blackout EU 19 twink spreadsheet (1.95 MB)



If you only want to view US dataz follow the Excel custom auto-filter instructions later on in this thread.



Still waiting for some guild and realm names for Non Ruin US twinks!



Let me know if you have any problems opening the spreadsheet or spot any errors in the data, it uses hyperlink() functions which aren't available in excel 95.



Shame that the HK and KB data is too unreliable to do anything interesting with. Too many people have more WSG KBs than WSG HKs, e.g.



The World of Warcraft Armory
 
Took a look out of curiosity, very well done!
 
ALLIANCE:

§*<Rèvølútiøn> - Shattered Hand - CONTACT: Diiesel, Holyhek, Bobbo, Bigbadnblue

§*<Bloodlust Represent> - Durotan - CONTACT: Crossword/Ebullient/Grizzlybear

§*<Meat Puppet> - Azgalor - CONTACT:

§*<Partners in Crime> - Arthas - CONTACT: Bðnnie, Stunnashadez

§*<Prodigy> - Bloodhoof - CONTACT: Ertai, Painaid

*<Paragon> - Skullcrusher - CONTACT: Hyfee

*<Dead On Arrival> - Elune - CONTACT:

<Interference> - Zul'jin - CONTACT: Treesixty, Whodeenee, Bences, Mtwink

<Majuc> - Bloodhoof - CONTACT: Prówl





HORDE:

§*<Prodigy> - Bleeding Hollow - CONTACT: Ertai, Painaid

§*<Sit Down> - Arthas - CONTACT: Nzxer, Realek

§*<We Trinket War Stomp> - Zul'jin - CONTACT: Hérø, Hectic

§*<With a Vengeance> - Medivh - CONTACT: Mazurati, Cptheals

§*<be tough no excuses> - Bloodhoof - CONTACT: Tombrady

<False Absolution> - Stormrage - CONTACT: Immensely, Filtér

<Engage> - Elune - CONTACT: Gracob, Vøid, Purgelawl, Trendy

<omg red alert> - Bloodhooof - CONTACT: Oprahlol

<No Mercy> - Argent Dawn - CONTACT: Shfonzy, Scourgé, Zaxíe
 
Grabco said:
ALLIANCE:

§*<Rèvølútiøn> - Shattered Hand - CONTACT: Diiesel, Holyhek, Bobbo, Bigbadnblue

§*<Bloodlust Represent> - Durotan - CONTACT: Crossword/Ebullient/Grizzlybear

§*<Meat Puppet> - Azgalor - CONTACT:

§*<Partners in Crime> - Arthas - CONTACT: Bðnnie, Stunnashadez

§*<Prodigy> - Bloodhoof - CONTACT: Ertai, Painaid

*<Paragon> - Skullcrusher - CONTACT: Hyfee

*<Dead On Arrival> - Elune - CONTACT:

<Interference> - Zul'jin - CONTACT: Treesixty, Whodeenee, Bences, Mtwink

<Majuc> - Bloodhoof - CONTACT: Prówl





HORDE:

§*<Prodigy> - Bleeding Hollow - CONTACT: Ertai, Painaid

§*<Sit Down> - Arthas - CONTACT: Nzxer, Realek

§*<We Trinket War Stomp> - Zul'jin - CONTACT: Hérø, Hectic

§*<With a Vengeance> - Medivh - CONTACT: Mazurati, Cptheals

§*<be tough no excuses> - Bloodhoof - CONTACT: Tombrady

<False Absolution> - Stormrage - CONTACT: Immensely, Filtér

<Engage> - Elune - CONTACT: Gracob, Vøid, Purgelawl, Trendy

§*<omg red alert> - Bloodhooof - CONTACT: Oprahlol

<No Mercy> - Argent Dawn - CONTACT: Shfonzy, Scourgé, Zaxíe

§*<Waw Tawent> - Bleeding Hollow - CONTACT: Pizza
Click to expand...

Fixed .
 
Grabco said:
ALLIANCE:

§*<Rèvølútiøn> - Shattered Hand - CONTACT: Diiesel, Holyhek, Bobbo, Bigbadnblue

§*<Bloodlust Represent> - Durotan - CONTACT: Crossword/Ebullient/Grizzlybear

§*<Meat Puppet> - Azgalor - CONTACT:

§*<Partners in Crime> - Arthas - CONTACT: Bðnnie, Stunnashadez

§*<Prodigy> - Bloodhoof - CONTACT: Ertai, Painaid

*<Paragon> - Skullcrusher - CONTACT: Hyfee

*<Dead On Arrival> - Elune - CONTACT:

<Interference> - Zul'jin - CONTACT: Treesixty, Whodeenee, Bences, Mtwink

<Majuc> - Bloodhoof - CONTACT: Prówl





HORDE:

§*<Prodigy> - Bleeding Hollow - CONTACT: Ertai, Painaid

§*<Sit Down> - Arthas - CONTACT: Nzxer, Realek

§*<We Trinket War Stomp> - Zul'jin - CONTACT: Hérø, Hectic

§*<With a Vengeance> - Medivh - CONTACT: Mazurati, Cptheals

§*<be tough no excuses> - Bloodhoof - CONTACT: Tombrady

<False Absolution> - Stormrage - CONTACT: Immensely, Filtér

<Engage> - Elune - CONTACT: Gracob, Vøid, Purgelawl, Trendy

<omg red alert> - Bloodhooof - CONTACT: Oprahlol

<No Mercy> - Argent Dawn - CONTACT: Shfonzy, Scourgé, Zaxíe
Click to expand...



Cheers Grab (edit: and Nova) the BigbulloxBot has started leeching US twink armories, check this thread tomorrow for a US spreadsheet :)



Still looking for more people to gather wsg battleground data for another twink data project I'm working on, offering 2 tabard loot card codes as prizes for people who install a mod, finish a couple of bg's and send me a file so I can build the uploader, details in this thread :



http://twinkinfo.com/forums/10-19-bracket/7655-help-wanted-recording-wsg-stats-twinkinfo-users.html
 
Nooooo i need to log out in my Ret gear!!!





Alliance:

Dynásty - Elune should also be included
 
Double post



I am wondering what criteria you are using to determine active twinks because that is a lot of data.



out of 1005 twinks from your data extraction

-If someone doesn't have a glyph I am assuming they are inactive or they don't play

-I am also assuming that "date last modified" (some people haven't logged on since the summer) could be used to determine activity
 
yeah I sorted it by falling deaths descending for the lols > epeen factor ;)



Everyone knows how to use excel's data -> sort to sort on a column, but some people may not know how to setup a custom auto filter.



E.g. If you want to view a list of twinks who've won MORE than 100 wsg :



1. Turn Autofilter ON using the Data -> Filter -> AutoFilter option



excel_help1.jpg




2. Small triangle dropdown buttons will appear on each column. Select the column(s) you want to filter on, and select custom



excel_help2.jpg




3. Select the filter options you want from the Custom AutoFilter window :



excel_help3.jpg




You can setup as many filters as you like, and do a data sort afterwards.
 
by filtering what is your best estimation of active twinks in EU? also how do you put pictures into the post??
 
Grabco said:
by filtering what is your best estimation of active twinks in EU? also how do you put pictures into the post??
Click to expand...



no idea...o_O theres an active field but I don't know what it means. I'll be storing player and guild summary data each month to show who's improving and by how much so after a month or two we should be able to see who's active.



I'm looking forward to calculating how twinks and guilds change over time the most of all. Lists of kills and win%'s are great but a bit epeeny for my liking. The twink who improves their stats the most over the next month gets as much respect and kudos from me as the person at the top of a kills list / wsgwin% list.
 
Eurys said:
You could also query armory data by parsing the armory's XML output, and then generating an XLS file for excel via PHP.



Some helpful links, if you're so inclined:



World of Warcraft Armory xml Grabber with cURL - TalkPHP

PHP Simple Excel File Generator | Get PHP Simple Excel File Generator at SourceForge.net
Click to expand...



Thanks for the info. The BigBulloxBot uses modified phparmory classes and curl to fetch the armory data. More info on phparmory :



phpArmory 0.4.1 – “Call to Arms” released - Marenkay.com



The version on sourceforge is a little old.



Am very interested in the the .XLS creator, I played around with .csv files but excel refuses to deal with accented / multibyte characters when opening .csv files.



Will look at PHP Simple Excel File and if it deals with names like rástámán (ARGGHHH!!! curse you and your accented characters! lol) properly then I'll use it on a website I'm building atm to host all this armory and battleground dataz.



If you'd like to help I can setup an SVN repository if you promise not to laugh at my cowboy code...
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 4 (members: 0, guests: 4)
Top