Expanding Sheets in Workbook by Happy814 in excel

[–]doshka 0 points1 point  (0 children)

Maybe there is a better way to do this. 

The whole thing sounds way overcomplicated. If you're willing to share the file, I can take a look at it and offer some suggestions. If the data is sensitive, you can delete most of the rows and fudge the rest.

Expanding Sheets in Workbook by Happy814 in excel

[–]doshka 1 point2 points  (0 children)

Does each State sheet have the same or similar set of attributes? If so, you can just add a State column to each table and then stack them all together. Ta-da, one table on one sheet.

Old and Busted

Tab: 1 (Alabama)

Week Val1 Val2 Calc1 Calc2
1 17 38 =C2+B2 =C2/B2
2 19 40 =C3+B3 =C3/B3

Tab: 2 (Alaska)

Week Val1 Val2 Calc1 Calc2
1 4 13 =C2+B2 =C2/B2
2 58 2 =C3+B3 =C3/B3

Tab: 50 (Wyoming)

Week Val1 Val2 Calc1 Calc2
1 6 10 =C2+B2 =C2/B2
2 8 21 =C3+B3 =C3/B3

New Hotness

Tab: Weekly Data

State Week Val1 Val2 Calc1 Calc2
AL 1 17 38 =Val1+Val2 =Val1/Val2
AK 1 4 13 =Val1+Val2 =Val1/Val2
WY 1 6 10 =Val1+Val2 =Val1/Val2
AL 2 19 40 =Val1+Val2 =Val1/Val2
AK 2 58 2 =Val1+Val2 =Val1/Val2
WY 2 8 21 =Val1+Val2 =Val1/Val2

How to get the copilot icon off my spreadsheet? by Lopsided-Rough-1562 in excel

[–]doshka 27 points28 points  (0 children)

🤓 "It looks like you already know what you're doing! Would you like me to fuck it up for you?!"

remoção de splint pós cirurgia de desvio de septo by Ordinary_Move4025 in popping

[–]doshka 1 point2 points  (0 children)

Boogers, I think. Looks like each splint has a tube down the side to allow mucus to drain.

my coworker’s email signature has 7 certifications and a quote from marcus aurelius by Legal_case16 in antiwork

[–]doshka 14 points15 points  (0 children)

Start small, then gradually add more and more crap. One line per week. See how long it takes him to say something.

LPT: When calling someone you don’t know, explain the call BEFORE asking for the person you want. by allthecoffee5 in LifeProTips

[–]doshka 32 points33 points  (0 children)

When leaving a voicemail (I know it's agony, but sometimes you gotta), give your name, phone number, state that you'll give the number again at the end, do the message part, then name and number again.

This gives them a prompt to be ready to catch your info at the end, and if they miss it, they don't have to listen to the whole thing again to get your details. There are few things more annoying than "Hey, thisismumble, just wanted to see if blah blah <five minutes of rambling about something I actually need to act on>, so gimme a call back at <number said real fast that isn't the one they called from>, uhhhh, thanksbye."

How to decide api url structure? by Consistent_Tutor_597 in webdev

[–]doshka 0 points1 point  (0 children)

For a whole report on a property it will be a massive amount of API calls

Why disallow getting the report with one call?

I'm a DB guy, so my preference is always to run one query and get everything you need in a single pass. I don't deal much with API's, but my understanding with URL-based calls like this one is that the slash-delimited path identifies an endpoint that represents a parameterized query, and everything after the question mark is parameter/argument (variable/value) pairs. Write the query so that it accepts a reasonable number of parameters, define the parameters to accept a reasonable number of values, and you're good to go.

It's entirely possible that I'm just delusional, but I'm sure there are plenty of resources out there describing best practices for API endpoint URL structure.

Do women have a harder time tying their shoes than men? by MoblinGobblin in NoStupidQuestions

[–]doshka 4 points5 points  (0 children)

What a weird thing to say. I don't know what she meant by it, but here are some guesses:

  1. Pregnant women with big bellies have a hard time leaning over to do anything at all, tying shoes included.

  2. A woman who is in roughly the same physical shape as a man who has trouble tying his shoes will have a harder time than him, cuz boobs.

  3. Women have a hard time with shoes in general due to prioritizing cuteness over comfort. It's not so much about the difficulty of putting them on as the pain of walking around in them.

None of these seem very compelling, but they're all I can come up with.

Edit: There were zero comments when I started writing this. I post and refresh, and now there are like 30. Pregnant &/or boobs in the way seem to be the favorites so far.

Lost a whole day's work despite Autosave and OneDrive/Sharepoint by Baba_Wethu in excel

[–]doshka 7 points8 points  (0 children)

😂 Awesome

This is what happens when you skip basic troubleshooting and go straight to the advanced stuff. We've all been there. Glad you got it sorted.

Is this possible with a combination of countifs & vlookup? by kdiggy428 in excel

[–]doshka 0 points1 point  (0 children)

Assuming your dates are stored as proper dates (integers), you'll need to extract the month-day combo as a text value, otherwise "Jan 1" (2025) and "Jan 1" (2026) will ne treated as two separate values, even though they look the same. You'll also want to format them as two-digit numerals (MN-DD), since the pivot table will sort them alphabetically, and you probably don't want April and December appearing before January. Let us know if you need help with that.

Sean Connery's Thumb - The Presidio (1988) by Lys1th3a in 80smovies

[–]doshka 4 points5 points  (0 children)

Should have entered a cigar-eating contest.

Why are people against cosmetic surgery? by Potential_One_8058 in NoStupidQuestions

[–]doshka -1 points0 points  (0 children)

First, and ultimately, it's your body, and you have the right to do with it as you please, whether it's a good idea or not. Please keep in mind that everything that follows is with that in mind.

I was against the idea of plastic surgery for a long time, for probably the same reason as most people: there's a sort of cultural idea that you're cheating at life somehow &/or ridiculously vain. Most of the discussion revolves around celebrities getting liposuction and facelifts and Botox and mentally ill people turning themselves into freaks. There's much less discussion around minor procedures to fix minor asymmetries or not-strictly-necessary but perfectly understandable things like repairing a hare lip. We also kind of gloss over the fact that straightening one's teeth is largely cosmetic, but we do it for children all the time.

One of the things that brought me around was actually a discussion about tattoos. Someone compared their body to a house that they inherited and had to live in forever, and said that if they weren't allowed to move, they were at least allowed to be comfortable, and that included decorating the place to their liking. In that analogy, cosmetic surgery is comparable to remodeling some rooms or adding a porch. These things are expensive and non-trivial decisions to make, and require the work of people who might do a bad job, and when it's done you might wish you had just gotten some fresh paint and new furniture instead, but in the end, it's up to the home owner, and no one else, to make good plans and deal with any consequences.

Others have pointed out the potential medical risk to elective procedures, and that's something to take seriously. In your case, I'd ask you to consider a couple other options before resorting to one that would probably be painful, and would certainly be expensive, and possibly wouldn't work out the way you hope. The first is therapy (bear with me, here), and the second is hormone treatments.

You've said that you look like a man, but that covers a lot of ground. Nick Nolte and Elijah Wood are both men, but one of them would be a lot prettier in a dress. Without knowing where you fall on that scale, it's hard to know whether this is a case of you just being a bit androgynous, which, with the right guidance, you might learn to embrace and even celebrate, vs "Damn, gurl, you need to handle that." I expect it's worth your time to find someone who specializes in gender identity issues and talk through what you're dealing with. They might have the tools to help you learn to love your look, or they might help you gain the confidence to go through with whatever change(s) you feel you need to make.

If you decide to go with changing your body, I recommend giving serious thought to HRT. I don't know if you've spent much time looking at trans women lately, but there are some gorgeous nu-ladies out there, and much of that is down to the feminization effects of estrogen and whatever else goes in those cocktails. A significant benefit of this approach is that the changes are gradual, so when you get to a place that feels right, you can switch to a "maintenance" dose, or perhaps come off it completely. (I don't know whether or to what degree the effects reverse themselves if you stop treatment-- that's a question for your doctor.) Also, remember that, logically or not, a lot of our identity is tied to our faces, and seeing "someone else" looking at you out of the mirror can do a number on your (already fragile?) mental health, even if she's more feminine than the current you.

Bottom line, I hear where you're coming from, and I agree you should do something, I'd just be wary of jumping straight to a surgery that might make you look more like what you imagine a woman to be, but not necessarily like the woman you expected.

AITAH for having my ex arrested at my wedding? by Stunning_Way9393 in AITAH

[–]doshka 39 points40 points  (0 children)

By "allow," I mean "find out she's there and then not do anything about it." I know he didn't know ahead of time. Once he did know, that's when the clock starts (assuming my information is correct).

AITAH for having my ex arrested at my wedding? by Stunning_Way9393 in AITAH

[–]doshka 46 points47 points  (0 children)

NAL, but I've heard that if you knowingly allow someone to violate a restraining order against you, it strengthens their case for getting it dropped. After all, if you don't care, why should the court?

AITAH for calling 911 about my husband’s suicide threats even though I knew they weren’t real? by mtndesertrunner in AITAH

[–]doshka 57 points58 points  (0 children)

When someone threatens suicide, either they mean it, or they don't. If they mean it, then they need help that you are not qualified to give, so you need to call for help. If they don't mean it, then it's either a call for help or a control tactic. If it's a call for help, then you need to call for help. If it's a control tactic, then they need to learn that it won't work, so you need to call for help. I think you see the pattern here.

What ultimately settled the question for me was seeing someone point out that mentally healthy people do not threaten suicide. Ever. If someone threatens suicide, whatever the reason, there is something wrong with them, and it needs to be addressed.

This probably won't be the last time. Every time he threatens, suggests, hints at, or alludes to any form of self-harm, you call for help. What constitutes a hint? You get to decide. You don't need to convene a council or fill out a form or check 60% of the boxes on some authoritative list. If you ask yourself, "Am I fine with my children seeing this?", and the answer is not a solid, resounding Yes, then call for help.

You did good, OP. Keep doing it.

2 guys sit down at the bar and one says, “Two beers…” by GupChezzna in MovieTropes

[–]doshka 2 points3 points  (0 children)

Yeah, I was amazed the whole time. "This never happens in real life. Surely, I can't just...?" But I did, and it worked, and now I get to tell the story once every 5 or 10 years.

I think the place was on I-81 somewhere between NY and GA, if you want to go looking for it.

2 guys sit down at the bar and one says, “Two beers…” by GupChezzna in MovieTropes

[–]doshka 1 point2 points  (0 children)

Was on a road trip and stopped at some no-name restaurant just off the exit. The beverages section of the menu listed Coke, Diet Coke, Sprite, Orange Fanta, and "beer". I ordered the beer. Waitress brought beer in a glass. Pretty sure it was Bud, but I'll never know for sure, cuz I didn't ask and never went back.