For the latest version of the Compact Calendar, please go to
http://davidseah.com/compact-calendar
Download the 2009 Calendar Template
INSTRUCTIONS
Download using the link below, unzip the archive. In the
Excelfolder, you’ll see files named something likeCompactCalendar.xlt. This is a Microsoft Excel spreadsheet template.Double-click the file (Windows) and a new spreadsheet will be created based on the template.
Print it out, or annotate the calendar within Excel. Again, I just print them out; you could make a fancier “production calendar” too and print that instead, if you’re that type of person.
Optionally you can copy the
.xltfile into your Microsoft Excel templates folder. This gives you the ability to create new calendars using Excel’s New Document command.
US Version
Download USA 2008 by Dave Seah
Includes Sun-Sat and Mon-Sun (w/ ISO8601 week numbers) versions in ZIP archive. You can also download the PDF Sun-Sat and PDF Mon-Sun versions too!
Download USA 2009 by Dave Seah
Includes Sun-Sat and Mon-Sun (w/ ISO8601 week numbers) versions in ZIP archive. You can also download the PDF Sun-Sat and PDF Mon-Sun versions too!
2009 International Calendars
If you’ve made a version of the Compact Calendar for your locale and would like to share, put it on a page on your own website and I’ll link it here! I no longer host other people’s files, because it puts the support burden on me to maintain them.
Argentina 2009 via Jeroen Sangers
Austria 2009 by Ronald
Australia 2009 by Working Solo
Australia/NSW 2009 by Diane (direct file download)
Canada 2009 by andryou
Chile 2009 via Jeroen Sangers
Chile 2009 by Gabriel
China (PRC) 2009 by iWorm
Colombia 2009 via Jeroen Sangers
Colombia 2009 by Javier Ferrand
Denmark 2009 by henrik
Ecuador 2009 via Jeroen Sangers
Estonia 2009 by Eero
France 2009 by Tisseurdetoile
Germany 2009 by Lennart Groetzbach
Guatemala 2009 via Jeroen Sangers
Greece 2009 by Gerasimos Tsiamalos
Hong Kong 2009 by Catus Lee
Indonesia 2009 by Eka
Italy 2009 by Luca Magnani
Italy 2009 by Strategie Vincenti
Japan 2009 by Yoshiomi KURISU
Libya 2009 by Dino
Malaysia 2009 by Fred
Mexico 2009 via Jeroen Sangers
Netherlands 2009 by Pieter
New Zealand 2009 by Jon Pawley
Peru 2009 via Jeroen Sangers
Phillipines 2009 by Arvin Pedregosa
Poland 2009 by Mizo
Poland 2009 by Jaason
Portugal 2009 by Miguel Alho
Romania 2009 by Andrei Neculau
Russia 2009 by Ivan Bulychev
Serbia 2009 by Goran Anicic
Singapore 2009 by John Spencer Tan
Slovakia 2009 by Uzivatel
South Africa 2009 by Jason Bagley
South Africa 2009 by Peter
Spain 2009 by Jeroen Sangers
Sweden 2009 by David Fredin
Taiwan 2009 by yuanlin
United Kingdom 2009 by gregnbaker.com (box-net download, unchecked)
Uruguay 2009 via Jeroen Sangers
Venezula 2009 via Jeroen Sangers
OTHER VERSIONS
- Yoshiomi KURISU has programmed an online Compact Calendar Creator that will even create PDFs. Very cool!
OTHER TOOLS
You can find more printable productivity tools on The Printable CEO™ Series page.
Lucía 
Boris 
spag 
Peter 
Hi David,
I am afraid that I am addicted to the Compact Calendar but am not smart enough to make my own for 2009. When might you be posting a new one?
I know, no matter how much you give, it’s never enough! The people just want more.
Many thanks for this great tool.
Mary Kay
I made Slovak version (Slovakia) 2009 – http://uzivatel.wordpress.com/2008/08/31/kompaktny-kalendar-2009/
Thanks for your job. Your blog is great!
I’m trying to change the colour of the box in the first day of each month… I want it in white, like the other ones. Thanks!
Hi David,
I’ve happened on your site before (when I could leisurely cruise the blog world!) Now, I’m looking for a scale-able template for a 2009 calendar… I followed the rabbit trail and your compact calendar is great! I also found the general start date version from James Mitchell site. Really cool:) I can’t use it for my purpose, but I’m going to use it for production scheduling for myself… thank you!
Julie: Someone actually called me up today and asked about the 2009 edition, so I said I could pop one out in about 15 minutes. Ooops. With all the rechecking of holidays, testing new features, and article prepwork, it’s really more like 4 hours.
But it’s up now! :-)
Dave, this is awesome. I’ll write up a list of jewish holidays for 08/09/10 to share.
Hey David! Great stuff once more. I’ve put together the Greek version of Compact Calendar 2009 :)
It can be found at http://theportraitofageek.com/blog/?p=186
Thanx for that!
Hi Dave,
shortly to inform you and your readers, that I’ve added to my blog (you already link to it) the 2009 calendar in ITALIAN language and that I’ve made it available in the following formats:
1. XLS Excel
2. PDF
3. ODS OpenOffice (freeware !)
4. Google Doc Spreadsheet (publicly accessible from anywhere you have access to an Internet connection !)
ciao
alex
Is there a version that shows the holiday descriptions in the leftmost calendar anymore? Your screenshots show it, but the calendar (at least S-S version) doesn’t have it. Seems like a useful feature. Thanks!
Thanks. I found a typo though:
“an visual advantage shared with the Gantt chart”
It should be “a visual”
I added one modification to your calendar that you may want to consider. Rather than shading the first day of each month, I alternated the background shading every other month. So the entire months of January, March, May, etc. are shaded while February, April, June, etc. are not. This makes it much easier to differentiate the months at a glance without sacrificing the compact “candy bar” design. You might want to try it out and see if you like it.
Hi David, thanks for the calendar. Inspired by your work, I developed my own calendar for the Fiscal year rotation. You can access that from my blog http://kaushalmodi.wordpress.com/2008/09/22/cal/
I just discovered this calendar, and it looks awesome!
I was wondering, if anybody would be willing to work on a student version, that goes from about August-July?
If somebody could point me in the right direction, I guess I could make it for myself!
@John, You can try using my calendar at http://ikaushal.com/2008/09/22/cal/ I started with David’s idea and built up on it. It will show you 12 months from the month and year you specify in the Excel sheet.
Great Tool! Just adapted the 2009 version to german including Austrian Holidays.
http://www.ronpoint.com/2008/09/23/kompakt-kalender-2009/
Just a quick question. Why is Thursday marked as R on the US 2009 PDF?
thanks,
Created the German version and updated the .xls sheet. Wow the holidays are also automatically updated based on the calendar year you choose.
http://www.lennartgroetzbach.de/blog/kompaktkalendar/
Hi!
Thanks for the new version, here is a swedish translation of the 2009 version: http://fredin.org/david/blog/2008/09/30/kompakta-kalendern-2009/
Dave,
thank You very much for the new version.
The updated italian version for the 2009 (with and without week numbers) can be found at following url:
http://www.magnificaweb.it/calendario-compatto-2009/
Thanks
Hello, nice work as usual,
I have update the french version of the compact-calendar it cant be found here, I have made the Microsoft Office and the OpenOffice Version.
You can find it here http://www.tisseurdetoile.net/blog/index.php?post/2008/10/09/Le-calendrier-compact-de-DavidSeah-2009
Hopes It Help.
Thanks for your work
have a nice day.
As I commented on you post about the new versions, I have created compact calendars in Spanish for (amongst others) Argentine, Chile, Colombia, Equador, Spain, United States, Guatemala, Mexico and Peru.
Oops, forgot to mention the location of these calendars: http://canasto.es/calendario-compacto/
Hi Dave, I updated the Hungarian Calendar.
Here is the new version:
http://www.hatekonysag.hu/blog/david-naptar-2009.htm
The link to the swedish version for 2009 has two “http” in it, so the link is invalid.
Here’s a mod that permits any fiscal or academic term, of any length, by allowing the user to specify both the start and end dates – a variation on Jim Mitchell’s mod, with high praise for David’s original from both of us!
http://ellisgodard.blogspot.com/2008/10/truly-compact-calendar.html
Feel free to distribute freely, and/or (esp David) to adopt the modifications (3 more on the way). Credit due appreciated, but keep the change. ;)
-eg
The Compact Calendar Creator (listed under “Other Versions”) generates wrong calendars—they’re one day off.
I’ve made a couple changes to ease the pain of updating holidays after changing the year. Of course, holidays that change dates (Easter) are still messy, but most of them will update with the year change.
Basically, you enter the date without the year (as a string) and it tacks the year on and makes a datestamp for the vlookup to use
Excel Template:
http://dl.getdropbox.com/u/200272/CompactCalendar2009us-Holiday_fix-xlt.zip
OpenOffice.org 3 Template:
http://dl.getdropbox.com/u/200272/CompactCalendar2009us-Holiday_fix-ots.zip
Hi David,
Danish translation is ready here:
http://tanker-om-ledelse.dk/index.php/ledelse/kompakt-kalenderen
BR Henrik
Denmark
I added a few tweaks.
Here’s the details on the first:
Convert and Merge Number and Date
http://www.mrexcel.com/forum/showthread.php?p=1765933#post1765933
You can change the year but the Holidays
didn’t automatically adjust. So, I, with
the help of the folks at MrExcel, figured
out a way to adjust the Holidays automatically
by plugging in the Year from the main Calendar
into the Holiday Dates. This way, when you
change to a new year, the Holidays update too,
and from the same location, so no having to
change each date every time you update.
One other thing I did was to change the Year
to a drop down list (hidden on the Holidays page
in Columns D-H. It now goes all the way up to
2050. And beyond that, it’s a simple matter to
simply update the numbers in the range.
The last thing that I haven’t entirely figured out
yet is the whole Holiday Friday, or Monday, or
as in Thanksgiving, the Last Thursday of November.
Using the info from this page:
Calculate Last Sunday and First Sunday in the Month:
http://www.dslimited.biz/excel-zen/formulas-and-functions/excel-formula-calculate-last-sunday-and-first-sunday-in-month.html
I used his example to calculate (after setting
up pointer tables, also on the Holidays page
the Last Thursday of November for Thanksgiving.
It should also be easy then to calculate any other
1st, 2nd, 3rd, last etc special dates.
Hope these prove useful.
Here’s the (Office 2007) sheet saved as a template.
http://home.comcast.net/~mmeroom/CompactCalendar2009us-ms1.xltx
Just to let you know.
There were improvements suggested
to the formula used to calculate
Holiday dates.
I’ve included the changes in the
formula, as well as the details
in my tweaks.
Same link.
So, if you downloaded it earlier,
you might want to download it again.
Thanx and Credit to all for their
suggestions and help as well as to
David for the original.
Here’s an updated Numbers template. Michael’s doesn’t update to 2009 well. This one should work except on leap years.
http://sites.google.com/site/compactcalendar/
Or direct link:
http://sites.google.com/site/compactcalendar/Home/CompactCalendar.nmbtemplate.zip
Michael’s Numbers template doesn’t update easily as the year changes. I’ve made one that will work most of the time, but isn’t optimized for Leap Years.
http://sites.google.com/site/compactcalendar/Home/CompactCalendar.nmbtemplate.zip
Thanks everyone for your updates and contributions! I’m in the process of making updates for 2009 from the various places I’m getting links. If you don’t see yours, let me know :-)
Reminder: I will not host files; I will only link to webpages.
Very nice!
Hi David,
I have posted an Estonian version of Compact Calendar 2009 at the following address:
http://eeromonheros.blogspot.com/2008/12/kompaktne-kalender-2009-eesti-phadega.html
Thanks for the great work!
Hi, David.
I have uploaded Indonesian version for 2009 at http://priatna.or.id/2008/12/24/kalender-2009/
Thanks for your work!
I have added the Compact Calendar of Paraguay to http://canasto.es/calendario-compacto/
Hi David,
Malaysia 2009 Edition :)
@
http://pejalai.blogsome.com/2008/12/26/compact-calendar-2009-malaysian-edition/
Hi David, Took me a while to get to it this year, but I ajusted the calender with Portugal’s holidays. The post is at : http://miguelalho.com/?p=817
Have a great year!!!
Hello David,
A bit late, but the dutch and frisian versions can be found at diepfries.nl again.
Happy Newyear!
I have found the compact calendar extremely useful for planning my longer term (usually a quarter or more)responsibilities for work and personal. It is also an “at a glance” overview of the entire upcoming quarter or year. I recommend that everyone explore how it may be adopted and adapted to improve your planning and execution.
I made Traditional Chinese version for Taiwan
http://blog.yalinfo.com/2009/01/compact-calendar-2009.html
The Portuguese link is wrong.
Can you fix it?
Thanks
Hi David,
I’ve imported the Singapore public holidays and school holidays into a Singapore Edition, and posted it on my blog at
http://imac.multiply.com/journal/item/5/The_Compact_Calendar_by_David_Seah
Added all the calendars in the comments above, and fixed the Portugal link.
hi David, thanks a lot for this calendar. I hope you don’t mind if i linked this page from mine.
Happy new year
Hi David,
I’ve posted a Monday-Sunday version with South African holidays at http://gtde.blogspot.com/2009/01/compact-calendar-south-african-edition.html
thanks for this and your other work
Peter
Hi Dave,
thanks for the great design!
I created my Hungarian version at
http://daniel.sparing.hu/2009/01/23/compact-calendar-hungary/
My own modifications, two of which could apply to the US original too:
- I needed to add two more holiday-like day groups and conditional formattings to incorporate some swapped workdays and Saturdays in the coloring.
- because the conditional formatting for 1st of month is before the one for holidays, it is not possible to decide if a 1st day is holiday or not. My workaround is to swap the formattings and uncheck “stop if true”, but this only works perfectly in the new Excel version.
- As the Christmas of 2008 and 1/1/10 are visually included in the calendar of 2009, I included them in the holiday listings too for proper coloring.
Hey, David, is there a version of this calendar wherein the work day starts on a Saturday? I’ve changed work locations and the workweek starts on Saturdays here.
Hope you could help me. Your compact calendar is really of great help for me.
Thanks and best regards,
Boris
Muy útil, muchas gracias