M
Mal Watts
All;
I have a problem when exporting data to Excel for analysis. Actually, two
problems. Would appreciate anyone's advice.
1. When exporting data for earned value analysis, I seem to be hitting
some kind of "wall" after which all of my data goes to zero. I'm exporting
BCWP, BCWS, ACWP, SV and CV fields to Excel 2003, from Project Standard
2002. I get no error messages, and I'm exporting about 100 "time periods".
The first 30-ish percent of my data looks fine. Then, after 16th May this
year every single figure in the Excel sheet becomes zero.
Example: In MSP, I can look at my Gantt chart and see a task which starts on
20 May, is of duration 2 weeks, and is 100% complete. It has an assigned
resource, and the cost rate of the resource is non-zero. So it should have
an impact on BCWS, BCWP,and ACWP. When I look at the entry for that task in
Excel, every datum is zero for all time, even BCWS. If I insert the BCWS
column into the Gantt view, sure enough, the value is 0 in that column, EVEN
IF I can clearly see work assigned to a resource for that task.
Any ideas ? The help file says nothing helpful. I can't work out what's
special about May 16th. It would have been at about this time that I
re-baselined I think (have not saved any baselines since then)... and at
about that time I also "re-scheduled unstarted tasks to start on current
date". Could this affect data export ? How do I fix it ? Why would
Project export zero data for a task which clearly HAS data (without telling
me) ?
2. How do we overcome the only-255-columns in Excel problem ? I want to
analyze a project which has more than 255 time-periods. In this case,
duration longer than 255 days, and I want to analyze day-by-day. At
present, my workaround has been to analyze week-by-week, but that's a hack,
not a solution.
(Actually, what I *really* want is decent Earned Value analysis, not this
Mickey Mouse export-to-Excel feature, but that's a question for another
day).
Thanks for any help,
Mal.
I have a problem when exporting data to Excel for analysis. Actually, two
problems. Would appreciate anyone's advice.
1. When exporting data for earned value analysis, I seem to be hitting
some kind of "wall" after which all of my data goes to zero. I'm exporting
BCWP, BCWS, ACWP, SV and CV fields to Excel 2003, from Project Standard
2002. I get no error messages, and I'm exporting about 100 "time periods".
The first 30-ish percent of my data looks fine. Then, after 16th May this
year every single figure in the Excel sheet becomes zero.
Example: In MSP, I can look at my Gantt chart and see a task which starts on
20 May, is of duration 2 weeks, and is 100% complete. It has an assigned
resource, and the cost rate of the resource is non-zero. So it should have
an impact on BCWS, BCWP,and ACWP. When I look at the entry for that task in
Excel, every datum is zero for all time, even BCWS. If I insert the BCWS
column into the Gantt view, sure enough, the value is 0 in that column, EVEN
IF I can clearly see work assigned to a resource for that task.
Any ideas ? The help file says nothing helpful. I can't work out what's
special about May 16th. It would have been at about this time that I
re-baselined I think (have not saved any baselines since then)... and at
about that time I also "re-scheduled unstarted tasks to start on current
date". Could this affect data export ? How do I fix it ? Why would
Project export zero data for a task which clearly HAS data (without telling
me) ?
2. How do we overcome the only-255-columns in Excel problem ? I want to
analyze a project which has more than 255 time-periods. In this case,
duration longer than 255 days, and I want to analyze day-by-day. At
present, my workaround has been to analyze week-by-week, but that's a hack,
not a solution.
(Actually, what I *really* want is decent Earned Value analysis, not this
Mickey Mouse export-to-Excel feature, but that's a question for another
day).
Thanks for any help,
Mal.