- IMPORT COLLECTION FROM DECKED BUILDER TO TAPPEDOUT MANUAL
- IMPORT COLLECTION FROM DECKED BUILDER TO TAPPEDOUT CODE
Understandably this might be bit "heavy" for you, so if you got Ipad, just get Decked builder and put your decks there. Now if there is a fire, I have something to show to them and say "HEres what burned" instead of trying to get everything out from my memory.ītw, my Excel-Fu was non-existent before this, so the codes might look all kinds of funny to pros, but they do what I require and thats enough for me :).
That way the numbers don't appear in excel as dates (at least it works for me).ġ) I can check from one file how many cards and which kind I have (Find -> whole workbook -> find all)Ģ) I wanted to have an estimate of my collections worth for myself, and for my insurance company. Leave Column Data format to general, but use "Advanced" on the same window and change Decimal Separator from "," to "."
Of course, use the pipe-delimited format price lists from Magictraders. When importing the price lists (Data -> From text), use "Other": | (pipe) as the mark that divides the prices into different boxes.
IMPORT COLLECTION FROM DECKED BUILDER TO TAPPEDOUT CODE
The rest is easy with =SUM(here-are-the-boxes-with-prices-in-the-tab) and then this kinda horrible code somewhere in the excel (each sheet has the sum price of that tab in box L2 and the 'xxx' are the names of the tabs I have):
IMPORT COLLECTION FROM DECKED BUILDER TO TAPPEDOUT MANUAL
Easier to see what cards might require manual check from price lists what the name really is etc. I tells that if you have foils or normals (more than 0/empty box), but prices lists do not have such name, that there is no such price found. Column L does the job of counting it right still)Ĭolumn M is extra info. Notice that I did it so that the columns B and C only show TOTAL number of such card, and the FOIL numbers, not the number of non-foils. Tabs NPrice and FPrice contain the imported normal and foil Magictraders lists.Ĭolumn J searches for the card name in column E from the normal price tab (between lines 2-20000) and prints out the price.Ĭolumn K does the same thing for the same card name from foil price tab.Ĭolumn L just counts the price together (checks how many normals and how many foils you have. any cards that appear in more than 1 expansion have (XXX) note after them, check the price lists for correct names) Some prices might be odd and need some common sense, but with big enough collection, the system gives kinda good approximation.Ĭolumn B : Total number of specific card from that expansion (normal+foil)Ĭolumn E : Name of the card (AS IT IS in the price list. However, Magictraders DOES have list for normal AND foil. I still had to price promos and such manually, as Magictraders does not have prices for those. With some googling and learning, I was able to make similar setup to an excel file that had a separate tab for each expansion. I had the same problem (but concerning my whole collection, including everything I had).Īnd the parts 2 and 3 (links provided in the first part).
0 kommentar(er)
