+ Reply to Thread
Results 1 to 7 of 7

Bilinear Interpolation- help needed

  1. #1
    Registered User
    Join Date
    02-28-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    12

    Bilinear Interpolation- help needed

    Hi,

    I have two data row, Index 1 and Index 2.

    Index 1 Index 2
    12.5 14.4
    12.5 14.4
    10.3 14.4
    11.9 14.4
    12.5 14.4
    16.4 14.4
    12.5 14.4
    12.5 11
    12.5 14.4
    12 14.4
    12 13
    12.5 11.2
    10.3 14.4
    11.9 14.4
    12.5 14.4
    16.4 14.4
    12.5 11
    12.5 14.4
    12.5 14.4
    11.7 13



    I have to make the third column which contains value which is interpolated from the table.

    Index 2
    Index 1 6 7 8 9 10 11 12 13 14 15
    11 628 637 654 677 711 752 794 836 879 921
    12 928 941 966 1000 1050 1112 1173 1235 1298 1360
    13 1312 1330 1365 1412 1484 1570 1657 1745 1833 1921
    14 1790 1814 1861 1925 2023 2141 2258 2378 2499 2618
    15 2372 2403 2465 2550 2679 2835 2990 3149 3309 3467
    16 3035 3087 3184 3312 3490 3701 3912 4130 4372 4587
    17 3849 3928 4079 4273 4503 4741 5012 5310 5671 5998
    18 4858 4989 5221 5515 5834 6134 6525 6979 7571 8089
    19 6118 6342 6700 7142 7611 8052 8652 9359 1031111106

    Excel sheet is attached. Please help
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,193

    Re: Bilinear Interpolation- help needed

    I could not find any relationship between the two table. Can you give some clues?

  3. #3
    Registered User
    Join Date
    02-28-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    12

    Re: Bilinear Interpolation- help needed

    There is no relation, these are random reading data.. I need to find using VLOOKUP, INDEX or Match. not sure how.

    So, for 12.5, it should average 12 value and 13 value and so on. Thanks

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,605

    Re: Bilinear Interpolation- help needed

    12.5 14.4
    In this case what is your expected result and why
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,193

    Re: Bilinear Interpolation- help needed

    So values in C3:L11 is useless? I am still in darkness.

  6. #6
    Registered User
    Join Date
    02-28-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    12

    Re: Bilinear Interpolation- help needed

    Sorry for not writing clearly.. Please go through the attachment and help me. I have lots of data like this. Its a big challange
    Attached Files Attached Files

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,605

    Re: Bilinear Interpolation- help needed

    See the attached file
    but this is a very long / big formula
    Attached Files Attached Files

+ 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. Bilinear interpolation of scattered data points
    By Sebi in forum Excel General
    Replies: 15
    Last Post: 09-19-2012, 01:05 AM
  2. Bilinear interpolation of irregular grid
    By Sebi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2012, 05:19 PM
  3. modify the the bilinear UDF for extrapolation
    By salmanisn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2011, 12:41 AM
  4. Replies: 0
    Last Post: 07-24-2008, 02:27 PM
  5. help with interpolation and limit of interpolation
    By uriel78 in forum Excel General
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

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