In this video I demonstrate calculations of quantum harmonic oscillator in Excel.
For the best experience, I recommend viewing it full screen!
Lennard-Jones Potential Equation $$ V(r) = 4 \epsilon \biggl[ \biggl (\frac{\sigma}{r}\biggr)^{12} - \biggl (\frac{\sigma}{r}\biggr)^6 \biggr] $$
$$ \sigma = \frac{r_m}{2^{1/6}} $$
Here, epsilon is the energy minimum and r_m is the distance of the energy minimum.
Note the part of the equation inside the square brackets. Recall that negative energies represent a more favorable interaction. The attractive term (raised to the power of 6) is subtracted from the repulsive term (raised to the power of 12).