Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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)|


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Delta E(cmc) formula

Hi Michelle,

I can definitely help you set up a spreadsheet that compares colors of test samples to a reference sample using the Delta E cmc formula in Excel. Here are the steps:
  1. Open a new Excel spreadsheet and label the columns as follows: L*, a*, b*, Ls, as, bs, DL, DCab, Dhab, CMC.
  2. Enter the L*, a*, and b* values for both the test sample and the reference sample in the first three columns.
  3. Calculate the SL, SC, and SH values for the reference sample using the formulas provided in the question.
  4. Enter the SL, SC, and SH values for the reference sample in the appropriate columns.
  5. Calculate the DL, DCab, and Dhab values for the test sample using the following formulas:

    Formula:
    DL L* - Ls
    DCab 
    = [(a* - as)^+ (b* - bs)^2]^0.5
    Dhab 
    = [(DCab)^- (DL)^2]^0.5 
  6. Enter the DL, DCab, and Dhab values for the test sample in the appropriate columns.
  7. Finally, calculate the CMC value for the test sample using the formula provided in the question:

    Formula:
    CMC = [(DL* / lSL)^+ (DC*ab cSC)^+ (DH*ab SH)^2]^0.5 
  8. Enter the CMC value for the test sample in the appropriate column.
  9. Repeat steps 2-8 for each test sample you want to compare to the reference sample.

That's it! You now have a spreadsheet that compares colors of test samples to a reference sample using the Delta E cmc formula in Excel. Let me know if you have any questions or need further assistance.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default Delta E(cmc) formula

Hi,

are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b for
example? The reason I ask is you have "unless h is between 164 and 345
degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us something,

A
1 SL
2 L
3 hab
4 ab
5 cSC
....


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Delta E(cmc) formula

Hi Shane,
The variables are based on the reference sample so I was hoping to determine
the formula for the entire sheet based on the reference. The spread sheet so
far has the reference and then the samples tested L, a and b. Here are the
fist few lines.
L a b
Master LT 28.63 2.04 4.08 28.99
Color 303 DARK BRONZE
Check L a b Delta E
1 1st 26.09 2.6 5.83 26.86
2nd 25.94 2.52 5.61 26.66
3rd 26.16 2.38 5.33 26.80
I was thinking it might be best to write a formula first for the h based on
the master data to determine which formula to use below. The formula for h is
the tangent to the -1 of (b/a) (this b and a are of the master reading). I
have no idea how to write this formula in excel.
Then from this I was hoping to be able to determine what T formula to use.
S sub L is also based on the L value of the master sample.
This website breaks down the formula really well but I just do not know how
to do these functions in excel (for example tan and cos and to the -1 power)
www.brucelindbloom.com/Eqn_DeltaE_CMC.html
Thank you so much,
Michelle


"Shane Devenshire" wrote:

Hi,

are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b for
example? The reason I ask is you have "unless h is between 164 and 345
degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us something,

A
1 SL
2 L
3 hab
4 ab
5 cSC
...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 690
Default Delta E(cmc) formula

Hi. Just some thoughts...

CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5


According to your link, the above equation is a little off.
You are missing the variable "l" and "c", but you merged them into the
variable name. I believe it should be...

CMC = [(DL* / (l*SL) )^2 + (DC / (c*SC) )^2 + (DH / SH)^2]^0.5

Note that there is no "ab" variable.

the tangent to the -1 of (b/a)


This is a math notation for the Arc Tangent, or inverse.
In Excel, it is the function ATAN()
Your link recommends using the function ATAN2() instead.

What are the values of l & c in your equations?

= = =
Dana DeLouis



Michelle7890 wrote:
Hi Shane,
The variables are based on the reference sample so I was hoping to determine
the formula for the entire sheet based on the reference. The spread sheet so
far has the reference and then the samples tested L, a and b. Here are the
fist few lines.
L a b
Master LT 28.63 2.04 4.08 28.99
Color 303 DARK BRONZE
Check L a b Delta E
1 1st 26.09 2.6 5.83 26.86
2nd 25.94 2.52 5.61 26.66
3rd 26.16 2.38 5.33 26.80
I was thinking it might be best to write a formula first for the h based on
the master data to determine which formula to use below. The formula for h is
the tangent to the -1 of (b/a) (this b and a are of the master reading). I
have no idea how to write this formula in excel.
Then from this I was hoping to be able to determine what T formula to use.
S sub L is also based on the L value of the master sample.
This website breaks down the formula really well but I just do not know how
to do these functions in excel (for example tan and cos and to the -1 power)
www.brucelindbloom.com/Eqn_DeltaE_CMC.html
Thank you so much,
Michelle


"Shane Devenshire" wrote:

Hi,

are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b for
example? The reason I ask is you have "unless h is between 164 and 345
degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us something,

A
1 SL
2 L
3 hab
4 ab
5 cSC
...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Delta E(cmc) formula

The l and c are both equal to one- it is a 1:1 ratio. The a and the b are the
measurements taken with the equipment in my spreadsheet below and are used to
calculate the delta C by taking the square root of the sample a squared plus
the sample b squared and the square root of reference a squared plus
reference b squared.

"Dana DeLouis" wrote:

Hi. Just some thoughts...

CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5


According to your link, the above equation is a little off.
You are missing the variable "l" and "c", but you merged them into the
variable name. I believe it should be...

CMC = [(DL* / (l*SL) )^2 + (DC / (c*SC) )^2 + (DH / SH)^2]^0.5

Note that there is no "ab" variable.

the tangent to the -1 of (b/a)


This is a math notation for the Arc Tangent, or inverse.
In Excel, it is the function ATAN()
Your link recommends using the function ATAN2() instead.

What are the values of l & c in your equations?

= = =
Dana DeLouis



Michelle7890 wrote:
Hi Shane,
The variables are based on the reference sample so I was hoping to determine
the formula for the entire sheet based on the reference. The spread sheet so
far has the reference and then the samples tested L, a and b. Here are the
fist few lines.
L a b
Master LT 28.63 2.04 4.08 28.99
Color 303 DARK BRONZE
Check L a b Delta E
1 1st 26.09 2.6 5.83 26.86
2nd 25.94 2.52 5.61 26.66
3rd 26.16 2.38 5.33 26.80
I was thinking it might be best to write a formula first for the h based on
the master data to determine which formula to use below. The formula for h is
the tangent to the -1 of (b/a) (this b and a are of the master reading). I
have no idea how to write this formula in excel.
Then from this I was hoping to be able to determine what T formula to use.
S sub L is also based on the L value of the master sample.
This website breaks down the formula really well but I just do not know how
to do these functions in excel (for example tan and cos and to the -1 power)
www.brucelindbloom.com/Eqn_DeltaE_CMC.html
Thank you so much,
Michelle


"Shane Devenshire" wrote:

Hi,

are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b for
example? The reason I ask is you have "unless h is between 164 and 345
degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us something,

A
1 SL
2 L
3 hab
4 ab
5 cSC
...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 690
Default Delta E(cmc) formula

L a b Delta E
Master 28.63 2.04 4.08 28.99


1st 26.09 2.6 5.83 26.86



Hi. ok. "lSL" is really "l*SL"
If I understand the equation, Your "Master" E is 28.99.
The "Delta E" for another reference (#1) should be a negative number
that is added to 28.99 to arrive at 26.86?
(E + Delta E = New E)

The way I understand it, your Delta E equation is a Square Root, and is
always positive. Hence, there is no solution.
Perhaps you can give some example on what is expected. Did you
calculate 26.86, or is that the expected answer?

= = =
Dana DeLouis


Michelle7890 wrote:
The l and c are both equal to one- it is a 1:1 ratio. The a and the b are the
measurements taken with the equipment in my spreadsheet below and are used to
calculate the delta C by taking the square root of the sample a squared plus
the sample b squared and the square root of reference a squared plus
reference b squared.

"Dana DeLouis" wrote:

Hi. Just some thoughts...

CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5


According to your link, the above equation is a little off.
You are missing the variable "l" and "c", but you merged them into the
variable name. I believe it should be...

CMC = [(DL* / (l*SL) )^2 + (DC / (c*SC) )^2 + (DH / SH)^2]^0.5

Note that there is no "ab" variable.

the tangent to the -1 of (b/a)


This is a math notation for the Arc Tangent, or inverse.
In Excel, it is the function ATAN()
Your link recommends using the function ATAN2() instead.

What are the values of l & c in your equations?

= = =
Dana DeLouis



Michelle7890 wrote:
Hi Shane,
The variables are based on the reference sample so I was hoping to determine
the formula for the entire sheet based on the reference. The spread sheet so
far has the reference and then the samples tested L, a and b. Here are the
fist few lines.
L a b
Master LT 28.63 2.04 4.08 28.99
Color 303 DARK BRONZE
Check L a b Delta E
1 1st 26.09 2.6 5.83 26.86
2nd 25.94 2.52 5.61 26.66
3rd 26.16 2.38 5.33 26.80
I was thinking it might be best to write a formula first for the h based on
the master data to determine which formula to use below. The formula for h is
the tangent to the -1 of (b/a) (this b and a are of the master reading). I
have no idea how to write this formula in excel.
Then from this I was hoping to be able to determine what T formula to use.
S sub L is also based on the L value of the master sample.
This website breaks down the formula really well but I just do not know how
to do these functions in excel (for example tan and cos and to the -1 power)
www.brucelindbloom.com/Eqn_DeltaE_CMC.html
Thank you so much,
Michelle


"Shane Devenshire" wrote:

Hi,

are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b for
example? The reason I ask is you have "unless h is between 164 and 345
degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us something,

A
1 SL
2 L
3 hab
4 ab
5 cSC
...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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


  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 690
Default Delta E(cmc) formula

Hi. At this web site...

http://www.brucelindbloom.com/index....taE_CIE94.html

If I fill in the first row with the following data.
28.63 2.04 4.08

and the second row with this data...
26.09 2.6 5.83

both that web site, and my excel calculate CMC(1:1) as 3.8379.
(based on the equations in the link)

Since you haven't received any equations, perhaps you can rephrase your
question / equation. I am not sure what 28.99 and 26.86 are, or how
they are calculated.

= = =
HTH
Dana DeLouis




Dana DeLouis wrote:
L a b Delta E
Master 28.63 2.04 4.08 28.99


1st 26.09 2.6 5.83 26.86



Hi. ok. "lSL" is really "l*SL"
If I understand the equation, Your "Master" E is 28.99.
The "Delta E" for another reference (#1) should be a negative number
that is added to 28.99 to arrive at 26.86?
(E + Delta E = New E)

The way I understand it, your Delta E equation is a Square Root, and is
always positive. Hence, there is no solution.
Perhaps you can give some example on what is expected. Did you
calculate 26.86, or is that the expected answer?

= = =
Dana DeLouis


Michelle7890 wrote:
The l and c are both equal to one- it is a 1:1 ratio. The a and the b
are the measurements taken with the equipment in my spreadsheet below
and are used to calculate the delta C by taking the square root of the
sample a squared plus the sample b squared and the square root of
reference a squared plus reference b squared.
"Dana DeLouis" wrote:

Hi. Just some thoughts...

CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5

According to your link, the above equation is a little off.
You are missing the variable "l" and "c", but you merged them into
the variable name. I believe it should be...

CMC = [(DL* / (l*SL) )^2 + (DC / (c*SC) )^2 + (DH / SH)^2]^0.5

Note that there is no "ab" variable.

the tangent to the -1 of (b/a)

This is a math notation for the Arc Tangent, or inverse.
In Excel, it is the function ATAN()
Your link recommends using the function ATAN2() instead.

What are the values of l & c in your equations?

= = =
Dana DeLouis



Michelle7890 wrote:
Hi Shane,
The variables are based on the reference sample so I was hoping to
determine the formula for the entire sheet based on the reference.
The spread sheet so far has the reference and then the samples
tested L, a and b. Here are the fist few lines.
L a b
Master LT 28.63 2.04 4.08 28.99
Color 303 DARK BRONZE
Check L a b Delta E
1 1st 26.09 2.6 5.83 26.86
2nd 25.94 2.52 5.61 26.66
3rd 26.16 2.38 5.33 26.80
I was thinking it might be best to write a formula first for the h
based on the master data to determine which formula to use below.
The formula for h is the tangent to the -1 of (b/a) (this b and a
are of the master reading). I have no idea how to write this
formula in excel. Then from this I was hoping to be able to
determine what T formula to use. S sub L is also based on the L
value of the master sample. This website breaks down the formula
really well but I just do not know how to do these functions in
excel (for example tan and cos and to the -1 power)
www.brucelindbloom.com/Eqn_DeltaE_CMC.html
Thank you so much,
Michelle

"Shane Devenshire" wrote:

Hi,
are DL, ISL, DC, ab, cSC, DH, SH and so on variables? Or is ab a*b
for example? The reason I ask is you have "unless h is between 164
and 345 degrees" but the only h you have is part of DH, SH, or hab.

How are all the variables laid out in the spreadsheet. Show us
something,
A
1 SL
2 L
3 hab
4 ab
5 cSC
...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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


  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default Delta E(cmc) formula

If you find out the answer to this please let me know I am working on the
same problem.

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


  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default Delta E(cmc) formula

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




  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default 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)|


  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 690
Default Delta E(cmc) formula

=(((B1-A1)^(2))+((B2-A2)^(2))+((B3-A3)^(2)))^(1/2)

Just to mention another way as a worksheet function: (I find easier to read)

=SQRT(SUMSQ(B1-A1,B2-A2,B3-A3))


Just to mention...you are using the formula..
[(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5

with a variable SL = 0.511

It was mentioned here a while ago that the equation does not appear
correct. There is no variable "lSL"
It appears to be something like:

(DL * / (L*SL))^2 ...etc
(C*SC)...etc

I may be wrong thou...

= = = =
Dana DeLouis



Robert wrote:

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I write an Excel formula for Delta E difference between col dragon_girl411 Excel Discussion (Misc queries) 7 May 4th 09 07:53 PM
Delta Variances by Period MrRJ Excel Discussion (Misc queries) 8 February 10th 09 09:51 PM
High Low Lines or Delta between two data sets Jeff Charts and Charting in Excel 1 July 19th 08 12:06 PM
convert numbers to positive and keep delta value nolenkw Excel Discussion (Misc queries) 3 August 11th 06 05:15 PM
greek symbol delta afdmello Excel Discussion (Misc queries) 1 October 23rd 05 07:31 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"