Merge multiple tables in one table

chiidzzz

New member
Joined
Aug 28, 2012
Messages
11
Reaction score
0
Points
0
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.
 

Attachments

  • performance.xlsx
    9.7 KB · Views: 14
Thanks man it works.
How did you get the numbers of ka, kb, kc and kd? I have other charts to do.
Thanks again
 
Last edited:
Thanks man it works.
How did you get the numbers of ka, kb, kc and kd? I have other charts to do.
Thanks again
 
Got formula and coefficients from a free curve fitting service on the net.
Rather complicated.
Send as much data as you can for your other charts.
Use MediaFire.com for huge files.
 
Back
Top