Merge multiple tables in one table
Hi,
I have several tables, each table is for a specific altitude, where torque is calculated based on a given temperature.
I need help to find a way to create 1 table that uses all the calculation from the other tables, where torque is calculated based on given temperature and altitude.
For example:
for altitude 4000 and temperature 30, torque is 93.2.
for altitude 6000 and temperature 25, torque is 90.5.
What If I want the torque for altitude 5000 and temperature 20, is there any way?
I provided a sample for better understanding.
Attachment | Size |
---|---|
performance.xlsx | 9.67 KB |
thanks
thanks
Double interpolation
You need a double interpollation on temperature and altitude.
Given you don't have many data points, you need assumptions. Please try this link as an example: https://www.box.com/s/1kfy1mqq1vfxymj9z3ba
Line 36, column 17 & 18 enter the temperature and altitude: the torque is calculated.
Hello, yes why not, please
Hello, yes why not, please give me the code.
Interpolation.
Yes, there is a way! you can do an interpolation . If you want the code to do an interpolation, just let me know.
If you rather prefer something more accurate... I have no idea.
I hope it helps