*Author

Offline rosutosefiTopic starter

  • Sr. Member
  • ****
  • Posts: 727
  • Reputation Power: 10
  • rosutosefi is taking their first peeks out of the Antlion's burrow.rosutosefi is taking their first peeks out of the Antlion's burrow.
  • Dead.
  • Awards: Slice of Elements 2nd Birthday Cake
Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg407973#msg407973
« on: October 11, 2011, 08:47:07 am »
Elements Card Tracking Spreadsheet v1.291

Updated the Card Tracking Spreadsheet made by Sir Valimont and pikachufan2164.
Because I am lazy to write stuff, I'm gonna quote all the stuff from 1.285 thread.

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.  :))
I will add more stuff to this. Probably shard count and better % completion stats.
Please tell me if something goes boom.
Not so active.

Offline Vineroz

  • Chat Moderator
  • *****
  • Posts: 1648
  • Country: hk
  • Reputation Power: 26
  • Vineroz is a proud Wyrm taking wing for the first time.Vineroz is a proud Wyrm taking wing for the first time.Vineroz is a proud Wyrm taking wing for the first time.Vineroz is a proud Wyrm taking wing for the first time.Vineroz is a proud Wyrm taking wing for the first time.
  • Awards: Deckbuilding Competition - Simulated ViolenceWeekly Tournament WinnerWeekly Tournament Winner
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg408137#msg408137
« Reply #1 on: October 11, 2011, 06:31:12 pm »
I don't know why but every time I enter the number of cards, the total number doesn't match with my account o.0
TIME is around us. It flows silently, trying to take everything away from us.
PvP Tournament Organizer (2012 Sep - 2013 Oct, 2016 Nov - 2017 Aug) | Chat Mod (2016 Nov - )  :time

Offline rosutosefiTopic starter

  • Sr. Member
  • ****
  • Posts: 727
  • Reputation Power: 10
  • rosutosefi is taking their first peeks out of the Antlion's burrow.rosutosefi is taking their first peeks out of the Antlion's burrow.
  • Dead.
  • Awards: Slice of Elements 2nd Birthday Cake
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg408498#msg408498
« Reply #2 on: October 12, 2011, 09:13:52 am »
Try to re-check. :D

It happens to me often too, but these are just errors in entering data. I currently use it, and it displays the correct number of cards (with 0 cards in the deck, of course)
Not so active.

Offline nerd1

  • Hero Member
  • *****
  • Posts: 1137
  • Country: us
  • Reputation Power: 15
  • nerd1 is a Blue Crawler starting to think about his first run.nerd1 is a Blue Crawler starting to think about his first run.nerd1 is a Blue Crawler starting to think about his first run.
  • kind of active
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg409082#msg409082
« Reply #3 on: October 13, 2011, 02:04:14 pm »
Woohoo! a 1.291 version was made! confetti for everyone! I used to use the old 1.26 version, but that got outdated and the way I edited in new cards (making another section at the bottom and adding the new cards there) was becoming too much of a pain to do. +rep
The laziest elements player this side of one thousand posts.

Offline rosutosefiTopic starter

  • Sr. Member
  • ****
  • Posts: 727
  • Reputation Power: 10
  • rosutosefi is taking their first peeks out of the Antlion's burrow.rosutosefi is taking their first peeks out of the Antlion's burrow.
  • Dead.
  • Awards: Slice of Elements 2nd Birthday Cake
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg409405#msg409405
« Reply #4 on: October 14, 2011, 03:01:44 am »
Woohoo! a 1.291 version was made! confetti for everyone! I used to use the old 1.26 version, but that got outdated and the way I edited in new cards (making another section at the bottom and adding the new cards there) was becoming too much of a pain to do. +rep
Well, you can use the insert function in excel, copy the one on top, and make some modifications on the total electrum and stuff.  :))
Not so active.

Offline nerd1

  • Hero Member
  • *****
  • Posts: 1137
  • Country: us
  • Reputation Power: 15
  • nerd1 is a Blue Crawler starting to think about his first run.nerd1 is a Blue Crawler starting to think about his first run.nerd1 is a Blue Crawler starting to think about his first run.
  • kind of active
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg409563#msg409563
« Reply #5 on: October 14, 2011, 01:06:14 pm »
Woohoo! a 1.291 version was made! confetti for everyone! I used to use the old 1.26 version, but that got outdated and the way I edited in new cards (making another section at the bottom and adding the new cards there) was becoming too much of a pain to do. +rep
Well, you can use the insert function in excel, copy the one on top, and make some modifications on the total electrum and stuff.  :))
yeah... I figured that out only after i did the edits... but as for making the modifications for total electrum, i dont know.
The laziest elements player this side of one thousand posts.

Colossus

  • Guest
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg432066#msg432066
« Reply #6 on: November 29, 2011, 12:00:44 am »
Since I was referred here (thanks Pika)

"Any chance someone has a Google Document update to this to include 1.29 with the new shards and everything?"

I can't use excel as I don't have it, so this would be really appreciated.

Offline UTAlan

  • Hero Member
  • *****
  • Posts: 1802
  • Reputation Power: 58
  • UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.UTAlan is truly a Titan, worthy of respect and acknowledgement.
  • Immortally Aether
  • Awards: Slice of Elements 9th Birthday CakeSlice of Elements 8th Birthday CakeSlice of Elements 7th Birthday CakeWeekly Tournament WinnerSlice of Elements 6th Birthday CakeReviver of the WikiWar #6 Winner - Team AetherSlice of Elements 3rd Birthday CakeSecond Budosei of BudokanSlice of Elements 2nd Birthday CakeWeekly Tournament Winner
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg432074#msg432074
« Reply #7 on: November 29, 2011, 12:26:55 am »
Since I was referred here (thanks Pika)

"Any chance someone has a Google Document update to this to include 1.29 with the new shards and everything?"

I can't use excel as I don't have it, so this would be really appreciated.
Until it is made a Google Doc, check out Open Office (http://www.openoffice.org/). Much better than Microsoft Office, anyway.

Colossus

  • Guest
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg432079#msg432079
« Reply #8 on: November 29, 2011, 12:48:08 am »
Until it is made a Google Doc, check out Open Office (http://www.openoffice.org/). Much better than Microsoft Office, anyway.
Thank you UTAlan! I will most certainly enjoy using this now.

Offline ElementalDearWatson

  • Sr. Member
  • ****
  • Posts: 614
  • Reputation Power: 8
  • ElementalDearWatson is a Spark waiting for a buff.
  • New to Elements
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg481023#msg481023
« Reply #9 on: April 14, 2012, 05:13:34 pm »
Soooo, is anybody going to update this?  Or is there an easy tutorial on how to edit the forms so I can do it myself?

Offline rosutosefiTopic starter

  • Sr. Member
  • ****
  • Posts: 727
  • Reputation Power: 10
  • rosutosefi is taking their first peeks out of the Antlion's burrow.rosutosefi is taking their first peeks out of the Antlion's burrow.
  • Dead.
  • Awards: Slice of Elements 2nd Birthday Cake
Re: Elements Card Tracking Spreadsheet v1.291 https://elementscommunity.org/forum/index.php?topic=32282.msg483627#msg483627
« Reply #10 on: April 19, 2012, 02:55:48 pm »
I don't have a stable net connection now. I'll work on it tomorrow, but who knows when I'll be able to upload it. Hope someone ninjas me?  :P
BTW, you can insert a row, enter the card details (and copy the formatting if you want to) and make necessary edits in totals and stuff. :)
Not so active.

 

anything
blarg: Sir Valimont