determining percented completed needed to be on schedule

[Mark VII]

Greetings -

We need to be able to answer the question of "what percent complete do we
need in order to be on schedule as of a specified date", but I don't see a
way to get this directly from Project at the summary task or project level.
The software is obviously doing something internally because the status field
shows values of "on schedule" vs "late", based on the % complete field.

At the individual task level, I was able to work something up at the
individual task level based on duration and time elapsed since task start.
Basically, the formula is ([report date] - [task start date])/([duration]).

Where I'm having difficulty is computed the needed percent complete at some
level of summary. In our case, this is not only for subtasks, but also based
on groupings of tasks that don't neatly fall into the outline structure (long
story).

Does anyone have any suggestions?

Thanks in advance,
Mark

 

[Rod Gill]

Don't think you can do this reliably. For example if a task has 10h of work
and is 50% complete , was it 50% complete after 5h, 2h or 20h? I think you
need to assign resources and then work out how much work should be done each
week and what that amount of work should achieve. That is the only reliable
way of predicting progress. People do work and work done completes tasks
(eventually!) % complete is a very poor measure of progress on its own.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[David]

Hi Rod,
I can see you give us a lot help and answer the question over here. I
understand also is most psi related questions be ignored and could you please
let me know if somewhere we can find psi related answer. I did submitted two
question here
1, how to get task, resource and assignment uniqueid in psi dataset.
2, how to check if the project is checked in from psi like the one in object
module
CanCheckOut ().
Thanks.
--
David

Don't think you can do this reliably. For example if a task has 10h of work
and is 50% complete , was it 50% complete after 5h, 2h or 20h? I think you
need to assign resources and then work out how much work should be done each
week and what that amount of work should achieve. That is the only reliable
way of predicting progress. People do work and work done completes tasks
(eventually!) % complete is a very poor measure of progress on its own.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------

Greetings -

We need to be able to answer the question of "what percent complete do we
need in order to be on schedule as of a specified date", but I don't see a
way to get this directly from Project at the summary task or project
level.
The software is obviously doing something internally because the status
field
shows values of "on schedule" vs "late", based on the % complete field.

At the individual task level, I was able to work something up at the
individual task level based on duration and time elapsed since task start.
Basically, the formula is ([report date] - [task start
date])/([duration]).

Where I'm having difficulty is computed the needed percent complete at
some
level of summary. In our case, this is not only for subtasks, but also
based
on groupings of tasks that don't neatly fall into the outline structure
(long
story).

Does anyone have any suggestions?

Thanks in advance,
Mark

 

[Rod Gill]

Sorry, psi programming requires good skills in C# and web services. I guess
very few people with those skills are in this ng, but I have noticed some
Microsoft people recently helping out, so persevere!

Until now this group has been all VBA based.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------

Hi Rod,
I can see you give us a lot help and answer the question over here. I
understand also is most psi related questions be ignored and could you
please
let me know if somewhere we can find psi related answer. I did submitted
two
question here
1, how to get task, resource and assignment uniqueid in psi dataset.
2, how to check if the project is checked in from psi like the one in
object
module
CanCheckOut ().
Thanks.
--
David

Don't think you can do this reliably. For example if a task has 10h of
work
and is 50% complete , was it 50% complete after 5h, 2h or 20h? I think
you
need to assign resources and then work out how much work should be done
each
week and what that amount of work should achieve. That is the only
reliable
way of predicting progress. People do work and work done completes tasks
(eventually!) % complete is a very poor measure of progress on its own.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------

Greetings -

We need to be able to answer the question of "what percent complete do
we
need in order to be on schedule as of a specified date", but I don't
see a
way to get this directly from Project at the summary task or project
level.
The software is obviously doing something internally because the status
field
shows values of "on schedule" vs "late", based on the % complete field.

At the individual task level, I was able to work something up at the
individual task level based on duration and time elapsed since task
start.
Basically, the formula is ([report date] - [task start
date])/([duration]).

Where I'm having difficulty is computed the needed percent complete at
some
level of summary. In our case, this is not only for subtasks, but also
based
on groupings of tasks that don't neatly fall into the outline structure
(long
story).

Does anyone have any suggestions?

Thanks in advance,
Mark