I had an interesting question from a client recently about why should they pay my full rate (I charge hourly) for bug-fixes when they are my mistakes? Here is my response where I argue that bugfixing is an integral part […]
Check out the latest episode of “Totally Unscripted” with Bruce McPherson talking about the new Sheets API and Spencer Easton about OAuth.
Never miss a “domain expiry” email notification ever again! One of my websites was recently down for a couple of weeks without me noticing (it looks like the email notification got lost in the post). So to avoid this happening again […]
This is a very cool script from Robert Elison that uses Apps Script and Google’s Vision API to monitor a webcam for anything unusual: http://ithoughthecamewithyou.com/post/get-an-email-when-your-security-camera-sees-something-new-apps-script–cloud-vision
This is a bit of a twist on the typical burndown chart with a couple of extra features: Velocity = points/actual hours. As the number of hours I work in a “sprint” can vary, and it is just me which […]
This script creates a PDF file using a Google Doc template and the values in a Google Spreadsheet. It is a development of this script , where this one allows you to specify the name of the PDF in the […]
This is a fun little custom function that makes a best guess at the address of a place you give it. Take a look at this sheet which has the custom function GET_ADDRESS() in B2 and gets the address of A2. […]
OpenStack is a cloud-based OS that provides a RESTful API to storage it manages. This is a library I’ve developed that allows you to access that storage via Google Apps Script. Read more…
I’ve just made public the Google Spreadsheet I use for my personal finance management. Features: Schedule regular transactions: Automatically create the next 40 days transactions (to create projected cash flow over the next month). This needs a Google Calendar called “Regular Transactions” […]
