⇆ bidicalc - a spreadsheet where formulas also update backwards

https://victorpoughon.github.io/bidicalc/

60 points · 6 comments · view on lemmy.world

6 Comments

probable_possum@leminal.space · 17 pts · 245d (3 replies)

Nice. What's the use case?

palordrolap@fedia.io · 10 pts · 245d (1 reply)

As it stands, it doesn't look like there is one. It appears to be a recreational mathematical toy for the creator to learn things more than it is for others to play with. It's kind of neat nonetheless.

I think I might have made different choices for the reversal calculations, but I haven't really thought about how I'd implement those choices, nor about nigh-insurmountable edge cases, and I'm only vaguely thinking about the "c = a OP b" case, not anything more extreme. The creator may have wanted to make the same choices but found themselves forced down a different path.

Verbatim from the creator: "it is imperfect".

probable_possum@leminal.space · 3 pts · 245d

It appears to be a recreational mathematical toy for the creator to learn things more than it is for others to play with. It's kind of neat nonetheless.

That's perfectly fine. :) I just couldn't find a use case and didn't want to miss it.

leastaction@lemmy.ca · 7 pts · 245d

It may or may not be intentional, but it could serve to answer what-if questions. If I want a certain outcome, what should the inputs look like?

j4cobgarby@feddit.uk · 3 pts · 245d (1 reply)

It's very cool. I wonder if a heuristic in the solver to prioritise changing values by as little as possible would help yield more predictable outcomes?

dusty_raven@discuss.online · 2 pts · 245d

It would also be cool to be able to add constraints in other cells, like A1 > B1 or A1 + B1 = 5, though then it would really be more like a linear programming solver than anything.