none
Project 2010: Change how planned work moves if actual work is higher RRS feed

  • Question

  • Take the following scenario:

    For one task, there are several persons booked with planned work. A specific person is booked for 5 days PW, but sends actual work accounting for 6 days. This is one day more than expected.

    This one day is then added to the planned work on task level.

    Is there an easy way to change this? What we would prefer is the following:

    The same situation as before, but instead of counting the extra hours towards the PW on task level, substract the extra hours from the PW of other resources in the task. If the task only has one resource, the planned work should rise, though.

    How would I go and approach this problem?

    Wednesday, March 27, 2013 8:38 AM

Answers

  • Hi Ruben,

    This is not possible.  Work values are only transferred between assignments the following conditions are true.

    1. The task is autoscheduled, of type fixed work or with the effort driven flag switched on.

    2. Resources are added or removed from the task.

    In your case, option 2 is not being met (assignment work/actual work is changing, rather that resources being added/removed.


    Ben Howard [MVP] blog | web

    • Marked as answer by ruben.demey Wednesday, March 27, 2013 10:17 AM
    Wednesday, March 27, 2013 9:40 AM
    Moderator

All replies

  • Hi Ruben,

    This is not possible.  Work values are only transferred between assignments the following conditions are true.

    1. The task is autoscheduled, of type fixed work or with the effort driven flag switched on.

    2. Resources are added or removed from the task.

    In your case, option 2 is not being met (assignment work/actual work is changing, rather that resources being added/removed.


    Ben Howard [MVP] blog | web

    • Marked as answer by ruben.demey Wednesday, March 27, 2013 10:17 AM
    Wednesday, March 27, 2013 9:40 AM
    Moderator
  • It's unfortunate that there's no flexibility to be configured for this behavior. Would it be difficult to adapt this functionality by using customized code so it meets the demands as I've mentioned? Just to get an idea of what effort it might take.
    Wednesday, March 27, 2013 9:53 AM
  • I'm sure this would be possible using VBA.  How much effort depends on how well you know VBA and the object model in MSProject.  Worth asking in the customisation forum.

    Ben Howard [MVP] blog | web

    Wednesday, March 27, 2013 10:17 AM
    Moderator