Hi all,
It's almost time for another tier, and that means an update to my raid team gear sheet.
Eden Raid Team Gear Planning (v2.0)
The goal is to have an easy-to-update place to track your raid team's gear as it improves, so questions like "Who should this twine go to?" or "Is this glove coffer free roll?" can be answered at a glance. Colored boxes make visualizing gear easy -- red bad, blue/purple good.
By popular request, I've also created a loot sheet to keep track of exactly which items dropped each week and who received them. You shouldn't need this if everyone accurately updates the gear sheet weekly, but it should serve as a second layer of record-keeping to resolve any questions if there are disagreements or inconsistencies.
(Previous posts for: Eden's Verse, Eden's Gate, Alphascape versions)
Initial Setup - New Users
[link] [comments]
Continue reading...
It's almost time for another tier, and that means an update to my raid team gear sheet.
Eden Raid Team Gear Planning (v2.0)
The goal is to have an easy-to-update place to track your raid team's gear as it improves, so questions like "Who should this twine go to?" or "Is this glove coffer free roll?" can be answered at a glance. Colored boxes make visualizing gear easy -- red bad, blue/purple good.
By popular request, I've also created a loot sheet to keep track of exactly which items dropped each week and who received them. You shouldn't need this if everyone accurately updates the gear sheet weekly, but it should serve as a second layer of record-keeping to resolve any questions if there are disagreements or inconsistencies.
(Previous posts for: Eden's Verse, Eden's Gate, Alphascape versions)
Initial Setup - New Users
- Make your own copy of the linked Google sheet (File > Make a copy...); you'll need a Google account.
- Open your copy and click Share in the upper right.
- Get Shareable link and give the link to your group members, or share it with specific accounts, however you want to do it. Give editing permissions.
- Optional: set sheet protections so your team can't "accidentally" mess up the logic too badly (Data > Protected sheets and ranges... > Sheet > Eden's Promise Gear > check "Except certain cells", enter ranges like so in any order: B1:J1 L1:U1 B3:U24 B30:U51 X27:AB27 X55 ).
- Optional: set permissions to restrict who can edit the loot sheet (Data > Protected sheets and ranges... > Sheet > Eden's Promise Loot)
- Right click the Eden's Promise Gear tab in the linked Google sheet, Copy to > Existing spreadsheet.
- Select your copy of the gear sheet, it should make a copy of the latest version as a new tab in your existing document.
- Do the same for the Eden's Promise Loot tab if you want it.
- Go to Tools > Script Editor and copy and paste all the junk from the original sheet's code (here).
- Your team can continue to use the same link as before to access the Eden's Promise sheet.
- Optional: set sheet protections so your team can't "accidentally" mess up the logic too badly (Data > Protected sheets and ranges... > Sheet > Eden's Promise Gear > check "Except certain cells", enter ranges like so in any order: B1:J1 L1:U1 B3:U24 B30:U51 X27:AB27 X55 ).
- Optional: set permissions to restrict who can edit the loot sheet (Data > Protected sheets and ranges... > Sheet > Eden's Promise Loot)
- Each person in the team picks a box for themselves.
- Enter your name, job, desired gear, and current gear according to the categories listed in the Legend.
- Don't ever use copy/paste or it'll mess things up, use Paste Special > Paste Values Only (Ctrl + Shift + V) if you need to paste.
- Each week, update your gear, markers (e.g., if you bought any gear/token with pages), iLv (optional), and how many clears your team has for each floor.
- You can duplicate the sheet (right-click the tab, Duplicate) and use the extra copy to keep track of alts, subs, etc. if you like.
- It automatically colorizes your gear based on progression, from red (weak gear), to white (crafted etc.), to darker colors like purple when you've obtained the desired gear.
- It keeps track of how many pages you have, how many pages and tokens you still need to gear up, and who currently needs the most.
- It shows when you've geared up your raid team sufficiently to free roll on specific coffers, either for iLv padding for your mains, or for alts. Check the left column for this.
- It shows when raid team members are being naughty or nice -- or at least, if they've been dragging their feet on updating their status, via timestamp.
- (v2.0) Added tracking for all 4 pages instead of just floors 2 and 3 (note that this will make copy/paste values only'ing from previous versions a bit complicated), added a Spent Pages row for better clarity. Added the loot sheet.
- (v1.3) Added floor clears and markers to streamline the sheet and make planned purchases and page tracking involve less effort on members' parts.
- (v1.23) Now shows which coffers are free roll.
- If the auto-timestamp feature doesn't work: go to Tools > Script Editor and copy and paste all the junk from the original sheet's code (here).
- If you need to upgrade your sheet to the latest version, or refresh/fix your copy: Follow the Initial Setup - Previous Users steps, copy and paste values only the name, job, gear, floor clears, etc. data from the old version to the new version (B3:U24 B30:U51 X27:AB27).
[link] [comments]
Continue reading...