I’ve been using the Things app to track all my personal todo’s and projects for a couple of years now. I love this beautifully simple Mac-assed Mac app and use it all the time.
I recently discovered how to get access to the Things database and was finally able to answer some questions about how I have been spending my time.
So, with that, here are some highlights of all my “Things” in 2020.
In 2020, I completed 108 personal projects. A project can be something small like “π Declutter 2nd floor”, medium like, “π³ Renew passport”, or big like “πΈ Convert my guestroom to the studio”. (I always include an emoji in my project name because somehow it helps motivate me.)
Some favorite completed projects of 2020 were “π³ Vote”, “π€ΉββοΈ Plan for best self”, “π§ Mental reorg”, and my favorite for 2020: “π¦ Corona?”
I canceled 9 projects, including “πΆ Home Gardening!”, “π Journaling”, the weird exercise kick of “π§π»ββοΈQi Gong” and “π₯Grav maga”, and the most fitting cancellation for 2020: “π¦ Holiday family plans”
I completed 11 projects to “fix” things, including “π Fix that slot under my door”, “π₯ Fix drums”, “π§ Fix that broken drawer in the kitchen”, and “βοΈ Basic blog fix up”
On a finer level, I completed 2565 individual tasks in 2020, or about 7 per day.
I canceled 521 tasks in 2020, about 1.4 per day.
At year’s end, I currently have 62 projects in progress. π€
For reference, here is a sample SQLite query to find all the projects created and completed in 2020.
SELECT title, date(creationDate, 'unixepoch') as start, date(stopDate, 'unixepoch') as stop from TMTask
WHERE type = 1
AND status = 3
AND date(creationDate, 'unixepoch') BETWEEN '2020-01-01' AND '2020-12-31'
ORDER BY creationDate