Laura McA said:
I'd like to export Resource by Project by %Allocated data from Project to
Excel.
Any ideas?
Laura,
You don't mention if you need timescaled data or just the static (i.e.
total) values. Depending on exactly what you need, there are several
options. If the data is static, you could use one or more export maps to
export the Project data to an Excel Worksheet. You can read details on
how to do that in the help file. If you want timescaled data, you may be
able to get what you want by using the "analyze timescaled data in
Excel" add-in/utility found on the Analysis toolbar. In either case it
may take more than one export to get all the necessary data but once it
is in Excel, you can manipulate it as needed.
Of course there is always the brute force method of setting up the view
to show what you want and then using cut and paste to transfer the data.
This can work quite well if the export is simple and you don't need to
do it on a regular basis.
The most flexible method requires the use of an advanced feature of
Project, namely VBA. With a VBA macro, Project data of any kind can be
exported to Excel and formatted into whatever form you need. I
personally prefer this approach because it offers the most flexibility
and once the code is written, the export can be initiated with the click
of a toolbar button.
You asked for ideas. Now you have some.
John
