Johannes!
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
cm0002@lemmy.world to Programmer Humor@programming.dev · 2 months ago

Excel logic

lemmy.ml

external-link
message-square
138
fedilink
  • cross-posted to:
  • programmerhumor@lemmy.ml
1
external-link

Excel logic

lemmy.ml

cm0002@lemmy.world to Programmer Humor@programming.dev · 2 months ago
message-square
138
fedilink
  • cross-posted to:
  • programmerhumor@lemmy.ml
alert-triangle
You must log in or # to comment.
  • Jankatarch@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    I can sense AI now.

  • HugeNerd@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    Pessimist has only one arm

  • InputZero@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    The engineer: The glass is two times bigger than it needs to be.

  • SplashJackson@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    More like 44567

    • xpinchx@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Best I can do is 7.45678e17

      • Smee@poeng.link
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        Is that like an error code for excel?

        • xpinchx@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          2 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 :)

          • psud@aussie.zone
            link
            fedilink
            English
            arrow-up
            0
            ·
            2 months ago

            You can make a date from a datetime in cell A1 with

            =Date(year(A1), month(A1), day(A1))

  • sbv@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Who asked the glass?

    • piefood@piefed.social
      link
      fedilink
      English
      arrow-up
      0
      ·
      2 months ago

      the AI that generated the image!

      • stebo@lemmy.dbzer0.com
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        oh cmon this is just a line drawing, surely no one asked an AI to create a line drawing right?

        • brbposting@sh.itjust.works
          link
          fedilink
          English
          arrow-up
          0
          ·
          2 months ago

          maibe

          • stebo@lemmy.dbzer0.com
            link
            fedilink
            arrow-up
            0
            ·
            2 months ago

            in my experience, tineye doesn’t find any matches ever

            • Knock_Knock_Lemmy_In@lemmy.world
              link
              fedilink
              arrow-up
              0
              ·
              2 months ago

              It used to be good. Maybe it’s been enshitified. I couldn’t see the business model.

              • sus@programming.dev
                link
                fedilink
                arrow-up
                0
                ·
                edit-2
                2 months ago

                I also noticed how it suddenly went from great to crap.

                But the real reason I think is ironically AI. It used to be that you could easily crawl the web, but after the AI craze, images suddenly became valuable to crawl and every website gets bombarded by scrapers, and are adding more and more countermeasures to make it more difficult, so tineye’s own image scraper probably can’t compete with them and so can’t find any new images

        • piefood@piefed.social
          link
          fedilink
          English
          arrow-up
          0
          ·
          edit-2
          2 months ago

          I actually have no idea, it just looks like an AI drawing to me. The fact that the glass is answering makes it a bit sus

          • stebo@lemmy.dbzer0.com
            link
            fedilink
            arrow-up
            0
            ·
            2 months ago

            yeah I agree there’s a lot of things off, like the glass speaking, it being way too big and the inconsistency in the way the people are drawn

  • sus@programming.dev
    link
    fedilink
    arrow-up
    0
    ·
    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

    • Smee@poeng.link
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      you

      No I can’t. Have you considered you might be beyond normal smart about this stuff?

      • psud@aussie.zone
        link
        fedilink
        English
        arrow-up
        0
        ·
        2 months ago

        The old way of saying that is close to obsolete. One now must take it from context whether the “you” means you or one.

      • sus@programming.dev
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        2 months ago

        well it’s supposed to be the “passive” you (or “indeterminate” you)

        but I think anyone can learn to notice the pattern of comics with this particular odd color style (assuming you would want to learn it for some reason, and if we ignore color blindness or other similar problems etc)

    • stebo@lemmy.dbzer0.com
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      just based off the background color

      … white?

      • sus@programming.dev
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        2 months ago

        technically I guess it’s between Cosmic latte and Desert sand

        or “light grayish yellow”

        …I had to look those up but it’s definitely not a plain white

    • StellarSt0rm@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Also why is the glass talking wtf?

    • cm0002@lemmy.worldOP
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Well which one is this one? (This was a crosspost so I don’t know lmao)

      • sus@programming.dev
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        The new one by openai, “gpt-4o image generation”

  • wise_pancake@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    Yesterday I laughed at this, today Excel stripped leading zeros from a sheet of UPCs and converted them to floating point.

    Also format as Text apparently means nothing

  • BigMikeInAustin@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Scientists rename human genes to stop Microsoft Excel from misreading them as dates

    Sometimes it’s easier to rewrite genetics than update Excel

    Aug 6, 2020

    https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates

    • wischi@programming.dev
      link
      fedilink
      arrow-up
      0
      ·
      2 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@feddit.org
        link
        fedilink
        arrow-up
        0
        ·
        2 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…

        • CeeBee_Eh@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          2 months ago

          MM/DD/YYYY

          DD/MM/YYYY

          Both of these are the wrong way to format dates.

      • mmddmm@lemm.ee
        link
        fedilink
        arrow-up
        0
        ·
        2 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”…

  • Feathercrown@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    I admire that glass’s self confidence

  • Nougat@fedia.io
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    January second for the Yanks.

    • Empricorn@feddit.nl
      link
      fedilink
      English
      arrow-up
      0
      ·
      2 months ago

      What, Medium/Small/Large order seems off to you??

      • skulblaka@sh.itjust.works
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        Look bud, you can’t call it “February second” in conversation, write it down as “Second February” in writing, and then get mad at us Yanks about it. Pick a lane.

        • Empricorn@feddit.nl
          link
          fedilink
          English
          arrow-up
          0
          ·
          2 months ago

          No, you misunderstand. I’m in America. But ISO 8601 standard 4 Life!

      • Nougat@fedia.io
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        You’re assuming that I’m not a Yank? Let me tell you, I can Yank with the best of them, and I do!

        • ZoopZeZoop@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          2 months ago

          I usually do mine solitarily.

          • Nougat@fedia.io
            link
            fedilink
            arrow-up
            0
            ·
            2 months ago

            Usually.

          • I Cast Fist@programming.dev
            link
            fedilink
            arrow-up
            0
            ·
            2 months ago

            Sounds like you’re walking a metaphorical minefield

            • Nougat@fedia.io
              link
              fedilink
              arrow-up
              0
              ·
              2 months ago

              Occasionally, he does mine with others.

      • Peffse@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        2 months ago

        12/31/9999

    • Dicska@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Oh, so THAT’S why they brought Excel into this! I didn’t make the connection and just thought Excel would even consider a glass of water a date.

      • psud@aussie.zone
        link
        fedilink
        English
        arrow-up
        0
        ·
        2 months ago

        A human artist might have said “1/2 full” instead of “half full” but LLMs don’t understand jokes so there’s no hope they’ll be able to make the joke easier

        • petrol_sniff_king@lemmy.blahaj.zone
          link
          fedilink
          arrow-up
          0
          ·
          2 months ago

          Oh my god.

          Jesus christ.

          I was thinking, “nah, that seems nitpicky, I’m sure a real person could write either.” But that is the entire setup for the punchline. I’m gonna rip my hair out.

  • LeninsOvaries@lemmy.cafe
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Ban slop!

    • Jankatarch@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Are you talking about AI or excel?

  • AItoothbrush@lemmy.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 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.

    • guywithoutaname@lemm.ee
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      I noticed that the new image model doesn’t like pure white backgrounds.

      • samus12345@lemm.ee
        link
        fedilink
        English
        arrow-up
        0
        ·
        2 months ago

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

    • zarkanian@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      How do you determine that something is AI?

      • elrecoal19_1@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        1 month ago

        deleted by creator

        • zarkanian@sh.itjust.works
          link
          fedilink
          arrow-up
          0
          ·
          2 months ago

          So, vibes basically.

          • elrecoal19_1@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            edit-2
            1 month ago

            deleted by creator

    • elrecoal19_1@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      edit-2
      1 month ago

      deleted by creator

      • AbsentBird@lemm.ee
        link
        fedilink
        English
        arrow-up
        0
        ·
        2 months ago

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

        • T156@lemmy.world
          link
          fedilink
          English
          arrow-up
          0
          ·
          2 months ago

          The glass is also speaking, as opposed to a third person.

  • Cyrus Draegur@lemm.ee
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Why the fuck is the glass talking

    • dependencyinjection@discuss.tchncs.de
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Freedom of speech I assume.

  • linuxgator@lemmynsfw.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Or Jan-2

    • MrScottyTay@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      0
      ·
      2 months ago

      Ew

  • uis@lemm.ee
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    The glass is half foal.

    • I Cast Fist@programming.dev
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Hard to belle-ieve

Programmer Humor@programming.dev

programmer_humor@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmer_humor@programming.dev

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

  • Keep content in english
  • No advertisements
  • Posts must be related to programming or programmer topics
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 88 users / day
  • 555 users / week
  • 1.62K users / month
  • 4.12K users / 6 months
  • 0 local subscribers
  • 24.1K subscribers
  • 973 Posts
  • 18.4K Comments
  • Modlog
  • mods:
  • adr1an@programming.dev
  • Feyter@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • BE: 0.19.8
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org