Reading a specific number from array/table?

1 次查看（过去 30 天）
Damir
Damir 2016-2-17
评论： Ashish Sheikh 2016-2-18
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!

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

采纳的回答

Ashish Sheikh
Ashish Sheikh 2016-2-17
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
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
Ashish Sheikh 2016-2-18
Do you mean that.. you want to round off the number and then perform linear interpolation ????

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by