Does one stay locked in place? Unclear.
It would make more sense to preserve the ratio if possible.
replyYeah, this concept is interesting but the fact that the simplest test case gives what's fundamentally a surprising result is very annoying.
replyIt also doesn't help that in the example, the expected outcome of 53.3333/46.6667 isn't even considered.
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.
reply A1 = 1.0 // the scale, your variable
A2 = 6 * A1 // intermediate values
A3 = 8 * A1
A4 = A2 + A3 // the sum
To get that, you could pass the ratio explicitly. C = 5A + 7B
replyWhat is inputs a,b,c,d,and e are polynomial coefficients? I am hoping to get a fields medal plz respond.
replyYou can actually solve fifth order polynomials with bidicalc! But it's a numerical solution, not an algebraic one, so no Fields medal.
replyI think it would be good if you could lock one of them.
reply100% 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.
replyYou 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.
replyIn 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.
IMO constant should be the default and variables should be annotated.
replydeleted
reply