reef

spreadsheets 😎

https://www.reddit.com/r/pokemon/comments/1fu76x4/a_spreadsheet_for_tcg_pocket_that_calculates_the/

I copy pasted those rows onto a separate sheet after I kept looking for them. I then asked AI for a formula to list everything that I am missing.

=QUERY({
  {'Genetic Apex'!B:B, 'Genetic Apex'!C:C, 'Genetic Apex'!E:E, 'Genetic Apex'!J:J, 'Genetic Apex'!K:K, ARRAYFORMULA(IF(ROW('Genetic Apex'!B:B)=1,"Source",IF(ROW('Genetic Apex'!B:B)>1,"Genetic Apex",)))};
  {'Mythical Island'!B:B, 'Mythical Island'!C:C, 'Mythical Island'!E:E, 'Mythical Island'!J:J, 'Mythical Island'!K:K, ARRAYFORMULA(IF(ROW('Mythical Island'!B:B)=1,"Source",IF(ROW('Mythical Island'!B:B)>1,"Mythical Island",)))};
  {'Space-Time Smackdown'!B:B, 'Space-Time Smackdown'!C:C, 'Space-Time Smackdown'!E:E, 'Space-Time Smackdown'!J:J, 'Space-Time Smackdown'!K:K, ARRAYFORMULA(IF(ROW('Space-Time Smackdown'!B:B)=1,"Source",IF(ROW('Space-Time Smackdown'!B:B)>1,"Space-Time Smackdown",)))};
  {'Triumphant Light'!B:B, 'Triumphant Light'!C:C, 'Triumphant Light'!E:E, 'Triumphant Light'!J:J, 'Triumphant Light'!K:K, ARRAYFORMULA(IF(ROW('Triumphant Light'!B:B)=1,"Source",IF(ROW('Triumphant Light'!B:B)>1,"Triumphant Light",)))};
  {'Shining Revelry'!B:B, 'Shining Revelry'!C:C, 'Shining Revelry'!E:E, 'Shining Revelry'!J:J, 'Shining Revelry'!K:K, ARRAYFORMULA(IF(ROW('Shining Revelry'!B:B)=1,"Source",IF(ROW('Shining Revelry'!B:B)>1,"Shining Revelry",)))}
},
"select Col1, Col2, Col3, Col4, Col6 
where Col4 < 2 and Col1 is not null 
and (Col3 matches '.*[♢☆✷♛].*')
order by Col3 asc", 0)

Laziness or insanity, up to others to decide

Is this A1a 031 Mew ♢♢♢? I have 4 of them. Do you have any of these:

A1 022	Exeggutor	♢♢♢	GA
A1 035	Charizard	♢♢♢	GA
A1 040	Arcanine	♢♢♢	GA
A1 046	Moltres		♢♢♢	GA
A1 095	Raichu		♢♢♢	GA
A1 128	Mewtwo		♢♢♢	GA
A2 024	Magmortar	♢♢♢	STS

If not

A1 013	Vileplume	♢♢♢	GA
A1 020	Victreebel	♢♢♢	GA
A1 022	Exeggutor	♢♢♢	GA
A1 035	Charizard	♢♢♢	GA
A1 040	Arcanine	♢♢♢	GA
A1 045	Flareon	♢♢♢	GA
A1 046	Moltres	♢♢♢	GA
A1 055	Blastoise	♢♢♢	GA
A1 061	Poliwrath	♢♢♢	GA
A1 079	Lapras	♢♢♢	GA
A1 080	Vaporeon	♢♢♢	GA
A1 082	Omastar	♢♢♢	GA
A1 089	Greninja	♢♢♢	GA
A1 095	Raichu	♢♢♢	GA
A1 103	Zapdos	♢♢♢	GA
A1 117	Alakazam	♢♢♢	GA
A1 128	Mewtwo	♢♢♢	GA
A1 145	Machamp	♢♢♢	GA
A1 159	Kabutops	♢♢♢	GA
A1 177	Weezing	♢♢♢	GA
A1 182	Melmetal	♢♢♢	GA
A1 203	Kangaskhan	♢♢♢	GA
A1 210	Aerodactyl	♢♢♢	GA
A1a 014	Volcarona	♢♢♢	MI
A1a 045	Golem	♢♢♢	MI
A2 012	Torterra	♢♢♢	STS
A2 020	Leafeon	♢♢♢	STS
A2 022	Shaymin	♢♢♢	STS
A2 024	Magmortar	♢♢♢	STS
A2 033	Mamoswine	♢♢♢	STS
A2 037	Empoleon	♢♢♢	STS
A2 046	Glaceon	♢♢♢	STS
A2 057	Electivire	♢♢♢	STS
A2 072	Dusknoir	♢♢♢	STS
A2 078	Giratina	♢♢♢	STS
A2 082	Rhyperior	♢♢♢	STS
A2 092	Lucario	♢♢♢	STS
A2 114	Bastiodon	♢♢♢	STS
A2 120	Heatran	♢♢♢	STS
A2 123	Garchomp	♢♢♢	STS
A2a 013	Heatran	♢♢♢	TL
A2a 021	Abomasnow	♢♢♢	TL
A2a 023	Palkia	♢♢♢	TL
A2a 026	Raichu	♢♢♢	TL
A2a 035	Rotom	♢♢♢	TL
A2a 060	Dialga	♢♢♢	TL
A2a 061	Giratina	♢♢♢	TL
A2b 007	Meowscarada	♢♢♢	SR
A2b 012	Magmortar	♢♢♢	SR
A2b 020	Dondozo	♢♢♢	SR
A2b 051	Grafaiai	♢♢♢	SR
A2b 057	Gholdengo	♢♢♢	SR

Hello :)

I'm looking to complete more deck missions and themed collections. Here is what I'm missing:

A1 022	Exeggutor	♢♢♢	GA
A1 035	Charizard	♢♢♢	GA
A1 040	Arcanine	♢♢♢	GA
A1 046	Moltres		♢♢♢	GA
A1 095	Raichu		♢♢♢	GA
A1 128	Mewtwo		♢♢♢	GA
			
A2 007	Yanmega ex	♢♢♢♢	STS
A2 010	Turtwig		♢	STS
A2 017	Combee		♢	STS
A2 024	Magmortar	♢♢♢	STS
A2 029	Infernape ex	♢♢♢♢	STS
A2 035	Piplup		♢	STS
A2 070	Duskull		♢	STS
			
A2a 047	Garchomp ex	♢♢♢♢	TL
A2a 057	Probopass ex	♢♢♢♢	TL
A2a 084	Garchomp ex	☆☆	TL
A2a 093	Garchomp ex	☆☆	TL
			
A2b 010	Charizard ex	♢♢♢♢	SR
A2b 022	Pikachu ex	♢♢♢♢	SR

Wow that room is beautiful, do you have more photos?

When it has offshoots or bark

Did you still need that Snorlax?

I haven't kept up with Pokemon in a few years. This is one of my favorites out of the new ones I'm learning about

Grafaiai is another one. I love that there's a graffiti pokemon 😂

Same idea as Dragonite, only there is less that you can be unlucky about

David Tennant's Kilgrave is hard to beat imo

I'll be checking these threads more often, so I'll be seeing you around

Thank you!

Sounds good, anyway it would be weird to offload more than 2 Celestic Town Elders on you lol

I'll look for ♢ cards from Triumphant Light since you're least likely to have those?

You can have multiple if you wanted, I have 8 of them. Sending one now