Automatic use of solver on different lines with different parameters
Good morning,
My problem seems to be simple I have a polynomial equation that gives a result. This result depends from two parameters with square and interaction terms. I want to be able to determine what value parameter B must have for the equation to have a predefined result.
Of course this is easy to be done with the solver or the target value but line per line and I need to do it on dozens of line in multiple spreadsheet.
Question: will I have to do it manually, is there a better way or will I have to use macros involving the solver ?
The second option would be the best, making macros will be more of a problem unless I have kind of a model and the first option, well frankly no.
In the supplied file, columns are :
A à Equation factors names.
B à Values of the equation factors used for the result computing.
C à Values of parameter A.
D à values of parameter B that need to be determined.
E à Equation result.
F à Desired value for the equation result.
I warmly thank whoever can help me solve this problem.
|