+ Reply to Thread
Results 1 to 7 of 7

Finding maximum point for each echo

Hybrid View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Finding maximum point for each echo

    Hello everyone,

    I am measure 1H T2 times of a basic polymer by solid state, and the data I acquire is given in 50 echoes of about the same size. I tried to create a pulse sequence to acquire only the echo maxima for each point, however this effort was futile and never seemed to work.

    I have attached a copy of my data, and what I was wondering was if there was any way to write a formula that could pick out the maximum points for each echo. I can do this by hand, but later when I have large number of data sets of various sizes, a formula would definitely help. In the end, I need 50 points for each data set, not the ~7000.

    Thank you very much!
    Jackie
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Finding maximum point for each echo

    Something like in the attached?
    Attached Files Attached Files
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Finding maximum point for each echo

    Maybe as attached?
    Attached Files Attached Files
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    08-13-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Finding maximum point for each echo

    Thank you very much! That seemed to work well with a little modification (see attached). Now my only question is how do I find the x-point that matches with the value for the echo maxima (in column D)?

    Thanks!
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-13-2012
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Finding maximum point for each echo

    This should have it for you. I used the offset function with the Match Function to get the proper row offset.


    Amp with X-Val.xlsx

  6. #6
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Finding maximum point for each echo

    You could also use this following for F19 and copied down:
    Formula: copy to clipboard
    =INDEX($A$19:$A$6546,MATCH(D19,$B$19:$B$6546,0))
    Last edited by Søren Larsen; 08-15-2012 at 04:19 AM.

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Finding maximum point for each echo

    For mine, you could autofilter the maxima column and untick #N/A

+ Reply to Thread

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