I will always appreciate a true Excel power user. I've seen some black magic shit.
this post was submitted on 27 Jan 2024
617 points (100.0% liked)
Science Memes
235 readers
64 users here now
Welcome to c/science_memes @ Mander.xyz!
A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.
Rules
- Don't throw mud. Behave like an intellectual and remember the human.
- Keep it rooted (on topic).
- No spam.
- Infographics welcome, get schooled.
This is a science community. We use the Dawkins definition of meme.
Research Committee
Other Mander Communities
Science and Research
Biology and Life Sciences
- !abiogenesis@mander.xyz
- !animal-behavior@mander.xyz
- !anthropology@mander.xyz
- !arachnology@mander.xyz
- !balconygardening@slrpnk.net
- !biodiversity@mander.xyz
- !biology@mander.xyz
- !biophysics@mander.xyz
- !botany@mander.xyz
- !ecology@mander.xyz
- !entomology@mander.xyz
- !fermentation@mander.xyz
- !herpetology@mander.xyz
- !houseplants@mander.xyz
- !medicine@mander.xyz
- !microscopy@mander.xyz
- !mycology@mander.xyz
- !nudibranchs@mander.xyz
- !nutrition@mander.xyz
- !palaeoecology@mander.xyz
- !palaeontology@mander.xyz
- !photosynthesis@mander.xyz
- !plantid@mander.xyz
- !plants@mander.xyz
- !reptiles and amphibians@mander.xyz
Physical Sciences
- !astronomy@mander.xyz
- !chemistry@mander.xyz
- !earthscience@mander.xyz
- !geography@mander.xyz
- !geospatial@mander.xyz
- !nuclear@mander.xyz
- !physics@mander.xyz
- !quantum-computing@mander.xyz
- !spectroscopy@mander.xyz
Humanities and Social Sciences
Practical and Applied Sciences
- !exercise-and sports-science@mander.xyz
- !gardening@mander.xyz
- !self sufficiency@mander.xyz
- !soilscience@slrpnk.net
- !terrariums@mander.xyz
- !timelapse@mander.xyz
Memes
Miscellaneous
founded 2 years ago
MODERATORS
This is one of my favorites to share. It's a 3D engine with raytracing with no VBA scripting - all of the calculations are done internally with spreadsheet math.
Good Excel users think themselves better than a beginner. Great Excel users think themselves somewhere between Intermediate and Advanced. Excel Masters, and I know one who placed in that Excel data modeling competition, know they’re somewhere in the Intermediate to Advanced range.
Yeah, but it's the kind of black magic where you accidentally summon Cthulhu and only notice it, after he destroyed half of the city.
load more comments
(1 replies)
Excel is a powerful tool. I was solving system of differential equations with Newton method in it. Sometimes it is easier than in Matlab (or Mathematica) if all you have is good understanding of how step-wise equations should look like, but not the differential equations themselves. Those steps may include if statements, for example.
Had to do a similar project and it took me three full days of back and forth with another software before I found out EXCEL rounds small numbers in very weird ways.
Also, in EXCEL functions/formulas and data/values are wildly mixed.
(Not mentioning a plethora of other mildly infuriating quirks here)
What does it do that LibreOffice Calc doesn't do?
Almost nothing, considering Calc is a clone. I don't think people are excluding LibreOffice from the list of smooth brain apps.
Embed objects and query spaces from other Microsoft products, mainly.
It's a circular argument that all of the corporate world is too heavily invested in to change.
Does libre office do pivot charts?
Call me crazy, but the admittance matrix hw (Gaussian, G-S, Newton, N-R, etc.) I did last semester was much more intuitive for me on MATLAB than on Excel... but I'm gonna get screwed for that because a vast majority of companies would never bother to pay for MATLAB (+ Toolboxes) licenses.
There is always Octave.
And I am not claiming that Excel is better than Matlab. There are lots of tasks where Matlab is better, or where it is not even possible to use Excel with any efficiency. And yet, Excel IS a powerful tool for scientists and engineers. Not just for accountants.
We have a single licence for matlab installed on an old laptop in the lab. I find it easier to program in Excel than try to reserve the laptop and go to the office (sometimes you reserve it and after arriving you find out that the last guy never returned it so you spend extra time trying to find where it is or who has it)
load more comments
(1 replies)
Being a SOLIDWORKS customer is exactly the same as being a rat in a cage. They are the most aggressively evil I’ve ever experienced. Adobe etc not even close
Yeah I wanted to comment on this too. It's a win for ms against dassault every time
Is it just me or is office 365 just worse and more impractical than the old office suites?
Solidworks, Matlab is not exactly what you call CHAD open-source tech as opposed to Python where you can get shit done with it.
The Ribbon interface used on office products isn't there because it's good UX. It exists because there's a software patent on it.
If office didn't use a patented UI, someone could make office software that replicated the UI of MS Office which would allow companies to switch to other products without having to retrain staff.
Microsoft was enshittifying their software long before anyone else.
No matter where you stand on your views of the ribbon, Microsoft introduced it in what, 2007? The patent is gonna expire soon.
There's a middleground. Power Automate. The website crashes Firefox.
That bottom row of wojaks are ableist as hell, I really wish people would stop using them.
4chan is a perpetual blight on memetic culture
Yeah, I really hate when their shit sticks..
Wojacks are the laziest shit ever. So ugly. So annoying. And yes absolutely ableist and other worthless stereotypes
Me: oracle, oracle and more oracle
Damnit, who put a maze with no exits in this cage?
I use python occasionally at work.
... Not IT approved, but well... we use an MSP, and I get to be a decision maker in the company for certain things, and just do it, because well.... I can, and the company keeps me around partially for the things I do with python and sql.
I would like to say Pandas should be used for much of that excel stuff, maybe even replace it, but... Microsoft has decided to bring Python capabilities into excel, so that will likely cement them in your workflow even further:
I've found the selling point in not needing to open excel and click around to run the script. So often people need to do like the same three things and don't even know how to write Python, so giving them a script to drag your file onto is a step up from excel
despite all my rage i'm still just a rat in a cave
Capitalism somehow means managers know better than you how STEM work should be done. Sigh... get used to it if you want to continue.:-| Make some FOSS on the side for fun?:-)
What is stopping you from proposing better software?
Never worked in a corporate environment?
Sure I have.
If you spin it by saying it would improve productivity, they'll listen and pretend it was their idea all along.
Or (way more likely) they'll just not listen or find excuses. That's how large corporations work. Do you really think, you'd be the first one to propose that maybe excel isn't the best tool for the job?
Mainly corporate momentum.
The decision to shift out of the microsoft is too costly at this point for even medium sized businesses to consider.
Nothing. It's the listening bit from the receiving end that's the problem.
Engineer in uni vs engineering job?
They missed using Access incorrectly with too many users and too large of a database.
Man I guess I’m spoiled. We get access to the top row except SolidWorks because we license an alternative. We use the entire MS suite too though but as a supplement. I don’t use excel hardly at all because JMP is superior in every single way, except for dashboards where we use PowerBI.
I for one think this demonstrates how overpriced universities are. All of academia is comparable to a ponzi scheme.
I use mainly python at work, but usually exit to excel to share the results to other people.
Openpyxl is for you.
I use Pandas, but im sure i have that library installed for Pandas use.
I'm in university and I use both...
So True, what about Automic, and Imformatica? Also Oracle..
view more: next ›