Elements Card Tracking Spreadsheet v1.3Yay it's a new shiny card tracking spreadsheet for version 1.3! And look, it doesn't give silly inaccurate values anymore!
Looks like someone got rid of laziness and worked on it. He made his own guide, too!
New stuff:Update for new cards
Deflagration worth fixed. (I forgot to change the card cost from 1.29 update, so maybe your electrum worth should have been ~12 electrum higher than what the tracker said. Sorry.)
Shard Count added
Option added for # of pillars goal
Excess cards no longer push Uber-elementalist Progress above 100% nor do they make a complete card set "incomplete".
Added Ultimate elementalist completion rate which includes marks and nymphs. So even if you finished grinding for all cards, you'll get only around 90%. *evil laughter*
Completion percentage added for new cards (Go go shard grinders!)
Completion indicator for pillars, marks and nymphs added.
- If you have excess nymphs and shards, it will suggest that you should sell them.
- It won't suggest selling excess pillars (why would you sell excess pillars?)
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.
Too uninformative? Here's the huge pikaspoiler again:
Spoiler for The huge spoiler:
Elements Card Tracking Spreadsheet v1.285
As there has been some demand for a complete card tracker, I've managed to update an existing one with Marks and the new cards from v1.27, as well with some additional statistics for the purposes of achieving Jmizzle Status™.
>>Download Link<< (#post_download)
If you have any questions and/or feedback about the spreadsheet, feel free to leave a reply on this thread. 
Credit goes to Sir Valimont for his user interface and formulae; I just added more cards to his spreadsheet as he has left the forums.
Source: http://elementscommunity.org/forum/index.php/topic,13271.0.html
SV's Notes (please read them to understand how to use this spreadsheet):
People have been asking about this, so I put it online. Please enjoy.
File is attached to this post.
Current Version: 1.285
Notes and how to use:
This is my personal spreadsheet that I use for keeping track of my Elements cards. I'm providing it here for free and am happy to take suggestions if anyone thinks it should be improved somehow.
If you do use this spreadsheet, I recommend that you keep it open in the background while you play so you can record cards as you get them. This way you won't have to go back and count after a long playing session. Also I highly recommend you maximize the spreadsheet and use it full-screen, since there is a lot of information and it's pretty wide.
Otherwise, in general, anyone should feel free to use this spreadsheet however he or she wants.
1. Editing the spreadsheet
There are 3 different things you should edit in the spreadsheet:
1) Enter the number of each card type you own. Do this simply by typing a number over where it says "x0" next to each card that is listed. You will see that by default the spreadsheet comes with 1 Longsword. You DON'T have to type the little "x" ... the spreadsheet will do that automatically for you.
2) At the top-left there is a box of statistics that includes your calculated total net worth. This is the sale price of all of your cards plus however many coins you have on-hand in your account. The line that says "On-Hand Electrum Coins" is where you should type that number.
3) The double-lined box at the top of the spreadsheet is where you decide how many cards of each type you want to "collect" for the spreadsheet's inventory purposes. I added this feature because unlike most people I collect 7 of each card type so that even if I use 6 of one type of card in my deck I will still have a placeholder. Most people collect 6 of each card type, though, so that is the default. This number will affect the calculations of how complete your set is, in terms of each element, rarity type, and so forth. Just type the NUMBER you want and not the word "cards." That is added automatically.
2. Card list features
All the cards are listed by element, in two columns, one for basic cards, and the other for the upgraded versions. You will see markings that indicate whether a card is rare and you will see both the single-card value of each card type and the total value of any stack of cards you might have. These are totaled at the bottom of each element group by commonality and then by elemental type.
You can collapse the view for any one element at any time by clicking the little MINUS (-) sign to the left of the element icon at the top of the section. This will allow you to look at the summaries of each element type near each other without having the complete list of all cards in your way. To see the card breakdown again, just click the button again -- it will now be a PLUS (+) sign.
One neat feature is that when you have more cards in a specific type, to the left of the card listing you will get a message that says "SELL" -- meaning you can afford to sell a card to the Bazaar for some extra cash and still be on track for your collection. If you have 12 un-upgraded cards (I call them "basic" cards) then the message will tell you "UPGRADE" meaning that you've gotten enough copies of that card type but need to upgrade some of them to have the full set. If you have a full set of a particular card type, you get a nifty little background that pops up with the element's color and says "COMPLETE." There is a summary statistic at the top-right of the spreadsheet that keeps track of how many types of cards you have the "complete" set for as well.
3. Summary Statistics
At the top of the spreadsheet are two sets of summary statistics. Your SET TOTALS are at the top-left and some OTHER STATS are in another section to the right. Set totals include things like your total net worth, but also show a breakdown of the total number of card types you own so you can see how close you are to having one of each card. The "Ownership %" stat is a percentage of exactly that. If you have one of each card that number will be 100%.
Set totals also shows you a breakdown of all basic and upgraded cards by commons and rares, and of course tells you the total number of cards you own overall.
The "Other Stats" section is pretty interesting, too. There are more complex breakdowns of card types but the main focus is on the VALUE of your card sets. This section will show you which elements you have the most value in -- which usually means the most upgraded cards, nymphs, and rares. It shows you your average value per element type and will tell you how far above or below the average each element is for you in a color-coded display. You can also see how many upgraded cards you have per element on average, which stack of cards is your most valuable stack (mine is 11 Quantum Towers for example), and other such things.
Lastly, my favorite thing: There is a stat that tells you how close to a "perfect" deck you are, based on your currently owned number of rares. If you plan to play Elements until you're as good as jmizzle, this is the stat for you! Good luck getting it past 10% though ... sheesh ... grinding.
Remember that there is NO NEED to manually edit any part of this section. All the calculations are done automatically, instantly, when you edit the card list section by adding new cards you've acquired.
4. Final Notes and Compatibility Issues
This spreadsheet was created using Microsoft Office 2002 for Windows.
Last note: This is completely free and I hope you enjoy it. Anyone can have it and anyone can use it however they want. I wrote "Prepared by Sir Valimont" at the top but hey, you can erase that if you feel like it.
Cheers and happy Elementing!
Download Instructions
1. Click on the attachment link below to download.
2. Open in Excel or OpenOffice.
3. Enjoy!
And use the download link below, not the one in the spoiler.
TL;DR version:
Edit stuff with green labels. DO NOT edit anything else.I can't see the attach option. Opera trolling me again?
Hey hey I'm a shiny mediafire link! Click me! Click me!Or use vrt's mirror. Thanks vrt!
