• 0 Posts
  • 20 Comments
Joined 3 years ago
cake
Cake day: October 1st, 2023

help-circle




  • Excel sees the cells you tell it to operate on. When you’re working with code, all the code is relevant. Usually in Excel, you have specific cells you want to do an operation on, and those are provided to the function, just like any other thing you do in Excel. If you want to operate on the entire spreadsheet, just provide a range including the entire spreadsheet, but this is not done unless you ask for it.





  • 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.



  • bus_factor@lemmy.worldtoMemes@sopuli.xyzVery normal and safe
    link
    fedilink
    arrow-up
    28
    arrow-down
    3
    ·
    edit-2
    3 days ago

    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 15.



  • Oh, you definitely wonder how long you can keep up with the corpo bullshit, but that wasn’t the vibe I was getting from the first panel. That was giving me more of a “junior engineer who can’t get something to work” vibe.

    I’ve traded half my pay for more fulfilling work and less corpo bullshit before, but I didn’t quit engineering. I see some people dreaming about leaving it all behind and buying a farm, but what they all had in common was zero farming experience. The grass is always greener and all that.


  • I’ve never hired a software consultant, but most of the time when I hire a company or person to do contract work like roofing, gardening or similar they prefer to be paid by check. Sometimes they accept credit cards, but usually not when the bill is over a certain amount, due to the cut going to the card company.

    Furthermore, “Direct Deposit” is basically a special term used for people getting their wages or salary paid to their bank account, as opposed to receiving it by check or cash. Other types of bank-to-bank transfers have different names, like “wire transfer” or “ACH transfer”.

    Americans love overcomplicating things in general, and particularly love using overly specific and technical names for stuff. There’s acronyms everywhere, and things are named after weird technicalities. Like nobody says “retirement account”, they call it “401(k)”, named after the paragraph in the law which defines it.

    You find stuff like that everywhere if you look. Some of their coins don’t even have a value printed on them, you just have to memorize how much they’re worth.