software

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

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 gt;,says...
gt; Hi
gt;
gt; I m using excel 2003 and I would like to know if it is possible to set
gt; several target cells to the solver.
gt; As we have several adjustable cells, is it possible to minimize up to 4
gt; results for instance ?
gt;
gt; Thanks
gt;

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
support.microsoft.com/kb/843304/en-us
quot;Tushar Mehtaquot; gt; wrote in message om...
gt; Simultaneously minimize multiple cells? No, not really. After all, what
gt; would you have Solver do if two cells had their minimum values at two
gt; different combinations of 'adjustable cells?'
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt;gt; Hi
gt;gt;
gt;gt; I m using excel 2003 and I would like to know if it is possible to set
gt;gt; several target cells to the solver.
gt;gt; As we have several adjustable cells, is it possible to minimize up to 4
gt;gt; results for instance ?
gt;gt;
gt;gt; Thanks
gt;gt;
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 gt;,
says...
gt; Best way to make solver do multiple analysis on a worksheet is to use
gt; coding.
gt;
gt; I use a basic loop function to reset solver each time it runs and then reset
gt; all the data by code. I have it doing 20 solutions on one page.
gt;
gt; The following link will help you get started for programming the solver
gt; support.microsoft.com/kb/843304/en-us
gt;
gt;
gt;
gt; quot;Tushar Mehtaquot; gt; wrote in message
gt; om...
gt; gt; Simultaneously minimize multiple cells? No, not really. After all, what
gt; gt; would you have Solver do if two cells had their minimum values at two
gt; gt; different combinations of 'adjustable cells?'
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Tushar Mehta
gt; gt; www.tushar-mehta.com
gt; gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; gt; Custom MS Office productivity solutions
gt; gt;
gt; gt; In article gt;,
gt; gt; says...
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;gt; I m using excel 2003 and I would like to know if it is possible to set
gt; gt;gt; several target cells to the solver.
gt; gt;gt; As we have several adjustable cells, is it possible to minimize up to 4
gt; gt;gt; results for instance ?
gt; gt;gt;
gt; gt;gt; Thanks
gt; gt;gt;
gt;
gt;
gt;

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 cellquot;squot; 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

quot;Tushar Mehtaquot; wrote:

gt; Simultaneously minimize multiple cells? No, not really. After all, what
gt; would you have Solver do if two cells had their minimum values at two
gt; different combinations of 'adjustable cells?'
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt; gt; Hi
gt; gt;
gt; gt; I m using excel 2003 and I would like to know if it is possible to set
gt; gt; several target cells to the solver.
gt; gt; As we have several adjustable cells, is it possible to minimize up to 4
gt; gt; results for instance ?
gt; gt;
gt; gt; Thanks
gt; gt;
gt;