Jump to content
FORUMS
Sign in to follow this  
Lockybalboa

Automated Raid-wide Item Tracking/Audit Google Sheet (updated for Legion)

Recommended Posts

HERE IS THE SPEADSHEET please make a copy and edit as needed for your guild.


Simple...ish spreadsheet to automate the tracking of your raid's gear, enchants, and artifact traits(NYI). Some color coding is also automatically done. Documentation for how to use the sheet is on the second tab of the sheet.
Works off of a Google script, I was given the OG script/spreadsheet in very early WoD so I have no idea who wrote it first (if anyone knows please tell me so I can credit their work). As far as I know the OG writer did not update it for Legion so I took it upon myself to do so for my guild. Since it is mostly ready for publication I thought I'd share it here in case it helps anyone else also.
The artifact trait tracking is not yet implemented due to the fact that I just don't know how the code will work. I won't be able to add this part into the sheet until Blizzard releases API documentation on the new functions or Legion goes live and I can see how it works on a real artifact.
The names in the sheet are just my toons from across a couple of servers so people can see how it works.

Share this post


Link to post
Share on other sites

Don't know whether you you meant this, Locky. It looks like the same idea but I really don't have a clue. 

Edit: just tried for my toons - wouldn't work. I'm on EU and it gives an error  ErrorRequest failed for https://us.api.battle.net/wow/character/Argent Dawn/Pandacho?fields=items%2Cmounts%2Cguild&Slocale=en_US&apikey=3nkgy6fys34hnhmuuefj6y9z37xvfxw2 returned code 404. Truncated server response: {"status":"nok", "reason": "Character not found."} (use muteHttpExceptions option to examine full response) (line 14).

Share this post


Link to post
Share on other sites

Hi, slightly confused by this. How is it automated? Just that it calculates averages or is there a script/addon to combine with this that automatically inspects people and adds data?

Share this post


Link to post
Share on other sites

Not used it myself, so I can't give you an answer unfortunately Lieghton. Hopefully Locky or someone that uses it can help out.

Share this post


Link to post
Share on other sites

I use it.

I'm not sure what does it mean "it calculates averages". It fetches data from the Armory to file so you don't have to check your raiders Armory one by one.

Locky described what it's doing his first post: "spreadsheet to automate the tracking of your raid's gear, enchants, and artifact traits"  and it's exactly this.

  • Like 1

Share this post


Link to post
Share on other sites

Does this still work for EU? I keep getting an error as TOON REALM NOT DEFINED. What am i doing wrong ? @Lockybalboa

Edited by Chilltax

Share this post


Link to post
Share on other sites

It works and updates the toons on EU, I checked right now.

UPD: the copy that I made for my guild in September still works fine, though the one linked in Locky's post does not.

Share this post


Link to post
Share on other sites

Someone messed with the code.

Go to Tools>Script editor... and replace the lines 7-14 with this :

function pull(toonName,toonRealm) {
 
  if(!toonName || !toonRealm) {
   return ""
  }
  toonRealm.replace(/\s+/g,"%20");
 
  var toonJSON = UrlFetchApp.fetch("https://eu.api.battle.net/wow/character/"+toonRealm+"/"+toonName+"?fields=items%2Cmounts%2Cguild&Slocale=en_GB&apikey=3nkgy6fys34hnhmuuefj6y9z37xvfxw2") 

 

Edited by Nap

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...