Sunday, March 21, 2010 12:45 PM
I am trying to track Project Costs for a client 'after the fact' so to speak. The project has ended, and the client wishes to determine what their actual Costs for their Staff were. Over the course of the project which lasted from 2006 to 2008, the client hired some specialists for specific periods of time to work on various tasks.
So there are specific dates where these Staff members would be present as Resources, and others where they would not.
Sometimes this happens in the middle of a Task, and some of these tasks can be lengthy.
i.e. if Mark is assigned to the Task Develop Space Standards, and this task takes 5 months from 1st January to 1st of June. Mark comes into the Project on the 1st of February, and leaves on the 1st of May.
I want to track Mark's Cost on the project for that particular phase for the 1st of February to the 1st of May.
On the 1st of May Jane entered the project, at a different Salary Rate. So I would need to track her from the 1st of May to the end of the project.
I know that there is Working Time, and Non Working time in the Resource Calendars. But I'm not sure that's the right way to go about it.
I can Assign both Mark and Jane as Resources for that task, and then add massive blocks of Exceptions between specific Dates.
For Mark that would be from the start of the project 1st January to when his contract started on the 1st of February . Then another massive exception from the 1st of May when his contract ended to 1st of Jan 2023 (past the end of the project)?
I thought there must be an elegant way to setup Temporary Resources for Staff, or to represent people on fixed length contracts, say three months or four months.
How would I do this quickly and easily? Is setting these massive Exception Periods really the best way to represent these 'Temporary' resources?
Sunday, March 21, 2010 12:57 PM
Sorry, you put this question into the wrong forum. This is for Project 2010 questions. Go to this link for Project 2007 or 2003 questions.
However, a quick answer to your question is to setup up or use an Excel OLAP cube. There are several that can be found in Reports menu. The cube allows you to filter by Project, Resource and other dimensions, and you can agregate by Resource and Time period.
Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
Sunday, March 21, 2010 1:12 PM
Those forums aren't as nice as these though! :-)