reef

joined 2 years ago
MODERATOR OF
lupin2021
steamedhams
sorted by: new top controversial old
[DISCUSSION] [SPOILERS] Daredevil: Born Again S01E09 in c/marvelstudios@lemmy.world
[–] reef@lemmy.ca 4 points 3 months ago

Oh was that the finale? I thought it was building up to a big finale next episode

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago

Sending a request now, I'm the Pikachu icon

I might be getting the Magnezone from someone else, but the A1 022 Exeggutor for A1a 031 Mew sounds perfect. I'll start a new trade once my other ones clear

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago (4 children)

😎

I used this spreadsheet + this formula I generated to list everything that I am missing:

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

=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)

I sent a friend request, pikachu icon!

Unfortunately I don't have that magnemite, but I'll start the 028 Manectric for the 140 Purugly as soon as my next trade clears. Thank you!

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago* (last edited 3 months ago)

A1 084 Articuno ex

Unfortunately no, I have 0 of those. Congrats on almost being done 🥳

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago* (last edited 3 months ago) (6 children)

I have A2a 028 Manectric ♢♢

I could use:

  • A2 140 Purugly ♢♢ STS

or any of

A1 015	Parasect	♢♢	1	Genetic Apex
A1 060	Poliwhirl	♢♢	1	Genetic Apex
A1 088	Frogadier	♢♢	1	Genetic Apex
A1 150	Onix	♢♢	1	Genetic Apex
A1 161	Mienshao	♢♢	0	Genetic Apex
A1 224	Brock	♢♢	1	Genetic Apex
A1 226	Lt. Surge	♢♢	1	Genetic Apex
A2 005	Tangrowth	♢♢	0	Space-Time Smackdown
A2 084	Gliscor	♢♢	1	Space-Time Smackdown
A2 094	Hippowdon	♢♢	1	Space-Time Smackdown
A2 097	Honchkrow	♢♢	1	Space-Time Smackdown
A2 104	Spiritomb	♢♢	1	Space-Time Smackdown
A2 112	Registeel	♢♢	1	Space-Time Smackdown
A2 128	Porygon2	♢♢	0	Space-Time Smackdown
A2 140	Purugly	♢♢	-1	Space-Time Smackdown
A2a 019	Froslass	♢♢	1	Triumphant Light
A2a 024	Phione	♢♢	1	Triumphant Light
A2a 034	Unown	♢♢	1	Triumphant Light
A2a 072	Irida	♢♢	1	Triumphant Light
A2b 015	Tentacruel	♢♢	1	Shining Revelry

I also have A2a 053 Magnemite Arceus ♢

I could use

A2 010	Turtwig		♢	STS
A2 017	Combee		♢	STS
A2 035	Piplup		♢	STS
A2 070	Duskull		♢	STS

or any of

A1 024	Tangela	♢	1	Genetic Apex
A1 059	Poliwag	♢	1	Genetic Apex
A1 070	Horsea	♢	1	Genetic Apex
A1 191	Spearow	♢	1	Genetic Apex
A1 194	Wigglytuff	♢	1	Genetic Apex
A2 010	Turtwig	♢	-2	Space-Time Smackdown
A2 017	Combee	♢	-1	Space-Time Smackdown
A2 035	Piplup	♢	-2	Space-Time Smackdown
A2 070	Duskull	♢	-1	Space-Time Smackdown
A2 136	Bibarel	♢	1	Space-Time Smackdown

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago* (last edited 3 months ago) (6 children)

I have

  • A2a 010 Leafeon ex Arceus ♢♢♢♢

I could use A1 195 Wigglytuff ex ♢♢♢♢ Genetic Apex

I have

  • A1 125 Hypno Pikachu ♢♢♢
  • A1 171 Nidoking Pikachu ♢♢♢
  • A2 089 Rampardos Dialga ex ♢♢♢

I could use (in order)

  • A2 024 Magmortar ♢♢♢ STS
  • A1 040 Arcanine ♢♢♢ Genetic Apex
  • A1 080 Vaporeon ♢♢♢ Genetic Apex

I have

  • A2 122 Gabite Palkia ex ♢♢
  • A2 134 Staraptor Palkia ex ♢♢
  • A2 152 Cynthia Palkia ex ♢♢
  • A2 147 Giant Cape Dialga ex ♢♢

I could use:

  • A2 140 Purugly ♢♢ STS

::: spoiler or any of

A1 015	Parasect	♢♢	1	Genetic Apex
A1 060	Poliwhirl	♢♢	1	Genetic Apex
A1 088	Frogadier	♢♢	1	Genetic Apex
A1 150	Onix	♢♢	1	Genetic Apex
A1 161	Mienshao	♢♢	0	Genetic Apex
A1 224	Brock	♢♢	1	Genetic Apex
A1 226	Lt. Surge	♢♢	1	Genetic Apex
A2 005	Tangrowth	♢♢	0	Space-Time Smackdown
A2 084	Gliscor	♢♢	1	Space-Time Smackdown
A2 094	Hippowdon	♢♢	1	Space-Time Smackdown
A2 097	Honchkrow	♢♢	1	Space-Time Smackdown
A2 104	Spiritomb	♢♢	1	Space-Time Smackdown
A2 112	Registeel	♢♢	1	Space-Time Smackdown
A2 128	Porygon2	♢♢	0	Space-Time Smackdown
A2 140	Purugly	♢♢	-1	Space-Time Smackdown
A2a 019	Froslass	♢♢	1	Triumphant Light
A2a 024	Phione	♢♢	1	Triumphant Light
A2a 034	Unown	♢♢	1	Triumphant Light
A2a 072	Irida	♢♢	1	Triumphant Light
A2b 015	Tentacruel	♢♢	1	Shining Revelry
Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 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

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago* (last edited 3 months ago)

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

Every ♢♢♢ I could use at least 1 more of

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

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 2 points 3 months ago* (last edited 3 months ago) (5 children)

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
Just got the crib into our first child's nursery, and the cat wasted no time in claiming the territory. in c/pics@lemmy.world
[–] reef@lemmy.ca 5 points 4 months ago

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

All Rise in c/stick@sh.itjust.works
[–] reef@lemmy.ca 2 points 4 months ago

When it has offshoots or bark

Trading Post Tuesday in c/pokemonTCGM@crazypeople.online
[–] reef@lemmy.ca 1 points 4 months ago

Did you still need that Snorlax?

10
c/MusicVideos - Share cool music videos (lemmy.world)
submitted 11 months ago* (last edited 11 months ago) by reef@lemmy.ca to c/communitypromo@lemmy.ca
2 comments fedilink
 

I was thinking about how I missed music videos. Found this one and thought it could use more subscribers

Edit:

Fixed link

!musicvideos@lemmy.world

46
What is a song that you can't help but move to, even a little? (lemmy.ca)
submitted 11 months ago* (last edited 11 months ago) by reef@lemmy.ca to c/asklemmy@lemmy.world
24 comments fedilink
 

This song came on while I was getting ready this morning

Forget Me Nots - Patrice Rushen (1982)

Original non-remastered version

I had to stop for a quick clap clap each time

17
Tron/Nine Inch Nails Music Video Trailer (a student project from 2011) (www.youtube.com)
 

Created for Non Linear Editing class using Final Cut Pro at the University of Houston.

13
Batman: Caped Crusader | Opening Title Sequence (youtube.com)
 

I love this aesthetic

247
These mouth guards are flavored? (lemmy.ca)
 

The idea makes me uncomfortable and I can't explain why

15
Steamed Hams but it's Basket Case by Green Day (www.youtube.com)
submitted 1 year ago* (last edited 1 year ago) by reef@lemmy.ca to c/steamedhams@lemmy.ca
0 comments fedilink
37
What song have you listened to a lot recently? (lemmy.ca)
 

I came across Self Control - Laura Branigan again recently, and that would be my pick

33
Steamed Hams but it all takes place inside the opening sequence (www.youtube.com)
18
Tokyo Underground - Short Film (R35 GT-R, BMW E30, FD RX-7, Honda NSX and more) (www.youtube.com)
submitted 1 year ago* (last edited 1 year ago) by reef@lemmy.ca to c/videos@lemmy.world
3 comments fedilink
 

The visuals, I just think they're neat

40 minutes worth of new wallpaper material

76
What's the worst hacking scene from any movie or show? (youtube.com)
 

Just saw this one

Two people one keyboard also comes to mind

76
TIL that the song from the time machine episode was a parody of "Zager And Evans - In The Year 2525" (youtube.com)
296
Julia Louis-Dreyfus Calls ‘Bulls—‘ Over Complaints That ‘Comics Can’t Be Funny Now’ Due to P.C. Culture: It’s Not an ‘Impossible Time to Be Funny’ (variety.com)
view more: ‹ prev next ›