• Jo Miran@lemmy.ml
    link
    fedilink
    English
    arrow-up
    48
    ·
    1 year ago

    I will always appreciate a true Excel power user. I’ve seen some black magic shit.

    • Followupquestion@lemm.ee
      link
      fedilink
      English
      arrow-up
      6
      ·
      1 year ago

      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.

    • AggressivelyPassive@feddit.de
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      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.

  • MxM111@kbin.social
    link
    fedilink
    arrow-up
    42
    arrow-down
    2
    ·
    1 year 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
      16
      ·
      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)

      • acockworkorange@mander.xyz
        link
        fedilink
        English
        arrow-up
        13
        ·
        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.

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

    • TheOakTree@beehaw.org
      link
      fedilink
      English
      arrow-up
      5
      ·
      edit-2
      1 year 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
        ·
        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.

  • HootinNHollerin@slrpnk.net
    link
    fedilink
    English
    arrow-up
    29
    ·
    edit-2
    1 year ago

    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

    • mayooooo@beehaw.org
      link
      fedilink
      English
      arrow-up
      4
      ·
      1 year ago

      Yeah I wanted to comment on this too. It’s a win for ms against dassault every time

        • Atropos@lemmy.world
          link
          fedilink
          English
          arrow-up
          1
          ·
          1 year ago

          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.

    • BombOmOm@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 year ago

      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.

      • cyberfae@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 year ago

        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.

  • noctisatrae@beehaw.org
    link
    fedilink
    English
    arrow-up
    20
    ·
    1 year ago

    Solidworks, Matlab is not exactly what you call CHAD open-source tech as opposed to Python where you can get shit done with it.

  • SpaceCowboy@lemmy.ca
    link
    fedilink
    English
    arrow-up
    15
    arrow-down
    1
    ·
    1 year ago

    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.

    • SuperSpruce@lemmy.zip
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      No matter where you stand on your views of the ribbon, Microsoft introduced it in what, 2007? The patent is gonna expire soon.

  • OpenStars@startrek.website
    link
    fedilink
    English
    arrow-up
    8
    arrow-down
    1
    ·
    1 year ago

    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?:-)

  • Auzy@beehaw.org
    link
    fedilink
    English
    arrow-up
    8
    arrow-down
    1
    ·
    edit-2
    1 year ago

    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

    • smileyhead@discuss.tchncs.de
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      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.

    • hglman@lemmy.ml
      link
      fedilink
      English
      arrow-up
      5
      arrow-down
      2
      ·
      1 year ago

      If you dont understand why the specific instruction set you studied isnt the point you should maybe po back to school.

        • Auzy@beehaw.org
          link
          fedilink
          English
          arrow-up
          2
          arrow-down
          1
          ·
          edit-2
          1 year ago

          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)

      • Auzy@beehaw.org
        link
        fedilink
        English
        arrow-up
        2
        arrow-down
        2
        ·
        1 year ago

        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).

    • lichtmetzger@feddit.de
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      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.

  • Truck_kun@beehaw.org
    link
    fedilink
    English
    arrow-up
    6
    ·
    1 year ago

    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:

    https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439

    • Buttermilk@lemmy.ml
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      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