bidicalc: a bidirectional calculator
bidicalc A spreadsheet where formulas also update backwards — by Victor PoughonGitHub | Buy me a Coffee ☕ In any normal spreadsheet, when you change values that are the input to some formulas, the outputs are automatically updated:Could it also work the other way? What if you could also change the output, and have the inputs be updated to match the formula?For the past few months I’ve been obsessed really curious about this idea. But there were so many questions:Would it even be possible at all?Could it work with very complex formulas? With exponents? With advanced math functions like log(), abs(), etc?How would the UX work? In a normal spreadsheet, when you click on a cell that has a formula, you get to change the formula’s expression. I would need a way to let the user change…
