Thomas Long7 said:He was running with an open DRS in a zone where it’s strictly forbidden... it doesn't matter if he left it open on purpose or if some faulty sensor or mechanical glitch triggered it... It's against the rules, period—and that requires a penalty...
Think about it: if a car has a speed limiter failure in the pits, they get hit with a penalty immediately—regardless of whether it was an accidental error...
Rules are rules...
Look, since race control manages the DRS system, they can just shut the whole thing down if they want. A speed limiter isn't part of the actual racing; it's driver assistance, and nobody is forced to use it. Drivers manage their speed in the pits through the throttle and brakes, just like in any other form of motorsport. Now, we have to ask ourselves: how much of an advantage does the DRS actually give versus the damage done by having it open for 90% of the lap without grip, especially with those extra pit stops to fix it... In reality, Alonso has already been punished by the mechanical failure, which robbed him of a fair fight for most of the race...
mistybear522 said:I tried tweaking those settings too, but honestly, it didn't change a thing. I'm starting to think the issue is actually with the hardware itself. I've got a Brother HL-L2350DW, and this thing insists on having the paper aligned to the left when it pulls it in. If I slide an envelope to the left, it grabs it just fine and prints perfectly. But the second I try to center it or push it to the right? It acts like there isn't even any paper in the tray! Is it possible the software is sending a command for right-alignment? Because when I tried printing an envelope using standard A4 settings, the text ended up landing exactly where it should have... Man, now I feel like I just made things even more confusing for everyone 😁 The problem is still hanging around...
My guess? It’s probably just a simple sensor issue inside the printer. If it keeps demanding everything be left-aligned, it's likely because the sensor (that little microswitch) near the feeder is positioned further to the left. That way, one single sensor can detect all the different paper sizes it handles. You might actually be able to spot it yourself if you look closely—you'll see a tiny plastic lever that the paper pushes against as it moves through.
At the end of the day, you'll just have to adjust your "layout" to match how the machine wants to grab the paper, and call it a day. For example, most laser printers have that sensor right in the middle, so the guides for the manual feed slot move in sync to keep the paper centered over the sensor. I don't deal with inkjets all that much, but I'd bet the sensor is offset specifically so it stays versatile enough to handle photo paper, various sizes, etc., by keeping it off to one side...
Patrick Sanders91 said:Thanks, it's pretty simple. I fixed it and now it goes d again = and then click on the profit sheet, then the first column with the right click, and then what? task description In the Percentage worksheet, calculate the % profit share for each year relative to the total profit. Perform the calculation based on data linked from the Profit worksheet. Display the % data using the percentage category with four decimal places.🤷
Of course it’s easy when we're talking elementary math, but me, a big-hearted American soul, had to grab the chance to act like a genius...
You don't know how to move forward because you're missing one specific piece of info, right? Total profit. So, underneath the profit data in your Profit table, you just need to add up all the profits, say =SUM( B2 : B5 ) or whatever cells you used for that.
Now, just like before, divide the individual profit by that total profit.
Just a heads up: if you're going to drag that first formula down, make sure to use an absolute reference for the total profit sum, like:
=Profit!B2/Profit!B$5 (if the total profit is in cell B5, that $ "locks" the row so it doesn't shift when you copy it down)
Notice how both pieces of data are on the same sheet now? Makes it even easier (unless this task requires a new sheet)
Then just format the result as "Percentage" with the requested number of decimals...
BTW buddy, I've got your back. No shame in learning from a pro, right?
Did you finish that Revenue table yet? If you did: - Right-click on "Sheet2" - Rename - Expenses - Select the whole Revenue table - right-click - Copy - (go to your new Expenses sheet) - Paste - In that new sheet, just change the header from "Revenue" to "Expenses" - Click the first cell in your new table, type "=", then click over to the "Revenue" sheet and grab the first value in the revenue column, then type *0.9503 and hit enter. - Drag that cell down to fill the rest. - Highlight all those numbers, right-click - Format cells - Number - check the box for the separator, and make sure you've got two decimal places set.
/* and don't include those quotation marks */
Honestly, you might want to brush up on this stuff before the school year starts. How are you gonna survive when you hit college level math? ☕
ruggedcyclist7 said:Forget formatting, just use the formula =ROUND(number,num_digits). For num_digits—just pick how many decimal places you want (like 2 in your case)
That covers one part of the problem. But if you don't use formatting, it won't hit those other requirements, like making sure you aren't seeing trailing zeros after whole numbers or extra decimals. So, you should probably leave the cell format set to General, assuming it hasn't been changed already (you know how people love tweaking blank templates to fit their own vibe).
Microsoft Office Home and Business 2010: Word, Excel, PowerPoint, OneNote, Outlook It's the retail version, so you get the actual box and the disc. No dealing with any of that PKC nonsense. You get licenses for two machines—one desktop and one laptop—but apparently, you can't run it on two desktops at once. At least, that's how they explain it over at Microsoft USA. Price: roughly $215 The downside? It's all in American. Place: For example, right here
Honestly, using a database just feels more natural when you're dealing with that much data and all those different types... What exactly is a delimiter in a .txt file anyway? And does importing them into databases actually work?
Benjamin Wilson7 said:Actually, you pretty much answered your own question 🙂, though I gotta admit I've never really needed to do something like that in real life.
- just remembered, if you hold ALT and hit ENTER, you can force a line break inside a cell to push the text down—like keeping it in the top third of the cell. But the catch is that math won't work right then, and it only works if you manually increase the row height, which I doubt will satisfy you, or will it?
..., or will it?😂 (sorry, I know a similar joke, so it popped into my head)
Nope, that's not what I'm looking for.
What you're suggesting is just a quick-fix way to wrap text.
What I actually want is precise positioning—like placing a single digit at exactly 2/5ths the height of the cell, or maybe making sure it stays exactly 3mm from the top edge, something like this...
This is a context menu from LibreOffice (and an older version at that). As you can see, there's an option to set padding (basically the space between the cell border and the content) for all four sides, plus you can sync them up so they're identical on every side. Since it's a context menu, any settings you pick here apply specifically to the selected cell, a group of cells, or even the whole table if you want...
Basically, it's the exact same concept as setting page margins, except we're talking about cell margins. In LibreOffice, you can set this property locally for whatever you select, meaning you could have a ton of different margin settings all on one single sheet. Plus, you can define these "margins" in specific increments provided by default—like 0.5mm—or you can manually type in a value with precision down to 0.01mm (man, I wish Microsoft Excel offered even a 1mm increment!)
I can't find that in Excel: setting a left or right "offset" using globally defined increments, or having vertical alignment options beyond just centering...
Alright, my turn to step up and play the expert since I’ve been busy handing out advice to everyone else lately! 🤦
So, here's my dilemma with Excel 2010:
Is there any way to get actually precise control over how content sits inside a cell? I mean, beyond just the usual left, right, center, top, or bottom alignment. The only other thing I found was that "indent" feature (yeah, yeah, I know, using non-English menus is a total drag), which lets me nudge things left or right, but those units are set globally rather than per cell. I don't see anything similar for adjusting vertical placement...
Coming from an OpenOffice background, where you can just right-click, hit Format, and find "Spacing to contents" to set custom margins for all four sides of every single cell, I’m honestly shocked that a giant like Microsoft hasn't built something identical. How is that even possible???
Right now, my only choices are to vertically center everything or just let the text sit awkwardly stuck against the cell border...
I've got this spreadsheet with a list of cities and zip codes all lumped together...
For example:
60601 Chicago, IL 90210 Beverly Hills ....
Now I need to split them up so the zip code goes into one column and the city name goes into the next (2 columns total).
What's the easiest way to pull this off?
I tried using the "Text to Columns" feature in Excel, but it's acting up because some places have multiple names or extra spaces, so it keeps splitting things into too many columns.
Wait, didn't we already tackle something just like this in that other thread from the previous page? A little off-topic: Is that guy who usually handles the Excel stuff actually coming back to work, or is his desk just sitting empty? Is anyone even interested in taking over?
@Walter Jackson48/">@@Walter Jackson48, thanks for catching that! I totally skipped over the second half of the IF function, didn't even realize it was going to spit out a 0...
Pop this formula into cell N1: =IF(G1=1,"MON,")&IF(H1=1,"TUE,")+...
Or just go with =CONCATENATE(IF(G1=1,"MON,"),IF(H1=1,"TUE,"),...)
That CONCATENATE function works fine in LibreOffice, so I'm pretty sure it's available in Microsoft Excel too, right? Also, in LibreOffice you use a semicolon as a delimiter, but if I remember correctly, Microsoft Excel uses a standard comma...
I bet their Resume says something like "proficient in Microsoft Office" ☕
First problem->here's a direct fix, no macros or scripts needed, just pure brute force:
1. Add a single column for "Gender" where every row will show either "Male" or "Female"
2. In the first row, pop in this formula: =IF(LEFT(A1,4)="mrs.","Female","Male") (just swap out that A1 in the formula for whatever cell actually holds the data)
3. Drag that formula all the way down the column
This assumes your data is clean—meaning everyone is labeled consistently as "mr." or "mrs.". If one lady is listed as "madam," you'll need to tweak the formula or clean up the data first...
Pro tip: If you aren't sure what you're doing, make a backup copy of the file first and just play around with that...
Edit: That syntax was from OpenOffice, so I might have used a comma instead of a semicolon...
Fawkes would probably demand some kind of masterclass certification just to become a moderator; Barbara thinks moderators are basically just customer service reps for some big telecom company; The mods would just vote for themselves if they could, but hey, we don't have a button, right?
Meanwhile, I’m sitting here studying the poll rules and begging the admin to give me a button (I try clicking him once a day, but why isn't it working??)
You make a good point. Maybe I’m nitpicking a little, but if you ask me, about 70% of people out there don't even grasp the difference between absolute and relative cell references. And don't even get me started on what happens when they try to copy-paste them everywhere! Of course, I’m not saying that’s what happened here—it's just that the fact he tried using an Excel function instead of building some messy workaround with SUM() gives it away. Plus, my biggest gripe is how OpenOffice syntax doesn't always play nice with Microsoft Office tools. Even I run into hiccups when switching between them. Sure, the free stuff covers maybe 95% of what I need daily, but man, sometimes I just facepalm at the Pivot Table results I get. I'm with you, though—it’s definitely not built for quick beginner fixes. For the heavy-duty stuff that you set up once and leave running forever? Not a chance. Besides, testing things thoroughly is just kind of in my DNA...
Of course you didn't catch that I was talking nonsense! You can't really mess around with subtotals if all you want is a grand total on a separate sheet. But hey, you can solve this super elegantly using a Pivot Table, as long as you still have that Team column (you know, to show which group everyone belongs to)... I can't give you a step-by-step guide because I'm working in OpenOffice, so my specific menu paths might not mean much to you, but here's the gist: select your data range (it's best if your first row has headers, so make sure to include those), go to the Data menu and pick Pivot Table (or whatever the equivalent is in Excel), set the destination to a new sheet in the options, then in the wizard, drag "Team" into the row labels and pull "Weight" into the values area. Boom. Done. That’s how it works in OO, and I just tested it out myself—I whipped up a quick mockup with some dummy data in about 30 seconds flat..
First things first: head over to the first sheet and toss in a new column. You'll need to assign a team name to every person there, since that’s going to be super important for your math later on. Once that's done, don't just go around adding up cells using absolute references on the second sheet. That's a rookie move! Instead, use a conditional subtotal based on that team attribute. It's the only way to make sure your calculations stay dynamic, no matter how you shuffle the people around on that first sheet...
Karen Ortiz83, just ignore him and go straight for it. @James Fisher11/">@@James Fisher11 is comparing apples to oranges here: he’s pitting some random no-name thumb drive with "god-tier" speed claims against actual drives. Even at their worst, these disks hit around 40 MB/s, which is plenty for streaming (hey, free!) video content. I mean, a decent USB drive usually hits less than 30 MB/s, and most cheap ones struggle to even break 20 MB/s.
As for how long it lasts? Well, everything electronic eventually dies, right? It’ll become obsolete sooner or later regardless of how much you use it. But let's be real—this is a portable drive, not some heavy-duty server model designed to run 24/7.
I’ve got a storejet 250 GB, and honestly, it works like a charm. It doesn't hog power, so I can plug it right into my Roku streaming box without needing an extra power supply. On my PC, I just use a standard single cable—that thicker Y-style one—and it never skips a beat. Plus, the casing is great; that rubberized finish means it doesn't slide around. It basically sticks right where you put it, feels super solid in your hand...
