494
Thoughts??
(mander.xyz)
A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.
Rules
This is a science community. We use the Dawkins definition of meme.
I learned how to do a fucking LOT of statistical shit in my degree. I also learned to get REALLY good at all kinds of shit in Excel.
Guess which helped my career on an actual practical way the most? Guess which made people seek me out at work for help with things?
Sometimes Excel is what's available. Sometimes it's just faster to do it that way rather than code up some ridiculously overdone solution in some programming language. Having both skills is best, but don't shit on opening an excel and just fucking getting it done, whatever it is.
If used right, it can also be a great equalizer with those less technically skilled in your workplace. You can quickly format and tune things and even layer a little bit of vba to make their lives easier without having to get into the complexity of an entire bespoke coded solution.
Also, a reminder for those in the back. For most of us, we aren't in college to learn a specific skill so much as we are there to learn how to be taught. To prove we are capable of taking instructions and producing results as requested.
If you never understand this, then you'll never understand later why you fail to land a high quality job.
FOSS is always available. R is always available. Your points remain but you're never in a situation where Excel is the only thing you can use.
R, the language where dependency resolution is built upon thoughts and prayers.
Say what you want about Excel, but compatibility is kinda decent (ignoring locales and DNA sequences). Meanwhile, good luck replicating your R installation on another machine.
You heard about conda/containers/pixi/whatever?
PS: Excel will often fail if your system has a different default language. Like in many European countries one and a half is 1,5, not 1.5. Excel can't take it.
I have fucked around enough with R’s package management. Makes Python look like a god damn dream. Containers around it is just polishing a turd. Still have nightmares from building containers with R in automated pipelines, ending up at like 8 GB per container.
Also, good luck getting reproducible container builds.
Regarding locales - yes, I mentioned that. Thats’s a shitty design decision if I ever saw one. But within a locale, most Excel documents from last century and onwards should work reasonably well. (Well, normal Excel files. Macros and VB really shouldn’t work…). And it works on normal office machines, and you can email the files, and you can give it to your boss. And your boss can actually do something with it.
I also think Excel should be replaced by something. But not R.