So at the start of this expansion I made a Google spreadsheet for my guild to keep track of things like weekly AP gains and World Quests / Dungeons completed, since I did not feel like there was anything out there that did the job well. I have received positive feedback on it so I figured I would share it, for whoever is still looking for a simple but in-depth overview of their guild. You can look at an example populated version here:
https://wowaudit.com/demo
If you want to make a copy, you can use this link. What the spreadsheet shows is the following:
- A summary sheet with everyone's traits (main spec or currently logged out spec), item level (either currently equipped or highest ever equipped), weekly or all-time World Quests/Dungeons completed, and weekly Artifact Power obtained (from Wednesday to Wednesday)
- A roster sheet where you can see your role distribution, including tier tokens and armor type.
- An overview sheet with more extensive stats of all your raiders, including rankings for each statistic.
- A single view sheet where you can look at the gear of individuals, which dungeons they have done, how many tier pieces they have, their enchants, which legendaries they have (it will remember and store legendaries that people have logged out with)
Since Google spreadsheets can become really slow and sluggish if you perform API calls from within the spreadsheet, and it is not realistic to have it store historical data of all your raiders, there are no API calls made from the spreadsheet itself. Character data is refreshed intermittently externally, and the spreadsheet simply displays the data. You just fill in your guild's key in the spreadsheet and it will start displaying your guild's data once the first API call is made (you can create a key here).
I hope some of you find this useful!
EDIT: There is quite a substantial amount of guilds being created, don't be alarmed if your added characters stay on 'pending' status for a while - they have been added to the queue to be tracked and will keep being tracked intermittently. Just enter your key in your spreadsheet copy and after a while the data will be there.
EDIT2: For those who are confused, creating a guild on the website does not mean your members will automatically be tracked. You have to manually add the members you want to be tracked in the next section after creating a guild.
EDIT3: I set up a Discord server in case you have any questions it will be faster if you ask them there. https://discord.gg/86eUAFz