Sorting in the LCH Color Space: Sort Updates
See the previous post here: Sorting By Color in the LCH Color Space
Updating Luminance Rounding
At some point, I was rounding all my values to the nearest 10, 15, etc.
MROUND(I2,15)
I realized the sort looks visually smoother if Hue rounds up to the next increment.
CEILING.MATH(K2,20)
At the time, I left Luminance rounding to the nearest 15. Now, I've updated Luminance to round up to the nearest 10.
CEILING.MATH(I2,10)
Says me, it makes the sort look a touch smoother. Mostly, I just wanted the formulas to match.
MROUND 15 on top; CEILING 10 on bottom
Sorting Key
I added a sorting key so it's easier to sort the data.
Instead of using Excel's multilevel sort interface, I can just sort by 1 field. (Which is very helpful on my tablet.)
=B2&"-"&M2&"-"&TEXT(L2,"000")&"-"&TEXT(100-N2,"000")&"-"&TEXT(J2,"000.00")
Notes on making the sort work:
- I'm forcing leading zeros on the numbers:
TEXT(L2,"000") - Since Luminance is a reverse sort, and since Luminance ranges from 0-100, I did a quick transformation to invert the values:
TEXT(100-N2,"000")