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.

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.

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.

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.

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.

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?

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.