Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2012, 04:00 AM
lizat lizat is offline Elapsed Time, mandays &% complete Windows 7 64bit Elapsed Time, mandays &% complete Office 2010 64bit
Novice
Elapsed Time, mandays &% complete
 
Join Date: Nov 2012
Posts: 4
lizat is on a distinguished road
Default Elapsed Time, mandays &% complete

On my project we are not doing detailed resource planning, so although we will assign tasks to an individual I want to be able to specify the start and end date and then know the elapsed duration. We will know the amount of work. We may have entered some completion time.

I want to be able to:
  • know the start & end dates and change them - without changing the % complete if it has been completed. this will be because we have extended the time but it will still be as complete as it already is
  • record the man days and the elapsed days.... is this possible

For example here is a task:


  • starts 1st Jan
  • ends 31st Jan
  • elasped 31 days
  • 8 man-days work
  • Fred is assigned
  • It is 20% complete
We are going to end the end date to 14th Feb. The man days are still 8 and the completion is still 20%. I don't want them adjusted.

Is this possible?

Thank you................ liz
Reply With Quote
  #2  
Old 11-08-2012, 05:50 AM
JulieS JulieS is offline Elapsed Time, mandays &% complete Windows 7 64bit Elapsed Time, mandays &% complete Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Liz,

I'm afraid the scenario isn't going to work. % Complete is a duration measurement - so if you change the finish date (increase duration) Project will automatically drop the % complete. Even with manually scheduled tasks, changing the finish date to a later date will drop the % complete.

You may be able to come closer using % Work complete and fixed work tasks. If you set your tasks as fixed work - and you adjust duration - project simply recalculates assignment units.

Julie
Reply With Quote
  #3  
Old 11-09-2012, 03:19 AM
lizat lizat is offline Elapsed Time, mandays &% complete Windows 7 64bit Elapsed Time, mandays &% complete Office 2010 64bit
Novice
Elapsed Time, mandays &% complete
 
Join Date: Nov 2012
Posts: 4
lizat is on a distinguished road
Default

Julie,

thank you, that seems to work. Can you explain the difference between the two complete fields?

Also related to this, if I am changing all my tasks to follow this practice of fixed work & %work complete then I am wondering how I can force the duration to "reset" to either estimated (with a ?) or actually any other chosen unit. This is a general problem that I stumble on where, for example we want to show elapsed days and the task is currently man-days, how do we force to use elapsed without loosing the current date settings.... does this make sense?
Reply With Quote
  #4  
Old 11-10-2012, 06:21 AM
JulieS JulieS is offline Elapsed Time, mandays &% complete Windows 7 64bit Elapsed Time, mandays &% complete Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Liz,

I'm afraid I don't follow your new question. By definition, duration is in working day - omitting non-working time such a Saturday and Sunday.

The man-hours you are referring to are usually called "work" and is based upon resources assigned to tasks. It is very possible to have a task with a fairly long duration but lower amounts of work.

The two complete fields are the % complete which is a duration field calculated = (Actual Duration/Duration)*100.

If you have a 10 day duration task, and you've complete 6 days, the percent % is 60%.

% Work complete is a work calculation:
(Actual Work/Work)*100

In most circumstances as % complete changes, % work complete would change as well. Where there may be a difference is a task that has a work contour where the task may start with 1 person but as the task progresses additional resources perform work.

I hope this helps.

Julie
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Elapsed Time, mandays &% complete complete % and physical complete % ketanco Project 3 05-25-2012 08:19 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Elapsed Time, mandays &% complete % Complete (Actual) vs % Complete (Should) Carlos Maximo Project 3 12-06-2011 12:01 PM
Reporting ManDays on people not fully assigned to the Project Imagios Project 9 10-10-2011 04:36 AM
Elapsed Time, mandays &% complete Calculate elapsed time in Word table? Snvlsfoal Word Tables 1 08-11-2011 05:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:30 PM.


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