Excel Tools

Various tools in MS Excel, with full documentation

Quadratic Interpolation (2nd order, with 3 points)

v1.00 (Release date: March 20, 2024), Available in English.

Given three points P1, P2, P3 with known coordinates (x1, y1), (x2,y2), (x3,y3), the quadratic interpolant is a second order curve which passes through these three points.
For a value xP in the interval, the value yP on the curve is calculated.

Download File (xlsx)


Bilinear Interpolation - Two independent variables

v2.00 (Release date: March 19, 2024), Available in English.

In mathematics, bilinear interpolation is an extension of linear interpolation for interpolating functions of two variables (e.g., x and y) on a rectilinear 2D grid. The key idea is to perform linear interpolation first in one direction, and then again in the other direction. Although each step is linear in the sampled values and in the position, the interpolation as a whole is not linear but rather quadratic in the sample location. Read more on Wikipedia

Download File (xlsx)


Linear Interpolation - One independent variable

v2.00 (Release date: March 19, 2024), Available in English.

Given two points P1, P2 with known coordinates (x1, y1), (x2,y2), the linear interpolant is the straight line between these points.
For a value xP in the interval, the value yP along the straight line is calculated.

 

Download File (xlsx)


Leap Year Calculation

v2.00 (Release date: March 19, 2024), Available in English.

Calculates the leap years of the calendar.

Download File (xlsx)


Pascha (Orthodox Easter) Calculation

v2.00 (Release date: March 19, 2024), Available in Greek.

Calculates the date of the Orthodox Easter and relevant fests for a given year. 

Download File (xlsx)