• nerdschleife@lemm.ee
    link
    fedilink
    English
    arrow-up
    106
    arrow-down
    1
    ·
    edit-2
    11 months ago

    2013-2016 excel is GOATed tbh. Usable and without the cloud bullshit Microsoft tried to push in the coming years

    (Yes, I still wish this wasn’t the industry standard office suite)

    • MissJinx@lemmy.world
      link
      fedilink
      arrow-up
      23
      ·
      11 months ago

      I’ve worked for a company that used google instead of microsoft, man… that was hard. It’s not standard for nothing, it’s a lot better.

      • ManosTheHandsOfFate@lemmy.world
        link
        fedilink
        arrow-up
        17
        arrow-down
        2
        ·
        11 months ago

        My company used Google for a few years. Higher level Excel users hated Sheets and didn’t give up Excel. But for the rest of us riffraff Sheets was great. The collaboration features work really well, better than Office 360.

        • xpinchx@lemmy.world
          link
          fedilink
          arrow-up
          15
          arrow-down
          1
          ·
          11 months ago

          I’m one of the Excel guys, I live by tables, PowerQuery, VBA/UDFs, and loading data from APIs and SQL databases. If any of that functionality lives in Sheets I’ve never been able to figure it out productively.

          My last contract used Sheets and I felt like a toddler, it’s too different for my tastes.

      • rambos@lemm.ee
        link
        fedilink
        arrow-up
        19
        ·
        11 months ago

        Same here. Usually office 2007 + saveaspdf plugin + local language pack is my way to go, but recently started using only office and Im amazed how compatible it is, at least for my usage.

    • Shard@lemmy.world
      link
      fedilink
      arrow-up
      12
      ·
      11 months ago

      I work in Data centers. A few years back I saw a banking customer with a mainframe computer in their hall while we were upgrading the buildings cooling systems.

    • Hyggyldy@sffa.community
      link
      fedilink
      arrow-up
      10
      ·
      edit-2
      11 months ago

      It seems to be solid for making calculators. I’ve used a number of build optimizers for various games that are made in Excel.

      Edit: Actually I guess they’re Google Sheets. Idk how the feature sets compare.

  • VYTSKA@lemm.ee
    link
    fedilink
    arrow-up
    32
    ·
    11 months ago

    The amount of massive excel sheets I’ve seen in various departments, when I was working as an office IT was ridiculous.

    Some people had to wait for 30 seconds with every minor change and that was “normal”.

    Excel != Database

    • heird@lemmy.ml
      link
      fedilink
      arrow-up
      19
      ·
      11 months ago

      I’ve worked for a massive corporation in which they had 300mb+ excel files they bought high specs computers just to have them load fast enough and searching would take 3 to 5 minutes we suggested that they’d try moving it to Microsoft access and the query became instant, I can’t imagine the hours wasted waiting for the queries to run

      • Hamartiogonic@sopuli.xyz
        link
        fedilink
        arrow-up
        4
        ·
        11 months ago

        My rule of thumb when Excel is still just fine:

        1. The data fits on the screen. Roughly 40x30 matrices are fine. These rules aren’t set in stone, so there are situations when it’s still justified to use matrices larger than that.
        2. You can see all the sheets you need. Roughly 10-14 sheets. If you need more sheets than that, you should probably split the calculation into several files.
        3. You need complicated VBA macros and you need them to run perfectly every time. In my experience, this programming language is infuriatingly unpredictable and unreliable. Random things happen all the time and no amount of debugging is able to solve these types of cosmic problems.

        You can go beyond those general guidelines, but using everything gets more and more annoying the further you go. Pretty soon you’ll realize it would have been better to build the whole thing in Python, R or something else. Once the file size hits 15 MB you know you’ve gone way too far and it’s about time you rebuilt the whole calculation using some nicer tool. I try to switch as soon as possible when I realize my calculations are about to grow beyond these limits.

    • PerogiBoi@lemmy.ca
      link
      fedilink
      English
      arrow-up
      45
      ·
      11 months ago

      You would be honestly very uncomfortable if you knew how much sensitive information is stored on the desktop of someone as an excel spreadsheet.

      • xpinchx@lemmy.world
        link
        fedilink
        arrow-up
        5
        ·
        11 months ago

        True, I work in ecomm and we definitely have database exports being passed around relatively freely. No passwords obviously, but segmentation data, emails, addresses, phone numbers, etc.

        We have good IT security but it still doesn’t feel great.

  • driving_crooner@lemmy.eco.br
    link
    fedilink
    arrow-up
    29
    ·
    11 months ago

    I’m trying to move away and doing all I can with python (pandas, numpy and friends). Everything starts with a pd.read_excel() and finish with a df.to_excel().

  • gbuttersnaps@programming.dev
    link
    fedilink
    arrow-up
    18
    ·
    11 months ago

    Having worked for a state government which maintained data for federal submissions in 15 different versions of the same giant excel file on 15 different computers, it’s scary how accurate this is.

    • Gork@lemm.ee
      link
      fedilink
      arrow-up
      6
      ·
      11 months ago

      I’ve worked at private companies where this is the case too lol.

      This is true even when better software would work instead of the one-size-fits-all-but-isn’t-suitable Excel.

      Often to get it to work the way I want is through VBA scripting. And at that point I should be using other software but companies are cheap and don’t want to invest in better tech.