Skip to content

Instantly share code, notes, and snippets.

View adamamyl's full-sized avatar

adam mcgreggor adamamyl

72 followers · 95 following
View GitHub Profile
@adamamyl
adamamyl / IMPORTQUERY
Created September 29, 2015 21:12
Import selected stuff from another google doc
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PQe7nPK97toYYocbqMX7qn2_6F6w2FpW7Bf4waOLucw/edit#gid=1402173896", "Form Responses 1!A1:H500"), "SELECT Col2, Col7, Col3, Col4, Col5, Col6, Col8 where Col5 CONTAINS 'Decor'",1)
=QUERY(IMPORTRANGE("
https://docs.google.com/spreadsheets/d/1PQe7nPK97toYYocbqMX7qn2_6F6w2FpW7Bf4waOLucw/edit#gid=1402173896", // LINK TO SHEET
"Form Responses 1!A1:H500" // RANGE TO SELECT FROM
),
"SELECT Col2, Col7, Col3, Col4, Col5, Col6, Col8 WHERE Col5 CONTAINS 'Decor'",1) // NOTE, here, we can't use B, G, C, D etc -- convert to Col#
@adamamyl
adamamyl / gist:c8514ae427df9cbeffa4
Created August 7, 2015 11:41
for a given email address, find the lists they're subscribed to, and display the dates of the last post for each list
find_member githubgists@no2id.net | while read L
do
bin/withlist -r last_post ${L} 2>&1 | grep Last
done | column -t | awk '{print $9, $6, $7, $1}' | sort -h | column -t
@adamamyl
adamamyl / cpvg_hyperlink_mailto.php
Created August 1, 2015 19:15
Quick extension to https://wordpress.org/plugins/custom-post-view-generator to add mailto: links
@adamamyl
adamamyl / exit-bigv-console
Last active November 24, 2015 13:34
Exit sequence for BigV management console (ssh)
To close the serial console, you would typically type three characters in quick succession:
~ (tilde)
. (full-stop / period)
ENTER
@adamamyl
adamamyl / gdocs-gantt
Created May 28, 2015 14:07
gantt in gdocs
| # | C | D | G |
| 3 | Arrival Date | Departure Date | 2015-07-01 | 2015-07-02 | 2015-07-03 |
| 5 | 2015-07-03 | 2015-07-15 | 0 | 0 | 1 |
=IF(AND(G$3>=$C5,G$3<=$D5), 1, 0)
@adamamyl
adamamyl / stylize-openoffice-draw
Created May 23, 2015 22:11
Add styles (file) to Open/Libre Office draw xml files
for F in `ls *.fodg`; do
f="${F}-filter"
sed -n '/<\/office:automatic-styles>/,$p' "${F}" > ${f}
# styles.fodg contains the xml shite upto </office:automatic-styles>
# from a doc containing the styles sought/wanted to replicate
cat ../../styles.fodg ${f} > ${f}.out
mv "${f}.out" "${F}"
done
@adamamyl
adamamyl / list_lists-spit
Created May 18, 2015 12:31
list of lists
list_lists --bare | perl -ne 'chomp; print qq^<li><a href="/listinfo/$_">$_</a></li>\n^;' >> /path/to/index.inc
@adamamyl
adamamyl / gins-and-tonics-and-slices
Created April 28, 2015 11:44
gins, tonics, slice
gin | market | tonic | slice
--------------------|---------------------|----------------------------|--------
Beefeater | Domestic | Fever Tree Indian | Lemon
Beefeater | Imported | Indi | Lemon
Beeferater 24 | Domestic | Fever Tree Mediterranean | Lemon
Beeferater 24 | Imported | Indi | Lemon
Bloom | Domestic | Fever Tree Indian | Lemon
Bloom | Imported | Indi | Lime
Bombay Saphire | Domestic | Fever Tree Mediterranean | Lime
Bombay Saphire | Imported | Abbondio | Lime
@adamamyl
adamamyl / gdocs-translate
Created April 20, 2015 14:24
gdocs-translate
=IF(B5<>"", GOOGLETRANSLATE(B5, "EN", "ES"), "")
@adamamyl
adamamyl / gist:5cf73a86db9bfc0aab1f
Last active August 29, 2015 14:19
Who y'gonna call
Delivery Primary contact Secondary contact Tertiary contact
Site fuel (diesel, petrol) power rangers power lead site lead
Theme camp fuel relevant person in camp (not on radio) theme camp lead malfare shift lead (accio Nomad)
Ice Ice camper on duty No Info Malfare shift lead
Water Theme camp lead Any briefed volunteer (need to handle money) Site Lead
Deliveries if specific camp, them (not on radio) multiple camps: ?production site lead
Tow-Trucks Malfare Shift Lead (accio Nomads)
Police Site lead Malfare shift lead Board lead
Fire Site lead Malfare shift lead Board lead