The first example on the main page has a formula with two variables being updated from changing one value. The immediate question I have is if I change the output, where does the extra degree of freedom come from on the inputs? Does one stay locked in place? Unclear.

I am a huge fan of the concept though. It's been bugging me for years that my spreadsheet doesn't allow editing text fields after filtering and sorting them down to the subset I want. I have to go all the way back to the mess of unsorted input rows to actually edit them.

▲ rahimnathwani a day ago | parent | next [-]

  Does one stay locked in place? Unclear.

If you set C1=A1+B1 then, when you set a value for C1, A1 and B1 are each half of that value, even if they started off unbalanced.

▲ geon 21 hours ago | parent | next [-]

It would make more sense to preserve the ratio if possible.

	▲	pxx 15 hours ago \| parent \| next [-]
		Yeah, this concept is interesting but the fact that the simplest test case gives what's fundamentally a surprising result is very annoying. It also doesn't help that in the example, the expected outcome of 53.3333/46.6667 isn't even considered.
	▲	fouronnes3 14 hours ago \| parent \| prev \| next [-]
		You can do this with bidicalc already! You just have to model the problem correctly. If you expect the ratio to remain constant, what you actually want is a problem with a single free variable: the scale. `A1 = 1.0 // the scale, your variable A2 = 6 * A1 // intermediate values A3 = 8 * A1 A4 = A2 + A3 // the sum` Now update A4 (or any other cell!) and the scale (A1, the only variable) will update as you expect.
	▲	rafabulsing 15 hours ago \| parent \| prev [-]
		To get that, you could pass the ratio explicitly. C = 5A + 7B

▲ idiotsecant a day ago | parent | prev | next [-]

What is inputs a,b,c,d,and e are polynomial coefficients? I am hoping to get a fields medal plz respond.

	▲	fouronnes3 a day ago \| parent [-]
		You can actually solve fifth order polynomials with bidicalc! But it's a numerical solution, not an algebraic one, so no Fields medal.

▲ exe34 a day ago | parent | prev [-]

I think it would be good if you could lock one of them.

▲

hamandcheese a day ago | parent [-]

You can.

	▲	shomp 21 hours ago \| parent [-]
		With # (octothorpe) #Val

▲ ximm a day ago | parent | prev [-]

100% this. When I reached the end of that page I felt pranked because the obvious question was never answered. How are these cases resolved? Is it possible to fix some inputs and only update others? What if I sometimes want to change input A, and other times I want to update input B? All this should be explained as early as possible.

▲

fouronnes3 a day ago | parent [-]

You can do it and it is explained, actually. Use # as a prefix to indicate a constant, e.g.: #50 will be a constant and not a variable.

In the future I'd like to support more user input constraints, in particular domain constraints for variables. So you could tell the solver that this cell must remain in some interval, and it would respect that interval instead of assigning any real value.

	▲	nkrisc 15 hours ago \| parent \| next [-]
		IMO constant should be the default and variables should be annotated.
	▲	a day ago \| parent \| prev [-]
		[deleted]