#1
|
|||
|
|||
Updating actual work and work on resource spread sheet
Hi,
I need to calculate the allocation of my employees within the near future, for this I update weekly the actual work for their activities. I would like project to divide the remaining work evenly in the weeks left.. but project insists in crazy divisions that I don´t understand. Example: Pedro has a project of 100 hours, and has worked 10 hours this week (90 hours remaining now). If the project is to be delivered within 3 weeks I would like project to assign automatically 30 hours for week (30x3=90). |
#2
|
|||
|
|||
What kinds of tasks are you working with: Fixed Units, Fixed Work, or Fixed Duration.
|
#3
|
|||
|
|||
Hi Julie,
First and foremost thank you for all replies you´ve been giving. I am working with Fixed Work Tasks. |
#4
|
|||
|
|||
You're welcome and sorry for the delay. Let's break this down a bit. A 4 week duration task with 100 hours of work means 25 hours per week or 63% peak units. If during the first week, the resource only accomplishes 10 hours of work, then the remaining 15 hours of work he or she is scheduled for will be redistributed.
On a Fixed Work task - Project adds two additional days - 8 hours for the first day and 7 hours for the second day. The 5 hours per day originally scheduled for first part of the task is not increased. The Remaining work is 90 hours but the duration has increased to 4.38 weeks and the peak units has increased to 100%. On a fixed Djuration task, the 15 hours of work is kept in the same duration - but the scheduled hours of work per day is increased to 6 hours per day - 30 hours per week. The peak units is increased for the entire task to 75%. For a Fixed Units task, results is the same as a Fixed Work task. The duration increases, the 5 hours per day still holds until the last two days where the work is at 8 and 7 hours per day. So, if you want the work per day to increase, but the duration stay the same - use Fixed Duration tasks and project will re-distribute the remaining work evenly. I hope this helps. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fixing Work, % of actual work and Final Date in a task (while assigning resources) | Campelliann | Project | 1 | 01-09-2017 06:15 PM |
How to Input Actual Overtime Work | caveman | Project | 13 | 03-31-2015 05:24 PM |
Where have all my 'actual work' entries gone? | flanjamin | Project | 3 | 11-24-2014 03:41 PM |
Change Resource Time vs. Duration when Updating Work column | lylel | Project | 3 | 07-23-2012 06:09 PM |
Actual work in the future | joday48 | Project | 3 | 07-06-2012 06:00 AM |