optimizer

[Mangesh]

Hi everyone,

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

 

[Guest]

Sure:

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

 

[Mangesh]

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

 

[Mike Middleton]

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]

Hi Mike,

Thanks for the tip.

Mangesh

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






- Show quoted text -