Report export to Excel?

[Kamil Dursun]

Hello,

I want to export timephased assignment costs to Excel. I cannot see the
Analysis Wizard can do this.

I have made a crosstab report that prints out timephased assignment costs
just the way I want.

Can I export the report to Excel?

Thanks for any help.
Kamil

 

[John]

Hello,

I want to export timephased assignment costs to Excel. I cannot see the
Analysis Wizard can do this.

I have made a crosstab report that prints out timephased assignment costs
just the way I want.

Can I export the report to Excel?

Thanks for any help.
Kamil

Kamil,
What exactly do you mean by "assignment costs"? Unless you have
non-labor costs (e.g. material or fixed costs), the Cost field itself is
the assignment cost.

To export timescaled data to Excel, you have two choices. If the
timescaled fields are built-in fields (e.g. Cost, Work, Peak Units,
etc.) you can use the "analyze timescaled data in Excel" add-in/utility
found on the "Analysis" toolbar. If you need timescaled data for
customized fields, you, or someone, will need to create VBA code to
calculate the data and export it to Excel.

Unfortunately one of the limitations of built-in reports is that they
cannot be saved or exported. However as noted in the previous paragraph,
any data (built in or other) can be exported to Excel (or other
applications that support VBA) with a VBA macro.

Hope this helps.
John
Project MVP

 

[Kamil Dursun]

Thanks for the reply John,

I need to export detailed-timephased assignment costs to Excel i.e. if there
are more than one resource assigned to a task, I need each of the resource
costs separately.

It was really not so difficult; I first set up the Task Usage table and
cut/pasted the data into Excel. It worked.

If I need more sophisticated solutions, I will have to write a macro but
that will be later.

regards
Kamil

 

[John]

Thanks for the reply John,

I need to export detailed-timephased assignment costs to Excel i.e. if there
are more than one resource assigned to a task, I need each of the resource
costs separately.

It was really not so difficult; I first set up the Task Usage table and
cut/pasted the data into Excel. It worked.

If I need more sophisticated solutions, I will have to write a macro but
that will be later.

regards
Kamil

Kamil,
Cut and paste is the brute force approach but it will certainly work in
a pinch. I wouldn't want to use it though on a regular basis - too error
prone and very inefficient.

John