Blog

  • 77 – Happy Holidays

    77 – Happy Holidays

    This is a brief message to say happy holidays, if you are in fact celebrating it. What would this post be without a Google Spreadsheet activity, so here it is; the Randomised Holiday Present Picker! Need a (very) last minute holiday present idea? Use this randomiser to generate some ideas. https://docs.google.com/spreadsheets/d/1wWKxHtIS1ojlObI6T_3bXMfFoM2QbA1nb9zOajFEpDw/edit?gid=0#gid=0 Here’s a brief breakdown…

    Read more

  • 76 – Preparing a Google Doc Calendar for 2025

    Premise This was something that I wish I had put time aside for during teaching that would have helped me cut down some time during planning. During the holiday of each term, I would sit down and plan the following term. This would involve reflecting on the term prior, how the students engaged, how their…

    Read more

  • 75 – Business Process Management Series: 2 BPMN Project Mapping (As-Is)

    This is the second post in the series of Business Process Management (BPM). Today, we get into the fun stuff — well, what I consider the fun stuff. This is where we take all of that initial hard work to understand the business’ needs, values, key stakeholders, operations, and how they are all interconnected, and…

    Read more

  • 74 – Updating an ARIMA Stock Market Predictor

    Back in October of this year (2024), I made a post about using an ARIMA Stock Market Predictor Model in Python. Today is an update of that predictor. This is essentially what data, science, and learning is all about, right? Reviewing and updating previous notions or ideas; see more in the continuing BPM series over…

    Read more

  • 73 – Business Process Management Series: 1 Project Outline

    If you had told me that I could spend hours mapping processes in my 30s when I was in high school, I would have actually believed you. I was always thinking about how to map steps out. This specifically came to mind as I was a huge skateboarding, gymnastics, and trampolining fan as I used…

    Read more

  • 72 – How to Create Professional Looking Google and Excel Spreadsheets

    When I watched this episode of Silicon Valley, I never felt more connected to a quote. Monica Hall’s criticism of Pied Piper is that “the whole thing feels engineered.” To be fair, the entire quote is “I mean, it’s not, it’s not the UX or the design or anything that you can tweak. It’s just…

    Read more

  • 71 – Streamline Your Schedule: Automating Timetable Swaps with Google Sheets

    In one of my current jobs, it’s my responsibility to track updates in timetables. For any event that we plan for, it’s necessary to have between 6 and 20 workers assigned on a day. However, given the nature of work, life, and competing priorities, some people will need to bow out from these events, leaving…

    Read more

  • 70 – How to Count Across Multiple Spreadsheets and Provide Summary Statistics in Google Sheets

    Premise Back in September of this year, I posted a blog about how to use INDIRECT to count across multiple spreadsheets using Excel. When I was creating this post, I actually developed 3 different approaches to it. This was due to the limited functionality that Google Sheets presents regarding INDIRECT, arrays, and maintaining COUNTIF across…

    Read more

  • 69 – AI Problems 2: Asking ChatGPT for Google Sheets Problems to Solve

    In a previous post, I was considering how people might be using AI to solve their problems, or potentially create interesting & efficient solutions that they were unable to develop within a particular timespan. With Ai easily within reach of those who understand how to engage with it, I believe that there is the internal…

    Read more

Leave a comment