Posts by Jack Hayes

Looks like the Nuggets aren't letting Spencer Jones walk that easily. They stepped up to match the Thunder's offer, so he's staying in Denver for the next two years. Do you guys think this is a smart move for their long-term depth?

Kyle Cook82 said:At work, we use Microsoft Outlook for all our official communication. I was wondering, is there any way to check if my boss is reading the emails I send or the ones arriving at my work address without me knowing? Basically, does he have access to my inbox?

I think it’s called a "shared mailbox," or something like that...?

I’ve been doing this for ages, but I really recommend keeping a dedicated email address just for your private stuff—something like a personal Gmail account. It isn’t even about being paranoid; it’s honestly just cleaner and way more organized. If you try to use your work email for everything, you end up constantly filtering through junk just to find your personal messages. Having a separate inbox makes life so much easier. ☕

Here's some C# code—it starts at 10,000, and for every number after that, it adds up the digits. It sorts them into three groups: exactly 10, more than 10, or less than 10. The loop stops once we've found 10 numbers for each category or if we hit 1,000 iterations 🙂. Finally, it prints out three lines containing those numbers
. // digit sum
private static void DigitSumTask()
{
int loopCounter = 0;
bool shouldExit = false;
int sum = 0;
int startingNumber = 10000;
int indexIs10 = 0;
int indexGreater10 = 0;
int indexLess10 = 0;
int[] sumEquals10 = new int[10];
int[] sumGreaterThan10 = new int[10];
int[] sumLessThan10 = new int[10];

// loop
while (!shouldExit) {
startingNumber++;
// sum digits
string numberStr = startingNumber.ToString();
sum = 0;
for (int i=0; i < numberStr.Length; i++) {
sum += int.Parse(numberStr.Substring(i, 1));
}
// sum is 10
if (sum == 10) {
if (indexIs10 < 10) {
sumEquals10[indexIs10] = startingNumber;
indexIs10++;
}
}
// sum greater than 10
if (sum > 10) {
if (indexGreater10 < 10) {
sumGreaterThan10[indexGreater10] = startingNumber;
indexGreater10++;
}
}
// sum less than 10
if (sum < 10) {
if (indexLess10 < 10) {
sumLessThan10[indexLess10] = startingNumber;
indexLess10++;
}
}
loopCounter++;
// exit if all found or 1000 iterations passed
if ((indexIs10 == 10 && indexGreater10 == 10 && indexLess10 == 10) || loopCounter >= 1000)
{
shouldExit = true;
}
}

// print results
string line1 = "";
string line2 = "";
string line3 = "";
for (int j=0; j < 10; j++) {
line1 += sumEquals10[j] + ", ";
line2 += sumGreaterThan10[j] + ", ";
line3 += sumLessThan10[j] + ", ";
}
Console.Character Limit = 140;
Console.WriteLine("Sum equals 10 for: " + line1);
Console.WriteLine("Sum is greater than 10 for: " + line2);
Console.WriteLine("Sum is less than 10 for: " + line3);
Console.Enter();
}
The main thing you need to focus on is summing those digits, then saving the number and counting until you hit 10☕.

Sam Peterson6 said:So, I put together this sheet in Microsoft Excel and went to hit print.
It spits out all the text just fine, but the actual table? Totally missing. It's just raw text floating there.
Any idea how I can get it to actually print the table too?

Are you sure you actually turned the table on, or are you just looking at the standard Excel gridlines? Those default lines don't always show up on paper. You need to select all your data first, then go ahead and hit either the All Borders icon or use Format as Table.☕

@Karen Ortiz83, you’ve gotta trust your own gut more than you trust any piece of tech. Just hit save, back it up somewhere secure, and then you can actually get some sleep... 🙂

Unfortunately, there isn't much I can do to help fix this one. Just a heads-up for next time: try to stick strictly to the rules. It’s always a good idea to save your work frequently, and honestly, I’ve learned the hard way to copy the document somewhere else before making any major changes just in case things go sideways. It’s definitely better to hit save before you even start printing. At the end of the day, try backing everything up to an external drive, a thumb drive, or even just using the cloud. For example, if you upload it to Google Drive, you can access it from anywhere—whether you're at a FedEx Office, a local library, or on the go. ☕

vividmoose33 said:Hey everyone! My Shift + V shortcut isn't working. The little monkey icon disappeared too. I've already tried two different keyboards. Any ideas? Help me out here...

Quick check—take a look at your taskbar and see what language you're set to. Is it set to US or EN?! ☕

darkowl72 said:If this is actually critical, here’s my standard advice: don't try to fix it yourself. You'll just end up making things worse (even just poking around can mess up data integrity), so take it to a pro. You can just pull the drive out of your PC and ship it via FedEx marked as fragile—it isn't that expensive. Being without your computer for a few days is a small price to pay if those Pictures actually matter to you...

http://www.infolab.com/pricing/

Otherwise, those "smart" Libraries are basically designed for users who have zero clue where they're saving stuff; they just scan every folder they find for Pictures, Video, or whatever else. I've always hated them for that exact reason—it's way too easy to lose track of where you actually are. I'll stick to my own organization method...

I'm totally with you on that; I also can't stand it when programs try to make decisions for me. 👍

Alexander Mitchell4 said:Honestly, it's one of those "300 miracles" kind of days... I'm trying to log in this evening, but a third of the window isn't even visible. It offers the Facebook and Google login options, but that bottom section where you actually type in your username and password? Totally cut off. On top of that, I keep getting these pop-ups asking me to enable Adobe Flash, and once I finally click allow, the whole little window just turns white. I can't see a thing—no Flash animations, no videos on Facebook, nothing on the forums either.
I really should brush up on my tech skills, but I don't remember things being this glitchy before.

It sounds like you need a deep clean—think Arial + Vanish. Honestly, it might be best to let someone who really knows their stuff take a look at it.

Is this actually a hidden camera...?! 🍿

I've got this old Notebook Dell Inspiron from back in 2007 running Windows XP Service Pack 3. Honestly, Firefox works like a charm on it. My daughter spends time watching videos on YouTube and she hasn't complained once—everything just works. And why wouldn't it? Firefox is kept up to date. So, I don't think it's necessarily about the hardware or the OS being outdated. ☕
Just format the drive, install Windows XP Service Pack 3 along with some security software (like Norton + Malwarebytes), and then get Firefox installed... If that doesn't do the trick... 🙂

Kyle Johnson2 said:You could totally leverage some Microsoft Office functions like IF, AND, VLOOKUP, WEEKDAY to build out a formula in cell B2, then just drag it down and across...

Yeah, I definitely agree. It’s much smarter to maintain a dedicated "database" for your companies and employees—maybe even keep it on its own separate sheet. You'll really start seeing the payoff the very first time you need to update an employee's info...
👍

Rebecca Cooper92 said:I need some help here. When I use justified alignment in Word, I keep getting these huge double spaces between my words. Any idea how to fix this?

So, here's the deal with justified alignment: it basically stretches the line from the left margin all the way to the right by forcing extra space between words. If you have a short line with a lot of room left over before the right margin, the software just shoves those extra gaps in there to make it fit, which can definitely look pretty messy. If you aren't a fan of that look, just highlight that specific paragraph—don't worry about the whole document—and switch it back to left alignment.

Jack Hayes said:Just pop this formula into cell A2 (assuming your first date starts in A1)...

Quick correction: I meant cell B2 if the first date is in A2... My bad, just a typo! 🤷

Grace White66 said:Hey there! I've been banging my head against the wall for two days now, scouring Help files and Google...
I want to build an Excel sheet where the first column lists every single day of 2015 in this format: "Thu 1/1/2015". I know how to handle those 365 entries.
Then, I have rows representing clients (about 50 of them). In the grid, I need specific employee names to automatically pop up based on a schedule—something like "Client Mate Trade works on Thursday with Pero Peric." Basically, I want Pero Peric's name to show up for every Thursday of the year.

How on earth do I pull this off?!
I’d rate my Excel skills at about a 6/10, but clearly, that isn't cutting it here. Could anyone just give me a little hint?

If you put the first date in cell A1, try adding this formula to cell A2:
Code:

Just swap out the text strings like 'MON' or 'TUE' with your actual employee names, then drag the formula down all the way to December 31st. ☕

You didn't even consider a free alternative like LibreOffice. Honestly, even though I have Microsoft Office installed, I find myself using LibreOffice way more often. If you really need the official suite for some specific reason, maybe just grab Microsoft Office for a single PC. Otherwise, stick to the free stuff. Just a little suggestion and some info from my side... ☕

Nicholas Wells74 said:Questions like this really shouldn't be asked on this forum.

I've been using the 2003 version for ages now. Honestly, it does everything I need it to do and I'm happy with it.
I’m actually a little nervous about the day I’m forced to upgrade to the 2007 or 2010 versions—all those new ribbon menus and other unnecessary bells and whistles.
God forbid!

Maybe you just haven't given LibreOffice a fair shot? I'M JUST ASKING!
My job provides me with a licensed version of Microsoft Office 2010, but I've actually been doing most of my work in LibreOffice since back when I was still using the 2003 version, even after docx and xlsx became the standard. And personally? I find those ribbons just as "charming" as anyone else. 🙂 I wouldn't go out and buy Microsoft Office, and I certainly wouldn't install it illegally when there are perfectly good free options available. ☕

I was just thinking about how much easier life gets when you finally get those spreadsheets organized. It’s funny how much time we spend staring at cells, trying to make everything line up perfectly. Honestly, I could spend all day tweaking my Microsoft Excel files until they look exactly the way I want them to! Jack Hayes says:
Is there a way to set up Excel so that whatever I type in Column 1 automatically copies itself over to, say, Column 10? The reason I’m asking is that I need to make sure the address, owner's name, and contact info show up on every single page of my A4 printouts. I was wondering if I could either have the data mirror itself into Column 10, or—even better—just have everything stay in Column 1 on my screen while magically appearing at the top of every printed page. Any tips?

Looking for duplicate rows or columns? Just check the menu. I’ve been messing around with my spreadsheets all morning, trying to get everything looking just right before I send them over to the boss. I hit a little snag while working in Microsoft Excel—specifically when it comes to getting those header rows to show up on every single page when you print. It’s one of those things that seems simple until you're staring at a hundred pages of data and realizing the titles are only on the first one! Does anyone have a quick tip on how to set up "Rows to repeat at top" so the layout stays consistent? I want to make sure this looks professional once it hits the printer. Thanks in advance! I'm sorry, I think you might have sent that message before you were finished typing! What was on your mind? I was playing around with some data yesterday and realized I needed to fix my print settings. If you're trying to get those specific columns to show up on every single page when you print, here’s how you handle it. First, head over to the Page Layout tab in Microsoft Excel. Look for the Print Titles option—it's right there in the Page Setup group. Once that window pops up, click into the "Columns to repeat at left" box. Instead of typing anything manually, just go ahead and click the column header on your sheet that you want to stay visible. It's much easier than trying to guess the cell references! After that, hit OK and you should be all set.That’s probably tucked away in Page Setup. Or maybe somewhere else nearby. Just Google it.. ☕

I used an example where the data starts over at cell D2. If your setup actually kicks off at cell C2, then you'll want to use these formulas instead:
Code:

☕

quietcobra21 said:Actually, column C is the initial price Peter offered, and D is his final price. Column E shows Mark's initial offer, while F is Mark's final price. Basically, the spreadsheet identifies which bidder gave the lowest price, puts that value in column G, and then calculates the ratio of the initial price to the final price for whichever bidder was cheaper—and it doesn't have to be the same person for every item. For apples, Mark was cheaper; for pears, it was Peter; and for plums, we're back to Mark.
How do I pull this off? Help?

No, wait, did you try using a formula yet?
Look, if you don't care about keeping a strict structure—like, if the lowest price could just be any cell belonging to a specific user—you can actually handle this entire thing using MIN and MAX functions.
- finding the lowest price
Code:

- this grabs all the values, both starting and final prices.
- calculating the index
Code:

- if both people submitted the exact same lowest price, the index is the lowest price divided by the highest price; if they aren't the same, then
- if the first person has the lowest price (regardless of whether it was their start or end price), the index is the lowest price divided by their own highest price; otherwise
- the index is the lowest price divided by the second person's highest price.
☕