Trying to get scheduled hours for a particular time period

[KT]

Hello everyone!! I am hoping someone can help me answer this question.

I have a resource pool which is linked to several projects. When I look at
the resource usage, under the work column, I have total number of hours
scheduled for each resources. That hours may be laid for a period of time
such as three month, one year or two years. I was wondering whether will I be
able to find the scheduled hours for a given time period, say from May 10,
2005 to February 11, 2006. Like I need to have two columns, one start date
and the other as end date. When I enter the start and end date I want the
number of scheduled hours during that period. I am not sure whether this can
be done or let me know if I am expecting more that what I should. I also
welcome any other method to achieve this. Any help really appreciated.

KT

 

[Pratta]

Hi KT
I would suggest you open the master project and go to the Resource Usage
view and insert a column for project .
If you haven't got a master project, open all the projects you have linked
to the resource pool by selecting Window/New Window. You can then save the
new file created as your master when you close.
If all the projects are open then the LHS of the Res Usage view will show
the project name. If not open the path shows. Then go to the RHS double click
in the heading area and set the major scale to Years and the minor scale to
weeks.
Select the weeks you are interested in.
I think this will have the info you are after.
You can also see this type of view from a task perspective in the Task Usage
view.

Regards.............Pratta

 

[John]

Hello everyone!! I am hoping someone can help me answer this question.

I have a resource pool which is linked to several projects. When I look at
the resource usage, under the work column, I have total number of hours
scheduled for each resources. That hours may be laid for a period of time
such as three month, one year or two years. I was wondering whether will I be
able to find the scheduled hours for a given time period, say from May 10,
2005 to February 11, 2006. Like I need to have two columns, one start date
and the other as end date. When I enter the start and end date I want the
number of scheduled hours during that period. I am not sure whether this can
be done or let me know if I am expecting more that what I should. I also
welcome any other method to achieve this. Any help really appreciated.

KT

KT,
Yes this can be done and it can be done a couple different ways. The
easiest way is to set the timescale for the Resource Usage view so it
has the resolution necessary to bound the date range. For example, if
you want to see 5/10/05 through 2/11/06, set the major scale to years
and the minor scale to days (since the dates are mid month). Then
display Cumulative Work in the timescaled data. By taking the difference
between the value shown for 5/10/05 and 2/11/06 you will have the total
Work hours in that timespan.

You could also try using the "analyze timescaled data in Excel" utility
found on the Analysis toolbar. With it you can specify a range of data
to export and once it is in Excel, it will be much easier to sum up.

A more sophisticated approach is possible but does require an advanced
feature of Project. A fairly simple VBA macro can be written using the
TimeScaleData Method to capture the desired date range of data and put
it in a spare Text field. This approach is obviously the most flexible
and provides exactly what you want but does require a little VBA
programming.

Hope this helps.
John
Project MVP

 

[KT]

Hi John and Pratta,

Thanks for your suggestion. I tried the option you gave me: changing the
Major scale and Minor scale. Here I didn't really understand your guidelines
that 'taking the difference between the two values’. I was wondering whether
is that I have to do manually or is there any kind of filter available to do
this?

I am quite interested in trying the simple VBA code which John mentioned.

John, can you please let me know where I can find that code online, or is
there any discussion group that discusses about that. Please suggest.

Thanks again for you replies.

 

[John]

Hi John and Pratta,

Thanks for your suggestion. I tried the option you gave me: changing the
Major scale and Minor scale. Here I didn't really understand your guidelines
that 'taking the difference between the two values’. I was wondering whether
is that I have to do manually or is there any kind of filter available to do
this?

I am quite interested in trying the simple VBA code which John mentioned.

John, can you please let me know where I can find that code online, or is
there any discussion group that discusses about that. Please suggest.

Thanks again for you replies.

KT,
With regard to taking the difference you will have to do that manually.
Unfortunately there is no filter or "spreadsheet" formula that can be
used to get the sum automatically. It may be possible with a clever
custom formula but as far as I am concerned, VBA is a whole lot easier.

Whether the VBA code to do what I suggested is available on-line or not
is a question I cannot answer. There is so much stuff on the web (i.e.
"the truth is out there" - Mulder). However, I tell ya what I'm a gonna
do. Unless someone else "steps up to the plate", I'll write the code for
you but it will be a few days. Right now I have other priorities. If you
want me to write it, contact me direct.

John
Project MVP