Skip to content

Instantly share code, notes, and snippets.

View rmeekers's full-sized avatar

Rutger Meekers rmeekers

4 followers · 1 following
View GitHub Profile
@rmeekers
rmeekers / paletteSet.json
Last active July 26, 2023 12:49
Enter Digital Color Palette
{
"author": "Enter Digital – www.enterdigital.coop",
"description": "The official brand colours of Enter Digital.",
"palette": [
{
"name": "Base Brand Colours",
"description": "",
"colors": [
"#E0F378",
"#F5F5F5",
@rmeekers
rmeekers / node_red.json
Last active February 5, 2024 11:14
Node Red flow to monitor Eeve / Toadi to Home Assistant via MQTT (including auto discovery) - https://community.home-assistant.io/t/eeve-toadi-willow/405097
[
{
"id": "76106b40e1ce3c2f",
"type": "tab",
"label": "Toadi to MQTT",
"disabled": false,
"info": "",
"env": []
},
{
@rmeekers
rmeekers / Regex to split street into street, number and box
Created June 16, 2021 08:49
^(\w[\s\w\-\'.]+?)\s?((?:\d+(?:\s?-\s?\d+)?)\s?[a-zA-Z]?)(?:\s?-?\s?)?((?:\/|bus|Bus)\s?.+)?$
@rmeekers
rmeekers / vlookup_in_multiple_columns.md
Last active April 24, 2020 07:13
Google Sheet formula to do a vlookup in multiple columns

Assumptions:

  • value to look for is in cell C2
  • array to search in: 'email domains'!A:Y
  • value to retrieve is in column no 26 (Z)
=ArrayFormula(if(countif('email domains'!A:Y;C2)=0;"";index('email domains'!A:Z;sum(if('email domains'!A:Y=C2;row('email domains'!A:Y))); sum(if('email domains'!A:Y=C2;26)))))
@rmeekers
rmeekers / difference between straight and curly quotes.md
Created March 13, 2020 11:13
What's the difference between straight and curly quotes?

Straight quotes are the generic vertical quotation marks which are inserted via the quotes button on a keyboard. There are two variants:

  1. the straight single quote (') and 2 .the straight double quote (").

Curly quotes are the quotation marks used in good typography. There are two sets of curly quote characters:

  1. Single quotes: the opening single quote (‘) and the closing single quote (’)
  2. Double quotes: the opening double quote (“) and the closing double quote (”).

How to use these quotes in a text editor?

@rmeekers
rmeekers / convertXMLtoHtml.md
Last active September 24, 2019 12:39

This describes how you can convert an XML file to a simple HTML table. The table can then be copy/pasted into a Google Sheet for example for further manipulation.

Install Saxon

brew install saxon

Convert XML file to HTML

saxon -s:input.xml -xsl:stylesheet.xsl -o:result.html

Sample XSL

@rmeekers
rmeekers / Import CSV in Google Sheets.gs
Last active September 24, 2019 09:31
/**
* Set of functions to import CSV files into a Google Sheet
* Imports CSV as text, freezes the first row, sets it bold and removes empty rows and columns.
*/
var settings = {
CSVFolderID: '',
singleFileID: '',
CSVSeparator: ';'
}
@rmeekers
rmeekers / gist:69cb2ec85440b7709c75baebfd13b014
Created August 5, 2019 13:49
Atom replace element
<tag>[\s\S]*?</tag>
@rmeekers
rmeekers / Extract filename from URL in Google Sheets
Created April 4, 2019 17:29
=TRIM(RIGHT(SUBSTITUTE(A2;"/";REPT(" ";100));99))
@rmeekers
rmeekers / importNumberOfInternetUsersPerCountry.gs
Created June 6, 2018 09:28
Formula to import the number of internet users for a given country
/*
* Datasource: public Google Spreadsheet with internet user data:
* https://docs.google.com/spreadsheets/d/1uxPf0einHJxZqkTvXnFto0O8Q4Lxw9RBPKoBCV2idTE/edit
*
* In the example below, we expect one or more country codes (ISO 3166-1 alpha-2), separated by a pipe (|), in cell A2
*/
=
SUM(
QUERY(
IMPORTRANGE("1uxPf0einHJxZqkTvXnFto0O8Q4Lxw9RBPKoBCV2idTE";"Data!B:C");