forum.alglib.net

ALGLIB forum
It is currently Thu Mar 28, 2024 7:15 pm

All times are UTC


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.



Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: optimization functions for VBA
PostPosted: Wed Oct 15, 2014 9:20 pm 
Offline

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
 Profile  
 
 Post subject: Re: optimization functions for VBA
PostPosted: Thu Oct 16, 2014 10:25 am 
Offline
Site Admin

Joined: Fri May 07, 2010 7:06 am
Posts: 903
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
 Profile  
 
 Post subject: Re: optimization functions for VBA
PostPosted: Sat Dec 06, 2014 11:36 am 
Offline

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
 Profile  
 
 Post subject: Re: optimization functions for VBA
PostPosted: Mon Dec 22, 2014 12:48 pm 
Offline

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
 Profile  
 
 Post subject: Re: optimization functions for VBA
PostPosted: Fri Jan 16, 2015 7:45 am 
Offline

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
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 50 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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group