Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export resource usage data

Status
Not open for further replies.

antenna

Technical User
Feb 10, 2005
1
CA
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?
 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top