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

On the Fly Data Validation Values in Google Script

I’m helping the School in France do some payment logging. We have five different activity types with different payment increment rules . . . so if you’re teaching a class you have a minimum of 90 mins, a minimum step of 30, and a max of 150 mins. For Tutoring it’s 15 minute minimum, 15 […]

Read More… from On the Fly Data Validation Values in Google Script

Weekly Web Harvest for 2024-03-31

AI bots hallucinate software packages and devs download them • The RegisterSeveral big businesses have published source code that incorporates a software package previously hallucinated by generative AI. Not only that but someone, having spotted this reoccurring hallucination, had turned that made-up dependency into a real one, which was subsequently downloaded and installed thousands of […]

Read More… from Weekly Web Harvest for 2024-03-31

The overhead of scarcity

I’m reading a fantasy/sci-fi series called the Broken Earth.1 A theme running through it is the laws/rules that apply during times of environmental upheaval (fifth seasons). Essentially, it’s your basic post-apocalyptic, dystopian Earth with frequent geological turmoil that lead to hard times. As a result, they’ve got a bunch of rules (stone loreLore that’s carved […]

Read More… from The overhead of scarcity

Weekly Web Harvest for 2024-03-24

JavaScript Visualized – Promise Execution Models All The Way Down 3D DOM viewer, copy-paste this into your console to visualise the DOM topographically.A really different way of looking at the DOM h/t D’Arcy Stanford Prison Experiment: why famous psychology studies are now being torn apart  – VoxMany of the classic show-stopping experiments in psychology have […]

Read More… from Weekly Web Harvest for 2024-03-24