Excel Tools

Various tools in MS Excel, with full documentation

Finding the real roots of a 3rd order polynomial

v1.00 (Release date: May 10, 2025).

Calculates the real roots of a 3rd order polynomial.

See the related article on Medium.com

Download File (xlsx)


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

v3.00 (Release date: May 10, 2025), Available in Greek.

Calculates the date of the Orthodox Easter and relevant fests for a given year (between 1900 and 2099). 

Download File (xlsx)