Excel equation for Delta E Color

[AJBA940]

I need to calculate Delta E (?E*oo) on the Lab Color Spectrum for the samples given below. The equation is complex and I get lost when the tangents and degrees come in. Also, I'm not sure if the equation below has all the info, such as kL or Sc. Any help would be greatly appreciated!

 

[jmacleary]

Hello there and welcome to the forum. Without knowing the first thing about the subject, a google search for 'lab color spectrum formula in excel' came up with some hits the best of which seems to be Color calculations in Excel – rgbcmyk It is a free add-in which I think has the formulae you want. I hope it may help!