Several target cells in the solver

[omathilde]

Hi

I m using excel 2003 and I would like to know if it is possible to set
several target cells to the solver.
As we have several adjustable cells, is it possible to minimize up to 4
results for instance ?

Thanks

 

[Tushar Mehta]

Simultaneously minimize multiple cells? No, not really. After all, what
would you have Solver do if two cells had their minimum values at two
different combinations of 'adjustable cells?'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[David Adamson]

Best way to make solver do multiple analysis on a worksheet is to use
coding.

I use a basic loop function to reset solver each time it runs and then reset
all the data by code. I have it doing 20 solutions on one page.

The following link will help you get started for programming the solver
http://support.microsoft.com/kb/843304/en-us

 

[Tushar Mehta]

Yes, it is possible to use Solver with VBA. But, I am not sure how that
helps the OP.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[walter]

I have some option market prices and I also have a model based on 5
parameters which calculates the prices of options.

I want solver to find those 5 optimal parameters which minimizes the
differences between the observable market prices and my calculated
theoretical prices! There must be a away to set solver `s target cell"s" to
be the differences between individual options? Ahy help?

I have tried setting as target the sum of the squared differences but that
doesnt find the opimal parameters either. Thx