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

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
1        1000    100        12
1        1000    200        18
1        1000    300        21
1        1500    100        13
1        1500    200        17
1        1500    300        23
1        2000    100        15
1        2000    200        21
1        2000    300        28
2        1000    100        10
2        1000    200        19
2        1000    300        23
2        1500    100        14
2        1500    200        21
2        1500    300        24
2        2000    100        18
2        2000    200        26
2        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!

Answer 1

[Kevin Rawson]

help interp3