List of card in my decks that are not in my inventory

See if the attached Excel file helps you at all. Not as ideal as a native method, to be sure! But it eases things a bit.

INSTRUCTIONS

Initial Setup

1. For any decks you currently have on Dropbox, go to Tools > Export to CSV.

2. 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).

3. Make sure you right-click each worksheet tab and rename it to match whatever name you put in the "Deck Names" area. I have example decks so you can get the idea. (And you'll get red error formatting if one of the names doesn't match!)
   

   • Important: The workbook currently doesn't support non-alphanumeric characters in the deck / sheet names. (This could be easily changed if anybody cares.)

4. Copy and paste the data from the Deck CSV files you exported in Step 1 into their corresponding worksheets.

5. 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.

Usage

1. Export your entire Inventory to CSV, and rename it to something easy to type (like just "Inventory"). DON'T alter the file.
   

   • You don't necessarily have to do this every time, just whenever you need an updated Inventory CSV on your computer.

2. 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 .csv ending).

3. 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. The "H" column stands for "Have", "W" is "Want", and the third column "Need" is the important number -- how many of the card you actually need to buy.

Updating Decks

There's no need to export a CSV file for a deck each time you change it. Just go to that deck's worksheet and alter the card names and quantities yourself. (It doesn't matter if there's blank lines between cards.)

If you ever decide to build a new deck, just get its name added to the Deck Names area, get a worksheet created, and either manually enter in the cards into the sheet, or you can export a CSV from DeckBox again.

Hey, no problem! I already had the file created for myself, so I figured I'd share it. (The only work on my part was to type out detailed instructions. LoL)

And to each his own! Honestly, the way you and settlerjoe are doing it sounds like way more work to me. Cuz now that I have all my decks in that Deck Checker, if I make a change to a deck, I just update both the Deck Checker and Deckbox decks (like 30 seconds total). And I've always exported a CSV of my inventory anyways for backup if I make a change to it, so that doesn't take any *extra* time for this Excel-based approach (but even if you're not already doing that, again, takes like 30 seconds, if that). And then all I have to do to see a list of cards I'm missing is to open Deck Checker and my latest Inventory CSV. It's an always up-to-date list of missing cards, with none of the hassle that you and settlerjoe describe.

And adding / removing a deck is super easy and fast. None of that making changes to an "All 14 decks" deck.  :\

You could always give it a shot! You never know. You might like it.

(And now I suddenly have Dr. Seuss' "Green Eggs and Ham" in my head. LoL!)

Did you give the Deck Checker a shot? I'm not sure what would be even easier, other than a native feature developed by Sebi.

You said changing decks requires 20-30 minutes of your time -- my method takes mere seconds to make a single change to a deck.

- Making changes to 5 of your pauper decks? Open both Deckbox and the Deck Checker, and change quantities or card names in both. (So a few more seconds per tweaked card than a native method.) And then your list of "cards to buy" is instantly up-to-date and easily viewable.

- Added a bunch of your cards to your inventory? Export a CSV of it anywhere on your computer.

- Want to see that list of missing cards because you're about to go to the card store? Open the inventory CSV and Deck Checker simultaneously, and the list populates for you. Copy and paste the list into Word and print off your list. Doing that takes hardly any longer than clicking on a link in Deckbox would.

So the ONLY extra work at this point is having to export your inventory each time you change it (which is smart to do anyways), and having to type a card name / quantity twice instead of once any time you change a deck.

Give my method a shot! I think you'll be pleasantly surprised at how easy it is. 

Last edited by meldon44 (2018-10-15 02:01:36)