Exporting Cost Data to Excel

[Jack]

Hi,

I'm trying to export project cost data to excel. I've used the "Timescale
data to Excel" wizard, which reports project cost data accurately in Excel,
but it doesn't allow you to add any additional field, like resource,
start/stop dates etc.

I have also tried to save the whole project to Excel using the export to
Excel wizard and it allows you to customize the fields that you want to
transfer, but the cost data isn't accruate due to the summary tasks. If you
sum up the total costs for each task in the project the summary tasks get
added twice, and your total costs are off.

I'm looking for a way to exclude summary task cost when extracting Excel
data, (like the Timescale report provide), but still have assess to extract
other project fields.

Thanks for your help,
Jack



I've used the "Timescale data to Excel" wizard and

 

[Jan De Messemaeker]

Hi,

Just a thought, you could export the "summary" field and base an Excel
formula on its value.
HTH