View unanswered posts | View active topics
Forum rules
1. This forum can be used for discussion of both ALGLIB-related and general numerical analysis questions
2. This forum is English-only - postings in other languages will be removed.
 
|
Page 1 of 1
|
[ 5 posts ] |
|
| Author |
Message |
|
GBarker
|
Post subject: optimization functions for VBA  Posted: Wed Oct 15, 2014 9:20 pm |
|
Joined: Wed Oct 15, 2014 9:14 pm
Posts: 1
|
|
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) ?
|
|
| Top |
|
 |
|
Sergey.Bochkanov
|
Post subject: Re: optimization functions for VBA Posted: Thu Oct 16, 2014 10:25 am |
|
 |
| Site Admin |
Joined: Fri May 07, 2010 7:06 am
Posts: 927
|
|
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.
|
|
| Top |
|
|
|
Belisarith
|
Post subject: Re: optimization functions for VBA Posted: Sat Dec 06, 2014 11:36 am |
|
Joined: Thu Oct 09, 2014 5:44 pm
Posts: 3
|
|
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.
|
|
| Top |
|
|
|
ConnieKeefe
|
Post subject: Re: optimization functions for VBA Posted: Mon Dec 22, 2014 12:48 pm |
|
Joined: Fri Dec 12, 2014 6:03 am
Posts: 2
|
|
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
|
|
| Top |
|
|
|
chalnikkal
|
Post subject: Re: optimization functions for VBA Posted: Fri Jan 16, 2015 7:45 am |
|
Joined: Fri Jan 16, 2015 5:12 am
Posts: 1
|
|
misses most functionality present in modern ALGLIB versions. As far as I remember, it misses constrained LM functionality. Only unconstrained fits are performed.???
|
|
| Top |
|
|
|
|
Page 1 of 1
|
[ 5 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 37 guests |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
Login
Register
FAQ
Search