It’s always interesting to see how people do things in other places. Our school in France has a lot of non-standard things going on. This one is based on the idea that overtime and recuperation time (coming in late to make up for working longer) needs to balance out for each week that starts with […]
Tag: google sheets
Logging Time: A Song as Old as Time
As always occurs in places I work, we are looking to better log how we spend out time1 I do think it’s good to reflect on how you spend your time as an individual and as an organization. It’s also nice to be able to present aspects of that data with qualitative elements to paint […]
Extracting data using regexextract in Google Sheets
One of our tools has usage data that ends up being three items on one line. Each line of data is something like this 1. email@middlebury.edu 123. The first number doesn’t matter. I want the email address and the last number (which indicates usage hours). In the old days, I’d have rigged something together using […]
Read More… from Extracting data using regexextract in Google Sheets
Google Sheets JSON the Long Way
Ever since Google turned off direct access to the JSON data from Google Sheets, I’ve used a couple of App Script workarounds. They were a bit clumsy for what I was doing but better than re-writing the entire page. I find going through the whole oAuth and Google project process to be more hassle than […]
Filtering CSV in PHP
I got an email from a KQED reporter asking about this old post on importing CSVs into Google Sheets. The source data was big though and hosted on GitHub and they only wanted the California data. I thought that anything we did in Google Script was likely to time out so I built a little […]
Data Games with Google Sheets
This is for a workshop with students on Saturday. It’s a revision of a thing Jeff and I did a way back in 2018. I think I’ve come up with some improved examples and I’ve revised a few things. The goal is to let any skill level start to see how spreadsheets can be useful […]
Horizontally Combine Many CSV Sheets in Google Sheets
An odd request came in from a faculty member the other day. As part of their research they had 60 or so CSVs that they wanted combined horizontally. I have many ways to do it vertically but this was a new one. Each file was around 350KB so they weren’t huge and 60 isn’t a […]
Read More… from Horizontally Combine Many CSV Sheets in Google Sheets
Monthly Reporting, A Gravity Forms to Google Forms Love Story
Well not really but I’ll explain it anyway. Gravity to Google There are a number of plugins that tie Gravity Forms to Google Sheets but most (all?) of them rely on the ability to create an application to get authentication tokens. Many institutional accounts turn off that capability. VCU has turned that off. As a […]
Read More… from Monthly Reporting, A Gravity Forms to Google Forms Love Story
Persistent Check Off List
Origin Story We’re doing the Photography is Magic course again this semester. One thing we do the first week is go around and the room and students say a word that has something to do with their major, life etc. We also name some cliche image types from Instagram. We end up with a large […]
Google Sheets Data Flow
This is a pretty specific thing but the concepts ought to be broadly applicable and interesting for the 3 to 5 people who will end up reading this. It’s a fairly amusing blend of less standard Google Functions and a bit of Google Script to do something fairly decent that had been quite a bit […]