Interpolation for Google Sheet

Download and use is free of charge

Nevertheless, I'm always going to appreciate donations

Download here

Interpolation for GSheet Add-on

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.