Pokémon TCG Pocket

141 readers

5 users here now

Gotta Post'em All!

A community for sharing and discussion about the Pokémon TCG Pocket mobile game.

Finally got that epic pull you've been waiting on? Show it off!

Looking for advice? Ask away!

Trying to complete the card Dex? Come trade with us!

Art sharing and discussion about the physical Pokémon TCG is permitted but please label it clearly to avoid confusion. If you aren't interested in the Pocket edition you may be looking for one of the communities below.

Other active Pokémon communities on Lemmy:

[email protected]

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

Join our SimpleX chat room!

If you prefer a more chat like discussion we maintain a room on SXC just for Pokémon TCG Pocket!

Lemmy breaks this link. Please copy/paste it manually or use the QR code.

https://simplex.chat/contact#%2F%3Fv=2-7&smp=smp%3A%2F%2F1OwYGt-yqOfe2IyVHhxz3ohqo3aCCMjtB-8wn4X_aoY%3D%40smp11.simplex.im%2Ftwv5_eoH4T1iKRRf3hZlwU0kNAJovzko%23%2F%3Fv%3D1-3%26dh%3DMCowBQYDK2VuAyEA2nHfYR-8V_ABE7M506SR6NYxb9OZ0cL5WTJvWyvr4wg%253D%26srv%3D6ioorbm6i3yxmuoezrhjk6f6qgkc4syabh7m3so74xunb5nzr4pwgfqd.onion&data=%7B%22groupLinkId%22%3A%22Y94sPj_zv9uL_6BOWH8EcQ%3D%3D%22%7D

founded 2 months ago

MODERATORS

[email protected]

Trading Post Tuesday (lemmy.world)

submitted 6 days ago by [email protected] to c/[email protected]

73 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

[–] [email protected] 2 points 5 days ago (1 children)

This is beautifully formatted lol.

[–] reef 2 points 5 days 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

[–] [email protected] 3 points 5 days ago

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