forum.alglib.net
http://forum.alglib.net/

optimization functions for VBA
http://forum.alglib.net/viewtopic.php?f=2&t=2153
Page 1 of 1

Author:  GBarker [ Wed Oct 15, 2014 9:20 pm ]
Post subject:  optimization functions for VBA

I am trying to find an multivariate constrained optimization algorithm that I can use in VBA. I found the ALGLIB free package and downloaded it. It looks like "minlm" might be what I'm looking for, but I can't find any examples of its use and I'm stumped just looking at the source code. Does anyone have an example of use in VBA (or VB6) ?

Author:  Sergey.Bochkanov [ Thu Oct 16, 2014 10:25 am ]
Post subject:  Re: optimization functions for VBA

ALGLIB for VBA is quite old (many years old), misses most functionality present in modern ALGLIB versions. As far as I remember, it misses constrained LM functionality. Only unconstrained fits are performed.

Author:  Belisarith [ Sat Dec 06, 2014 11:36 am ]
Post subject:  Re: optimization functions for VBA

Hey,

you can use ALGLIB in Excel by compiling a dll.
I described a possible way in this post:
http://forum.alglib.net/viewtopic.php?f=2&t=2165

Best regards.

Author:  ConnieKeefe [ Mon Dec 22, 2014 12:48 pm ]
Post subject:  Re: optimization functions for VBA

And I'm hoping that spline1d is the right tool to interpolate smoothly between the points while ensuring that queries for points where data has been provided return exactly the data from the map. I will also need to get values for x=0 to x=10, and x=245 to

Author:  chalnikkal [ Fri Jan 16, 2015 7:45 am ]
Post subject:  Re: optimization functions for VBA

misses most functionality present in modern ALGLIB versions. As far as I remember, it misses constrained LM functionality. Only unconstrained fits are performed.???

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/