| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
optimizer
Hi everyone,
Has anyone tried to develop an optimizer in VBA? Maybe something like quadratic programming etc. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mean variance optimizer for excel | Excel Discussion (Misc queries) | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Hybrid Mode
