This is a question regarding Visual Reports in Microsoft Project and exporting to Excel

Microsoft Project exports the Cashflow Visual Report to an Excel Pivot Table. It graphs the Cost over time. This refers to the cost of all tasks occuring on that day.

In the pivot table field list, there is Time >Time Weekly Calendar on the Axis.

1. Do you know how I can copy this Time Weekly Calendar to another excel file.

2. If I was to export the Cost1 field in Project, how do you calculate the daily Cost1 for all tasks occuring on that day?
Project uses the Cost field by default and it automatically calculates the daily cost of all tasks for that day and graphs this cost over time.

cashflowb.xls