3 ms·
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 out
by willrshansen 10mo ago
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 10mo agoDoes 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.
- exe34 10mo agoI think it would be good if you could lock one of them.
- hamandcheese 10mo agoYou can.
- shomp 10mo agoWith # (octothorpe) #Val
- idiotsecant 10mo agoWhat is inputs a,b,c,d,and e are polynomial coefficients? I am hoping to get a fields medal plz respond.
- fouronnes3 10mo agoYou can actually solve fifth order polynomials with bidicalc! But it's a numerical solution, not an algebraic one, so no Fields medal.
- geon 10mo agoIt would make more sense to preserve the ratio if possible.
- pxx 10mo agoYeah, 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.
- rafabulsing 10mo agoTo get that, you could pass the ratio explicitly. C = 5A + 7B
- fouronnes3 10mo agoYou 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.
- ximm 10mo ago100% 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 10mo agoYou 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.
- deleted 10mo ago[deleted]
- nkrisc 10mo agoIMO constant should be the default and variables should be annotated.