How to interpolate values in a matrix

[VSGobbo]

Is it possible to interpolate using the calcPad?
Example:
Matrix: M = [1; 10|2; 20|3; 30]
x value = 1,5
y value = ?
I tried the formulas "take","line" and "spline" but it didn't work.
Thank You

[strsthapa]

Note that x values are index(rows, columns) not the value in index

[VSGobbo]

Thank you for your help. It's working.

[strsthapa]

you can also define macro to interpolate using values in cells instead of index

[ralphinge123]

c

[ralphinge123]

can we get the ode of the macro ??

[VSGobbo]

'//Original data
y(k) = take(k; 1; 1.2; 1.4; 1.6; 1.8; 2.0; 3.0; 4.0; 5.0; 6)
x(k) = take(k; 0.2874; 0.3762; 0.4530; 0.5172; 0.5688; 0.6102; 0.7134; 0.7410; 0.7476; 0.7500)
'Roark formulas
'
y0 = ? {5}'Change this value'
#hide
N = 10'10 values'
x0 = 0
#for i = 1 : N - 1
#if y(i) ≤ y0 ∧ y(i + 1) ≥ y0 ∨ (y(i) ≥ y0) ∧ (y(i + 1) ≤ y0)
x0 = x(i) + (x(i + 1) - x(i))*(y0 - y(i))/(y(i + 1) - y(i))
#end if
#Loop
#show
x0