export resource usage data

[antenna]

I am trying to create an file, preferably excel pivot table, which would look like the resource usage view. It would contain a list of resources from a defined group and list the WBS codes and task names they are assigned to and then give a week by week breakdown of the remaining work (or % assigned) for each task. Even better would be if I could specify the period of time (a 8 week window say).

Does anyone know how I might do this?

 

[PDQBach]

I've never played with pivot tables so take this as a suggestion on possible approaches.

dim res as resource
dim asgn as assignment

for each res in activeproject.resources
for i = 1 to res.assignments.count
tskid = res.assignments(i).taskid

' Now you have the resource data and the task data for one assignment

next i
next

It's been a long time simce I played with TimePhaseData but you've got a start now.


If you're going to do this often, then create some vba. If you're going to do this occasionally, copy&paste has worked well enough for me for years.