More French Budget Complexities

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 […]

Read More… from More French Budget Complexities

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 […]

Read More… from Logging Time: A Song as Old as Time

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

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