I'm doing some writing on design languages at the minute and, in an aside, I talked about working for UK local governments in a previous job. At that time, we used to be tasked with making the primary thematic colour purple because no political party used it. This usage was in the days before the rise of UKIP you see. Anyway, a purple cloth used to be reserved solely for royalty because of the die's exorbitant cost. Finding a list of the colours of all UK political parties on Wikipedia got me thinking about the amount of scripting I'm doing in the context of the 1000 miles in 2021 challenge. So I copied the table from Wikipedia and threw it into a Google Sheet. I converted the colour names into their HEX values then converted them to HSL so that I could sort them properly. Sorted first by Lightness, then Saturation and finally by Hue - I finally output an HTML link which I could display. The following is the sheet script I used to generate the links, and the result is above.
const RGBToHSL = (r,g,b) => {
// Make r, g, and b fractions of 1
r /= 255;
g /= 255;
b /= 255;
// Find greatest and smallest channel values
let cmin = Math.min(r,g,b),
cmax = Math.max(r,g,b),
delta = cmax - cmin,
h = 0,
s = 0,
l = 0;
// Calculate hue
// No difference
if (delta == 0){
h = 0;
}
// Red is max
else if (cmax == r) {
h = ((g - b) / delta) % 6;
}
// Green is max
else if (cmax == g) {
h = (b - r) / delta + 2;
}
// Blue is max
else {
h = (r - g) / delta + 4;
}
h = Math.round(h \* 60);
// Make negative hues positive behind 360°
if (h < 0){
h += 360;
}
// Calculate lightness
l = (cmax + cmin) / 2;
// Calculate saturation
s = delta == 0 ? 0 : delta / (1 - Math.abs(2 \* l - 1));
// Multiply l and s by 100
s = +(s \* 100).toFixed(1);
l = +(l \* 100).toFixed(1);
return ["hsl(" + h + "," + s + "%," + l + "%)", h, s, l];
}
const hexToRGB = hex => hex.replace(/^#?([a-f\d])([a-f\d])([a-f\d])$/i, (m, r, g, b) => '#' + r + r + g + g + b + b).substring(1).match(/.{2}/g).map(x => parseInt(x, 16))
const myFunction = () => {
const returnSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1')
const rowCount = returnSheet.getLastRow()
for (let i = rowCount; i > 1; i--) {
const rawValue = returnSheet.getRange('C' + i).getValue()
const c = hexToRGB(rawValue)
const hsl = RGBToHSL(...c)
const url = returnSheet.getRange('B' + i).getRichTextValue().getLinkUrl()
returnSheet.getRange('D' + i).setValue(rawValue.toUpperCase())
returnSheet.getRange('E' + i).setValue(c[0])
returnSheet.getRange('F' + i).setValue(c[1])
returnSheet.getRange('G' + i).setValue(c[2])
returnSheet.getRange('H' + i).setValue(hsl[0])
returnSheet.getRange('I' + i).setValue(hsl[1])
returnSheet.getRange('J' + i).setValue(hsl[2])
returnSheet.getRange('K' + i).setValue(hsl[3])
if(url){
returnSheet.getRange('L' + i).setValue(`<a href="${url.replace('/meta/shortname', '').replace('Template:', '')}" target="\_blank" style="background-color:${rawValue.toUpperCase().trim()};width:1px;" title="${returnSheet.getRange('B' + i).getValue()}"></a>`)
}
}
}
Top comments (0)