Spline Calculation Excel May 2026

Equation for i=3: h2*z2 + 2*(h2+h3)*z3 + h3*z4 = 6*(slope3 - slope2) → 2*z2 + 2*(2+3)*z3 + 3*0 = 6*(1 - (-0.5)) → 2*z2 + 10*z3 = 9

So: (z_1 = 0, z_2 = -1.92857, z_3 = 1.285714, z_4 = 0) For each interval ([x_i, x_i+1]): spline calculation excel

(x=1 to 2, h=1): a = 2 b = (3-2)/1 - 1/6*(2 0 + (-1.92857)) = 1 - (1/6) (-1.92857) = 1 + 0.32143 = 1.32143 c = 0/2 = 0 d = (-1.92857 - 0)/(6*1) = -0.32143 Equation for i=3: h2*z2 + 2*(h2+h3)*z3 + h3*z4