% Complete Calculation
in [Project]
|
From: SwapnaK on 5 May 2008 12:47 Trying to understand how the Task % Complete given at the parent task gets distributed to subtasks under it. Is it based on duration, work, dates or anything else? Please hlep...!!! -- SwapnaK ------------------------------------------------------------------------ SwapnaK's Profile: http://forums.techarena.in/member.php?userid=48275 View this thread: http://forums.techarena.in/showthread.php?t=962325 http://forums.techarena.in
From: salgud on 5 May 2008 13:54 On Mon, 5 May 2008 22:17:40 +0530, SwapnaK wrote: > Trying to understand how the Task % Complete given at the parent task > gets distributed to subtasks under it. Is it based on duration, work, > dates or anything else? Please hlep...!!! Actually, it doesn't. It's the other way around. The % completes of the subtasks determine the % complete of the summary line, based on actual hours worked over total hours for all subtasks. Keep in mind, % Complete is a very poor way to input task progress. Actual hrs worked and remaining hrs give much better results. Hope that helps in your world.
From: Trevor Rabey on 5 May 2008 21:04 Yes, everything about the tasks rolls up to the summary, not the other way round. A task need not have any resource, work or cost associated with it, which just leaves duration to be tracked, and it can be. % Complete is about duration only. Tracking is not a matter of a choice between duration, work and cost. There is no distinction between them as to which is a "poor" or "better" way to track and measure progress. Using % of whichever, though is second rate, and unnecessary, compared to using the actual and remaining and allowing MSP to calculate % for you. Suppose the task is "lay some bricks". This task will have a duration, work and material type resources assigned and costs arising from bot the resource costs and the task's fixed cost (which is a cost which is independent of the resources, if any). That means there are 4 things to track and they are each more or less independent of the others: Bricks, Duration, Work, Cost At any given status date, each of the 4 will have an actual and a remaining, a total and a %, and the total and % can be derived from the actual and the remaining. So this is possible, even likely: Bricks, 50% Duration, 60% Work, 40% Cost, 55% "Progress" is a mixed picture, not one number. Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING www.perfectproject.com.au "salgud" <spamboy6547(a)comcast.net> wrote in message news:1p0l59l5olptn.11fhfr4oytyn5.dlg(a)40tude.net... > On Mon, 5 May 2008 22:17:40 +0530, SwapnaK wrote: > >> Trying to understand how the Task % Complete given at the parent task >> gets distributed to subtasks under it. Is it based on duration, work, >> dates or anything else? Please hlep...!!! > > Actually, it doesn't. It's the other way around. The % completes of the > subtasks determine the % complete of the summary line, based on actual > hours worked over total hours for all subtasks. > Keep in mind, % Complete is a very poor way to input task progress. Actual > hrs worked and remaining hrs give much better results. > Hope that helps in your world.
From: SwapnaK on 6 May 2008 01:38 Thank You. But in Microsoft Project it allows me to enter % Complete at the summary task level and then it distributes the % Complete to it's subtasks. For eg...if I have a Summary Task of Skill Management and I have subtasks under it as follows: - Skill Management - Add - Edit - View - Delete - Search For me it makes sense to list out all the subtasks so the developer knows what is needed to be done. But when it comes to submitting the status the developer may want to report % Complete at the Summary Task level. MPP allows that and then it distributes the status to it's subtasks. However I am not understanding the way it's distributing. Is there any algorithm or method? Any help in this regard is greatly appreciated. -- SwapnaK ------------------------------------------------------------------------ SwapnaK's Profile: http://forums.techarena.in/member.php?userid=48275 View this thread: http://forums.techarena.in/showthread.php?t=962325 http://forums.techarena.in
From: Rod Gill on 6 May 2008 04:43
I agree with Trevor, using % complete to track progress is a very low accuracy method. If a task with 10h of work is 50% complete did it start on time? did it take 5h to do 50% or 8? is there 5h to go or 8? Actual start, and actual work and remaining work or actual Duration and remaining duration are much better. Recording actual hours each day is better again. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "SwapnaK" <SwapnaK.38z6nd(a)DoNotSpam.com> wrote in message news:SwapnaK.38z6nd(a)DoNotSpam.com... > > Thank You. > > But in Microsoft Project it allows me to enter % Complete at the > summary task level and then it distributes the % Complete to it's > subtasks. For eg...if I have a Summary Task of Skill Management and I > have subtasks under it as follows: > > > - Skill Management > > - Add > - Edit > - View > - Delete > - Search > > For me it makes sense to list out all the subtasks so the developer > knows what is needed to be done. But when it comes to submitting the > status the developer may want to report % Complete at the Summary Task > level. MPP allows that and then it distributes the status to it's > subtasks. However I am not understanding the way it's distributing. Is > there any algorithm or method? Any help in this regard is greatly > appreciated. > > > -- > SwapnaK > ------------------------------------------------------------------------ > SwapnaK's Profile: http://forums.techarena.in/member.php?userid=48275 > View this thread: http://forums.techarena.in/showthread.php?t=962325 > > http://forums.techarena.in > |