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.

    • Reef@lemmy.ca
      2·
      8 days ago

      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