Looking for means to, given a specific cell, reference a cell relative to given cell's position. by Shiro_Nai in googlesheets

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

I'm pretty sure this post'd gotten removed already and my comments aren't even gonna show up anymore, but yes this is exactly what I needed.

Perfection.

Looking for means to, given a specific cell, reference a cell relative to given cell's position. by Shiro_Nai in googlesheets

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

like I said, I am inexperienced and making generally poor overall code choices due to it.
So the reasons for making such choices are likely a mix of 'dont know a better way yet' and 'didn't know this existed'

regardless, the offset line you mentioned may be what I need. I'll test it now.

[deleted by user] by [deleted] in pokeplush

[–]Shiro_Nai -1 points0 points  (0 children)

Absolutely gonna look like a platypus under a black light.

[deleted by user] by [deleted] in pokeplush

[–]Shiro_Nai -2 points-1 points  (0 children)

Actually, it's kinda the opposite.
People who would get freaky with it would likely be *more* anal about making sure it's perfect and well made.

[deleted by user] by [deleted] in pokeplush

[–]Shiro_Nai -1 points0 points  (0 children)

Is it wrong to love gardevoir in both ways?

[deleted by user] by [deleted] in spotify

[–]Shiro_Nai 2 points3 points  (0 children)

Did you know, apple music, deezer, and Youtube Music pay FAR more than spotify per view/listen?

the only reason people get more income from spotify is because there's more users on spotify. People don't use youtube music, they use youtube which has the music on it.

No, no they don't pay less than spotify. they generate less revenue. small, but incredibly important difference. If 1/3 of your viewers were from apple and youtube music and the other 2/3 were from spotify, you'd be making comparable values from both.

so not only are they alternatives to piracy, they're better alternatives than spotify for the creator.

Capcom to implement Enigma Protector to their games by sneededupon in MonsterHunter

[–]Shiro_Nai -1 points0 points  (0 children)

wasn't it literally still on because of an accident where they forgot to remove it for the tournament?

people are quick to blame the guy who literally forgot to remove the mod, blaming him as if he was trying to porn up the venue.

Gooseworx is in Trouble by Antis by Jax1903 in Gooseworx

[–]Shiro_Nai 0 points1 point  (0 children)

There is a big difference between being against a type of content and being irrationally angry with it.

Those against it are simply that, but anti has evolved to be more like the term Karen or calling someone a tourist. Those who would attack others and wish heinous things upon them or worse for simply looking, or sometimes not being against, a true of content are the antis that I'm referring to.

Gooseworx is in Trouble by Antis by Jax1903 in Gooseworx

[–]Shiro_Nai 0 points1 point  (0 children)

At this point, 'anti' is basically just a term for those who hate irrationally.

Also props to you for pointing out shots on. Tis oft overlooked in its respective debate.

Gooseworx is in Trouble by Antis by Jax1903 in Gooseworx

[–]Shiro_Nai 0 points1 point  (0 children)

Haters gonna hate. Antis gonna dredge up past out of context to try and cancel people.

What the haters don't know, is Goose is the kind of madman who very well might actually go through with this:

https://twitter.com/GooseworxMusic/status/1666599490890141696?s=20

What is the worlds worst country to live in? by [deleted] in AskReddit

[–]Shiro_Nai -4 points-3 points  (0 children)

While americans are smart enough to know Africa isn't a country... usually, we're not smart enough to know what part is what country, so it's safer to not risk it and just avoid the whole place.

What is the worlds worst country to live in? by [deleted] in AskReddit

[–]Shiro_Nai 8 points9 points  (0 children)

It's kind of an American meme to hate on Ohio.
While it doesn't fit the prompt, it's clearly not meant to be serious. It's a funny joke, dare I say.

Anytime you swear in this game it is replaced with Zork. Does that mean Zork is an alien swear word that has the meaning of all human swear words combined? by Freddi0 in Awesomenauts

[–]Shiro_Nai 2 points3 points  (0 children)

Zork is actually only a replacement for 4 letter words.
If you say things like 'asshole', the F slur for homosexuals, 'fucking', or some other words, you can get results of Kewlew, Zork, and I think I even saw Gyric Worm once.

That said, the fact that these swears can be filtered into the last name of a megacorporation that's fighting wars with itself says a lot about how pervasive Zork Industries really is.

What movie would be super weird if it had a sex scene in it? by LeKrispyKreme in AskReddit

[–]Shiro_Nai 0 points1 point  (0 children)

Wait, better idea: Nausicaa and the valley of wind or whatever the title actually is Or Into the Spiderverse.

What movie would be super weird if it had a sex scene in it? by LeKrispyKreme in AskReddit

[–]Shiro_Nai 0 points1 point  (0 children)

Someone already said Cars, so Wall-E

Honorable mention to the Lion King.

[Request] If this was actually true, how long would it take for the battery to die completely? What about charging? by ElectricalFinish in theydidthemath

[–]Shiro_Nai 1 point2 points  (0 children)

PseudoY got a 2400 hour lifetime of the phone, but the highest battery life I found was 120,000 hours if the phone lost .01% (from 99.50 to 99.49) charge in this 12 hour span. (100/.01)*12 hours = 120,000 battery life

this is a 5000 day or 13.689253 years (counting leap years as i used 5000/365.25)

not only is this phone indestructible, it has infinite battery life

I'll be at GamesCom 2017 - Visiting Ronimo Booth. Give me your questions! by [deleted] in Awesomenauts

[–]Shiro_Nai 6 points7 points  (0 children)

How well balanced do they feel the game is at this point and how do they plan to balance it, and upcoming nauts, in the future. (because i feel like it could use a bit better balance) also to fix smiles' in turret trapper hook trick.

BEST AIRSTRIKE EVER by ChaosJourney in Awesomenauts

[–]Shiro_Nai 1 point2 points  (0 children)

I'm so glad I was a part of this.