Hi Rod,
I checked out earned value, but don't find it very relevant to what
I
am
getting at.
I probably didn't use the proper terminology here, which may be
causing
some confusion. This is what I want to find out, for example, a
developer
is
assigned to a task scheduled for 10 days. Now 5 working days have
passed
and
he has completed 30 percent of the work for the task( work complete
percentage is 30%). Since his duration pecent is 5/10 = 50%, so we can
say
he
is behind schedule by 20%.
So, by duration, I mean the scheduled time for a resource to finish
his
tasks in a project. By comparing the duration percent (work time
passed/
shceudled time to finish his assigned tasks in a project) and work
percent,
we would be able to tell if he is behind or ahead of his schedule in
completing tasks and answer the question you raised -- at what hour he
is
50%
complete.
Does this make sense?
--
Lang
:
Resources don't have durations: tasks do. Therefore there is no %
complete
for resources only % work complete. % complete on its own is only a
very
approximate measure of progress. For example, a 10 hour task 50%
complete:
is it 50% complete after 4h, 5h, or 8h and how many really remaining?
%
complete on its own cannot tell you whether you are ahead or behind
schedule
for a resource.
I think you need to read help on earned value, but that only works
well
when
you have very accurately scheduled resources and very accurately
tracked
their progress.
--
Rod Gill
Project MVP
Visit
www.msproject-systems.com for Project Companion Tools and more
Thanks for the reply, Rod.
I am not sure I get what you mean by duration is meaningless. What I
am
trying to get is to see how much a developer is ahead or behind his
work
for
all the tasks he is assinged to as a whole in a project. He may have
made
progress on different tasks, maybe not exactly in the order
scheduled.
So,
I
thought I would be able tell by comparing duration percent and work
percent
-- if work percent is larger than duration percent, he is ahead of
schedule,
otherwise, he is behind.
Is the correct way to get such info?
--
Lang
:
Hi,
Duration is meaningless and not calculable for a resource, but in
the
Resource Sheet you can insert the % Work Complete column.
--
Rod Gill
Project MVP
Visit
www.msproject-systems.com for Project Companion Tools and
more
Thanks for the response, John.
On the question of percent complete info for each developer, I
mean
the
info
for each developer on a project as a whole (not on a task). For
example,
there are five developers working on a project and work on
different
tasks. I
want to get the percent complete info (work percent and duration
percent)
for
each of the five developers separately.
I guess I can use a Macro to add up all the percent info of tasks
that
a
developer works on, but I haven't used macro before in MS Project
and I
wonder if there is a easier way.
Thanks for the help again.
--
Lang
:
I posted this question on Microsoft Project General Questions,
but
haven't
got any reply. Want to try here.
If you open a project, open project information
dialog and then click statistics button at the bottom, you
will
see
the
Percent Complete info, which includes both duration percent
and
work
percent.
Question:
- How to obtain such information for each
developer?
- How to obtain such information for each top
level
task?
I have spent lots of time on this and still
couldnâ?Tt
figure it
out. I want to get statistics for each developer on how they
are
doing
on a
project. For example, I can divide the work percent by
duration
percent, then
I could tell how much(in percentage) a developer is ahead or
behind
of
schedule.
Thanks for the help in advanace,
Lang
Lang,
If by "each developer" you mean the percent complete information
you
see
in Task Information/Statistics, then the ProjectSummaryTask
Property
is
probably what you want.
Top level % Complete =
ActiveProject.ProjectSummaryTask.PercentComplete
Top level % Work Complete = [same as above except
".PercentWorkComplete"]
To get the information for each top level task I assume you mean
for
each Summary Line. This will require looping through all Summary
Lines
in the file and then looking at the same information as above. A
simple
macro to do this might look something like this: (Note: if the
option
to
show the Project Summary Task is selected this will pick up the
top
level data also).
Sub Data()
FilterApply Name:="summary tasks"
SelectTaskColumn
Set Area = ActiveSelection.Tasks
For Each t In Area
SummPC = t.PercentComplete
SummPWC = t.PercentWorkComplete
Next t
End Sub
Hope this helps.
John
Project MVP
