Elements Card Tracking Spreadsheet 1.327

[kirbylover314]

Is there a way to make the Sell tab ignore Relics? I like stashing them

I mean the Sell tab is just recommending what to sell, doesn't mean you have to. Any reason simply ignoring that line by yourself isn't sufficient?

Not really, just thought it would be nice since Relics are the only "common" card that gets listed in the Sell tab.

[Leodip]

I cannot import my collection anymore with the import function, for some reason. I think it's because of having recently gotten 2 Holy Cows (from Plat). How can I solve this?

I was thinking of removing manually Holy Cow from the decka when I import it: does someone know how data is stored in the decka?

[Naii_the_Baf]

I cannot import my collection anymore with the import function, for some reason. I think it's because of having recently gotten 2 Holy Cows (from Plat). How can I solve this?

I was thinking of removing manually Holy Cow from the decka when I import it: does someone know how data is stored in the decka?

Data in the decka is stored like this:

There are seven digits by card. The first four are an ID, and the following three are the amount you have. The ID is generated by converting the card code, in Base32, to Base10, and then substracting 5000 from the resulting number.}

For Holy Cow, the code is 5lt, which is converted to 5821. As such, Holy Cow's ID is 0821. Since you said that you have 2 Holy Cows, the other three numbers should be 002.

You should look up 0821002(only 0821 is really needed, but I added 002 for reference, since you also need to delete the next three digits after the ID) and remove it. Your decka should be free of Holy Cows now.

[DoctorWho42]

This tool is so cool!  Did you make this yourself? It's really impressive!

[antiaverage]

This tool is so cool!  Did you make this yourself? It's really impressive!

I started with a simpler sheet that someone else built and then slowly added more tools, features, and improvements. At this point it's been entirely reworked, but it would not have happened with the people I thanked in the original post.

Special thanks to suxerz for starting this sheet, serprex for bug reports and code, and CuCN for bug reports and code.