• Smee
        link
        fedilink
        42 months ago

        Is that like an error code for excel?

        • @[email protected]
          link
          fedilink
          32 months ago

          Nah just stupid number formatting, my UPCs regularly turn into scientific notation or my UOM automatically convert to a string =“12” which ruins math operations so first I have to make a helper column =NUMBERVALUE([@UOM]).

          Or being unable to convert datetime to a simple date for date calculations without loading the table into power query and transforming it there. You can change the format into short date but if the actual value is datetime it will still throw an error but now the type issue is hidden, so have fun reading docs and troubleshooting until you realize your mistake :)

    • @[email protected]
      link
      fedilink
      722 months ago

      Best thing is, they introduced some settings to turn that auto-conversion off and they don’t work 🤣 can’t make that stuff up.

      • Elvith Ma'for
        link
        fedilink
        312 months ago

        I mean, I know of a Microsoft product that allows for a batch import of data provided in an Excel file. You need to use their template file. Which, when used, automatically formats all dates the American way, ignoring your locale settings. Depending on which date is first encountered on import (e.g. which date you entered in the first line) then designates whether the whole file is imported with dates read as MM/DD/YYYY or DD/MM/YYYY.

        You start your list on January 1st? It will import everything as MM/DD/YYYY then. You start you list on e.g. January 22nd? DD/MM/YYYY it is then. Good luck getting that import running without errors…

      • @[email protected]
        link
        fedilink
        212 months ago

        Nothing works in Excel. Excel will do what it wants.

        But that doesn’t stop the MS support and a thousand stupid people from claiming “oh, you just have to format it as text, are you dumb or what”…

  • @[email protected]
    link
    fedilink
    45
    edit-2
    2 months ago

    it’s funny how you can tell at a glance exactly what model generated this image, just based off the background color

  • AItoothbrush
    link
    fedilink
    English
    302 months ago

    Someone explain to me why i have a sense for ai? This is like the fourth time this week i see an ai image and i spotted it even tho at first i hadnt seen the mistakes the ai made. Something just feels off in ai pictures and i cant really pin down what it is. But when i see one i can just spot it for some reason.

    • @[email protected]
      link
      fedilink
      12 months ago

      There’s also some artifacting around the lines that are reminiscent of JPEG, but not kind of that, and it seems like the text is superimposed onto it in a second or third pass by an external tool to make it look more consistent.

      • Elrecoal19
        link
        fedilink
        32 months ago

        The uncanny valley. It looks overall right, but some details don’t feel quite right even if you dln’t know which ones.

          • Elrecoal19
            link
            fedilink
            42 months ago

            Yeah, until you find what’s actually wrong, like the arms that fuse with the table, the talking glass, the almost identical faces, the glass being giantic, the backgroud colour, the specific artstyle (just like when AI made images that looked too shiny and shit, and it was obvious it was AI)…

    • Elrecoal19
      link
      fedilink
      18
      edit-2
      2 months ago

      Uncanny valley. The AI gets things right overall, but not enough that you don’t realize somerhing is wrong.

      For me it’s the arms being fused with the table,pessimist only having one arm, the faces that feel too generic/soulless (like, they barely change between pesimist and excel), the “optimist” being the glass and not another character…

      • AbsentBird
        link
        fedilink
        English
        92 months ago

        The glass is also weirdly large considering it looks like it should be at roughly the same distance as the people.

      • @[email protected]
        link
        fedilink
        English
        2
        edit-2
        2 months ago

        It’s become such a reliable tell that I’m genuinely curious why AI seems to think that cartoon images MUST look like they’re drawn on old paper.

        EDIT: The AI answer I got when asking Google was about what I’d expect, but this last bit I hadn’t considered:

        Sepia tones can help unify the color palette of an image, making it more visually cohesive and pleasing. This could be a factor in the AI’s decision to use sepia, as it can contribute to a sense of order and harmony in the generated image.

        So it uses it to try and make it more visually appealing to a wide audience, leading to it looking even more bland and uninspired.