Re: statistical graph showing percentages

In article <CB1B73F8-1444-4CDF-B2D7-C6E811D3EEF7@xxxxxxxxxxxxx>,
Sandy82 <Sandy82@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I would like to produce a statistical graph in excel showing the percentage
of the duration of the project elapsed and the percentage of the tasks
completed, in comparison with the baseline.

Sandy82,
There are various ways to do it, but first a little better understanding
of your parameters is required. For example, are you looking for a set
of three data points for the whole project taken over time (i.e. 3 data
points as of today, 3 more as os next Monday, etc.), or are you trying
to plot 3 data points for each and every performance task? Also, what do
you mean by "baseline"? Project has several baseline fields. Are you
talking about baseline duration, baseline start, baseline finish, or
some other baseline?

Once the parameters are nailed down and appropriate data calculated (if
necessary), the data can be exported to Excel using an export map, a VBA
macro, or if you have Project 2007, visual reports.

Lots of options.

John
Project MVP
.

Relevant Pages

  • Re: statistical graph showing percentages
    ... This plan was saved as a baseline. ... not simply task duration information). ... scheduled duration and subject to change as the schedule is ... The first filter would find all tasks that are between month ...
    (microsoft.public.project)
  • Re: Automatic calculation w/ add duration to "planned start/finish
    ... The baseline should NOT recalculate. ... That's the whole reason it exists - as the schedule changes due to actuals turning out different from what was planned, the baseline preserves the original plan for comparison. ... Note that there are three sets of fields: Start, Finish, and Duration; Actual Start, Finish, and Duration; and Baseline Start, Finish, and Duration. ...
    (microsoft.public.project)
  • Re: Buffer or lag periods
    ... They are correct that the baseline should only be changed given a scope change but keep in mind that the baseline is not an objective or productivity target. ... My intention behind the buffer time was "not to keep the resource reserved" ... wrong in the effoprt estimate but the duration. ... it will take him 3 days no matter what your schedule calls ...
    (microsoft.public.project)
  • Re: statistical graph showing percentages
    ... predicted task durations (baseline). ... duration is the difference in working time between the start ... The first filter would find all tasks that are between month ... option and I have to produce a chart or report that shows the total ...
    (microsoft.public.project)
  • Re: Actual Work Greater than Baselined Work
    ... Project, I'll probably use Work, Resource Names, Predecessors, Project Start ... customized Duration field to hold task actual effort and duration. ... If you have a baseline work of X man-hours ... only way he can do more is by extending his workday with overtime, ...
    (microsoft.public.project)