The power of the human voice is such that when someone called me up to ask me about the 2009 version of the Compact Calendar, I was so moved that I actually got off my butt to make it. Easier said than done; I said it would take about 15 minutes + about an hour to post. Four hours later, I’m finally done with tweaking, testing, download testing, virus scanning, packaging, and updating. It takes a bit of work to make sure these archives are clean…hopefully I didn’t miss anything. I almost posted a version that was off by one day…close call!
What Is It?
The Compact Calendar is my impromptu planning calendar, designed to be printed on paper from Excel. Print a bunch of these sheets out; it’s great for bringing to a meeting and sketching out a schedule on-the-fly. I keep a supply on hand when I’m actively out in the field. Unlike other calendars, it represents the months as a solid “bar of time”, which makes it easier to visualize how much time you really have. Plus, it just looks neat.
You can read more about the use and design of the Compact Calendar on the Compact Calendar Page.
I finally have a version that will update the entire calendar when you change the year field at the top of the spreadsheet, based on the work of Todd Foster. So now, it’s super easy to make new versions of the calendar yourself for any arbitrary year. Just remember to update the Holiday Table.
“Jenny” and Jim Service both submitted techniques for handling the automatic month labeling on the left side, and I’ve incorporated it.
There have been several other modifications submitted to me over the year, and I’ve tried to pick the ones that are simple to maintain (e.g. they don’t require additional Excel modules, or tricky hidden extra columns). Thanks everyone for your submissions!
Check It Out
You can download the 2009 version at the regular Compact Calendar Page. I have only updated the US version; the international versions are handled by independent bloggers and are not under my control at all. I just link to them!
You’ll need Office 1997 or later to open the Excel Templates. Personally I have been using Office 2007, so there may be some issues with earlier versions of Office that I don’t know about. Please leave a comment if you come across anything. For users of non-Office productivity suites, good luck!