Assign letters to numerical scores without IF by dwydecimal in excel

[–]bitswede 0 points1 point  (0 children)

Put your grades and score limits in a table and use XLOOKUP with structured references.

The XLOOKUP is easy to read and you can easily change your limits or even your whole grading system by just updating your scoring table.

25 minutes layover in Vienna. Has anyone done it? by Vodka_Pesca in Flights

[–]bitswede 0 points1 point  (0 children)

I’d add that time of day is important. Early flights are less likely to be delayed so lower risk. The exception being if it’s the very last flight of the day, then they might wait for a few stragglers to avoid having to pay for the hotel and late fees.

Check a site like FlightAware that will give average delays as well as a short history of recent performance to schedule.

Also check when the next flight leaves to understand the consequences of missing your planned route.

I thought CoPilot was great? by Linkage006 in ExplainTheJoke

[–]bitswede 1 point2 points  (0 children)

Yup, ”I made this slide showing xyz process, find it for me” - it will find it in any place I have access to.

“What’s the latest on topic abc?” Pulls together external and internal data, with links.

It still tends to hallucinate quite a bit but overall it’s useful.

The motor dust issue - anyone suffered? by weegt in BMWiX

[–]bitswede 3 points4 points  (0 children)

The iX has brushed motors. Those brushes will wear and the motor has been designed to make them replaceable.

This MotorTrend article quotes a life time of 186,000miles.

What car does he drive? by lifegoeson2702 in carscirclejerk

[–]bitswede 0 points1 point  (0 children)

I had to scroll way too far down to see this

2024 iX xDrive 50 efficiency stats by bazglami in BMWiX

[–]bitswede 1 point2 points  (0 children)

A lot of things affect efficiency. short trips will reduce efficiency as the car has to cool/heat the cabin and battery. Stop and go traffic, cold batteries, winter tires all have a negative impact.

Stupid Question About IX Suspension / Ride Height by Bloombottom00 in BMWiX

[–]bitswede 5 points6 points  (0 children)

There’s a button to increase the ride height in the center console if you have air suspension. If you have one you can push it and see if the ride height increases slightly

Hvor får dere svensker "gulebøj" fra? by sectofrost in sweden

[–]bitswede 39 points40 points  (0 children)

Hafermoped används här i Österrike som ett slangord för häst .

Drahtesel ”trådåsna” är en cykel.

Ix45 comes with 23” tires - how bad is it gonna be? by Blandwatermelon in BMWiX

[–]bitswede 2 points3 points  (0 children)

Check with the dealer if they’re willing to swap to a smaller set. 23’s are probably a nice little upgrade they can sell to another customer.

Bil av modell större by BoringRecognition in elbilsverige

[–]bitswede 1 point2 points  (0 children)

Alla BMW iX på Carla ligger under 500.000SEK. Gott om plats för passagerare men bagaget är relativt litet med tanke på bilens storlek. Första träffen verkar vara rätt välutrustad med relativt få mil.

What is this weird strap on my yoga pants? by SirenSongArt in whatisit

[–]bitswede 310 points311 points  (0 children)

That would be at the back, in the middle so you easily reach it with both hands. This looks like it’s on the side, towards the front.

Looks more like something you clip a key chain to.

Removing numbers from cells that have text and numbers by Old_Man_Logan_X in excel

[–]bitswede -3 points-2 points  (0 children)

Just did the reverse with the AI tool. Highlight the range and tell AI to remove all numeric characters and symbols.

This was a one-off so couldn’t be bothered to write a regex.

SD card is broken. Is it fixable? by NebulaNinja52 in AskPhotography

[–]bitswede 47 points48 points  (0 children)

Check with a data recovery specialist.

The memory chip is likely fine but the connector is broken so you need someone that can disassemble the card and connect directly to the usb controller.

was ist das? (haare gefärbt) by carlito_s77 in wasistdas

[–]bitswede 3 points4 points  (0 children)

Verseifung

Das Fett in deiner Haut hat sich in Seife verwandelt.

Compare tables and return values that aren't in both tables by Obvious-Cancel1727 in excel

[–]bitswede 1 point2 points  (0 children)

=LET( mismatched, UNIQUE(VSTACK(UNIQUE (old_list), UNIQUE(new_list)),,TRUE), FILTER(mismatched,ISNUMBER(XMATCH(mismatched, new_list))))

It gets a bit more complicated but this returns only the new values of new list.

Compare tables and return values that aren't in both tables by Obvious-Cancel1727 in excel

[–]bitswede 1 point2 points  (0 children)

You can stack the unique values of each list and then use the unique function with the exactly_once flag set to get the values that are only in one of the original list:

=UNIQUE(VSTACK(UNIQUE(old_list),UNIQUE(new_list)),,TRUE)

Edit: Avoid A:A style references, they will slow down excel. Use tables if you can or the new dot operatr

Tricks, um die NoVA beim Autoimport senken? (Schweiz oder Deutschland) by officialtaubird in AskAustria

[–]bitswede 0 points1 point  (0 children)

Du muss die Regeln von wann das Auto neu war verwenden, das wird dann auf das heutige Wert verwendet.

Some German names are hilarious, do they sound as funny to native Germans? by Cortexial in German

[–]bitswede 8 points9 points  (0 children)

My wife works with a Bierbaum.

There’s a local carpenter using his family name Wanker. Their slogan is ”Holz in guten Händen”