Hacker News new | ask | show | jobs
by omarhaneef 1377 days ago
It’s 2022 and how come they don’t have GPT4 and some stable diffusion built in?
1 comments
armchairhacker 1377 days ago
seriously though, I think a copilot-like ML to improve flash fill is a genuinely amazing idea which could save insane hours, especially with people less familiar with complex formulas/coding
link
evandwight 1377 days ago
Someone just created that!

https://excelformulabot.com/

Apparently Microsoft is creating a plugin.

(Not affiliated)

link
armchairhacker 1376 days ago
Not quite what I meant. Basically you fill in some cells, and then expand the region and Excel will autofill. For example if you have

    Full Name        | Nickname
    Smith, John      | Johnny
    Ayers, Danielle  | Dani
    McDougle, Jack   | Jack
    Jason, Charles   |
    James, Trent     |
    Myers, Jessica   |
    David, Katherine |
And if you select the first 4 entries on the right and drag down, it will fill in the last 4.

This is known as flash fill and already implemented: https://support.microsoft.com/en-us/office/using-flash-fill-.... Except AFAIK it still uses hard-coded pattern recognition. This is exactly the type of thing ML is good for!

link
nl 1376 days ago
Google Sheets has this and it works really well.

I had an idea Excel had something as well but maybe not?

link