Reading a specific number from array/table?

Question

Damir 2016-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268672-reading-a-specific-number-from-array-table

评论： Ashish Sheikh 2016-2-18

采纳的回答： Ashish Sheikh

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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ashish Sheikh 2016-2-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268672-reading-a-specific-number-from-array-table#answer_210226

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

2 个评论
显示无隐藏无

Damir 2016-2-18

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 2016-2-18