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.
Matlab excels at dgls, Excel does math not. Newton method isn’t it
matlab
Octave works as a great replacement
Octave 💪💻!!
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
I have to use solidworks at work. God, do I miss Creo.
I used Creo for about 5 years at a previous job but I never knew the cost. How does it compare?
Creo has a bit of a steeper learning curve to be sure, and is more expensive.
But it also is, in my experience, much more robust and has a lot more capability on the advanced side of modeling. Solidworks requires more workarounds in order to accomplish what you’re trying to do, vs Creo with probably a dedicated tool for that specific task.
Is it just me or is office 365 just worse and more impractical than the old office suites?
I think it’s mostly because they keep trying to push other services down your throat. For example, opening a link in Outlook opens it in Edge, even when your default browser is something else. I can’t use Edge for that link, I’m not signed into stuff there. So now, because of retarded decisions like that, Outlook actually is missing basic features that Hotmail in the 90s had.
because of retarded decisions like that
You know you could have just used shitty instead of using a slur, which would have the same emphasis without the baggage of the other word.
Idiot. Moron. Imbecile. All words used as retarded before it. 🤷♂️
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?
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?:-)
I did computer science, and we used MIPS Assembly…
I ask you, when has anyone EVER wanted to use a MIPS processor lol.
Also, for AI, we were forced to use LISP, which the lecturer didn’t teach. He graded us using a poorly written script, and if your program crashed his script, he gave you 0. You only got 1 attempt. But, when is the last time, ANYONE has used LISP either lol
And Perl… And PHP, etc
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.
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.
That is true… However, I guess I’m a bit salty we didn’t do ARM instead
That being said, admittedly, I’ve never used assembly again anyway lol (except once, for reverse engineering something)
Mobile phones like the N97 were already using ARM… Whilst it might have been about learning the algorithms, one could argue considering the cost of university that we should at least get taught on the best platform (obviously RISC based in this case).
One could make the same argument about anything though. I could argue they shouldn’t have even taught X86 architecture, and taught TempleOS instead of Unix Tools (after all, it’s NOT the point). The point is to learn, but it is also to avoid double learning AFTER uni too.
I will give them props for at least teaching us OpenGL at the time instead of Glide (that was a good decision).
deleted by creator
I love lisp type languages. Very neat. Your instructor sounds like a stupid fuck. I say this as a professional programmer.
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 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
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.
deleted by creator
Engineer in uni vs engineering job?