Excel “Short” to “Long” data reformatter
I'm not sure where I got the following file (a quick Google didn't…
Excel rolling-year calculations
Having found nothing online that helped, here is my attempt at…
iTunes Match analysis results
Using my script and a DRC meter (see here) I conducted a comparison…
Useful VBA pages for data sheet manipulation
http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx
http://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx
VBA code to test if a cell is all upper case
This tests to see if a cell is ALL UPPER CASE. If so, it replaces…
Avoiding issues when disconnected using ssh
To solve issues with broken pipes etc when connecting to remote…
iTunes Match Analysis Tool
Update - for the results of this on my iTunes library see here.
This…
Command for TFL bus wait times
curl -s http://countdown.tfl.gov.uk/stopBoard/55335 \
| tr '}'…