⇆ bidicalc - a spreadsheet where formulas also update backwards

Comments

• probable_possum@leminal.space ⁨4⁩ ⁨days⁩ ago

  Nice. What’s the use case?

  source

  • palordrolap@fedia.io ⁨4⁩ ⁨days⁩ ago

    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".

    source

    • probable_possum@leminal.space ⁨4⁩ ⁨days⁩ ago

      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 use and didn’t want to miss it.

      source
  • leastaction@lemmy.ca ⁨4⁩ ⁨days⁩ ago

    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?

    source
• j4cobgarby@feddit.uk ⁨4⁩ ⁨days⁩ ago

  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?

  source

  • dusty_raven@discuss.online ⁨4⁩ ⁨days⁩ ago

    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.

    source