I've been thinking about this a ton lately -
I think the holy grail is something that extends the spreadsheet UX with the capability to address much larger data sets, roughly equivalent in power to a Jupyter notebook.
This probably means constraining some of the totally free-form data entry and imposing some kind of discipline onto columns? As well as some way to intuitively group together groups of cell-level formulas into a logical "row", and describe row-level operations, with some kind of rough type checking or duck typing?
But you might want to still retain an ability to lay out the result of computations free-form for invoice and other reporting uses that Excel is still great for?
Better graphical visualization would be nice too and I think that's actually in reach - there are great open source options like vegalite and apache echarts that open up a lot of possibilities for new tools.
You know, despite being quite different than what you described, what comes close for me in concept is the Spyder IDE. They have pretty reasonable data visualization tools when you go to inspect variables. I find it really nice work in. It lets me do the real visualization and interplay between variables in code or in my head and just quickly inspect tables/vectors/rasters to sanity check as I work in real time.
What's missing is the ability to then manipulate those tables and have it backfeed into the code, but I think that honestly you could again get close to that with some basic right-click>generate new column> type in python expression > translate to input into interpreter type of workflow.
I also know there are some python based excel type programs.
I have had same kind idea but then moved on becouse getting user trust the system is very hard and this needs more qui than ai work. But good luck it is definetly those unicorn ideas if it succees.
This probably means constraining some of the totally free-form data entry and imposing some kind of discipline onto columns? As well as some way to intuitively group together groups of cell-level formulas into a logical "row", and describe row-level operations, with some kind of rough type checking or duck typing?
But you might want to still retain an ability to lay out the result of computations free-form for invoice and other reporting uses that Excel is still great for?
Better graphical visualization would be nice too and I think that's actually in reach - there are great open source options like vegalite and apache echarts that open up a lot of possibilities for new tools.