Interpolation for LibreOffice Calc
Interpolation for Calc Add-in
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.