I am working on a project where I have one person, person 1, working on a task full time and another person, person 2, contributing a few hours here and there. The task type is fixed units. I have person 2 set to 0% for units. The way its set up now whatever hours I add as Actual Work for Person 2 adds hours to the Total Work of the task. I want to make any hours that person contributes towards the project add to Actual Work and subtract from Remaining Work, so that the Work of the task doesn’t change. Does anyone know if this is possible?
I don’t think you can make project work the way you want it to.
The way project calculates total work is the sum of all actual work + remaining work. If you gave person 1 – 100 hours and person 2 – 0 hours, your initially have 100 hours total work. If person 2 applied 10 hours of actual work, you will now have a total work of 110 hours because person 1 has 100 hour remaining and person 2 has 10 hours of actual. 10 + 100 = 110. As far as I know, you can’t set up resource assignments as a “pool” where 100 hours of work can be performed by multiple people with them all drawing down from the original 100 hours work.
You have two options. 1) Anytime person 2 applies actual work, manually reduce the remaining work on person 1. So in the above example, you’d set the remaining work for person 1 down to 90. That way 10 actual + 90 remaining still results in 100.
2) You need to assign remaining work to both assigned resources. If person 2 thinks they might work 20 total hours on the task, give person 2 – 20 hours of work on the assignment. Then, as person 2 applies actual work, their remaining work will automatically be reduced and the total task hours will not change…unless one of the resources starts applying more actual hours than their original work estimate.
Hope that helps
Thank you, that helps. I ended up adding in a Baseline Work column and made a macro to copy Baseline Work to the Work column after I update Actual Work.