Results 1 to 5 of 5

Collating two time series

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Zurich
    MS-Off Ver
    Excel 2010
    Posts
    9

    Collating two time series

    Hi all,

    I have the following question, you may have an advice:

    There are two time series as shown below. In column A the time data is given only for specific time point. In column B there are marker data (which start at the given time point and last until the next). In column C a continuous time scale is given (I just show the beginning of this column, but is goes until 114,1 sec).
    My question is how I can collate these two time series, such as the time points from column A are automatically put at the correct row according to column C?

    I also attach the example in a file to easier reading!
    Example_I.xlsx
    many thanks for your suggestions
    Lisa

    ----------------------------------------
    Time points Marker Time scale
    0,0 1 0
    5,6 2 0,1
    11,1 3 0,2
    17,3 4 0,3
    22,7 1 0,4
    28,9 2 0,5
    35,7 3 0,6
    42,2 4 0,7
    48,8 1 0,8
    54,2 2 0,9
    60,2 3 1
    65,6 4 1,1
    71,7 1 1,2
    76,9 2 1,3
    84,6 3 1,4
    90,3 4 1,5
    96,9 1 1,6
    102,4 2 1,7
    108,5 3 1,8
    114,1 4 1,9
    2
    2,1
    2,2
    2,3
    2,4
    etc....
    Last edited by holp; 10-08-2012 at 02:39 AM.

Thread Information

Users Browsing this Thread

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

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