• @ChickenLadyLovesLife
      link
      English
      631 year ago

      I once looked through a textbook from my friend’s MBA course. The first thing I noticed was in a highlighted box in the chapter on business negotiating: “Your skill at negotiating will affect the outcome of the negotiations.”

      These are the people that make 10X what I make.

      • @grayman
        link
        201 year ago

        This is why I refuse to get an MBA. I already know my pants go on my legs. Thanks.

        • @Viking_Hippie
          link
          151 year ago

          taking notes On the legs, you say? Interesting…🤔

        • @ChickenLadyLovesLife
          link
          English
          81 year ago

          Your skill at putting on your pants will affect the outcome of the pants-on-putting operation.

        • @theuberwalrus
          link
          61 year ago

          I have an MBA and I can assure you, most are not young.

          • @[email protected]
            link
            fedilink
            21 year ago

            Depends. It’s a business here and there are lots of young people with MBAs and not enough experience to contextualise the things learned within the masters. I mean, some are even doing it post grad.

            From my past experience with these types of people, I have a very low opinion on young people with MBAs. Business degree holders who want a shortcut to the top.

            • @theuberwalrus
              link
              21 year ago

              My comment was mostly a self deprecating joke, denying the only neutral part of the statement. But you’re right, wide range of ages in any business program.

        • @ChickenLadyLovesLife
          link
          English
          51 year ago

          You’ve probably had the experience of sharing the highways there with Germans cutting through your country to get to Austria and forgetting they were not on the Autobahn any more. I drove a rental car when I visited there years ago, and I’ve never had a more terrifying driving experience than looking in my rearview mirror and seeing empty road stretching back for miles, and two seconds later having a black BMW riding my ass and flashing its high beams at me.

      • 10EXP
        link
        fedilink
        English
        91 year ago

        Are you sure that wasn’t the introduction to the Speech skill in Skyrim?

    • @iamnotdave
      link
      101 year ago

      I learned this in my first statics class, and I have a BS in business administration.

  • @ocassionallyaduck
    link
    821 year 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.

    • @[email protected]
      link
      fedilink
      10
      edit-2
      1 year 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.

      • @Leviathan
        link
        51 year ago

        What’s the typeface? I’m sorry, I know nothing.

        • @[email protected]
          link
          fedilink
          21 year ago

          I used to make a monthly document that was in English and Japanese. I used either Meiryo or Meiryo UI. That looked ok in both scripts but there is another font where the en looks shit. Or maybe I’m thinking of full width characters.

  • @[email protected]
    link
    fedilink
    48
    edit-2
    1 year 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.

    • @[email protected]
      link
      fedilink
      101 year ago

      I only ever encountered Access was once many years ago and I was warned that it had issues with multiple users.

      • @[email protected]
        link
        fedilink
        171 year ago

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

        • @[email protected]
          link
          fedilink
          61 year ago

          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.

          • @[email protected]
            link
            fedilink
            31 year 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.

            • @[email protected]
              link
              fedilink
              41 year 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_
      link
      3
      edit-2
      1 year 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

      • JackbyDev
        link
        fedilink
        English
        111 year 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.

      • @[email protected]
        link
        fedilink
        101 year 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.

      • @[email protected]
        link
        fedilink
        61 year 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.

    • @blackbirdbiryani
      link
      11 year ago

      No simple way to join tables though, which is still pretty shocking to me.

  • TacoButtPlug
    link
    fedilink
    English
    461 year ago

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

    • @eslaf
      link
      371 year ago

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

      • @xpinchx
        link
        381 year 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.

    • @[email protected]
      link
      fedilink
      111 year ago

      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.

      • qaz
        link
        41 year ago

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

        • @[email protected]
          link
          fedilink
          21 year 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.

    • @Confused_Emus
      link
      English
      81 year 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.

  • @thantik
    link
    English
    311 year ago

    Anyone else use Microsoft Access…30 years ago?

  • @[email protected]
    link
    fedilink
    English
    221 year ago

    Should’ve been the version saying:

    Geanie: “It is done”

    Person: “But… nothing changed”

    G: “Correct”

    • @[email protected]
      link
      fedilink
      71 year 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!

    • @NedDasty
      link
      31 year ago

      CSV is great but the byte loss on numbers is sometimes gruesome.

  • @[email protected]
    link
    fedilink
    131 year 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.

    • @Blank
      link
      81 year ago

      Even Genie have standards.

  • @AnUnusualRelic
    link
    English
    131 year 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.”

  • Max_Power
    link
    fedilink
    English
    13
    edit-2
    1 year ago

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

      • @protput
        link
        71 year ago

        That would be something I could google. So not completely useless.

        • qaz
          link
          11 year ago

          How about “An error message on my screen”?

  • @[email protected]
    link
    fedilink
    9
    edit-2
    1 year ago

    Honestly, since the introduction of ‘tables’, pivot tables, Power Pivot and Power Query, Excel is way more viable to be used as a database. Tables in particular mean that formulas fill down and the range automically resizes when records are added.

    • @droans
      link
      41 year ago

      Iirc tables are actually treated similar to databases on the backend.

  • @joneskind
    link
    81 year ago

    My old ass crying in MS Access

    • @iwasgodonce
      link
      21 year 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.

  • asudox
    link
    81 year ago

    Kind of related question: Is it okay for me to use JSON as a small DB? I just store basic blog page data there.

    • @[email protected]
      link
      fedilink
      101 year ago

      I mean it will work, but for a blog I’d store the pages in markdown files, to make it easier to edit. For context, look into how Hugo works

      • asudox
        link
        31 year ago

        I thought of that as well. I might switch to that. It will make the organization better anyways.

    • @[email protected]
      link
      fedilink
      English
      41 year ago

      TinyDB literally does this. in general its more of does this work for my use case and am i aware of its limitations.

    • @[email protected]
      link
      fedilink
      4
      edit-2
      1 year ago

      A few circumstances to consider…

      If it’s just your own little tool and you don’t intend to share it with others: do whatever you want. SQL or NoSQL or JSON, it doesn’t matter. Use your own judgement.

      In my experience tho most homegrown JSON-based “databases” tend to load all data into the memory, simply because they are very simplistic (serialize everything into JSON and write to disk, deserialize everything into a struct). If your dataset is too big for that, just go straight for a full-fledged database.

    • Drew
      link
      fedilink
      21 year ago

      yep, though IO might bottleneck you at some point, and then you can happily switch to mongoDB