I will always appreciate a true Excel power user. I’ve seen some black magic shit.
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.
deleted by creator
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)
Matlab excels at dgls, Excel does math not. Newton method isn’t it
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
Not that bad when you sail the high seas
I’ve known people that had authorities show up from that btw
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.
Me: oracle, oracle and more oracle
Damnit, who put a maze with no exits in this cage?
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
deleted by creator
If you dont understand why the specific instruction set you studied isnt the point you should maybe po back to school.
Snarky but true. MIPS actually is common in network equipment. It’s niche, but not completely unused. Also, it’s really an excellent instruction set for teaching.
deleted by creator
deleted by creator
MIPS is RISC type and more open that x86 or ARM. I guess this is why they teach it. Also I heard that some universities/schools starts teaching RISC-V more and more because of just that.
PHP is pretty cool if you know what you’re doing and use its modern, object-oriented features. It’s also very easy to write horrendous spaghetti code with it, which is what most people sadly do and give it a bad rap.
I love lisp type languages. Very neat. Your instructor sounds like a stupid fuck. I say this as a professional programmer.
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
deleted by creator
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?:-)
despite all my rage i’m still just a rat in a cave
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.
