Several target cells in the solver
 

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

Several target cells in the solver
 

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

In article ,
says...
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

Several target cells in the solver
 

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" wrote in message
om...
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

In article ,
says...
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

Several target cells in the solver
 

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

In article ,
says...
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" wrote in message
om...
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

In article ,
says...
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

Several target cells in the solver
 

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

"Tushar Mehta" wrote:

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

In article ,
says...
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