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)
Kind of serious, the lack of smooth scrolling makes Calc really horrible to use on a touchpad or with large/differing sized cells (formatted sheets with headers and such)
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?
Smooth scrolling.
Kind of serious, the lack of smooth scrolling makes Calc really horrible to use on a touchpad or with large/differing sized cells (formatted sheets with headers and such)
Almost nothing, considering Calc is a clone. I don’t think people are excluding LibreOffice from the list of smooth brain apps.
Not lagging horribly with big tables after calculating a simple formula? That’s the only thing i can think of. Everything else is just very similar
Oh but excel does lag heavily with any table over a couple megabytes, of course that’s only on my computer
You probably have apple stuff or Intel or windows /s
Does libre office do pivot charts?
Matlab excels at dgls, Excel does math not. Newton method isn’t it