forum.alglib.net

ALGLIB forum
It is currently Sun Dec 22, 2024 2:42 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  [ 2 posts ] 
Author Message
 Post subject: numerical integration on excel vba
PostPosted: Fri Sep 02, 2011 8:26 am 
Offline

Joined: Fri Sep 02, 2011 8:24 am
Posts: 1
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: Sat Sep 03, 2011 6:56 am 
Offline

Joined: Sun May 16, 2010 11:42 pm
Posts: 63
You can download a spreadsheet from here:
http://newtonexcelbach.wordpress.com/20 ... functions/
which has four spline interpolation functions:

CSplineInt1D =CSplineInt1D(X Coords, Y Coords, UBX, End Type 1, End 1, End Type 2, End 2)
AkimSplineInt1D =AkimSplineInt1D(X Coords, Y Coords, UBX)
HSplineInt1D =HSplineInt1D(X Coords, Y Coords, Derivatives, UBX)
CRSplineInt1D =CRSplineInt1D(X Coords, Y Coords, UBX, End Type, Tension)

For these you need to evaluate the function as a number of points, and the functions will fit a spline to those points and return the integral.

You might also like to have a look at:
http://newtonexcelbach.wordpress.com/20 ... uadrature/

which has routines that will evaluate the integral of a function entered as text, using the Tanh-Sinh method.

_________________
Doug Jenkins
http://newtonexcelbach.wordpress.com/


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

All times are UTC


Who is online

Users browsing this forum: No registered users and 39 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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group