Microsoft boffins contemplate equipping Excel with AI
(2023/02/04)
- Reference: 1675477750
- News link: https://www.theregister.co.uk/2023/02/04/microsoft_excel_ai/
- Source link:
Sooner or later, everything ends up in Microsoft Excel.
The 37-year-old spreadsheet has been used to run [1]Doom and [2]Pac-Man , [3]stop-motion animation , a turn-based [4]role playing game , [5]chess , and [6]a neural network , among other things.
Excel's latest trick comes courtesy of Microsoft's own software developers: "FLAME: A small language model for spreadsheet formulas."
[7]
It's detailed in [8]a preprint paper from Microsoft researchers Harshit Joshi, Abishai Ebenezer, José Cambronero, Sumit Gulwani, Aditya Kanade, Vu Le, Ivan Radiček, and Gust Verbruggen. The paper describes an assistive AI system called FLAME. It's a small language model that can improve the creation and maintenance of Excel formulas.
[9]
[10]
Large language models like OpenAI's ChatGPT are [11]all the rage at the moment. These are statistical models trained on vast amounts of text that can predict a likely output based on a text prompt input.
The problem with large language models is that they're, well, large – training requires lots of input data and money, and using the resulting model for inference also demands a lot of hardware. For example, the researchers cite Incoder 6.7B, a model trained for code infilling on 159GB of source code over a period of 24 days with 248 Nvidia V100 GPUs.
[12]
Lambda Labs has [13]estimated the cost to train GPT-3, a 175B parameter model, comes to about $4.6 million using Tesla V100 instances.
Weighing in at a mere 60M parameters, FLAME is "the first language model designed exclusively for Excel formulas." While the research paper does not explicitly state that FLAME is an acronym representing "First LAnguage Model for Excel," we speculate that this is the case.
[14]Microsoft to offer ChatGPT-as-a-service from Azure real soon now
[15]Microsoft injects AI into Teams so no one will ever forget what the meeting decided
[16]GPT-4 could pop up in Bing, as Google races to build chatbot search products
[17]It's your human hubris holding back AI acceptance
Despite its modest size, FLAME manages to outperform much larger models tuned for completing lines of code (code infilling), including CodeT5 (220M), Codex-Cushman (12B), and Codex-Davinci (175B).
FLAME is designed to autocomplete Excel formulas or repair malformed ones, and to handle syntax reconstruction, a technique for stripping delimiters (eg, curly braces) out of a formula so models can more easily recognize and reconstruct the full formula.
So in some future version of Excel, once FLAME has been wired into the software, entering a buggy formula like this… =IF('Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2="", yes, no)
…could end up looking like this with the help of FLAME's corrective ability. =IF(AND('Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2=""), "yes", "no")
And being able to do so with two orders of magnitude less training data than Codex or other large language models means Microsoft should find FLAME much more affordable to deploy when it's ready.
For those who have to maintain large spreadsheets with lots of formulas, your humble vulture has to say, FLAME looks pretty cool. ®
Get our [18]Tech Resources
[1] https://www.youtube.com/watch?v=J2qU7t6Jmfw
[2] https://github.com/spences10/pacellman
[3] https://www.youtube.com/watch?v=Fq9EV2fYF2E
[4] https://arenaxlsm.fandom.com/wiki/Arena.Xlsm_Wiki
[5] https://www.tabellenexperte.de/excel-fuer-kreative-die-unizeichen-funktion/
[6] https://www.youtube.com/watch?v=GvCxv6SzqF8
[7] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[8] https://arxiv.org/abs/2301.13779
[9] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[10] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[11] https://www.theregister.com/2023/02/03/chatgpt_most_popular_apps/
[12] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[13] https://lambdalabs.com/blog/demystifying-gpt-3
[14] https://www.theregister.com/2023/01/17/azure_openai_chatgpt/
[15] https://www.theregister.com/2023/02/02/microsoft_teams_premium_ai/
[16] https://www.theregister.com/2023/02/02/microsoft_gpt4_google_search/
[17] https://www.theregister.com/2023/02/03/human_hubris_may_prevent_people/
[18] https://whitepapers.theregister.com/
The 37-year-old spreadsheet has been used to run [1]Doom and [2]Pac-Man , [3]stop-motion animation , a turn-based [4]role playing game , [5]chess , and [6]a neural network , among other things.
Excel's latest trick comes courtesy of Microsoft's own software developers: "FLAME: A small language model for spreadsheet formulas."
[7]
It's detailed in [8]a preprint paper from Microsoft researchers Harshit Joshi, Abishai Ebenezer, José Cambronero, Sumit Gulwani, Aditya Kanade, Vu Le, Ivan Radiček, and Gust Verbruggen. The paper describes an assistive AI system called FLAME. It's a small language model that can improve the creation and maintenance of Excel formulas.
[9]
[10]
Large language models like OpenAI's ChatGPT are [11]all the rage at the moment. These are statistical models trained on vast amounts of text that can predict a likely output based on a text prompt input.
The problem with large language models is that they're, well, large – training requires lots of input data and money, and using the resulting model for inference also demands a lot of hardware. For example, the researchers cite Incoder 6.7B, a model trained for code infilling on 159GB of source code over a period of 24 days with 248 Nvidia V100 GPUs.
[12]
Lambda Labs has [13]estimated the cost to train GPT-3, a 175B parameter model, comes to about $4.6 million using Tesla V100 instances.
Weighing in at a mere 60M parameters, FLAME is "the first language model designed exclusively for Excel formulas." While the research paper does not explicitly state that FLAME is an acronym representing "First LAnguage Model for Excel," we speculate that this is the case.
[14]Microsoft to offer ChatGPT-as-a-service from Azure real soon now
[15]Microsoft injects AI into Teams so no one will ever forget what the meeting decided
[16]GPT-4 could pop up in Bing, as Google races to build chatbot search products
[17]It's your human hubris holding back AI acceptance
Despite its modest size, FLAME manages to outperform much larger models tuned for completing lines of code (code infilling), including CodeT5 (220M), Codex-Cushman (12B), and Codex-Davinci (175B).
FLAME is designed to autocomplete Excel formulas or repair malformed ones, and to handle syntax reconstruction, a technique for stripping delimiters (eg, curly braces) out of a formula so models can more easily recognize and reconstruct the full formula.
So in some future version of Excel, once FLAME has been wired into the software, entering a buggy formula like this… =IF('Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2="", yes, no)
…could end up looking like this with the help of FLAME's corrective ability. =IF(AND('Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2=""), "yes", "no")
And being able to do so with two orders of magnitude less training data than Codex or other large language models means Microsoft should find FLAME much more affordable to deploy when it's ready.
For those who have to maintain large spreadsheets with lots of formulas, your humble vulture has to say, FLAME looks pretty cool. ®
Get our [18]Tech Resources
[1] https://www.youtube.com/watch?v=J2qU7t6Jmfw
[2] https://github.com/spences10/pacellman
[3] https://www.youtube.com/watch?v=Fq9EV2fYF2E
[4] https://arenaxlsm.fandom.com/wiki/Arena.Xlsm_Wiki
[5] https://www.tabellenexperte.de/excel-fuer-kreative-die-unizeichen-funktion/
[6] https://www.youtube.com/watch?v=GvCxv6SzqF8
[7] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[8] https://arxiv.org/abs/2301.13779
[9] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[10] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[11] https://www.theregister.com/2023/02/03/chatgpt_most_popular_apps/
[12] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/aiml&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Y93mcYyvsElKGuObagds3AAAAFE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[13] https://lambdalabs.com/blog/demystifying-gpt-3
[14] https://www.theregister.com/2023/01/17/azure_openai_chatgpt/
[15] https://www.theregister.com/2023/02/02/microsoft_teams_premium_ai/
[16] https://www.theregister.com/2023/02/02/microsoft_gpt4_google_search/
[17] https://www.theregister.com/2023/02/03/human_hubris_may_prevent_people/
[18] https://whitepapers.theregister.com/