Traducir el blog
Color's chart
Posted on abril 09, 2010 by Excel Pedro Wave
Users perceive colors by the sense of sight and you can't believe your eyes, can you?
In a modern monitor, LCD or LED type, the images are formed by the additive mixture from the basic colors Red (R), Green (G) and Blue (B), so technically known as the RGB color model.
The cone cells in our eyes are sensitive to colors. There are three specialized types in each of the basic colors. The green and red are seen with the same intensity, but the blue is perceived as one twentieth (1/20), wich allows the compression of images and videos in JPEG and MPEG formats, reducing the blue component without appreciating a substantial loss quality. But everything depends on having the sense of sight as much or little developed as those good painters, for whom this loss is important. The opposite occurs in those with color blindness and in severe cases come to confuse red and green, although they can see more shades of purple that people with normal vision and are able to distinguish some hidden objects.
The levels of RGB for each color grade ranging from minimum 0 to maximum brightness level of 255, so a single point of light can be altered by 16,777,216 (256x256x256) different values of RGB, from (0,0,0) to (255,255,255), which is sufficient for 24-bit monitors, but they tend to be 32 bits, up to 4,294,967,296 colors (although usually 8 bits per RGB value and 8 bit alpha transparency, depending on the graphics card . To do this using other color models such as CMYK (for its initials in English Cyan Magenta Yellow blacK) with different color depths. The colors of the web pages as you're seeing now are generated using HTML color codes representing their respective RGB values.
In short, that "nothing is truth, nothing is lie, it all depends on the eye of the beholder", but what is not acceptable is that the professionals of user-centered design use a non-standard and variable color palette and not follow the technical and legal requirements officially established. And it occurs more often than it should be by negligence or by the damn hurry.
As a little colorful exercise, I'm attaching three Excel sheets with the flags of India, Spain and Europe, with the official colors of their respective countries:
The Royal Decree 441/1981 of 27 February, technically specifies the colors of the Spanish Flag:
And it also indicates a tolerance of 5 CIELAB units, so the Spanish Flag is made of more than two colors, as many as drapes and shapes of the pieces of cloth with which hardens the skin of a bull that is Spain.
For those of you that do not have a professional drawing program and need to convert colors in different models, you can visit The Coloring Pages that I used to so not to confuse between amalgam of all colors.
In a modern monitor, LCD or LED type, the images are formed by the additive mixture from the basic colors Red (R), Green (G) and Blue (B), so technically known as the RGB color model.
The cone cells in our eyes are sensitive to colors. There are three specialized types in each of the basic colors. The green and red are seen with the same intensity, but the blue is perceived as one twentieth (1/20), wich allows the compression of images and videos in JPEG and MPEG formats, reducing the blue component without appreciating a substantial loss quality. But everything depends on having the sense of sight as much or little developed as those good painters, for whom this loss is important. The opposite occurs in those with color blindness and in severe cases come to confuse red and green, although they can see more shades of purple that people with normal vision and are able to distinguish some hidden objects.
The levels of RGB for each color grade ranging from minimum 0 to maximum brightness level of 255, so a single point of light can be altered by 16,777,216 (256x256x256) different values of RGB, from (0,0,0) to (255,255,255), which is sufficient for 24-bit monitors, but they tend to be 32 bits, up to 4,294,967,296 colors (although usually 8 bits per RGB value and 8 bit alpha transparency, depending on the graphics card . To do this using other color models such as CMYK (for its initials in English Cyan Magenta Yellow blacK) with different color depths. The colors of the web pages as you're seeing now are generated using HTML color codes representing their respective RGB values.
In short, that "nothing is truth, nothing is lie, it all depends on the eye of the beholder", but what is not acceptable is that the professionals of user-centered design use a non-standard and variable color palette and not follow the technical and legal requirements officially established. And it occurs more often than it should be by negligence or by the damn hurry.
As a little colorful exercise, I'm attaching three Excel sheets with the flags of India, Spain and Europe, with the official colors of their respective countries:
The Royal Decree 441/1981 of 27 February, technically specifies the colors of the Spanish Flag:
| Color | Color Name | Tone ºH | Croma C | Lightness L |
|---|---|---|---|---|
| Yellow | Flag Weld-Yellow | 85.0 | 95.0 | 80.0 |
| Red | Flag Red | 35.0 | 70.0 | 37.0 |
And it also indicates a tolerance of 5 CIELAB units, so the Spanish Flag is made of more than two colors, as many as drapes and shapes of the pieces of cloth with which hardens the skin of a bull that is Spain.
For those of you that do not have a professional drawing program and need to convert colors in different models, you can visit The Coloring Pages that I used to so not to confuse between amalgam of all colors.
Traducción al español aquí.
Suscribirse a:
Enviar comentarios (Atom)
Mi lista de blogs
-
-
Transferring different data types to/from Python with pyxll - When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decora...Hace 1 día
-
Audité 4 archivos de Excel generados por IA. El resultado me sorprendió - Si alguna vez le pediste a ChatGPT, Claude, Gemini o Copilot que te generara un archivo de Excel y no […] The post Audité 4 archivos de Excel generados p...Hace 2 días
-
Curso gratis de Excel inicial - Curso gratis de Excel inicial Accede gratis y completa las historias, ejercicios y test en este recurso que te comparto con Kahoot!: https://create.kahoo...Hace 3 días
-
GENERAR IMAGEN A PARTIR DE TEXTO CON GPT – IMAGE EN AZURE FOUNDRY Y MOSTRARLA EN POWER APPS - Hola a todos!! Hace unas semanas, GPT empezó a permitir algo especialmente interesante: generar imágenes directamente a partir de lenguaje natural. Es de...Hace 4 días
-
Unas recurrencias muy útiles - Quienes usamos a menudo los números poligonales nos encontramos con esta relación de recurrencia de tercer orden: xn= 3xn-1-3xn-2+xn-3 El origen de esta...Hace 1 semana
-
Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002] - This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or no AI help o...Hace 1 semana
-
Cronograma de Obra MS Project: Guía Práctica para Construcción (18 minutos) - { "@context": "https://schema.org", "@type": "Article", "headline": "Cronograma de Obra en MS Project Paso a Paso: Guía Práctica para Construcción", "descr...Hace 2 semanas
-
Relojes de 24 horas y de 12 horas AM/PM - 🔝*To translate this blog post to your language, select it in the top left Google box. * Cómo aprender a usar relojes de 24 horas He visto que quien...Hace 2 meses
-
📒 Cómo separar textos dentro de una misma columna y agrupar fechas y horas con Power Query en Excel 💪🏽 - 📒 Cómo separar textos dentro de una misma columna y agrupar fechas y horas con Power Query en Excel 💪🏽 En muchos escenarios de análisis de datos, especi...Hace 3 meses
-
9 Interesting Examples With PY Function in Microsoft Excel - These are the most interesting PY function tasks in Microsoft Excel that’ll surely make you a fan! The PY function in Microsoft Excel opens up an exciting ...Hace 4 meses
-
Build a Daily Events Calendar in Excel - Use my Excel events calendar to track meetings and events inside a workbook. Add your upcoming events to a list, set a start date, and then see those items...Hace 4 meses
-
Mostrar datos de dos celdas en un cuadro de texto de Microsoft Excel - En Microsoft Excel es posible vincular el contenido de una celda a un cuadro de texto o a una forma. Vincular contenido de cuadro de texto a valor de cel...Hace 6 meses
-
Cómo hacer gráficos en Excel - Excel es una de las herramientas más potentes y versátiles para el análisis y la presentación de datos. Los gráficos en Excel no solo ayudan a visualizar...Hace 1 año
-
Fin - Llevo tiempo pensando esta entrada y no sé que decir. Analisis y Decisión nació en 2008 y no ... Leer más »Hace 1 año
-
Análisis DAFO (FODA, DOFA) las decisiones con Excel - Para conocer la situación de una empresa, proyecto o persona, recurrimos al análisis DAFO (FODA, DOFA) en la toma de decisiones con Excel. El los años sese...Hace 1 año
-
Color, Conditions, and Copilot: How to save time using conditional formatting with Copilot in Excel - Hi everyone, this is part 11 in a series of posts to show you some of the things that are possible to do with Copilot in Excel. *What is conditional f...Hace 1 año
-
How To Predict Bearing Life With Excel - When you work in mechanical engineering, understanding the reliability and performance of bearings under various conditions is crucial. Bearings are the co...Hace 1 año
-
TikTok’s search evolution - 2 in 5 Americans use TikTok as a search engine. Nearly 1 in 10 Gen Zers are more likely to rely on TikTok than Google as a search engine. More than half of...Hace 2 años
-
Unblocking and Enabling Macros - When Windows detects that a file has come from a computer other than the one you're using, it marks the file as coming from the web, and blocks the file....Hace 3 años
-
-
-
La importancia de saber mecanografía en 2022 - [image: Resultado de imagen de mecanografía viñeta escribiendo a máquina] Según la RAE, la mecanografía es el arte de escribir a máquina. Hace unos cuantos...Hace 4 años
-
London Excel Meetup Workbooks - The workbooks used in my presentation on “Analytical and Interactive Dashboards in Excel” at the London Excel Meetup, September 3, 2020Hace 5 años
-
Cálculo de jornada que termina al día siguiente (Power Query) y despedida - [image: Cálculo de jornada que termina al día siguiente (Power Query) y despedida]Hace 6 años
-
International Keyboard Shortcut Day 2019 - The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient...Hace 6 años
-
Welcome, Prashanth! - Last March, I shared that we were starting to look for a new CEO for Stack Overflow. We were looking for that rare combination of someone who… Read more "W...Hace 6 años
-
Visualize parts and whole - combine clustered column and stacked column charts - *Inga: Disa what?* *Igor: -ppeared.* by The FrankensTeam ------------------------------ Really it was 3 years ago we posted our last article? *Freddy: Th...Hace 7 años
-
Salvador Sostres, analfabeto profesional - Los nuevos tiempos traen nuevas profesiones. Internet, además, ha revolucionado el mundo del periodismo y la palabra escrita. Adaptarse o morir, ese es el ...Hace 8 años
-
Planificación de compras - Realizar una lista con los productos que necesitamos y que formarán parte de nuestra cesta de la compra nos ayuda a *encontrar la combinación de bienes p...Hace 13 años
-
-
-
-
-
-
-
-
-
2 Response to "Color's chart"
Buenos dias mi nombre es Juan, les escribo porque me gustaría un poco de ayuda del a mi problema. En una hoja de Excel he añadido un gráfico y tiene a su vez que he creado un reloj análogo que funciona bien. El problema se encuentra en el hecho de que en lugar de los clásicos números que componen las horas y minutos del día. He añadido diamantes blancos. Ahora deseo a cada extremo de los cinco minutos, el diamante, que corresponde a ese minuto que revela roja. Cómo puedo obtener todo esto; Además me gustaría que fuera no sólo técnica sino también práctica, por lo que puedo entender todos los pasos que se han creado para llevar a cabo estas acciones. Ya que no tengo mucha práctica con estas carta gracias de antemano por cualquier ayuda que me va a dar Saludos sinceros desde Maurizio a.
Hola Maurizio,
Tu solicitud de ayuda la puedes dirigir al grupo de usuarios del Foro de AyudaExcel
que te atenderán muy bien si subes un ejemplo de tu plantilla como la tengas preparada, explicando lo que quieres conseguir.
Es totalmente gratis hacerte usuario y hacer preguntas y ayudar a la comunidad de usuarios de Excel.
Un saludo,
pedrowave
Leave A Reply
Comenta este artículo, critícalo o avisa si detectas algún error que haya que corregir.