About Dave's Compact Calendar (modified to add NZ holidays)
NZ : WEEK STARTING MONDAY 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 10 11 12 13 14 April 15 16 17 18 May 19 20 21 22 23 June 24 25 26 27 July 28 29 30 31 August 32 33 34 35 36 September 37 38 39 40 October 41 42 43 44 November 45 46 47 48 49 December 50 51 52 January March February January MONTH M T W R F
2009
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
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
10 11 12 13
16 17 18 19 20 23 24 25 26 27 2 9 3 4 5 6
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)