Delta E(cmc) formula
"Robert" wrote:
I finnally got it worked out. Say your standard is in cells A1 for L., A2 for
a., and A3 for your b. Your test sample is in cells B1 for L., B2 for a., and
B3 for the b.
Here is the formula I am useing note there may be other ways to write it but
I know this works.
=(((B1-A1)*(B1-A1))+((B2-A2)*(B2-A2))+((B3-A3)*(B3-A3)))^(1/2)
It could probably be written this way as
well=(((B1-A1)^(2))+((B2-A2)^(2))+((B3-A3)^(2)))^(1/2)
"Michelle7890" wrote:
Does anyone out there have the Delta E cmc formula for excel? I am trying to
set up a spreadsheet that compares colors of test samples to a reference
sample in a spreadsheet. But my excel skills are not this good.
Thanks,
Michelle
CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5
whe
SL = 0.040975L* / (1+0.01765L*) unless L < 16 when SL = 0.511
SC = 0.0638C*ab / (1+0.0131C*ab) + 0.638
SH = (fT + 1 - f)SC
whe
f = [(C*ab)^4 / {(C*ab)^4 + 1900)}]^0.5
T = 0.36 + |0.4 cos(hab + 35)|
unless h is between 164 and 345 degrees when
T = 0.56 + |0.2 cos(hab + 168)|
|