Sorting in the LCH Color Space: Sort Updates

C. Kennedy -

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