View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle7890 Michelle7890 is offline
external usenet poster
 
Posts: 8
Default Delta E(cmc) formula

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)|