Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Creating Timescaled Resource Data Reports

1 reply [Last post]
Tue, 2006-09-26 09:11
Paul Harris
User offline. Last seen 1 year 16 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
I have a client with a Microsoft Project schedule that has multiple projects in one schedule:

1. Projects and Areas identified using Outlining
2. Multiple resources assigned against activities
3. Project, Areas, Clients and Funding Sources identified in Text Columns, thus Projects and Areas are available in both outlining and Text columns.

They require reports with:

The Horizontal axis showing Quarters, Months or Weeks (a report for each)
Vertical axis showing
One Text Column (Say Client)
Second Text Column (Say Funding Source)
Budget/Actual/To Complete
Resource Quantity and/or Resource Cost

My understanding is after some experimenting that:
1. Analyze Time Scaled data in Excel does not export Resources
2. Exporting to Excel does not support timescaled data and long activities that span multiple periods will not be split over periods
3. This report is not produced by Views without massive amounts of irreverent detail
4. This report is not produced by Reports

Does any one have a technique for simply creating this type of report?

Regards
Paul E Harris

Top

Replies