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

3 views (last 30 days)
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.

Kevin Rawson on 13 Apr 2019
help interp3