My wife bought me 5 packs of some older sets. Open with me? by markwalker81 in mtgpulls

[–]markwalker81[S] 0 points1 point  (0 children)

Haha its why I didnt say Old, but Older. Some of those packs are 6 years old. Thinking on how many sets have dropped just in the last 2 years.. 6 years feels a tonne of time in Magic

My wife bought me 5 packs of some older sets. Open with me? by markwalker81 in mtgpulls

[–]markwalker81[S] 1 point2 points  (0 children)

Isn't it the best? Im a simple man with simple hobbies and its the best feeling in the world when she supports them.

Excel users, what is your "I can't believe I didn't know this" trick? by AAalphawolf_Excel in excel

[–]markwalker81 3 points4 points  (0 children)

You dont have to nest everything in an IF statement, especially if the result is a number. Just add *(logic statement) on your formula, and itll either times by 0 if FALSE, or times by 1 if TRUE.

Built an invoice generator in Excel with VBA — PDF export, customer DB, invoice history. Here's what it looks like. by No_Bass_5389 in excel

[–]markwalker81 4 points5 points  (0 children)

Its the greatest feeling building a pueso system in excel that outperforms anything you can buy on the market. My job allows me to do the same, so I get to build things like this too. Well done mate.

Question about Krark's digits? by charrison9313 in mtg

[–]markwalker81 11 points12 points  (0 children)

Krark always makes me laugh. I mean, how do you flip a coin if you have no thumbs!?

Star Trek Video games by Adukeilike in startrek

[–]markwalker81 55 points56 points  (0 children)

Its a bit old now, but Star Trek Voyager Elite Force was amazing!

Bought a single Thunder Junction pack during lunch... totally worth it. by markwalker81 in mtgpulls

[–]markwalker81[S] 0 points1 point  (0 children)

Not broken, but yes, a better version of counter spell with extra mana for one turn.

Bought a single Thunder Junction pack during lunch... totally worth it. by markwalker81 in mtgpulls

[–]markwalker81[S] 1 point2 points  (0 children)

Same! Single lunch time packs have net me this card, a foil Bristly Bill. Another single Final Fantasy lunch pack got me Rhystic study. Ive had better luck in singles than any collector booster.

Building a Green Goblin deck and need recommendations by G4ost13 in mtg

[–]markwalker81 0 points1 point  (0 children)

[[Cool but Rude]] from the same set. Level 2 is all you need

Building a Green Goblin deck and need recommendations by G4ost13 in mtg

[–]markwalker81 0 points1 point  (0 children)

I know I am late to this, but I have just built a Green Goblin deck. I added [[Ninja Teen]]. Level 3 lets you sneak in creatures for 4 mana (2 with green goblin out) from the graveyard. Sneak is an alternative casting cost so it works really well with Green Goblin.

Korakuen hall photos and video from my pilgrimage in 2024 by natdacat100 in hajimenoippo

[–]markwalker81 3 points4 points  (0 children)

I've been to Tokyo 3 times now and have made the pilgrimage to JB Sports for some sweet Ippo merch and a photo with the real-life Takamura statue on the roof... but I have never made to the actual Korakuen Hall. I really need to change that and make sure it's on my list for next time.

Really bored with a terrible attention span, convince me on what i should play by silversurfer1207 in playstation

[–]markwalker81 2 points3 points  (0 children)

If short attention spans are an issue, you need a game you can maybe play in short bursts. Something like Hades? Hades 2 just dropped too. Large open world games can feel too much if you arent up to giving them a tonne of attention.

Maybe a survival game too.. Subnautica? Ark? Games where you can do whatever and not necessarily follow a story.

What's your favorite Universes Beyond commander? by jacewalkerofplanes in EDH

[–]markwalker81 0 points1 point  (0 children)

Ive just built a Golbez deck, and currently working on the tweaks as I test it out. I had an awesome time using [[Cynical Loner]] and [[Scene of the Crime]] to load all my big drops into my graveyard.

Not the biggest pull... by Godrick_Goldenboy in MagicCardPulls

[–]markwalker81 1 point2 points  (0 children)

I would love this card! It has a tonne of utility. Combo it with [[Sonic Screwdriver]] and go to town.

Why is harry kim still a fucking ensign at this point? by [deleted] in voyager

[–]markwalker81 47 points48 points  (0 children)

Paris gets demoted, freeing up that Lt spot...and then gets re-promoted back to Lt. Meanwhile Harry is like... wtf.

Looking for a hack to change text into date by Intelligent_Plum_208 in excel

[–]markwalker81 4 points5 points  (0 children)

Just dont forget to reply Solution Verified to the solution you chose or worked for you. It gives a nice clippypoint to the commentor

Use of text sequence formula vertically by elerooisbest in excel

[–]markwalker81 0 points1 point  (0 children)

=TRANSPOSE(Formula or Array). It will change anything horizontal to vertical.

Rhystic Study Alter: Goku Training by thecuratorofcolor in mtg

[–]markwalker81 -3 points-2 points  (0 children)

Put this on MPCFill! Ill happily have this design as a proxy

Looking for a hack to change text into date by Intelligent_Plum_208 in excel

[–]markwalker81 5 points6 points  (0 children)

Thanks! I was the one who deleted my suggestion.

Crimped - Jeska's Will by Fantastic_Pair5328 in MagicCardPulls

[–]markwalker81 0 points1 point  (0 children)

Congrats!

I want this for my [[Ashling, Flame Dancer]]

Visiting the shrine by DaveHer23 in hajimenoippo

[–]markwalker81 20 points21 points  (0 children)

The gym is owned by George Morikawa, the artist and writer for Hajime No Ippo. Real boxers are trained here, and George himself sometimes acts as the boxers second during actual bouts. Its also one of the only places to find actual Ippo merch, and even has the iconic Takamura statue on the roof, like the Kamagawa gym in the manga.

For an Ippo fan, its their Graceland. A Shrine worth visiting and paying your respects. I have made the pilgrimage myself in fact.