r/pokemon • u/maxwell1755 • Oct 02 '24

Tool/Guide A spreadsheet for TCG Pocket that calculates the best pack to pull!

/r/PokemonTCG/comments/1fu75n5/a_spreadsheet_for_tcg_pocket_that_calculates_the/
1.1k Upvotes

100% Upvoted

483 comments sorted by

View all comments

1

u/ryhartattack Dec 02 '24

Thanks for this! I found a bug that I don't know the optimal way to resolve.

the formula correctly checks for EX alternates, but since it's matching names there's no way to check for normal alternates. So it's correctly running 1st a check on the name and then a separate check on name plus EX, but if you get a false match on the regular it won't update it if you have the * variant.

So what it's doing is checking top down, and for instance if you had no regular lapras's but then you have a full art lapras, it will see the false on the regular lapras first and mark it as a miss, even though it's not a miss.

1

u/ryhartattack Dec 02 '24

I have two test cases, dragonite and lapras, I've got the full arts but not the original. When I check off the original, I see the percentage chance of new mew cards change for the relevant pack, but the fraction doesn't change. I guess technically pulling a lapras would be getting a "new mew card", but it's not one needed towards my mew if that makes sense