Posts by silvergull10

What can we actually expect from this track? Is anyone anticipating Kimi coming out swinging at the start tomorrow, only to get bogged down by a dirty surface or some other nonsense? I’m also genuinely curious about how Ferrari plans to handle things this year. They didn't run into nearly as many issues last season, but looking at the field right now, that duo is breathing down their necks.

Did Vettel even bother putting in a second lap, or did he just throw in the towel before he even started? Williams really should have been sitting in the 3-4 range here.

Despite all the hype surrounding a potential Ferrari comeback, the Italian team were 1.43 secs slower Than Hamilton—barely shaving off 0.2 seconds from where they stood last year when their former driver Fernando Alonso managed to qualify fifth.

If that ridiculous 107 percent rule were actually in effect, McLaren could probably just pack up their bags right now and head straight to Sepang.

Giedo van der Garde won his legal battle, so he’s officially back in the seat for this weekend. Now we just wait to see who Sauber decides to drop to make room. Honestly, he’ll probably end up being sidelined just like Nelson Piquet Jr.; you can't afford to go toe-to-toe with the team when you don't have any major backing behind you.

Hopefully, we get some clear skies over the Midwest. If we hit any heavy rain or high winds, my stream quality is going to tank. I’m going to spend a little more time tinkering with my antenna setup, hoping I can prevent the signal from pixelating.

How do I sum up specific cells spread across different sheets when they aren't lined up in the same rows? I’ve been messing around with VLOOKUP and various other methods, but I’m officially out of ideas 🙂. Any help would be appreciated. I can't sort the data because it would mess everything up.
http://www.datafilehost.com/d/9ebb33f3
Basically, what should replace the "xxx" in this formula: "=SUM(zg🙏t!XXX)" so that it totals the beer fields located on the fourth sheet?

EDIT: That bit above was just me typing a colon; I accidentally hit the right key combination and the forum turned it into a smiley face 🤣.

That’s great, thanks. You didn't really need to go through the trouble of explaining how to add an expression to a cell—I actually figured that out on my first pass—but I appreciate it. It'll definitely come in handy for someone else reading this thread.

I think you missed my point because you got too hung up on the specific example I used—and honestly, changing a single value like that is trivial with a basic find-and-replace. In my actual spreadsheet, I’m dealing with a massive variety of data points: different cities, streets, lakes, mountains, and so on. What Kyle Johnson2 is suggesting is definitely the right way to go, but I’m currently struggling to get the nested formulas to behave themselves. I have already implemented the CONCATENATE command 👍. From what I can see, Excel offers a tool called Kutools that solves this exact headache instantly, but those bastards charge a premium for it.

1. I'm trying to figure out how to fix capitalization in Excel. I already know about the PROPER and UPPER functions, but they aren't doing what I need. For example, if I have "El Paso City Street," I want it to look like "El Paso City Street," but my current attempts are forcing everything into lowercase after the first letter—turning it into "El paso city street." I need a way to capitalize the first letter of the cell while leaving the rest of the existing casing exactly as it is.
2. Does anyone happen to have a link to a reliable site that lists these kinds of macros or VBA snippets?
3. Also, is there an efficient way to bulk-insert text into an entire column? Say I have a list containing "Mainz" and "El Paso," and I want to prepend the word "Street" so it reads "Street Mainz" and "Street El Paso." On the flip side, I also need to append text to the end of cells—like turning "Frankopanski" or "Heinzlov" into "Frankopanski Street" or "Heinzlov Street."

That’s one of the most pointless Safety Car calls I’ve seen in a long time. By the time they actually pulled the trigger, the race was already effectively decided, making the whole deployment a complete waste of time. It felt entirely unnecessary. Besides, we could really do with some lessons for the drivers on how to actually clear the track when the opportunity arises.

Personally, I’m anticipating some strategic overcuts here. My expectations are high for Kimi Raikkonen if he can manage to stretch that opening stint significantly; while the drivers who pit early are stuck fighting through traffic, he could find a massive advantage. I remember back when Fernando Alonso managed to charge through the field after starting from the very back. Granted, he was carving through the midfield back then—teams that were two or three seconds off his pace per lap—but today, Pirelli’s tire degradation creates a gap between even the top-tier cars that is just as substantial.

stormybadger8 said:If you've been around here long enough, you don't even have to imagine.🤣
Some of these folks actually remember when they used to call Alonso a fraud, a cheat, a coward, a little snitch, and all that junk.
Honestly, compared to what they said about Sebastian Vettel or Kimi Raikkonen, they were being pretty soft on them. They went way harder on Alonso, attacking him from every angle imaginable...
So yeah, their reaction is totally predictable. It’s not just predictable—it’s the exact same crowd that spent years insulting Alonso while he was winning in a "wrong car"...

But why even get worked up? There's a great feature on this forum called the "ignore list"... and it's pretty sweet when you have a blue nickname and the privilege to actually use it.😍

I’d bet anything you don't actually use her; you just sit there eagerly waiting for posts like this so you can finally unload on someone.
Regardless of the race itself, thank God the podium ended up looking the way it did, no matter who stood where. That was honestly all I wanted from this race. Reading through the previews the day before, I found myself getting a little anxious that Sebastian Vettel or Jenson Button might actually sneak onto the podium. Even toward the end, when he started closing in on Lewis Hamilton, I was feeling the tension. 😠It would be an absolute embarrassment if, in a standard race free from unforeseen chaos, drivers who simply managed their tires during Q3 were rewarded with a podium finish. In my view, the regulations should be adjusted to ensure there is a dedicated set of tires allocated specifically for qualifying and a separate set for the race itself. Furthermore, we should mandate that the race starts on the exact same tire component used to set the qualifying times.

stormybadger8—isn't it about time you started a dedicated TBF1 vs. the community thread? 😁, this current setup is ridiculous. Yesterday it was all about the transfer market, today it’s just endless gossip, and neither belongs here. Also, what's the deal with your moderation style? Are you only acting as a moderator during winter testing or 🤷, I'm being serious here?

stormybadger8 said:So the plan was basically to chase them down and lap them? Using it like that feels pretty stupid, but hey, if that’s how they want to play it.

I honestly missed that detail earlier. I was busy digging around for info on that new contract😁, then I stumbled onto this video and it actually caught me off guard.

All in all, the clip is way too short to really make sense of what happened or why, but the one thing that’s totally nonsensical is that you can just use DRS whenever you want, regardless of whether you've already lapped the driver before the activation zone.

It’s just plain ridiculous.🙄

I don't think Vettel lost anything because of this. Even if Red Bull had let him go, he probably would've just overtaken Alonso on the next lap or ended up in a wreck anyway.🤣

Regardless, that specific rule is just dumb.🙂

He wouldn't have had the pace to pass him; even he admitted that at the press conference—they simply didn't have the speed yesterday.
In my view, the way DRS is structured is purely for technical simplicity. It would be an absolute nightmare to design a system that tracks everyone's exact position and gap on the track in real-time. This current setup is straightforward and functional. As far as I can tell, it’s pretty boring; I noticed it only once when someone got squeezed out, and that was specifically Alonso while he was battling Schumi.

mistybear87 said:He has a light that turns on when he’s allowed to use DRS. He didn't trigger it immediately; he only did it later on the straight once he realized he was cleared to go.
It isn't his fault, nor is it Ferrari's. Race control is the only entity responsible for giving the signal for DRS—specifically, through the software they utilize. If the software glitches (maybe there's a "Ferrari mode" 😬) it isn't Fernando Alonso's fault.

3.18.2 The adjustable bodywork may be activated by the driver at any time prior to the start of the race and, for
the sole purpose of improving overtaking opportunities during the race, after the driver has completed a
minimum of two laps after the race start or following a safety car period.
The driver may only activate the adjustable bodywork in the race when he has been notified via the control
electronics (see Article 8.2) that it is enabled. It will only be enabled if the driver is less than one second
behind another at any of the pre-determined positions around each circuit. The system will be disabled by
the control electronics the first time the driver uses the brakes after he has activated the system.
The FIA may, after consulting all competitors, adjust the above time proximity in order to ensure the stated
purpose of the adjustable bodywork is met.
There is absolutely nothing in the regulations stating this doesn't apply to overtaking other drivers; we have seen similar situations in previous races. Everything is perfectly within the rules, and honestly, Red Bull would be complaining if it weren't.

stormybadger8 said:Fernando Alonso is defending his spot using DRS

WTF 😕

I didn't even wrap my head around how that was even possible 😕

It’s because the detection zone is positioned quite a bit earlier, and they were actually lapping the car there. If you look at the car trailing him on the main straight, it was right ahead of Alonso when it hit the detection zone. It seems nonsensical, but the detection system doesn't distinguish between drivers who have been lapped and those fighting for position; we've seen this happen several times this year already.

Joshua Newman2 said:- Fernando is running on a questionable engine (this will be his fifth race on this specific unit, right?) and it wouldn't surprise me at all if it blew. If that happens, Red Bull takes the win because they'll have destiny on their side.

I highly doubt he'll be stuck with that particular engine. They have the one from Spa-Francorchamps (which hasn't been through a full race distance yet). Plus, there's the first engine from Bahrain, which I assume they haven't pushed to the limit during free practice—assuming they even used it at all.

stormyviper11 said:Look, for me, soccer perfection—or as close as it gets—was that 1994 US National Team run where they made it to the finals while only letting opponents get shots on goal maybe seven or eight times total over six matches... and most of those were desperate long-range shots. Watching a perfect defense was way more satisfying to me than those high-scoring blowouts. It's that same appreciation for tactics and flawless execution that makes me enjoy marathons, biathlons, and other long-winded sports that most people find boring. It's a matter of taste... and honestly, it usually comes with age. When I was younger, I didn't give a damn about those judges scoring ski jumps, but nowadays, whenever I'm watching at Planica, the style matters just as much to me as the distance...

Anyway, back to the point: Alonso had major issues with the car sliding around during the lap when the safety car heads to the pits for the second time this season. In Monaco, I was convinced it was just him being careless, but after seeing it happen again, I'm starting to think it might actually be the car. Does anyone know if there's been anything mentioned about Ferrari having trouble maintaining tire temperatures in those specific situations?

The first instance isn't really a fair comparison because in Monaco, he was running on the same set of tires for almost the entire race, and that slide was largely a byproduct of not actually racing. He instinctively went too heavy on the throttle the moment he saw Michael in his rearview mirror. Therefore, the Singapore incident stands alone, and he likely just miscalculated there. It’s never easy staying composed when you're under constant pressure from Red Bull Racing for the duration of a race.

With Formula 1; Who do you feel was most to blame for Hamilton and Webber's collision in Singapore?

Lewis Hamilton 32.75%
Mark Webber 34.72%
Fifty-fifty 32.52%

A few races ago, everyone was writing Alonso off and making jokes at Ferrari's expense, but look how much they're being feared now. Just remember how much people mocked Alonso when he insisted he could still fight for the title. Honestly, if it weren't for those engine issues, he likely would have clinched it already. McLaren has upgrades coming for Suzuka, and we aren't even close to the finish line yet, so I don't get why people are dismissing them so easily. It's the same old story: Alonso is battling engine reliability and Red Bull is dealing with their own set of issues—from brakes and spark plugs to stupid collisions—yet here is McLaren, back in the mix.

EDIT;We’ve got a good upgrade for Suzuka: we’ll have something that we tried to put on the car this weekend but couldn’t - for reliability reasons. Coupled with our planned-for-Suzuka upgrade, it should hopefully be a bit of a double-whammy

Jenson Button http://www.formula1.com/news/headlin...0/9/11312.html

He’s really pushing his luck again, isn't he? And now he's getting worked up because some journalist actually called him out. He seems to be under the impression that anyone is actually going to give him the answers he's looking for.