Bubblehunter95

• Excel Interpolate Table Worksheet
• Excel Interpolate Table Function
• How To Interpolate Between Two Numbers
• Excel Interpolate Table Lookup

Hi Guys,

1. The following Microsoft Excel formula performs linear interpolation by calculating the interpolation step value. A present or future value table.
2. As you can see, this also produces for splines, the interpolated results you're looking for. I don't have ready access to Excel's Analysis Toolkit, so I don't know if Excel's includes splines. If not, LO Calc will run in Windows and it's free. This covers the approaches you can use to interpolate the intermediate values.

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

Excel Linear Interpolation Linear interpolation in excel means forecasting or guessing the upcoming next value of any certain variable given on the current data, here we create a straight line which connects two values and we estimate the future value through it, in excel we use forecast function and a lookup function to do a linear interpolation. Linear Interpolation in Excel Let’s take a look at how to perform this analysis on some real data. The table below lists air density as a function of temperature in 20 degree Celsius increments. If we want to get data at any temperatures other than those in the first column, we’ll have to interpolate.

<colgroup><col><col><col span='16'></colgroup><tbody>

Excel Interpolate Table Worksheet

</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?

Excel Interpolate Table Function

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><col><col></colgroup><tbody>
</tbody>

How To Interpolate Between Two Numbers

Thanks,

Excel Interpolate Table Lookup

David