linear interpolation
DESCRIPTION
Linear InterpolationTRANSCRIPT
0 373.0200 156.1400 113.6600 93.1800 81.5
1000 73.71200 67.21400 62.41600 58.31800 55.0
New X
485 104.92 <-- using cell references217 152.46 <-- using named ranges150 210.30 KnownX blue cells700 87.34 KnownY green cells900 77.61
For an explanation of linear interpolation visit:
Air Velocity
Thermal Resistance
Interpolated Value
http://www.BlueLeafSoftware.com/Products/Dagra/LinearInterpolationExcel.php
0 200 400 600 800 1000 1200 1400 1600 1800 2000
0
50
100
150
200
250
Tabulated data
Interpolated data
Air Velocity [FPM]
Th
erm
al R
esis
tan
ce [
°C/W
]
FORECAST(E19,OFFSET($C$4,MATCH(E19,$B$4:$B$12,1)-1,0,2),OFFSET($B$4,MATCH(E19,$B$4:$B$12,1)-1,0,2))
0 200 400 600 800 1000 1200 1400 1600 1800 2000
0
50
100
150
200
250
Tabulated data
Interpolated data
Air Velocity [FPM]
Th
erm
al R
esis
tan
ce [
°C/W
]
FORECAST(E19,OFFSET($C$4,MATCH(E19,$B$4:$B$12,1)-1,0,2),OFFSET($B$4,MATCH(E19,$B$4:$B$12,1)-1,0,2))