Show total percentage of project assigned to a resource

[Rob]

Hello All,

I have a question dealing with percentages for resources. Is there any way
on the resource usage and/or task usage to show the following:

1. What part of the project is assigned to the resource in percentage and
total numberof days/weeks/months etc.

2. What percentage of the the project does a specific task include. For
example if the project is ten days and a specific task is five days then that
task is fifty percent of the total projects' duration.

I am sure that there are fields that show this information in both the
resource usage and task usage but I can't find them. Any help would be
greatly appreciated.

Regards,

Rob

 

[Rod Gill]

This information doesn't exist. You need to write VBA code whenever you need
to compare the values for any one task or resource with any other or the
total for a project.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Rob]

I write VBA code for Excel and I also design VB applications. I have never
written any macros or code for Project. Can subroutines in Project be
designed to create views and place custom information in these views?

 

[John]

Hello All,

I have a question dealing with percentages for resources. Is there any way
on the resource usage and/or task usage to show the following:

1. What part of the project is assigned to the resource in percentage and
total numberof days/weeks/months etc.

2. What percentage of the the project does a specific task include. For
example if the project is ten days and a specific task is five days then that
task is fifty percent of the total projects' duration.

I am sure that there are fields that show this information in both the
resource usage and task usage but I can't find them. Any help would be
greatly appreciated.

Regards,

Rob

Rob,
I saw your post on the main newsgroup. Since it was directed to Julie,
she will probably respond. I'm not sure why you also posted it here.
I'll make a reference in that post to my answer here.

The basic answer to both questions is, "no".

On your first question, resource assignments are task specific and there
is no field that relates a resource's assignment to the project as a
whole. Such a relationship could be created using VBA but you also asked
about that data in the Usage views and creating custom timescaled data
requires a user defined algorithm for spreading that data over time - it
may or may not be linear.

On your second question, I'm guessing a good 90% of project plans have
task durations that overlap, therefore trying to create the percentage
you want doesn't make much sense. However in the rare case where a
project's task durations are all sequential and there is no concurrency,
the percentage duration of any given task to the whole project duration
could be created using VBA. Timescaling this data doesn't make sense.

Hope this helps.
John
Project MVP

 

[Rob]

Hi John,

Thank you for the answer. I had originally posted the question to Julie.
However, I have had too many experiences in the past where I do not get an
answer so I also post the question in the main forum. I know that this is
not the preferred way to post a question, but sometimes you have to find an
answer any way you can. I do have a follow-up to my original question. I do
a lot of vba and vb programming. What view would you recommend that I
download to Excel to create a spreadsheet that I can manipulate with some
macros to get the percentages that I am looking for?

Thanks again,

Rob

 

[Rod Gill]

VBA can do anything you can do manually in Project (and no more). If you
want a fast start to learning Project VBA, then my book is definitely the
way to go!

Whilst Excel VBA is based around Ranges of cells, Project's Objects are
based on Projects, Tasks, Resources and Assignments.
--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Jan De Messemaeker]

Hi,

First of all, I'm a bit surprised at your interpretation of how these
newsgroups work.
You posted your first question twice. OK, you may not hve understood that
it's mostly the same people looking at both groups, and that you create
double work, but that you double-post again now is a bit surprising. Plese
don't cross-post.
The general NG is for well, yes, general questions, this one is about
developping so your VBA question is to the point here.
Furthermore, the strength af this NGs is that so many volunteers pick up a
question and reply so you are not dependent of the presence of one or the
other, and sometimes having different insights in a problem can help you
more.
So one doesn't "post to Julie" (with all due respect, Julie IS the absolute
champion in both quantity and quality of replies!), just post to the
apprpriate NG and you will get an answer, sometimes more than one.

For instance, no need to go to Excel here.
Half of the work could be done by a formula but since you would do some VBA
by all means, this is a VBA solution to your original question:

(First a remark: in Project you do not do VBA on a view but on the objects
directly)

Sub Dontcrosspost()
dim Job as task
dim Total as single
total=0
for each job in activeproject.tasks
'First calculate the sum of durations
if not job is nothing then
if not job.summary then
total=total+job.duration
end if
end if
next job
'now for the percentages
for ech job in activeproject.tasks
if not job is nothing then
job.number1=100*job.duration/total
end if
next job
end sub

By now you will have understood how to show the percentages dont you?
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jan De Messemaeker]

Hi,

See a typical example in my other post today
There are also interesting examples in fellow MVP Jack Dahlgren's site
http://www.masamiki.com

As I said in the other post, don't think view, cell... think Project's
objects (tasks, assignments, resources... ) and their properties.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[John]

Hi John,

Thank you for the answer. I had originally posted the question to Julie.
However, I have had too many experiences in the past where I do not get an
answer so I also post the question in the main forum. I know that this is
not the preferred way to post a question, but sometimes you have to find an
answer any way you can. I do have a follow-up to my original question. I do
a lot of vba and vb programming. What view would you recommend that I
download to Excel to create a spreadsheet that I can manipulate with some
macros to get the percentages that I am looking for?

Thanks again,

Rob

Rob,
It looks like you got a plethora of responses including a somewhat stern
scolding from Jan about cross-posting. Let me temper that just a bit.
The Project newsgroup is blessed with several knowledgeable and
experienced people who respond - some are MVPs, others are not. The
point is that someone DOES read every post. If it is a simple question,
it will get answered quickly. If it requires some research or more in
depth analysis, then a response might take a day or two. Very few
questions, (those that are poorly written or off subject), go totally
unanswered.

John
Project MVP