| ▲ | d--b a day ago | |
The examples are great and these bidirectional calculators are something that people would love to have in traditional spreadsheets. So much so that Credit Suisse, which basically was running everything on heavily modded Excel, created a full language whose outputs were Excel spreadsheets capable of doing that. That thing called “paradise” was a total monstrosity but showed how much people wanted this. That said, you really need a way to set which cells are fixed and which cells are allowed to move if you want to move past basic examples. Most times you know what you want to do. like => if the user modifies that cell, find a solution for those specific ones. If you can enter that info, then you have a lot more constrains for your solver and will avoid a lot of edge cases where everything goes to 0, and you can check that the calculation entered is indeed reversible or not, or if it could have multiple solutions, and so on. | ||
| ▲ | amelius 19 hours ago | parent | next [-] | |
> and these bidirectional calculators are something that people would love to have in traditional spreadsheets People want them in general programming languages too. I can't count the number of times I had to implement the same function multiple times, but backwards in various ways. | ||
| ▲ | fouronnes3 a day ago | parent | prev [-] | |
Constants are supported, use # as a prefix, e.g.; #50. I'd like to add more constraints in the future like a domain constraint for variables. | ||