# I would appreciate your help

• ### Question

• Good evening.

I would
appreciate your help with the following two problems :

1) For a resource that is set as a material, I want to show / calculate the usage rate (%) at each task where it is used. Exactly as it is shown the percentage of the resources which is set as work. To understand what I mean, a member of a workgroup works
50% of his time and he uses a computer at 50% of its time. I was asked to appear in Gannt Chart the usage rate (%) for the computer. Also I have to export a table where the percentage use of the material resource (computer) must be shown for each task.

2) A task duration is set to 100 days. I use the A and B member of a workgroup to 100% of their time (work = 200 days). I add one more member of a workgroup (C) who is working 100% of his time for the same task, but only 50 out of 100 days. The total work converted correctly (work = 150 days), but the percentage shown in column Resource Name, and in Gannt Chart Bars reflects the percentage corresponding to the duration of 50 days (100%). I have to show the percentage corresponding to the duration of 100 days (50).

Is there any solutions for the above problems ?

Nora

P.S. I am sorry about my English. it's difficult for me to express myself in English :)

Saturday, September 3, 2011 9:08 PM

• Hi,

1) A computer is a work type resource, not a material. Materials are consumed, computers are not. Once it's a computer, the % usage is easy to see.

2) For the resource working 50 out of 100 days, units must be 50%. I know they may be workiung 100% for half the days, but you need to average this for Proejct. Project doesn't care if teh resource works 100% for half the days, 50% for all days or.....

Rod Gill

The one and only Project VBA Book Rod Gill Project Management
Saturday, September 3, 2011 9:53 PM

### All replies

• Hi,

1) A computer is a work type resource, not a material. Materials are consumed, computers are not. Once it's a computer, the % usage is easy to see.

2) For the resource working 50 out of 100 days, units must be 50%. I know they may be workiung 100% for half the days, but you need to average this for Proejct. Project doesn't care if teh resource works 100% for half the days, 50% for all days or.....

Rod Gill

The one and only Project VBA Book Rod Gill Project Management
Saturday, September 3, 2011 9:53 PM
• Hi Rod,

1) If I set computer as work type resource then I have another problem.

I have to show a field in Gantt Chart View, that calculates the total human work days for each task. For example. For the task “Task1” (duration 10 working days) works George (100%) and Lina (50%). The field “Total human days spent” will set to 15 days (work), which is right. If I assign to the task the computers which are used, then the field “Total human days spent” will set to 30 days, that is not right. Is there a way to calculate only the human work?

2) I am trying to find a way that I could use the C member of the workgroup full time for the 50 days that his is free from other tasks, so i contoured the work. Is there a way to calculate the percentage corresponding to the total duration of the task (100 days) using a formula ?

Thanks again

Nora

Sunday, September 4, 2011 8:18 AM