Note: If you have the old version of this, be aware that I accidentally left some personal information in the file. I don't mind if you keep it but please don't redistribute the file. If you want another copy, just download the one attached to this post (I removed the sensitive information). Thanks!
People have been asking about this, so I put it online. Please enjoy.
File is attached to this post.Current Version: 1.0Current Version: 1.26
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 spreadsheetThere 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 featuresAll 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 StatisticsAt 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 IssuesThis spreadsheet was created using Microsoft Office 2008 for Mac. That's right, I use a Mac. I think the file will open well on the PC version of Excel, but if not, let me know and I will try to save it in a different format for you. It would be a shame not to have it look right because there is a lot of fine-tuned design that makes the spreadsheet look and feel excellent. What can I say, good design is my profession.
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!
