Analyze Timescaled Data in Excel % complete problem

D

Duane Nutley

Whenever I have used the Analyze Timescaled Data I have never had a problem
with it. But recently someone asked why the wizard does not seem to work with
either the Cumulative % Complete or Percentage Complete fields.

So I went to an old project, put in actual values and ran the wizard. Stated
that I wanted the Percentage Complete field, not the Work field, told it for
the entire project and told it to graph.

The result - the graph is on 0% and in the sheet with the data, the Total
Percentage Complete contains 0.
Now when I did the same report but with the Work field it worked and I
noticed in the Total field that it uses the Sumif calculation, yet when I
used the Percentage Complete field it used no calculation and just had 0%.

Anyone else experienced the same problem, or if you try it what happens for
you?
Note I am using Project 2003 SP 3, and have tried it on Project 2003 SP 2. I
don't know which version of Project 2003 the original person had.
 
J

JulieS

Duane Nutley said:
Whenever I have used the Analyze Timescaled Data I have never had a
problem
with it. But recently someone asked why the wizard does not seem to
work with
either the Cumulative % Complete or Percentage Complete fields.

So I went to an old project, put in actual values and ran the wizard.
Stated
that I wanted the Percentage Complete field, not the Work field, told
it for
the entire project and told it to graph.

The result - the graph is on 0% and in the sheet with the data, the
Total
Percentage Complete contains 0.
Now when I did the same report but with the Work field it worked and I
noticed in the Total field that it uses the Sumif calculation, yet
when I
used the Percentage Complete field it used no calculation and just had
0%.

Anyone else experienced the same problem, or if you try it what
happens for
you?
Note I am using Project 2003 SP 3, and have tried it on Project 2003
SP 2. I
don't know which version of Project 2003 the original person had.

Hello Duane,

Most likely not much solace, but yes, I see exactly what you report.
When exporting either the Percent Complete or the Cumulative % Complete,
the totals row is not calculating, therefore the graph is incorrect..

However, all is not lost. In my export the Project Summary Task line in
the worksheet does show the correct Percent Complete and Cumulative %
Complete. Just change the reference in each of the series to the
correct data in the worksheet and you should be all set.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project
 
D

Duane Nutley

Hello Duane,
Most likely not much solace, but yes, I see exactly what you report.
When exporting either the Percent Complete or the Cumulative % Complete,
the totals row is not calculating, therefore the graph is incorrect..

However, all is not lost. In my export the Project Summary Task line in
the worksheet does show the correct Percent Complete and Cumulative %
Complete. Just change the reference in each of the series to the
correct data in the worksheet and you should be all set.

I hope this helps. Let us know how you get along.

Thanks for the info Julie. Weird thing is that in a couple of different
project I experimented with, none of them exported the Project Summary Task
info (Task 0), even though it was in the project. I found that I had to
select the task, and then tell the wizard to only export selected tasks.

But again thanks for letting me know that of course I could work from
Project Summary Task data.

Duane
 
J

JulieS

Duane Nutley said:
Thanks for the info Julie. Weird thing is that in a couple of
different
project I experimented with, none of them exported the Project Summary
Task
info (Task 0), even though it was in the project. I found that I had
to
select the task, and then tell the wizard to only export selected
tasks.

But again thanks for letting me know that of course I could work from
Project Summary Task data.

Duane

You're welcome Duane and thanks for the feedback. Glad to know you
found a work-around.

Julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top