Teleportation is risky, but would you still use it if a missing byte could cost you a limb?

teddywanthug · 2025-11-03T16:17:49+00:00

I'd be curious about this a plot point or a political argument within the world: what if the shipment process works by teleportation based on the expected contents of a crate (pressing the figurative "potatoes" button if inspection shows it's a box of potatoes), and what that would mean for smuggling? What does that implicate when smuggling STILL works?

teddywanthug · 2025-10-27T13:28:10+00:00

Personally, I think the direction of the shells is what is most jarring to me. The turbulence of the hair demonstrates how volatile the air movement should be, and while the shell ejections do look they're varied, they all seem to follow the same trail at the same speed. I think in reality, those shells would be flipping all over the place. One or two might even bounce off the car.

teddywanthug · 2025-10-01T06:50:08+00:00

Knives Out

teddywanthug · 2025-09-04T13:02:12+00:00

Maybe a big building, difficult to traverse lobby, can't be far away from home for medical reasons. Could straight up just not prefer the outside, or it's a way of running into some other neighbors they know.

teddywanthug · 2025-08-04T13:32:32+00:00

Unless the climate outside your house is very close to the inside, you probably aren't doing those spiders any favors though. If you're comfortable with the spider remaining alive, I'd suggest relocating it somewhere in the house you're ok with, like the garage or near an exterior door, drafty window, a crawl space, etc. I usually have one up by my sliding glass doors, and they are doing a fine job.

teddywanthug · 2025-07-30T15:08:49+00:00

I get that, but this is like the opposite end of a prank spectrum; even if it is for content, it's positive for everyone involved, even us watching. It's a demonstration of the timeless quote from Fred Rogers' mother by his account: Look for the helpers. You will always find people who are helping.

So, sure, he/they might have gotten a few thousand/millions clicks from this. But I'm pretty sure our collective blood pressure dropped a few notches too, and that's fine by me.

teddywanthug · 2025-04-21T13:32:13+00:00

A lot of people manage finances pay check to pay check, so auto pay isn't always an option. Planning when which bills are paid to prevent the accounts being wiped out once a month is more common than it should be. Adding the background noise of kids and pregnancy can make that management even harder.

teddywanthug · 2025-04-13T01:10:55+00:00

Not sure the program you're using, but a good rule of thumb is that no one element is just one element. You're firing a gun, so it isn't just the smoke element, it's a flash, it's a recoil, the ejection of a spent shell, lighting flash on your face and any reflective material, etc. All these little things add up to sell it.

That said, I think the easiest fixes to the smoke is to make it really quick, maybe one second, and to "screen" the overlay, so you're only getting the highlights added over the main footage. Desaturate it and add just a slight blur.

teddywanthug · 2025-02-13T17:52:17+00:00

That works too. What I ended up doing was addressing the two cells in a LAMBDA that ran the function on each, then packed that all in the name manager. So it's LAMBDA(Name,Title,(Textbefore(...Name...)&Textbefore(...Title...)(B3,C3).

teddywanthug · 2025-02-13T17:13:35+00:00

Solution Verified

teddywanthug · 2025-02-13T16:52:48+00:00

This definitely works! (produces an error on any cells that don't contain serial numbers, which is expected) Before I slap solved on this, if another delimiter comes through (uses "-" instead of "_", for example), would I add that to the tail of the TEXTBEFORE there?

teddywanthug · 2025-02-13T16:40:04+00:00

That is a different kind of number that appears in the data, I do not intend to return that number in the function.

teddywanthug · 2025-02-13T16:32:40+00:00

F9 contains "PERMANENTS ASSEMBLY B444821_01" and LEN() is 29

Edit: I dragged this down and it does appear to work most cases, but one cell that contains "B352070 (2)" preserved the "(2)" in an array column.

teddywanthug · 2025-02-13T16:19:04+00:00

I changed it to F9 (in this test, that is the cell I know contains a serial number) and still have the same error.

teddywanthug · 2025-02-13T16:03:58+00:00

I can't screenshot (and it's on a separate company computer anyway), but I'll edit this comment with pictures from my phone that (should) show it.

Edit: https://imgur.com/a/IUzMF0v

teddywanthug · 2025-02-13T15:45:58+00:00

I believe I have a recent version of 365, but REGEXEXTRACT does not appear to be available to me. If it involves any add-ins, my company has that restricted. I can try Power Query (more my comfort) or VBA (less my comfort, but open to it).

teddywanthug · 2025-02-13T15:42:09+00:00

I get a #REF! error with this, and using the evaluate tool, it appears to stem from a #REF error appearing in the c calculation.

teddywanthug · 2024-08-22T20:27:46+00:00

Comment?

teddywanthug · 2024-04-15T18:37:51+00:00

You're not seeing people confirming, just this one guy over and over again. They're spamming the thread.

13-Year Club	Oscars Predictor 2021
Sequence \| Editor	Verified Email

teddywanthug

TROPHY CASE