ProjectCalendar01

It’s a project calendar for keeping track of (a) which projects I’m working on and (b) when I’ve worked on them. That way I can easily see where my time is spent and possibly where I need to adjust things. (“Looks like I’m neglecting my writing. Time to fix that.”)

I started out using the back of my Field Notes notebook, since it has a handy grid, but I ran into a problem: when I finish the notebook, I no longer have my project calendar with me.

Enter Google Spreadsheets:

ProjectCalendar02

The grey boxes mean that the project has ended. Each month is its own sheet, which keeps things tidy. (Projects that end don’t need to be on the next month’s sheet.)

And the best part? It’s super easy to maintain. I can just copy and paste the black boxes, and when I start a new month, it only takes a few seconds to clear out the boxes and change the days of the week.

Speaking of tracking things, I forgot to blog about my writing log (which I used to use back when I was writing more frequently):

Writing Log

I’m also planning to make a grid-based log for scripture reading and family history and other church-related things I want to do more diligently.

Update: You can now download a Google Docs template of the project tracker.

Another update: There’s now a project page for this.