Excel equation for Delta E Color

A

AJBA940

New Member
Joined
Jan 27, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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!

1580153022109.png


CIE00 formula
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
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!
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Can Excel even calculate this equation?
Replies
9
Views
814
SomethngWicked
S
D
  • Question
Excel Word Link - part table Excel to Word, part Word to Excel
Replies
2
Views
352
NdNoviceHlp
NdNoviceHlp
B
  • Question
VBA/Macro (dynamic ranges) IF And Statement that uses interior color in column A and blank in column F
Replies
0
Views
649
blooeyez
B
M
  • Question
Creating Results Table + Hiding columns based on text in specific row
Replies
4
Views
726
MelissaBr
M
M
  • Solved
Using Excel to Mass E-mail (Outlook) with links in the body
Replies
4
Views
680
MixedUpExcel
M

Forum statistics

Threads
1,221,283
Messages
6,159,021
Members
451,531
Latest member
Ian Denney

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top