+ Reply to Thread
Results 1 to 5 of 5

Function to interpolate a complex table

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2010
    Posts
    3

    Function to interpolate a complex table

    I need a function that can take two values and and interpolate the third. The table is attached. I have used these forums to lookup other functions for past projects, but I couldn't find a function that could work with this. Any ideas? I also posted this at http://www.ozgrid.com/forum/showthread.php?t=166410
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: Function to interpolate a complex table

    See attached.
    Last edited by shg; 06-13-2012 at 10:26 AM. Reason: remove attachment
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Function to interpolate a complex table

    Thank you shg. This works great for the pressure values given on the table. I haven't checked for pressure values in between but the entropy values I'm getting look to be incorrect.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: Function to interpolate a complex table

    Yikes, I introduced a bug in neatening up some formulas. Corrected in attachment.
    Attached Files Attached Files
    Last edited by shg; 06-14-2012 at 06:30 PM.

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Function to interpolate a complex table

    It Works! I checked the outputs values and they are correct. Tables look neat as well. Thanks again.

+ 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