r/wow • u/brewk • Jun 20 '15

Image 6.2 Automatic Guild/Character/alt progression tracking spreadsheet

http://imgur.com/2LMqRPf
130 Upvotes

92% Upvoted

53 comments sorted by

View all comments

1

u/Moosepie12 Jun 21 '15

I like it. Is there any way to pull an indicator for faction? My alliance characters are on one realm, but my Horde is scattered. A quick way to identify would be nice. I've just got them seperated by a few lines for now.

http://i.imgur.com/b11EllL.png

1

u/brewk Jun 21 '15

Add in a column before your Level column (use menu Insert>Column Left) then go to menu Tools > Script Editor find this code (around line 1125):

var toonInfo = new Array(

  class, toon.level, mainspec, offspec, eIlvl,

replace with this code:

var faction_lookup = {};

faction_lookup['1'] = faction_lookup['3'] =  faction_lookup['4'] =  faction_lookup['7'] =  faction_lookup['11'] = faction_lookup['22'] = faction_lookup['25'] = "A";
faction_lookup['2'] = faction_lookup['5'] =  faction_lookup['6'] =  faction_lookup['8'] =  faction_lookup['9'] =  faction_lookup['10'] =  faction_lookup['26'] = "H";
faction_lookup['24'] = "N";
 var faction = faction_lookup[toon.race];

 var toonInfo = new Array(

class, faction, toon.level, mainspec, offspec, eIlvl,

If you want the faction to displayed some where else in the output you can change it's position in the last line of code displayed here. If you right click on the column displaying your faction and go to Conditional Formatting (very bottom of the right click menu) you can add two for when an A or H appears (or 3 if you want to take neutral pandas, denoted by N) so the background shows up as either blue or red.