SPREADSHEETLLM Pipeline. Copyright: Arcxiv (2024). DOI: 10.48550/arxiv.2407.09025
A team of programmers and AI specialists at Microsoft have developed an AI tool called SpreadsheetLLM that applies the capabilities of a large language model to spreadsheets. In their study, It was published. On the Arcxiv Using the preprint server, the group developed SheetCompressor, a coding framework that efficiently compresses spreadsheets for use by large language models (LLMs).
LLM programs like ChatGPT are well known, but as more people use them, gaps in their capabilities become more apparent. One gap is the ability of such models to understand spreadsheets. Given their unique structure and capabilities, spreadsheets remain a mystery to LLM programs, preventing their use as a helpful tool. a tool For business.
In this new study, the team at Microsoft created a tool to reorganize Schedule In a model that law students can use as a data source. As the team notes, it is based on a concept they call SheetCompressor, a programming tool that allows data to be managed and analyzed using artificial intelligence to get information into spreadsheets.
To implement SheetCompressor, the researchers broke it down into three main functions: compression, translation, and data formatting. The first function was implemented by adding what the team calls anchors throughout a spreadsheet to help law students understand what the spreadsheet was doing.
Once in place, the rows and columns are replaced with a structured table. Translation units are then used to remove blank cells or duplicate values. Implementing a lossless inverted index translation JSON format allows data appearance to gather.
The team also added additional modules to handle unique situations, such as adjacent cells with similar numeric formats. The result is a tool that allows LLM students to use spreadsheets as a data source in a variety of ways.
The research team proposes that SpreadsheetLLM opens the door to using LLM technology to revolutionize the way spreadsheets are used; from automating data entry, to analyzing data, to presenting complex information in a way that is accessible to people from diverse backgrounds. They also suggest that this would make spreadsheets and the data they contain more accessible and useful.
more information:
Yuzhang Tian et al, SpreadsheetLLM: Spreadsheet encoding for large language models, Arcxiv (2024). DOI: 10.48550/arxiv.2407.09025
© 2024 Science Network X
the quoteMicrosoft Unveils Software That Lets LLM Holders Work with Spreadsheets (2024, July 16) Retrieved July 16, 2024 from https://techxplore.com/news/2024-07-microsoft-unveils-software-llms-spreadsheets.html
This document is subject to copyright. Apart from any fair dealing for private study or research purposes, no part of it may be reproduced without written permission. The content is provided for informational purposes only.
