Comment on I try to spice it up with some VB Macros but it's still ultimately just a spreadsheet.

• EditsHisComments@lemmy.world ⁨1⁩ ⁨day⁩ ago

  Hopefully you utilize Python instead of Excel for data management. Unless you have non-engineers or tech-illiterate people on your team or adjacent teams lol

  source

  • ViatorOmnium@piefed.social ⁨1⁩ ⁨day⁩ ago

    Why not both. I once wrote an abomination that read and wrote data into a Google Spreadsheet, interacting with formulas in the spreadsheet in the process.

    source

    • prex@aussie.zone ⁨16⁩ ⁨hours⁩ ago

      Image

      source
    • iii@mander.xyz ⁨22⁩ ⁨hours⁩ ago

      I hope there’s a place worse than hell

      source
    • EditsHisComments@lemmy.world ⁨1⁩ ⁨day⁩ ago

      Jesus Christ

      source
    • virku@lemmy.world ⁨1⁩ ⁨day⁩ ago

      Oh Lord. Before I found power bi 15 or so years ago I made interactive speeadsheets that did a lot of querying directly towards sql based on a set of input cells. Did a lot of crunching on the data merging data fetched from different database etc before presenting them in their own sheets. The worst part is that it was a huge leap from what we did earlier. Then I would write sql queries and dump the result to Excel every time management needed data.

      source
  • virku@lemmy.world ⁨1⁩ ⁨day⁩ ago

    I mostly use sql for data management stuff through c# .NET. But there is a lot of Excel and power bi towards the numbers people.

    source