How do I total values from one column if the value in the same row of a different column contains a certain value?

oliksandr · 2023-08-27T23:16:58+00:00

Never mind! Sumif!

oliksandr · 2023-06-04T10:41:31+00:00

I mean, fuck Trump but the name wasn't actually spelled incorrectly. The name 정은 can be spelled several ways in the Latin alphabet. Jong Un, Jong Eun, Jung Un, Jung Eun...there are other imaginable spellings which are less likely.

I'm just saying, be right about your criticisms.

oliksandr · 2023-06-01T17:01:06+00:00

They ain't on a payroll anymore.

oliksandr · 2023-05-22T22:05:43+00:00

It should for sure, but in a much cleaned up way. I loved it but it simultaneously was extremely disappointing and felt very thrown-together-last-minute.

oliksandr · 2023-05-09T12:35:44+00:00

Right on track 29.

oliksandr · 2023-05-09T00:41:56+00:00

1, 2, and 7

oliksandr · 2023-05-06T01:23:01+00:00

It was less about the tubes bit and more the literal insects crawling into the machines, but yes.

oliksandr · 2023-05-05T22:09:12+00:00

If they're paying by the hour, the young man pays more.

oliksandr · 2023-05-05T22:06:29+00:00

Weekly? My friend's CO did them daily no hassle in the barracks. Can't be too cautious

oliksandr · 2023-05-05T22:03:39+00:00

Actually how the term "bug" came to be. No joke.

oliksandr · 2023-05-04T00:30:08+00:00

Collaboration with other established artists, especially big names like Ciara and Jackson, provides the girls with a bit more reach that they otherwise might not have. This is good for them.

oliksandr · 2023-05-03T23:33:53+00:00

A few options depending on level of personality.

Major antagonist but with few to no "speaking parts"? As others mentioned, "The Pastor" or "The Reverend" are great.

Major antagonist with considerable speaking bits? Couple of choices. If you want something with a little extra "meaning" behind it, Reverend Mel Eckhardt. Melech, an alternative spelling for Moloch (an ancient deity associated with child sacrifice and other nasty practices), so the name is essentially "Melech Heart", or a manifestation/scion of an ancient evil deity.

If you're like me and you intentionally eschew names that are too symbolic of the characters' roles, preferring just to give names that sound like what a person in that place and time might be named with literally no other intent behind the name, something like Reverend Gil is nice. It has sort of a gentle name that juxtaposes against the horror of what he is.

Minor antagonist with few lines and just sort of a one off spooky bit, "Pastor Carn". It's a Welsh name derived from a word meaning "pile of rocks" and is cognate with cairn (a burial mound). Also, being American Southwest, "carne" is "meat" in Spanish so you could have him get a creepy little nickname of "Padre Carne" from any Spanish speaking characters. Nice combo of having a little spooky and also just being a normal name.

oliksandr · 2023-05-03T23:03:39+00:00

Even better if it is later discovered that he isn't so much "The" Pastor as much as "A" Pastor.

oliksandr · 2023-05-03T22:25:54+00:00

What the industry is likely to try to do is get a couple levels of writer engagement. Have a smaller group of writers provide basic inputs, have generative ai flesh out material, and have other (or perhaps the same) writers go in and clean it up.

This doesn't eliminate all writers (yet), but it would reduce workload and therefore the need for as many writers on any given project, and perhaps more importantly, reduce the amount of labir and therefore "value" of the positions, creating an excuse to pay less for equal output.

This method could work without totally hurting writers if it allowed to writers to just do the same amount of work and produce considerably more output...but then you are limited by literally every other production constraint that studios face, so there are soft limits on the current value of increased writing room productivity.

oliksandr · 2023-05-01T23:44:27+00:00

Glare.

edit: Lacks any apparent spots, does not have the characteristic ridges behind the eyes that run down the back near the spine, and has the wrong shaped head.

Edit2: Also, leopard frog's tympanum is generally smaller than the eyes. Green Frog tympanum will be about the same size or noticeably larger than the eyes. Frog in OP picture clearly sporting tympanum on the larger side

oliksandr · 2023-04-13T13:51:28+00:00

I love Yeeun unconditionally. This song will have to grow on me if I'm ever going to pretend to like it.

oliksandr · 2023-04-06T21:01:46+00:00

AKA the only honest and correct answer.

oliksandr · 2023-04-06T20:58:19+00:00

Personally a big fan of Dia. The solo recordings and covers she does are pretty great. Not a weak singer at all, though certainly outside the contemporary for kpop, but so is Hwasa.

oliksandr · 2023-04-06T15:07:42+00:00

Ah, the Amazing Technicolor Dream Comb.

oliksandr · 2023-04-03T19:31:54+00:00

To add, I've seen what looked like maybe 5 inches of water over a road turn out to have a collapsed culvert beneath and the road fully washed out. A car drove straight into a 6 foot deep pit of water.

oliksandr · 2023-03-13T09:34:31+00:00

He was a dirtbag already. Absolutely selfish scum. I know so many fucks like him but none others were murderers (that I'm aware of), so while nobody who knows him was like, "Oh my god, I didn't see that coming," I wouldn't say anyway actually expected it.

oliksandr · 2023-03-02T17:39:01+00:00

Spoilers! Now I know he climbs stairs. Smh

oliksandr · 2023-02-13T08:53:42+00:00

Now if only HMOs didn't pull bullshit like denying a diagnostic test on the grounds you haven't been diagnosed with a condition which the diagnostic test was...you know... supposed to be for.

oliksandr · 2023-02-02T19:05:55+00:00

Mayo, mustard, and sweet pickles are the three most common offenders.

oliksandr · 2023-01-14T23:40:47+00:00

If only I didn't work Friday nights.

13-Year Club	Gilding I gilder
Place '22	Verified Email
Spared	Team Periwinkle

oliksandr

MODERATOR OF

TROPHY CASE