Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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)| |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I write an Excel formula for Delta E difference between col | Excel Discussion (Misc queries) | |||
Delta Variances by Period | Excel Discussion (Misc queries) | |||
High Low Lines or Delta between two data sets | Charts and Charting in Excel | |||
convert numbers to positive and keep delta value | Excel Discussion (Misc queries) | |||
greek symbol delta | Excel Discussion (Misc queries) |