Time Phased Data Export

[Cheryl]

Develop a user friendly add in that exports time phased data by resource to
MS Excel. Allow the user to select all resources or specific resources. The
request for this comes up all over the boards. Currently to accomplish this
one must be an advanced programmer. The analyze time phased data does not
provide resource information. The users need this information in Excel to
analyze resource usage and overallocations.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...c18d75b&dg=microsoft.public.project.developer

 

[Dale Howard [MVP]]

Cheryl --

Although I appreciate your suggestion, the capability already exists in
Microsoft Project. If you apply any Resource view, such as Resource usage,
and then run the Analyze Timescaled Data Wizard, you can "push" the
information for selected resources directly to Excel. Hope this helps.

 

[Cheryl]

Dale,
Thanks for the suggestion, however, the Analyze Time scaled data is not
flexible in the field(s) that it allows you to export. I need to extract
Resource information and customized text fields and number fields...etc. The
flexibility is simply not there. I see other posts across the board
requesting similar information. I also, as I have seen in other posts, have
the need to extract information from the task (gantt chart) fields as well as
it's associated custom text and number fields.
I hope that microsoft will consider this.
Cheryl

 

[JohnK]

Cheryl,
Whilst I support your enhancement, it is possible to get MS Project
Resource Time Phased Data into Excel without programming using
MSDATASHAPE e.g.

From Excel Menu Data>Import External Data>Import Data...

From the Select Data Source Wizard, click the New Source... button

From the Data Connection Wizard, Choose Other/advanced

From the Data Link Properties Wizard

On the Provider Tab select MSDataShape
On the All Tab, edit Extended Properties and type in Project
Name=Z:\your project file.mpp and edit the Data Provider to be
Microsoft.Project.OLEDB.11.0
Click OK (This takes you back to the Data Connection Wizard)

Select any table (you will override this later)
Click Next
Enter a unique filename and Click Finish (This takes you back to the
Data Source Wizard)

On the Data Source Wizard, click the Open button (This takes you back
to Excel)

On the Import Data Wizard click Edit Query...
Change the Command Type to SQL (MSDataShape uses SQL type statements)
and type in your SQL statement e.g. SELECT AssignmentUniqueID,
AssignmentTimeActualWork , AssignmentTimeWork, AssignmentTimeStart FROM
AssignmentTimephasedByDay WHERE
AssignmentTimeWork>AssignmentTimeActualWork

The only problems I have found are Null fields come through as
2.69653970229347E+308 so you have to replace 2.69653970229347E+308 by 0
and the time fields need to be divided by 60000 to get hours. The
Resource Name is found to doing the same procedure on the Assignment
Table and using VLOOKUP to get the Resource Name into the Timephased
data table.

Best Wishes,
John.