June 27, 2012

New version of the Project Holiday Wizard released (v 2.1)

This version will correctly locate the Outlook Holiday file in Office 2010 if you have that installed.  It should also work with Project 2010 but I haven't been able to test that.  Please let me know how you go.

Some people are also looking for an up to date Outlook Holiday file for older versions of Office.  The tool lets you manually select a file and will take you to a website where you can download the latest Outlook version of the file (2010).  That website is http://www.outlook-tips.net/outlook-calendar/missing-holidays/.

March 12, 2010

Rules for observing holidays that fall on a weekend

An interesting point has been raised by one of our Project Holiday Import Wizard users regarding the observance of holidays that fall on a non-working day (typically, a weekend).

In the US, if a declared holiday falls on a Saturday, it is generally observed on the preceding Friday and if it falls on a Sunday, it is observed on the following Monday.

In the UK and Australia and many other countries, if a declared public holiday falls on a Saturday or Sunday, it is observed on the following Monday. There are exceptions of course. Anzac Day, 25 April in Australia, does not result in a day-in-lieu if it occurs on a Saturday in most states (except Western Australia).

This means we need to provide some additional options in the Project Holiday Import Wizard, to control the treatment of holidays that fall on non-working days. The possible behaviours would seem to be:
  1. Observe holidays on their scheduled date regardless of non-working days;
  2. Observe holidays using USA Rules: move Saturday to previous Friday and move Sunday to following Monday;
  3. Observe holidays falling on weekends (Saturday and Sunday) to the following Monday;
  4. Ask me which rule to use for each holiday that falls on a weekend.
I am interested in your comments.

April 30, 2009

Project Holiday Import Wizard

Please provide feedback on our Project Holiday Import Wizard tool for Microsoft Office Project including any suggestions for it's future development.