8 years ago
The Ultimate Guild Activity / Raid Tracker [Feedback Encouraged]
Hey SWGOH Community!
Madducks here from Defective Clones. I'd like to get your feedback on a relatively comprehensive 'Guild Activity Tracker' (or whatever you want to call it) that I've put together.
Defective Clones Tracker <---- Click the link to check it out!
The tracker accurately captures the following:
Daily Ticket Counts (Not based on in-game daily tickets, which is bugged)
Lifetime tickets
Raid Damage for the past 7 H Rancor and N AAT raids.
Average DPR (Damage per raid)
Variance from average and previous DPR values.
Conditional formatting marking highs and lows.
Conditional formatting marking each respective members' career personal best in Rancor and AAT.
Various accolades like; most improved, weekly MVP, and etc.
'Get out the boot' evaluation to determine who is on the chopping block.
For the rest of you data junkies out there that keep similar data to track your guild's performance in the interest of making progress, I'm hoping to accomplish the following with this post:
Share my approach with hopes that someone my find it useful for their own guild. Plagiarizer away! I just ask that you share the love if you make improvements for yourself.
Collect feedback on what I might be missing that could improve my data set.
For folks that are savvy with Google Sheets functions, I'd love to hear about any improvements you'd make to reduce manual data input if you go as far as to evaluate the functions I'm using presently (simple stuff, just VLOOKUP, IFERROR, etc.)
Finally, if anyone is familiar with a way I can extract data from the game's database (in an approved way, of course) to automate/simplify some of my reporting tasks, I'd love to hear about it!
Hoping to see some constructive feedback (good or bad)!
Thanks!
Angrywaterfowl
Account 1
Account 2
Madducks here from Defective Clones. I'd like to get your feedback on a relatively comprehensive 'Guild Activity Tracker' (or whatever you want to call it) that I've put together.
Defective Clones Tracker <---- Click the link to check it out!
The tracker accurately captures the following:
For the rest of you data junkies out there that keep similar data to track your guild's performance in the interest of making progress, I'm hoping to accomplish the following with this post:
Hoping to see some constructive feedback (good or bad)!
Thanks!
Angrywaterfowl
Account 1
- In-Game Name: Madducks
- Ally Code: 729-963-117
Account 2
- In-Game Name: Madducks1 (new alt account)
- Ally Code: 455-719-586