Interpolation for Google Sheet

Packaged Functions included:

• interpo: Linear interpolation with one parameter and two source ranges

• interpo2: Linear interpolation with two parameters and a table source

• cercha: Spline interpolation with one parameter and a table source range

• cerchapi: Determine the initial slope (1st derivative) at the first point of first spline

• cerchapf: Determine the final slope at the last point of the last spline

• cerchaci: Determine the initial curvature (2nd derivative) at the first point of the first spline

• cerchacf: Determine the final curvature (2nd derivative) at the last point of the last spline

• cerchara (Range, keyArg, v1, v2) Determine the curvature radius of the segments in the given points

• cercharaxy (Range, keyArg, v1, v2) Determine the centers of curvature coordinates of the segment, in the given points

• cerchap (Range, keyArg, v1, v2) Determine the slopes (1st derivative) at the given (well-known) points.

• cerchac (Range, keyArg, v1, v2) Determine the polynomial (spline) coefficient

• cerchacoef (Range, keyArg, v1, v2) Determine the polynomial (spline) coefficient respect to the origin of coordinates

• cercharea (Range, keyArg, v1, v2, w1, w2) Determine the area under splines until the Xs axis

• cerchamx (Range, keyArg, v1, v2, w1, w2) Determine the static moment under splines area respect the Xs axis

• cerchamy (Range, keyArg, v1, v2, w1, w2) Determine the static moment under splines area respect the Ys axis

• cercham2x (Range, keyArg, v1, v2, w1, w2) Determine the second static inertial moment under splines area respect the Xs axis.

• cercham2y (Range, keyArg, v1, v2, w1, w2) Determine the second static inertial moment under splines area respect the Ys axis.

• cerchap2 (Range, keyArg, v1, v2, w1, w2) Determine the inertial product under the spline with respect to the Xs and Ys axes.

• cerchaxg (Range, keyArg, v1, v2, w1, w2) Determine the longitudinal coordinate of the gravity center of the area formed under the spline.

• cerchayg (Range, keyArg, v1, v2, w1, w2) Determine the vertical coordinate of the gravity center of the area formed under the spline.