![100 Top Tips: Microsoft Excel](https://www.sean.co.uk/assets/images/books-416/excel100.jpg)
100 Top Tips: Microsoft Excel
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
12 July 2024
For the latest issue of The MagPi, I've written a tutorial about creating new clocks and calendars with Python. I've been thinking recently about how Python can be used to improve your productivity, so for this article, I provided some examples of using the datetime module to represent time in useful and inspiring ways.
The article includes a "hello world" example that tells you how many days it is to Christmas. It then shows you how to make a calendar like the one shown on the right, where a bar graph shows how much of the current day, month and year has passed. (Or remains, depending on whether you're a calendar-half-full or calendar-half-empty kind of person). If you're working on goals with a deadline of the current month or year, this can help you to see how much of your available time has already passed, and how much is left.
The second example is a countdown clock, made by wiring up a four-digit seven-segment display to the Raspberry Pi's GPIO pins. By setting this to the end of the work day, you can see how much time is left at any moment. This helps you to choose the biggest task next that will fit in the time available, or can inspire a mild panic to get you moving if you are on an end-of-day deadline that's closing in too fast. With magazine listings, the idea is to keep the code simple. One enhancement I thought of, but didn't include, was for the clock to have different finishing times on different days, because some days I finish at different times to others.
You can download the code for these examples here, and can find issue 143 of The MagPi online or in your newsagent.
You might also be interested in my pomodoro timer for the micro:bit, which also features in my free Coding Compendium ebook.
Issue 143 of The MagPi also includes an article I wrote about Spin, a DJ deck that plays AI-generated music. You use buttons to choose the parameters you want for generating the music and can scratch it using a real record deck.
Permanent link for this post | Blog Home | Website Home | Email feedback
© Sean McManus. All rights reserved.
Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.
Code a space adventure game in this Python programming book published by No Starch Press.
Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!
Set up your Raspberry Pi, then learn how to use the Linux command line, Scratch, Python, Sonic Pi, Minecraft and electronics projects with it.
In this entertaining techno-thriller, Sean McManus takes a slice through the music industry: from the boardroom to the stage; from the studio to the record fair.