1507
You have 1 wish... (sh.itjust.works)
submitted 2 years ago by to c/memes@lemmy.ml
87 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 46 points 2 years ago (3 children)

This is basically what I run for a living and it's definitely not glamorous.

  • permalink
  • fedilink
  • source
  • hideshow 6 child comments
    •
  • [–] 37 points 2 years ago (1 child)

    Employers get what they demand, what they deserve. Anyway excel works as a database until around 1 million entries...

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 37 points 2 years ago

    Once you get to a million just start a new one and create a "master" spreadsheet that uses power query to append them all. Problem solved ;)

    Don't tell anyone but I actually do this.

  • permalink
  • fedilink
  • source
  • parent
  • [–] 11 points 2 years ago (1 child)

    I feel you. Working in healthcare, ms office is the only thing consistently installed site wide I can take advantage of to run a db.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 4 points 2 years ago (1 child)

    Couldn’t you use Access instead of Excel or is that not possible for your use case?

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 2 points 2 years ago

    Unfortunately IT blocked Access installs because some staff were using it for mission critical processes, and upon leaving IT were required to maintain them. They felt excel was less likely to lead to scenarios like this.

    Little did they know excel projects are probably worse to maintain.

  • permalink
  • fedilink
  • source
  • parent
  • [–] 8 points 2 years ago

    I work as a network tech for a globally spanning ISP specializing in fiber services, handling major maintenances that are service effecting for business and government customers (SLAs are in effect). These maintenances are planned and tracked through various excel sheets - housed either in a shared network drive (so yeah, we may run into issues where multiple people are trying to edit the same doc at once), or excel tables in a SharePoint.

    Prior to the merger of companies I recently went through, we had actual database systems to track this stuff that worked just fine. And now we're relying on the same shit a grad student would use to track their doctorate progress. It'll work until it doesn't. Looking forward to the shit-show if it gets me overtime.

  • permalink
  • fedilink
  • source
  • parent