Single formula to return multiple column averages?

just a funny color game that is completely imperfect
RAL1000-9000_Mittelwerte-lin-quad-kub_122456.ods (35.2 KB)

1 Like

I am not that familiar with the German system. I find some humor that each is called a ‘standard’. thanks for sharing!

L* avg, a* avg, b* avg, R avg, G avg, B avg, at O, P, Q, S, T, U.

The visual perception of colors is scaled logarithmically, not linearly, depending on the light intensity/illuminance. Anyone can test this: 2% gray to 5% gray to 8% are easy to distinguish, but at 80% to 85% to 90% to 100%, it becomes difficult relatively to a white background.

1 Like

Perhaps of interest to those interested in studying the complexity of biological-physical optics/photonics:


The RAL colors are a set of printed cards that can be used to spectrally compare reflective surfaces, regardless of the light source. Both the card and the object, even if they look similar, reflect the same light spectrum. These RAL card sections thus refer both absolutely and relatively, not including the surface structure of the object, which has a significant influence on the perception of color.
There is naturally no reference for spectral emitters (RGB, CMYK, L*a*B, HAB, etc.), since each eye perceives spectral light differently, and even electronic photosensors have large tolerances.


A side note: Our two eyes perceive “colors” differently depending on the distribution and quantity of cones and rods, and only in the brain does a colored image of our individually perceived environment emerge.
The RAL spectrum has 9 (!) basic colors. RGB only 3, and CMYK only 4. They lack brown, gray, orange, and black and white. Also missing are infrared and ultraviolet. People with artificial lenses can see near UV radiation down to 200 nm. The natural lens of the human eye absorbs the UV spectrum shorter than about 400 nm.

1 Like

Interesting- I shoud look for a set of the printed cards to have for reference.

I find the entire subject of color, and color perception very interesting. I was going to upload my pyhton 3D scatter plot, but not an allowed format. I asked at GitHub the best way to place there, but never received an answer.

1 Like