That's it! Depending on how much data is in your inventory file, the response might be a little sluggish, but you'll see a list populate with any missing cards. Have the Inventory open at the same time as the Deck Checker, and on the "Missing Cards" worksheet, type the name of the Inventory file into the designated cell (NO. You don't necessarily have to do this every time, just whenever you need an updated Inventory CSV on your computer. If you switch back to the "ALL" worksheet, you should be able to see an alphabetized and consolidated list of all cards needed for all decks.Įxport your entire Inventory to CSV, and rename it to something easy to type (like just "Inventory"). (This could be easily changed if anybody cares.)Ĭopy and paste the data from the Deck CSV files you exported in Step 1 into their corresponding worksheets. Important: The workbook currently doesn't support non-alphanumeric characters in the deck / sheet names. (And you'll get red error formatting if one of the names doesn't match!) I have example decks so you can get the idea. Make sure you right-click each worksheet tab and rename it to match whatever name you put in the "Deck Names" area. Open the attached Deck Checker workbook, then create a new worksheet for each deck (supports up to 20, with a max of 100 unique cards per deck). Not as ideal as a native method, to be sure! But it eases things a bit.įor any decks you currently have on Dropbox, go to Tools > Export to CSV. See if the attached Excel file helps you at all. Is there a way to see the cards that I have in my decks, but are not in my inventory? Without having to go to each deck individually?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |