Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2017, 08:15 AM
Campelliann Campelliann is offline Updating actual work and work on resource spread sheet Windows 8 Updating actual work and work on resource spread sheet Office 2016
Novice
Updating actual work and work on resource spread sheet
 
Join Date: Jan 2017
Posts: 6
Campelliann is on a distinguished road
Default 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).
Reply With Quote
  #2  
Old 01-26-2017, 11:51 AM
JulieS JulieS is offline Updating actual work and work on resource spread sheet Windows 7 64bit Updating actual work and work on resource spread sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

What kinds of tasks are you working with: Fixed Units, Fixed Work, or Fixed Duration.
Reply With Quote
  #3  
Old 01-27-2017, 04:47 AM
Campelliann Campelliann is offline Updating actual work and work on resource spread sheet Windows 8 Updating actual work and work on resource spread sheet Office 2016
Novice
Updating actual work and work on resource spread sheet
 
Join Date: Jan 2017
Posts: 6
Campelliann is on a distinguished road
Default

Hi Julie,

First and foremost thank you for all replies you´ve been giving. I am working with Fixed Work Tasks.
Reply With Quote
  #4  
Old 01-31-2017, 11:17 AM
JulieS JulieS is offline Updating actual work and work on resource spread sheet Windows 7 64bit Updating actual work and work on resource spread sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Updating actual work and work on resource spread sheet How to Input Actual Overtime Work caveman Project 13 03-31-2015 05:24 PM
Updating actual work and work on resource spread sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft