Topic: Dependence of value in one cell from value in other cell - how to construct?
Hello! I ask the help.
I made in the table in which on the basis of input parameters (are selected in a picture) and experimental the data (the long table from below) is calculated certain result (cell H5). My task - to find values parameters at which the result is minimum. For this purpose I plan to use the unit of search of the decision built in an ex-fur-tree.
Problem in that operation of this unit extremely strongly depends on starting values parameters . Thus, now my task - to select good starting values parameters .
For this purpose I want to set any adequate (but not too successful) values all parameters , and then to vary each of them individually and to look, how changes result .
The Question : how to me, without spoiling the initial table, to construct (for example, on new sheet) dependence result from each of parameters (at fixed values of the remaining parameters specified in the initial table)? For example, I know that all y0 lie in a range from 0 to 0,00001, and all w lie in a range from 0 to 10. I can break these ranges, for example, into 100 points, to fill with values the first column of new sheet... And here is how to fill the second column?
It is obvious that the task a straight line and has the decision. But I simply do not know, on what keywords for it to search. Help, please!
I search most for the common decision because I expect that in the future the amount of parameters still increases.