Consulting

Results 1 to 3 of 3

Thread: Interpolation of data on Excel

  1. #1
    VBAX Newbie
    Joined
    Mar 2010
    Posts
    1
    Location

    Interpolation of data on Excel

    Hi,

    Basically my problem is that I haven't got any experience with coding on excel and I have a lot of data that needs sorting at the moment.

    What I have is quite a few sets of data, all with two columns in. Basically I will end up plotting these but I need to have the x values at regular intervals whereas at the minute they are not constantly spread.

    If anyone could help I basically need a code that somehow stores the (call them x and y for simplicity) two columns of data and then outputs a new spreadsheet with a the x data at set intervals and the new interpolated data for the y set.

    Thanks!

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,078
    Location
    Can you share a sample workbook that shows on sheet1 several rows of what the actual data looks like and on sheet2 what you want it to look like.

    Make sure sheet1 shows the problem and sheet 2 fixes it.

    Also tell us how many rows of data you're talking about. 100, 10,000, 1,000,000

  3. #3
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    6,942
    Location
    Unless you really want to use VBA, the worksheet Trend () function will do that

    Lineral interp sample in attached file, but you can do Log, and Exp. Power is a little tricker

    WS 'Raw' is the sparse data, and 'Spread' is evenly spaced

    I just used a simple y = f(x) = 1.5x formula

    Paul

Posting Permissions

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