In Merlin you can enter exceptions for holidays or exceptional working days in the working time inspector. Exceptions applying for the complete project should be entered in the project calendar. Those affecting only a specific resource, should be entered in its calendar.
From time to time we get asked in support how one could visualize those exceptions in the Gantt. Merlin shows non working days in grey, but it has no explicit function for showing which grey date ranges belong to which exception.
To solve this, we wrote a small applescript creating activities out of the defined exceptions of a resource. To test it, just check the following script:
(* Scripting with Merlin 2 You may incorporate this ProjectWizards sample code into your program(s) without restriction. This ProjectWizards sample code has been provided "AS IS" and the responsibility for its operation is yours. You are not permitted to redistribute this ProjectWizards sample code as "ProjectWizards sample code" after having made changes. If you're going to redistribute the code, we require that you make it clear that the code was descended from ProjectWizards sample code, but that you've made changes. Copyright ©2011 ProjectWizards, Melle, Germany. All rights reserved. *) (* Name: Creates activities for visualation of the exceptions of a selected resource (German: Erstellt Vorgänge für die Visualisierung der Ausnahmen im Ressourcenkalender einer ausgewählten Ressource) Author: Vicky Stamatopoulou for ProjectWizards, Copyright 2011 Info: The script prompts for the name of resource, creates the activities, handles title of exception, start & end dates, and working mode Date: June 1st 2011 *)