+ Reply to Thread
Results 1 to 6 of 6

Extrapolating 15min, to 10min data- help?

  1. #1
    Registered User
    Join Date
    07-13-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Unhappy 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
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Extrapolating 15min, to 10min data- help?

    Hi
    Try this formula in E3 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-13-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Re: Extrapolating 15min, to 10min data- help?

    Hi Jose,

    Thank you very much, that has done it!

    Alex

  4. #4
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Extrapolating 15min, to 10min data- help?

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

  5. #5
    Registered User
    Join Date
    07-13-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    3
    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

  6. #6
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Extrapolating 15min, to 10min data- help?

    Hi
    Where's your data?

+ 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. Extrapolating Missing Data
    By GregOMH in forum Excel General
    Replies: 2
    Last Post: 05-13-2016, 11:20 PM
  2. 5min interval data series to 10min using pivot tables
    By env-eng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-11-2015, 06:33 AM
  3. Extrapolating data
    By sherlock1241 in forum Excel General
    Replies: 3
    Last Post: 04-21-2015, 12:03 PM
  4. Extrapolating data over time
    By Dan Shorer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2014, 04:07 PM
  5. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  6. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  7. Excel Session timer 10min splash screen Warning then 15min force close
    By Phil_pac in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-20-2009, 12:31 PM

Tags for this Thread

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