forum.alglib.net

ALGLIB forum
It is currently Thu Mar 28, 2024 12:36 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  [ 4 posts ] 
Author Message
 Post subject: numerical integration on excel vba
PostPosted: Fri May 28, 2010 4:30 am 
Offline

Joined: Fri May 28, 2010 4:04 am
Posts: 2
hi, I'm new to excel vba programming, so i was looking for a complete aplied example using de vb6 package, what I need is to define and integrate a function F(x) on a finite interval [a,b].
for example:
Image


Thank you very much!!!


Top
 Profile  
 
 Post subject: Re: numerical integration on excel vba
PostPosted: Fri May 28, 2010 7:24 am 
Offline
Site Admin

Joined: Fri May 07, 2010 7:06 am
Posts: 903
You should use autogk.bas unit, which requires 16 other units: ap, tsort, hblas, reflections, creflections, sblas, ablasf, ablas, ortfac, blas, rotations, hsschur, evd, gammafunc, gq, gkq.

Use it as follows:
Code:
    Dim State As AutoGKState
    Dim V As Double
    Dim Rep As AutoGKReport

   
    '
    ' f(x) = 3*x^2 + x/2
    ' Exact answer is 2*pi
    '
    Call AutoGKSmooth(3, 5, State)
    Do While AutoGKIteration(State)
        State.F = 3*State.X*State.X + 0.5*State.X
    Loop
    Call AutoGKResults(State, V, Rep)

    ' Now V contains result


Top
 Profile  
 
 Post subject: Re: numerical integration on excel vba
PostPosted: Fri May 28, 2010 4:29 pm 
Offline

Joined: Fri May 28, 2010 4:04 am
Posts: 2
It worked like a charm!!!

thank you.! Great project.


Top
 Profile  
 
 Post subject: Re: numerical integration on excel vba
PostPosted: Tue Feb 24, 2015 12:21 pm 
Offline

Joined: Tue Feb 24, 2015 12:17 pm
Posts: 1
I'm developing an application in VB6 that should interpolate some specific points entered by the user (click with mouse) on a picture control.

_________________
kaleem


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC


Who is online

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