2015 – Page 2 – By @mhawksey

Drawing squircles in Lau for WatchMaker (using WatchMaker functions)

July 14, 2015

I recently made a WatchMaker Android Wear watch face based on the ‘squircle’. This post covers the maths behind squircles and getting (x,y) co-ordinates for any given polar angle. Finally I reveal the secrets of functions in WatchMaker Lau script.

Getting the details of uploads to any YouTube channel into a Google Sheet

July 2, 2015

As of yesterday TED have uploaded 1,903 videos totaling 1,622,120 seconds of playtime which have been viewed 428,117,012 times and received 4,360,903 likes. This post highlights how to work with Google Apps Script advanced services and other Google API documentation

Using import.io authenticated data sources with Google Apps Script

July 1, 2015

Last year I wrote about how you can use Google Apps Script to integrate with import.io. In this post I look at using authenticated data sources for import.io with Google Apps Script

Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script

June 21, 2015

At the Association for Learning Technology (ALT) one of the core tools we use for membership management is CiviCRM. In this post I show you how we use Google Apps Script to automate reporting and analysis

Batch changing Google Sheet cell background colours with Google Apps Script

June 1, 2015

At ALT we use Google Sheets as an easy way to share and collaborate on draft event timetables. Recent examples are the ALT Annual Conference 2014 and the OER15 timetables. One of the reasons for publishing draft timetables using Google Sheets is we can get a static url for people to download it as PDFs […]

Becoming a watch maker

May 19, 2015

Find out how I got on creating a watch face for Android Wear only using my mobile phone.

Generate a PDF (csv/xlsx/ods) download/publish to the web link for new Google Sheets

April 30, 2015

Basic little Google Sheet template for generating download links of new Google Sheets in different formats including pdf, csv and xlsx

Creating a Twitter Question/Revision Bot using Google Sheets

April 29, 2015

My old colleague at Cetis, David Sherlock, posted a nice little ‘Twitter Question/Revision Bot’. This uses a .csv file of questions and multiple choice answers which get randomly tweeted out using a Python script. David designed the project with a Raspberry Pi in mind but also highlights it can be easily run on any Unix […]

4 Comments

How to explore the Twitter API without code using the console

April 23, 2015

The non tech savvy way to peel back Twitter and see the data in your tweets.

TAGSPresenter (alpha) – A Twitter/Google Sheets based presentation concept

April 15, 2015

Update: Didn’t go well but revised version on this I’ve used successfully is here and slides published here. Later today (2.30pmUTC) I’ll be presenting at #oer15 about Twitter in open education (tune in here). As I wanted to highlight the network effect of Twitter I wanted to engage not just the room, but leave ‘footprints’ […]