Elements Card Tracking Spreadsheet 1.321

[Absol]

Elements Card Tracking Spreadsheet v1.321

What's new:
1. Shards moved to respective elements, cost update
2. Added Graviton Salvager, Dry Spell, and Phase Salvager
3. Cost update for Graviton Mercenary and Thunderstorm

Foreword
This spreadsheet was first created by SirValimont and later edited by pikachufan2164, and much later edited by rosutosefi in 1.31. And later, after the 1.32 patch was released, shards are moved into their respective elements, along with the additional three cards into the game. I edited the spreadsheet again to reflect the changes.

Credit goes to:
Sir Valimont for first sheet
pikachufan2164 for editing up to 1.285
rosutosefi for editing up to 1.31
Absol for editing up to 1.321

How do I use this thing?

   - Enter your goal for the number of copies you want per card (default is 6) and the number of copies you want per pillar (default is 24). This will be the basis of the tracker for your card completion.
   - Enter the amount of electrum you have.

   - Next, enter the number of copies you have per card. Column F for unupgraded, N for upgraded.
   - The following example shows the completion indicator for cards.

      - It will show "complete" for cards that you have 6 of, both unupped and upped.
      - If you don't have a complete set yet, it will show the number of copies you have for that card.
      - If you have an excess of unupgraded cards But still lack some of the upgraded cards, it will suggest that you upgrade some of the cards. But if you have too many unupgraded cards, it will suggest that you sell some of the cards.
      - If you have too many upgraded cards, it will suggest that you sell some of the cards.
      - If you have completed the set of cards and have an excess of them, it will suggest selling some of the cards. But unlike the previous version, it will now count for the completed card sets.
   - Check out the shiny numbers above for your personal satisfaction. Don't edit things there though.

Spoiler for New patch?:

And if something bad happens to me (well, that depends on your perspective about what's good or bad), like if I got
hit by a train or fell of a plane or simply lost access to the internet or anything, it would be nice if someone knew
how to edit this thing and give out future updates. Because of that, I changed some of the formulas to make it more
editor-friendly. This is actually the "heavy part" of this update.

If a new card is added, you can insert a row BETWEEN TWO EXISTING CARDS. This is to ensure that the new row you
created is included in card totals and stuff. You can move the row after that, so don't worry.

Next, you can copy a row from another card and paste it on the new row. Remember that you should copy everything on
the row, a least everything from column B to S (Yes, there's something important in column S. The completion
indicator I used since the v1.3 update). I suggest copying from the same element so the color fits. If the card
should not be considered as a pillar, you should copy a non-pillar card.

And because it is a new card, you should also CHANGE the new card collection progress (remove the old card count
you silly). Add the S columns of the new cards and divide it by (number of new cards)*2.
You should also change the number of cards written before the element name in the card lists. Yes, it matters.

You can then input card name and costs on the copy you made. If it's a common non-pillar, you're done! If it isn't,
then make these few edits:
If it is a 2-band rare, edit the formula for basic and upgraded 2-band rares and add the appropriate values. DO NOT
change the formula for the total 2-band rares as it will make the formula messy, which is bad for future updates.
If it is a mark, shard, or a nymph, follow the steps for the 2-band rares (of course, edit the mark/shard/nymph
totals instead) AND make the necessary edits on the collection progress percentages. Add the S column of the new card
to the numerator and increase the denominator by 2. If it is a pillar/pendulum, you only need to edit the pillar
completion percentage. It's the same with the nymphs, marks and shards.

Actually, I think I can edit the spreadsheet so that all you need to do is the insert, copy and edit but it takes too
long. Maybe on the next update? <- this is legacy of rosutosefi and i can't update it. Ask him instead.

TL;DR version:
Edit stuff with green labels. DO NOT edit anything else.

>> This is the download link. Click! <<

See ya.

[antiaverage]

Nice updates.

I did similar with the Google Docs version:
https://docs.google.com/spreadsheet/ccc?key=0Ao07Zx9C3FLcdF9hUGtiZTdhRC1oYkFiU19PNEZ6ZEE

Working on a Beta version which adds some new features and changes the layout a bit:
https://docs.google.com/spreadsheet/ccc?key=0Ao07Zx9C3FLcdHJVY0Q1b3ZZUGRrZk00LXVSUHRrdXc

[rosutosefi]

Ooh. Okay, thanks for updating! Now I can continue derping around. 

[Pella]

Silly newbie-ish question:  Why is the default 24 for pillars and pendulums?  I've seen a bunch of decks that others have made, and so far I've never seen anything that had 24 unupped or 24 upped of either.  Why is that number so high?