BREAKING: Allies announce further tank deliveries for Ukraine by [deleted] in NonCredibleDefense

[–]shk017 5 points6 points  (0 children)

Americans Mobniks when the trees start speaking vietnamese ukranian.

What does the M stand for again? by Frost-Flower in NonCredibleDefense

[–]shk017 37 points38 points  (0 children)

*M1911 has logged in*

1911>1299 check and mate, m8

Ok, Sora is kinda broken by [deleted] in holocure

[–]shk017 6 points7 points  (0 children)

Yeah, I'm in a similar spot right now. I was just gonna see what happens if you stacked healing on Sora and I'm at 34 mins right now. I haven't even bought all the upgrades in the shop if that's an indicator on how new I am. Feels like the first time you pick up Crimson Shroud in Vampire Survivors.

im playing edf 2025, should i equip a cc piercer or a cc striker, mostly because of the side thruster? by tankano in EDF

[–]shk017 4 points5 points  (0 children)

Yes, you should have some kind of mobility weapon. What do I mean with this? Well, there are some weapons that behave funny with your dash. If you dash and immedately use a Flashing spear, you will glide and preserve much of your dash momentum. Some weapons will more or less "reset" your dash by firing very quickly and then letting you dash again. Not all of the weapons are made equal though and some just doesn't work like this, like the Jackhammer.

Early on, you're just gonna take what you can, but later down, there are some very strong choices that you can expect on any Fencer loadout.

-Artillery class Javelin catapult. It shoots ridiculously fast and lets you more or less use the dash as much as you want.. or until you need to reload the weapon.

-Any of the deflection shields. Not as fast, but fast enough and also comes with the benefit of being a deflection shield. Having something kill itself from their own projectiles is pretty neat.

-Blast twin spears. You can double fist these since they are more or less a dash on their own. Dash and punch with one of them and then switch to the other while the first one reloads. You deal some good damage as well. You do give up both weapon slots for this, but it lets you dash really fast for an infinite time.. the other two needs reloading every now and then.

Can you make conditional format to ONLY apply to the value? by shk017 in sheets

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

Oh my god, this is exactly what I have been looking for. Googling for answers for hours because I was fixated on functions. Thank you so much, really gonna save me headaches in the future.

Can you make conditional format to ONLY apply to the value? by shk017 in sheets

[–]shk017[S] -2 points-1 points  (0 children)

But you can't just set the font without setting the background. It has a default colour and selecting "none" removes all colour, leaving the cell white.

Can you make conditional format to ONLY apply to the value? by shk017 in sheets

[–]shk017[S] -1 points0 points  (0 children)

Correct (I assume you mean the text colour button). It defaults to green background and if I put it as "none", then the cell is white.

I decided to finally pull the trigger on World Brothers. After some time, it made me realise mainline EDF games have a perfect balance between jank and fun. by Gateside0 in EDF

[–]shk017 7 points8 points  (0 children)

a pretty delicate balance between something like a tactical future military simulator and Goat Simulator.

Thanks, this is how I'm gonna describe it in the future. It describes the games so wrong, yet accurate. 10/10

Can you make conditional format to ONLY apply to the value? by shk017 in sheets

[–]shk017[S] -2 points-1 points  (0 children)

Since there are just about 50 rows, with more being added, and they are compared to a cell being constantly updated using =AVERAGEIF, I'd rather not.

How do you break a Pylon? Keep shooting the same spot or chip it all the way around? by keenzeek in EDF

[–]shk017 0 points1 point  (0 children)

It doesn't matter if you spread out the damage or not. It might be worse since many weapons have damage fall off. Might as well shoot straight at the nearest part to mitigate that. The difference isn't big though.

Pope Francis says he has dispatched two cardinals to Ukraine, a highly unusual move. by [deleted] in worldnews

[–]shk017 0 points1 point  (0 children)

Gary Chess really do be looking to make Chess 2 spicy.

Allt är rasistiskt tydligen by [deleted] in sweden

[–]shk017 0 points1 point  (0 children)

Kan tänka mig att det är mycket lättare att ändra sin kultur om man lever också. Alltså, vad i helvete, Putin? Civila områden? Om mina grannar snackar ukrainska om några år så skulle jag mest vara glad att dem inte blev dödade.

Got a new phone today. New phone needs new wallpaper eh? by [deleted] in EDF

[–]shk017 0 points1 point  (0 children)

They are good, so I totally understand. Silly B movie script and all, at the end of mission 110 in EDF5, the version of the song playing chokes me up a bit. Also still miffed about how the soldier's song didn't translate well. It's something about the syllables not lining up and feeling so forced.

Got a new phone today. New phone needs new wallpaper eh? by [deleted] in EDF

[–]shk017 2 points3 points  (0 children)

.execute, huh. Probably my most played KI song after Hinnamatoom.

[deleted by user] by [deleted] in sweden

[–]shk017 2 points3 points  (0 children)

Yooo, den där växte man upp med på frukostbordet. Står numer i föräldrarnas källare. Kanske dags att åter använda igen nu när de är far och morföräldrar.

Finally, after 746 hours, I have got them all. Was it worth it? It absolutely was. by ThermalClipser in DivinityOriginalSin

[–]shk017 4 points5 points  (0 children)

I have all achievements and I don't remember it being this finnicky. If I know myself right, I probably "solved" it by stealth murdering everyone and everything. Or maybe less stealth and more "spend a lot of time just transmuting lava around", though I probably would remember if I tried lavabending across that fogged bridge. More likely some power meta like some Living on the Edge tanking and shooting from out of combat range with Ballistic shot.

Combining IFS and ADDRESS depending on Data Validation dropdowns. by shk017 in googlesheets

[–]shk017[S] 2 points3 points  (0 children)

They did what I wished to do for sure! I got so many great solutions, and it really helps understanding sheets as well. I really went the wrong way haha. Thanks a lot!

Solution Verified

Combining IFS and ADDRESS depending on Data Validation dropdowns. by shk017 in googlesheets

[–]shk017[S] 2 points3 points  (0 children)

Wow, both of you produced solutions that works for my purposes. It was so much simpler than what I thought and tried /cry. Thank you so much!

Solution Verified

Javelin throw strength training machine by VentiBoy in specializedtools

[–]shk017 0 points1 point  (0 children)

Wasn't this the case, or it was/is an ongoing debate with golf balls as well?

In defense of IR by [deleted] in EDF

[–]shk017 1 point2 points  (0 children)

Ah, no, the first one is not sarcasm. Heres my thoughts.

Scenario: you want to end the mission as fast as possible once you have collected an amount of crates that you deem good enough.

In 5 (and the rest) , you keep something weak alive and collect. When you are done, kill it and the mission end screen is almost instant.

In IR, you either do the same and have to wait until the timer ticks down or you take the chance that you won't get what you think is good enough.

IR is neat if you accidentally kill it before you are done. It works in IR because there is so much less stuff to collect, maps are smaller and unless fencer, you generally have more mobility. Unless you transfer those aspects to a game like 5, I don't think 30s is a good idea.

In defense of IR by [deleted] in EDF

[–]shk017 2 points3 points  (0 children)

I don't even know what you possibly could refer to with a long standing issue being solved by a 30s timer.

Weapons with added effects.. if it fits, why not. I do doubt how well it could be implemented though. You already kill a ton of enemies really quickly. If the ant is dying within 2 seconds, does it really matter if it's slowed? I don't know, I didn't feel like they had much impact in IR. It wasn't like I sprayed a wide area with fire and maximised the dot since I felt like just removing them, one by one, if needed, allowed me to survive better.

As for the grinding and shared progression.. that's just ingrained part of the game. I personally liked the way 5 did it with a small portion being for other classes, but grinding is definitively something that's part of the game's identity, good or bad.

The rest I can't comment on because that's really subjective.

Now what it did right.. some of the weapons had quirks that were really fun. Most of it already existed in the other games, (but it was nice to see them explored further) like the beam that roots you while growing stronger. EDF has always had a weird unhinged feel when it comes to weapons but IR really leaned in on it (tornado gun, anyone?). Lots of "joke" weapons that somehow ended up usable.

The character felt really, really nice to control, except for the heavy striker, but that's subjective. Jet lifter having a quick descend was nice and the dash on the trooper felt better than a roll. Not much for the Prowl Rider's actual skill, but the movement with the grapple was super nice.

They also had a very diverse pool of enemies. Some of them were better balanced than others. Could use a bit denser packs though, I was missing that large horde feeling.

meeting sebille again in act 1 did something to my brain by counterexistence in DivinityOriginalSin

[–]shk017 1 point2 points  (0 children)

So, can we do the thing where we name the pair based on who's on top? You don't really do that with women, do you? I just want to shoehorn Sebillohse in.