this post was submitted on 27 Jan 2024
17 points (100.0% liked)

Science Memes

12384 readers
2767 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

  1. Don't throw mud. Behave like an intellectual and remember the human.
  2. Keep it rooted (on topic).
  3. No spam.
  4. 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

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago
MODERATORS
[email protected]
[email protected]
[email protected]
17
despite all my rage IT keeps me trapped like a rat in a cage. (mander.xyz)
submitted 1 year ago by [email protected] to c/[email protected]
188 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 0 points 1 year ago (4 children)

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.

[–] [email protected] 1 points 1 year ago

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)

[–] [email protected] 0 points 1 year ago

Matlab excels at dgls, Excel does math not. Newton method isn't it

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] [email protected] 0 points 1 year ago

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.

[–] [email protected] 0 points 1 year ago (5 children)

What does it do that LibreOffice Calc doesn't do?

[–] [email protected] 0 points 1 year ago

Does libre office do pivot charts?

[–] [email protected] 0 points 1 year ago

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.

[–] [email protected] 0 points 1 year ago* (last edited 1 year ago) (1 children)

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

[–] [email protected] 0 points 1 year ago (1 children)

Oh but excel does lag heavily with any table over a couple megabytes, of course that's only on my computer

[–] [email protected] 0 points 1 year ago

You probably have apple stuff or Intel or windows /s

[–] [email protected] 0 points 1 year ago

Almost nothing, considering Calc is a clone. I don't think people are excluding LibreOffice from the list of smooth brain apps.

[–] [email protected] 0 points 1 year ago

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)