Card Collectors spreadsheet

[Evil Hamster]

* I'm not sure this is the appropriate location for this thread, feel free to move it if it's not *

I have created a spreadsheet for those of you who want to collect all of the cards!

How it works-

Fill in the number of each card you have in the blue column (owned)

The wanted column is set to 6 of each rare (12 pillars) and 12-rare for the commons (24-rare for pillars). Edit that column however you want if you want to.

Then the sheet calculates number of cards needed, coins needed (for all except rares which can not be bought) and sale value for cards above the number of wanted.

Some of the sell values are blank (cards I don't have). Fill in the appropriate column if you want.

Have fun collecting 1.4 million worth of cards!

[Evil Hamster]

Hmm, when I load it is really far off to the right, and I can only see the numbering. Any way I can fix this? (other than pressing random buttons, I think I covered that prettty well)

Thx

Maybe check the column widths?

What software are you using? It works on Excel 2003 and 2007.

[Forfeit]

Hmm, when I load it is really far off to the right, and I can only see the numbering. Any way I can fix this? (other than pressing random buttons, I think I covered that prettty well)

Thx

[Forfeit]

I'll open it on excel this time, thank you

[Evil Hamster]

You're welcome.

I plan on updating it whenever more new cards are released. I have many more sell value numbers now!

[Kumlekar]

Theres no line for the unupgraded shard. thanks though.

[MartyrX]

Evil Hamster

Thanks for the spread sheet.  It comes in very handy.

MartyrX

[Scaredgirl]

Good job.

[Drawckab]

Sounds like you did great work!  Call me stupid, but I can't find the link to download the spreadsheet.

I know this is an old thread, but I found it because I decided to make my own spreadsheet and figured I'd see if anyone had done the same to fill in some holes in my data.  I don't have near the calculations you do.  All I've calculated is the total loss and percentage of loss on the sale of cards, both upped and unupped.

I get bored of my deck quickly and often sell cards to build a new deck.  I started thinking I've lost tons of money by selling all those cards and decided to figure out loss percentages for all the cards.  That way, if I have a choice between selling two cards I can choose the one with the lowest loss percentage.  Even if that choice sells for less than the other, if the percentage of loss is less it's the better choice in the long run, assuming it gives me enough to buy the new card I'm wanting.

Anyway, how can I get this spreadsheet?

[jmizzle7]

Sounds like you did great work!  Call me stupid, but I can't find the link to download the spreadsheet.

I know this is an old thread, but I found it because I decided to make my own spreadsheet and figured I'd see if anyone had done the same to fill in some holes in my data.  I don't have near the calculations you do.  All I've calculated is the total loss and percentage of loss on the sale of cards, both upped and unupped.

I get bored of my deck quickly and often sell cards to build a new deck.  I started thinking I've lost tons of money by selling all those cards and decided to figure out loss percentages for all the cards.  That way, if I have a choice between selling two cards I can choose the one with the lowest loss percentage.  Even if that choice sells for less than the other, if the percentage of loss is less it's the better choice in the long run, assuming it gives me enough to buy the new card I'm wanting.

Anyway, how can I get this spreadsheet?

This is a very, very old thread, and I think the attached file got lost when SG did some forum maintenance. Sorry for the inconvenience.

[Drawckab]

This is a very, very old thread, and I think the attached file got lost when SG did some forum maintenance. Sorry for the inconvenience.

Yeah, I just noticed Evil Hamster hasn't been here since January.  Oh well, thanks anyway.  Maybe when I've collected more data I'll share my spreadsheet.