AVS Forum banner
1 - 11 of 11 Posts

·
Registered
Joined
·
12,934 Posts
Discussion Starter · #1 ·
Is there an excel calculator for grayscale that allows input of 10-pt grayscale xyY data and then returns dE's in various formulas (CIELUV, CIELAB, and CIE94)? I'd like to be able to calculate CIELAB and CIE94 dE's for grayscale data from ColorHCFR (xyY) without having to do one point at a time.
 

·
Registered
Joined
·
669 Posts

Quote:
Originally Posted by PlasmaPZ80U /forum/post/18136928


Is there an excel calculator for grayscale that allows input of 10-pt grayscale xyY data and then returns dE's in various formulas (CIELUV, CIELAB, and CIE94)? I'd like to be able to calculate CIELAB and CIE94 dE's for grayscale data from ColorHCFR (xyY) without having to do one point at a time.

Tom H's spreadsheet attached to the end of his Basic Guide has this for 20%-100% white readings. I assume he left out 10% because for most folks readings at that level are not going to be considered reliable/accurate.



cheers,



--tom
 

·
Registered
Joined
·
12,934 Posts
Discussion Starter · #3 ·
Thanks, I was able to get CIELUV and CIELAB to work, but for some % stimulus values of CIE94, I got the #### (#NUM!) message. Not sure how to fix it, especially since the worksheet is protected. 20, 30, 40, 70, and 80 show this error message, while the remaining ones worked fine.
 

·
Registered
Joined
·
669 Posts

Quote:
Originally Posted by PlasmaPZ80U /forum/post/18139491


Thanks, I was able to get CIELUV and CIELAB to work, but for some % stimulus values of CIE94, I got the #### (#NUM!) message. Not sure how to fix it, especially since the worksheet is protected. 20, 30, 40, 70, and 80 show this error message, while the remaining ones worked fine.

What are the xy coordinates that caused the errors?



--tom
 

·
Registered
Joined
·
12,934 Posts
Discussion Starter · #7 ·

Quote:
Originally Posted by TomHuffman /forum/post/18139976


Fixed.

Nice, it works perfectly now. Is the minimal perceptible difference for CIE94 higher than 1.0 for grayscale? Using this formula, I get two points with 1.0 dE and one with 1.3 dE. Those same points are well below 2.5 and 2.0 for CIELUV and CIELAB, respectively.
 

·
Registered
Joined
·
8,007 Posts

Quote:
Originally Posted by PlasmaPZ80U /forum/post/18140094


Nice, it works perfectly now. Is the minimal perceptible difference for CIE94 higher than 1.0 for grayscale? Using this formula, I get two points with 1.0 dE and one with 1.3 dE. Those same points are well below 2.5 and 2.0 for CIELUV and CIELAB, respectively.

CIE94 and CIELAB should be the same for grayscale. CIELUV will be a little higher. What value did you test?
 

·
Registered
Joined
·
12,934 Posts
Discussion Starter · #9 ·

Quote:
Originally Posted by TomHuffman /forum/post/18141488


CIE94 and CIELAB should be the same for grayscale. CIELUV will be a little higher. What value did you test?

I tested 40%, 80%, and 100% using CIE94.


40% (0.312051, 0.327233) 1.0

80% (0.313477, 0.33081) 1.0

100% (0.311976, 0.330588) 1.3


I didn't initially notice that CIELAB and CIE94 were the exact same for grayscale. So, this means a dE under 2.0 for both formulas is ideal for grayscale? I was thrown off by the 1.0 MPD for CIE94.
 

·
Registered
Joined
·
8,007 Posts

Quote:
Originally Posted by PlasmaPZ80U /forum/post/18141559


I didn't initially notice that CIELAB and CIE94 were the exact same for grayscale. So, this means a dE under 2.0 for both formulas is ideal for grayscale? I was thrown off by the 1.0 MPD for CIE94.

For grayscale 2.0 is about as good as it gets, visibly anyway. The MPD of 1.0 for CIE94 is for color only. This is because of the way CIE94 treats the relationship between lightness and chromatic errors. Since grayscale doesn't consider lightness, CIE94 and CIELAB are the same here.
 
1 - 11 of 11 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top