Archive for the 'Uncategorised' Category

Minimal elm program

Wednesday, February 8th, 2017

This is not the shortest Elm hello world program. But it is about as short as I can make an Html.program. Having written it, and read it, it felt somehow profound. Like a haiku.

Elm Cambridge first meetup: an overview of Elm

Monday, February 6th, 2017

Here are the Prezi ‘slides’ from my talk tonight at the first Cambridge Elm meetup

Elm support compiled into Universal Ctags

Monday, February 6th, 2017

I started this project to make vim-tagbar work with Elm. I use tagbar to get an overview of my source files (especially python); I like how it presents the scope of nested tags. I wanted that overview of my Elm modules too. ctags-elm got me started but exuberant ctags doesn’t let you define scoped tags in config […]

The Fridge-brilliance of Maybe

Monday, May 30th, 2016

I’ve been tinkering with Elm recently. It’s a typed functional programming language that reminds me of the Haskell I wrote during my PhD. And, it’s great fun. I wrote a toy application, and recently upgraded it to 0.17. Along the way I had an insight about the Maybe type which I try and to explain in context. […]

Get list of worksheets on the command line

Thursday, April 14th, 2016

Today I need to get a list of worksheets from a very large spreadsheet (~100 worksheets, many thousands of cells on each) quickly from the command line. My ruby script tried to parse the entire workbook and exploded all my RAM. Then I discovered grep -0 which prints matching occurrences only (each on a separate […]

Getting round the limitations of Excel VBA’s UsedRange function

Tuesday, April 5th, 2016

Turns out that the Excel VBA function UsedRange doesn’t always give the expected results. It gives you the range of cells that have ever been used. If you’ve formatted them, or they used to have values in that you’ve since deleted, you still get those cells. Today I wanted to iterate all cells in a […]

pip install rx

Tuesday, March 22nd, 2016

I just installed RxPy the Reactive extensions for Python, as you may guess from the title of this article. Well, that was easy. What next? Here’s a delightfully short program which does — ahem — something: It echoes stdin to stdout. Kinda. There are more newlines than I was expecting — an extra one after […]

Excel excess: how to remove unwanted styles with VBA

Friday, March 11th, 2016

Long story short, I just opened a workbook with 37,000 styles :(. Apparently this is a common problem). Allen Wyatt of ExcelTips suggests deleting non-builtin styles. But I had over 6,000 of those. And some of my user-defined styles are important! My solution is to remove any style whose name ends with a number, keeping […]

Keeping named files in bash

Monday, February 1st, 2016

It just took me way too long to solve this, so I’m going to write it up quickly: The Problem I have a file containing the basenames of spreadsheets that I want to keep in a directory structure. I want to delete all the other spreadsheets. There are levels of nested directories and the files […]

What do chameleons eat?

Sunday, June 28th, 2015

When this question comes up in a children’s book these days, what do the characters do? Zoe (and Beans) rushes inside to Google it. Which brings me to Mr Christmas and his flying teapot: All you do is refuel every thousand miles, and you can fly up to three times the speed of sound! Nic […]