Error Analyzing Timescaled BCWS in Excel

[Juan Pablo Morales]

I have a very simple project, with two tasks with fixed costs, and a baseline.
I change the actual dates of the tasks, and change the status date to be
after the project's finish.
This means that the new BCWS should be the sum of fixed costs. On project
this is true, but when exporting the information to excel the sum is lower.
How can this be? How can Project produce one result and then by exporting to
excel produce another?

To give an idea of scales, Project says (correctly) that the BCWS is 3000,
but Excel says it is 1666.
Is this a bug? What am I missing?

For further information the project file is available at
http://www.ingenian.com/~foxtrot/project.mpp
I am using Project 2003 wirth the latest patch applied.

 

[Juan Pablo Morales]

Oops I reviewed and the file linked is correct, it just has bad default
times for generation of timescaled data. However I have a larger file that
has these errors, even if dates are set correctly.

 

[Juan Pablo Morales]

After a lot of fighting I discovered what can only be described as a bug
with Project Exporting into Excel.

What happens is: If I set a fixed cost on a task that has children this
task gets into the calculatrions for Earned value, but it's value is not
exported into excel. That is, it is not taken into account fo the Excel
total.

 

[John]

After a lot of fighting I discovered what can only be described as a bug
with Project Exporting into Excel.

What happens is: If I set a fixed cost on a task that has children this
task gets into the calculatrions for Earned value, but it's value is not
exported into excel. That is, it is not taken into account fo the Excel
total.

Juan,
It is not an "error" or bug. The "analyze timescale data in Excel"
utility does not export Summary line values. You mentioned that you
applied a Fixed Cost to a task with children. That means a Summary line.
Applying any resources, labor, material or fixed to Summary lines is not
recommended. Rather, set up a separate subtask under the Summary and
apply the Fixed Cost to that.

Hope this helps.
John
Project MVP