Hi Guys,
I've recorded engine data and two of the variables recorded were engine speed and coolant temperature. To determine friction torque, the table below needs to be used:
<colgroup><col><col><col span="16"></colgroup><tbody>
</tbody>
The values in the main body of the table are friction torque. I would like to be able to calculate friction torque for a range of engine speeds and coolant temperatures. I think I have to interpolate the table to do this. How do I interpolate the table on Excel?
Below is a small sample of my spreadsheet. I would like a formula to calculate the friction torque by using the values in the engine speed and coolant temperature columns, and then using the table above. Any suggestions?
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Thanks,
David
I've recorded engine data and two of the variables recorded were engine speed and coolant temperature. To determine friction torque, the table below needs to be used:
Engine Speed | 400 | 800 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1800 | 2000 | 2200 | 2400 | 2600 | 2800 | 3000 | |
Coolant Temperature | |||||||||||||||||
-30.04 | 80 | 96 | 104.4 | 108.9 | 113 | 117.8 | 122.7 | 127.6 | 132.5 | 141 | 148 | 156 | 161.7 | 168 | 176 | 183 | |
-20.04 | 65 | 82 | 90.2 | 93.9 | 98.1 | 102.6 | 107.5 | 112 | 117.3 | 125 | 132.3 | 139.2 | 144.9 | 150 | 156.2 | 162 | |
-10.04 | 55 | 69 | 76 | 80.3 | 83.6 | 87.8 | 92 | 96.5 | 101 | 107.7 | 115 | 121 | 127.5 | 133.7 | 139.3 | 145 | |
-0.04 | 48 | 59 | 63 | 66.8 | 69.5 | 72.9 | 76.8 | 80.6 | 85 | 92.5 | 99 | 106 | 113 | 119.1 | 125.7 | 133 | |
9.96 | 45.5 | 54.3 | 58.7 | 60.8 | 62.7 | 66 | 69 | 72.9 | 77 | 85 | 92 | 100 | 106 | 112.5 | 119 | 125.5 | |
19.96 | 43.8 | 52.3 | 56.5 | 58.5 | 60.4 | 63.6 | 65.9 | 69.1 | 72.2 | 80.1 | 87.1 | 95 | 102.1 | 108 | 115 | 120.9 | |
29.96 | 42.2 | 50.3 | 54.4 | 56.3 | 58.1 | 61.2 | 63.5 | 66.5 | 69.5 | 77.1 | 83.9 | 91.5 | 98.3 | 104 | 110.5 | 116.4 | |
39.96 | 40.5 | 48.4 | 52.3 | 54.1 | 55.9 | 58.8 | 61 | 63.9 | 66.7 | 74 | 80.6 | 87.9 | 94.4 | 100 | 106 | 111.8 | |
49.96 | 39.3 | 43.8 | 46.6 | 48 | 49.3 | 51.5 | 53.2 | 55.5 | 57.6 | 63.1 | 68.2 | 73.9 | 80.5 | 86 | 92 | 100.3 | |
59.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
69.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
79.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
89.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
99.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
109.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 | |
119.96 | 38 | 39.2 | 40.8 | 41.8 | 42.7 | 44.1 | 45.4 | 47 | 48.5 | 52.1 | 55.8 | 59.8 | 66.5 | 73.2 | 80.9 | 88.7 |
<colgroup><col><col><col span="16"></colgroup><tbody>
</tbody>
The values in the main body of the table are friction torque. I would like to be able to calculate friction torque for a range of engine speeds and coolant temperatures. I think I have to interpolate the table to do this. How do I interpolate the table on Excel?
Below is a small sample of my spreadsheet. I would like a formula to calculate the friction torque by using the values in the engine speed and coolant temperature columns, and then using the table above. Any suggestions?
Coolant Temperature (°C) | Engine Speed (rpm) | Friction Torque (Nm) |
30 | 940 | |
30 | 940 | |
30.16 | 940 | |
30.16 | 937 | |
30.2 | 937.5 | |
30.5 | 938 | |
30.6 | 941 | |
30.6 | 941 | |
31 | 941 | |
31 | 940.5 | |
31 | 939 | |
31 | 938.5 | |
31 | 939.5 | |
31.9 | 940 | |
32 | 941.5 | |
32.5 | 942.5 | |
32.5 | 939 | |
32.5 | 939.5 | |
32.6 | 941.5 | |
33 | 942 | |
33.4 | 942.5 | |
33.5 | 943 | |
35 | 942 |
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Thanks,
David