(last edited on April 29, 2014 at 1:25 am)
I’ve uploaded the updated Compact Calendar for 2011 to its own special page. For those of you who haven’t seen it, it’s a single-page calendar in the form of a vertical strip that I call a “candybar of time”. I use Microsoft Excel to calculate all the dates so you can print it out and use it for whatever you need.
The Compact Calendar is great for planning meetings, since the candybar of time helps visualize the time you have available more intuitively. I’ve heard of people who also keep a stack of them handy for impromptu planning at home, using the refrigerator as its home base.
New Features for 2011
I’ve included a new extended calendar as a convenience for people who need to plan past the end of the year. Also, there is a new week starting Saturday template, for Arabic countries that are using that standard.
I’ve made a few tweaks to the Holiday table, mostly to make it just a bit more bulletproof when editing values. Other than that, it should work just like it did last year. If you need to generate a calendar for any year, just type it in the year box at the upper right of the “Calendar” worksheet, and everything will automagically calculate.
Internationalization
Every year generous individuals create versions of the Compact Calendar for their own countries. If you’ve made one for 2011, upload a ZIP file to your website and write a blog post about it; I’ll link it to the main Compact Calendar page here so others can find it. Just leave a comment here, or shoot me an email to let me know about it.
Download and More Information
Download USA 2011 by Dave Seah w/ major US holidays.
For the International Calendars for 2011, please visit the Official Compact Calendar Page. You can also find the design and usage notes there if you’d like to know more about how the Compact Calendar works. Enjoy!
7 Comments
Thank you for providing the compact calendars. I modify to my use by adding column headings for various categories of annual or quarterly events/actions (audits, birthdays, Personal Time Off events, etc), and color code on the calendar date. The tool is invaluable as an “at a glance” planning tool.
I’m a fireman and we use wallet calendars. We have three shifts; RED, Green and Blue. The shift week is on a 9 day circuit. Is there code to make the date or background a color every nine days? Example the first week in January: Green days 1st, 3rd and 5th. Blue 2nd, 7th and 9th. Red 4, 6 and 8. etc…..
I have similar needs as those of Glen (also a public safety employee) and we have rotating platoons. I would also like additional information on personalizing the Compact Calendar such as, how would you set a re-occurring date such as a payday? Thanks for any input.
Glenn, William: I’ll have to think about how to do those two tricks automatically, but the short answer would be to make a copy of the compact calendar and then color each cell manually by selecting the dates you want and changing the background colors.
You may have to use the special copy: copy values (not formulas) for it to work.