(last edited on April 29, 2014 at 1:26 am)
For the latest version of the Compact Calendar, please go to
https://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
<
p><
p>
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.
100 Comments
Cool, a new version of the David Seah’s compact-calendar so this my french translation of this must have tools
is here in french : http://www.tisseurdetoile.net/blog/index.php?post/2007/11/26/Le-calendrier-Compact-de-Dave-Seah-2008
Thanks for your work
have a nice day.
Thanks Le TisseurDeToile!
I know that others have added their own versions already, so I’m going through my email to find them.
The Compact Calendar is very useful for me.
Thanks~~~Dave Seah
A while ago I made a Spanish compact calendar for 2008 based on last year’s calendar, with separate calendars for the regions Cataluña, Madrid, Valencia and Lleida. After that special versions for Colombia and Mexico have been added:
http://canasto.es/2007/10/calendario-compacto-2008/
A new Italian version, including the ISO 8660 week numbers is available here:
http://paolo.ciarrocchi.googlepages.com/calendariocompatto
together with the 2007 version which I suggested in Aug.
David, I love your site and the information I’ve learned from you. Thanks for the new version of the Compact Calendar!
One question/request: do you plan to do .pdf versions again, like you did for 2007? I don’t have Excel, and MS Works Spreadsheets doesn’t like multi-sheet Excel files.
Thanks again for your insight!
Genia: I’ve uploaded PDF printout versions for you. Enjoy!
Hi~ Dave
I have made a Taiwan(Traditional Chinese) compact calendar for 2008, but I don’t know how to put it on the website.
Can you tell me how can I do?
Dave, you’re a sweetheart. Thanks so much for the .pdf versions!
Hey Dave!
Thanks for posting the 2008 calendar!
I’ve put together a Portuguese (Portugal) version with the main / official holidays.
http://www.miguelalho.com/tools/CompactCalendar2008pt-ss1.zip
E Sheng: Just upload it to your own website, write a blog post about it, and let me know, and I’ll link to it.
OK!! David
CompactCalendar2008-Taiwan
http://esheng.vox.com/library/post/compactcalendar2008-taiwan.html
Thanks
Man, David. Just found your blog and I love it. Fantastic stuff – great design, content, you name it. You probably get a lot of comments like this, but hey you deserve it. I’ll be back to dig around more ;)
Cheers,
Albert
UrbanMonk.Net
Modern personal development, entwined with ancient spirituality.
I made the hungarian translation:
http://www.hatekonysag.hu/blog/kompakt-naptar-2008-letoltes.htm
Hi Dave,
Thanks as always for sharing these ideas with us all. I have modified the table to show the public holidays for Thailand for 2008.
http://orient-expression.blogspot.com/2007/11/technology-applied-compact-calendar.html
Thanks! Added Portugal, Taiwan, and will now add Hungarian and Thailand!
Albert, David: thanks for the kind words! I really appreciate them! :-)
I made the Korean translation:
http://blog.naver.com/2kiya/44789604
Thanks for your great idea!
Hi David,
I love this calendar and I’ve made a little modification to the italian version: I’ve added a column with the number of the weeks, as long as I and my customers verry often referres to these numbers.
My modded calendar is available here (http://www.strategievincenti.net/2007/12/project-management-il-calendario-compatto/)
ciao
alex
Ciao Alex,
I already did the same and David already linked my version:
Italy 2008 w/ ISO8660 Weeks by Paolo Ciarrocchi
http://paolo.ciarrocchi.googlepages.com/calendariocompatto
Are there any differences in the two “implementations”?
That said, I like your blog :-)
Ciao Paolo,
I didn’t seen your version. I’m using the compact calendar since last year and I didn’t check back to this site lately, but only today to comunicate that I modded and publish my italian version.
I didn’t know other people had the same need as I had and already made the addition of the weeks number.
No there are no substantial changes, despite the fact that I located the number of the weeks just beside the column with the dates of Monday.
have a nice day
ciao
alex
I’ve made one for Alberta Canada, but it could be easily modified for the other provinces with different days. I also made some modifications as I like having lines to write on. I setup a light gray graph which would be useful for writing and drawing things like graphs and gantt charts. I also added a couple of lines at the top for subject heading and for the date or start/end time.
Dave, feel free to post this up on your site:
http://demo.commerxtest.com/calendar/compactcalendar2008m-s.xls
Dave, really great calendar. I am trying to make one for Kuwait but require more space in the Tables to add more holidays.
Where can I edit the lookup table so I can make it larger?
Hyun-soo, Dave: Awesome, thanks! BTW, Dave, if you could make the XLS file into a ZIP archive, that would be much more download-friendly.
nibag: The HolidayTable can be expanded if you just insert rows in the middle, and not the ends. This should expand the range automatically (not guaranteed if you do it at the end). So, right-click the ROW number (all the way at the left of the spreadsheet), choose INSERT (or it might be INSERT ROW) from the menu, and that should add a row. To repeat the insert, you can type CTRL-Y a bunch of times.
Republic of Ireland Holidays (Download UK one and edit holidays table – copy and paste in)
1-Jan-08 New Year’s Day
17-Mar-08 St. Patrick’s Day
23-Mar-08 Easter
24-Mar-08 Easter Monday
5-May-08 May Day
2-Jun-08 June Bank Holiday
4-Aug-08 August Bank Holiday
27-Oct-08 October Bank Holiday
25-Dec-08 Christmas Day
26-Dec-08 St. Stephen’s Day
Very handy, thank you!
Hi David and everybody. A Dutch (Nederlands) and a Frisian (Frysk) translation can be found here: http://diepfries.nl/index.php/compact-calendar-2008/
Hi David,
Great job again!
I made the Brazilian translation with the national holidays and national holidays + São Paulo holidays.
http://nicholasalmeida.com/CompactCalendar2008br/
Norwegian (norsk): http://2g.no/teknologi/2007/kompaktkalenderen-2008/
Zip file:
http://demo.commerxtest.com/calendar/compactcalendar2008m-s.zip
Please edit my original post if you can.
Hi,
I’ve made a Norwegian version of the calendar available here:
http://andedam.org/2007/12/04/kompaktkalender/
Thanks for this Dave.
I’ve uploaded a Canadian-British Columbia calendar to the Wiki.
Alberta Dave: Something happened to your’s as the last tab (Tables) is missing.
Hello, Dave!
Well, looks like Nicholas has made a brazilian version already. Anyway, my version is here:
http://carladobrasil.wikispaces.com/space/showimage/CalendarioCompacto2008.zip
Thanks for sharing your idea!
I’ve made a South African version but my wordpress.com blog doesn’t allow ZIP uploads. I’ve tried to register on your wiki so I can upload it there but after five or six attempts at entering a string that matches the CAPTCHA, I gave up. Is there some other way I can get it to you?
Added all!
Steve Crane: I’m sorry that the CAPTCHA isn’t working right…maybe I should disable it. I’ve turned it off for now…if anyone else has had trouble with it, please let me know.
Now it says I’m not authorised to perform that action when I try to register. I got past the CAPTCHA when I posted my last comment by typing it all in upper case even though it was displayed in lower case, but that didn’t work with the one on the registration page. I hope I get past to post this comment.
Steve: I think it requires numbers too at the end, but otherwise I’m not sure what the problem is. When I tested it I didn’t have any problems (Firefox). The authorization error occurs when Expression Engine thinks you are a bot, caused by repeated failed captcha attempts.
Email me directly with what you want your username to be, and I will register you manually.
Hi Dave,
Thanks for the great calendar! Question for you: I wanted to change the font color of the conditional formatting of the holidays but after changing the font color it did not actually update the calendar. What’s the trick to refreshing the calendar (so to speak) so the conditional formatting will take place again?
Thanks!
Christi
David,
This is not a translation, but rather a port to Apple’s Numbers spreadsheet program. I needed to use the functionality and thought it would be a good thing to share. The functions were not compatible, so I had to do a little manual work, but visually it is the same.
It can be found here:
http://www.numberstemplates.com/2007/12/04/template-david-seahs-compact-calendar-for-numbers/
I have included links back to your site, but please let me know if you prefer I take it down.
Thanks for the great tools.
– Michael
Hi David,
Thanks for the calendar, its amazingly very easy…
I just made a India version for it, would like to share that on your website. Please let me know where can i email that.
Thanks & Regards
Shikhar
Compact calender is cool simple calendar.
I made Korean version compact calendar.
It’s little bit different.
http://opencache.tistory.com/117
Christi: You need to set the formatting in the Conditional Formatting dialog box, not regular text formatting. Search help for “conditional formatting” for your version of Excel, and you should be able to figure it out from there. Good luck!
Michael: Awesome! I added the link.
Shikhar: If you don’t have hosting, register yourself on the public wiki, zip your file up, and then upload it and create a page for it. It’s all DIY here :-)
Malbong: Thanks! Added!
Hi David. Thanks for your calendar. It’s very handy! You may find Indonesia version at http://priatna.or.id/2007/12/05/kalender-2008/
Hello David, I’ve put a Simplified Chinese version for China Mainland at
http://www.beimfenster.com/?p=401
Thanks for this great tool.
Hello David, I have to say that all your printables are making my life better and organized. Also I uploaded in the wiki a Venezuelan version too. Hope to see more printables!
Hello David
I edited and translated the compact calender into a Hong Kong version. (PS. Of course,it’s Traditional Chinese.)
And I’ve upload it into you wiki
[[File:CompactCalendar2008-HongKong.zip]]
For refer only: Gov HK:General holidays for 2008 http://www.gov.hk/en/about/abouthk/holiday/index.htm
Thank you for your calendar.
It’s simple & useful.
Yes this seems like quite a good thing
I just made a India version for it, would like to share that on your website. Please let me know where can i email that.
I’ve just made slovak version (Slovakia). It’s available on my blog – http://zapisnik.mipo.us/kompaktny-kalendar-2008-slovenska-verzia.html
G’day, the “links” under “Download the Calendar Template” on the web page,https://davidseah.com/blog/comments/compact-calendar/
are NOT links. Thanks for all the info, but can you get the links fixed so they work, please? Take care, Ron
Ron: I am not following what your problem is. There are dozens and dozens of links on this page. Which ones specifically are not working? Many of them point to blog posts off-site. Some of them point to PDF files or ZIP files.
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