Skip to main content
12-Amethyst
February 16, 2022
Solved

Interp Function

  • February 16, 2022
  • 1 reply
  • 1388 views

Hi guys

 

I have 2 sets of data kz.b and kc and the refence variable z.b

 

currently i can interpolation to find what kc is when z.b is equal to a value hence the below;

BG_9641770_0-1645005373003.png

 

however there a various values of Kcphi which i may need to interpolate between such as if

 

kcphi was 6 i would then need to interpolate the value between kcphi5 and kcphi10 to then return the value and interpolate z.b to return the vlaue i am after.

 

i was wondering if there is a function that could be written to help with this

 

Thanks 🙂

Best answer by Werner_E

You may use the 2D interpolation function provided in the attached sheet.

I assumed phi to be an angle in degree, so I added the necessary unit.

Werner_E_0-1645011033466.png

The same principle could easily be applied to use spline interpolations instead of linear interpolations.

 

1 reply

Werner_E25-Diamond IAnswer
25-Diamond I
February 16, 2022

You may use the 2D interpolation function provided in the attached sheet.

I assumed phi to be an angle in degree, so I added the necessary unit.

Werner_E_0-1645011033466.png

The same principle could easily be applied to use spline interpolations instead of linear interpolations.

 

12-Amethyst
February 16, 2022

Thank you