It pains me to defend an AI feature, but this whole tweet is disingenuous and stupid. The documentation for =COPILOT() says a few things which are relevant to understand what we’re seeing here:
You’re not supposed to use it for math
It only has access to the parts of the spreadsheet you pass it as the second argument
In this case the user has not provided copilot any cells to look at, so they’re just asking what the typical answer on the Internet is for the request “sum the numbers above”. And the sum of numbers above things are apparently often 12.
Is the analogy like giving access to a nuclear reactor to users and giving them access to AI to help them run the nuclear plant by allowing the AI to give users the most common answers and responses into how to run a nuclear power plant.
People do all sorts of weird non-math stuff in Excel. The stated use-case for this feature is stuff that operates on text. Say for example you fill column A with quotes from your customers about your product. Then you can tell Copilot to provide a summary of each row in column B, and whether the sentiment is positive or negative in column C. You could aggregate the results as well.
There are better tools for that sort of thing, but a lot of people really love their Excel hammer, and they see nails everywhere.
True, I did forget that it might have been useful for me in one very specific instance where there was a comments section in one of our excel forms and I wanted to summarize the most common words mentioned in those comments. Couldn’t figure out how at the time but this could potentially have figured it out. Not sure I would trust the accuracy of it’s result though
It pains me to defend an AI feature, but this whole tweet is disingenuous and stupid. The documentation for
=COPILOT()says a few things which are relevant to understand what we’re seeing here:In this case the user has not provided copilot any cells to look at, so they’re just asking what the typical answer on the Internet is for the request “sum the numbers above”. And the sum of numbers above things are apparently often 12.
Keep in mind that if you allow a user to make this mistake, people will DEFINITELY make this mistake. A lot.
That is true for a lot of things, particularly every AI feature ever.
And if that’s true, just imagine something any more compex, that could get lost amid the rest of the slop for a long time
Is the analogy like giving access to a nuclear reactor to users and giving them access to AI to help them run the nuclear plant by allowing the AI to give users the most common answers and responses into how to run a nuclear power plant.
Every job is just some sort of troubleshooting, it just makes it harder to do when your manual is making stuff up
… You aren’t supposed to use it for math… In excel? What is the point?
People do all sorts of weird non-math stuff in Excel. The stated use-case for this feature is stuff that operates on text. Say for example you fill column A with quotes from your customers about your product. Then you can tell Copilot to provide a summary of each row in column B, and whether the sentiment is positive or negative in column C. You could aggregate the results as well.
There are better tools for that sort of thing, but a lot of people really love their Excel hammer, and they see nails everywhere.
True, I did forget that it might have been useful for me in one very specific instance where there was a comments section in one of our excel forms and I wanted to summarize the most common words mentioned in those comments. Couldn’t figure out how at the time but this could potentially have figured it out. Not sure I would trust the accuracy of it’s result though