Extrapolating 15min, to 10min data- help?

Hey everyone,

So I'm conducting an experiment where I'm looking at river depth and time. My river depth results are every 10 minutes, but my rain gauge is in 15 minute intervals. I'd much prefer to have the data in 10 minute intervals to improve the resolution of this particular study.

I'm struggling to find a way to extrapolate the data on excel so the data is in 10 minute intervals. I've tried changing the 15 min rain data in to 5 minutes (divide by 3, three times) but when I try to copy the formula, excel reads the adjacent rather than following the previous pattern. I've also tried =N3, =(N3-N4)*0.33333+N4, =(N4-N5)*0.66666+B5 repeated as well.

I've attached a copy of my working out (Sheet 2). If anyone could have a look I'd be very grateful!!

If you need any more information please let me know

Alex

Hi
Try this formula in E3 and copy down

Formula:

=FORECAST(D3,OFFSET($B$2,MATCH(D3,$A$3:$A$2643,1),0,2,1),OFFSET($A$2,MATCH(D3,$A$3:$A$2643,1),0,2,1))

Hi Jose,

Thank you very much, that has done it!

Alex

You're welcome.
Please, don't forget mark this thread as SOLVED.

I've just got a slight problem in trying to copy that formula to extrapolate the data from 5 minute to 10 minute datasets, I can't quite get my head around how you did it to get the 5 minuthe data sorry!

Any help would be much appreciated

Hi
Where's your data?