• SpaceNoodle@lemmy.world
    link
    fedilink
    English
    arrow-up
    80
    arrow-down
    1
    ·
    edit-2
    2 months ago

    I don’t see the problem. Sometimes it’ll be fifteen, and then it will be perfect every time. This saves the user literal hours of time poring over documentation and agonizing over which esoteric function to use, which far outweigh the few times this number will be nine.

  • shalafi@lemmy.world
    link
    fedilink
    English
    arrow-up
    74
    ·
    2 months ago

    Stunned that they’re fucking with their flagship Office product. Without Excel, everyone could simply drop Office.

    Been a sysadmin at small companies for 10 years, and that means I’m the one vetting and purchasing software. Last shop was all in on Google for Business and Google for auth. Worked pretty well, but accounting and HR still had to have Excel.

    It’s not even so much that other software can’t do simple Excel tasks, it’s the risk of your numbers getting lost in translation. In any case, nothing holds a candle to the power of Excel. And now they want to fuck with it?!

    • towerful@programming.dev
      link
      fedilink
      English
      arrow-up
      49
      ·
      2 months ago

      Excel is often used by people that don’t know what a database is, and you end up with thousands of rows of denormalised data just waiting for typos or extra white spaces to fuck up the precarious stack of macros and formulae. Never mind the update/insert anomalies and data corruption waiting to strike.

      I have a passionate hate for Excel, but I understand that not everyone is willing to learn more robust data processing

      • Cenzorrll@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        2 months ago

        It’s probably because Access fucking sucks, leaving excel as the only database adjacent program available to office workers. I would love to be able to use anything but excel on my projects. Hell, python and some CSVs would make my life so much easier, but I ain’t going through IT to let me have that, and it opens up a HUGE can of worms in my line of work if I start using homemade scripts. The execs can pay for a LIMS system if they want me more productive.

      • grue@lemmy.world
        link
        fedilink
        English
        arrow-up
        25
        arrow-down
        1
        ·
        edit-2
        2 months ago

        The precarious stack of macros and formulae that you also can’t version control properly because it’s a superficially-XML-ified memory dump, not textual source code.

        Almost every nontrivial use of Excel would be better off as, if not a database, at least something like a Jupyter notebook with pandas.

        • Cenzorrll@lemmy.world
          link
          fedilink
          English
          arrow-up
          2
          ·
          2 months ago

          I do bioanalysis without a sample management system. I recently had a 1000+ sample project with 6 analytes, all samples needing a few reanalyses due to everything in this whole project being complete shit.

          I spent probably three weeks of time just tracking samples to figure out what needed what analysis through excel. It’s so painful knowing that a proper python script could do it in a few seconds.

  • jjjalljs@ttrpg.network
    link
    fedilink
    English
    arrow-up
    60
    ·
    2 months ago

    Ed Zitron wrote an article a while ago about Business Idiots. From what I recall, the people in charge of these big companies are out of touch with users and the product, and so they make nonsense decisions. Companies aren’t run by the best and brightest. They’re run by people who do best in that environment.

    Microsoft seems to be full of business idiots.

  • Sceptiksky@leminal.space
    link
    fedilink
    English
    arrow-up
    9
    ·
    2 months ago

    I’m so happy to know world will crumble by LLM corpo bullshit rather than climate change. It looks MUCH more fun.

  • edgemaster72@lemmy.world
    link
    fedilink
    arrow-up
    27
    ·
    2 months ago

    Simple, 3+2 = 5. Add 1, which came before the 3 and 2, and you get 1 then 5, 15. It’s new new math, or as I will henceforth call it, mAIth.

  • elgordino@fedia.io
    link
    fedilink
    arrow-up
    12
    ·
    2 months ago

    One of the principal justifications for George Osborne’s 2010 austerity plans turned out to be erroneous thanks to an Excel error.

    That was without any help from AI, things could be about to get much worse.

  • jballs@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    135
    arrow-down
    1
    ·
    2 months ago

    Ok I see what happened here. You said the numbers “above” and it saw A in the column name. In hexadecimal that’s a 10. But you also said “numbers” plural, and “1” isn’t plural. So it took A + 2 + 3 = 15.

    Makes perfect sense, maybe just write better prompts next time. /s

    • bstix@feddit.dk
      link
      fedilink
      English
      arrow-up
      6
      ·
      2 months ago

      I doubt it. The column name isn’t part of the data.

      However “the numbers above” is data.

      3 letters + 7 letters + 5 letters= 15 letters.

      • Cethin@lemmy.zip
        link
        fedilink
        English
        arrow-up
        5
        ·
        2 months ago

        No it isn’t. The above is using logic, however bad it may be. LLMs are not. It’s just a statistical model. It doesn’t think.

      • ook@discuss.tchncs.de
        link
        fedilink
        English
        arrow-up
        19
        ·
        2 months ago

        Woah woah woah, stop it right there. I won’t stand for slander against actual search engines!

  • jsomae@lemmy.ml
    link
    fedilink
    English
    arrow-up
    12
    ·
    2 months ago

    on the one hand, obviously this is not the way you should be using that function. On the other hand, I’m not sure how you even should.