This is really cool! It's like Excel's goal seek but can also handle the case of arbitrary input cells. Goal seeek can only handle one input and one output cell.

But how do you handle the case where multiple variables can be changed? If multiple input cells is the key difference from Goal seek, i think some more rigor should be placed into the algorithm here

e.g. setting A1 + B1 and wanting the result to be 5. Currently it bumps both A1 and B1 equally. What's the thought process behind this?

▲

fragmede a day ago | parent [-]

Yeah. The UI could have a lock icon to set, eg B1 should stay fixed and then only A1 would change.

	▲	tkzed49 a day ago \| parent [-]
		It supports this. If you type # before a number, like #5, it's made constant.