+ Reply to Thread
Results 1 to 7 of 7

**3D Interpolation x,y,z -> f(x,y,z)**

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Exclamation **3D Interpolation x,y,z -> f(x,y,z)**

    Hi All,

    Basically, I need a UDF for 3D Interpolation.
    I was able to make UDF for 2D Interpolation, but 3D is very difficult.

    Scenario: I will have a table with X, Y, Z and appropriate value f(x,y,z). With given table, if I pick any number to X,Y,Z , then interpolated f(x,y,z) is generated.

    I attached a file! so please have a look!

    My table will be either Table 1 or Table 2 or anything else. Means, Range Y wouldn't be same, Interval wouldn't be same, etc.

    Thank you in advance!

    Chris

    P.S
    .pdf file might help you understanding mathematical concepts.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    What would the answer be for your example?

  3. #3
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    Can you help me about UDF? VBA code...

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    Not sure I follow it, hence asking for an illustration of expected results.

  5. #5
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    nah, I don't need your help. After I provide everything that you need, you just ignored it.

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

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    God speed.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: **3D Interpolation x,y,z -> f(x,y,z)**

    Chris - you've got a strange attitude.

    Ironically, you have probably alienated the one person on this forum, shg, who could have rattled you off a solution.

    Bye bye.

+ 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