Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Interpolation functions

    hi all,

    i am looking for sites that enable adding interpolation/extrapolation functions like spline and others that does not exist under the list of xl function. any help/ideas.
    TIA
    dubdub

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Here are some VBA routines for cubic Spline.
    http://www.business-spreadsheets.com/forum.asp?t=120
    http://www.mrexcel.com/forum/excel-q...ions-code.html

    You can google to find other routines and google to find other types of interpolations. I typically will do straight line interpolations with TREND between 2 sets of points (or more if a line fits) or try to define the model of the data and then fit the equation (parabola, inverse, log, etc).

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Greate Thanks Steve, and my sicere apolgy for very late reply.
    TIA
    dubdub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •