Hi all,
5.2 and Eden's Verse are around the corner, and that means another version of my gear planning sheet.
Eden Raid Team Gear Planning (v1.3)
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.
(Previous posts for: Eden's Gate, Alphascape versions)
Initial Setup - New Users
[link] [comments]
Continue reading...
5.2 and Eden's Verse are around the corner, and that means another version of my gear planning sheet.
Eden Raid Team Gear Planning (v1.3)
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.
(Previous posts for: 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.
- Optional: set sheet protections so your team can't "accidentally" mess up the logic too badly (Data > Protected sheets and ranges... > Sheet > check "Except certain cells", enter ranges like so in any order: B1:F1 H1:M1 B3:M24 B29:M50 P26:T26 O53 ).
- Right click the Eden's Verse 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.
- Your team can continue to use the same link as before to access the Eden's Verse sheet.
- Optional: set sheet protections so your team can't "accidentally" mess up the logic too badly (Data > Protected sheets and ranges... > Sheet > check "Except certain cells", enter ranges like so in any order: B1:F1 H1:M1 B3:M24 B29:M50 P26:T26 O53 ).
- 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. (For floors 3 and 2 only for now.)
- 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.
- (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:M24, B29:M50, P26:T26).
[link] [comments]
Continue reading...