Hi all,

The sheet has been updated just (barely) in time for the patch.

Pandaemonium Raid Team Gear Planning (v6.202)

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.

There is also 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: Pandaemonium Asphodelos; Eden's Promise, Verse, 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 > Abyssos 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 > Abyssos Loot)

Initial Setup - Previous Users

• Right click the Abyssos 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 Abyssos Loot tab if you want it.
• Your team can continue to use the same link as before to access the sheet.
• Optional: set sheet protections so your team can't "accidentally" mess up the logic too badly (Data > Protected sheets and ranges... > Sheet > Abyssos 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 > Abyssos Loot)

How to Use It

• 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), 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. If using the duplicate sheet to track gear for each member's primary alt job, link the sheets by typing the main sheet's name into the Linked Sheet box in the alt sheet. (It should turn red when you've done it correctly.) You can daisy chain linked sheets for secondary alt jobs, etc.

What It Shows You/Why Use It

• 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. Using the linked sheets feature, it can continue tracking this for your team's alt jobs, too.
• 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.

What's New Since the Previous Release

• (v6.2) Improved sheet linking logic, added weapon count display to loot sheet.
• (v6.0) Removed belts, added sheet linking.
• (v2.1) By ~popular demand~, added automatic iLv calculation.
• (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.

Troubleshooting

• 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.
• 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. (The stuff below Desired/Current and within the dotted lines. Not Spent Pages etc. Specifically, the ranges: B3:U24 B30:U51 X27:AB27 .)