none
Mutually Exclusive Calendars RRS feed

  • Question

  • I have seen a post in the past about Exception dates in Calendars and options to define them similar to the options available for "Recurring Tasks" in Project. I have a situation where I would like to create "Mutually Exclusive" calendars whereby there are some tasks that cannot be worked on on the last Friday of each month and conversely there are tasks that can only be worked on on the last Friday of the month. 

    I reckon Dale will know this, does anyone else?


    Dominic Moss MAPM, MCTS, MCITP, MCT
    Wellingtone PM News
    Wellingtone EPM Site
    Wellingtone PM Recruitment

    Thursday, April 3, 2014 8:30 AM

Answers

  • Hi Dominic,

    In order to define recurring exceptions, go to the calendar (change working time), then create an exception (like just a 1 day exception), entering a name and click on details. There you'll be able to enter recurring settings for your exception.

    See Nenad excellen blog here for PS2013.

    http://ntrajkovski.com/2013/11/07/recurring-week-exceptions-in-ms-project-2013/

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Dominic Moss Sunday, April 6, 2014 1:29 PM
    Thursday, April 3, 2014 12:43 PM
    Moderator
  • I don't want to repeat what others have told except I would like to emphasize on the finer aspects of creating these two base calendars.

    Create one calendar (Change Working time option, Project ribbon), say "Last Friday nonworking" calendar, with Mon-Friday (is working) in default work week and insert a monthly exception with last Friday is nonworking

    Create another calendar say "Last Friday working" calendar, with Mon-Thursday as non-working day in the default work week, and insert weekly exception with Friday is nonworking and another monthly exception with last Friday is working (if you have multiple exceptions on the same day the priority is for daily exceptions, then monthly exceptions, then weekly exceptions) - this is quite trick and so the screenshots - http://i.imgur.com/yDiqJgd.png, http://i.imgur.com/T8UTxdH.pnghttp://i.imgur.com/J1HvJoE.png

    Then, open the task select the Advanced tab and select the Calendar: dropdown to either "Last Friday working" or "Last Friday nonworking" to schedule the task.

    Hope this give you more clarity.


    Sai PMP, PMI-SP, MCTS Project, MVP Project




    Sunday, April 6, 2014 5:18 AM
    Moderator

All replies

  • errr.. is this a trick question?

    Surely it is just change working time, copy the standard calendar and make a nonworking day exception for every last Friday in every month, for as many months as necessary to cover the entire duration of the project. There are only 12 months in a year.

    Similarly, same thing but the exception days are every day except every last Friday in every month, for as many months as necessary to cover the entire duration of the project.

    Ok, it's a bit of repetition but it just takes 10 minutes to set up.

    Thursday, April 3, 2014 9:10 AM
  • Trevor - thanks for your answer, I guess I should have been more explicit. I can edit calendars manually but was wondering if there is a way of defining things from the Details dialog box that is available when you select either an exception date or if you select the Default or any other defined entry in the "Work Weeks" section.

    Dominic Moss MAPM, MCTS, MCITP, MCT
    Wellingtone PM News
    Wellingtone EPM Site
    Wellingtone PM Recruitment

    Thursday, April 3, 2014 10:03 AM
  • Hi Dominic,

    In order to define recurring exceptions, go to the calendar (change working time), then create an exception (like just a 1 day exception), entering a name and click on details. There you'll be able to enter recurring settings for your exception.

    See Nenad excellen blog here for PS2013.

    http://ntrajkovski.com/2013/11/07/recurring-week-exceptions-in-ms-project-2013/

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Dominic Moss Sunday, April 6, 2014 1:29 PM
    Thursday, April 3, 2014 12:43 PM
    Moderator
  • I don't want to repeat what others have told except I would like to emphasize on the finer aspects of creating these two base calendars.

    Create one calendar (Change Working time option, Project ribbon), say "Last Friday nonworking" calendar, with Mon-Friday (is working) in default work week and insert a monthly exception with last Friday is nonworking

    Create another calendar say "Last Friday working" calendar, with Mon-Thursday as non-working day in the default work week, and insert weekly exception with Friday is nonworking and another monthly exception with last Friday is working (if you have multiple exceptions on the same day the priority is for daily exceptions, then monthly exceptions, then weekly exceptions) - this is quite trick and so the screenshots - http://i.imgur.com/yDiqJgd.png, http://i.imgur.com/T8UTxdH.pnghttp://i.imgur.com/J1HvJoE.png

    Then, open the task select the Advanced tab and select the Calendar: dropdown to either "Last Friday working" or "Last Friday nonworking" to schedule the task.

    Hope this give you more clarity.


    Sai PMP, PMI-SP, MCTS Project, MVP Project




    Sunday, April 6, 2014 5:18 AM
    Moderator
  • Dear Sai,

    Thanks for the explanation and the screen-shots - I was unaware of the prioritisation of conflicting exceptions so I have definitely learnt something from your posting. The solution you have provided addresses my requirement most elegantly, thanks.


    Dominic Moss MAPM, MCTS, MCITP, MCT
    Wellingtone PM News
    Wellingtone EPM Site
    Wellingtone PM Recruitment

    Sunday, April 6, 2014 1:28 PM
  • Dear Guillaume - your explanation along with Sai's have given me the answer to my requirement - I will probably blog on this myself soon and will of course acknowledge the advice given on this Forum.

    Dominic Moss MAPM, MCTS, MCITP, MCT
    Wellingtone PM News
    Wellingtone EPM Site
    Wellingtone PM Recruitment

    Sunday, April 6, 2014 1:29 PM
  • You are most welcome

    Sai PMP, PMI-SP, MCTS Project, MVP Project

    Sunday, April 6, 2014 4:37 PM
    Moderator
  • Dear Sai - I have published a Blog on this feature and have given you credit

    Calendars Explored


    Dominic Moss MAPM, MCTS, MCITP, MCT
    Wellingtone PM News
    Wellingtone EPM Site
    Wellingtone PM Recruitment

    Friday, May 16, 2014 3:45 PM