Reading a specific number from array/table?

Hi!

I have this table from excel,

d[mm] stands for diameter in [mm], b1 is the coefficient for diameter. I want to create a script, in which I specify diameter d in [mm], and the the result is the coefficient from the second row. For example; d=40 -> (b1)=1,03

Thanks for your help!

Answer 1

[Ashish Sheikh]

If you are importing excel data which is like 2 x 9 matrix ...

if A is 2 x 9 array ... d =60 ( for which the coefficient to be found,) then

z=find(A(1,:)==d); y=A(2,z) ; % y is the coefficient

Enter the number to be searched as d and y is the coefficient

[Damir]

Thank you very much!

How about if d is somewhere in the middle, like d=33, then I want to pick the closest highest and lowest number from row 1 an use linear interpolation to determine b1 for d=33.

Example: d=33 -> 30 (b1=1.09) and 40 (b1=1.03) -> linear interpolation; 33 b1=1.072

[Ashish Sheikh]

Do you mean that.. you want to round off the number and then perform linear interpolation ????