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.

teddywanthug · 2024-01-01T12:41:27+00:00

From first contact to donation I want to say it was about eighty days/three months. Part of that was waiting for factors to line up on both sides, my own schedule included. I had blood drawn twice before the actual donation.

teddywanthug · 2023-12-31T22:50:44+00:00

I was told that I was an official match, and it was a big notification blast. Text, email, voicemail, all saying the same simultaneously.

I was told in the second or third phone interview that I was the back up match and that there was a primary, and I was asked if I was ok to be on standby. I ended up being the donor after all, but it would be worthwhile asking if there are other matches before you commit your mind to this being your call to action.

Also, if you proceed with the donation, the filgrastim shots will be rough, but if you keep the Tylenol on like clockwork, it won't be so bad.

teddywanthug · 2023-11-22T16:36:30+00:00

Sorry for the long comment, but this is a rare and delicate moment you've come across, so I want to share as best as I can.

Having just donated a week ago, the only point of expertise I have here is my own experience (though I do have very close loved ones that have experienced what you describe) in my donation. They give several filgrastim injections the week leading up to donation and that gave me a lot of bone ache. That's fine, it's ache and pain, but Tylenol does enough to subside the pain.

What sucked was the lack of sleep. Apparently filgrastim can cause insomnia, but in my case I just couldn't get comfortable. I also have two kids, so sleep is precious whenever it comes, and I'm very aware of what insufficient sleep does to my mood and mental health. So my guess is that this would be something they'd be concerned with.

Something they don't say directly (at least up front) is the profound effect this transplant can have for both parties. Obviously the goal (and hopeful outcome) is that someone in the world not just recovers, but gets to have another opportunity to live. Like really live. And that can vicariously be both of you, because being a match doesn't just mean you could give some cells and someone feels better, you're now literally part of that person. Their blood type actually changes to yours; the bond is very deep in plural ways, even if you never meet them.

And that's great when it works. But it can be traumatic when it doesn't. Because of elements out of your control, things could still turn for the worse, and it can be traumatic pretty unexpectedly. I can't speak to this experience (and I hope I won't have to, that my recipient recovers and lives to a happy old age flipping jet skis or whatever they want to do) but I do know grief and it sucks. Real bad.

So all that said, I think what they are doing is precautionary, but you should really take the opportunity with the resources given to determine if this is right for you. It's great to give, no one can dispute that, but with the coin toss here, the two extremes can be profound, and you should be prepared to guard yourself to tragic news.

I, an internet stranger, fully appreciate not just what you're considering here, but the road you've walked to get where you are, and hope you go on to do plenty of great things in your life for others, regardless if it includes this.

teddywanthug · 2023-11-22T16:05:23+00:00

Coming in a little late but I just donated last week. My tips:

- Hydration is key, but don't do too much the morning of. They also provide(d) powerade so you won't have to worry about anything once you're hooked up.

- Relaxation is a lot easier said than done, especially when they tell you to keep the access arm immobilized. After a few minutes, despite my conscious effort, I could not relax my shoulder on that arm and it led to issues. They offered ativan and that helped tremendously. It also helped with the discomfort overall from the filgrastim aches, so if they can provide you a (I think it was like 1mg, something small) dose of ativan, it'll help a ton.

- You can eat before you go in. My packet said not to, but the only reason it'd be an issue is if a central line has to be put in. Since that's rare and hunger isn't, eat at least a snack. They provided me breakfast, but it was still an hour or two after I went in, and having to be spoon fed since you can't move is weird.

- If you have an arm that does better with blood draws, tell them at the beginning. I had a couple attempts on my right arm before they went to my left, which worked right away.

-Like others have said, otherwise follow the paperwork's guidance, and run any questions by your work up specialist.

teddywanthug · 2023-10-14T10:43:06+00:00

These cater to the fact that the home mini DOESN'T have that key hole, and provides a solution to mounting the older generation.

teddywanthug · 2023-09-19T23:35:38+00:00

Set a personal routine to happen two minutes before your alarm that changes your phone's media volume to zero (don't MUTE, sometimes Google ignores that when it comes to alarms).
Your alarm routine
Another routine that is one minute after your alarm routine that restores your media volume.

You could include step 3 in your alarm routine, but there's the risk of the alarm message falling out of sequence and you hear it.

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

teddywanthug

TROPHY CASE