Pokémon TCG Pocket

282 readers

6 users here now

Kick back and open some packs!

Welcome to our corner of the Poké-verse. This is a community for sharing and discussing the Pokémon TCG Pocket mobile game. Whether you're a hardcore collector or a casual fan, thanks for checking us out!

What We Do Here

Card Pulls: Show off those epic pulls you've been waiting on.
Help & Advice: Community support for mission help or deck building.
Trading: A place to find others to trade with and complete your Dex.

Physical TCG & Art

Sharing art and discussing the physical TCG is permitted. To keep things organized, please label these posts clearly so they aren't confused with the Pocket edition.

Useful Resources

Textless Game Art:
Pokéos

Deck Ideas & Meta:
Game8

Other Pokémon Communities

If you are looking for more general Pokémon discussion, check out these spots:

!pokemon@sopuli.xyz
!pokemon@lemmy.ml

If you’d like your community added to this list, please message a mod.

founded 1 year ago

MODERATORS

FrostyTrichs@crazypeople.online

sunoc@sh.itjust.works

FrostyTrichs@testing.crazypeople.online

Endmaker@ani.social

Trading Post Tuesday (lemmy.world)

submitted 10 months ago by Idreamofcheesy@lemmy.world to c/pokemonTCGM@crazypeople.online

72 comments fedilink hide all child comments

Anyone get any good pulls this week? Maybe a couple duplicates you want to offload?

Post a list of what you're looking for, people will reply with what they'd like in exchange.

you are viewing a single comment's thread
view the rest of the comments

[–] FrostyTrichs@crazypeople.online 2 points 10 months ago (1 children)

This is beautifully formatted lol.

[–] reef@lemmy.ca 2 points 10 months ago (1 children)

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

[–] FrostyTrichs@crazypeople.online 3 points 10 months ago

Saving this comment for later. That's bound to be useful as the set lists expand.