Skip to content

Instantly share code, notes, and snippets.


Eric Mill konklone

View GitHub Profile
konklone / date differences in google spreadsheets.js
Created Apr 23, 2018
calculate date differences between two columns, for Google Apps Script / GSheets
View date differences in google spreadsheets.js
// Subtracts two dates, formatted as e.g. 2025-04-10T12:46:10
// Author: Eric Mill,
// columns with notBefore and notAfter dates
var startField = "D";
var endField = "E";
var resultField = "F";
// first sheet
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
View gist:3f8b8b2c3ac4dfee62af21ac2acd6021
konklone /
Created Jan 14, 2017
House and Senate URL extractor, needs to be in unitedstates/congress-legislators' scripts/ dir
#!/usr/bin/env python
import utils
import urllib
from utils import load_data, save_data
import io
import csv
def save_csv(header, rows, path):
output = io.StringIO()
View cat-food-dispenser.lua
-- The function get_name() should return a single string that is the name of the puzzle.
function get_name()
-- The function get_description() should return an array of strings, where each string is
-- a line of description for the puzzle. Surrounding text with asterisks will cause it to
-- be rendered in bold, something we use when mentioning a signal by name.
konklone / cert.rb
Last active Jun 29, 2019 — forked from pzb/sample-chain1.txt
generate a self-signed root, issuing intermediate, and end entity certificate and private key
View cert.rb
#!/usr/bin/env ruby
# Forked from
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
konklone /
Created Sep 11, 2016
old script for cleaning up subdomain exports, used to be
# -*- coding: utf-8 -*-
from sys import argv
import csv
import re
script, arg = argv
# Open the input raw subdomain list, the filtered output handle, and
# a file for likely-missing rows we'd like to take a second look at.

Intro to APIs at the FEC - May 2, 2016

An introduction to working with URLs, JSON, APIs, and open data -- without writing any code.

You will need

konklone /
Last active May 2, 2016
fec open data workshop notes
konklone / hell
Created Apr 18, 2016
scandinavian electronic music I have been listening to lately