How to look for a value in an excel and/or interpolate it

Question

Alejandro Checa Bartolomé 2019-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455860-how-to-look-for-a-value-in-an-excel-and-or-interpolate-it

回答： Kevin Rawson 2019-4-13

在 MATLAB Online 中打开

Hi!

I have a big problem, that I am sure that has an easy solution but I can't find it...

I have an excel file of a gearbox with 4 columns (gear number, speed, torque, torque losses).

Well, what I need is to look for or interpolate the torque losses, based on the gear number, speed and torque. These parameters are calculated, so based on them I need a function that returns the corresponding torque losses.

The file looks like this:

Gear      Rpm    Torque    Losses
      1000    100        12
      1000    200        18
      1000    300        21
      1500    100        13
      1500    200        17
      1500    300        23
      2000    100        15
      2000    200        21
      2000    300        28
      1000    100        10
      1000    200        19
      1000    300        23
      1500    100        14
      1500    200        21
      1500    300        24
      2000    100        18
      2000    200        26
      2000    300        33

It is something like this, but for 6 gears and multiple RPM speed and torques. I obtain these three values from some calculations and then I need to receive the losses from the excel. In case the points are not in the excel (ex: gear:1, rpm:1250, torque:220) I would need to obtain the losses value by interpolation.

Thanks in advance!