Blog

  • 79 – One Year Anniversary at Work

    Goal setting, hey. It’s a hard thing to create, but even harder to play out and actually achieve what you had intended. I believe there are a multitude of reasons why people struggle with this, one of which being the fear of failure. (Here’s a talk by a personal hero of mine, Rodney Mullen, if

    Read more

  • 78 – Goals for the New Year and Job

    I will delve into my reflection of the past year at my job in next week’s post, but this week is about looking forward. For today’s post, I want to outline what I’d like to achieve over this coming year. Well, really, I can keep this quite short — I plan and aim to be

    Read more

  • 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

Leave a comment