Developing a Website using WordPress – Tasks and Timescales

Developing a website using WordPress is one way to simplify what can be a daunting and time-consuming task. I’ve attempted to simplify it even further by summarising the typical tasks involved and, most importantly, given you an idea of the time and hence the cost of each. You can then use this to help you […]


New version of Flubaroo for Google add-ons

The new version of Flubaroo (v12) is out to support the new Google add-ons, the replacement for the Google Script Gallery. Add-ons make Google Apps Scripts available via the Google Chrome Web Store.

Google UK search position tool

Most of the online search position tools are based on the global rather than the UK site, so when I found this spreadsheet that used and allowed comparative searches of different keywords I thought it was worth sharing (and you may have noticed I’m a  big fan of Google Spreadsheets): Good to get […]

Flubaroo v3.1 – Number range answers

A new version of the Google Apps Script quiz grader/marker, Flubaroo v3.1, has just been released. The main new feature is the ability to grade numeric answers within a specific numeric range, rather than only accepting a single value. Useful when you are only looking for an approximate answer, say when looking for the longitude […]

Google Sheet Color Scales

Color Scales Spreadsheet The Google Apps Script contained in this spreadsheet sets the background color of the cells in a selected range according to their numeric value. This is similar to the ‘color scales’ or color gradient feature in Microsoft Excel. The lowest number found in the selection is set to the low color, the […]

BTC-e Trade API is a Bitcoin Trading site that provides an API to make trades, get transaction history, etc. I’ve written a Google Apps Script that uses this BTC-e Trade API. As well as seeing the script itself by clicking on the link, I’ve created a simple web app that can do a “getInfo” and a “TransHistory” query. They […]


I was recently asking about an automatic quiz marking (that’s grading to our American friends) using Google Apps Script. It didn’t take me long to find out that this was a wheel that had already been invented; a flubaroo shaped wheel. So I’m hoping to be able to start contributing a few patches to this […]

Rose Task Manager (RTM) – v0.3.0

Rose Task Manager (RTM, formerly  RoseCMMS) is a team/collaborative task manager or simple project manager developed with Google Apps Script. It’s main features are: Customised Google form for entering tasks to the … Online and sharable Google spreadsheet task list Email notifications for new tasks and status updates Links with a Google calendar to provide […]

Backing up a website via SSH

I recently had to backup a WordPress site that I only had shell (SSH) access to – no fancy hosting admin panel. This can be used for any PHP/MySQL site. Backup the database Log into hosting server via SSH by downloading an SSH client like Putty. You’ll need the server name, and user name and […]

Collaborating with Google Drive

Google Drive is an incredible collaboration tool that I’ve been really impressed with. Here’s some of the things I’ve picked up along the way: Shared Team Folder To avoid having to share all files individually I generally create a single folder with the name of the team to be collaborated with, e.g. Finance, and set […]

Proudly powered by WordPress   Premium Style Theme by