Instructions
Find the periapsis and apoapsis of the orbiting body of interest. Periapsis is the object's closest approach to the body it orbits, while apoapsis is the furthest the object gets from the body it orbits. For objects orbiting the Earth, these are the perigee and apogee; for objects orbiting the sun these are perihelion and aphelion.
As an example, for Venus's orbit around the sun, the perihelion is 107.5 million kilometers and the aphelion is 108.9 million kilometers.
Enter the values in two cells. Make sure the spreadsheet interprets the numbers as numbers and not text. Often this can be done by starting the entry with an equals sign.
In another cell, put the sum of the two values.
For the example problem, the sum will be 216.4 million kilometers.
In another cell, put the difference between apoapsis and periapsis.
For Venus, the aphelion - the perihelion = 108.9 - 107.5 = 1.4 million kilometers.
Enter the final calculation in another cell. The eccentricity is equal to the difference between apoapsis and periapsis divided by their sum.
For the example, this is 1.4 million kilometers / 216.4 million kilometers = 0.0065. That's nearly a circle.