u/Musty-Old-Couch

Sorry if this is a dumb question, but my work provides me with a laptop to use to work remotely - however we can also remote in via Citrix. I work remotely 3 days a week and basically always use my personal PC unless I'm travelling while working which is rare (maybe 5ish days a year?).

I only use my personal PC for 10ish hours a week for gaming, so about 80%+ of it's use is for work, which means I can claim 80% of it's depreciated value for the year as a work expense under normal circumstances, right? However, since I'm provided a laptop and don't NEED a PC, just prefer to use it, does that mean I can't claim it?

Let's say Mr Fantastic makes The Flash a helmet with a small rod on it that can withstand FTL travel. The rod sticks out backwards a bit so when the flesh is running it's situated away and behind his body a bit. There is a clamp on the rod that the Ring is placed into.

While standing still, it's still close enough to The Flash that he will be influenced by it (or else anyone could avoid it's corruption just by putting it in a box and not touching it).

However the Flash starts running FTL towards Mount Doom. The ring would attempt to influence The Flash, however he would constantly be moving away from the influence at FTL speeds, meaning it would never reach him.

It would be like attaching a mobile phone to this rod with an alarm playing on it. As long as you ran faster than sound can propogate ever hear the alarm. Can The Flash outrun the rings ability to influence?

Hi r/excel - I'm wondering if it's possible to perform a countif on a column, but:

* Use a delimiter to separate values within the same cell, as if they were in their own cell

* Does not use helper columns, VBA, power query, etc, just a single formula.

A more concrete example is, say we have this column:

Cat
Dog
Frog/Toad/Tadpole/Cat
Pear/Apple/Peach
Potato/Icecream/Pear/Apple
Creamers/Creamery/Milk/Pear/Apple
Pie/Cream/Cake

Then in another column we had a bunch of words and wanted to see if they exist in the above column. A partial string countif/xlookup would not work (ie using "*") because cream would then be erroneously be counted in the third last column (Icecream), or if case sensitive, the second last column (Creamers or Creamery) and not the last column where Cream exists.

Basically, I just want to find the full complete string of the word as a normal xlookup would, be treat a single cell with and "/" in it as if they were separate cells.

The second column would just be a list of words. All of these words from the above column would exist in it, plus some that don't. The expected results of a count if would be:

Frog, Toad, Tadpole, Dog, Peach, Potato, Icecream, Creamers, Creamery, Pie, Cream, Cake, Milk = 1

Cat = 2

Pear, Apple = 3

Any other word = 0 times obviously

Would also accept a formula that simple checks if they exist and doesn't count them.

I know there are better ways to have done this like not combining values in a cell in the first place, but my boss insists it be done this way as it's set up how he likes. VBA, Powerquery, pivot tables, officescripts, etc are too esoteric for him, he just wants a formula that checks if the value exists and ideally counts instances.

I've heard Brock, the 16 year old that got trapped before John Jones, got stuck in the same part as John. But the part John got stuck in is often referred to as the furthest anyone has ever been, which wouldn't be true if Brock got trapped in there.

Where did Brock get stuck?

I loved GW1 and 2, but it was always a suboptimal experience due to high ping. But given the nature of the gameplay, it was still playable. If Guild Wars 3 is going to be more action heavy, please can we get some Australian based servers.

I know I'm yelling into the void a bit and Arenanet is unlikely to see this, but maybe if enough sentiment is shared on line it might encourage them to finally provide proper service to Australia

My question could be more generalised to be 'can a jury find someone not guilty on the basis that they simply like the idea of committing the crime, no matter how extreme?'

But let's use Luigi as an example. Let's say the jury find him non guilty. Then let's say, right after that verdict, they (completely unprompted) volunteer the information that they reached the verdict because "it's great seeing CEOs murdered and we'd love to see more of it, we don't think it should be illegal".

Does Luigi walk free? Or is this considered a basis for a mistrial?

Ie would towns specifically seek out people who had already had survived the plague and therefore have a heightened immune response to future infections to fill roles that would be in close contact plague sufferers or those yet to be infected?

Would these people command higher salaries too? Ie could a doctor, priest or even just an undertaker who has survived the plague negotiate better pay as they would be less likely to die and also spread infection themselves, making them more sought after?

Both concepts seem to be based on the premise of not engaging with the case on the terms of the court or in good faith, but jury nullification is fine but using a coin is prohibited. Shouldn't either both be allowed or neither?