ABCDEFGHIJKLMNO
1
enCard IDCardPackRarityFirst-third cardsFourth cardFifth cardNotes# of cardsVer 3.1.111/14/2024Description
2
A1 001BulbasaurMewtwo♢2.000%0Rate by rarity1-345This is the odds for you to pull a card of a specific rarity across the 1st through 3rd cards, 4th card, and 5th card. The liklyhood to pull a specific card in columns G, H, and I pull from these rates, so they can be easily configured for future expansions
3
A1 002IvysaurMewtwo♢♢2.571%1.714%0♢100.000%0.000%0.000%
4
A1 003VenusaurMewtwo♢♢♢0.357%1.429%0♢♢0.000%90.000%60.000%
5
A1 004Venusaur exMewtwo♢♢♢♢0.333%1.333%0♢♢♢0.000%5.000%20.000%
6
A1 005CaterpiePikachu♢2.000%0♢♢♢♢0.000%1.666%6.664%
7
A1 006MetapodPikachu♢2.000%0☆0.000%2.572%10.288%
8
A1 007ButterfreePikachu♢♢♢0.357%1.429%0☆☆0.000%0.500%2.000%
9
A1 008WeedleMewtwo♢2.000%0☆☆☆0.000%0.222%0.888%
10
A1 009KakunaMewtwo♢2.000%0♛0.000%0.040%0.160%
11
A1 010BeedrillMewtwo♢♢♢0.357%1.429%0Collection SummaryThis is a summary fo your collection as defined by pack. Basically, this shows you how many of a packs potential cards you own. For example, the Mewtwo row is taking into account all of the cards that are exclusive to the Mewtwo pack, and the cards that can be found in all packs. The Pack with the most missing cards section can be used to decide what pack to open if you want a quick, simple answer. For a more accurate result, see Chance to get a new card
12
A1 011OddishCharizard♢2.000%0
13
A1 012GloomCharizard♢♢2.571%1.714%0*These totals includes cards found across all packs% Owned% MissingFraction
14
A1 013VileplumeCharizard♢♢♢0.357%1.429%0Total0.00%99.65%0/287
15
A1 014ParasPikachu♢2.000%0Mewtwo0.00%100.00%0/125
16
A1 015ParasectPikachu♢♢2.571%1.714%0Pikachu0.00%100.00%0/126
17
A1 016VenonatMewtwo♢2.000%0Charizard0.00%100.00%0/126
18
A1 017VenomothMewtwo♢♢2.571%1.714%0Pack with most missing cardsMewtwo
19
A1 018BellsproutCharizard♢2.000%0
20
A1 019WeepinbellCharizard♢♢2.571%1.714%0Advanced FilteringThis is the Advanced Filtering section. Here you can select what rarities the calculations will take into account. For example, if you only want to hunt rare cards, you can exclude the ♢ cards. Note that this only effects calculations in the dark blue box
21
A1 020VictreebelCharizard♢♢♢0.357%1.429%0
22
A1 021ExeggcuteCharizard♢2.000%0♢☆
23
A1 022ExeggutorCharizard♢♢♢0.357%1.429%0♢♢☆☆
24
A1 023Exeggutor exCharizard♢♢♢♢0.333%1.333%0♢♢♢☆☆☆
25
A1 024TangelaCharizard♢2.000%0♢♢♢♢♛
26
A1 025ScytherMewtwo♢2.000%0Card CountThis section is very simmilar to the Collection Summary, with the key difference being that pack calculations do not include cards found acoss all packs, and that it is effected by Advanced Filtering
27
A1 026PinsirAll♢♢2.571%1.714%
*Based on Mewtwo pack
0*These totals DON'T include cards found across all packs% Owned% MissingFraction
28
A1 027CottoneeAll♢2.000%
*Based on Mewtwo pack
0Total0.00%100.00%0/285
29
A1 028WhimsicottAll♢♢2.571%1.714%
*Based on Mewtwo pack
0Mewtwo0.00%100.00%0/79
30
A1 029PetililAll♢2.000%
*Based on Mewtwo pack
0Pikachu0.00%100.00%0/80
31
A1 030LilligantAll♢♢2.571%1.714%
*Based on Mewtwo pack
0Charizard0.00%100.00%0/80
32
A1 031SkiddoCharizard♢2.000%0All0.00%100.00%0/46
33
A1 032GogoatCharizard♢2.000%0Pack with most missing cardsMewtwo
34
A1 033CharmanderCharizard♢2.000%0
35
A1 034CharmeleonCharizard♢♢2.571%1.714%0Chance to get a new cardThe Chance to get a new card section sums the odds of every card you do not own and displays them by card number. For example, if you are missing 3 ♢ cards in the Mewtwo collection, and each one has 2% chance to be pulled, then you would have a 6% chance to get one of them. Like Collection Summary, these calculations include cards found across all packs.
36
A1 035CharizardCharizard♢♢♢0.357%1.429%0*These totals includes cards found across all packsFirst-third cardsFourth cardFifth card
37
A1 036Charizard exCharizard♢♢♢♢0.333%1.333%0Mewtwo100.000%100.000%100.000%
38
A1 037VulpixCharizard♢2.000%0Pikachu100.000%100.000%100.000%
39
A1 038NinetalesCharizard♢♢2.571%1.714%0Charizard100.000%100.000%100.000%
40
A1 039GrowlithePikachu♢2.000%0Best pack to open (% chance)MewtwoMewtwoMewtwo
41
A1 040ArcaninePikachu♢♢♢0.357%1.429%0
42
A1 041Arcanine exPikachu♢♢♢♢0.333%1.333%0Chance to get at least 1 new card across all 5 cardsThis section calculates the odds for you to get at least 1 new card out of each pack, and tells you which pack has the highest chance to get you new cards. This is probably the pack you should always pick
43
A1 042PonytaAll♢2.000%
*Based on Mewtwo pack
0Mewtwo100.000%Best pack to open (% chance, all cards)
44
A1 043RapidashAll♢♢2.571%1.714%
*Based on Mewtwo pack
0Pikachu100.000%Mewtwo
45
A1 044MagmarCharizard♢2.000%0Charizard100.000%
46
A1 045FlareonCharizard♢♢♢0.357%1.429%0Mew TrackerThis section is simmilar to Card Count except it only considers cards who's name matches one of the names in the M48 cell, so it only considers the first 150 Pokemon. By doing it this way, it can be easily configured into a Celebi tracker or something simmilar for future expansions

The formulas are incredibly scuffed, but they work. I encourage you to try and improve them, but be warned, you should do extensive testing before deciding what you have made works
47
A1 046MoltresCharizard♢♢♢0.357%1.429%0
48
A1 047Moltres exCharizard♢♢♢♢0.333%1.333%0Required CardsBulbasaur Ivysaur Venusaur Charmander Charmeleon Charizard Squirtle Wartortle Blastoise Caterpie Metapod Butterfree Weedle Kakuna Beedrill Pidgey Pidgeotto Pidgeot Rattata Raticate Spearow Fearow Ekans Arbok Pikachu Raichu Sandshrew Sandslash Nidoran♀ Nidorina Nidoqueen Nidoran♂ Nidorino Nidoking Clefairy Clefable Vulpix Ninetales Jigglypuff Wigglytuff Zubat Golbat Oddish Gloom Vileplume Paras Parasect Venonat Venomoth Diglett Dugtrio Meowth Persian Psyduck Golduck Mankey Primeape Growlithe Arcanine Poliwag Poliwhirl Poliwrath Abra Kadabra Alakazam Machop Machoke Machamp Bellsprout Weepinbell Victreebel Tentacool Tentacruel Geodude Graveler Golem Ponyta Rapidash Slowpoke Slowbro Magnemite Magneton Farfetch'd Doduo Dodrio Seel Dewgong Grimer Muk Shellder Cloyster Gastly Haunter Gengar Onix Drowzee Hypno Krabby Kingler Voltorb Electrode Exeggcute Exeggutor Cubone Marowak Hitmonlee Hitmonchan Lickitung Koffing Weezing Rhyhorn Rhydon Chansey Tangela Kangaskhan Horsea Seadra Goldeen Seaking Staryu Starmie Mr. Mime Scyther Jynx Electabuzz Magmar Pinsir Tauros Magikarp Gyarados Lapras Ditto Eevee Vaporeon Jolteon Flareon Porygon Omanyte Omastar Kabuto Kabutops Aerodactyl Snorlax Articuno Zapdos Moltres Dratini Dragonair Dragonite Mewtwo
49
A1 048HeatmorAll♢2.000%
*Based on Mewtwo pack
0*There are cards in multiple packs. The totals won't add up% Owned% MissingFraction
50
A1 049SalanditMewtwo♢2.000%0Total0.67%99.33%1/150
51
A1 050SalazzleMewtwo♢2.000%0Mewtwo0.00%100.00%0/45
52
A1 051SizzlipedeAll♢2.000%
*Based on Mewtwo pack
0Pikachu0.00%100.00%0/50
53
A1 052CentiskorchAll♢♢2.571%1.714%
*Based on Mewtwo pack
0Charizard0.00%100.00%0/44
54
A1 053SquirtlePikachu♢2.000%0All0.00%100.00%0/19
55
A1 054WartortlePikachu♢♢2.571%1.714%0Pack with most missing cardsMewtwo
56
A1 055BlastoisePikachu♢♢♢0.357%1.429%0
57
A1 056Blastoise exPikachu♢♢♢♢0.333%1.333%0Chance to get a new Mew cardSimmilar to Chance to get a new card, but only counting Mew cards in the same way that Mew Tracker does. Not very helpful, but necessary for the next section

This used to be broken beyond repair, but the incredibly intiligent u/ratufdez solved it
58
A1 057PsyduckAll♢2.000%
*Based on Mewtwo pack
0*These totals includes cards found across all packsFirst-third cardsFourth cardFifth card
59
A1 058GolduckAll♢♢2.571%1.714%
*Based on Mewtwo pack
0Mewtwo58.00%60.60%70.98%
60
A1 059PoliwagCharizard♢2.000%0Pikachu64.00%61.28%73.69%
61
A1 060PoliwhirlCharizard♢♢2.571%1.714%0Charizard52.00%57.99%69.11%
62
A1 061PoliwrathCharizard♢♢♢0.357%1.429%0Best pack to open (% chance)PikachuPikachuPikachu
63
A1 062TentacoolMewtwo♢2.000%0
64
A1 063TentacruelMewtwo♢♢2.571%1.714%0Chance to get at least 1 Mew card across all 5 cardsIf you are going for unlocking Mew, this should be the pack you pick
65
A1 064SeelPikachu♢2.000%0Mewtwo99.153%Best pack to open to unlock Mew
66
A1 065DewgongPikachu♢♢2.571%1.714%0Pikachu99.525%Pikachu
67
A1 066ShellderMewtwo♢2.000%0Charizard98.565%
68
A1 067CloysterMewtwo♢♢2.571%1.714%0Instructions for on how to adapt this spreadsheet for future expansions
69
A1 068KrabbyMewtwo♢2.000%0
70
A1 069KinglerMewtwo♢♢2.571%1.714%0One of the key points I had when making this spreadsheet was making sure it was as easy as possible to adapt for future expansions. I intend to keep updating this for a while, but there will come a time when my interest in the game has waned and someone else will have to pick up the slack
71
A1 070HorseaPikachu♢2.000%0
72
A1 071SeadraPikachu♢♢2.571%1.714%0
73
A1 072GoldeenPikachu♢2.000%0
74
A1 073SeakingPikachu♢2.000%0
75
A1 074StaryuCharizard♢2.000%0
76
A1 075StarmieCharizard♢♢2.571%1.714%0With that in mind, I crafted this spreadsheet so that there is as little manual labor required to update it as possible. Unless I forgot something, there should only be 2 steps: Conditioanl formatting and Data entry
77
A1 076Starmie exCharizard♢♢♢♢0.333%1.333%0
78
A1 077MagikarpPikachu♢2.000%0
79
A1 078GyaradosPikachu♢♢♢0.357%1.429%0
80
A1 079LaprasCharizard♢♢♢0.357%1.429%0Step 0: Purging
81
A1 080VaporeonMewtwo♢♢♢0.357%1.429%0
82
A1 081OmanytePikachu♢♢2.571%1.714%0Right off the bat I've broken my two step rule. Don't worry though, this one is easy. All you have to do is click the little arrow by the expansion name (Genetic Apex) and click duplicate. The we just have to delete everything in columns C, D, E, and F. Now just rename the new sheet with the same arrow as before, and you're done!
83
A1 082OmastarPikachu♢♢♢0.357%1.429%0
84
A1 083ArticunoMewtwo♢♢♢0.357%1.429%0
85
A1 084Articuno exMewtwo♢♢♢♢0.333%1.333%0
86
A1 085DucklettCharizard♢2.000%0
87
A1 086SwannaCharizard♢♢2.571%1.714%0
88
A1 087FroakieCharizard♢2.000%0
89
A1 088FrogadierCharizard♢♢2.571%1.714%0Step 1: Conditional Formatting
90
A1 089GreninjaCharizard♢♢♢0.357%1.429%0
91
A1 090PyukumukuCharizard♢2.000%0You probably noticed that when you deleted the data, all of the rows turned white. This is because of Conditional Formatting, and it's the same thing that makes the boxes for number of cards turn green when you have 2 or more. We will be using this to automatically color code our whole spreadsheet
92
A1 091BruxishAll♢♢2.571%1.714%
*Based on Mewtwo pack
0
93
A1 092SnomAll♢2.000%
*Based on Mewtwo pack
0
94
A1 093FrosmothAll♢♢2.571%1.714%
*Based on Mewtwo pack
0
95
A1 094PikachuPikachu♢2.000%0
96
A1 095RaichuPikachu♢♢♢0.357%1.429%0
97
A1 096Pikachu exPikachu♢♢♢♢0.333%1.333%0The first thing we have to do is replace the remaining pack names still left on the spreadsheet with whatever the new packs are. For this example let's say the new packs are Mewthree, Pikablu, and MissingNo. All we have to do is press Ctrl + H to bring up the find and replace window. Then we simply replace each old pack with the new pack. In our example, we would Find Mewtwo, Replace with Mewthree and press Replace all. The we just repeat the process with Pikablu and MissingNo replacing Pikachu and Charizard respectively.
98
A1 097MagnemitePikachu♢2.000%0
99
A1 098MagnetonPikachu♢♢♢0.357%1.429%0
100
A1 099VoltorbPikachu♢2.000%0