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’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.

Also pandas and matplotlib but maybe that’s just me.

-Data Nerd

Yeah but fuck all that python is good enough for most beginners. Variables, scope, loops, functions, operators… Once you get some of the principles down switching to C++ or similar isn’t nearly as bad.

Being a person that tried to learn C/C# from scratch in my early days python was a good gateway language.

I love that realization when I throw some hacky shit together and it somehow works first try.

When I try to be organized and meticulous nothing works and I eventually give up.

Forkyz ❤️

You guys are only using 8 joins?

Unrelated but alt+e+s+v is so ingrained into my muscle memory. I should really get a macro pad

Very cool post, thanks for sharing

I can’t speak for everyone but I rely heavily on VBA scripts, dozens of macros, PowerQuery for ETL, connection to azure SQL data, etc. If you work with big data excel is basically a must.

What’s next… Underware?

It’s not as bad as you might think if you have a specific goal in mind. My scope is mainly scripts and automation (python) for data analysis and productivity.

My boss was curious about market basket analysis so I spent an afternoon following along with a tutorial and researching and got the data I needed by EOD. Most of that time was cleaning up the input data and troubleshooting because it was a huge data set.

We use brother printers at work and they’re 10/10. Even with a fresh windows install they just work.

I do things probably the stupidest way imaginable and find someone’s git project using a library I need to use and see how they used it.

People that release libraries with demos and use cases are angels, in my eyes at least.

When they don’t inherit the traits you want so you kill your children and start over.