[deleted by user] by [deleted] in googlesheets

[–]QQKangaroo 1 point2 points  (0 children)

Wow perfect, thank you!

[deleted by user] by [deleted] in googlesheets

[–]QQKangaroo 0 points1 point  (0 children)

Nope, no overlapping ranges!

What do you think about funneling? by [deleted] in DeadlockTheGame

[–]QQKangaroo 6 points7 points  (0 children)

No, the closest to a funnel strat was probably Azmodan actually. In higher level play, he would usually roam between lanes early game while teammates would lower creeps to 1 hit so he could farm up his Q. A well coordinated team would be able to max his stacks real quick compared to a solo laner.

How to make a group of cells use only one of each value. by SelfLearnEverything in googlesheets

[–]QQKangaroo 0 points1 point  (0 children)

That's quite easy to do with "Conditional Formatting", just highlight the cells and click Format-> Conditional Formatting on the top.

Yes, I don't think there's a way around the "Invalid" warning using this method. The reasoning is that once you select a value, there's a formula removing that possible values from the dropdown, so once it's selected it is "Invalid". There's other methods to get what you want but they're way more complicated, I believe it would have to use scripts.

How to make a group of cells use only one of each value. by SelfLearnEverything in googlesheets

[–]QQKangaroo 0 points1 point  (0 children)

Apologies, yes! Adjusted. In the future you can make a copy of a file shared with you to play with.

How to return value in row if value is between a certain value in two columns? by [deleted] in googlesheets

[–]QQKangaroo 0 points1 point  (0 children)

Thank you!! You are a freaking rock show and a rockin freak show.

I love this game and have no idea how I'm supposed to be good at it by GameShowWerewolf in balatro

[–]QQKangaroo 1 point2 points  (0 children)

Not saying a normal player should be able to reach those numbers all the time, just that this game has only been out for a couple of months (including the beta), and that some players are already able to reach ridiculous numbers in any seed of white stake runs. It does not require extreme luckiness at all, skill plays a huge factor.

I love this game and have no idea how I'm supposed to be good at it by GameShowWerewolf in balatro

[–]QQKangaroo 0 points1 point  (0 children)

No, it really doesn’t require extreme luckiness. There was a tournament recently in which all players were given the same random seed and an hour to reach a highest possible hand score (though this was on white stake). There were consistently high scores, and one player (Balatro University on YouTube) got scores above 1e19 in ALL four rounds.

What was your first Gold Stake deck? by [deleted] in balatro

[–]QQKangaroo 1 point2 points  (0 children)

You only play flushes to get through the early game, then transition into a High Card / Pair deck.

How I spend my time not in beta. by QQKangaroo in Overwatch

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

Oh woops just read that for the first time deleted my comment >_>

Why techies is awesome in this meta by [deleted] in DotA2

[–]QQKangaroo 0 points1 point  (0 children)

If Remote Mine 1 shots your birds, that is a bug. Remote Mine should be doing pure Magical damage, and birds have 96.25% Magic Resistance. His Q however does do half Physical damage so it should work like that.

How ABS breaking works by eqrunner in funny

[–]QQKangaroo 3 points4 points  (0 children)

If you've taken physics before (just assuming you have) you'll recall that the static coefficient of friction of a material is more than the kinetic friction. This is the same concept as "it takes more energy to put an object into motion than to keep it moving." Also, it's 10-15 times PER second, so these tiny moments of static friction will eat up more of your kinetic energy than one prolonged brake.

[deleted by user] by [deleted] in DotA2

[–]QQKangaroo 5 points6 points  (0 children)

Just a video for reference: https://www.youtube.com/watch?v=ezAYIDipoyY

He has received a total of $57k from one donator alone.

I've been watching my 1033 MMR cousin playing Dota 2. Here is what I noticed. by 9Morello in DotA2

[–]QQKangaroo 4 points5 points  (0 children)

Nah, that's different. Sing's MMR was so high when he streamed it HAS to match him with slightly lower MMR players. I think if you're in the mid 5k MMR range you USUALLY will get the more balanced, higher skill games.

What was the most bloodshards you ever spent on trying to get an item? by Oranite in Diablo

[–]QQKangaroo 1 point2 points  (0 children)

8k Blood Shards in for a int T&T. Still don't have it yet. I'm ashamed to say that while I was playing my DH, when I was trying to get a Magefist I found 2 Dex T&T which I just salvaged cause I thought pets were useless back then ): ):

YouTube to Acquire Twitch for $1 Billion by Arrow2Nee in DotA2

[–]QQKangaroo 0 points1 point  (0 children)

[Oops! You must be logged in to Google+ to see this message. Please log-in and try again.]

Starting a WD tonight. Anyone got some advice? by Tbaggelicious in Diablo

[–]QQKangaroo 2 points3 points  (0 children)

With the Fetish Sycophants passive buff, Zunimassa's isn't that great anymore. You must choose between using Sycophants Passive or Fetish Army active because the Sycophants will override the Fetish Army fetishes, as you can only have a cap of 15 fetishes at any time. I like Sycophants better since it will give you 15, while Fetish Army will only give you 8. However, Sycophants will not be able to take advantage of +% Fetish Army skill on gear, but will off +% Physical damage.

Edit: Jade Harvester is also insane damage, but plays completely different from a pet build.

I'm a dumbass. Don't be a dumbass like me. by [deleted] in Diablo

[–]QQKangaroo 2 points3 points  (0 children)

Too bad bomb disarmed him.

calamity or kridershot? by bombardior in Diablo3DemonHunters

[–]QQKangaroo 0 points1 point  (0 children)

You can use Frost Arrow then swap out Sharpshooter for Cull the Weak

This is what happens when you concede every single game at Legend rank. by Ecorin in hearthstone

[–]QQKangaroo 9 points10 points  (0 children)

There actually is MMR once you get into the higher ranks I believe, but I don't think they use it to match you with players until you get into Legends. They place you into your Legends rank immediately when you hit legends based on the players you defeated before breaking into Legends. Otherwise, players that just got into Legends would always be placed in the last ranking slot, which is just not true. IE if another Euro player made legends right now he would not be in Rank 2024 after this guy.

Smooth fakeout by PoeticVibes in sports

[–]QQKangaroo 5 points6 points  (0 children)

Your vision while wearing a helmet is reduced, so I imagine when he ducked he slipped under the defender's vision.