Resource Name in Gantt Chart

[Steve]

In the Gantt Chart the Resource Name show normal as "name1[45%],name2[55%]".
Is there a way to create it to show as "name1[15hrs], name2[20hrs].

To show the hours rather than % of time. If it can't be done directly, is
there a way to use the custom fields to show it using the Gantt Chart view?

 

[Rod Gill]

Hi,

You can insert the Work column, but that would show total work for all
resources on the task. Alternatively use the Task Usage View.

 

[Jan De Messemaeker]

Hi,

Yes you could create a formula in a text field and show that one; see
Format, Bar Styles.
HTH


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

In the Gantt Chart the Resource Name show normal as "name1[45%],name2[55%]".
Is there a way to create it to show as "name1[15hrs], name2[20hrs].

To show the hours rather than % of time. If it can't be done directly, is
there a way to use the custom fields to show it using the Gantt Chart

view?

 

[Steve]

I understand the process, but as to building a formula that pull the each
resource hours I'm lost. In the Gantt Chart when I open the custom Text and
try to make a formula, I don't see field names that are appropriate. Maybe I
don't know enough about formulas. Can you give me a suggestion.

Steve

Hi,

Yes you could create a formula in a text field and show that one; see
Format, Bar Styles.
HTH


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

In the Gantt Chart the Resource Name show normal as "name1[45%],name2[55%]".
Is there a way to create it to show as "name1[15hrs], name2[20hrs].

To show the hours rather than % of time. If it can't be done directly, is
there a way to use the custom fields to show it using the Gantt Chart

view?

 

[Jan De Messemaeker]

OOOOOPS...
You're right, you don't have access to work by resource (or to be precise,
by assignment) in the formulae

You could run a VBA procedure to create the field:

Sub ResWork
dim Job as task
Dim asg as assignment
dim txt as string
For each job in activeproject.tasks
if not job is nothing then
txt=""
for each asg in job.assignments
if len(txt)>0 then
txt=txt & ", "
end if
txt=txt & asg.resourcename & "["
txt=txt & cstr(asg.work/60) & " h]"
next asg
job.text1=txt
end if 'nothing
next job
end sub

I hope you know how to put this to work - if not ask again - I am about to
leave on holiday so I can't help you further..

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

I understand the process, but as to building a formula that pull the each
resource hours I'm lost. In the Gantt Chart when I open the custom Text and
try to make a formula, I don't see field names that are appropriate. Maybe I
don't know enough about formulas. Can you give me a suggestion.

Steve

Hi,

Yes you could create a formula in a text field and show that one; see
Format, Bar Styles.
HTH


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

In the Gantt Chart the Resource Name show normal as "name1[45%],name2[55%]".
Is there a way to create it to show as "name1[15hrs], name2[20hrs].

To show the hours rather than % of time. If it can't be done directly, is
there a way to use the custom fields to show it using the Gantt Chart

view?

 

[Steve]

Thank you, this is exactly what I was trying to do. Steve

OOOOOPS...
You're right, you don't have access to work by resource (or to be precise,
by assignment) in the formulae

You could run a VBA procedure to create the field:

Sub ResWork
dim Job as task
Dim asg as assignment
dim txt as string
For each job in activeproject.tasks
if not job is nothing then
txt=""
for each asg in job.assignments
if len(txt)>0 then
txt=txt & ", "
end if
txt=txt & asg.resourcename & "["
txt=txt & cstr(asg.work/60) & " h]"
next asg
job.text1=txt
end if 'nothing
next job
end sub

I hope you know how to put this to work - if not ask again - I am about to
leave on holiday so I can't help you further..

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

I understand the process, but as to building a formula that pull the each
resource hours I'm lost. In the Gantt Chart when I open the custom Text and
try to make a formula, I don't see field names that are appropriate. Maybe I
don't know enough about formulas. Can you give me a suggestion.

Steve

Hi,

Yes you could create a formula in a text field and show that one; see
Format, Bar Styles.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Steve" <[email protected]> schreef in bericht
In the Gantt Chart the Resource Name show normal as
"name1[45%],name2[55%]".
Is there a way to create it to show as "name1[15hrs], name2[20hrs].

To show the hours rather than % of time. If it can't be done directly, is
there a way to use the custom fields to show it using the Gantt Chart
view?