VB4
03-07-2022, 05:14 AM
Good Day All!
Would some kind person help me with my first VBA script, linear-interpolation.
After looking at some previous posts I am still finding issues with the boundaries of those scripts.
Problem: There is a sets of data that both vary that I need to complete the gaps for in the columns.
E.g. :
X
Y
1
10
3
14
5
16
7
?
10
22
12
23
15
28
16
30
18
28
Question: How can I create a VBA script to complete a linear interpolation, filling the missing data ?
Any help is much appreciated. :bow:
Thanks,
VB4
P.S. Also a double interpolation would be something I would like to develop further.
Would some kind person help me with my first VBA script, linear-interpolation.
After looking at some previous posts I am still finding issues with the boundaries of those scripts.
Problem: There is a sets of data that both vary that I need to complete the gaps for in the columns.
E.g. :
X
Y
1
10
3
14
5
16
7
?
10
22
12
23
15
28
16
30
18
28
Question: How can I create a VBA script to complete a linear interpolation, filling the missing data ?
Any help is much appreciated. :bow:
Thanks,
VB4
P.S. Also a double interpolation would be something I would like to develop further.