About Dave's Compact Calendar (modified to add NZ holidays)
NZ : WEEK STARTING MONDAY (Provincial Holdys noted in calendar) About Compact Calendar I use this calendar template for project estimating. It's compact, easy to print, and most importantly allows me to visualize time as blocks.
Using the Compact I usually just circle the starting dates of a task, then run a line out to the right side where I can make a note as to what it is. With the amount of whitespace available on Calendar the right, there's plenty of room to leave notes. After I'm done, I then either make a clean version with another sheet of paper, or type up the dates right on a copy of this spreadsheet Printing Partial Calendars For small projects, I don't usually need the entire calendar, so I just select the rows I need then PRINT SELECTION from the print dialog. The headers/footers are set up so that it "prints clean" with the legends. Works great! If you need to change the year, just update the YEAR cell in the upper right corner of the calendar header; the rest of the calendar should automatically be calculated and updated. The 'Tables' worksheet tab has a list of holidays that you can change. If you change the year, make sure that you change the dates on this table as well. Click on the CALENDAR worksheet tab below to see the calendar itself ISO 8601 Week Information and calculation from http://www.rondebruin.nl/weeknumber.htm Auto-calculation of first day based on year cell provided by Todd Foster http://www.boidem.org/ Automatic month calculation tip from Jim Service and "Jenny" New Zealand Holidays added by Jon Pawley (jon.pawley+compactcalendar@gmail.com) from data retreived from http://www.ers.dol.govt.nz/holidays_act_2003/dates/2006_9.html
Change the Year
Adding Holidays
Enjoy! Credits
COMPACT CALENDAR (NZ)
# 52 1 2 3 4 5 6 7 8 9 March January
19 - Wellington 19 - Southland 26 - Auckland
2009
R F s
27 3 10 17 24 31 7 14 21 28 7 14 21 28 4 11 18 25 2 9 16 23 30 6 13 20 27 4 11 18 25 1 8 15 22 29 5 12 19 26 3 10 17 24 31 7 14 21 28 5 12 19 26 2
MONTH
M
T
W
s
28 4 11 18 25 1 8 15 22 1 8 15 22 29 5 12 19 26 3 10 17 24 31 7 14 21 28 5 12 19 26 2 9 16 23 30 6 13 20 27 4 11 18 25 1 8 15 22 29 6 13 20 27 3
22 23 24 25 26 29 30 31 5 6 7 1 8 2 9
12 13 14 15 16 19 20 21 22 23 26 27 28 29 30 2 9 3 4 5 6
February
2 - Nelson 6 - Waitangi Day
10 11 12 13
16 17 18 19 20 23 24 25 26 27 2 9 3 4 5 6
10 9 - Taranaki 11 23 - Otago 12 13 14 April 15 10 - Good Friday 16 13 - Easter Monday 17 25 - ANZAC Day 18 May 19 20 21 22 23 June 24 1 - Queen's Birthday 25 26 27 July 28 29 30 31 August 32 33 34 35 36 September 37 28 - Canterbury (South) 38 39 40 October 41 23 - Hawkes' Bay 42 26 - Labour Day 43 44 November 45 2 - Marlborough 46 13 - Canterbury 47 30 - Chatham Islands 48 49 December 50 7 - Westland 51 52 January
10 11 12 13
16 17 18 19 20 23 24 25 26 27 30 31 6 7 1 8 2 9 3 10
13 14 15 16 17 20 21 22 23 24 27 28 29 30 4 5 6 7 1 8
11 12 13 14 15 18 19 20 21 22 25 26 27 28 29 1 8 2 9 3 4 5
10 11 12
15 16 17 18 19 22 23 24 25 26 29 30 6 7 1 8 2 9 3 10
13 14 15 16 17 20 21 22 23 24 27 28 29 30 31 3 4 5 6 7
10 11 12 13 14 17 18 19 20 21 24 25 26 27 28 31 7 1 8 2 9 3 4
10 11
14 15 16 17 18 21 22 23 24 25 28 29 30 5 6 7 1 8 2 9
12 13 14 15 16 19 20 21 22 23 26 27 28 29 30 2 9 3 4 5 6
10 11 12 13
16 17 18 19 20 23 24 25 26 27 30 7 1 8 2 9 3 4
10 11
14 15 16 17 18 21 22 23 24 25 28 29 30 31 1
visit davidseah.com/pceo/cal for more information
HOLIDAY LOOKUP TABLE
DATE 1-Jan-09 2-Jan-09 19-Jan-09 19-Jan-09 26-Jan-09 2-Feb-09 6-Feb-09 9-Mar-09 23-Mar-09 10-Apr-09 13-Apr-09 25-Apr-09 1-Jun-09 28-Sep-09 23-Oct-09 26-Oct-09 2-Nov-09 13-Nov-09 30-Nov-09 7-Dec-09 25-Dec-09 28-Dec-09 DESCRIPTION New Year's Day Day after New Year's Day Wellington Anniversary Day Southland Anniversary Day Auckland Anniversary Day Nelson Anniversary Day Waitangi Day Taranaki Anniversary Day Otago Anniversary Day Good Friday Easter Monday ANZAC Day Queen's Birthday Canterbury (South) Anniversary Day Hawkes' Bay Anniversary Day Labour Day Marlborough Anniversary Day Canterbury Anniversary Day Chatham Island Anniversary Day Westland Anniversary Day Christmas Day Boxing Day (observed)