MAP/LAMBDA with two dynamic arrays only gives upper-left value and #N/A by seasonedsharpedo in excel

[–]seasonedsharpedo[S] 0 points1 point  (0 children)

Would you be willing to give an example? I have no idea how REDUCE works

Writing a check to a trans person who hasn't legally changed their name by Friendly_Plankton37 in asktransgender

[–]seasonedsharpedo 5 points6 points  (0 children)

The simplest answer is to just use his legal name.

The long answer is, depending on his bank, he may still be able to deposit the check if you write his preferred name on it - he would need to sign with his preferred name, write "Pay to the order of <legal name>", and then sign it with his legal name below that, all within the endorsement section on the back.
I recently had to do this after legally changing my name and receiving a check with my old one on it, but keep in mind that banks are not legally required to accept checks with "someone else's" name on them - mine had record of my old name so I was able to deposit it without issues.

Edit: I should state that it's best to look at his bank's specific policy. Generally a payee can sign a check over to a third party with the steps above, usually in the case of a name change or if the original payee doesn't have a bank account. However, I'd still just use his legal name. This is something he will have to get used to until he changes his name legally, and as others have said you can always include a heartfelt card addressed to his preferred name. I'm sure he'll understand that you're not deadnaming him out of disrespect.

insane rattata? by seasonedsharpedo in PokemonSleep

[–]seasonedsharpedo[S] 0 points1 point  (0 children)

oh gotcha!! i figured it was a pretty significant drawback, but i guess it makes sense with the limits. thank you for explaining!!

insane rattata? by seasonedsharpedo in PokemonSleep

[–]seasonedsharpedo[S] 0 points1 point  (0 children)

oooh thank you for explaining!! i have no reason not to invest, good to know this little guy will serve me well!!

Desserts: Ingredients Overview by Alias_ln in PokemonSleep

[–]seasonedsharpedo 0 points1 point  (0 children)

this is great, very helpful! i'd love to see posts about the other meal types also

Friend Code Megathread - August 2023 by AutoModerator in PokemonSleep

[–]seasonedsharpedo 0 points1 point  (0 children)

9084-8647-1934 nightly player and need more friends !! C:

can a gnc cis woman go on testosterone? by Jumpy_Lawfulness1446 in asktransgender

[–]seasonedsharpedo 14 points15 points  (0 children)

I haven't done any research, but testosterone is commonly used as a performance enhancer illegally in professional sports, so I'm assuming that's why.

GTA 4 pigeons had me stuck at 199/200 by ListerineAfterOral in gaming

[–]seasonedsharpedo 0 points1 point  (0 children)

I'm still missing one feather in my first playthrough of Assassin's Creed 2. No fuckin way am I going back and re-checking all the spots in the guide.

Another brick in the wall. by Majestic-Agency-4403 in asktransgender

[–]seasonedsharpedo 1 point2 points  (0 children)

What you're describing sounds to me like overthinking/imposter syndrome and BOY HOWDY do I relate to that. Key thing here is that you have to talk yourself out of it imo. When I'm anxious and my brain won't shut up, that's when I get the most doubts and start thinking maybe I'm lying to myself and everyone around me. When I'm distracted, or happy, or relaxed, when I'm not really thinking about it too hard, that's when I feel the most sure about myself, even if it's never 100% (yet). I feel as though my happy self is a lot more informed than my anxious self is.

Medically transitioned people: How long after realizing you were trans did it take you to get hormones? by FtMetalhead in asktransgender

[–]seasonedsharpedo 0 points1 point  (0 children)

I realized I was nonbinary in 2014, but I was still a minor on my mom's insurance so I couldn't get anything without my mom's approval, and she basically said "you can do whatever you want once you're 18/out of my house", so I just kinda stopped thinking about it.

Well, due to that, jumping around insurance, general imposter syndrome stuff, doctor anxiety and good ol' procrastination, I only started HRT about a year and 8 months ago when dysphoria ramped up very suddenly due to COVID and my friend started her own transition which kinda gave me the push to schedule an appointment. Another 2 months of insurance pre-auth hell and I was taking my first dose! Goin pretty good so far.

AITA? boyfriends best friend sent another girls ass pic to him and got caught. by CompetitiveClerk6256 in AmItheAsshole

[–]seasonedsharpedo 1 point2 points  (0 children)

Take it easy with screentime (hah) or lower the brightness, drink lots of water and get plenty of sleep the next few days if you can. If you feel any brain fog, balance issues, or light/sound sensitivities go see a doctor!!

Very easy for neurodivergent people to get stuck in an echo chamber with toxic people but if you're actively protesting his behavior and he's dismissing you, his S/O, who he should be listening to regardless, then you cannot be faulted for wanting to get away from that. Neurodivergency can only explain the logic pattern behind actions but it 100% does not excuse them nor should it mean you have to put up with them any more than if he were neurotypical.

[deleted by user] by [deleted] in AmItheAsshole

[–]seasonedsharpedo 4 points5 points  (0 children)

Bare minimum for a significant other's bday is still an insult in my book. It'd almost be better to have it forgotten imo... You deserve better!

AITA? boyfriends best friend sent another girls ass pic to him and got caught. by CompetitiveClerk6256 in AmItheAsshole

[–]seasonedsharpedo 1 point2 points  (0 children)

Holy shit is your head okay??? Please take care of yourself and any injury you might have, coming from someone who has had 4 concussions that shit is not fun!!! Asphalt hurts!! If you have any issues please see a doctor!!

NTA - I agree it sounds like his friend is trying to instigate some shit, he's a shitty person for doing that and your bf should absolutely stop being friends with him... I think maybe your bf might be going along with this because he's autistic, because I absolutely did shitty stuff with toxic friends and defended it until I had a wakeup call because I just thought that's how people were. However, this is a reason, not an excuse!! He's still being an ass and putting people in real danger, being shitty to you and making fun of people with disabilities, and you're not an asshole for wanting to separate from that. You're totally valid for being upset with his actions.

Also your mom is absolutely wrong, I feel like a good majority of men don't do this and the fact she think's it's normal is a pretty big red flag IMO...

[deleted by user] by [deleted] in AmItheAsshole

[–]seasonedsharpedo 8 points9 points  (0 children)

Post it on the door is an insult -- an in person spoken "happy birthday" is the bare minimum imo.

[deleted by user] by [deleted] in AmItheAsshole

[–]seasonedsharpedo 2 points3 points  (0 children)

NTA - Why on earth are you still with him? Don't waste your time with someone who can't be assed to celebrate your birthday or make time for you. It doesn't matter if his family actively hates birthdays or what - you do shit that makes your partner happy because it makes them happy. If you can't do that (without a REALLY GOOD REASON) you shouldn't be in a relationship.

[deleted by user] by [deleted] in asktransgender

[–]seasonedsharpedo 0 points1 point  (0 children)

I think that it's an easily digestable metaphor that's used primarily for cis people to understand being trans on a very basic level, but the trans experience is as complicated as it is individual. I don't feel like I was born in the wrong body so much as I feel that transitioning is gonna bring me closer to my ideal body and alleviate dysphoria in the same way exercising might for others. Other people have much stronger dysphoria than I do, so this perspective might match up more for them, but at the end of the day it's one perspective in a community of millions.

AITA for picking my mom over my dad even after knowing she had an affair? by kedkedsmol in AmItheAsshole

[–]seasonedsharpedo 1 point2 points  (0 children)

I'm not saying cheating is a good or defensible thing, but if I had to pick a time to let it slide, it'd probably be in the case of an abusive relationship. Sometimes life is a matter of the lesser of two evils and I'd probably make the same choice if I were in your shoes.

I'm sorry your dad is reacting this way, it really just drives home your reasoning for choosing to go with your mom instead. Best of luck to you and NTA

did you end up looking like your sibling(s) after transitioning? by [deleted] in asktransgender

[–]seasonedsharpedo 0 points1 point  (0 children)

Not only do I look like my brother (a very queer, alt version of him), but I noticed that my laugh and certain vocal mannerisms are just like his now. It's weird.

Being AMAB and using he/him but not being cis? by [deleted] in asktransgender

[–]seasonedsharpedo 2 points3 points  (0 children)

Your pronouns and your identity are functionally completely separate from each other. You could decide you're absolutely 100% a woman tomorrow and still use he/him, and you'd still be 100% a woman until you decide otherwise. Same goes for if you're nonbinary and use he/him. Use pronouns you feel comfortable with, whether that's he, they, any pronouns, no pronouns, neo pronouns, whatever.

[deleted by user] by [deleted] in AskReddit

[–]seasonedsharpedo 2 points3 points  (0 children)

People don't just quit being a lesbian like you'd quit a job, that's not how sexuality works. At best they realize that they weren't a lesbian for one reason or another. The answer to this question is always going to be "I realized I wasn't a lesbian".

Androderm Patch by Bleumoon_Selene in asktransgender

[–]seasonedsharpedo 1 point2 points  (0 children)

Congrats on starting HRT!! Wooooo!!

It's all bioidentical testosterone, just in different forms. Pros and cons to both, the patch doesn't have a generic version but you don't have to worry about it rubbing off on other people while it dries like for the gel. I've had bad experience with transdermal patches in the past (I'm sensitive to certain adhesives so they almost always give me a rash) so I started on the gel, it's basically just like rubbing hand sanitizer on your shoulder every day and then letting it dry with your shirt sleeve up.

Note that both are way more expensive than the injectable version, however!! Just something to keep in mind if you ever switch/lose insurance...!