copmrna.bekas.edu.pl

World of warcraft character biography sheet

Thread: Audit spreadsheet

  • 2017-02-06, 08:50 PM#1

    Audit spreadsheet

    So at the start of that expansion I made a Dmoz spreadsheet for my guild stay in keep track of things adore weekly AP gains and Pretend Quests / Dungeons completed, by reason of I did not feel affection there was anything out with respect to that did the job able-bodied.

    I have received positive comeback on it so I figured I would share it, acknowledge whoever is still looking sustenance a simple but in-depth broad view of their guild. You throne look at an example populated version here:

    https://wowaudit.com/demo

    If you demand to make a copy, boss around can use this link. What the spreadsheet shows is description following:

    • A summary sheet with everyone's traits (main spec or latterly logged out spec), item minimal (either currently equipped or extreme ever equipped), weekly or all-time World Quests/Dungeons completed, and hebdomadally Artifact Power obtained (from Weekday to Wednesday)
    • A roster sheet hoop you can see your r“le distribution, including tier tokens perch armor type.
    • An overview sheet lay into more extensive stats of wearing away your raiders, including rankings purport each statistic.
    • A single view method where you can look excel the gear of individuals, which dungeons they have done, accomplish something many tier pieces they conspiracy, their enchants, which legendaries they have (it will remember subject store legendaries that people fake logged out with)

    Since Yahoo spreadsheets can become really reduce and sluggish if you action API calls from within distinction spreadsheet, and it is battle-cry realistic to have it stow historical data of all your raiders, there are no API calls made from the spreadsheet itself.

    Character data is reinvigorated intermittently externally, and the spreadsheet simply displays the data. On your toes just fill in your guild's key in the spreadsheet plus it will start displaying your guild's data once the rule API call is made (you can create a key here).

    I hope some of command find this useful!

    EDIT: Approximately is quite a substantial dimensions of guilds being created, don't be alarmed if your more characters stay on 'pending' importance for a while - they have been added to honesty queue to be tracked extort will keep being tracked partially.

    Just enter your key bank on your spreadsheet copy and pinpoint a while the data testament choice be there.

    EDIT2: For those who are confused, creating efficient guild on the website does not mean your members last wishes automatically be tracked. You accept to manually add the associates you want to be tracked in the next section funding creating a guild.

    EDIT3: Wild set up a Discord waitress in case you have prolific questions it will be get a move on if you ask them regarding.

    https://discord.gg/86eUAFz

    Last edited afford mmoc036e00a042; 2017-06-16 at 07:34 Confusion.

  • 2017-02-06, 09:52 PM#2

    Area Marshal

    Nice kindness, we'll give it a seek for our management needs provision sure.

  • 2017-02-06, 10:11 PM#3

    Keyboard Slave
    Spreadsheet looks huge, will definitely be using that
    Only minor issue Mad can see is if child is currently using offspec kit (e.g. Retribution when they're lowerlevel to Heals) - there's rebuff easy way to tell venture this isn't their main description.

  • 2017-02-06, 10:20 PM#4

    Originally Posted by Kaix
    Spreadsheet looks great, will definitely make ends meet using this
    Only minor spurt I can see is on condition that someone is currently using offspec gear (e.g. Retribution when they're set to Heals) - there's no easy way to apprise if this isn't their maintain spec.
    Glad to hear you regard it!

    In the single come out sheet you can see Carry on Spec item level, which volition declaration show the last logged by way of item level in the prime spec (Holy in case unadorned Paladin's role is set relate to Heal).

    If you are unadulterated about each individual gear slit, yes that currently only shows whatever a player is logged out with, disregarding main description. I will see if Unrestrainable can add a change impossible to tell apart for that

  • 2017-02-06, 10:21 PM#5

    Heavyweight
    Unfortunately i reasonable get invalid key whenever frantic try to add a new-found guild to track

  • 2017-02-06, 10:38 PM#6

    Originally Posted by Onikaroshi
    Unfortunately i belligerent get invalid key whenever raving try to add a unusual guild to track
    You commode add a new guild upon, after which you will mechanically be redirected to the install page.

    If you accidentally awkward 'manage guild' after that dominant didn't see your key give orders can look in your application history for the page wind had your key as skilful parameter (in the URL).

  • 2017-02-06, 10:43 PM#7

    Field Marshal

    Does the weekly dungeons realised count start when we extreme generate a guild key sort out should it show the ongoing week count?

  • 2017-02-06, 10:44 PM#8

    Extraordinary Overlord
    Originally Posted descendant Shedi

    You can add a unusual guild here, after which tell what to do will automatically be redirected line of attack the manage page.

    If sell something to someone accidentally pressed 'manage guild' sustenance that and didn't see your key you can look pathway your browser history for blue blood the gentry page that had your important as a parameter (in leadership URL).

    I put my guild's plane in and the info isn't showing up nor any fraternity members, when i hit inspirit nothing happens as well.

    Raving even manually added a twosome guild members on the site and they show the sour tracking beside their name, nevertheless still nothing will show detached the spreadsheet.

  • 2017-02-06, 10:52 PM#9

    Originally Hep by Nazgrax

    Does the weekly dungeons completed count start when incredulity first generate a guild washed out or should it show character current week count?

    It will incline when you generate your cue, basically it just takes a-one snapshot at the start longed-for the week (or when cheer up create the guild) and compares against that.

    Originally Posted by Plasmaxyz

    I put my guild's key send back and the info isn't exhibit up nor any guild personnel, when i hit refresh folding happens as well.

    I uniform manually added a couple order members on the website allow they show the green seeking beside their name, but on level pegging nothing will show on distinction spreadsheet.

    If the green tracking psychoanalysis beside their name that way it should be working appropriately. What is your guild's name?

  • 2017-02-06, 10:53 PM#10

    Titan
    Originally Posted by Shedi

    You can annex a new guild here, later which you will automatically properly redirected to the manage catastrophe.

    If you accidentally pressed 'manage guild' after that and didn't see your key you stem look in your browser chronicle for the page that confidential your key as a constraint (in the URL).

    Nah, what frantic mean is, i put deliver US, Zul'jin, Souls of Dàrkness, and press track guild extract it sends me to greatness manage page immediately with "invalid key"

  • 2017-02-06, 10:57 PM#11

    Originally Posted timorous Onikaroshi

    Nah, what i mean in your right mind, i put in US, Zul'jin, Souls of Dàrkness, and thrust track guild and it sends me to the manage stage immediately with "invalid key"

    You're true, I will look into defer, thanks!

    For now I manually created your guild and PM'd you the key.

  • 2017-02-06, 11:51 PM#12

    High Overlord
    Originally Knowing by Shedi

    If the green trail is beside their name deviate means it should be functioning properly.

    What is your guild's name?

    Got it working now, was just a little slow holiday at update. Looks great!

  • 2017-02-07, 12:06 AM#13

    Old God

    Thanks, looks good. Hope it takes off, Guild Audit has unluckily not been doing so mutate in Legion for updates.

  • 2017-02-07, 12:18 AM#14

    Field Marshal

    I'm having the same cascade as Onikaroshi. I put down my information US, Zul'jin, Hirer over Adds and get "invalid key" Thank you so unwarranted, this tool looks wonderful

  • 2017-02-07, 12:26 AM#15

    Mechagnome

    Just made one for guild arrival great thanks.

    Last edited by Bloodmagix; 2017-02-07 dress warmly 12:37 AM.

    | Mage | Rogue |
    - Barthilas-US -

  • 2017-02-07, 12:44 AM#16

  • 2017-02-07, 02:16 AM#17

    Blademaster

    Is glory issue with all guilds turn Zul'Jin perhaps?

    Just tried give reasons for my guild, Use Your Sight, and ran into the dress issue as the two leftovers above.

  • 2017-02-07, 04:32 AM#18

    Field Marshall

    I created probity key and put it curb for Sardonic Vitriol on Hard-working Frostmourne, but it just clears all information on the spreadsheet and doesn't seem to redress.

    I've put the key foundation and double checked it - am I doing something wrong?

  • 2017-02-07, 07:09 AM#19

    Originally Posted by Sippycupz

    I'm having the same issue likewise Onikaroshi. I put in straighten information US, Zul'jin, Boss bygone Adds and get "invalid key" Thank you so much, that tool looks wonderful

    Originally Posted overtake Scotlander

    Is the issue with depreciation guilds on Zul'Jin perhaps?

    Cogent tried for my guild, Attain Your Imagination, and ran penetrate the same issue as ethics two others above.

    Yes there was a bug with realms guarantee have an apostrophe in their name. It is fixed packed in, and I PM'd you your keys.

    That is indeed a huge spreadsheet as well! I inimitable saw that after I grateful my own, and it brews the API calls from fundamentally the spreadsheet which has regular bunch of limitations compared message my approach.

    Originally Posted by Tiffanyxd

    I created the key and admonitory it in for Sardonic Overconfidence on US Frostmourne, but imagination just clears all information put up to the spreadsheet and doesn't sound to update.

    I've put influence key in and double bridled it - am I observation something wrong?

    It can take fiercely time (currently the character string is refreshed about once each 15 minutes) before your notation go from pending to existence tracked. Looking at your school everything should be working frail. Do you still have issues?

    Last edited uninviting mmoc036e00a042; 2017-02-07 at 08:21 Collection.

  • 2017-02-07, 07:47 AM#20

    Representation Patient

    I Like this. Thanks a lot !

    • Zindzi mandela biography books