Nah just stupid number formatting, my UPCs regularly turn into scientific notation or my UOM automatically convert to a string =“12” which ruins math operations so first I have to make a helper column =NUMBERVALUE([@UOM]).

Or being unable to convert datetime to a simple date for date calculations without loading the table into power query and transforming it there. You can change the format into short date but if the actual value is datetime it will still throw an error but now the type issue is hidden, so have fun reading docs and troubleshooting until you realize your mistake :)

Best I can do is 7.45678e17

Yeah if its something ad hoc I’ll paste values but for sheets meant to be maintained I’ll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)

Damn you just described my role but everything happened within a span of 3 years

Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works 😫

I think it’s just the most simplified you can get talking about cellular biology, specifically when teaching organelles. So most primary science textbooks use that terminology and it’s more memorable than all the other organelles so it just stuck and it got repeated and reviewed every year and it sorta became a pre Internet meme and part of a shared consciousness if you were schooled in the US.

Hah I’ve thought of this maybe I can look into it, I’m an amateur Arduino enthusiast but it might even be more simple than that.

The same crossed my mind but that would be hell for everyone around you on a sunny day. Sometimes even just a car with a lot of chrome is annoying 😔

I recently had a high beam tailgating me. I moved my side and rearview mirrors to reflect it back and he passed me on a double yellow line with him in front of me I just turned on my own high beams. He turned off soon after but I hope it made his day a little more frustrating ¯_(ツ)_/¯

Dude YES. 20 years ago driving in the country you see some high beams in the distance and people would go back to low beams as they get around a corner or crest a hill when they see other cars.

My commute is through a lot of schools and parks and pedestrian crossings and it’s somewhat poorly lit, so everyone has high beams on regardless of traffic but as a result I can’t see shit. If there’s oncoming cars stopped and a pedestrian tries to squeak through I literally wouldn’t be able to tell.

It’s gotten so bad, either people have their brights on all the time or they’re not adjusted properly. In either case headlights DONT HAVE TO BE SO BRIGHT.

I’ve noticed this a lot lately. Extremely long winded and well written emails that could just be a few bullet points.

Give me the human version please. If your email fills my entire screen it’s going through the GPT gauntlet and if your point is lost that’s kinda on you.

If you ever find a way around this let me know, it’s maddening. Especially overseas contacts where I have to wait a day in-between responses, sometimes it takes a week or more to get what I need.

I have a friend that tried me to get into this and I just couldn’t it wasn’t that fun.

One of my all time favorites. There’s something special about the N64, these games were magical as a kid and a lot of them still hold up today.

I used to play through Ocarina almost every year but it’s been about a decade and I started a playthrough last week. People have made some incredible progress on updating textures and such to make the game look more modern 👌

There’s a happy medium. I have a slightly newer VW GTI (2017) with a touchscreen but there are still buttons and dials for basically everything. It’s a perfect infotainment system if you ask me :)

So I just watched it for the first time earlier this year and honestly it wasn’t bad. It’s cheesy (and by most measures not a great film), but it was genuinely fun to watch.

TIL my boss is more evil than Darth Vader.

If I were applying I might do a cover letter for like my top 2-3 picks just to try and tip the scales.

I do the hiring for my department and most cover letters are AI/template garbage but sometimes I’ll get a short and sweet one that seems genuine and it gives a legitimate edge.

That’s sad to hear. It’s been a long time since I’ve played any sports games and I had a hankering recently but everything has shit reviews and I keep coming across stories like yours.

Remember a game would come out with everything you need to enjoy the game? ¯_(ツ)_/¯

You must really hate going to the movies. If I spend $60-70 on a game and get 50-100+ hours of entertainment from that money spent that’s a dub in my book.

If someone enjoys flight simming it’s not really a question, they will buy this game because it’s one of the best all-around sims.