Interpolation for Calc

Tags: Calc Extension

This Add-in contain function to solve interpolations and extrapolation tasks.

Description

The objective of this add-in is to create easy-call functions to interpolate and extrapolate.

Developed by: Manuel Astros (manuel.astros1980@gmail.com) July 2018

https://sites.google.com/view/interpolation/home

All functions were developed to behave in the same way that the interpolation add-in created by Jose Ivan Martinez Garcia for Excel.
It will make possible a kind of interoperability among LibreOffice-Calc, Google-sheet in interpolation matter.

The Help for the usage of this Interpolation Add in can be found published in http://personales.gestion.unican.es/martinji/Interpolation.htm

Packaged Functions included in this add-in until now:
interpo(x, XRange, YRange) Linear interpolation with one parameter and two source ranges
interpo2(x, y, Range) Linear interpolation with two parameters and a table source
cercha(x, Range, keyArg, v1, v2) Spline interpolation with one parameter and a table source range
cerchapi(Range, keyArg, v1, v2) Determine the initial slope (1st derivative) at the first point of first spline
cerchapf(Range, keyArg, v1, v2)     Determine the final slope at the last point of the last spline
cerchaci(Range, keyArg, v1, v2)     Determine the initial curvature (2nd derivative) at the first point of the first spline
cerchacf(Range, keyArg, v1, v2)     Determine the final curvature (2nd derivative) at the last point of the last spline


Others functions will be added time by time, until all function implemented in the original excel add-in are available in this one.

coming soon: video tutorial, cerchara, cerchamx and cerchamy

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 0.3 New functions were added 5.0 Linux, Windows CC-BY
    This release adds new functionalities to the add-in, listed as follow:
    • Determination the initial slope (1st derivative) at the first point of the first spline:

       cerchapi(Range, keyArg, v1, v2)

    • Determination the final slope at the last point of the last spline:

       cerchapf(Range, keyArg, v1, v2)

    • Determination the final slope at the last point of the last spline:

       cerchaci(Range, keyArg, v1, v2)

    •  Determination the final slope at the last point of the last spline:

       cerchacf(Range, keyArg, v1, v2)

     
    Download
  • 0.2 Cubic interpolation function was added cercha(x, Range, keyArg, V1, V2) 5.0 Linux, Windows CC-BY

     

    The idea of this release is adding new functionalities to the add-in, listed as follow:
    • The license was added to the installation package
    • Cubic interpolation with one parameter and a table source range was added:

       cercha(x, Range, keyArg, v1, v2)

     
    Download
  • 0.1 First release for interpolation and extrapolation functions 5.0 Linux, Windows CC-BY

    Packaged Functions included in this addin are:

    interpo: interpo(x, XRange, YRange)
    interpo2: interpo2(x, y, Range)

     

    Others functions will be added time by time, until all function implemented in the original excel add-in are available here.

     

    Coming soon: first two "Cerchas" functions will be added, for cubic interpolation.

     

     

    Download

Feedback

☆ ☆ ☆ ☆ ☆

Post your review

Reviews

No one has commented on this page yet.

RSS feed for reviews on this page | RSS feed for all reviews