Posts by Nicholas King

nimblenomad said:I’ve always been pretty terrible when it comes to managing my time—not that I was looking for a specific topic here—but I’ve been scouring all sorts of online tutorials and forums regarding how to write formulas in Word... essentially, I’m working on my senior thesis and I know how to denote a vector like "a" with that little arrow sitting right above it... however, how on earth do you write a vector "ab" where the arrow actually spans the middle, positioned perfectly between the a and the b? I really hope you guys get what I'm asking, because I feel like I'm going to lose my mind if I can't figure this out... THANKS SO MUCH!

In the Equation editor, you should find vector notations in two different toolbars. One (where the derivatives are located) has the notation for a single-letter vector, while the other one (usually the bottom row, to the right of the integrals—at least that's how it looks on my screen) features the notation for a vector like AB.

Carol Peterson25 said:I’m looking for some help with Excel—if anyone knows how to handle this, I would really appreciate it.

In my American Windows settings, the decimal separator is a period. 🙂

But whenever I type a period, Excel decides to be difficult and converts it into a "date cell."

Ethan Palmer69 said:How can I get text to sit above the top page borders—basically, I want the book title on the left-hand pages and the chapter title on the right?
Should I just use a text box?

You really need to brush up on some terminology here—specifically headers and the "different odd and even pages" setting.

And, honestly, you’re probably going to have to wrestle with sections too, which—if I’m being perfectly honest—isn't exactly the most intuitive feature in Microsoft Office. 🙂

Keith Robinson78 said:Honestly, I don't know why I, as a graphic designer, don't run into more of those "geniuses" who think they know everything about...

I suppose it might be because a truly solid presentation isn't just about the visual design—it’s actually much more than that. You have to consider the substance, the tone, the "balance," the literacy... 🙂

rustydrifter10 said:What would you even say to a six-year-old if they asked, "Hey, what's PMS?" 🙂

Do you really have anything better to offer than, "It's just a period of time where certain changes happen in your body that can affect your mood or cause some aches, but you can help manage it by eating healthy and staying active"—which is pretty much the gist of what I told her? It was quite a while ago, so I can't remember my exact wording word-for-word. 😁

So, I was sitting there watching a rerun of Judge Judy last night—you know, one of those endless loops they play on cable—and I witnessed something that actually left me a bit stunned. There’s this little girl in the episode, maybe around six years old, and she just looks up at her mom and asks, "What's an orgasm?" I mean, honestly... you're just sitting there with your coffee, and suddenly you're hit with a question that most adults aren't even prepared to answer properly. It’s one of those moments where you realize how much the world has changed, or perhaps how little we prepare people for the sheer randomness of life. I guess it makes you wonder about the state of parenting these days, though maybe I'm just being overly cynical. Still, it was quite a jarring moment to witness during such a mundane evening.

Amy Schumer responds: "I seem to have forgotten—I'll probably need to double-check the manual." 🤣

Drew Hernandez said:I almost feel embarrassed even posting in a women's sub-forum (John Doe), but I’m genuinely curious. I know if I posted this on the men's side, I'd just get mocked or have my orientation questioned. So, do you actually talk to your adolescents about sex? How do you approach it, and when does it start? I was just reading some advice on a website suggesting you should start early—like, eight years old??? It said things like, "Boys have a penis and testicles, and as their voices deepen, they grow body hair. Girls have vulvas and uteri, and as they grow, their breasts and hips develop." What a load of nonsense. Eight years old? Seriously?
So, how much do you or your better halves (ha!) actually discuss this with your adolescents? My kids tried to bring it up once, but I was already more informed than they were by then [honestly, I don't even know where or how I learned it]. I don't know why they even bothered. Since I already knew the deal, the whole conversation just boiled down to my dad's classic line: "Son, just don't do anything stupid," and that was that.
How do you handle it with your sons versus your daughters? Do you initiate the conversation, or do they come to you? And at what age? Just curious...

Well, it starts right when they begin asking questions—and honestly, some of those questions might surface even earlier than the ages you're currently wondering about.

A child needs those answers, and you can—quite simply, really—provide them exactly as requested. There isn't some grand, complex strategy required here. For instance, I suppose an eight-year-old could be given a perfectly straightforward explanation of PMS or whatever else happens to pique their curiosity.

If a parent starts acting awkward or tries to dodge the topic, the kid learns two things: a) that sex is something shameful, and b) that if they want the "real" scoop, they should go talk to that one kid in middle school who "knows" everything—you know, the one who claims 🙄 you can't get pregnant from your first time, that STIs are just urban legends, and that women are only fertile on the fourteenth day of their cycle, specifically between 10:45 AM and noon.

By failing to maintain that open line of communication regarding sexuality, a parent is essentially digging a massive, unnecessary trench between themselves and their child. And yes, I believe that includes having honest discussions about contraception as well.

jaderider11 said:Basically, I need a spreadsheet that takes all the data where the code ends in 1 and puts it into one table, then everything ending in 2 goes into another, and so on up to 10.

Well, it really depends on whether that project code is stored as an actual number or just a text string—if it's a number, you could pull that last digit using =MOD(A1,10), though if it's text, =RIGHT(A1,1) might be the way to go.

The rest of the solution—well, that’s a bit more complicated—depends entirely on how your data is structured (how many columns we're talking about, etc.) and what you actually mean by "saving them into different tables"—do you want them moved to different spots on the same sheet, or are we talking about moving them to entirely separate tabs within the workbook?

I suppose it's relatively simple to set up a "semi-automatic" workaround: you just add a helper column to extract that final digit and then use that as your criteria for an AutoFilter. If you're looking for a fully automated solution, though, you'd probably need to write some actual code or a macro.

wiredcobra46 said:how do I make that spacing—you know, actually get COLUMNS? I get how to do rows—just hit enter... THANKS SO MUCH FOR THE HELP!!! YOU'RE SAVING MY LIFE! 🙂

Well, you clearly don't even get how to do rows, because that isn't done by hitting Enter. 🙂

If you're trying to build matrices, there's a specific template within the Equation editor—in the 2003 version, the most useful one is in the bottom row. Just pick the "general matrix" option, specify the number of rows and columns you need, and you're all set.

slyfalcon542 said:I'm running into an issue here. My final senior thesis needs to be bordered—specifically, I need a 5 mm margin from the right, bottom, and top edges, but a 25 mm margin on the left side.

Honestly, just draw a rectangle with those specific dimensions—kind of like how you'd set up a header —and set the wrapping to "behind text." Then, just align it properly for the binding so you don't run into any trouble with the state standardized testing requirements. 🙂

ambermason16 said:Let me jump the gun here just to save some precious server space: I’m offering my objective perspective as a colleague to the self-proclaimed moderators and as a regular Redditor weighing in on the OP... do you... need a bus ride? 🤷

WTF, "colleague to the self-proclaimed moderators"?! What kind of bizarre job title is that? Are the moderators on United Airlines following some "one for all, all for one" squad mentality or something? 😕

Before replying, I actually checked—you aren't a moderator over at Estée Lauder. So, if we ignore this whole idea of some "universal brotherhood of moderators" 🙄, my presence here and yours start from the exact same baseline. Posts, complaints, comments. That's it.

It would be incredibly easy for you to save yourself the dramatic exclamation points by simply ignoring this. But me? I guess I can't even manage that. 🙂

Whether I’m reading this with logic or without it, I still don't grasp how someone's "paper-thin history" somehow causes an 80% loss in value quoting the sentence "Both perfumes are fake!"

ambermason16 said:I saw piles of cardboard from all over the place. For me, that automatically makes everything you're claiming lose at least 80% of its credibility. Though, maybe it actually is true.

Confused.

The sentence in the quoted post literally says, "Both perfumes are FAKE!!! ". Even if we strip away 80% of her credibility, we are still left with—well—the sentence "Both perfumes are FAKE!!! ". Which is, you know, just a tiny bit illegal.

It’s a quoted sentence—it isn't a paraphrase, nor is it about personal impressions where some random internet user's opinion or work should be treated as grounds for judgment. It's like... you report a crime, and then the cop starts digging through your neighbor's apple tree from twenty years ago. "A-ha!!! You stole apples!!! You've got nothing to report to me, come on, move along in small groups!!!"

BTW, how can a quoted sentence be perhaps true? 😕

...or could you ask the question in a slightly less aggressive way? 🤷

Which part of the question was "aggressive"? 😕

"If that's the case (and it is, since we know from experience that selling imitations is banned at street stalls), why is selling fakes allowed on the Estée Lauder sub-forum, provided you just state they are fake?"

Sarah Brown86 said:it really ought to be a macro using a filter
but I honestly have no clue which specific code to use... I'm totally stuck here :P

Just go ahead and send over whatever code you've managed to write so far—that way we can actually see where things went sideways.

Benjamin Wilson7 said:For the first round, she managed to nest an IF statement—using AND to help out—and actually solved the problem. Now we’ll just have to see if she truly understands the concept of nesting functions.

I suspect that when they say "write a program," they really do mean using VBA. 🙂

Morgan Bishop4 said:I marked this one using force

Once you actually get into the Chart Wizard—and in that second step, you'll see a "Series" tab—there is a specific box for your "Category /X/ axis labels." Just click inside that box, highlight the range where your X-axis labels are located, and that should be that.

Assuming, of course, that I’ve correctly interpreted such a sparse explanation. 🙂

Sarah Brown86 said:???

Just send over whatever solution you've managed to scrape together—then we can actually take a look and see if there's anything worth salvaging.

The screenshot is honestly a bit baffling—you’ve got entries for 200 and 300, yet the total sales tax is sitting at 20. 😕

I'm struggling to pin down where the actual issue lies here: if cells E12, F12, and G12 are where you're inputting the price inclusive of tax, then presumably H12 should be calculated as 0.22*(E12 + F12 + G12)/1.22, while I2 would be E12 + F12 + G12 - H12.

Of course, if you're dealing with a different state sales tax rate, then obviously those 0.22 and 1.22 figures won't apply.

Anthony Barrett37 said:Can someone please walk me through how to set this up in Word?

The screenshot you shared looks like an "automatic Table of Contents." To get that working, you basically need to make sure your chapter titles are formatted using styles like Heading 1, Heading 2, and so on—you know, the standard stuff. Once that's done, you just head over to
Insert -> References -> Table of Contents
. You might have to tweak a few settings here and there, but that's pretty much it.
The big plus with doing it this way—and I really think it's the only way to go if you value your sanity—is that the table updates itself automatically whenever your page numbers shift.
There is a "manual" way to do it, I suppose, where you'd set up a right-aligned tab with a dotted "leader" line. You’ll get the alignment you want, sure, but you're going to be stuck typing everything out by hand, which... well, it's a massive headache. 🙂

Gregory Rogers20 said:the issue is also that these numbers are decimals (like 20.5).

Look, what you're doing here is bordering on outright disrespect.

You showed up with one description of your problem—which was actually solved in several different ways—and then, in every single follow-up post, you tack on some new "the issue is also..." which essentially sabotages every solution we've offered (mine included, though how was I supposed to know those numbers could be decimals or wouldn't just increase by increments of 1?).

Do you honestly believe people have nothing better to do than constantly—and for free—re-solve new variables in your problem? It’s a bit like walking up to a crew of contractors while they're pouring a foundation for a single-story house and saying, "Oh, the issue is also that I actually need three bedrooms instead of two." I mean, the contractors will fix it for you—but they’ll certainly send you a massive bill for the extra work. 😁

Is it really that difficult to just sit down and describe the entire situation from start to finish right at the beginning?

You're being unprofessional, and frankly, you're wasting people's time and goodwill. Goodbye.

Ethan Palmer69 said:Is there any way to delete a page number from specific pages in Microsoft Office Word without it automatically nuking the numbers on every single page?

Honestly, just set the image layout to "in front of text"—then you can stretch it out however you want—and basically just hide the number behind it.

It’s probably the easiest workaround available.

shadowhawk32 said:I ended up helping out a neighbor who was facing the exact same deadline—it’s true, I was basically glued to my desk from 8 AM until 5 PM, but I still managed to grab $167 😁

😱

So, what exactly were you doing for nine hours "at the computer"—manually carving out every single bit on the hard drive by hand?