AI code gen means that anything that is currently modeled as a spreadsheet is better modeled in code. You get all the advantages of software - libraries, open source, AI, all the complexity and expressiveness."
“Anything that is currently modeled” would be true if we could guarantee the correctness of AI-generated code.
Business people prefer the familiarity of spreadsheets, or at least some kind of grid. At the same time, I am working on this software out of frustration with spreadsheets, because users are forced to translate A1*B2-style addresses into business meaning.
So I agree that code is one possible direction. But I think there is also a middle ground: business rules over dimensions. Enterprise tools like TM1 have explored this direction for decades.
It is an early alpha multidimensional modeling engine. The main idea is to separate the model from the grid: dimensions, cubes, rules, and views instead of spreadsheet cell formulas.
I am looking for feedback from people who have built or maintained spreadsheet models, especially on whether the abstraction is understandable.
https://x.com/andrewchen/status/2031532980032909640 - related?
"prediction re the end of spreadsheets
AI code gen means that anything that is currently modeled as a spreadsheet is better modeled in code. You get all the advantages of software - libraries, open source, AI, all the complexity and expressiveness."
“Anything that is currently modeled” would be true if we could guarantee the correctness of AI-generated code.
Business people prefer the familiarity of spreadsheets, or at least some kind of grid. At the same time, I am working on this software out of frustration with spreadsheets, because users are forced to translate A1*B2-style addresses into business meaning.
So I agree that code is one possible direction. But I think there is also a middle ground: business rules over dimensions. Enterprise tools like TM1 have explored this direction for decades.
the only way that's possible is if you can use a spreadsheet to test the code.
I made OM Core public today.
It is an early alpha multidimensional modeling engine. The main idea is to separate the model from the grid: dimensions, cubes, rules, and views instead of spreadsheet cell formulas.
I am looking for feedback from people who have built or maintained spreadsheet models, especially on whether the abstraction is understandable.
Docs: https://cloudcell.github.io/om-docs/