Comment by btown
10 days ago
> terrible at accessing cells in a spreadsheet from which it's called
Are there any companies solving LLM-based interactions with arbitrary messy spreadsheets?
Not the nice demo ones with a single consistent table and maybe some charts/PivotTables - the ones with 20 sheets each of which has 3-4 different data tables laid out side by side, which should be linked to each other but likely aren't?
I've long thought that one could build a probabilistic graph representation, annotated with text, of "this is the likely meaning of this area in the sheet, this is how it relates to other columns in other areas, formulas are inconsistent in this way," allow an LLM to ask questions of a tool that can traverse this graph until it determines an optimal plan, and allow it to output and iterate on e.g. xlwings code to execute that plan.
I'm frankly surprised Microsoft didn't create an entire "skunkworks" for this problem - is anyone else doing so?
I am doing exactly this. In stealth, launching soon
Best of luck! Feel free to ping me, email in bio if you ever want to chat.