can project predict percent complete values?

[fullstacks]

I want to use these values to track progress in a line chart format in excel.

 

[John]

I want to use these values to track progress in a line chart format in excel.

fullstacks,
What do you mean by "predict percent complete values"? If you mean
predict future performance, then no. The best you can do is to develop
an algorithm that uses past performance data to predict the short term
future but that will require VBA. If you mean predict percent complete
up to the current data, what Project fields will be used for the
criteria?

John
Project MVP

 

[fullstacks]

Basically, I am trying to generate a line graph in excel that has 4 lines.
One for early start % complete (optimistic), late start percent complete
(pesimistic), an average of those two, and then actual percent complete. The
wizard that creates these charts from project to excel only exports work and
cost data. I want to export schedule data. I think what ia am trying to do
is to convey the info on a tracking gantt view in a line graph. Except for
the actual % complete line, I want to chart the other three before any work
has been done so that I can compare actual progress to them.

 

[John]

Basically, I am trying to generate a line graph in excel that has 4 lines.
One for early start % complete (optimistic), late start percent complete
(pesimistic), an average of those two, and then actual percent complete. The
wizard that creates these charts from project to excel only exports work and
cost data. I want to export schedule data. I think what ia am trying to do
is to convey the info on a tracking gantt view in a line graph. Except for
the actual % complete line, I want to chart the other three before any work
has been done so that I can compare actual progress to them.

fullstacks,
I'm still having trouble understanding how you intend on getting early
and late start % complete if you want the data before any work has been
done. Percent complete defines how much of the task is complete (i.e.
resources have been applied and work has been done), so how do you get
any kind of % complete if nothing has been done. It just doesn't compute.

With regard to getting schedule information to Excel. When you refer to
a wizard that exports data from Project to Excel for charts I'm assuming
you are referring to the "analyze timescaled data in Excel" utility.
However, it doesn't sound like you need timescaled data. What you want
is a periodic export of customized static data. My approach to that is a
custom VBA macro. Using VBA you can generate and export any Project data
you want to Excel and plot it all with the push of a single toolbar
button (for example). But until I (or perhaps someone else) can
determine exactly what you want, it is difficult to provide additional
assistance.

John
Project MVP

 

[doniy]

% complete= X completed/total X
if you have not used resource and assign works, then your % complete is
based on duration.
so predict % complete at a furture day, i think, is the duration of all the
tasks planed to elapse up to that date/total duration of all the tasks.
if you assigned works or cost, then predict % complete=budget for work
planned/total budget

 

[Steve House [MVP - MS Project]]

FYI - "% Complete" in Project ALWAYS refers to duration. Work is "% Work
Complete" and there is also a "% Physical Complete" field available if you
wish to use it. "% Complete" and "% Work Complete" are usually linked so
that updating one updates the other but there is an option setting to sever
the link if one chooses. % Complete predicted for a task on a certain
status date could be calculated from duration that should be completed by
that date divided by the total duration but for the life of me I can't see
what information that number gives you or what use such a number would be in
terms of managing and tracking the project.