# forum.alglib.net

ALGLIB forum
 It is currently Tue May 30, 2023 11:45 am

 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.

 Page 1 of 1 [ 5 posts ]
 Print view Previous topic | Next topic
Author Message
 Post subject: optimization functions for VBAPosted: 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

 Post subject: Re: optimization functions for VBAPosted: Thu Oct 16, 2014 10:25 am

Joined: Fri May 07, 2010 7:06 am
Posts: 885
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

 Post subject: Re: optimization functions for VBAPosted: 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

 Post subject: Re: optimization functions for VBAPosted: 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

 Post subject: Re: optimization functions for VBAPosted: 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

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 5 posts ]

 All times are UTC

#### Who is online

Users browsing this forum: No registered users and 3 guests

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum

Search for: