Task Usage View - Totals for Percent Allocation

[RJC]

Is there a way to get column totals in Task Usage View when the Detail Style
contains Percent Allocation? It looks like totals are presented when the
Detail Style contians Work, but not for Percent Allocation.

 

[John]

Is there a way to get column totals in Task Usage View when the Detail Style
contains Percent Allocation? It looks like totals are presented when the
Detail Style contians Work, but not for Percent Allocation.

RJC,
So what would the percent allocation be at the summary level? Would it
be the sum total of assignment percent allocations? No, that doesn't
work. How about an average of assignment percent allocations? No, that
doesn't work.

Gee, I'm not sure what that summary value would be and Project isn't
either. That's why there are no summary line values for percent
allocation.

John
Project MVP

 

[RJC]

In my organization we bill out based on the percentage of a set montly amount
for a full time equivalent (FTE) that project members spends on a project
for a given month, rather than billing at an hourly rate. I'm using the task
usage view to summarize the people slotted to work on a task on a month by
month basis. By summing up the percent allocations the client can see the
number of FTEs they would have working for them for each month.

Example
July Aug Sept
Task 1 (total) 60% 100% 140%
Resource 1 20% 20% 60%
Resource 2 40% 80% 80%

I'm trying to use the percent allocation for to get to this total FTE number.

 

[Jonathan Sofer]

You can get this total in a Data Analysis (OLAP) view by creating and FTE
calculated field, and will allow you to display a sum field as well. If you
are using MSPS 2007 then you can get down to the task level information, but
not in MSPS 2003.

Jonathan

 

[John]

In my organization we bill out based on the percentage of a set montly amount
for a full time equivalent (FTE) that project members spends on a project
for a given month, rather than billing at an hourly rate. I'm using the task
usage view to summarize the people slotted to work on a task on a month by
month basis. By summing up the percent allocations the client can see the
number of FTEs they would have working for them for each month.

Example
July Aug Sept
Task 1 (total) 60% 100% 140%
Resource 1 20% 20% 60%
Resource 2 40% 80% 80%

I'm trying to use the percent allocation for to get to this total FTE number.

RJC,
As originally written your post didn't make a whole lot of sense - hence
my reply. Now that you have more thoroughly explained what you want to
do, things make more sense.

If you are using Project in a Project Server environment, then
Jonathan's suggestion will probably work (I don't know, I don't do
Server). However if you are not using Project Server, then your options
are more limited. With a stand alone installation of Project, there is
no way to create a percent allocation sum in either Usage view. The best
you can do is to export the data to Excel and then do the math there.

Depending on which version of Project you are using, exporting
timescaled data can be done in different ways. For pre-Project 2007, you
can try the "analyze timescaled data in Excel" utility. Project 2007
added a feature called Visual Reports that creates a pivot table in
Excel. Of course with any version of Project, VBA can be used to export
any Project data.

Hope this helps.
John
Project MVP

 

[RJC]

I am using MSPS 2003. I tried the "analyze timescaled data in Excel"
utility that John suggested. It got me pretty close to what I wanted. I'll
continue to experiment using that technique. My organization will be
upgrading to MSPS 2007 sometime next year, so I'll take a look at the other
suggestions that are dependent upon that release sometime in the future.

Thanks for the helpful suggestions.

 

[John]

I am using MSPS 2003. I tried the "analyze timescaled data in Excel"
utility that John suggested. It got me pretty close to what I wanted. I'll
continue to experiment using that technique. My organization will be
upgrading to MSPS 2007 sometime next year, so I'll take a look at the other
suggestions that are dependent upon that release sometime in the future.

Thanks for the helpful suggestions.

RJC,
You're welcome and thanks for the feedback.
John