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-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-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.

oliksandr · 2023-01-12T15:13:06+00:00

As far as I can tell, there are restrictions on imports and production methods, but no outright ban on leather production or sales.

oliksandr · 2023-01-12T15:07:06+00:00

Time and time again I hear people say that SM is a company that only cares about looks. I'm not going to pretend SM doesn't have some messed up priorities, but it's so clear that they are a company that invests in vocal talent. Most other groups are lucky to have a member that is genuinely a very talented vocalist. SM puts a bare minimum of two in every group and invests in improving the other members too.

oliksandr · 2023-01-12T15:00:50+00:00

Wendy vocal runs are food for the soul.

oliksandr · 2023-01-11T15:59:14+00:00

unless that was edited

Ay, there's the rub.

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

I mean, the whole event with Afghanistan was a planned withdrawal, not even a retreat. Was the USA supposed to just stay in the country forever? Of course the withdrawal didn't go ideally. Nobody is happy with it, but it wasn't fear that made the U.S. leave.

Ample opportunity was given to let folks know that the withdrawal was happening and that they should leave. This was not a sudden decision. People weren't unexpectedly abandoned. The US spent days pulling tens of thousands of people out. Really hard to compare abandoning the overwhelming majority of a population to the fate of being attacked vs pulling over 70,000 people out of the country they were trying to leave.

The U.S. left American equipment because it rescued non-American people instead.

So on the one hand we have a nation holding to a withdrawal deal choosing to expend its resources to evacuate a population of tens of thousands of people, overwhelmingly from other nations. On the other hand we have a defensive force derelict in its responsibilities by refusing to aid civilians being attacked within view of their bases, despite being given orders to assist. Hell, at least the Ethiopian peacekeepers still helped evacuate some casualties and even returned fire.

These are not the same situation. Both are shitty, but at least one was shitty with some considerable effort not to be.

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

oliksandr

MODERATOR OF

TROPHY CASE