The deterministic part (calculations) is done by Excel.
The non-deterministic part is turning human instructions ("calculate the NPV over 10 years for X given Y") into Excel.
This is already a non-deterministic process (humans are non-deterministic!). The question is if an AI model can be more reliable than humans, and I can't see any reason why it wouldn't be.
The correct path is pretty clear, so the logits for following that path are going to be a long way from off-path.
For something like this the real problem is training the model to use Excel (which will show up by it being confused which sheet it is on or trying to use the wrong window or things like that), not the non-determinism.
so basically what you're saying is that: it doesn't do the math, it tells the math-doing-thing what math to do. Basically, instead of humans using Excel, imagine AI using Excel?
Yet I don't understand the aha moment here? It might save analyst time but aren't there already enough automation that you don't really need to tell the AI to tell the math-doing-thing to do the math because the math-doing-thing is already optimized for most general functions? What are we gaining from adding the non-deterministic process here when the real non-deterministic process is still the human being prompting what to do?
Seems like a solution to a non-problem from my pov.
Sure in the sense that you're setting up a program that has inputs and outputs etc. But then all math is programming. All language is too, even speaking can be considered programming if you're stretching the definition enough. But I will disagree that setting up spreadsheets = basically software engineering.
The LLM just needs to make sure it uses it appropriately. Doing that bit is the non-deterministic part, but the NPV calculation itself is completely deterministic.
When you setup a spreadsheet, you choose a column or cell to show the NPV. You use the npv formula on this cell and apply it to inputs from other columns or cells.
This process of deciding what data to put in what column and how to apply NPV to it is non-deterministic. You could choose to put it in column A, or column B or maybe even row 3 - it depends!
Do you really think you come off as a good person posting things like this? This place is to satisfy intellectual curiosity, not to lord your supposed intelligence over others, without even proving it exists in the first place.
The non-deterministic part is turning human instructions ("calculate the NPV over 10 years for X given Y") into Excel.
This is already a non-deterministic process (humans are non-deterministic!). The question is if an AI model can be more reliable than humans, and I can't see any reason why it wouldn't be.
The correct path is pretty clear, so the logits for following that path are going to be a long way from off-path.
For something like this the real problem is training the model to use Excel (which will show up by it being confused which sheet it is on or trying to use the wrong window or things like that), not the non-determinism.