• kingthrillgore@lemmy.ml
    link
    fedilink
    English
    arrow-up
    8
    ·
    edit-2
    7 months ago

    Well if you’re trying to use Excel as a database, get them behind SQL Server or something. Hell, Access is a step up.

    Using Excel outside of simulation proofs is not a wise business decision, because it means (going off my experience) institutional knowledge

    • Aleric@lemmy.world
      link
      fedilink
      English
      arrow-up
      10
      ·
      7 months ago

      Indeed, I’m pushing for SQL but work in a field that sees Excel as a huge improvement over past practices. They’re about one step removed from writing on toilet paper.

      My original career was in a much more data intensive field, so I’ve become “that guy” regarding proper data storage and hygiene. Case in point: we sit directly next to IT. Every time we talk about data collection, I’ll get up on my SQL soap box and one of the IT folks will let out a comical groan.