+ Reply to Thread
Results 1 to 3 of 3

Help with interpolating data at 5-minute resolution down to 1-minute resolution

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    Massachussetts
    MS-Off Ver
    Excel 2010
    Posts
    7

    Help with interpolating data at 5-minute resolution down to 1-minute resolution

    Hey everyone, looking for some help in entering a formula which will allow me to expand my data set by interpolating between sets of x,y values. My data set is in 5-minute resolution and I would like to interpolate so that I can output a new set of x,y values in 1-minute resolution. Here is my example of what I have and what I would like my end result to be, and also I have attached a sample of my data set in the below excel file:

    Thanks in advance for any tips anyone can offer

    Original data set
    Date Time Temperature oC
    6/12/13 13:30 18.28
    6/12/13 13:35 17.9
    6/12/13 13:40 17.9

    Desired data set
    Date Time Temperature oC
    6/12/13 13:30 y
    6/12/13 13:31 y
    6/12/13 13:32 y
    6/12/13 13:33 y
    6/12/13 13:34 y
    6/12/13 13:35 y
    6/12/13 13:36 y
    6/12/13 13:37 y
    6/12/13 13:38 y
    6/12/13 13:39 y
    6/12/13 13:40 y

    datetime_temp.xlsx

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Help with interpolating data at 5-minute resolution down to 1-minute resolution

    I took the linear interpolation formula and just replaced all the real data values with INDEX(MATCH()) terms.

    Well, I put the MATCH in a helper column to make it easier to look at but you could just as easily nest it if you wanted (the way that runs the time values have to be in ascending order). I also just made x1 - x0 = 5 minutes rather than a lookup; if you had more variable data intervals you could just make those INDEX functions on the time array as well.

    This might also throw some errors at the end, I didn't check that.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-06-2013
    Location
    Massachussetts
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Help with interpolating data at 5-minute resolution down to 1-minute resolution

    Thank you very much that worked out perfectly. It didn't seem to throw any errors at the end either. Solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Reduce 1 minute data to 30 minute data in Excel
    By MilanBawa in forum Excel General
    Replies: 9
    Last Post: 02-24-2022, 12:48 PM
  2. Looking to convert 10 minute interval data to 15 minute interval data
    By rsporseen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2013, 01:01 PM
  3. [SOLVED] Macro that runs every minute when System Clock changes minute?
    By naira in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2013, 04:11 PM
  4. Correspond Dates to Minute by Minute Data
    By chubby127 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2013, 05:50 AM
  5. rolling minute data into 30 minute averages
    By grc1980 in forum Excel General
    Replies: 0
    Last Post: 08-30-2006, 03:58 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1