I don’t have the patience to enter in all that info but thanks for sharing such a nice tool!
@wereotter good point on the exclusives… I guess it will look like a rounding error fro many of us though. I do own one of these, so if you take it out, then I’d be shown as having a card that is missing. I’ll go look at the headers again.
@wereotter I changed the calc to be based on 58 and added a note to the sheet. I also had a shading problem in that section. Headers also fixed for the SOI/EMN page. Thanks for letting me know on this.
@Firinmahlazer yeah, I first did this quick and dirty just because I couldn’t keep a count in my head long enough and it’s kind of grown a life of its own the past couple of days. ![]()
Yeah. I think that’ll just have to be up to the user to know since it’s possible to own duplicates of those cards that should be calculated for orbs, but may not count toward set completion.
Sorry. Want to use chart. But unsure what to do. Can you please post instruction on how to edit it. Confused as to count. As eg. Origin tab. Page 1. 19. 19 21. 25. Etc. What do those number represnt. Thanks.
My assumption: list of card from origin, Commons only, sorted by default. First page mean all Commons from that page (sum of dupes).
At least this is how image counted in my own sheet:)
The numbers are just the card counts. Pages are the pages you see when you bring up the card view in the game and filter by rarity and set/block. I’ll see about putting a couple of screen shots in the sheet if Google sheets support embedded pictures.
@Phillmoore I’ve added an Instructions tab with some pictures of how I went about it. Setting the filters up right within MtGPQ is the key to filling this out, the “pages” should feel like the pages on your Cards screen after applying the filter.
@Brigby @bken1234 Would one of you be able to pin @ElfNeedsFood’s calculator? Perhaps in a different sub-forum? Also, not sure what your permissions are Bianca.
Thanks
@Szamsziel technically the sort order doesn’t matter as long as you are consistent. Getting the filters right is really what matters.
@babar3355 I think by the time this thread goes inactive, it won’t need pinning.
That was so much fun! Thank you @ElfNeedsFood. Looks like I can craft all my missing rare (and my one missing uncommon) and have enough left over to pick my top 10 or so favorite missing mythic.
More card for you to master ![]()
I might finally get Olivia! And the pig!
me too. and Deploy. hopefully before they get nerfed. ![]()
The word is “balanced” not “nerfed”. ![]()
Probably they never get “balanced” because only happen in legacy and virtually everybody has it with booster craft.
No, a whole lot of people won’t have it even with crafting. Probably most.
Two minor things regarding your sheet (which is a great tool, thank you!)
Your SOI/EMN page has headers for OGW cards.
Also I’m not sure how you want to calculate in the three rare exlusives from KLD. It shows me missing 4, which is correct, but only three of those can be looted from packs as the fourth card is Core Prowler, and it’s impossible to say if those three cards will be about to loot or craft in the future.
I came in to ask about that since exclusive mythics are in the Masterpiece boosters only so are those counting as Masterpieces?
A lot more than today. If you on that one card you can go for it with crafting. Until now you can’t even buy bfz, soi or some other booster every time you want. Very hard to get the chosen one then.
But you have to balance you wish list with the weight of your purse and patience of course.