• @ocassionallyaduck@lemmy.world
    link
    fedilink
    582 years ago

    Japanese companies, this isn’t a wish, it’s a fundamental truth of the universe. Like gravity. No matter the scale or importance of them. I promise you your car exists because of an Excel 2003 file on some underpaid engineer’s laptop that they periodically sync with an inventory system.

    • @Getawombatupya@aussie.zone
      link
      fedilink
      8
      edit-2
      2 years ago

      I once worked for a Japanese company where I had to make a presentation. In Excel, I shit you not. Then we had one of our “shadow” managers make a Japanese translation of the same thing. It took me two days to get the kerning and print layout right, especially with that weird english typeface that is Japanese standard, I hate to think how long the translator took to get their version right.

  • TacoButtPlug
    link
    fedilink
    English
    382 years ago

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

    • @eslaf@lemmy.world
      link
      fedilink
      312 years ago

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

      • @xpinchx@lemmy.world
        link
        fedilink
        252 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.

    • @Confused_Emus@lemmy.world
      link
      fedilink
      English
      72 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.

      • qaz
        link
        fedilink
        42 years ago

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

        • 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.

  • @ZC3rr0r@lemmy.ca
    link
    fedilink
    24
    edit-2
    2 years ago

    Microsoft spent years and years trying to get people to not use Excel as a database, until they eventually had to give up hope that anyone who doesn’t know the difference would voluntarily use Access, so they started adding database-like functionality to Excel to meet their customer’s demands and try to make the experience at least a little bit less painful.

    This is a real-life case of “meet the user where they are” despite the designer’s wishes, because even within Microsoft, there is strong agreement on not using Excel as a DB.

      • @ZC3rr0r@lemmy.ca
        link
        fedilink
        102 years ago

        Well, to be fair to Access, it’s not like Excel is such a great multi-user database either, now is it? ;-)

        • Well excel nowadays doesn’t have issues with concurrent users if you have office 365 like many companies do.

          At that time it was Access with the files located at a company shared drive, the issue was concurrent writes I believe.

          • @ZC3rr0r@lemmy.ca
            link
            fedilink
            32 years ago

            Yes, but at the time Excel didn’t support concurrency either ;-)

            Anyway, you are correct about the issue with concurrent writes, but that’s only because Access was intended as a single user DB. If you wanted a multi-user DB you should be getting MS SQL server.

            Not saying this product strategy worked (it clearly didn’t, otherwise people would not be using Excel), but that’s how they envisioned it to work.

          • @filcuk@lemmy.zip
            link
            fedilink
            22 years ago

            Better yet, put your access backend to OneDrive to acquire an un-openable, un-deletable file.

            • @ZC3rr0r@lemmy.ca
              link
              fedilink
              42 years ago

              I actually ran this setup for a pretty long while without major issues. YMMV but OneDrive is not a terrible way to store a single user database backend if you don’t have a lot of sequential writes going into it in a short timespan.

    • @_number8_@lemmy.world
      link
      fedilink
      3
      edit-2
      2 years ago

      i…isn’t that the entire point of excel? what is it for if not to store data?

      similarly i remember a reddit comment that broke my brain, saying no one should be using excel, they should be using a ‘cell matrix organizer’ or similar. we all can name 5 off the top of our heads

      • @frezik@midwest.social
        link
        fedilink
        102 years ago

        Excel has a purpose, but storing data long term isn’t it. It’s for calculating data. It shouldn’t be the single source of truth.

        One of the things Microsoft did to make it work was extending the row limit from 65k to 1M. Apparently, Economics professors were very excited about that one, which explains a lot.

      • JackbyDev
        link
        fedilink
        English
        102 years ago

        Excel is this weird mix of storing small amounts of data but so good for visualizing data. If people are saying it shouldn’t be used to store data they mean massive amounts of data as opposed to something like some small scale accounting for a fund raiser.

      • @ZC3rr0r@lemmy.ca
        link
        fedilink
        62 years ago

        Storing data is only one of the parts to the formula of what makes a database. Proper databases require structured storage of the data and some way to query the data constructively. Excel did not have those features until Microsoft gave up trying to convince people to not use it as a DB and added it to Excel.

    • @SpaceCowboy@lemmy.ca
      link
      fedilink
      72 years ago

      I mean it’s a simple file format so it’ll perform better because it doesn’t have to decode any complex formats or protocols.

      Big O? Never heard of it!

  • @NotBadAndYou@ttrpg.network
    link
    fedilink
    112 years ago

    Isn’t the Genie usually depicted as malicious, or at least mischievous? I would expect the Genie to grant the wish, knowing what a shitshow it would be.

  • Max_Power
    link
    fedilink
    English
    10
    edit-2
    2 years ago

    My 5th rule would be “no ‘fix my IT problem without me telling you what the error message says’”. Because fuck that

  • @AnUnusualRelic@lemmy.world
    link
    fedilink
    English
    92 years ago

    “I have to make a brochure for the printing shop and I’d like to compose it in Excel”

    “There are actually five rules…”

    “In Powerpoint?”

    “Make that six.”

    • @xuniL@lemmy.dbzer0.com
      link
      fedilink
      122 years ago

      Except PowerPoint is actually quite nice to make quick, easy and good looking visualizations and brochures without having to deal with Word

      • @Car@lemmy.dbzer0.com
        link
        fedilink
        5
        edit-2
        2 years ago

        I can personally attest to entire universities advocating for student use of powerpoint for all sorts of printshop work to include thesis and capstone presentation posters for conferences :)

        For people who don’t want to spend time learning yet another single-purpose application, it works quite well

    • @iwasgodonce@lemmy.world
      link
      fedilink
      22 years ago

      one of our partners we have to integrate with at work sends us reports in ms access format. it’s not fun, especially when everything is running in lambda and there doesn’t seem to be any good libraries for reading ms access files that would easily run in lambda.

  • @betamark@lemmy.world
    link
    fedilink
    52 years ago

    I imagine an alternate 4th panel wherein the genie says “ok you can bring back dead people.” What do yall think? Also I bet we could come up with a themed genie or setting that would punch up the joke too. ♡♡ love it BTW, op.