Detox Site – Energy-conscious website breakdown

Screenshot of the carbon rating saying "Uh oh! This web page is dirtier than 99% of web pages tested."

The following is what I wrote for this year’s DLINQ Digital Detox. It was strange writing without footnotes. It’s also a lot less of my normal writing voice. I was writing for a bunch of strangers rather than you, my dear readers.1 It’s easy to use the web without thinking about it much. Modern processors, […]

Read More… from Detox Site – Energy-conscious website breakdown

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

A screenshot of the art-based 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 […]

Read More… from FotoFika Art Baseball Cards

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. See the Pen […]

Read More… from All the TAGS Twitter Avatars

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

Read More… from Justify Your Year – 1 Page Front and Back

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