In the time of APIs, python scrapers and other cool things, bookmarklets have fallen from favor but they still have uses and I still like them. For small jobs that you want to make accessible to people they are still really handy. In this scenario Middlebury has lots of ways to get roster information about […]
Category: Data
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
FotoFika Art Baseball Cards
Origin Story The 2020 All Stars project1 is tied to the FotoFika site supporting photography faculty teaching online due to COVID. One of the concerns that came up in discussions was that this year’s graduating class wouldn’t be getting the personal connections that normally happen during exhibitions. That led to a discussion around Mike Mandel’s […]
All the TAGS Twitter Avatars
I have someone who gathered a bunch of tweets for their research using Martin’s TAGS aggregator. She wanted to show all the avatars. Once I published the spreadsheet, here’s all the javascript needed to make that happen. It’s lightly annotated for your reading pleasure and the functioning codepen example is included below. var spreadsheetID = […]
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
Justify Your Year – 1 Page Front and Back
We’re getting a new supervisor in the near future so we were asked to write up a success/challenges<footnote>See how I made them opportunities? ABC baby. ABC. Or ABC if you’d prefer. I’m good with either.</footnote> sheet to give them an idea of what’s working for our various groups and what’s giving us problems. I thought […]
H Tags and Auto-Constructing an Anchor Index
Origin Story I got a fairly dense Word document that needed to go online in way that people could more easily navigate. After checking it out, it appeared we had a large number of sections but we were lucky in that they were designated by H tags of various levels. Now I could have gone […]
Read More… from H Tags and Auto-Constructing an Anchor Index
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 […]
Making an Index Using Javascript
Working with a faculty member we had a rather long page that was originally written in Google Docs. It had many sections that were (mostly) designated by H tags of various denominations. The goal was to and put it on a website quickly build an index of anchor links. I did not wish to do […]
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 […]