cm0002Excel logic
NougatJanuary second for the Yanks.
What, Medium/Small/Large order seems off to you??
You're assuming that I'm not a Yank? Let me tell you, I can Yank with the best of them, and I do!
I usually do mine solitarily.
Usually.
I Cast FistSounds like you’re walking a metaphorical minefield
Occasionally, he does mine with others.
12/31/9999
I mean, that is the way you say it verbally.
1/2 - January second.
skulblakaLook 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.
No, you misunderstand. I’m in America. But ISO 8601 standard 4 Life!
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.
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
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.
What, Medium/Small/Large order seems off to you!?
ShayKStageEx-cell?
More like 44567
Best I can do is 7.45678e17
SmeeIs that like an error code for excel?
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 :)
You can make a date from a datetime in cell A1 with
=Date(year(A1), month(A1), day(A1))
it’s funny how you can tell at a glance exactly what AI model generated this image, just based off the background color
Well which one is this one? (This was a crosspost so I don’t know lmao)
The new one by openai, “gpt-4o image generation”
you
No I can’t. Have you considered you might be beyond normal smart about this stuff?
well it’s supposed to be the “passive” you (or “indeterminate”)
The old way of saying that is close to obsolete. One now must take it from context whether the “you” means you or one.
stebojust based off the background color
… white?
StellarSt0rmAlso why is the glass talking wtf?
There’s also some nasty artifacting around the lines, nat look like but not exactly JPEG.
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
Scientists rename human genes to stop Microsoft Excel from misreading them as dates
Scientists have renamed 27 human genes to stop Microsoft Excel misreading them as dates. The changes have been underway for the past year but have been formally announced as new guidelines published by the HUGO Gene Nomenclature Committee. Scientist are overjoyed but annoyed Microsoft didn’t make the changes itself.
Best thing is, they introduced some settings to turn that auto-conversion off and they don’t work 🤣 can’t make that stuff up.
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…
MM/DD/YYYY
DD/MM/YYYY
Both of these are the wrong way to format dates.
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”…
Who asked the glass?
the AI that generated the image!
oh cmon this is just a line drawing, surely no one asked an AI to create a line drawing right?
I actually have no idea, it just looks like an AI drawing to me. The fact that the glass is asking makes it a bit sus
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
maibe
in my experience, tineye doesn’t find any matches ever
It used to be good. Maybe it’s been enshitified. I couldn’t see the business model.
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, so tineye probably can’t compete with them and so can’t find any new images
MoonRavenHonestly, for a community (lemmy) that wanted to get away from corporate stuff (reddit) it pains me to see how even the most basic thing to draw is being delegated to Ai (corporations).
I’ve come to the conclusion in the last couple weeks I simply can’t identify AI images anymore. I have no clue what about this makes everyone call it out as AI, and there’s have been many such instances of this happening with me lately. I’m going to get modern day Nigerian princed when I’m older I can feel it in my bones
SqueakyBeaverMost of it for me is the font. It seems like chatgpt likes to use the same font for everything
It also kind of feels off somehow. I can’t explain. it, but there’s just something wrong with this image
cannedtunaI mean… for me it’s the “why the fuck is the glass talking?”
TheLowestStoneLeft guy has 1 arm. Both guys have an arm that melds into the surface that the glass is sitting on. The “optimist” is the glass.
Left guy has 1 arm.
Perspective.
Both guys have an arm that melds into the surface that the glass is sitting on.
Nah the arms are in front of the railing.
The “optimist” is the glass.
So what it’s visually balanced. I would shy away from reading surrealist meaning into it but it’s not like humans never make that kind of choice.
The plain fact of the matter is that nowadays it’s often simply impossible to tell, and the people who say “they can always tell” probably never even tried to draw hands or they could distinguish twelve-fingered monstrosities from an artist breaking their pencil in frustration and keeping the resulting line because it’s closer to passing than anything they ever drew before.
I agree that the “arm things” are wrong, as it’s pretty clearly just an artistic choice that a human could very much do.
But that said these images are 100% provable to be AI. If you haven’t built up the intuition that immediately tells you it’s AI (it’s fair, most people don’t have unlimited time for looking at AI images), these still have the trademark “subtle texture in flat colors” that basically never shows up in human-made digital art. The blacks aren’t actually perfectly black, but have random noise, and the background color isn’t perfectly uniform, but has random noise.
This is not visible to the human eye but it can be detected with tools, and it’s an artifact caused by how diffusion models work
Not using plain RGB black and white isn’t a new thing, neither is randomising. Digital artists might rather go with a uniform watercolour-like background to generate some framing instead of an actual full background but, meh. It’s not a smoking gun by far.
The one argument that does make me think this is AI was someone saying “Yeah the new ChatGPT tends to use that exact colour combination and font”. Could still be a human artist imitating ChatGPT but preponderance of evidence.
I can generally spot SD and SDXL generations but on the flipside I know what I’d need to do to obscure the fact that they were used. The main issue with the bulk AI generations I see floating around isn’t that they’re AI generated, it’s that they were generated by people with not even a hint of an artistic eye. Or vision.
But that doesn’t really matter in this case as this work isn’t about lines on screen, those are just a mechanism to convey a joke about Excel. Could have worked in textual format, the artistry likes with the idea, not in the drawing, or imitation thereof.
The thing missing here is ~~that usually when you do waatercolor, you want to make it visible. The AI ‘watercolor’ is usually extremely subtle, only affecting the 1-2 least significant bits of the color, to the point even with a massive contrast increase it’s hard to notice, and usually it varies pixel by pixel like I guess “white noise” instead of on a larger ~~scale like you’d expect from watercolor
Could potentially be a compression artefact but I freely admit I’m playing devil’s advocate right now. Do not go down that route we’d end up at function approximation with randomised methods and “well intelligence actually is just compression”.
I actually kind of looked at (jpeg) compression artifacts, and it’s indeed true to the extent that if you compress the image bad enough, it eventually makes it impossible to determine if the color was originally flat or not.
(eg. gif and dithering is a different matter, but it’s very rare these days and you can distinguish it from the “AI noise” by noticing that dithering forms “regular” patterns while “AI noise” is random)
Though from a few tests I did, compression only adds noise to comic style images near “complex geometry”, while removing noise in flat areas. This tracks with my rudimentary understanding of the discrete cosine tranform jpeg uses*, so any comic with a significantly large flat area is detectable as AI based on this method, assuming the compression quality setting is not unreasonably low
*(which should basically be a variant of the fourier transform)
I recreated most of the comic image by hand (using basic line and circle drawing tools, ha) and applied heavy compression. The flat areas remain perfectly flat (as you’d expect as a flat color is easier to compress)
But the AI image reveals a gradient that is invisible to the human eye (incidentally, the original comic does appear heavily jpeg’d, to the point I suspect it could actually be chatgpt adding artificial “fake compression artifacts” by mistake)
there’s also weird “painting” behind the texts which serves no purpose (and why would a human paint almost indistinguishable white on white for no reason?)
the new ai generated comic has less compression, so the noise is much more obvious. There’s still a lot of compression artifacts, but I think those artifacts are there because of the noise, as noise is almost by definition impossible to compress
Same here. I did not think twice about this picture or a few other posts in the past and yet there are pitchforks in the comments and I think to myself “What are you all on about?”. I rue how unrecognizable AI “slop” has gotten.
The reason this one is blatant AI is that the imagery doesn’t make any sense. Why is the glass of water itself the optimist?
I fed it into ChatGPT, highlighted the errors, and told it what I wanted to be different.
irelephant [he/him]🍭Still looks kinda soulless.