ExcelBanter - Matrix and linear interpolation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matrix and linear interpolation (https://www.excelbanter.com/excel-discussion-misc-queries/115975-matrix-linear-interpolation.html)

Matrix and linear interpolation

Hi guys,
consider the following matrix:

A B C D E
G H
1 hv/bv g CLF CLx KLF KLx 3
200
2
3 0,250 15,000 0,75 0,43 1,8 1,24
4 50,000 0,77 0,33 1,65 1,16
5 100,000 0,8 0,24 1,59 1,11
6 300,000 0,9 0,07 1,56 1,11
7 0,500 15,000 0,9 0,76 1,08 1,04
8 100,000 0,97 0,68 1,07 1,02
9 300,000 1,1 0,6 1,05 1,02
10 2,000 15,000 0,87 1,3 0,94 1,12
11 100,000 0,81 1,15 0,89 1,07
12 300,000 0,8 1,5 0,79 0,9
13 4,000 15,000 0,68 1,2 0,9 1,24
14 100,000 0,51 1,03 0,81 1,12
15 300,000 0,5 1,33 0,64 0,83

without using VBA is it possible to find an expression that having the
G1 (3) value for hv/bv and H1(200) value for g returns the linear
interpoleted value of CLF, CLX, KLF and KLX in four cells?

For example given 3 for hv/bv and 200 forg should returns 0,665 for CLF
(=((0,81+0,8)/2+(0,5+0,51)/2)/2) and so on four the remaining three
parameters CLX, KLF and KLX.

Regards,
Claudio

Matrix and linear interpolation

Hi Claudio:

You can use the FORECAST() function to do a straight linear interpolation
between supplied data points. As its name implies, it is normally used to
extrapolate rather than interpolate.
--
Gary's Student

" wrote:

Hi guys,
consider the following matrix:

A B C D E
G H
1 hv/bv g CLF CLx KLF KLx 3
200
2
3 0,250 15,000 0,75 0,43 1,8 1,24
4 50,000 0,77 0,33 1,65 1,16
5 100,000 0,8 0,24 1,59 1,11
6 300,000 0,9 0,07 1,56 1,11
7 0,500 15,000 0,9 0,76 1,08 1,04
8 100,000 0,97 0,68 1,07 1,02
9 300,000 1,1 0,6 1,05 1,02
10 2,000 15,000 0,87 1,3 0,94 1,12
11 100,000 0,81 1,15 0,89 1,07
12 300,000 0,8 1,5 0,79 0,9
13 4,000 15,000 0,68 1,2 0,9 1,24
14 100,000 0,51 1,03 0,81 1,12
15 300,000 0,5 1,33 0,64 0,83

without using VBA is it possible to find an expression that having the
G1 (3) value for hv/bv and H1(200) value for g returns the linear
interpoleted value of CLF, CLX, KLF and KLX in four cells?

For example given 3 for hv/bv and 200 forg should returns 0,665 for CLF
(=((0,81+0,8)/2+(0,5+0,51)/2)/2) and so on four the remaining three
parameters CLX, KLF and KLX.

Regards,
Claudio