optimizer
 

Hi everyone,

Has anyone tried to develop an optimizer in VBA? Maybe something like
quadratic programming etc.

optimizer
 

Su

Checkout Solver in Excel Help. There are also may examples of New-Raphson,
Fletcher-Powell-Davidon, and other conjugate gradient methods available in
Excel.
--
Gary''s Student - gsnu200736


"Mangesh" wrote:

Hi everyone,

Has anyone tried to develop an optimizer in VBA? Maybe something like
quadratic programming etc.

optimizer
 

Hi Gary''s Student,

Thanks for your response.

I know how to work with the solver, but i am specifically looking for
the implementation of the algo.
The second part where you mentioned about the methods available in
excel... where are they available?

Mangesh



On Aug 8, 2:50 pm, Gary''s Student
wrote:
Su

Checkout Solver in Excel Help. There are also may examples of New-Raphson,
Fletcher-Powell-Davidon, and other conjugate gradient methods available in
Excel.
--
Gary''s Student - gsnu200736



"Mangesh" wrote:
Hi everyone,

Has anyone tried to develop an optimizer in VBA? Maybe something like
quadratic programming etc.- Hide quoted text -

- Show quoted text -

optimizer
 

Mangesh -

Frontline Systems (the developers of Excel's Solver) have an advanced
version of Solver for quadratic programming:

http://www.solver.com/xlslslpeng.htm

- Mike
http://www.MikeMiddleton.com


"Mangesh" wrote in message
oups.com...
Hi everyone,
Has anyone tried to develop an optimizer in VBA? Maybe something like
quadratic programming etc.

optimizer
 

Hi Mike,

Thanks for the tip.

Mangesh



On Aug 9, 3:16 am, "Mike Middleton" wrote:
Mangesh -

Frontline Systems (the developers of Excel's Solver) have an advanced
version of Solver for quadratic programming:

http://www.solver.com/xlslslpeng.htm

- Mikehttp://www.MikeMiddleton.com

"Mangesh" wrote in message

oups.com...



Hi everyone,
Has anyone tried to develop anoptimizerin VBA? Maybe something like
quadratic programming etc.- Hide quoted text -

- Show quoted text -