Recreating Tufte’s famous weather chart using Google Sheets data and the Google Charts API. This chart encapsulates the historic min/max range, the normal range, the 2015 temperature and any occasions when the 2015 temperature was a record min or max.
These charts show the performance of all the teams that have competed in the Premier League since its inception, the 1992-93 season (Leicester highlighted blue as the current 2015/16 champions): AFC Bournemouth Arsenal Aston Villa See the dynamic version and read about how I created this chart in Excel in this in-depth tutorial I wrote. … Continue reading A history of the Premier League in 47 Excel charts
In this tutorial, you’ll learn how to add subscript or superscript characters in Google Sheets.
This is Annual Review number nine! That makes this the longest career stint I’ve had. Woohoo! 🎉 (Before this, I was a Forensic Accountant for eight years.) 2023 was a great year. Of course, it had its ups and downs, but my family and I are all healthy and safe, which is all that matters. … Continue reading 2023 In Review And A Look Forward To 2024
This post describes how I designed and ran an audience survey with over 1,700 responses, using Google Forms, Sheets, Apps Script, and ChatGPT. I’ll show you the entire process from end-to-end, including how I: Created a survey with Google Forms Used Apps Script to automatically say thank you to 1,700 respondents Analyzed the response data … Continue reading How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses