Quote:
Originally Posted by grail
You did not answer the question about HOW you arrived at those figures?

DO you mean how I get the values? For the values 1,4,and 8, they are predefined. The desired output are based on this formula
(((xx2) * (xx3)) / ((x1x2) * (x1x3))) * y1 + (((xx1) * (xx3)) / ((x2x1) * (x2x3))) * y2 + (((xx1) * (xx2)) / ((x3x1) * (x3x1))) * y3
x = current ID;
x1 = the first known ID (second previous known ID); > 1
x2 = the second known ID (first previous known ID); > 4
x3 = the third known ID (next known ID); > 8
y1 = the first known value (the value of ID x1)
y2 = the second known value (the value of ID x2)
y3 = the third known value (the value of ID x3)