Re: statistical graph showing percentages

Thank you for your reply John, I should add I have tried various methods of
acomplish this e.g. exporting to excel by way of the analysis timephased
option and the "save as xls" but I cannot seem to find the correct
information to imput to achieve the desired results. I would be very
grateful for any suggestions you may have as presently I am wading through 3
different MS Project Books and seem to be going round in circles.
Best regards
Sandy82

"Sandy82" wrote:

Forgive me if I was a little vague, I am a complete novice with Project. I
have to create a report or graph which shows, month on month cumulatively,
the percentage of tasks which have been completed in comparison to the
predicted task durations (baseline). There are no resources or costs to
consider.


"John" wrote:

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: How can I view the % complete where a project task should be?
    ... Very good John, perhaps I should replied - can't be done. ... Multiple baselines, tasks may not all have the same baseline, and of course ... Critical – Cannot be achieved in given time scale (including slack). ... Tracking late – consuming total slack. ...
    (microsoft.public.project)
  • Re: Baseline Save Date & External Reporting
    ... "John" wrote: ... LindaC wrote: ... Note however that if you save a new baseline for selected tasks (e.g. ... Project MVP ...
    (microsoft.public.project)
  • Re: Baseline Save Date & External Reporting
    ... LindaC wrote: ... "John" wrote: ... Note however that if you save a new baseline for selected tasks (e.g. ... Project MVP ...
    (microsoft.public.project)
  • Re: Graphical indicators
    ... thanks John ... do you know what all these MI5 posts are all about? ... I want to set up in a text field, graphical indicators so that the image ... turns red if the current start date is>10 days after the baseline date, ...
    (microsoft.public.project)
  • Re: Track Estimated vs Actual work
    ... John, thanks, I thought that might be the case. ... What is the best way to then compare the Baseline schedule to your current ...
    (microsoft.public.project)
Loading