Shulou(Shulou.com)11/24 Report--

CTOnews.com, February 4 (Xinhua)-- Microsoft's Excel, which has a history of 37 years, is not only a spreadsheet processing tool in a pure sense, but also can be extended to run Doom and Pac-Man games, produce stop-motion animation, play chess, and so on.

Microsoft software developers have recently extended the functionality of Excel again, introducing a small language model called FLAME to improve the creation and maintenance of Excel formulas by assisting artificial intelligence systems.

CTOnews.com learned that Microsoft researchers Harshit Joshi, Abishai Ebenezer, Jos é Cambronero, Sumit Gulwani, Aditya Kanade, Vu Le, Ivan Radi floor ek and Gust Verbruggen described this in detail in the preprinted paper.

Take the popular ChatGPT as an example, large language models require a lot of input data and funds, and reasoning using the generated models also requires a lot of hardware.

FLAME, which contains only 60m parameters, is "the first language model specially designed for Excel formula". Research papers point out that FLAME is the acronym for "First LAnguage Model for Excel".

Despite its small scale, FLAME's AI performance in Excel outperformed larger models such as CodeT5 (220m), Codex-Cushman (12B), and Codex-Davinci (175B) that were adjusted to complete lines of code (code filling).

FLAME is designed to automate Excel formulas or fix malformed formulas and handle syntax reconstruction, a technique that removes delimiters (such as curly braces) from formulas, so models can more easily identify and reconstruct complete formulas.

If the user enters the wrong formula in Excel in the future:

= IF ('Jan 13 correction B2 = ",' Feb 13 correction B2 =", 'Mar 13 correction B2 = ",' Apr 13 correction B2 =", yes, no) eventually looks like this with the help of FLAME's correction capabilities:

= IF (AND ('Jan 13 / B2 = ",' Feb 13 / B2 =", 'Mar 13 / B2 = "",' Apr 13 / B2 = ")," yes "," no ")

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.