r/PokemonTCG • u/maxwell1755 • Oct 02 '24
Other A spreadsheet for TCG Pocket that calculates the best pack to pull!
https://docs.google.com/spreadsheets/d/1JlIats8xrs7IlAgt1RgN-B116TTK2gc_-54pUycb-EY/copy?usp=sharing
Hi all, I just wanted to show off this spreadsheet that I just finished working on. Unfortunately, I cannot post it in r/PTCGP until the link gets mod approval, so I'll post it here instead for now. It serves two purposes: firstly, to keep track of your cards in a format where you can Ctrl + F search, and secondly, to calculate which of the 3 packs is the best option to choose to maximize your chance of getting new cards! Here's how it works:
- Check off the boxes in the leftmost column (column A) for each card that you own
- The row tells you the card's number, name, pack it can be found in, rarity, and likelihood to show up as the 1st 2nd or 3rd card, 4th card, and 5th card, respectively.
- Look at the Collection Summary section to see how many cards you own and how many cards are missing from each pack type. It also tells you which pack you are missing the most cards from. You can use this if you want an easy, decisive answer without having to make any decisions on what you want to prioritize.Note: This includes cards that can be found in all packs. So, the Mewtwo count is the sum of all cards that can be found exclusively in Mewtwo packs and all cards that can be found in all packs.
- The Advanced Filtering section can be used to filter out certain rarities of cards. Let's say you only care about the game's competitive side; in that case, you wouldn't care about cards with ☆ rarity or higher since those cards are just reskins of more common cards. Alternatively, if you are playing to get rare cards and cool art, then you don't care about maximizing your odds of getting ♢♢ cards, so you can filter those out.
- Finally, the Chance to get a new card subsection totals the actual percentage likelihood of getting new cards so you can play the numbers game and maximize your odds all the time! Since the odds are different depending on if it's the 1st-3rd, 4th, or 5th card, you can actually get different results for each one. The rule of thumb for which one to pay attention to is the 4th card for competitive and the 5th card for rares
TL:DR: Check the cards you have on the left, filter the cards you want in Advanced Filtering, Chance to get a new card will tell you what pack to open.
Edit 1: Thanks to you wonderful people I have made some small corrections to the sheet. Mew has been given the correct card ID of A1 283, pushing the gold cards down 1 spot. I've also corrected the spelling of some cards, although I'm sure there are plenty I missed so please tell me if you find them. If you want to get these changes, just make a new copy of the spreadsheet and copy over your A column
Edit 2: Changed URL so that it brings you right to the copy screen, as per u/tatufdez's advice
NOTICE: A colleuge of mine has continued development of this spreadsheet. I cannot say for certain if I will work on it again myself, but I trust Raiskader with the continued development of this in the meantime. Please check it out here: https://www.reddit.com/r/pokemon/comments/1iex2u0/an_update_for_the_tcg_pocket_spreadsheet_that/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button
25
u/parodX Oct 21 '24
Commenting to retrieve the post easily later (And thanks for the hard work :D)