#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Solver Problem | myusername343 | Excel | 0 | 04-10-2014 10:09 AM |
Simple Macro help for Excel Solver | ue418 | Excel Programming | 1 | 06-23-2013 12:34 PM |
Automatic line extension is creating 2 lines | jim999 | Word | 6 | 03-29-2013 03:28 PM |
Question on using solver | jcg | Excel | 0 | 12-13-2011 05:54 PM |
Ms word solver | DAREGOT | Word | 1 | 03-11-2010 11:52 PM |