% Complete Calculation

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

salgud
Mon May 05 12:54:40 CDT 2008

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.

Trevor
Mon May 05 20:04:49 CDT 2008

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@comcast.net> wrote in message
news:1p0l59l5olptn.11fhfr4oytyn5.dlg@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.

SwapnaK
Tue May 06 00:38:32 CDT 2008

Thank You.

But in Microsoft Project it allows me to enter % Complete at th
summary task level and then it distributes the % Complete to it'
subtasks. For eg...if I have a Summary Task of Skill Management and
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 develope
knows what is needed to be done. But when it comes to submitting th
status the developer may want to report % Complete at the Summary Tas
level. MPP allows that and then it distributes the status to it'
subtasks. However I am not understanding the way it's distributing. I
there any algorithm or method? Any help in this regard is greatl
appreciated

--
Swapna
-----------------------------------------------------------------------
SwapnaK's Profile: http://forums.techarena.in/member.php?userid=4827
View this thread: http://forums.techarena.in/showthread.php?t=96232

http://forums.techarena.i

Rod
Tue May 06 03:43:17 CDT 2008

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@DoNotSpam.com> wrote in message
news:SwapnaK.38z6nd@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
>

Steve
Tue May 06 09:32:34 CDT 2008

% Complete only deals with durations, by definition. It is strictly a
measure of the passage of time and is not an indication of the amount of
work performed or progress on the deliverable to be produced. As others
have pointed out, the summary % complete is normally computed upwards from
posted actual durations of the subtasks, not the other way around. You can
measure the number of days work has taken place on an observable activity
versus the number of days the work is expected to last but you can't
estimate the % Complete on a summary task because it literally does not
exist as an observable, measurable activity. It is a composite of a number
of different activities grouped together for reporting purposes, nothing
more. The summary percent complete is calculated by taking the total of the
actual durations worked on all of the subtasks and dividing that sum by
total durations of all the subtasks. The resulting percentage, in turn, is
multiplied by the duration of the summary task to compute an effective
actual duration of the summary. This actual duration is subtracted from the
summary total duration to come up with a summary remaining duration. That
remaining duration is subtracted from the summary end date to provide a
final effective "worked through" date for the summary task.

In P2007, when you enter a % Complete directly for a summary task it
reverses that logic. Takes your input % Complete, subtracts it from 100 to
calculate the % Remaining, subtracts that from the finish date to result in
an effective worked through date. It then uses that date to set a
completed-through date for each of the subtasks. If they're scheduled to
finish before that date, they're 100% complete. If they're in-progress on
that date, they're whatever percent complete that date represents. If
they're not yet scheduled to start, they're 0% Complete.

Hope this helps

--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs

"SwapnaK" <SwapnaK.38z6nd@DoNotSpam.com> wrote in message
news:SwapnaK.38z6nd@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
>

SwapnaK
Wed May 07 07:23:57 CDT 2008

Hi Steve, Thank you. That was helpful.

TASK 6 DAYS WED 5/7/08 WED 5/14/08 50%
*1 6 days Wed 5/7/08 Wed 5/14/08 45%*
1.1 2 days Wed 5/7/08 Thu 5/8/08 100%
1.2 3 days Thu 5/8/08 Mon 5/12/08 47%
1.3 4 days Fri 5/9/08 Wed 5/14/08 10%
1.4 5 days Thu 5/8/08 Wed 5/14/08 28%
1.5 3 days Wed 5/7/08 Fri 5/9/08 81%
*2 5 days Wed 5/7/08 Tue 5/13/08 60%*
2.1 3 days Wed 5/7/08 Fri 5/9/08 81%
2.2 5 days Wed 5/7/08 Tue 5/13/08 48%

Above one is my project data. I have reported 50% at the Summary task
level. Here is my understanding from your explanation.

Project is 50% complete. Duration is 6 days. So I will take remaining
50% progress and calculate the completed-through date, which is
5/9/2008. So all tasks that end before that will have 100% status. That
explains me the status of the first subtask i.e., 1.1. However not sure
about the calculation of the remaining tasks. Can you please shed some
light on the point 'If they're in-progress on that date, they're
whatever percent complete that date represents.'

Thank you in advance.

--
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

Steve
Wed May 07 14:13:10 CDT 2008

We have a task that began Monday at 8am and is expected to take 5 days to
finish Friday at 5pm. It is now Wednesday at 5pm and we have worked as
planned and it appears that we really will finish on-schedule. By
definition the task is 60% complete. But if it's Wed at 5pm and it looks
like we won't really finish until Monday at 5, the task is only 50% complete
(3 days past out of now 6 days required to finish).

--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
MS MVP

"SwapnaK" <SwapnaK.391krf@DoNotSpam.com> wrote in message
news:SwapnaK.391krf@DoNotSpam.com...
>
> Hi Steve, Thank you. That was helpful.
>
> TASK 6 DAYS WED 5/7/08 WED 5/14/08 50%
> *1 6 days Wed 5/7/08 Wed 5/14/08 45%*
> 1.1 2 days Wed 5/7/08 Thu 5/8/08 100%
> 1.2 3 days Thu 5/8/08 Mon 5/12/08 47%
> 1.3 4 days Fri 5/9/08 Wed 5/14/08 10%
> 1.4 5 days Thu 5/8/08 Wed 5/14/08 28%
> 1.5 3 days Wed 5/7/08 Fri 5/9/08 81%
> *2 5 days Wed 5/7/08 Tue 5/13/08 60%*
> 2.1 3 days Wed 5/7/08 Fri 5/9/08 81%
> 2.2 5 days Wed 5/7/08 Tue 5/13/08 48%
>
> Above one is my project data. I have reported 50% at the Summary task
> level. Here is my understanding from your explanation.
>
> Project is 50% complete. Duration is 6 days. So I will take remaining
> 50% progress and calculate the completed-through date, which is
> 5/9/2008. So all tasks that end before that will have 100% status. That
> explains me the status of the first subtask i.e., 1.1. However not sure
> about the calculation of the remaining tasks. Can you please shed some
> light on the point 'If they're in-progress on that date, they're
> whatever percent complete that date represents.'
>
> Thank you in advance.
>
>
> --
> 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
>

SwapnaK
Thu May 08 06:54:22 CDT 2008

Steve,

Somehow I am confused. Would you mind explaining the % Calculation of
the Task 1.2 please?

--
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

Steve
Thu May 08 11:32:52 CDT 2008

I'll give it a shot but first what are the links between the tasks?

"SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
news:SwapnaK.393cne@DoNotSpam.com...
>
> Steve,
>
> Somehow I am confused. Would you mind explaining the % Calculation of
> the Task 1.2 please?
>
>
> --
> 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
>

Trevor
Thu May 08 20:58:27 CDT 2008

Steve,
For this example, we don't need the links because he gives us the start
dates and they'll do as snet constraints just for getting the bars to be in
the right place.
Apart from the fact that putting 50% Complete into the main summary and
allowing MSP to distribute it downwards to the lower level summaries and
thence to the tasks is so wrong way round that no one would ever do it, it
is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
I tried to reverse engineer the numbers and gave up, for the moment.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au
"Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
> I'll give it a shot but first what are the links between the tasks?
>
> "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
> news:SwapnaK.393cne@DoNotSpam.com...
>>
>> Steve,
>>
>> Somehow I am confused. Would you mind explaining the % Calculation of
>> the Task 1.2 please?
>>
>>
>> --
>> 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
>>
>

SwapnaK
Fri May 09 00:00:46 CDT 2008

Hi Steve,

No links as of now between tasks. BTW, does linking change Statu
Calculation as well? If yes, probably once i am clear on this, I migh
request again for explaining that scenario as well. :-).

Trevor Rabey;3721639 Wrote:
> Steve,
> For this example, we don't need the links because he gives us th
> start
> dates and they'll do as snet constraints just for getting the bars t
> be in
> the right place.
> Apart from the fact that putting 50% Complete into the main summar
> and
> allowing MSP to distribute it downwards to the lower level summarie
> and
> thence to the tasks is so wrong way round that no one would ever do it
> it
> is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
> I tried to reverse engineer the numbers and gave up, for the moment.
>
> Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
> www.perfectproject.com.au
> "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
> news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
> > I'll give it a shot but first what are the links between the tasks?
> >
> > "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
> > news:SwapnaK.393cne@DoNotSpam.com...
> >>
> >> Steve,
> >>
> >> Somehow I am confused. Would you mind explaining the % Calculatio
> of
> >> the Task 1.2 please?
> >>
> >>
> >> --
> >> 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
> >>
>

--
Swapna
-----------------------------------------------------------------------
SwapnaK's Profile: http://forums.techarena.in/member.php?userid=4827
View this thread: http://forums.techarena.in/showthread.php?t=96232

http://forums.techarena.i

Trevor
Fri May 09 00:28:01 CDT 2008

This is a multi-part message in MIME format.

------=_NextPart_000_00D2_01C8B1D8.83045290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

You need to see the Tracking Table, with Actual Duration and Remaining =
Duration

TASK (SUMMARY) Wed 07/05/08 08:00 NA 50% 3d 3d

1 (SUMMARY) Wed 07/05/08 08:00 NA 45% 2.71d 3.29d

1.1 Wed 07/05/08 08:00 Thu 08/05/08 17:00 100% 2d 0d

1.2 Thu 08/05/08 08:00 NA 47% 1.42d 1.58d

1.3 Fri 09/05/08 08:00 NA 10% 0.42d 3.58d

1.4 Thu 08/05/08 08:00 NA 28% 1.42d 3.58d

1.5 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d

2 (SUMMARY) Wed 07/05/08 08:00 NA 60% 3.02d 1.98d

2.1 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d

2.2 Wed 07/05/08 08:00 NA 48% 2.42d 2.58d

Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT =
PLANNING www.perfectproject.com.au=20
"Trevor Rabey" <trabey@nospam.westnet.com.au> wrote in message =
news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au...
> Steve,
> For this example, we don't need the links because he gives us the =
start=20
> dates and they'll do as snet constraints just for getting the bars to =
be in=20
> the right place.
> Apart from the fact that putting 50% Complete into the main summary =
and=20
> allowing MSP to distribute it downwards to the lower level summaries =
and=20
> thence to the tasks is so wrong way round that no one would ever do =
it, it=20
> is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
> I tried to reverse engineer the numbers and gave up, for the moment.
>=20
> Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING=20
> www.perfectproject.com.au
> "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message=20
> news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
>> I'll give it a shot but first what are the links between the tasks?
>>
>> "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message=20
>> news:SwapnaK.393cne@DoNotSpam.com...
>>>
>>> Steve,
>>>
>>> Somehow I am confused. Would you mind explaining the % Calculation =
of
>>> the Task 1.2 please?
>>>
>>>
>>> --=20
>>> SwapnaK
>>> =
------------------------------------------------------------------------
>>> SwapnaK's Profile: =
http://forums.techarena.in/member.php?userid=3D48275
>>> View this thread: =
http://forums.techarena.in/showthread.php?t=3D962325
>>>
>>> http://forums.techarena.in
>>>
>>=20
>=20
>
------=_NextPart_000_00D2_01C8B1D8.83045290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3314" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>
You need to see the Tracking Table, with =
Actual=20
Duration and Remaining Duration
TASK (SUMMARY) Wed 07/05/08 08:00 NA 50% =
3d=20
3d
1 (SUMMARY) Wed 07/05/08 08:00 NA 45% =
2.71d=20
3.29d
1.1 Wed 07/05/08 08:00 Thu 08/05/08 17:00 =
100% 2d=20
0d
1.2 Thu 08/05/08 08:00 NA 47% 1.42d =
1.58d
1.3 Fri 09/05/08 08:00 NA 10% 0.42d =
3.58d
1.4 Thu 08/05/08 08:00 NA 28% 1.42d =
3.58d
1.5 Wed 07/05/08 08:00 NA 81% 2.42d =
0.58d
2 (SUMMARY) Wed 07/05/08 08:00 NA 60% =
3.02d=20
1.98d
2.1 Wed 07/05/08 08:00 NA 81% 2.42d =
0.58d
2.2 Wed 07/05/08 08:00 NA 48% 2.42d=20
2.58d</DIV>
<DIV> </DIV>
<DIV>Trevor RabeyTrevor Rabey 0407213955 61 =
8 92727485=20
PERFECT PROJECT PLANNING <A =
href=3D"http://www.perfectproject.com.au"><FONT=20
face=3DArial size=3D2>www.perfectproject.com.au</A>=20
</DIV>
<DIV>"Trevor Rabey" <<A=20
href=3D"mailto:trabey@nospam.westnet.com.au">trabey@nospam.westnet.com.au</A>> wrote=20
in message <A=20
href=3D"news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au">news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au</A><=
FONT=20
face=3DArial size=3D2>...</DIV>> =
Steve, >=20
For this example, we don't need the links because he gives us the start =
 >=20
dates and they'll do as snet constraints just for getting the bars to be =
in=20
 > the right place. > Apart from the fact that putting 50% =
Complete=20
into the main summary and > allowing MSP to distribute it =
downwards to=20
the lower level summaries and > thence to the tasks is so wrong =
way round=20
that no one would ever do it, it > is still interesting. =
Summaries 1 and=20
2 get 45% and 47% for a start. > I tried to reverse engineer the =
numbers=20
and gave up, for the moment. > > Trevor Rabey 0407213955 61 =
8=20
92727485 PERFECT PROJECT PLANNING > <A=20
href=3D"http://www.perfectproject.com.au">www.perfectproject.com.au</A> >=20
"Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message =
 >=20
<A href=3D"news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl">news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl</A>... >> I'll give it a shot but first what are the =
links between=20
the tasks? >> >> "SwapnaK" <<A=20
href=3D"mailto:SwapnaK.393cne@DoNotSpam.com">SwapnaK.393cne@DoNotSpam.com</A>> wrote=20
in message >> <A =
href=3D"news:SwapnaK.393cne@DoNotSpam.com"><FONT=20
face=3DArial size=3D2>news:SwapnaK.393cne@DoNotSpam.com</A>... >>> >>>=20
Steve, >>> >>> Somehow I am confused. Would you =
mind=20
explaining the % Calculation of >>> the Task 1.2=20
please? >>> >>> >>> -- =
 >>>=20
SwapnaK >>>=20
------------------------------------------------------------------------<=
BR>>>>=20
SwapnaK's Profile: <A=20
href=3D"http://forums.techarena.in/member.php?userid=3D48275">http://forums.techarena.in/member.php?userid=3D48275</A><=
BR><FONT=20
face=3DArial size=3D2>>>> View this thread: <A=20
href=3D"http://forums.techarena.in/showthread.php?t=3D962325">http://forums.techarena.in/showthread.php?t=3D962325</A><=
BR><FONT=20
face=3DArial size=3D2>>>> >>> <A=20
href=3D"http://forums.techarena.in">http://forums.techarena.in</A> >>> >> > ></BODY></HTML>

------=_NextPart_000_00D2_01C8B1D8.83045290--

SwapnaK
Mon May 12 04:38:51 CDT 2008

Hi Trevor,

How did we arrive at .42 d calculation for each task? I think if I ca
understand that my doubt will be cleared.

Thanx in advance.

Trevor Rabey;3721890 Wrote:
> You need to see the Tracking Table, with Actual Duration and Remainin
> Duration
>
> TASK (SUMMARY) Wed 07/05/08 08:00 NA 50% 3d 3d
>
> 1 (SUMMARY) Wed 07/05/08 08:00 NA 45% 2.71d 3.29d
>
> 1.1 Wed 07/05/08 08:00 Thu 08/05/08 17:00 100% 2d 0d
>
> 1.2 Thu 08/05/08 08:00 NA 47% 1.42d 1.58d
>
> 1.3 Fri 09/05/08 08:00 NA 10% 0.42d 3.58d
>
> 1.4 Thu 08/05/08 08:00 NA 28% 1.42d 3.58d
>
> 1.5 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>
> 2 (SUMMARY) Wed 07/05/08 08:00 NA 60% 3.02d 1.98d
>
> 2.1 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>
> 2.2 Wed 07/05/08 08:00 NA 48% 2.42d 2.58d
>
>
> Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJEC
> PLANNING www.perfectproject.com.au
> "Trevor Rabey" <trabey@nospam.westnet.com.au> wrote in messag
> news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au...
> > Steve,
> > For this example, we don't need the links because he gives us th
> start
> > dates and they'll do as snet constraints just for getting the bars t
> be in
> > the right place.
> > Apart from the fact that putting 50% Complete into the main summar
> and
> > allowing MSP to distribute it downwards to the lower level summarie
> and
> > thence to the tasks is so wrong way round that no one would ever d
> it, it
> > is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
> > I tried to reverse engineer the numbers and gave up, for the moment.
> >
> > Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
> > www.perfectproject.com.au
> > "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
> > news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
> >> I'll give it a shot but first what are the links between the tasks?
> >>
> >> "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
> >> news:SwapnaK.393cne@DoNotSpam.com...
> >>>
> >>> Steve,
> >>>
> >>> Somehow I am confused. Would you mind explaining the % Calculatio
> of
> >>> the Task 1.2 please?
> >>>
> >>>
> >>> --
> >>> 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
> >>>
> >>
> >
>

--
Swapna
-----------------------------------------------------------------------
SwapnaK's Profile: http://forums.techarena.in/member.php?userid=4827
View this thread: http://forums.techarena.in/showthread.php?t=96232

http://forums.techarena.i

Trevor
Tue May 13 02:11:59 CDT 2008

It is easier to start at the top and go down.
50% at the summary gets distributed as 45% to 1 and 60% to 2, then so on
down to the tasks.
I am waiting for Steve's answer.

You should not be concerned about this because it is completely wrong to
start at the top anyway in real practice.
It is just an interesting puzzle with no real practical significance.

Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au
"SwapnaK" <SwapnaK.39alre@DoNotSpam.com> wrote in message
news:SwapnaK.39alre@DoNotSpam.com...
>
> Hi Trevor,
>
> How did we arrive at .42 d calculation for each task? I think if I can
> understand that my doubt will be cleared.
>
> Thanx in advance.
>
>
> Trevor Rabey;3721890 Wrote:
>> You need to see the Tracking Table, with Actual Duration and Remaining
>> Duration
>>
>> TASK (SUMMARY) Wed 07/05/08 08:00 NA 50% 3d 3d
>>
>> 1 (SUMMARY) Wed 07/05/08 08:00 NA 45% 2.71d 3.29d
>>
>> 1.1 Wed 07/05/08 08:00 Thu 08/05/08 17:00 100% 2d 0d
>>
>> 1.2 Thu 08/05/08 08:00 NA 47% 1.42d 1.58d
>>
>> 1.3 Fri 09/05/08 08:00 NA 10% 0.42d 3.58d
>>
>> 1.4 Thu 08/05/08 08:00 NA 28% 1.42d 3.58d
>>
>> 1.5 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>>
>> 2 (SUMMARY) Wed 07/05/08 08:00 NA 60% 3.02d 1.98d
>>
>> 2.1 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>>
>> 2.2 Wed 07/05/08 08:00 NA 48% 2.42d 2.58d
>>
>>
>> Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT
>> PLANNING www.perfectproject.com.au
>> "Trevor Rabey" <trabey@nospam.westnet.com.au> wrote in message
>> news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au...
>> > Steve,
>> > For this example, we don't need the links because he gives us the
>> start
>> > dates and they'll do as snet constraints just for getting the bars to
>> be in
>> > the right place.
>> > Apart from the fact that putting 50% Complete into the main summary
>> and
>> > allowing MSP to distribute it downwards to the lower level summaries
>> and
>> > thence to the tasks is so wrong way round that no one would ever do
>> it, it
>> > is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
>> > I tried to reverse engineer the numbers and gave up, for the moment.
>> >
>> > Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
>> > www.perfectproject.com.au
>> > "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
>> > news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
>> >> I'll give it a shot but first what are the links between the tasks?
>> >>
>> >> "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
>> >> news:SwapnaK.393cne@DoNotSpam.com...
>> >>>
>> >>> Steve,
>> >>>
>> >>> Somehow I am confused. Would you mind explaining the % Calculation
>> of
>> >>> the Task 1.2 please?
>> >>>
>> >>>
>> >>> --
>> >>> 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
>> >>>
>> >>
>> >
>> >
>
>
> --
> 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
>

SwapnaK
Tue May 13 04:12:18 CDT 2008

Hi Steve,

Please Help!!!

--
Swapna
-----------------------------------------------------------------------
SwapnaK's Profile: http://forums.techarena.in/member.php?userid=4827
View this thread: http://forums.techarena.in/showthread.php?t=96232

http://forums.techarena.i

Steve
Tue May 13 17:32:12 CDT 2008

Haven't had much time the last few days - I'll get back to ya!

"SwapnaK" <SwapnaK.39cdne@DoNotSpam.com> wrote in message
news:SwapnaK.39cdne@DoNotSpam.com...
>
> Hi Steve,
>
> Please Help!!!!
>
>
> --
> 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
>

Steve
Tue May 13 17:31:25 CDT 2008

You're correct, it doesn't really matter what the links are AFAIK. SNET
constraints on some of the tasks would have the same effect. Just wanted to
setup the same exact starting plan Swap had.

"Trevor Rabey" <trabey@nospam.westnet.com.au> wrote in message
news:9I-dnQ6pqYzdorTVnZ2dnUVZ_vjinZ2d@westnet.com.au...
> It is easier to start at the top and go down.
> 50% at the summary gets distributed as 45% to 1 and 60% to 2, then so on
> down to the tasks.
> I am waiting for Steve's answer.
>
> You should not be concerned about this because it is completely wrong to
> start at the top anyway in real practice.
> It is just an interesting puzzle with no real practical significance.
>
> Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
> www.perfectproject.com.au
> "SwapnaK" <SwapnaK.39alre@DoNotSpam.com> wrote in message
> news:SwapnaK.39alre@DoNotSpam.com...
>>
>> Hi Trevor,
>>
>> How did we arrive at .42 d calculation for each task? I think if I can
>> understand that my doubt will be cleared.
>>
>> Thanx in advance.
>>
>>
>> Trevor Rabey;3721890 Wrote:
>>> You need to see the Tracking Table, with Actual Duration and Remaining
>>> Duration
>>>
>>> TASK (SUMMARY) Wed 07/05/08 08:00 NA 50% 3d 3d
>>>
>>> 1 (SUMMARY) Wed 07/05/08 08:00 NA 45% 2.71d 3.29d
>>>
>>> 1.1 Wed 07/05/08 08:00 Thu 08/05/08 17:00 100% 2d 0d
>>>
>>> 1.2 Thu 08/05/08 08:00 NA 47% 1.42d 1.58d
>>>
>>> 1.3 Fri 09/05/08 08:00 NA 10% 0.42d 3.58d
>>>
>>> 1.4 Thu 08/05/08 08:00 NA 28% 1.42d 3.58d
>>>
>>> 1.5 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>>>
>>> 2 (SUMMARY) Wed 07/05/08 08:00 NA 60% 3.02d 1.98d
>>>
>>> 2.1 Wed 07/05/08 08:00 NA 81% 2.42d 0.58d
>>>
>>> 2.2 Wed 07/05/08 08:00 NA 48% 2.42d 2.58d
>>>
>>>
>>> Trevor RabeyTrevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT
>>> PLANNING www.perfectproject.com.au
>>> "Trevor Rabey" <trabey@nospam.westnet.com.au> wrote in message
>>> news:ItSdnSHAuJZeMr7VnZ2dnUVZ_uednZ2d@westnet.com.au...
>>> > Steve,
>>> > For this example, we don't need the links because he gives us the
>>> start
>>> > dates and they'll do as snet constraints just for getting the bars to
>>> be in
>>> > the right place.
>>> > Apart from the fact that putting 50% Complete into the main summary
>>> and
>>> > allowing MSP to distribute it downwards to the lower level summaries
>>> and
>>> > thence to the tasks is so wrong way round that no one would ever do
>>> it, it
>>> > is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
>>> > I tried to reverse engineer the numbers and gave up, for the moment.
>>> >
>>> > Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
>>> > www.perfectproject.com.au
>>> > "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
>>> > news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
>>> >> I'll give it a shot but first what are the links between the tasks?
>>> >>
>>> >> "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
>>> >> news:SwapnaK.393cne@DoNotSpam.com...
>>> >>>
>>> >>> Steve,
>>> >>>
>>> >>> Somehow I am confused. Would you mind explaining the % Calculation
>>> of
>>> >>> the Task 1.2 please?
>>> >>>
>>> >>>
>>> >>> --
>>> >>> 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
>>> >>>
>>> >>
>>> >
>>> >
>>
>>
>> --
>> 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
>>
>
>

Steve
Sat May 17 09:47:21 CDT 2008

Finally found some time to look at this.

Linking won't change status calcs as such but it will effect the start and
end times of tasks and that might. I'm thinking about how task 1.2 got to
be starting on May 8th and 1.3 got to May 9th. If it's a SNET constraint it
will probably start at 8am. But if it got there some other way, it might
start late in the day. It becomes important because we need to be able to
figure out how many "actual duration minutes" are being generated for each
minute worked. Remember, Project does ALL of its duration calculations in
minutes to the nearest 10th. Because not all of the tasks are going on all
of the time, the 50% complete point for the whole project does not
correspond to excatly 3 days into the project, or Friday at 5pm. Instead,
the 50% mark is on Friday roughly about 11 am. There are a total of 12000
minutes of duration to be worked [(2+3+4+5+3+3+5) * 8 * 60] and 50% complete
on the summary means we've worked 6000 of them. To get the percentages for
all the tasks and summaries, we have to go minute-by-minute from Wed at 8am
until Fri at 11+am and calculate the number of Actual Duration minutes each
clock minute represents. For instance, on Wed we have tasks 1.1, 1.5, 2.1,
and 2.2 taking place - each clock minute passing earns us 4 AD (Actual
Duration) minutes. On Thurs we have 1.1, 1.2, 1.4, 1.5, 2.1, and 2.2 taking
place - each clock minute earns us 6 AD minutes. On Fri we have 1.2, 1.3,
1.4, 1.5, 2.1, and 2.2 to also earn 6 AD minutes for each passing clock
minute.
Look at some status dates

Wed 5pm: Cummulative AD minutes worked 4*8*60 = 1920
Thur 5pm: Cummulative AD minutes worked 6*8*60+1920 = 4800
Fri 11am: Cummulative AD minutes worked 6*3*60+4800 = 5880

so the 6000 total minutes worked milestone occurs a few minutes after 11am
on Fri, roughly 11:05am. There are some slight discrpancies due to
accumulating roundoff errors. To figure the percent complete of each of the
individual subtasks, count up the number of minutes spent of each task
between its start and 11:05 am Friday and divide by the total duration of
the task in minutes. For task number 1.2, for example, its duration is 3
days or 1440 minutes. It starts Thur 8am so by Friday at 11:05, 665 minutes
have been worked on it. (655/1440)*100 = 46.2%, close enough to the
displayed value of 47% for government work <grin>.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs

"SwapnaK" <SwapnaK.394nvd@DoNotSpam.com> wrote in message
news:SwapnaK.394nvd@DoNotSpam.com...
>
> Hi Steve,
>
> No links as of now between tasks. BTW, does linking change Status
> Calculation as well? If yes, probably once i am clear on this, I might
> request again for explaining that scenario as well. :-).
>
>
>
>
> Trevor Rabey;3721639 Wrote:
>> Steve,
>> For this example, we don't need the links because he gives us the
>> start
>> dates and they'll do as snet constraints just for getting the bars to
>> be in
>> the right place.
>> Apart from the fact that putting 50% Complete into the main summary
>> and
>> allowing MSP to distribute it downwards to the lower level summaries
>> and
>> thence to the tasks is so wrong way round that no one would ever do it,
>> it
>> is still interesting. Summaries 1 and 2 get 45% and 47% for a start.
>> I tried to reverse engineer the numbers and gave up, for the moment.
>>
>> Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
>> www.perfectproject.com.au
>> "Steve House [MVP]" <sjhouse at hotmail dot com> wrote in message
>> news:e690skSsIHA.5580@TK2MSFTNGP04.phx.gbl...
>> > I'll give it a shot but first what are the links between the tasks?
>> >
>> > "SwapnaK" <SwapnaK.393cne@DoNotSpam.com> wrote in message
>> > news:SwapnaK.393cne@DoNotSpam.com...
>> >>
>> >> Steve,
>> >>
>> >> Somehow I am confused. Would you mind explaining the % Calculation
>> of
>> >> the Task 1.2 please?
>> >>
>> >>
>> >> --
>> >> 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
>> >>
>> >
>
>
> --
> 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
>

% Complete Calculation

Re: % Complete Calculation by salgud

Re: % Complete Calculation by Trevor

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Rod

Re: % Complete Calculation by Steve

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Steve

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Steve

Re: % Complete Calculation by Trevor

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Trevor

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Trevor

Re: % Complete Calculation by SwapnaK

Re: % Complete Calculation by Steve

Re: % Complete Calculation by Steve

Re: % Complete Calculation by Steve