Project Reports

[Steve NCC]

How do I export the results of a Project Report (Reports/Workload/Resource
Usage) to an excel spreadsheet. At the moment I print to a utility that can
create a spreadsheet, manually create the columns etc but it is very time
consuming and prone to errors.

 

[John]

How do I export the results of a Project Report (Reports/Workload/Resource
Usage) to an excel spreadsheet. At the moment I print to a utility that can
create a spreadsheet, manually create the columns etc but it is very time
consuming and prone to errors.

Steve,
There is no direct method. Project's built-in reports are unfortunately
for print only. However, besides your own method there are other options.

Since you are using timescaled data, you could try the "Analyze
timescaled data in Excel" utility found on the "Analysis" toolbar. You
will still have to massage and format the data once it gets into Excel
though.

If you have some experience with VBA (or know someone who does), the
best method is to create a VBA macro to export the data you want and
format it as needed. Once the code is developed, running it can be as
simple as hitting a button on a toolbar.

Hope this helps.
John
Project MVP

 

[Steve NCC]

John

The time analysed data doesn't refer to resource usage. Am I mising something.

Thanks

 

[John]

John

The time analysed data doesn't refer to resource usage. Am I mising
something.

Thanks

Steve,
I'm not sure I understand what you didn't understand but let me try to
clarify. You mentioned wanting a report for resource usage. Any usage
view (or report) in Project is timescaled, that is, the data on the
right side of the screen is time-phased. The only directly available
method for exporting time-phased data is via the "Analyze timescaled
data in Excel" utility (or a VBA macro developed by the user). Running
the utility from different views will give slightly different results -
try it using the Gantt Chart view, Resource Usage view and Task Usage
view. Note that you cannot run the utility for a built-in report.

Does that help? If not please elaborate.

John
Project MVP