Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |