% Complete Calculation

[SwapnaK]

Hi Steve,

Please Help!!!!

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/members/48275.htm
>>> >>> View this thread:
>>> % Complete Calculation
>>> >>>
>>> >>> http://forums.techarena.in
>>> >>>
>>> >>
>>> >
>>> >
>>
>>
>> --
>> SwapnaK
>> ------------------------------------------------------------------------
>> SwapnaK's Profile: http://forums.techarena.in/members/48275.htm
>> View this thread: % Complete Calculation
>>
>> http://forums.techarena.in
>>
>
>

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/members/48275.htm
> View this thread: % Complete Calculation
>
> http://forums.techarena.in
>

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/members/48275.htm
>> >> View this thread:
>> % Complete Calculation
>> >>
>> >> http://forums.techarena.in
>> >>
>> >
>
>
> --
> SwapnaK
> ------------------------------------------------------------------------
> SwapnaK's Profile: http://forums.techarena.in/members/48275.htm
> View this thread: % Complete Calculation
>
> http://forums.techarena.in
>