• MxM111@kbin.social
    link
    fedilink
    arrow-up
    90
    arrow-down
    3
    ·
    9 months ago

    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.

    • Bloody Harry@feddit.de
      link
      fedilink
      English
      arrow-up
      37
      arrow-down
      1
      ·
      9 months 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)

      • Vash63@lemmy.world
        link
        fedilink
        English
        arrow-up
        34
        ·
        9 months 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)

      • acockworkorange@mander.xyz
        link
        fedilink
        English
        arrow-up
        27
        ·
        9 months ago

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

      • Harbinger01173430@lemmy.world
        link
        fedilink
        English
        arrow-up
        19
        ·
        edit-2
        9 months ago

        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

      • Moira_Mayhem@beehaw.org
        link
        fedilink
        English
        arrow-up
        8
        ·
        9 months 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.

    • TheOakTree@beehaw.org
      link
      fedilink
      English
      arrow-up
      5
      ·
      edit-2
      9 months ago

      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.

      • MxM111@kbin.social
        link
        fedilink
        arrow-up
        5
        ·
        9 months 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.

      • criticon@lemmy.ca
        link
        fedilink
        English
        arrow-up
        1
        ·
        9 months ago

        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)