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

numerical integration on excel vba
http://forum.alglib.net/viewtopic.php?f=2&t=13
Page 1 of 1

Author:  e3m88 [ Fri May 28, 2010 4:30 am ]
Post subject:  numerical integration on excel vba

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!!!

Author:  Sergey.Bochkanov [ Fri May 28, 2010 7:24 am ]
Post subject:  Re: numerical integration on excel vba

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

Author:  e3m88 [ Fri May 28, 2010 4:29 pm ]
Post subject:  Re: numerical integration on excel vba

It worked like a charm!!!

thank you.! Great project.

Author:  Kokab [ Tue Feb 24, 2015 12:21 pm ]
Post subject:  Re: numerical integration on excel vba

I'm developing an application in VB6 that should interpolate some specific points entered by the user (click with mouse) on a picture control.

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