You can see the terrain image in this spreadsheet. Having just released the Color Scale Add-on I was having a play around with a terrain generator and created this (fairly) high-res terrain in a Google Sheet! The terrain generation script is based on Hunter Loftis’ “Realistic terrain in 130 lines”, and just took a little tweaking to […]
Ever popular in the Script Gallery, Color Scale is now available as an add-on in the Google Web Store for adding to your own Google Sheets. The Color Scale add-on for Google Sheets sets the background color of the cells in a selected range according to their numeric value. This is similar to the ‘color […]
I’ve documented my techniques and best practices in developing Google Apps Scripts.
This is a little script to create a PDF file using a Google Doc template and the values in a Google Spreadsheet. It take the fields from the active row in the active sheet the script is contained in and using a Google Doc template (identified by TEMPLATE_ID) creates a PDF doc with these fields […]
Installation Guide – Demo Spreadsheet – Demo Form I’ve just released a new version of Rose Task Manager, a collaborative task manager that integrates Google Calendar with Google Sheets to provide regular task scheduling, plus other features: Now works with new Google sheets. Added Auto-record of start and stop time. When the status is changed to “in-progress” the time […]
This is a simple wrapper for the Google Apps Script library BetterLog, a logging library that allows you to specify different levels of trace and write them to a log sheet. My wrapper allows you to pass in the function name of the calling function and adds a little synaptic sugar by shortening the function […]
Here is a list of git commands for getting a project that you have already started working on locally up onto Github. Here are instructions on forking a repo – getting the first copy of the project your are interested in onto your computer. 1. Create the repo online Create the repo on github.com, along […]
I’ve just finished a sleek new photo gallery website for Lisa Davies, aka Lisa the Teapot, a freelance textile designer in West Wales. Check out the gallery on the front page, where she demonstrates some of the funky things she does with fibres. Her USP is her ‘ole school approach, taking it from plant/animal/mineral all […]